RE: Double Quotes in Database

DON'T use HTMLEditFormat() to insert in the database! Just store the quotes as is in the database. Use HTMLEditFormat() for display. This way you will not have the double encoding and you can even use the data in non HTML. If you insist on using html code in the db, you could use a UDF to

asp 2 cfm help pleazzzzzzzzzzzz

working on converting this page here is the asp code, mostly interested in the paging part <%@ Language=VBScript %> <% Response.Buffer=True %> <% Dim GuestBookName dim GuestbookUrl Dim MailBox Dim Password1 Dim AllowUbbcode Dim ConnectionString Dim PageSize Dim AdminLogFlag IF Session("AdminLogge

Variable Session scopes

What is the best way of creating variable session scopes called from a global vars page without CF chucking errors.. global vars page request.sessionVar = "mySite"; // This changes across the mini sites request.dbsitePrefix = "test"; Application.cfm Page - and yes sessionmanagement is on

Re: Variable Session scopes

Carl V wrote: >What is the best way of creating variable session scopes called from a global vars >page without CF chucking errors.. > >global vars page > > request.sessionVar = "mySite"; // This changes across the mini sites > request.dbsitePrefix = "test"; > > >Application.cfm Page - and yes se

Web Services problem

I'm learning about using Web Services and I'm getting an error that doesn't make sense. Maybe someone could shed some light on the problem? I'm using a CFC to simply retrieve some zip codes from a db. SELECT zipcode FROM tblzipcodes

Re: asp 2 cfm help pleazzzzzzzzzzzz

anyone see anything diff that needs to be added (its 441am im sure im missing something SELECT * FROM guestbook ORDER BY postdatetime desc #subject# #number# #email# #url# #sex#

Re: Web Services problem

Will Tomlinson wrote: >I'm learning about using Web Services and I'm getting an error that doesn't make >sense. Maybe someone could shed some light on the problem? > >I'm using a CFC to simply retrieve some zip codes from a db. > > > > > > SELE

Dan Switzer

Anyone heard from Dan Switzer lately? ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffu

RE: authorize.net processing

Tim, Nope - you use the password in the old "3.0" implimentation. The x_tran_key is created by you in the merchant terminal. You answer a "secret question" and they use your answer to give you a hash or encrypted string. That string is then used as your x_tran_key. This is the version 3.1 implime

Re: Web Services problem

Will, Change "wtomlinson..com" to "wtomlinson.com" :) -joe On Thu, 28 Oct 2004 06:40:00 -0400, Will Tomlinson <[EMAIL PROTECTED]> wrote: > I'm learning about using Web Services and I'm getting an error that doesn't make > sense. Maybe someone could shed some light on the problem? > > I'm usin

RE: Dan Switzer

Is he Mr. PengoWorks? Man I love those qForms. Macromedia should have bought qForms for embedded Blackstone form validation :-) Sincerely, Andrew -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 6:52 AM To: CF-Talk Subject: Dan Swi

Re: OT: Find out my IP

WOW, cheers for the response, i never knew all that about NTL's proxies. As for the upgrades, i've got mine here (on the south coast) had it for a while now and i gotta say i like it. Though the upload speed is what really needs looking into. Andy On Wed, 27 Oct 2004 20:18:02 +0100, Paul Vernon

Re: Web Services problem

I just tried it and it worked finemaybe a little slow, but it worked. Here is the dump of the returned query: query ZIPCODE 1 00501 2 00544 3 00601 4 00602 5 00603 6 00604 7 00605 8 00606 9 00610 10 00611 11 00612 12

Re: authorize.net processing

