http://www.macromedia.com/devnet/mx/coldfusion/extreme/cftags_cfscript.html
The sample code in the article seems to call a CFQuery from within a CFSCRIPT block:
<CFSCRIPT>
SQLString = "Select * From LoginInfo where
UserID='BobZ' and Password = 'Ads10'";
DATASOURCE = "CompanyInfo";
checkUser=CFQUERY(SQLString: SQLString,
DATASOURCE: DATASOURCE);
if (checkUser.recordCount neq 0) {
CFOUTPUT("Welcome Back, " & checkUser.UserID);
} else {
CFOUTPUT("Your UserName is Wrong.. try again!");
CFLOCATION(theURL:"login.cfm");
}
</CFSCRIPT>Thanks,Howie----- Original Message -----
From: Adrian Lynch
To: CF-Talk
Sent: Wednesday, August 18, 2004 10:41 AM
Subject: RE: Query from within a cfscript
Have you got a function of your own called CFQuery()?
Ade
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
