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
Yes it can be done SELECT * FROM MyTable WHERE cfif MyVar eq ThisValue SomeField = This cfelse SomeField = ThisOtherValue /cfif ORDER BY SomeField HTH Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL

RE: SQL in a CFIF

2002-03-12 Thread Brendan Avery
you can not have your cfif conditional execute on the database-side; but you can put cfif and other cftags inside a cfquery tag-pair. for example if you had a page that had to display some item from your database, you could use a cfif to decide whether to pull an item by id or if no id is

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
Yep. cfif MyCondition cfquery name=myquery datasource=mydsn Select * from MyTable /cfquery /cfif OR cfquery name=MyQuery datasource=MyDSN Select * from MyTable cfif MyCondition Where lID = #IDVar# /cfif /cfquery OR Put

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
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

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
) (BAR) [EMAIL PROTECTED] To: CF-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

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