I had problems with the {ts..} and Strings when inserting inserting. After
much playing I found that I could either use Replace() to get rid of them
before processing or to use a date-time field in the db.But I have never had a CF error putting them into the db. Don't know if that helps you any. But it might be something to think about. Ricardo. "Beattie, Barry" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > > Ah, but I'm forced into using DWMX server behavours (yuck - don't ask!) > which doesn't use queryparams. > > It's a string! work-arounds shouldn't be necessary... > > cheers > barry.b > > -----Original Message----- > From: Adam Chapman [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 8 October 2003 3:42 PM > To: CFAussie Mailing List > Subject: [cfaussie] RE: I think this is a CFMX bug. Please prove me > wrong. > > > Gidday Barry, > > > <cfset myTestString = "{ts it ain't 'alf 'ot, mum}"> > > Have you tried using a cfqueryParam tag? > > insert into tTest1(valTest1) > values(<cfqueryparam value="#myTestString#" cfsqltype="CF_SQL_VARCHAR">) > > (or perhaps there is a more suitable datatype?) > > Cheers, > Adam > > PS: What ain't 'alf 'ot? > > > -----Original Message----- > From: Beattie, Barry [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 08, 2003 1:55 PM > To: CFAussie Mailing List > Subject: [cfaussie] I think this is a CFMX bug. Please prove me wrong. > > > wierdness inserting into a text field in a db table (MSAccess, CFMX > 6.1). > > try it out, see what you think > cheers > barry.b > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
