> <cfset commalist = valuelist(GetAlias.env_var)>
> <cfquery name="Insert" datasource="data2" dbtype="ODBC">
> INSERT into profs
> (strField1)
> VALUES
> ('#commalist#')
> WHERE strUsername=<cfqueryparam value="#auth#"
cfsqltype="CF_SQL_VARCHAR">
> </cfquery>
My apologies for the late response to this thread, but I couldn't
help noticing the WHERE clause in this INSERT statement. If there
is already a value in strUsername, then an UPDATE statement
should be used rather than an INSERT.
~Dina
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
