Re: Query o Queries and apost's
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 could filter it though a cfqueryparam-er next time and see what happens there tho. Hmmm... really just an edge case, I'm thinking- if it's anything at all, as noone else has run into it. I know the generated SQL is valid, I can cut and paste the same string into a 3rd party query thingy and it works fine. The mysterious doubles only happen within the cfquery tag itself. Odd... :DenNy On 4/17/06, Ben Nadel <[EMAIL PROTECTED]> wrote: > > 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 Ave. > Suite 1005 > New York, NY 10001 > 212.691.1134 x 14 > 212.691.3477 fax > www.nylontechnology.com > > Sanders: Lightspeed too slow? > Helmet: Yes we'll have to go right to ludacris speed. > -Original Message- > From: Denny Valliant [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 15, 2006 11:55 PM > To: CF-Talk > Subject: Query o Queries and apost's > > While I'm thinking about it, has anyone seen a weird thing with QoQs, > where > if you are using generated SQL ( like so: > >#someSQL# > > ) > > You get strange extra apostrophes? I say strange because doing someSQL = replace(someSQL,"'","","ALL")> doesn't work, (there aren't any > extra apostrophes in the first place) but dbtype="query"> >#replace(someSQL,"'","","ALL")# > > > does? I.E. the extra 's only get added within the tag? > > (Pretend I have correct ordering of vars in replace ;-)) > > I think it just must be a brain-fart somewhere along the line... I haven't > seen anything like it via google, so I figure, it's on this end. > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238223 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
RE: Query o Queries and apost's
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 Ave. Suite 1005 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax www.nylontechnology.com Sanders: Lightspeed too slow? Helmet: Yes we'll have to go right to ludacris speed. -Original Message- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: Saturday, April 15, 2006 11:55 PM To: CF-Talk Subject: Query o Queries and apost's While I'm thinking about it, has anyone seen a weird thing with QoQs, where if you are using generated SQL ( like so: #someSQL# ) You get strange extra apostrophes? I say strange because doing doesn't work, (there aren't any extra apostrophes in the first place) but #replace(someSQL,"'","","ALL")# does? I.E. the extra 's only get added within the tag? (Pretend I have correct ordering of vars in replace ;-)) I think it just must be a brain-fart somewhere along the line... I haven't seen anything like it via google, so I figure, it's on this end. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237896 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query o Queries and apost's
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 Subject: Query o Queries and apost's While I'm thinking about it, has anyone seen a weird thing with QoQs, where if you are using generated SQL ( like so: #someSQL# ) You get strange extra apostrophes? I say strange because doing doesn't work, (there aren't any extra apostrophes in the first place) but #replace(someSQL,"'","","ALL")# does? I.E. the extra 's only get added within the tag? (Pretend I have correct ordering of vars in replace ;-)) I think it just must be a brain-fart somewhere along the line... I haven't seen anything like it via google, so I figure, it's on this end. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237832 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Query o Queries and apost's
While I'm thinking about it, has anyone seen a weird thing with QoQs, where if you are using generated SQL ( like so: #someSQL# ) You get strange extra apostrophes? I say strange because doing doesn't work, (there aren't any extra apostrophes in the first place) but #replace(someSQL,"'","","ALL")# does? I.E. the extra 's only get added within the tag? (Pretend I have correct ordering of vars in replace ;-)) I think it just must be a brain-fart somewhere along the line... I haven't seen anything like it via google, so I figure, it's on this end. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237817 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
