Discussion Locked

interactive database

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Once I have made a database. How do you get it to work with e-commerce or how do you make a form find a product from the database.

5 replies

by limatik

There are many aspects to consider.

1. Target application (no. of users, requirements, project duration, etc.)
2. Platform

You could also try to find out what programming language you will be using.

I suggest you try to search on database programming topics using Java. There are lots of references in the web.

Best of luck.

by yungthrilla43

ok here is the deal. assume that your database is access. you have several waysd to connect to a dbase. i will show you how to do it with asp using custom connection string.
ok so lets say that you want to display all data in your access database that is on the root of your cdrive. (this assumes you have IIS or a web server running that supports asp)
start the page like this:
<%@ language="vbscript" %>
<%
dim db
set db = server.createobject("adodb.connection")
db.mode admoderead
db.open"provider=microsoft.jet.oledb.4.0;data source=c:\mydata.mdb

dim rs
set rs = server.createobject("adodb.recordset")
rs.open "select * from ", db

'''ok what has happend is we have connected to your database and we have created a recordset that holds all of the fileds now lets loop through it

if rs.eof and rs.bof then
response.write "there are no records"
else
rs.movefirst
while not rs.eof
response.write rs.fields("fieldname1") & " "
response.write rs.fields("filedname2") & "
"
rs.movenext
wend
end if
%>

any questions email me at chris.mcintosh@haysrpc.com or call at 559-490-7853

This discussion is closed to new replies.