No, this isnt a problem. I am only storing the actual sql of the query, the stuff that goes inside the cfquery tag, in the temporary text file. So its not a problem.
Im going to clean this up some and then ill post what ive got to the group so everyone can have it. Its already proven to be quite useful. On 9/20/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > >><cfquery name="variables.q" datasource="#form.ds#"> > #form.sqlQuery# > </cfquery> > > >>It works beautifully. My problem and question is... > > I can see another issue: single quotes. > > That is why, if you look at my example code, I reversed the quotes. > > "<cfquery name='variables.q' datasource='#form.ds#'>#form.sqlQuery#</cfquery>" > > This will allow single quotes inside the string with no problem, and since > queries seldom contain double quotes all should be well, albeit if it did, > something would have to be done about the interior double quotes. > > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > Confidentiality Notice: This message including any > attachments is for the sole use of the intended > recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the > intended recipient, please contact the sender and > delete any copies of this message. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218771 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
