I checked the database and there seems to be something wrong with the <cfqueryparam> because when I check the fields using SQL Query Analyzer there are question marks "?" in the fields which I think is an error trying to update the fields?
Do I need the <cfqueryparam>? On Thu, 04 Sep 2003 07:55:24 -0400, Bushy wrote: > Hi, > > What's wrong with the below syntax? I think the single quotes around the "commalist" > is throwing it for a loop? > How can I get around this? If I use double quotes I'll run into the same problem > around the "ListGetAt..." code. > > <cfquery name="Insert" datasource="prefs"> > UPDATE tblProfiles > SET > strSelect='<cfqueryparam value="#ListGetAt(commalist,1,'|')#" > cfsqltype="CF_SQL_LONGVARCHAR">' > WHERE strUsername='#auth#' > </cfquery> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
