Access Database content on a web page

**Krass** · Nov 9th, 2000, 10:35 AM

Hi. I had no luck with this post on other forums so her eI am...

I am planning on building a web page that shows an access database's content based on the user's choice (Example for a CD store, the user will choose the kind of music, price range etc)

I am very familiar with Access and the way it deals with SQL. Are there any tutorials I should look for? Thank you

**damonous** · Nov 9th, 2000, 12:03 PM

Check out Active Server Pages or IIS applications. Either one will do the trick.

**Krass** · Nov 9th, 2000, 12:22 PM

Active Server Pages? This is what they call ASP right? Then this must be very popular. Is this to be used with my web developer (frontpage, macromedia etc)?

Or is it a web-page developer by itself? All I want to be able to do is perform custom queries. I don't need no online shop or anything like that.

Do you know a place for good tutorials on this?

Thank you

**Brandito** · Nov 9th, 2000, 03:19 PM

'Add this to your .html page
<form method= post action="your.asp">
<input type="text" name="Pass" value size="20"></input>
<input type=submit></input>

---------------------------------------

'Create the "your.asp" you called in your html file
<html> 'use normal html

<% my_pass = request("Pass") %> 'Server side VBS

<%
SQL_String = "SELECT info.login ..."
SQL_String = SQL_String & " where((info.pass) = my_pass);"

set conn = server.createobject("adodb.connection")
conn.open "dsn=loginform" 'Your Database

set rs = conn.execute(SQL_String)

while not rs.eof
If LCase(rs("login")) <> "root" then
response.write "<br><b>Login:</b> " & rs("login")
Else
rs.movenext 'goes to the next record
Wend
%>
<p>All login names use Password: <% =my_pass %>
</html>

------------------------------
This is sample BS code that will query a database and print out all Login Names that have the Password you send to the .ASP except the Login of ROOT.

This should help you on your way so you can get a feel of what your in for.

Brandon

**Shafee** · Nov 14th, 2000, 01:28 PM

Hi there,

Here is a really great tutorial which helped me get started with ASP.

http://msdn.microsoft.com/library/pa...erverpages.htm

[Edited by Shafee on 11-14-2000 at 01:33 PM]

**Krass** · Nov 15th, 2000, 09:28 AM

...sounds good. But from that URL, there is no link and couldn't find on MSDN where the tutorial actually starts.

Can you help me out?

**HeSaidJoe** · Nov 15th, 2000, 09:39 AM

Don't forget to check and see if your host allows ASP on their server...a vast majority don't.

Lots of stuff Here

**vbdeveloper** · Nov 15th, 2000, 09:56 AM

Firstly, you can use Front page itself to link to a database. Refer to any book on front page for this.
Front Page automatically creates a database connection for you guiding you through the wizard. You can set up the database connection using Insert->Database Results. Morever you can also specify sql statements.

Secondly, ASP lets you set up database manipulation through code. You have to link to the database which is done by using the connection object of ASP. After the connection is established, a recordset is returned(i.e) a group of fields are returned based upon your search criteria. You can manipulate the recordset using the ASP code and syntax.

I recomment you learn ASP cause it would really help you in database manipulation on the net.

I would soon send you a perfect code for you use based on a real life time simulation.

Enjoy Programming.

**Krass** · Nov 15th, 2000, 11:34 AM

I hope, and I think, that my knowledge on databases (SQL, recordsets) will help me a lot in learning ASP.

I'm simply new to everything that touches the web. Maybe some of you can answer my question: I am thinking on retrieving data from a database and show its content in an OCX component I usually employ in VB.

What will happen if the user viewing the web page doesn't have the component (.ocx)?

**Shafee** · Nov 17th, 2000, 07:25 AM

Try this link then.

http://msdn.microsoft.com/library/de...erverpages.htm

Use the TOC (Table Of Contents) at the left hand side of the screen.

[Edited by shafee on 11-17-2000 at 07:28 AM]

**Skeen** · Nov 17th, 2000, 07:28 AM

It don't get much easier.

I'm a crap programmer, but even I can use asp's

Blummin' smashin they are - I'd reccomend 'em to anybody!

Cheers 'n' beers
Skeen

Thread: Access Database content on a web page

Thread Tools

Display

Here is some example Code

<?>

Reply to query

SQL in VBScript sat inside HTML

Posting Permissions