Webpage

[oliver_penney]

allo

if i have a database on a local pc

how do i write a very simple webpage to do a "SELECT * FROM sometable" in a webpage

i'm ok writing html btw

thanx in advance

ol

 

[ChrisUK]

I'm assuming your DB is an Access one.

First, the website host has to support ASP (Active Server Pages) if it doesn't you can't access a database online! most free hosts do not support ASP and others only support CGI or PHP - no use to you!

However, all is not lost. you can

a) change your host - wwwserver.co.uk is mine and they support ASP

b) find a free host who will give you ASP support - Brinkster is one of these but rememmber nothing is really free

There are loads of ASP demos on the web which will help you start off on the ASP road - just type ASP into google

HTH

Chris

 

[oliver_penney]

hmm

i need a server to do it all on my c:\ ?

tsk

thanx anyways

ol

 

[ChrisUK]

Sorry, I thought when you said a webpage you were talking about an online page. If you just want to do it on your local pc then you don't need a separate server, what you need depends on what OS your running on your PC.

If you have XP home you're stuffed - it needs to be XP PRO.

If you have Windows ME or 98 you need to get a copy of PWS (Personal Web Server) - it's free and comes with the Win98 CD. Windows ME doesn't support it but it will work, you'll need to down load it form Microsoft.

After this it's a case of looking up some ASP code, try a google search on "ASP Access" and you should find some code snippits which will help you.

HTH

Chris