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,

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-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 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 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 Jeff Garza
; <[EMAIL PROTECTED]> Sent: Thursday, February 27, 2003 12:42 PM Subject: Whats wrong with this code? Hi, Whats wrong with the below code? I get a SQL syntax error. INSERT INTO results ( FileName, Command, CreatedOn, LastAcc, LastMod, Size, Directory, Username,

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 Bryan F. Hogan
lopment > 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:43 PM > To: CF-Talk &

RE: Whats wrong with this code?

2003-02-27 Thread FlashGuy
fied ColdFusion MX Developer > Digital Bay Media, Inc. > 1-877-72DIGITAL > > > -Original Message- > From: FlashGuy [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 27, 2003 2:43 PM > To: CF-Talk > Subject: Whats wron

RE: Whats wrong with this code?

2003-02-27 Thread Bryan F. Hogan
- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, February 27, 2003 2:43 PM To: CF-Talk Subject: Whats wrong with this code? Hi, Whats wrong with the below code? I get a SQL syntax error. INSERT INTO results ( FileName, Command, CreatedOn, LastAcc, LastMod, Size,

Whats wrong with this code?

2003-02-27 Thread FlashGuy
Hi, Whats wrong with the below code? I get a SQL syntax error. INSERT INTO results ( FileName, Command, CreatedOn, LastAcc, LastMod, Size, Directory, Username, New, Copy, Delete, Move, Rename, Description ) VALUES ( , , , , , , ,