<cfsavecontent variable="plsql">
BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = 'Welcome to here' WHERE DATACALL = 2; END;
</cfsavecontent>
<cfquery name="davidTest" datasource="#mysession.dcname#">
#plsql#
</cfquery>
results in:
ORA-06550: line 1, column 50: PL/SQL: ORA-00933: SQL command not properly ended ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored
SQL = "BEGIN UPDATE SYSTEMINFO SET LOGINPAGEMESSAGE = ''Welcome to here'' WHERE DATACALL = 2; END;"
-----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]
