so...I am completely new to this and I am only doing it for a class project...kinda fun...but html sucks...anyway...
I got the drop down menu to select the right company...so it then enters the "store ID" I selected into the right place....but then on my table it shows all my stores not just the one I selected...and I need it to show only the store I selected...what do I do?????
Here is my code...
%>
</select>
<br>
<input type="Submit" value="Get store Info">
</form>
</body>
</html>
<% ELSE %>
<html>
<title>Your store inventory list</title>
<body>
<h1>Inventory List</h1>
Here is the inventory list for your store:<BR>
<form method="post" action="UpdateInventory.asp">
<input type=hidden name=storeid value=<%=Request.form("StoreID")%> >
The inventory list you chose is for store number
<%
SQL = "SELECT storeid FROM StoreManager where StoreID=" & Request.form("storeid")
set theusers=conn.execute(SQL)
response.write theusers(0)
SQL = "SELECT dbo.StoreManager.storeid, dbo.Inventory.itemid, dbo.Items.productname, dbo.Items.price, dbo.Items.cost, dbo.Items.description, dbo.Inventory.quantityonhand, dbo.Inventory.reorderpoint FROM dbo.Inventory INNER JOIN dbo.StoreManager ON dbo.Inventory.storeid = dbo.StoreManager.storeid INNER JOIN dbo.Items ON dbo.Inventory.itemid = dbo.Items.itemid" & Request.form("storemanager where storeid")
Table problems as well....
Reply With Quote
Bookmarks