I'm sorry I overlooked your statement before:
It does work if it's all on one line, not set as a variable first? (I can't test it, as we don't have ODBC datasources set up.)
I am trying to do this with the Oracle Native drivers not the ODBC.
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 27, 2004 4:55 PM
To: CF-Talk
Subject: Re: Help executing PL/SQL
Okay, what if you take that one (without line breaks) and use cfsavecontent
to save it to a variable and try to run it. Does that work? (In other words,
I'm trying to figure out if it's a problem with the replace statement, or a
problem with the way CF is passing the variable into the cfquery.)
----- Original Message -----
From: "Semrau Steven Ctr SAF/IE"
> Yes, doing this:
>
> <cfquery name="davidTest" datasource="#mysession.dcname#">
> BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE
DATACALL = 2; END;
> </cfquery>
>
> returns:
>
>
> davidTest (Records=0, Time=94ms)
> SQL =
> BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE
DATACALL = 2; END;
>
>
> And doing this:
>
> <cfquery name="davidTest" datasource="#mysession.dcname#">
> BEGIN
> UPDATE SYSTEMINFO
> SET LOGINPAGEMESSAGE = 'Welcome to here'
> WHERE DATACALL = 2;
> END;
> </cfquery>
>
>
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
