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_000_01BF9592.2A127AE2
Content-Type: text/plain;
charset="iso-8859-1"
Double Select Box Select Country and Counties/States are Shown in the
Second.
May be Useful to some one.
Regards,
Kevin McCabe
Intranet Developer
British SKY Broadcasting Ltd.
TEL: 0207 941 5502
*Are part-time band leaders semi-conductors?*
-----Original Message-----
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 23, 2000 2:17 PM
To: [EMAIL PROTECTED]
Subject: Re: Countries, States and Counties in case anyone needs them
I too am having a problem logging in as anonymous. Just for clarification
what is the host name?
twcreations.com
ftp.twcreations.com
tropicalwebcreations.com
Thanks.
Dave
----- Original Message -----
From: Larry C. Lyons <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 23, 2000 13:59
Subject: Re: Countries, States and Counties in case anyone needs them
> Bud,
>
> Thanks its going to be quite useful.
>
> larry
>
> --
> Larry C. Lyons
> EBStor.com
> 8870 Rixlew Lane, Suite 201
> Manassas, Virginia 20109-3795
> tel: (703) 257-4759
> fax: (703) 361-6706
> http://www.ebstor.com
> http://www.pacel.com
> email: [EMAIL PROTECTED]
> Chaos, panic, and disorder - my work here is done.
> --
> Bud <[EMAIL PROTECTED]> wrote in message
> news:v04210104b4ffb3300abd@[192.168.0.2]...
> > Hi all.
> >
> > I know this is OT, but I figured someone here could probably use it.
>
>
>
> ------------------------------------------------------------------------
> ------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------_=_NextPart_000_01BF9592.2A127AE2
Content-Type: application/octet-stream;
name="index.cfm"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="index.cfm"
<CFQUERY NAME=3D"Countries" DATASOURCE=3D"county">
SELECT Countries.Country_ID, Countries.Country, =
Countries.Country_Code
FROM Countries
ORDER BY Country
</CFQUERY>
<script
language=3D"javascript">
<!--=20
<CFOUTPUT query=3D"Countries" group=3D"Country_ID">
<CFQUERY NAME=3D"states" DATASOURCE=3D"county">
SELECT States.State_ID, States.State, States.Country_ID
FROM States
Where States.Country_ID =3D#Country_ID#
ORDER BY State
</CFQUERY>
selList#country_id# =3D new Array(<cfloop query=3D"states" =
startrow=3D"1" =
endrow=3D"#states.RecordCount#">"#State#","#State_ID#"<CFIF CurrentRow =
is not RecordCount>,</cfif></cfloop>);
</CFOUTPUT>
function fillSel(selObj)
{
var i =3D j =3D 0;
var newItem;
var src;
var srcName =3D "";
for (i =3D 0; i < selObj.length; i++)
if (selObj.options[i].selected)
srcName =3D selObj.options[i].value;
src =3D eval(srcName);
with (document.cascade.destList)=20
{
options.length =3D 0;
for (i =3D 0; i < src.length; i++)
{
newItem =3D options.length;
options[newItem] =3D new Option(src[i]);
options[newItem].value =3D src[i+1];
i++;
}
options[0].selected =3D true;
}
}
//-->=20
</script>
<form name=3D"cascade">
<p><select name=3D"selList1" size=3D"1"
onchange=3D"fillSel(this)">
<option selected>Select an option</option>
<CFOUTPUT query=3D"Countries" group=3D"Country_ID">
<option =
value=3D"selList#Country_ID#">#Countries.Country# =
(#Countries.Country_Code#)</option>
</CFOUTPUT>
</select>
<select name=3D"destList" size=3D"1">
<option>-- Select an option -- </option>
</select></p>
</form>
------_=_NextPart_000_01BF9592.2A127AE2--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.