View Single Post
  #3 (permalink)  
Old 09-11-02, 12:09
AnthroRules AnthroRules is offline
Registered User
 
Join Date: Jul 2002
Posts: 10
Quote:
Originally posted by WingMan
Are you sure that
PC.EmailAddress = ':3'
is being substitued by test@something.com ??

Shoud this be somthing like
PC.EmailAddress = char(39) + :3 + char(39)
to add the ansi ' before and after the variable :3

clear as mud
Thank you very much for your reply! However, that is incorrect in terms of how Cold Fusion parameterizes variables within SQL statements. The parameterization is correct, but again, the error persists.

I think it may have something to do with the column type for "Password", since it was set to RAW rather than VARCHAR. I am going to try to change the column type and also the SQL type in the Cold Fusion parameterization codes.

Thanks!
Reply With Quote