Yea...This is driving me insane! (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

lwpunk -> Yea...This is driving me insane! (9/10/2001 13:06:00)

I have been working on the checkbox thing for quite some time now.
www.stenek.com/inventory/inventory.htm
If you would like to check it out.
I just need each checkbox to read more then just one value.
And if I make it take just the ID value and send it through my insert SQL statement I dont know how to turn the actual ID# into the record info.
Spooky wrote this,
----
The suggestion I make, is that you only send the ID of the record then use that ID later in the piece to retrieve the record details.
ie

Select * from products where ID IN(1,2,3,5,7)

Thats the difficulty youll strike, because wahtever we do here, carts are WAY more complicated that anything I could discus here

----
I know I can do this...
Please help,

Lwpunk




Spooky -> RE: Yea...This is driving me insane! (9/10/2001 22:08:00)

I assume you will place into a table

ID | OrderBy | OrderedItem

So, you will now know Person "a" has ordered 1,2,3,4,5

You could do this either as 1 input record or 5 (add to database)

Any further queries, to find out what the customer ordered, would demand a query of "OrderedItem" and then use that value to query the "where ProductID IN (::OrderedItem::)"



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
1.0625