thanks Mark >-Original Message- >From: Mark A Kruger [mailto:[EMAIL PROTECTED] >Sent: Thursday, October 28, 2004 12:32 PM >To: 'CF-Talk' >Subject: RE: authorize.net processing > >Tim, > >Nope - you use the password in the old "3.0" implimentation. The x_tran_key >is created by you in th

RE: asp 2 cfm help pleazzzzzzzzzzzz

Have you got any sample data? The "lt" makes me think "less than" symbol, maybe there is something in your data that is causing invalid XML?? Gav -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 28 October 2004 10:11 To: CF-Talk Subject: asp 2 cfm help plea wor

Re: OT: Find out my IP

On Thursday 28 Oct 2004 13:08 pm, Andy Jarrett wrote: > WOW, cheers for the response, i never knew all that about NTL's proxies. When I was on NTL, my box just got a public IP. How are you connected to them ? Set top box ? Stand alone box ? xDSL ? Intergrated wireless gatway nonsense ? Linux gate

cfchart / cfgraph help please

Hello, I am currently trying to generate some bar charts. The server we are running is Version 6,0,0,48097 Professional On using cfchart or cfgraph the page that loads just shows the little place holder as if you were missing a picture (the white square with a red cross) After looking in the

XML faster?

Is it faster to connect to an XML file than to a database? Assuming both store the same amount of data. I know that getting the data in and out is easier with a database, but I wonder if it is faster with XML. XML vs. Access? XML vs. SQL Server? XML vs. MySQL? XML vs. Oracle? Johnny ~

Re: OT: Find out my IP

N nothing that complicated. Just the usual direct wire from the NIC to the NTL box. On Thu, 28 Oct 2004 15:21:48 +0100, Thomas Chiverton <[EMAIL PROTECTED]> wrote: > On Thursday 28 Oct 2004 13:08 pm, Andy Jarrett wrote: > > WOW, cheers for the response, i never knew all that about N

Re: XML faster?

I can't imagine a scenario where file read/writes would be faster than database queries, everything else being equal. - Original Message - From: "Johnny Le" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 9:45 AM Subject: XML faster? > Is it faster

Re: XML faster?

Johnny Le wrote: >Is it faster to connect to an XML file than to a database? Assuming both store the >same amount of data. I know that getting the data in and out is easier with a >database, but I wonder if it is faster with XML. > > It would depend on drivers, whether ODBC was used, etc. On

Re: Variable Session scopes

Do you put this in the application.cfm or somewhere else? Carl >Carl V wrote: > >Its probably worth copying your session variable to a local variable, so >that you don't keep hitting the session and to make it easier to access >your variables. > >request.thisSession = duplicate(session[request

RE: cfchart / cfgraph help please

-Login to your CF Administrator -Click the charting Link. Try these settings: Disk Cache 50 4 C:\CFusionMX\charting\cache This should solve your problem. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4

CFMail Problem

Hi all, I have a couple of clients who manage their own mail servers. I host their websites. In a simple contact form using CFMail, the message being sent to the client works fine. But as best practice, I always generate a confirmation email back to the sender, so they can have a record of what

Html Area 3 issue?

Hi, Any of you guys using the HTML Area 3 wysiwig? I've been using it and have found a really annoying problem that I dont know how to solve. I can duplicate this on 2000 and xp ie 6. To duplicate, open a page with the wysiwig and then keep reloading it with f5. If I do this between 5 and 20 t

Dates in Queries - Again

I don't know why I have so much trouble with this.. OK, I need to get all records with a depart date starting today and for the next 15 days... So, first set the variables... ...and then it seems this should work in the query: WHERE DEPART_DATE >= #TodayDate# and DEPART_DATE <= #FutureDate

SQL Mask not using CF

Hi All I was wondering if someone could help me out with the following SQL function. I would like to select Today(*) from my database but have it display as Thursday, October 28, 2004 This is easily done with a mask in CF but is there a way to do it right in my select statement? Something li

OT: JavaScript Form Behaviour

I have a form that has a series of radio buttons, so that users can choose a timeperiod. If the user picks 'Range', they can then also choose 'one week, two weeks, one month, etc.' to specify the range. What I'm wondering... is whether there is a way I can write something in JavaScript that says

Re: Html Area 3 issue?

DRE wrote: >Any of you guys using the HTML Area 3 wysiwig? I've been using it and >have found a really annoying problem that I dont know how to solve. > > I stopped using HTMLArea when I noticed conflicts between it and some other JS code I use, specifically fValidate. I've since started usin

Re: Dates in Queries - Again

what RDBMS are you using? Look at the BETWEEN op WHERE DEPART_DATE BETWEEN #TodayDate# AND #FutureDate# Also, I'd use cfqueryparam on this WHERE DEPART_DATE BETWEEN AND Actually, I'd use the DB maybe for this tooon Oracle something like this WHERE DEPART_DATE BETWEEN sysdate AND sysda

Re: Web Services problem

The 'wtomlinson..com' is showing up in the error message, not from his code (or at least the code he posted here) I copied his code right from his post into a page and it worked. On Thu, 28 Oct 2004 07:07:49 -0400, Joe Rinehart <[EMAIL PROTECTED]> wrote: > Will, > > Change "wtomlinson..com" to

RE: JavaScript Form Behaviour

> I have a form that has a series of radio buttons, so that > users can choose a timeperiod. If the user picks 'Range', > they can then also choose 'one week, two weeks, one month, > etc.' to specify the range. > > What I'm wondering... is whether there is a way I can write > something in Ja

Re: Html Area 3 issue?

Thanks Damien, It is cute but amazingly enough it seems to have the same issue for me I'm amazed! But both my computers seem to do it for me on and off site!!! DRE On Thu, 28 Oct 2004 11:28:51 -0400, Damien McKenna <[EMAIL PROTECTED]> wrote: > DRE wrote: > > >Any of you guys using the HTM

Re: OT: JavaScript Form Behaviour

Jillian, The answer is yes. In your drop down have an onChange event, that calls a function that checks the value selected and then does a document.formName.formFieldFame.selected = true based on that value. This should work. HTH G On Thu, 28 Oct 2004 09:28:29 -0600, Jillian Koskie <[EMAIL PR

Re: SQL Mask not using CF

http://www.rocket99.com/sybase/sybase22.html see: Transact SQL: date/time formats Use the convert function to format the date into the style of your choice. On Thu, 28 Oct 2004 11:27:36 -0400, Mickael <[EMAIL PROTECTED]> wrote: > Hi All > > I was wondering if someone could help me out with the

Re: JavaScript Form Behaviour

1 2 3 a b c On Thu, 28 Oct 2004 11:48:51 -0400, Tangorre, Michael <[EMAIL PROTECTED]> wrote: > > I have a form that has a series of radio buttons, so that > > users can choose a timeperiod. If the user picks 'Range', > > they can then also choose 'one week, two wee

Re: Dates in Queries - Again

> WHERE DEPART_DATE BETWEEN #TodayDate# AND #FutureDate# At least the dates are correct. Hmmm... Database is mySQL 76 : WHERE DEPART_DATE BETWEEN #TodayDate# AND #FutureDate# Syntax error or access violation: You have an error in your SQL syntax near 'WHERE DEPART_DATE BETWEEN '2004-10-28' AND

Re: Web Services problem

Scott Stroz wrote: >The 'wtomlinson..com' is showing up in the error message, not from his >code (or at least the code he posted here) > >I copied his code right from his post into a page and it worked. > > Yep - so he's got a typo in his code on that remote server that has been introduced afte

OT - hosting?

I know, its a dead horse but I've been out of the loop for a while. I did do a search but didnt find much. Does cfdynamics still have the favorable reputation that it used to? If not, any suggestions. MX sql2000 medium traffic site. Thanks. DRE -- DRE www.webmachineinc.com www.theanticool.co

Re: OT - hosting?

I've had nothing but good experiences with them, for what it counts. ~Simon > > I know, its a dead horse but I've been out of the loop for a while. I > did do a search but didnt find much. > > Does cfdynamics still have the favorable reputation that it used to? > If not, any suggestions. MX

Re: OT - hosting?

crystaltech generally seems to be one of the more recommended as having a favorable reputation these days. http://www.crystaltech.com On Thu, 28 Oct 2004 08:57:57 -0700, DRE <[EMAIL PROTECTED]> wrote: > I know, its a dead horse but I've been out of the loop for a while. I > did do a search but

Re: OT - hosting?

www.CrystalTech.com HTH, Donna On Thu, 28 Oct 2004 08:57:57 -0700, DRE <[EMAIL PROTECTED]> wrote: > I know, its a dead horse but I've been out of the loop for a while. I > did do a search but didnt find much. > > Does cfdynamics still have the favorable reputation that it used to? > If not, an

Re: OT - hosting?

[EMAIL PROTECTED] wrote: > I've had nothing but good experiences with them, for what it counts. me too. i can't remember the last time i had a technical problem with cfdynamics. ~| The annual ColdFusion User Conference is being

RE: cfchart / cfgraph help please

> I am currently trying to generate some bar charts. > The server we are running is > Version 6,0,0,48097 Professional In addition to Ryan's suggestions, you might want to consider upgrading to CFMX 6.1. That's a free upgrade. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202

RE: JavaScript Form Behaviour

Worked like a charm --thanks everybody!! -- Jillian -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: October 28, 2004 9:52 AM To: CF-Talk Subject: Re: JavaScript Form Behaviour 1 2 3 a b c On Thu, 28 Oct 2004 11:48:51 -0400, Tang

RE: XML faster?

Imagine do u have application where the user can built his own report visually (ie: one form with differents fields of the table in database and u want to built the report output, Employees from the sales department where the amount of their sales is greather than 30 000 dls )...the imagine u can

Re: OT - hosting?

Excellent! Thanks for the feedback! DRE On Thu, 28 Oct 2004 23:13:53 +0700, Paul Hastings <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > I've had nothing but good experiences with them, for what it counts. > > me too. i can't remember the last time i had a technical problem with > cf

RE: OT - hosting?

+1 for me as well. With one small caveat; just make sure one knows that database back-ups by CFdynamics are only available for 3-7 days. Found this out when we learned that a programming snafu on my part cleared an important table, seven days after it happened. We lost the data. On that no

spell checker

Can anybody point me to a client side spell checker that uses the microsoft data file or whatever it is that MS Word uses? Thanks, Tim ~| Protect your mail server with built in anti-virus protection. It's not only good

RE: Dates in Queries - Again

I'm not sure exactly what that code would do, but it's cleaner (and probably works better) to use DateAdd() to add days to an existing date. Since your date field is a varText you can't directly compare it to a ODBC date (I assume mysql would implicitly cast the date to a string). It might work

Re: Dates in Queries - Again

Does mySQL allow casting? in Oracle I've had to use the to_date() function to cast a char field to date. On Thu, 28 Oct 2004 11:42:56 -0400, Les Mizzell <[EMAIL PROTECTED]> wrote: > > WHERE DEPART_DATE BETWEEN #TodayDate# AND #FutureDate# > > At least the dates are correct. Hmmm... Database is

OT: dummy frame?

One of our outside consultants has created a site for us that they're using frames to hide the real location of. Besides the fact that this won't work well for our purposes, their frameset included the link to the actual site and one for a dummy page, e.g.: Our Company's Site http://www.c

RE: XML faster?

XML will always be slower than a good database, particularly for large volumes of data. Consider a scenario where you have 1000 records that are about 500 bytes each. If it's in a database, it's already in a read-optimized format that can be quickly queried and send back only the needed results. W

RE: OT: Find out my IP

I know this is getting way OT from CF so this is my last post on this but it does illustrate the point... > When I was on NTL, my box just got a public IP. It's unlikely that you ever got a truly public IP using NTL cable however I would have to say depending on the region you lived in it would

OT: editors, back to HomeSite+ for me

Well, after spending ages between last night and this morning doing my bi-annual editor search, I went back to Homesite+ and am going to stick with it. The 5.5 version seems to do what I need in terms of code insight and syntax highlighting, and its less resource intensive than Dreamweaver by

Re: OT - hosting?

Thanks Ian, I would be interested in this as well. DRE On Thu, 28 Oct 2004 09:29:44 -0700, Ian Skinner <[EMAIL PROTECTED]> wrote: > +1 for me as well. > > With one small caveat; just make sure one knows that database back-ups by CFdynamics > are only available for 3-7 days. Found this out when

request scope question

Been away too long... What does the following block of code assign to the "request.queryName" variable?? SELECT column1, column2 FROM table Can i now access "request.queryName.column1" ? TIA, Brian ~| Protect your mail s

Re: request scope question

It assigns the recordset as a whole. request.queryName.column1 should return the value of column1 in the first row of the recordset. cheers, barneyb On Thu, 28 Oct 2004 12:02:04 -0500, G <[EMAIL PROTECTED]> wrote: > Been away too long... > > What does the following block of code assign to the "

Re: Dates in Queries - Again

Lee, IF you are using Version 4.1.1 or higher, you can use the STR_TO_DATE() function. WHERE STR_TO_DATE(DEPART_DATE, '%c/%e/%Y') You will need to consult the MySQL documentation for more info on the date formatting options. http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html abou

RE: dummy frame?

> Why would they bother with the dummy frame, why would it be needed? It's a handy way to keep JavaScript persistent. I don't know if that's why they're doing it, though. > And is it a common practice in the JSP world to put spaces as > the first character of every attribute value (see above)?

Re: Dates in Queries - Again

ooopsies! I missed the part about ur field being varText. Yeah, that's going to be fun. ;) Looks like you can use the STING_TO_DATE() function maybe? Doug On Thu, 28 Oct 2004 11:40:29 -0400, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > what RDBMS are you using? > Look at the BETWEEN op > >

Re: OT: editors, back to HomeSite+ for me

Did you look at cfeclipse? Spike Damien McKenna wrote: > Well, after spending ages between last night and this morning doing my > bi-annual editor search, I went back to Homesite+ and am going to stick > with it. The 5.5 version seems to do what I need in terms of code > insight and syntax hi

Re: CFMail Problem

Yeah, that most definitely sounds like a relaying issue. Have your client add your server address(es) to their relay-allow list(s). Most (though it should be all) mail servers will not allow a foreign IP to send email to domains that the server does not host. -Ryan On Thu, 28 Oct 2004 11:20:49

cfqueryparam strangeness

223073026 that value should validate in this right... (CMFX 6.1 WIN2KSERVER) thanks. -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com ~~~

SP to find all triggers in a database?

Howdy - I've inherited the database (SQL Server 2000) from &^&*^*, and it has about a zillion tables in it. I need to make some changes to the app that goes with it, but want to find out if there are any triggers out there that are going to do things behind my back. Is there an easy way to do t

RE: cfqueryparam strangeness

> 223073026 > that value should validate in this right... (CMFX 6.1 WIN2KSERVER) > Trim(ipAddressNumber) ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http

Re: SP to find all triggers in a database?

This will get you all of the Triggers in teh DB: select * from sysobjects where xtype = 'TR' You may want to expand the query to get more descriptive information for the 'parent' On Thu, 28 Oct 2004 13:42:41 -0400, powell @ nauticom. net powell @ nauticom. net <[EMAIL PROTECTED]> wrote: > Howdy

Re: SP to find all triggers in a database?

This should tell you if you have any: SELECT * FROM sysobjects WHERE (xtype = 'tr') Rey - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 28, 2004 1:42 PM Subject: SP to find all triggers in a database? > Howd

Re: cfqueryparam strangeness

nope. On Thu, 28 Oct 2004 13:49:14 -0400, Tangorre, Michael <[EMAIL PROTECTED]> wrote: > > 223073026 > > that value should validate in this right... (CMFX 6.1 WIN2KSERVER) > > > > Trim(ipAddressNumber) > > ~| Purchase from H

RE: cfqueryparam strangeness

> 223073026 > that value should validate in this right... (CMFX 6.1 WIN2KSERVER) > Also, make sure you that your DB Column is INT and not BIGINT or TINYINT. Or, if it is.. Use the corresponding CF SQL type Mike ~| Purchase from

Re: Survey Creation Application

Do you can show that survey tool? Maybe a link? Cheers Marco On Wed, 27 Oct 2004 18:37:51 -0400, Nick Cabell <[EMAIL PROTECTED]> wrote: > I built a survey creation system for a non-profit using CF. It is fairly customized > and has been very difficult. It allows a variety of clients to create

Re: XML faster?

>Consider a scenario where you have 1000 records that are about 500 bytes >each. If it's in a database, it's already in a read-optimized format >that can be quickly queried and send back only the needed results. With >XML, you'd first need to read the WHOLE file (500k+, with tags) from >disk, run t

Re: cfqueryparam strangeness

the datatype in the MSSQL DB is BIGINT here is my code... select * from thisTable v inner join thatTable c on c.companyIdNumber = v.companyIdNumber where v.ipAddressNumber = ERROR in CFMX 6.1 (BUT NOT IN BST**) ANY IDEAS WHY? WHY? -- tony Tony Weeg

OT- SQL copy over

I have two SQL servers (DEV and LIVE) Whenever I need to change something in SQL I do first on DEV then I got the approval from client and then I copy over all the tables from one to another. Is there any easiest way that I can run the query which radomaly take all the table from DEV and COPY O

Re: OT- SQL copy over

EXACTLY and RANDOMLY? hmmm.. i would say you could do a backup and restore DTS package, maybe? tw On Thu, 28 Oct 2004 14:32:14 -0400, Asim Manzur <[EMAIL PROTECTED]> wrote: > I have two SQL servers (DEV and LIVE) > > Whenever I need to change something in SQL I do first on DEV then I got the

Re: XML faster?

> Use SAX then. Extremely quick. I've used SAX on 20 meg XML files with > awesome results. Yes, SAX is fast, but it requires more work than simply using CF's native capabilities (that use DOM in the background) > Too bad CF doesn't directly support SAX (yet). You can leverage Java for that, I

Re: OT: editors, back to HomeSite+ for me

FWIW, I recently tried He3, and disliked it immensely. I'm still using Homesite 5.5+ =) - Rick ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/b

RE: OT- SQL copy over

Look at DTS (in SQL Server Enterprise Manager) for server-to-server object copying. This can move tables (w/ indexes) and data (if you want it to). The simplest way to invoke it is to right-click on a database and select the All Tasks/Export option. Mark -Original Message- From:

Re: OT- SQL copy over

well I mean to say that. When I do changes on DEV and get approved by the client. Then I have to move back all the table to the LIVE. So its pain everytime to login on the server, launch the enterprise manager and then remove the old tables and wait for import/export and copy over all the data.

synching local database with web

I've been asked if its possible to have this scenario: Sales people entering information into their laptop computer database (ms access file) right after meeting a client - the sales person would not be online at that time. That evening or the next time they're online, is there someway to "sync"

Re: OT- SQL copy over

Oh I actually used the first option all the time which is "Copy tables and views from the source database". I will try this option next time and see how it goes. > Look at DTS (in SQL Server Enterprise Manager) for server-to-server > object copying. This can move tables (w/ indexes) and data

Re: OT- SQL copy over

you could setup a dts package, that does this, and then it would be as easy as a doubleclick to execute the package. tw On Thu, 28 Oct 2004 14:54:05 -0400, Asim Manzur <[EMAIL PROTECTED]> wrote: > well I mean to say that. When I do changes on DEV and get approved by the client. > Then I have to

Re: SP to find all triggers in a database?

Thanks for the postings, taht works great - narrows things down to about a dozen tables that I need to look at. Is there a way to programatically get the actual trigger code for a given trigter? I've followed the various links from sysobjects for the triggers, but none lead to the actual code.

Re: Dates in Queries - Again

> Looks like you can use the > STING_TO_DATE() function maybe? That didn't seem to work either. I'm not 100% sure what version the host is running. So, I added additional fields to the database, created a new query to properly convert the varCHAR dates to real dates, and all seems fine now. Th

Re: OT: editors, back to HomeSite+ for me

What did you dislike about He3? cfeclipse != He3 Spike Rick Root wrote: > FWIW, I recently tried He3, and disliked it immensely. I'm still using > Homesite 5.5+ =) > > - Rick > > > ~| Purchase from House of Fusion, a Ma

Re: Web Services problem

>I just tried it and it worked finemaybe a little slow, but it worked. > >Here is the dump of the returned query: > >query > ZIPCODE >1 00501 >2 00544 >3 00601 >4 00602 >5 00603 >6 00604 >7 00605 >8 00606 >9 00610 >10 00611 >11 00612 >1

RE: synching local database with web

> I've been asked if its possible to have this scenario: > > Sales people entering information into their laptop computer > database (ms access file) right after meeting a client - the > sales person would not be online at that time. > > That evening or the next time they're online, is there >

Re: SP to find all triggers in a database?

If you right-click on a table name, then 'All Tasks', you can 'Manage Triggers' On Thu, 28 Oct 2004 15:09:27 -0400, powell @ nauticom. net powell @ nauticom. net <[EMAIL PROTECTED]> wrote: > Thanks for the postings, taht works great - narrows things down to about a dozen > tables that I need to

RE: OT: editors, back to HomeSite+ for me

Spike, Some of his dislikes were features lacking in the current public beta of He3 (missing browser, non-Windows standard key mappings) and some of them were Eclipse specific things (updater problems and unfamiliar interface). I think that both He3 and cfeclipse could better target the CFStudio/H

Re: OT: editors, back to HomeSite+ for me

Spike wrote: > What did you dislike about He3? > > cfeclipse != He3 I know. To answer your question... #1 - I downloaded the beta, then had to restart He3 something like 5-6 times while it downloaded one new update at a time. That was annoying. #2 - It doesn't have browse capability for HTM

Re: synching local database with web

One thing you may want to look at doing is developing the salesperson app in Macromedia Central. It's made to do "occaisionally connected" apps like this. Cheers, Joe ~| Purchase from House of Fusion, a Macromedia Authorized Af

cfhttp error

My code: http://www.usaepay.com";> The result: The column name "" is invalid. Any ideas? My ultimate goal with this is to write wrappers for custom reports on the usaepay site, so that different departments in my client's company can see only their own data. USAePay makes it easy to see th

RE: cfhttp error

> My code: > url="http://www.usaepay.com";> > > The result: The column name "" is invalid. > > Any ideas? My ultimate goal with this is to write wrappers > for custom reports on the usaepay site, so that different > departments in my client's company can see only their own > data. USAePa

Re: synching local database with web

You could add a flag for transactions that are not uploaded to the server yet. When they add a new transaction, the flag is set. When they connect to the server, run a script that finds the ones with the flag set and upload them, and reset the flag At 03:00 PM 10/28/2004, you wrote: >I've

Re: OT: editors, back to HomeSite+ for me

Thanks Guy, I'm inclined to agree with you. It would probably be good to have a simple way of configuring either He3 or cfelclipse to match the Homesite or DreamWeaver layout and configuration. I shall put it on my (very long) todo list :) Spike Guy Rish wrote: > Spike, > > Some of his dis

Re: OT: editors, back to HomeSite+ for me

Rick Root wrote: > Spike wrote: > > >>What did you dislike about He3? >> >>cfeclipse != He3 > > > I know. To answer your question... > > #1 - I downloaded the beta, then had to restart He3 something like 5-6 > times while it downloaded one new update at a time. That was annoying. > > #2 -

OT: Homesite - disabling Browse feature and Edit/Browse tabs?

Is there any way, in HomeSite+ 5.5, to disable the Browse tab entirely and hide the tabs, just leaving the Edit pane? Given that I never use it its a bit useless for me. Thanks. -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.th

OT: Sql insert from one db to another

I can use an INSERT to copy the data from one table to another like: INSERT empinfoEmployeesTemp (EmployeeNum, FirstName, LastName) (SELECT EmployeeNum, FirstName, LastName FROM empinfoEmployees) But I need to copy the data from different databases (production to dev). How can I specify whi

Re: cfhttp error

Thanks, Dave, that was it. Man, do I feel dumb. Now I have a new problem. *g* Now I'm trying to get one of the pages that requires login, and I'm sending the username and password in the request, but I'm getting the login page instead. Am I missing some other important parameter, or does it

Re: OT: Sql insert from one db to another

Rodger, What database platform are you running on? t On Thu, 28 Oct 2004 14:25:14 -0700, Rodger <[EMAIL PROTECTED]> wrote: > I can use an INSERT to copy the data from one table to another like: > > INSERT empinfoEmployeesTemp (EmployeeNum, FirstName, LastName) > (SELECT EmployeeNum, FirstName

  1   2   >