RE: Whats wrong with this code?

2003-02-28 Thread Kennerly, Rick H CIV
Certainly has not been my experience. Rick -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 February, 2003 16:22 To: CF-Talk Subject: RE: Whats wrong with this code? -- Original Message -- From: Kennerly, Rick H

RE: Whats wrong with this code?

2003-02-27 Thread Bryan F. Hogan
Are all you column data types text ? Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From:

RE: Whats wrong with this code?

2003-02-27 Thread FlashGuy
No. They are all VARCHAR(50) to VARCHAR(255) On Thu, 27 Feb 2003 14:52:50 -0500, Bryan F. Hogan wrote: Are all you column data types text ? Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital

RE: Whats wrong with this code?

2003-02-27 Thread Bryan F. Hogan
of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:55 PM To: CF-Talk Subject: RE: Whats

RE: Whats wrong with this code?

2003-02-27 Thread Kennerly, Rick H CIV
It'd help to know what sql error you're getting. But here's my shot in the dark: Unlike update, input requires that the order of the input be the same as the order the columns are found in the database. If you've let DW/CF MX create your input data, that data will be in the order found on the

Re: Whats wrong with this code?

2003-02-27 Thread Jeff Garza
What is the error you are getting? There are some serious design issues with your DB if everything is a VARCHAR, but aside from that, post the error so we can see where it is failing. Jeff - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent:

Re: Whats wrong with this code?

2003-02-27 Thread Alexander Sherwood
At 01:09 PM 2/27/2003 -0700, you wrote: What is the error you are getting? There are some serious design issues with your DB if everything is a VARCHAR, LONG LIVE VARCHAR! ~| Archives:

RE: Whats wrong with this code?

2003-02-27 Thread FlashGuy
-Original Message- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:55 PM To: CF-Talk Subject: RE: Whats wrong with this code? No. They are all VARCHAR(50) to VARCHAR(255) On Thu, 27 Feb 2003 14:52:50 -0500, Bryan F. Hogan wrote: Are all you

RE: Whats wrong with this code?

2003-02-27 Thread Scott Brady
-- Original Message -- From: Kennerly, Rick H CIV [EMAIL PROTECTED] Unlike update, input requires that the order of the input be the same as the order the columns are found in the database. Ummm . . . not really. The ordering issues with SQL's INSERT

RE: Whats wrong with this code?

2003-02-27 Thread Bryan F. Hogan
] Sent: Thursday, February 27, 2003 3:20 PM To: CF-Talk Subject: RE: Whats wrong with this code? Yes! That was it. I changed the field names and it workds great. Thanks On Thu, 27 Feb 2003 15:06:38 -0500, Bryan F. Hogan wrote: There are two reserved words in your query that will cause