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
You mean:
cfquery
Select cfif var eq whatevercol,col2,col3cfelse*/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
, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 12, 2002 1:29 PM
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
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
)
[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 whatevercol,col2,col3cfelse*/cfif
From Table
/cfquery
-Original Message-
From
)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 2: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
Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 1:40 PM
To: CF-Talk
Subject: RE: SQL in a CFIF
more like
cfif ListFindNoCase(#userroles#, 'SELECT something FROM database WHERE
condition = exist')
Do something here
cfelse
Do
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
)
[EMAIL PROTECTED]
-Original Message-
From: Brendan Avery [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 3:43 PM
To: CF-Talk
Subject: RE: SQL in a CFIF
you can not have your cfif conditional execute on the database-side; but you
can put cfif and other cftags inside a cfquery tag
- Original Message -
From: LANCASTER, STEVEN M. (JSC-OL) (BAR) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 12, 2002 1:53 PM
Subject: RE: SQL in a CFIF
Let me give an understanding of what I am doing. I have a variable that is
passing one or up to three numbers. The numbers
, March 12, 2002 3:54 PM
To: CF-Talk
Subject: RE: SQL in a CFIF
Let me give an understanding of what I am doing. I have a variable that is
passing one or up to three numbers. The numbers are passed like this: 1, 2,
3 or 1 or 1,2. My problem is I need to check to see if the the number is
listed
PROTECTED]]
Sent: Tuesday, March 12, 2002 4:08 PM
To: CF-Talk
Subject: RE: SQL in a CFIF
Use Listfind
Cfif Listfind(varName, 1) do A
cfelseif Listfind(varName, 2) do B
/cfif
Listfind will work without throwing an error - even if the VarName is an
empty string.
Mark
-Original Message
Ok ... I have no idea what that means. Perhaps you should post some actual
code.
Mark
-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 4:07 PM
To: CF-Talk
Subject: RE: SQL in a CFIF
Yeah but the 1 or 2 or 3
Subject: RE: SQL in a CFIF
Yeah but the 1 or 2 or 3 is dynamic and may not always be the same. If I
have the ability to run a query I can figure out which one I need.
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-Original Message-
From: Mark A. Kruger
/TD
/CFIF
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 4:14 PM
To: CF-Talk
Subject: RE: SQL in a CFIF
Ok ... I have no idea what
-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 12, 2002 2:20 PM
Subject: RE: SQL in a CFIF
#org_dlo# can equal on of three numbers at this point. When they update the
database the ID's change so this time it may be 18, 20, 21 next week it may
be 1, 2, 3 and so on and so forth. I need to create
: SQL in a CFIF
Like I said use:
WHERE ll_userroles.userroles_id IN '#org_dlo#'
instead of
WHERE ll_userroles.userroles_id = '#org_dlo#'
Bryan Stevenson
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED
Yes - looks like a plain ol' IN clause to me too. Makes sure and account for
you datatype.
Mark
-Original Message-
From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 4:21 PM
To: CF-Talk
Subject: RE: SQL in a CFIF
#org_dlo# can equal
Subject: Re: SQL in a CFIF
Sorry that should be:
WHERE ll_userroles.userroles_id IN (#org_dlo#)
Bryan Stevenson
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate
19 matches
Mail list logo