Thanks John,
My problem was that my data had apostrophes. Like O'Brien, ST Mary's, etc.
The custom tag works great. Thanks
-----Original Message-----
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 31, 2000 2:13 PM
To: CF-Server
Subject: RE: Two related Combo boxes
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0436E.98F65D40
Content-Type: text/plain;
charset="iso-8859-1"
Here's the code I used in my implementation of that tag. Hope it sheds some
light.
<CFQUERY DATASOURCE="#session.TimeDSN#" NAME="qPullProjectsModules"
CACHEDWITHIN="#SESSION.CacheExpiry#">
SELECT
p.ProjectOID AS p_projectOID,
p.ProjectName AS p_projectName,
m.ProjectOID AS m_projectOID,
m.moduleoid AS m_moduleOID,
m.modulename AS m_moduleName
FROM PROJECT p, MODULE m
WHERE p.ProjectOID = m.Projectoid
order by p_Projectname
</CFQUERY>
<CF_TwoSelectsRelated
QUERY="qPullProjectsModules"
NAME1="Projects"
NAME2="Modules"
DISPLAY1="p_Projectname"
DISPLAY2="m_moduleName"
VALUE1="p_ProjectOID"
VALUE2="m_ModuleOID"
SIZE1="1"
SIZE2="1"
HTMLBETWEEN="</TD><TD>"
AUTOSELECTFIRST="Yes"
EMPTYTEXT1="(Choose a project)"
EMPTYTEXT2="(Choose a module)"
FORMNAME="DailyEntry">
J.
John Wilker
Allaire Certified ColdFusion Developer
Directfit, formerly known as Integrated Partnerships
949.838.8811 Direct
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Dan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 31, 2000 9:37 AM
To: CF-Server
Subject: RE: Two related Combo boxes
Hi Lorcan, I'm working with the tag now. John Wilker suggested it earlier.
I'm doing something wrong thou...I keep getting runtime errors..on loading
the window (Line 215) and after making the 1st selection (Line 460) My code
is below.
<CFLOCK SCOPE="APPLICATION" TIMEOUT="30" TYPE ="ReadOnly">
<CFQUERY DATASOURCE='#application.DSNMain#' NAME="GetCounty">
SELECT StateCode, County
FROM StateCounty
Order by StateCode
</CFQUERY>
</cflock>
<FORM ACTION="TestTwoSelectsRelatedGo.cfm" METHOD="POST" onSubmit="return
require_Selected();" Name="MyOtherForm">
<CF_TwoSelectsRelated
QUERY="GetCounty"
NAME1="StateCode"
NAME2="County"
DISPLAY1="StateCode"
DISPLAY2="County"
VALUE1="StateCode"
VALUE2="County"
FORCEWIDTH1="70"
FORCEWIDTH2="70"
SIZE1="1"
SIZE2="1"
HTMLBETWEEN="<BR>"
AUTOSELECTFIRST="Yes"
EMPTYTEXT1="(choose a state)"
EMPTYTEXT2="(now choose a county)"
ONCHANGE="Submit!"
FORMNAME="MyOtherForm">
</FORM>
-----Original Message-----
From: Lorcan Murphy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 31, 2000 12:00 PM
To: CF-Server
Subject: Re: Two related Combo boxes
Hi Dan,
there is a custom tag called TwoSelectsRelated.cfm available from the
gallery which does that to perfection.
Lorcan
Dan wrote:
> Here's a hard one. I have a form with two combo boxes (State and County).
> The problems is that the 2nd (County) combo box is based on the value of
the
> 1st (State). I would like to keep the form together. Is there a way to
> make the 2nd boxes values change based on the input of the 1st?
>
> --------------------------------------------------------------------------
----
> To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
-------------------------------------------------------------------
CONFIDENTIALITY AND DISCLAIMER NOTICE
This e-mail is intended only for the addressee named above and the
contents should not be disclosed to any other person nor copies
taken. Any views or opinions presented are solely those of the
sender and do not necessarily represent those of Awarenet Ltd
(trading as Unipalm) unless otherwise specifically stated. As
internet communications are not secure we do not accept legal
responsibility for the contents of this message nor responsibility
for any change made to this message after it was sent by the
original sender. We advise you to carry out your own virus check
before opening any attachment as we cannot accept liability for any
damage sustained as a result of any software viruses.
-------------------------------------------------------------------
----------------------------------------------------------------------------
--
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
----------------------------------------------------------------------------
--
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
------_=_NextPart_001_01C0436E.98F65D40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: Two related Combo boxes</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Here's the code I used in my implementation of that =
tag. Hope it sheds some light.</FONT>
</P>
<P><FONT SIZE=3D2><CFQUERY =
DATASOURCE=3D"#session.TimeDSN#" =
NAME=3D"qPullProjectsModules" =
CACHEDWITHIN=3D"#SESSION.CacheExpiry#"></FONT>
<BR> <FONT SIZE=3D2>SELECT =
</FONT>
<BR> =
<FONT SIZE=3D2>p.ProjectOID =
AS p_projectOID,</FONT>
<BR> =
<FONT SIZE=3D2>p.ProjectName =
AS p_projectName,</FONT>
<BR> =
<FONT SIZE=3D2>m.ProjectOID =
AS m_projectOID, </FONT>
<BR> =
<FONT SIZE=3D2>m.moduleoid =
AS m_moduleOID, </FONT>
<BR> =
<FONT SIZE=3D2>m.modulename =
AS m_moduleName</FONT>
<BR> <FONT SIZE=3D2>FROM =
PROJECT p, MODULE m</FONT>
<BR> <FONT SIZE=3D2>WHERE =
p.ProjectOID =3D m.Projectoid</FONT>
<BR> <FONT SIZE=3D2>order by =
p_Projectname</FONT>
<BR><FONT SIZE=3D2></CFQUERY> =
</FONT>
</P>
<BR>
<BR>
<BR>
<P><FONT SIZE=3D2><CF_TwoSelectsRelated</FONT>
<BR> <FONT =
SIZE=3D2>QUERY=3D"qPullProjectsModules"</FONT>
<BR> <FONT =
SIZE=3D2>NAME1=3D"Projects"</FONT>
<BR> <FONT =
SIZE=3D2>NAME2=3D"Modules"</FONT>
<BR> <FONT =
SIZE=3D2>DISPLAY1=3D"p_Projectname"</FONT>
<BR> <FONT =
SIZE=3D2>DISPLAY2=3D"m_moduleName"</FONT>
<BR> <FONT =
SIZE=3D2>VALUE1=3D"p_ProjectOID"</FONT>
<BR> <FONT =
SIZE=3D2>VALUE2=3D"m_ModuleOID"</FONT>
<BR> <FONT =
SIZE=3D2>SIZE1=3D"1"</FONT>
<BR> <FONT =
SIZE=3D2>SIZE2=3D"1"</FONT>
<BR> <FONT =
SIZE=3D2>HTMLBETWEEN=3D"</TD><TD>"</FONT>
<BR> <FONT =
SIZE=3D2>AUTOSELECTFIRST=3D"Yes"</FONT>
<BR> <FONT =
SIZE=3D2>EMPTYTEXT1=3D"(Choose a project)"</FONT>
<BR> <FONT =
SIZE=3D2>EMPTYTEXT2=3D"(Choose a module)"</FONT>
<BR> <FONT =
SIZE=3D2>FORMNAME=3D"DailyEntry"></FONT>
</P>
<P><FONT SIZE=3D2> J.</FONT>
<BR><FONT SIZE=3D2> </FONT>
<BR><FONT SIZE=3D2>John Wilker </FONT>
<BR><FONT SIZE=3D2>Allaire Certified ColdFusion Developer</FONT>
<BR><FONT SIZE=3D2>Directfit, formerly known as Integrated =
Partnerships</FONT>
<BR><FONT SIZE=3D2>949.838.8811 Direct </FONT>
<BR><FONT SIZE=3D2>[EMAIL PROTECTED] <<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]=
om</A>> </FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Dan [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:dsmith@USSBattleshipNJ=
.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, October 31, 2000 9:37 AM</FONT>
<BR><FONT SIZE=3D2>To: CF-Server</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Two related Combo boxes</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi Lorcan, I'm working with the tag now. =
John Wilker suggested it earlier.</FONT>
<BR><FONT SIZE=3D2>I'm doing something wrong thou...I keep getting =
runtime errors..on loading</FONT>
<BR><FONT SIZE=3D2>the window (Line 215) and after making the 1st =
selection (Line 460) My code</FONT>
<BR><FONT SIZE=3D2>is below.</FONT>
</P>
<P><FONT SIZE=3D2><CFLOCK SCOPE=3D"APPLICATION" =
TIMEOUT=3D"30" TYPE =3D"ReadOnly"></FONT>
<BR><FONT SIZE=3D2><CFQUERY DATASOURCE=3D'#application.DSNMain#' =
NAME=3D"GetCounty"></FONT>
<BR><FONT SIZE=3D2>SELECT StateCode, County</FONT>
<BR><FONT SIZE=3D2>FROM StateCounty</FONT>
<BR> <FONT SIZE=3D2>Order by =
StateCode</FONT>
<BR><FONT SIZE=3D2></CFQUERY></FONT>
<BR><FONT SIZE=3D2> </cflock></FONT>
</P>
<P><FONT SIZE=3D2><FORM =
ACTION=3D"TestTwoSelectsRelatedGo.cfm" =
METHOD=3D"POST" onSubmit=3D"return</FONT>
<BR><FONT SIZE=3D2>require_Selected();" =
Name=3D"MyOtherForm"></FONT>
</P>
<P><FONT SIZE=3D2> <CF_TwoSelectsRelated</FONT>
<BR> <FONT =
SIZE=3D2>QUERY=3D"GetCounty"</FONT>
<BR> <FONT =
SIZE=3D2>NAME1=3D"StateCode"</FONT>
<BR> <FONT =
SIZE=3D2>NAME2=3D"County"</FONT>
<BR> <FONT =
SIZE=3D2>DISPLAY1=3D"StateCode"</FONT>
<BR> <FONT =
SIZE=3D2>DISPLAY2=3D"County"</FONT>
<BR> <FONT =
SIZE=3D2>VALUE1=3D"StateCode"</FONT>
<BR> <FONT =
SIZE=3D2>VALUE2=3D"County"</FONT>
<BR> <FONT =
SIZE=3D2>FORCEWIDTH1=3D"70"</FONT>
<BR> <FONT =
SIZE=3D2>FORCEWIDTH2=3D"70"</FONT>
<BR> <FONT =
SIZE=3D2>SIZE1=3D"1"</FONT>
<BR> <FONT =
SIZE=3D2>SIZE2=3D"1"</FONT>
<BR> <FONT =
SIZE=3D2>HTMLBETWEEN=3D"<BR>"</FONT>
<BR> <FONT =
SIZE=3D2>AUTOSELECTFIRST=3D"Yes"</FONT>
<BR> <FONT =
SIZE=3D2>EMPTYTEXT1=3D"(choose a state)"</FONT>
<BR> <FONT =
SIZE=3D2>EMPTYTEXT2=3D"(now choose a county)"</FONT>
<BR> <FONT =
SIZE=3D2>ONCHANGE=3D"Submit!"</FONT>
<BR> <FONT =
SIZE=3D2>FORMNAME=3D"MyOtherForm"></FONT>
<BR><FONT SIZE=3D2></FORM></FONT>
</P>
<P><FONT SIZE=3D2> -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Lorcan Murphy [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]<=
/FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, October 31, 2000 12:00 =
PM</FONT>
<BR><FONT SIZE=3D2>To: CF-Server</FONT>
<BR><FONT SIZE=3D2>Subject: =
Re: Two related Combo boxes</FONT>
</P>
<P><FONT SIZE=3D2>Hi Dan,</FONT>
</P>
<P><FONT SIZE=3D2>there is a custom tag called TwoSelectsRelated.cfm =
available from the</FONT>
<BR><FONT SIZE=3D2>gallery which does that to perfection.</FONT>
</P>
<P><FONT SIZE=3D2>Lorcan</FONT>
</P>
<P><FONT SIZE=3D2>Dan wrote:</FONT>
</P>
<P><FONT SIZE=3D2>> Here's a hard one. I have a form with two =
combo boxes (State and County).</FONT>
<BR><FONT SIZE=3D2>> The problems is that the 2nd (County) combo box =
is based on the value of</FONT>
<BR><FONT SIZE=3D2>the</FONT>
<BR><FONT SIZE=3D2>> 1st (State). I would like to keep the =
form together. Is there a way to</FONT>
<BR><FONT SIZE=3D2>> make the 2nd boxes values change based on the =
input of the 1st?</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>> =
------------------------------------------------------------------------=
--</FONT>
<BR><FONT SIZE=3D2>----</FONT>
<BR><FONT SIZE=3D2>> To unsubscribe, send a message to =
[EMAIL PROTECTED] with</FONT>
<BR><FONT SIZE=3D2>'unsubscribe' in the body or visit the list page at =
www.houseoffusion.com</FONT>
</P>
<BR>
<BR>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
----</FONT>
<BR><FONT SIZE=3D2>CONFIDENTIALITY AND DISCLAIMER NOTICE</FONT>
</P>
<P><FONT SIZE=3D2>This e-mail is intended only for the addressee named =
above and the</FONT>
<BR><FONT SIZE=3D2>contents should not be disclosed to any other person =
nor copies</FONT>
<BR><FONT SIZE=3D2>taken. Any views or opinions presented are solely =
those of the</FONT>
<BR><FONT SIZE=3D2>sender and do not necessarily represent those of =
Awarenet Ltd</FONT>
<BR><FONT SIZE=3D2>(trading as Unipalm) unless otherwise specifically =
stated. As</FONT>
<BR><FONT SIZE=3D2>internet communications are not secure we do not =
accept legal</FONT>
<BR><FONT SIZE=3D2>responsibility for the contents of this message nor =
responsibility</FONT>
<BR><FONT SIZE=3D2>for any change made to this message after it was =
sent by the</FONT>
<BR><FONT SIZE=3D2>original sender. We advise you to carry out your own =
virus check</FONT>
<BR><FONT SIZE=3D2>before opening any attachment as we cannot accept =
liability for any</FONT>
<BR><FONT SIZE=3D2>damage sustained as a result of any software =
viruses.</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
----</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-------------</FONT>
<BR><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>To unsubscribe, send a message to =
[EMAIL PROTECTED] with</FONT>
<BR><FONT SIZE=3D2>'unsubscribe' in the body or visit the list page at =
www.houseoffusion.com</FONT>
</P>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>To unsubscribe, send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the body or =
visit the list page at www.houseoffusion.com</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C0436E.98F65D40--
----------------------------------------------------------------------------
--
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
