SQL in a CFIF

2002-03-12 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
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

RE: SQL in a CFIF

2002-03-12 Thread Clint Tredway
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

Re: SQL in a CFIF

2002-03-12 Thread Bryan Stevenson
, 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

RE: SQL in a CFIF

2002-03-12 Thread Brendan Avery
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

RE: SQL in a CFIF

2002-03-12 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
) [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

RE: SQL in a CFIF

2002-03-12 Thread Shawn Grover
) [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

RE: SQL in a CFIF

2002-03-12 Thread Alex Ninan
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

RE: SQL in a CFIF

2002-03-12 Thread Matthew R. Small
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

RE: SQL in a CFIF

2002-03-12 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
) [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

Re: SQL in a CFIF

2002-03-12 Thread Bryan Stevenson
- 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

RE: SQL in a CFIF

2002-03-12 Thread Mark A. Kruger - CFG
, 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

RE: SQL in a CFIF

2002-03-12 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
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

RE: SQL in a CFIF

2002-03-12 Thread Mark A. Kruger - CFG
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

RE: SQL in a CFIF

2002-03-12 Thread Shawn Kernes
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

RE: SQL in a CFIF

2002-03-12 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
/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

Re: SQL in a CFIF

2002-03-12 Thread Bryan Stevenson
-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

Re: SQL in a CFIF

2002-03-12 Thread Bryan Stevenson
: 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

RE: SQL in a CFIF

2002-03-12 Thread Mark A. Kruger - CFG
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

RE: SQL in a CFIF

2002-03-12 Thread LANCASTER, STEVEN M. (JSC-OL) (BAR)
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