General discussion

Locked

interactive database

By svant ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

interactive database

by limatik In reply to interactive database

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.

Collapse -

interactive database

by svant In reply to interactive database

The question was auto-closed by TechRepublic

Collapse -

interactive database

by yungthrilla43 In reply to interactive database

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 <tablename>", 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") & "<br>"
rs.movenext
wend
end if
%>

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

Collapse -

interactive database

by svant In reply to interactive database

The question was auto-closed by TechRepublic

Collapse -

interactive database

by svant In reply to interactive database

This question was auto closed due to inactivity

Back to IT Employment Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums