Originally posted by WingMan Are you sure that
PC.EmailAddress = ':3'
is being substitued by firstname.lastname@example.org ??
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.