Answered
value in CFQUERYPARAM
I'm cleaning up some codes and start using <cfqueryparam> tags in all the queries.
There is one query that I'm not 100% sure how to convert to cfqueryparam :
INSERT INTO sometable (Column_1,Column_2, .......)
VALUES ( '#Value_1#', '#Value_2# #Value_3#', ......)
The value inserted into Column_2 shows ' #value_1# #value_3# '
Should I use it this way in cfqueryparam:
<cfqueryparam cfsqltype="cf_sql_varchar" value="#value_1# #value_2#"> ? will this be a proper way to do it?
AdChoices