Basically I have a product system where on one page it pulls each product from the database, and assigns individual url's for the next aspx page.
But I can't figure out how to pull that variable from the url so that it can display the correct product info on the viewing product aspx page.
[code=asp]<script runat="server">
sub Page_Load
dim msaccessconnect ,query,database communication,r eaddatabase
msaccessconnect = New OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;data source=" & Server.MapPath( "Database.mdb") )
msaccessconnect .Open()
dim id As
query = "SELECT * FROM Products WHERE Product_ID="
databasecommuni cation=New OleDbCommand(qu ery,msaccesscon nect)
readdatabase=da tabasecommunica tion.ExecuteRea der()
Products.DataSo urce = readdatabase
Products.DataBi nd()
readdatabase.Cl ose()
msaccessconnect .Close()
end sub
</script>[/code]
I'd really appreciate any help anyone can give me! Thanks!
But I can't figure out how to pull that variable from the url so that it can display the correct product info on the viewing product aspx page.
[code=asp]<script runat="server">
sub Page_Load
dim msaccessconnect ,query,database communication,r eaddatabase
msaccessconnect = New OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;data source=" & Server.MapPath( "Database.mdb") )
msaccessconnect .Open()
dim id As
query = "SELECT * FROM Products WHERE Product_ID="
databasecommuni cation=New OleDbCommand(qu ery,msaccesscon nect)
readdatabase=da tabasecommunica tion.ExecuteRea der()
Products.DataSo urce = readdatabase
Products.DataBi nd()
readdatabase.Cl ose()
msaccessconnect .Close()
end sub
</script>[/code]
I'd really appreciate any help anyone can give me! Thanks!