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.

Reply via email to