This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01C0297D.DB5426F0
Content-Type: text/plain;
charset="iso-8859-1"
Dan
I think you missed the variable name from your isdefined function.....
select *
from tbl
where <cfif isdefined("id")>
id = #id#
</cfif>
or
<cfif isdefined("name")>
name = #name#
</cfif>
-----Original Message-----
From: Dan Donnick [mailto:[EMAIL PROTECTED]]
Sent: 28 September 2000 17:36
To: CF-Talk
Subject: conditional where statement
is this correct or am i missing something?
select *
from tbl
where <cfif isdefined(")>
id = #id#
</cfif>
or
<cfif isdefined(")>
name = #name#
</cfif>
______________________________
Dan Donnick
Cold Fusion Developer
Bixler Incorporated
1250 24th Street
Suite 250
Washington, DC 20037
P: (202) 686-5800
F: (202) 686-5801
______________________________
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------_=_NextPart_000_01C0297D.DB5426F0
Content-Type: application/octet-stream;
name="Richard Moger (E-mail).vcf"
Content-Disposition: attachment;
filename="Richard Moger (E-mail).vcf"
BEGIN:VCARD
VERSION:2.1
N:Moger;Richard
FN:Richard Moger (E-mail)
ORG:James Villa Holidays Ltd
TITLE:IT Manager
TEL;WORK;VOICE:+44 (01732) 840846
TEL;CELL;VOICE:+44 (0777) 953 8192
TEL;WORK;FAX:+44 (01732) 872093
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Regents Court=0D=0ALondon
Road;Addington;Kent;ME19 5PL;United Kingdom
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Regents Court=0D=0ALondon Road=0D=0AAddington,
Kent ME19 5PL=0D=0AUnited Kin=
gdom
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20000707T003119Z
END:VCARD
------_=_NextPart_000_01C0297D.DB5426F0--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
