>How could I integrate cfqueryparam in the following statement?
You'd have to redesign your custom tag. If I call out to any sort of SQL handler, for lack of a better term, I include the cfsqltypes as a delimited list, so a routine would be called something like
<cfmodule
template="do_sql_update.cfm"
tablename="mytable"
fields="field1,field2,field3"
values="form.value1,form.value2,form.value3"
cfsqltypes="CF_SQL_NUMERIC,CF_SQL_VARCHAR,CF_SQL_LONGVARCHAR"
wherekeys="foo,bar"
operators="eq,like"
wherevals="1,blah">
The sql statement then plugs these vals in, and usually that means a couple of loops to help get the job done.
HtH,
--
-------------------------------------------
Matt Robertson, [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
-------------------------------------------
--
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
