Re: Query o Queries and apost's

2006-04-19 Thread Denny Valliant
Next time it comes up I'll create a recipe. It's only when I'm doing complex dynamic creation of queries, and then trying a query of query of the query I created. I don't think that it's anything preserveQuotes would fix, and I haven't tried re-writing the generation to use cfqueryparams... I

RE: Query o Queries and apost's

2006-04-17 Thread Ben Nadel
Is there anyway you can make the SQL less dynamic and include CFQueryParams... That usually takes care of apostrophe type stuff. But if you cannot, I am not sure I have any ideas... Can you post the generated SQL?? -ben ... Ben Nadel Web Developer Nylon Technology 350 7th

RE: Query o Queries and apost's

2006-04-16 Thread Adrian Lynch
To be honest(does anyone ever say to be a liar?!), I'm too busy writing out columns names to read your email correctly, but have a play about with PreserveSingleQuotes() Adrian -Original Message- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: 16 April 2006 04:55 To: CF-Talk