"Name" may be a reserved word depending on your DB ...and just don't use CFUPDATE/CFINSERT...learn the SQL...it will make your life WAY simpler in the long run.
HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ----- Original Message ----- From: "Chris Kavanagh" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, February 01, 2005 2:41 PM Subject: CFUPDATE throwing up a weird error > Dear List, > > This CFUPDATE looks okay to my noobish eyes: > > -- > <CFSWITCH expression="#insert#"> > <CFCASE value="updatecompany"> > <CFUPDATE datasource="taskomatic" tablename="companies" > formfields="name"> > </CFCASE> > </CFSWITCH> > -- > > [#name# is the primary key] > > Yet when I run it, it's throwing up this error: > > -- > Error Executing Database Query. > > Syntax error or access violation: You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near 'where name='Dirtymilk'' at line 1 > -- > > Can anyone spot my mistake? > > Thanks, > CK. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192682 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
