_____
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 8 September 2004 1:54 PM
To: CF-Talk
Subject: RE: escaping " character
VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#,.
Becomes something like
VALUES (
<cfqueryparam cfsqltype="CF_SQL_INTEGER" name="#qData.SRXNO#">,
<cfqueryparam cfsqltype="CF_SQL_TIMESTAMP" name="#qData. SDISPDATE #">,
<cfqueryparam cfsqltype="CF_SQL_VARCHAR" name="#qData. PTITLE #">,.
Looks a bit complex huh? But you get used to it. Watch for curly quotes in
there.
_____
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 8 September 2004 3:56 p.m.
To: CF-Talk
Subject: RE: escaping " character
I am really lost here - I have read through the livedocs article on
cfqueryparam and it seems that it is meant to go to the right of a where
clause in a cfquery statement. I am really not sure how/why to use it.
Use <CFQUERYPARAM> !!!!!! put the #qData.xxx# in the value attribute and
use the appropriate cfsqltype
Pascal
> -----Original Message-----
> From: Brant Winter [mailto:[EMAIL PROTECTED]
> Sent: 06 September 2004 13:26
> To: CF-Talk
> Subject: RE: escaping " character
>
> What am i doing wrong here ? Sorry about the huge post, but I just
cant
> see
> what I am missing now ? The error in line 57 refers to a different
field
> than the exception message showing an address "Syntax error (missing
> operator) in query _expression_ '2 HOLBOURN CRES'." ????
>
_____
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]