Im I correct in thinking this SQL Is in a variable? <cfquery ...> #PreserveSingleQuotes(myvar)# </cfquery>
Pascal -----Original Message----- From: David Brown [mailto:[EMAIL PROTECTED]] Sent: woensdag 14 november 2001 17:17 To: CF-Talk Subject: ODBC error The below is an output of what is in the query. INSERT INTO tbl_user_profiles (username,password,FirstName,LastName,Email,Phone,CreateDate) Values ('dbrown','karen1','David','Brown','[EMAIL PROTECTED]','803 - 434-4703',{ts '2001-11-14 10:55:47'}) Below is the error I get. Any idea? ------------------------------------------------------------------------ - ------- Queries GetTableInfo (Records=10, Time=16ms) SQL = sp_columns tbl_user_profiles </PLAINTEXT><PRE></PRE></Q></S></SAMP></SCRIPT></SELECT></SMALL></STRIKE > </STRONG></SUB></SUP></TABLE></TD></TEXTAREA></TH></TITLE></TR></TT></U> <UL></UL></VAR></WBR><XMP></XMP> <HR> <H3>Error Occurred While Processing Request</H3> <P> <TABLE border=1> <TBODY> <TR> <TD> <H4>Error Diagnostic Information</H4> <P>ODBC Error Code = 22005 (Error in assignment) <P> <P>[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification <P> <P>SQL = "INSERT INTO tbl_user_profiles (username,password,FirstName,LastName,Email,Phone,CreateDate) Values (''dbrown'',''karen1'',''David'',''Brown'',''david.brown@palmettohealth. o rg'',''803-434-4703'',{ts ''2001-11-14 10:55:47''})" <P>Data Source = "Intranet_PHA2" <P>SQL = "INSERT INTO tbl_user_profiles (username,password,FirstName,LastName,Email,Phone,CreateDate) Values (''dbrown'',''karen1'',''David'',''Brown'',''david.brown@palmettohealth. o rg'',''803-434-4703'',{ts ''2001-11-14 10:55:47''})" <P> <P>The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (62:1) to (62:47). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
