Sorry I deleted your original email but what error are you getting?
Ade
-----Original Message-----
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: 18 August 2004 15:43
To: CF-Talk
Subject: Re: Query from within a cfscript
No, I'm basing my code from this article:
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]
