I don't know the exact fix, but I can tell you a little more about what Access is saying.
I have seen this wonderful error before within Access while designing forms. Generally, it only comes up when you have built a form control containing a dot or a bracket in the name, which makes Access choke. How does the update statement work if you remove the email line? M -----Original Message----- From: Scott Wilhelm [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:08 PM To: CF-Talk Subject: HELP PLEASE!!!! I keep getting the following error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[EMAIL PROTECTED]'. SQL = "UPDATE Staff SET LastName = "11", FirstName = "21", Building = "West Side Elementary", DeptCode = "09", Job = "3", Extension = 4, [Alternate Phone] = 3864504, [Alt Extension] = 5, Email = "[EMAIL PROTECTED]", GroupCode = 4, FTE = ".50", SupevisorID = 25 WHERE ID = 1137" Data Source = "SLL_STAFF" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (9:2) to (9:66). Date/Time: 03/10/03 13:06:54 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) Remote Address: 163.153.8.144 HTTP Referrer: http://admin.sllboces.org/tools/staff_directory.cfm?id=1137 Query String: a=update&id=1137 With this code: <cfquery name="InsertStaff" datasource="SLL_Staff" dbtype="ODBC"> UPDATE Staff SET LastName = "#form.lname#", FirstName = "#form.fname#", Building = "#form.bldg#", DeptCode = "#form.dept#", Job = "#form.job#", Extension = #form.ext#, [Alternate Phone] = #form.aphone#, [Alt Extension] = #form.aext#, Email = "#form.email#", GroupCode = #form.group#, FTE = "#form.fte#", SupevisorID = #form.sup# WHERE ID = #URL.id# </cfquery> Can someone tell me what I'm doing wrong? I know all the fields are correct, and the FORM requests are too... Thanks, Scott Scott Wilhelm Computer Technician/Web Developer http://www.sllboces.org <http://www.sllboces.org/> [EMAIL PROTECTED] Canton (Mon/Tue) St. Lawrence-Lewis BOCES PO Box 231, 139 State Street Road Canton, NY 13617 P. 315-386-4504 x 164 F. 315-386-3395 Heuvelton (Wed/Thu/Fri) Heuvelton Central School PO Box 375, 87 Washington Street Heuvelton, NY 13654 P. 315-344-2414 x 3651<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
