OK, I'm guessing that the reiinstall of SQLServer has introduced a software update with it that has finally corrected a bug within the db software (or drivers interface), that has so far gone unnoticed by letting the old behavior pass.
if you're already using PreserveSingleQuotes(), you'll find that cfqueryparam makes it look like a hack in comparison (ie: using cfqueryparam doesn't need preserveSingleQuotes) if the code has not changed but the database has, then, what ever has not been eliminated, however improbable, must be the answer. On Feb 14, 2008 2:57 PM, AJ Mercer <[EMAIL PROTECTED]> wrote: > no - but that is another world of pain I have to put up with > > Like I say, it used to work > > > On Feb 14, 2008 1:53 PM, Zac Spitzer <[EMAIL PROTECTED]> wrote: > > > > > are you using cfqueryparam? > > > > > > > > > > On Feb 14, 2008 3:27 PM, AJ Mercer <[EMAIL PROTECTED]> wrote: > > > Our SQL Server has just been reinstalled and now our CF application is > > > throwing an error when inserting a string that has a single quote in it. > > > > > > It used to work, so I am thinking there might be a setting in SQL Server > > > somewhere that enables this > > > Is this the case? > > > > > > > > > -- > > > > > > AJ Mercer > > > Web Log: http://webonix.net > > > > > > > > > > > > > > > -- > > Zac Spitzer - > > http://zacster.blogspot.com (My Blog) > > +61 405 847 168 > > > > > > > > -- > > AJ Mercer > Web Log: http://webonix.net > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
