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] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "LANCASTER, STEVEN M. (JSC-OL) (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 on and so forth. I need to create everything so that if > the ID's change the application will function exactly the same way without > any interruption. > > <CFIF IsDefined("dlo_org")> > <CFIF Len(dlo_org) GT 0> > <TD VALIGN="top" ALIGN="left"> > <FONT SIZE="-1"> > <cfoutput> > <cfquery name="getDloOrganization" > datasource="#application.lldbDatasource#"> > SELECT DISTINCT > InitCap(ll_userroles.userroles) || ' - ' || ll_organization.description as > description > FROM ll_userroles, > ll_useruserroles, > ll_user_org, > ll_organization > WHERE ll_userroles.userroles_id = > '#org_dlo#' > AND > ll_userroles.userroles_id = ll_useruserroles.userroles_id > AND > ll_useruserroles.useruserroles_id = ll_user_org.useruserroles_id > AND ll_user_org.org_id = > ll_organization.org_id > </cfquery> > </cfoutput> > <cfoutput > query="getDloOrganization"> > > #description# > </cfoutput> > <CFELSE> > > </CFIF> > </FONT> > </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 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 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 - CFG [mailto:[EMAIL 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----- > From: LANCASTER, STEVEN M. (JSC-OL) (BAR) > [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 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 in the #variable#. so That I can go from there. My application works > as long as my variable is only passing one number. If it passes 2 numbers my > query doesn't like it. I have a query based on the variable 2 being in > there. Any help would be appreciated. I am going crazy trying to figure it > out. > > Steven Lancaster > Barrios Technology > NASA/JSC > 281-244-2444 (voice) > [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-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 specified, pull > the default item: > > <cfquery name="iteminfo" datasource="mydsn"> > SELECT TOP 1 * FROM tbl_Merchandise > WHERE > <cfparam name="currentitem" default=""> > <cfif currentitem IS NOT ""> > id=#currentitem# > <cfelse> > default='y' > </cfif> > </cfquery> > > but it is important to note that the cftags, including the cfif are > processed before the query itself is sent to the sql server, so all this > happens within cf. > > > > > -----Original Message----- > > From: LANCASTER, STEVEN M. (JSC-OL) (BAR) > > [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, March 12, 2002 13:30 > > 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] > > > > > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists