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 Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 12, 2002 2:26 PM
Subject: Re: 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]
> ---------------------------------------------------------
> 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]
> > >
> >
> >
> >
> >
> >
> >
>
______________________________________________________________________
Why Share?
Dedicated Win 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=coldfusionc
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
