|
| |
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
 |
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
Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Yea...This is driving me insane! - 9/10/2001 22:08:00
I assume you will place into a tableID | 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::)"
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
