Home | Advertising Info5 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Friday, May 17, 2024  

  Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
Classic ASP - General
 PowerASP Code Help Area : Classic ASP - General
Subject Info: Adding Selection Feilds To Database A d d - P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
ChrisT
Newbie
Newbie
Avatar

Joined: January/08/2006
Location: United Kingdom
Online Status: Offline
Info: 1
Added: January/08/2006 at 3:14pm | IP Logged Quote ChrisT

I have 2 tables 1 listing countries and one listing states within those countries, I want a user to firstly select a country then click next hyperlinking to a new page asking them for a state which is filtered by the country initiall selected can anyone tell me how to do this.

PS I am relativley new to this so be gental!
Back to Top View ChrisT's Profile Search for other info by ChrisT
 
mjunior
Newbie
Newbie
Avatar

Joined: November/06/2004
Location: Brazil
Online Status: Offline
Info: 27
Added: February/02/2006 at 1:12pm | IP Logged Quote mjunior
Hi,

If you have the country also in a second table is a trivial issue...on contrary you'll need a more complicated sql statement by using inner.join...
Again, if you have a row of data in your second table correlating the states with respective countries..all you'll need is to send the selected field on your form (country) to another page where you'll place the state selection. Thus means in a second page you need to receive that value ( I presume you're aware about request.querystring methods)...then all you need to do is an option field using a select from your database filtering data as your variable recieved in page transition..

This is a general tip of course...Let me know if you need a fully exemple (you can send me your tables as well)

Hope it helps..

__________________
mjunior(dumb)
Back to Top View mjunior's Profile Search for other info by mjunior
 

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  A d d - P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area

   Active Server Pages Rule The World
 Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2024 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
 STATS Unless otherwise noted - All Rights Reserved.

PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com