more like
<cfif ListFindNoCase(#userroles#, 'SELECT something FROM database WHERE
condition = exist')>
Do something here
<cfelse>
Do something else here!!
</cfif>
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-----Original Message-----
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 3:35 PM
To: CF-Talk
Subject: RE: SQL in a CFIF
You mean:
<cfquery>
Select <cfif var eq "whatever">col,col2,col3<cfelse>*</cfif>
>From Table
</cfquery>
-----Original Message-----
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 3:30 PM
To: CF-Talk
Subject: SQL in a CFIF
How would write a select statement within a CFIF statement.
1. Can it be done?
2. What is the Syntax?
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
