>> If anything its going to be the behaviour of the ODBC/JDBC driver that is
causing the problem.
fair enough but since the drivers ship with CF, who's problem is it?
>> It would appear that the {ts prefix is reserved for ODBC style date/time
values.
then it's an "undocumented feature". I couldn't find any info specifically
on this. Certainly this is news to people on this list. I must be the only
person on CFAUSSIE having to endure DWMX server behavours with CF.
>> It seems reasonable that the driver should be able to make the assumption
that data falling into a certain format be treated in a specific way
I dissagree strongly! Assumptions are dangerous. It's a bloody string - end
of story!
One area of CF that I fine annoying is inconsistancies. I'm having to
constantly refer to docs instead of educated guesses because of this. I'll
accept that in each case there are explainations for each one but what you
end up with are far too many exceptions to the rules. This {ts} issue is a
case in point.
Sure CFQUERYPARAM will get around it but I still reckon it shouldn't happen.
Even Microsoft admits to things like this as bugs (eventually...).
just my 2c
cheers
barry.b
-----Original Message-----
From: Geoff Bowers [mailto:[EMAIL PROTECTED]
Sent: Thursday, 9 October 2003 11:13 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: I think this is a CFMX bug. Please prove me wr-
ong.
Barry,
It doesn't sound like a CF bug at all. If anything its going to be the
behaviour of the ODBC/JDBC driver that is causing the problem.
It would appear that the {ts prefix is reserved for ODBC style date/time
values. It seems reasonable that the driver should be able to make the
assumption that data falling into a certain format be treated in a
specific way -- ie. not as a string but as a date/time object.
-- geoff
http://blog.daemon.com.au/
Beattie, Barry wrote:
> my question is why it isn't seen as a string?
>
> the {ts '...'} is comming from a FORM. It is text. It is going into a text
> field. This error shouldn't happen, therefore it's a bug.
>
> ... or a "feature" in MS speak...
>
> cheers
> barry.b
>
> -----Original Message-----
> From: Ricardo Russon [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 8 October 2003 11:55 PM
> To: CFAussie Mailing List
> Subject: [cfaussie] Re: I think this is a CFMX bug. Please prove me wr
> ong.
>
>
> 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/
