Sure, what do you want to do?
<cfquery name="queryname" datasource="databasename">
select * from
<cfif form.field eq "1">
first_table
<cfelse>
second_table
</cfif>
</cfquery>
or
<cfquery name="queryname" datasource="databasename">
<cfif form.field eq "1">
select * from first_table
<cfelse>
delete from second_table where id = 1
</cfif>
</cfquery>
or
<cfif form.field eq 1>
<cfset querystring = "select * from first_table">
<cfelse>
<cfset querystring = "update second_table set name = 'Stud'
where id = 2">
</cfif>
<cfquery name="queryname" datasource="databasename">
#querystring#
</cfquery>
You can do a lot of things.
- Matt Small
-----Original Message-----
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 4: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]
______________________________________________________________________
Why Share?
Dedicated Win 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=coldfusionc
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
