Yes, this sounds like the best solution. I might, though, just opt to create
an array in the backend ASP file that processes the info. That way, I don't
have to create the SQL db on my server.

---------------------------------------------------------
Chuck Evans
Web Marketing Manager
Captura Software, Inc.
(425) 424-1155
chucke(at)captura.com
www.captura.com

-----Original Message-----
From: Stephen Johnston [mailto:pepe(at)gainsay.com]

Another option is to just pass the state and then on the backend pull the 
sales region out of a database table or array or some other storage method. 
This may give you better management options, particularly if any states 
change sales regions. Like if sales regions are associated with regional 
offices, where a new office may be created and take over some of the states 
that another office dealt with previously.

This could also be a nice introduction to database concepts if you have not 
dealt with that before. Using ASP and SQL server, this would probably only 
require an hour (or less) for someone who knows how to do it. And would not 
require a tremendous amount of study on your part to figure out how it is 
done. It would require one table and a query like: 'select region from 
sales_regions where state = "AL"' your table would look like this:

ID | state | region
1  | AK    | NorthWest
2  | AL    | SouthEast
3  | CA    | West

• Web Designer Courses
• Off the Shelf Training Courses

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA