Can anyone recommend a good way to filter " ' etc out of forms so on the
action page the SQL does not crash?
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Chad Gray wrote:
> Can anyone recommend a good way to filter " ' etc out of forms so on the
> action page the SQL does not crash?
cfqueryparam
Jochem
__
Structure your ColdFusion code with Fusebox. Get the official book at
htt
> Can anyone recommend a good way to filter " ' etc out of forms so on the
> action page the SQL does not crash?
There's no need to filter single or double quotes out of the form to prevent
sql from erroring unless you're also using PreserveSingleQuotes() ... CF
escapes single quotes automaticall
Is that a new tag? I see it mentioned a few times and I have never used
it. I will start reading. :)
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 4:30 PM
To: CF-Talk
Subject: Re: watching a form for illegal SQL characters
Chad
:35 PM
Subject: RE: watching a form for illegal SQL characters
> Is that a new tag? I see it mentioned a few times and I have never used
> it. I will start reading. :)
>
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August
S. Isaac Dealey wrote:
>>Can anyone recommend a good way to filter " ' etc out of forms so on the
>>action page the SQL does not crash?
>
> There's no need to filter single or double quotes out of the form to prevent
> sql from erroring unless you're also using PreserveSingleQuotes() ... CF
> esc
wrong option to pick?
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 4:38 PM
To: CF-Talk
Subject: Re: watching a form for illegal SQL characters
Nope, CFQUERYPARAM is a super great tag, it has many plus's, but the
interesting o
?¢â�š�¬�¢â�ž�¢ pillars can
>
> The database type is nText 16 I will assume CF_SQL_LONGVARCHAR was the
> wrong option to pick?
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 01, 2002 4:38 PM
> To:
8 matches
Mail list logo