no - it would not. What he's (probably) doing is staying away from a "data truncation" error - where the database
chockes on a string that is too long for the field size definition. In this case perhaps his field definition has a
size of 100 - doing a "left(string,100)" makes sure that the string is never too long.
-Mark
-----Original Message-----
From: Greg Luce [mailto:[EMAIL PROTECTED]
Sent: Monday, July 05, 2004 11:03 AM
To: CF-Talk
Subject: RE: Havent seen this error before...
Your second example is just trimming the left 100 chars, that won't affect
the single-quotes will it?
-----Original Message-----
From: JediHomer [mailto:[EMAIL PROTECTED]
Sent: Monday, July 05, 2004 11:57 AM
To: CF-Talk
Subject: Re: Havent seen this error before...
You dont need it to specify that its a string
i.e. set sfoo = 'im a sring'
It should also escape single quotes embeded into the string, but there
is a bug with a hotfix (which is what Mark was refering to I beleive)
where if you use a string function within the CFQueryParam which
contained a Single quote then it would be doubled up.
I.e.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
