Thanks, I'm trying to change the code using nested queries. ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, May 17, 2005 12:39 PM Subject: Re: Database error
> Rajani Chandra wrote: > > Yesterday i try cfqueryparam for simple query it works, but I'm not getting > > how to use cfqueryparam for my code because I'm storing all the fieldnames > > and values in one single variable (SETLISTSTR) and directly passing that > > variable to query. > > > > <cfset setliststr = "#setliststr# , #qry_getSpcListInfo.ItemName# = > > '#qry_getSpcListInfo.ItmValue#'"> > > > > <cfquery name="qry_update" datasource="EWNDAT"> > > UPDATE #qry_getSpcListInfo.PrimEntity# > > SET #setliststr# > > WHERE #whereclause# > > </cfquery> > > > > I don't have any idea how to use cfqueryparam for this code, so plz help me. > > You can't, you have to build the query inside the cfquery tags > with some traditional cfifs. It is highly recommended, but if you > don't want to do that check out PreserveSingleQuotes(): > http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h tml/wwhelp.htm?context=ColdFusion_Documentation&file=00000596.htm#134493 > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206909 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
