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: Fl

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 > D

RE: Whats wrong with this code?

2003-02-27 Thread Bryan F. Hogan
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 column data types "text" ? > > > Bryan F. Hogan > Director of Internet Deve

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: http://www.houseoffusion.com/cf_lists/i

RE: Whats wrong with this code?

2003-02-27 Thread FlashGuy
ital 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 wrong with this code? > > > No. They are all VARCHAR(

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 INSE

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 caus

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,