just thought of a nasty workaround (untested): write it to file then include it!
-----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: 21 February 2006 17:02 To: CF-Talk Subject: RE: cfsavecontent and cfqueryparam There's no way to do something like <cfqueryparam and then do an evaluate or something? There must be some workaround... > -----Original Message----- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 21, 2006 11:50 AM > To: CF-Talk > Subject: Re: cfsavecontent and cfqueryparam > > Nope, if you HAVE to put your SQL outside a CFQUERY tag, you have to > use inline values. Make sure you're very careful about sanitizing any > such values before using them, or you could be leaving yourself open > to SQL injection attacks. > > And don't forget preserveSingleQuotes() when you dump the generated > SQL into the CFQUERY tag. > > cheers, > barneyb > > On 2/21/06, Russ <[EMAIL PROTECTED]> wrote: > > I am trying to optimize some queries, and as such, trying to put several > 1 > > row insert queries into one. I am trying to use a function to generate > the > > sql, and then just loop through each record and generate the sql I need. > > The issue I'm running into is that cfqueryparam is not supported outside > of > > cfquery. Is there some way to escape it, or am I stuck with putting the > sql > > inline with the loop? > > > > > > Here is an example of what I want: > > > > <cfsavecontent variable="myqry"> > > > > set @userId=<cfqueryparam cfsqltype="cf_sql_integer" value="#userID#"> > > > > </cfsavecontent> > > > > Russ > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 100 invites. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233010 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
