RE: Whats wrong with this code?
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: 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, Directory, Username, New, Copy, Delete, Move, Rename, Description ) VALUES ( , , , , , , , , , , , , , ) --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 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: 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, >Directory, >Username, >New, >Copy, >Delete, >Move, >Rename, >Description >) > VALUES ( >, >, > cfsqltype="CF_SQL_LONGVARCHAR">, > cfsqltype="CF_SQL_LONGVARCHAR">, > cfsqltype="CF_SQL_LONGVARCHAR">, > cfsqltype="CF_SQL_LONGVARCHAR">, >, >, >, >, >, >, >, > cfsqltype="CF_SQL_LONGVARCHAR"> >) > > > > > > --- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --- > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Whats wrong with this code?
There are two reserved words in your query that will cause a problem. They are: Size and Delete, these column names should not be used. Without knowing the values of your variables. I can't say for sure if this is your problem. Bryan F. Hogan Director 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 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 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: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, >Directory, >Username, >New, >Copy, >Delete, >Move, >Rename, >Description >) > VALUES ( >, >, > cfsqltype="CF_SQL_LONGVARCHAR">, > cfsqltype="CF_SQL_LONGVARCHAR">, > cfsqltype="CF_SQL_LONGVARCHAR">, > cfsqltype="CF_SQL_LONGVARCHAR">, >, >, >, >, >, >, >, > cfsqltype="CF_SQL_LONGVARCHAR"> >) > > > > > > --- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --- > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Whats wrong with this code?
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 form. Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Whats wrong with this code?
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: 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, New, Copy, Delete, Move, Rename, Description ) VALUES ( , , , , , , , , , , , , , ) --- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Whats wrong with this code?
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/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 a problem. They > are: Size and Delete, these column names should not be used. > > Without knowing the values of your variables. I can't say for sure if this > is your problem. > > > Bryan F. Hogan > Director 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 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 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: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, > >Directory, > >Username, > >New, > >Copy, > >Delete, > >Move, > >Rename, > >Description > >) > > VALUES ( > >, > >, > > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > cfsqltype="CF_SQL_LONGVARCHAR">, > >, > >, > >, > >, > >, > >, > >, > > > cfsqltype="CF_SQL_LONGVARCHAR"> > >) > > > > > > > > > > > > --- > > Colonel Nathan R. Jessop > > Commanding Officer > > Marine Ground Forces > > Guatanamo Bay, Cuba > > --- > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Whats wrong with this code?
-- 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 come about because you list the columns and THEN list the values, so it's easy to screw up the order. Unlike UPDATE, where you pair off the names/values. You can insert them in any order you wish (at least with Access, SQL Server, and Oracle). Scott Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Whats wrong with this code?
Cool! Bryan F. Hogan Director 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 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 a problem. They > are: Size and Delete, these column names should not be used. > > Without knowing the values of your variables. I can't say for sure if this > is your problem. > > > Bryan F. Hogan > Director 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 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 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: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, > >Directory, > >Username, > >New, > >Copy, > >Delete, > >Move, > >Rename, > >Description > >) > > VALUES ( > >, > >, > > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > cfsqltype="CF_SQL_LONGVARCHAR">, > >, > >, > >, > >, > >, > >, > >, > > > cfsqltype="CF_SQL_LONGVARCHAR"> > >) > > > > > > > > > > > > --- > > Colonel Nathan R. Jessop > > Commanding Officer > > Marine Ground Forces > > Guatanamo Bay, Cuba > > --- > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Whats wrong with this code?
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 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 come about because you list the columns and THEN list the values, so it's easy to screw up the order. Unlike UPDATE, where you pair off the names/values. You can insert them in any order you wish (at least with Access, SQL Server, and Oracle). Scott Scott Brady http://www.scottbrady.net/ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4