Are you doubling all your single quotes in the phrases where you are preserving single quotes?
I've had this problem in the past where Oracle reads the sql as: Insert into tablea (lastname) values ('o'dell') as 'o' and dies or ignores dell. Need to write: Insert into tablea (lastname) values ('o''dell') And then it usually works. Margaret -----Original Message----- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:26 PM To: CF-Talk Subject: SQL and singlequotes Preservesinglequote() not working or are we missing something? Here is our code, and the resulting error from a user: <cfquery name="putitin" datasource="mrskellystea" username="#tea.user#" password="#tea.pass#"> Insert Into Feedback (comment, sitecomment, tearequest, okforemail, response, firstname, lastname, email, timedate) VALUES('#preservesinglequotes(form.comments)#', '#preservesinglequotes(form.sitesuggestions)#', '#preservesinglequotes(form.tearequests)#', '#form.teamail#', '#form.pleaserespond#', '#form.fname#', '#form.lname#', '#form.email_address#', #setdate#) </cfquery> >>>> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 't'. SQL = "Insert Into Feedback (comment, sitecomment, tearequest, okforemail, response, firstname, lastname, email, timedate) VALUES('I don't know if you got my message. Am looking for Mrs. Kelly's Special Jasmine tea. Is that the same as your Jasmine Special Grade? Is that the only Jasmine tea you carry? Do you have any hibiscus teas? ', '', '', 'n', 'n', 'Barb', 'Chapman', '[EMAIL PROTECTED]', {d '2002-05-06'})" Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists