|
| |
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
 |
On-going shopping cart battle! - 9/18/2001 13:46:00
I am getting closer and closer to my goal everyday.
The goal of not buying a shopping cart system is coming true....almost.
The one thing I am getting stuck on is adding more items. I think using the UPDATE statement will work but I havent worked out all the bugs yet.I am slowly doing this but I willl be successful.
Thanks for all the help so far! ![]("http://www.frontpagewebmaster.com/ubb/smile.gif") lwpunk,
|
|
|
|
Spooky
Posts: 26617
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: On-going shopping cart battle! - 9/19/2001 20:20:00
Explain more the theory and the update statements youve tried?
| |
|
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
|
RE: On-going shopping cart battle! - 9/19/2001 20:13:00
This is what I have done...1.Page with Inventory and checkboxes(ID) for checking off what you want to order. 2.Witch is then sent to Select from ID where IN(::ID: and gives the full line of data. 3.Then I send it to the order. Using the INSERT SQL. Use hidden fields for info. 4.Then at the order page I am using Session(Username) to sort between users. No update querys have been tried yet... Any suggestions?
| |
|
|
|
Spooky
Posts: 26617
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: On-going shopping cart battle! - 9/19/2001 17:48:00
When I mean theory, I sorta mean the logic of using an "update" statement.This infers you are updating an existing record.
To do that, you will need a lot of error checking, assuming its the same user, to see what they have ordered and whats changed. I think you still go back to adding a new record for each sale/order?
| |
|
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
|
RE: On-going shopping cart battle! - 9/20/2001 23:05:00
Well,
You know more then I do when it comes to this sorta thing spooky.
But I felt a sense of "you dont think I can do it" coming from your last reply. But I will.
Everything is working accept when I query with the checkbox to get the ID of the record and the go back to get more records the checkboxes that have already been checked reset.Is there anyway I can keep the information that has already been checked and still be able to add new recods?
check it out...
http://www.stenek.com/inventory/inventory.htm
| |
|
|
|
Spooky
Posts: 26617
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: On-going shopping cart battle! - 9/21/2001 16:28:00
You can always do it! (Its just a matter of time This part is definitely where I would save 1 record per line, and place the quantity with the individual product. Its the only way really. Youd need to open your "new" record sql, and execute(sql) for each record, looping until all records are added.
| |
|
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
|
RE: On-going shopping cart battle! - 9/24/2001 20:39:00
Hey,
Spooky, thanks for the reply.I was wondering if you could explain this "looping" that you mentioned in the last reply. Is there an example somewhere or a tutorial I could look at? Thanks,
lwpunk
| |
|
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
|
RE: On-going shopping cart battle! - 9/26/2001 20:19:00
I just download a program called Webclerk. Has anyone ever heard of this or used this.Apparently you can import your data and customize a shopping cart.
I tried using it and cant seem to figure out how to import my data.
?
| |
|
|
|
Spooky
Posts: 26617
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: On-going shopping cart battle! - 9/27/2001 20:48:00
Havent tried web clerk at all? got a URL? Im trying to find you an example of updating multiple records, I think www.aspfaq.com or www.aspfaqs.com had something?
I just cant see it at the moment.
| |
|
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
|
RE: On-going shopping cart battle! - 9/27/2001 20:03:00
Hey Spooky,The webclerk URL is...
www.webclerk.com
I might have to re-do a bit of the shopping cart now. I am begining to realize a few things I cannot do...
Any more ideas? lwpunk,
| |
|
|
|
Spooky
Posts: 26617
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: On-going shopping cart battle! - 9/27/2001 16:32:00
www.webclerk.com.....of course! duh....
| |
|
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
|
RE: On-going shopping cart battle! - 9/28/2001 20:39:00
Its all over...I gave up on building my own cart.
I found a free one I can use that has even more features and it works just fine... Accept for my Global.asa. I was using Spooky login lite and now that I have that shopping cart in it gives me an error when tring to log in. It must have something to do with my global.asa Any suggestions?
| |
|
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
|
RE: On-going shopping cart battle! - 10/1/2001 20:49:00
Hey Spooky,Got it all fixed and working now. Everything is working...I Never thought it would.. anyway. Thanks for the help everyone who has help me. This message board has let me keep my job and has tought me many things. Thanks again,
Lwpunk
| |
|
|
|
Spooky
Posts: 26617
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: On-going shopping cart battle! - 10/1/2001 16:39:00
"keep my job"?Man, tough boss ![]("http://www.frontpagewebmaster.com/ubb/wink.gif")
| |
|
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
|
RE: On-going shopping cart battle! - 10/9/2001 20:11:00
Just wanted to add one more reply so I could get the flame.
| |
|
|
|
lwpunk
Posts: 93
From: Amherst
Status: offline
|
RE: On-going shopping cart battle! - 10/9/2001 20:22:00
one more
| |
|
|
|
penguinaddict
Posts: 3
From: Vallejo, CA USA
Status: offline
|
RE: On-going shopping cart battle! - 10/9/2001 16:00:00
I was just wondering.... what's this free shopping cart you speak of??? Where is it???Thanks!
| |
|
 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 
