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'',''[EMAIL PROTECTED]
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'',''[EMAIL PROTECTED]
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
