HI everyone I am new to the programing world and want to learn how. I know html pretty good and have created a page that i would like to have asp sort when certian options on the drop down list are selected or when a value is entered into the input field (the items are displayed if the are greater than or less than this value). The database that I have is access and I'm not really good with that either. All the information that i want s already on this page www.freewebs.com/gobock/%20racing.html I also want to now how to store a link in a database. So if anyone can help out a noob and show me how to do all that i want to that would be awesome.
Thanks,
Evan

Hi Evan

Thats a big chunk to take for your first go at a dynamic web page, but a nice one. The best way forward is to break things downs into easier to manage pieces, especially as the final query will be a fairly complex one.

I've got a couple of concerns though:
#1. When you hit the filter button it takes you to gtplanet.net and there lies a problem. Without doubt you used their web page content and layout as your own, DMXzone does not advocate this behaviour, unless of course you have permission to do so. So if you want us to help you, help yourself and make changes to the page that somehow show it's your own work and not gtplanet's, note their copyright - Copyright ©2000 - 2005, Jelsoft Enterprises Ltd, GTPlanet.Networks. It would have been far better to say I want to build a page like this, with a link pointing to gtplanet.
#2. Does your host support ASP, as their dynamic pages are JSP. In principal they are the same but use different servers and languages.
#3. Does your host support the use of database to build dynamic content, as all I've seen on there is static html pages.

You may not be planning on hosting an ASP site just yet or you've alrady investigated ASP with your host, so #2 & #3 might be non-concerns, but #1 needs sorting Evan. Also you may plan to learn by developing on your own local machine first, which is preferable, if so, has the environment been setup yet? Which operating system are you working with? Which server-side scripting language are you using? Do you use Dreamweaver, if so which version, if not what are you using?

Post back with your thoughts and we can take it from there.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

ok yes I copied their page but I plan to modify it when I learn how to create a sortable table like that. I'll remove the page from the web also. My host right now does not support any server language since it is a free site. But i have IIS on my computer right.

Hi Evan

Cool <img src=../images/dmxzone/forum/icon_smile_cool.gif border=0 align=middle>

First off, you need to create your db and the table(s) to hold the data you want to display. Create an ODBC connection to access the data. Create your page to display your data.

Regarding your data, you'll probably want 3 tables, one for the Type, one for the New/Used and one for the rest of the data. Any fields that need to contain numbers, need to be specified as a numeric data type, the rest can be text.

Get going with that and in the meantime, I'll quickly write up the table(s) for you, so you can check. Don't put any data in yet until you're sure that the design is right.


Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

Thanks Lee,
I'll start creating the tables. Should I set the vehicles as the primary key or should I just not bother right now.

Hi Evan

Ok I've setup a db with 3 tables:

tbl_cars
tbl_new_used
tbl_type

The columns are:

tbl_cars
col_car_id - autonumber (no duplicates) PK - primary key
col_car - text (100)
col_cost - currency
col_power - number (no decimal places)
col_torque - number (1 decimal place)
col_power_weight - number (1 decimal place)
col_value - number (no decimal places)
col_type_id - number (no decimal places) FK - foreign key to tbl_type
col_nu_id - number (no decimal places) FK - foreign key to tbl_new_used

tbl_new_used
col_nu_id - autonumber (no duplicates) PK
col_nu - text

tbl_type
col_type_id - autonumber (no duplicates) PK
col_type - text

Use the relationships button to create the relationships between the three tables linking the FK as in tbl_cars.

Populate all tables with data.

Post back when ready.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

thanks lee

ok lee I have created the db and added the data to it but i was not able to create the foreign keys since i was not able to find the relationship button in the program if you could tell me where that is that awesome.
Evan

Forget about the question about making foreign keys i figured out how too.

ok so can some buddy plaese answer my question about how to sort the database i'm was told to set up. I have tried to learn hw to do it but I can't figure it out. So please can some buddy help me since lee seems not to be responding.

Hi Evan

Have you done anything other than the db? What tool are you using to create the asp page?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>ok so can some buddy plaese answer my question about how to sort the database i'm was told to set up. I have tried to learn hw to do it but I can't figure it out. So please can some buddy help me since lee seems not to be responding. <hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I've not responded due to you not giving me an update other than you creating the db and adding data. Can you also answer the questions I posted in my first reply?

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

ok i have dmx and have created a recordset with it. I have figure that it would need to be a dynamic table so created that. Thats about everything that i have done so far.

Ok Evan

Just noticed you'll need add an additional table, the make table that will hold AC, Acura, Alfa Romeo etc., you'll need it to be set up similar to the tbl_types table.

tbl_make
col_make_id - autonumber (no duplicates) PK
col_make - text

Need to add the data to this table and also add another field to the tbl_cars, col_make_id which an FK to tbl_make.

Post back here when you've done.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>