Re: HELP!!!

Cathy and Dave Sat, 22 Dec 2001 20:05:56 -0800

can you use WHERE manuid IN  '#dealersmanufacturers#' ?

----- Original Message -----
From: webmaster <[EMAIL PROTECTED]>
To: SQL <[EMAIL PROTECTED]>
Sent: Friday, December 21, 2001 11:38 PM
Subject: HELP!!!



> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0046_01C18A70.411749A0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Is there anyone who can help me figure out this problem?
>
> This is what I already have below.  Essentially I am trying to compare a =
> single value "manuId" to a comma delimited list of values which is the =
> field dealersmanufacturers.  Can anyone shed some light on this sql =
> dilema?
>
> Thanks, Branden
>
> <cfquery name=3D"dealersMainBody" datasource=3D"#request.maindsn#" =
> dbtype=3D"#request.dsntype#">
> SELECT dealersId, dealersName, dealersLink, dealersDescription, =
> dealersCategoryId, dealersState, dealersDateCreated, =
> dealersDateLastModified, dealersOnOff
> FROM tbldealer
> WHERE dealersCategoryId =3D #variables.DivisionId# and dealersOnOff =3D =
> 1=20
> <!---   12/18/01=20
>   Look for three unique strings, if string is the=20
>   (1) first in the list
>   (2) last in the list
>   (3) middle of the list
> --->
> <cfif isdefined("attributes.manuid")>
>  and=20
>   (
>  dealersmanufacturers like '#left(attributes.manuId,lenam)#,%'
>   or
>  dealersmanufacturers like '%,#right(attributes.manuId,lenam)#'
>   or
>  dealersmanufacturers like '%,#attributes.manuId#,%'=20
>  )
> </cfif>
> <!--- Bob END --->
> ORDER BY dealersName
> </cfquery>
>
> ------=_NextPart_000_0046_01C18A70.411749A0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html; =
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>
> <DIV><FONT face=3DArial size=3D2>Is there anyone who can help me figure =
> out this=20
> problem?</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>This is what I already have =
> below.&nbsp;=20
> Essentially I am trying to compare a single value "manuId" to a comma =
> delimited=20
> list of values which is the field dealersmanufacturers.&nbsp; Can anyone =
> shed=20
> some light on this sql dilema?</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>Thanks, Branden</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>&lt;cfquery name=3D"dealersMainBody"=20
> datasource=3D"#request.maindsn#" =
> dbtype=3D"#request.dsntype#"&gt;<BR>SELECT=20
> dealersId, dealersName, dealersLink, dealersDescription, =
> dealersCategoryId,=20
> dealersState, dealersDateCreated, dealersDateLastModified, =
> dealersOnOff<BR>FROM=20
> tbldealer<BR>WHERE dealersCategoryId =3D #variables.DivisionId# and =
> dealersOnOff =3D=20
> 1 <BR>&lt;!---&nbsp;&nbsp; 12/18/01 <BR>&nbsp;&nbsp;Look for three =
> unique=20
> strings, if string is the <BR>&nbsp;&nbsp;(1) first in the=20
> list<BR>&nbsp;&nbsp;(2) last in the list<BR>&nbsp;&nbsp;(3) middle of =
> the=20
> list<BR>---&gt;<BR>&lt;cfif =
> isdefined("attributes.manuid")&gt;<BR>&nbsp;and=20
> <BR>&nbsp;&nbsp;(<BR>&nbsp;dealersmanufacturers like=20
> '#left(attributes.manuId,lenam)#,%'<BR>&nbsp;&nbsp;or<BR>&nbsp;dealersman=
> ufacturers=20
> like=20
> '%,#right(attributes.manuId,lenam)#'<BR>&nbsp;&nbsp;or<BR>&nbsp;dealersma=
> nufacturers=20
> like =
> '%,#attributes.manuId#,%'&nbsp;<BR>&nbsp;)<BR>&lt;/cfif&gt;<BR>&lt;!--- =
> Bob=20
> END ---&gt;<BR>ORDER BY=20
> dealersName<BR>&lt;/cfquery&gt;</FONT></DIV></FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_0046_01C18A70.411749A0--
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
______________________________________________________________________
Macromedia ColdFusion 5 Training from the Source
  Step by Step ColdFusion
  http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: HELP!!!

Reply via email to