gazzzzzza Posted June 22, 2004 Posted June 22, 2004 I need to use/store the basket id as part of my order to allow my modifications to work and once the order has gone through, it gets changed into the actual order id. this works fine BUT i am worried that at some point there may be a crossover between order_id and csutomers_basket_id and this may mess up my system. i need to know how high the basket id could go i think - so i could set the order id at this (so it will go up from this and therefore have no crossover) i am having trouble with the basket id though as it seems to go back to 0 every now and again. anyone know when and why it does this? i hope someone understands my problem. Please note: this has nothing to do with the default operation of oscommerce - this is purely to allow my modification to work. i just need to understand how the basket id works basically. if anyone has a suggestion how i can keep these numbers from crossinbg over then please post it. it will be greatfully received. thanks in advance :D always here to offer some useless advice....
Mark Evans Posted June 22, 2004 Posted June 22, 2004 i need to know how high the basket id could go i think - so i could set the order id at this (so it will go up from this and therefore have no crossover) The maximum range of an INT field is 2147483647 Note: The order id is also INT so also has a maximum value of 2147483647 Mark Evans osCommerce Monkey & Lead Guitarist for "Sparky + the Monkeys" (Album on sale in all good record shops) --------------------------------------- Software is like sex: It's better when it's free. (Linus Torvalds)
gazzzzzza Posted June 23, 2004 Author Posted June 23, 2004 ok do you know what it goes up to (or why) before it resets because i have had a customer basket id of around 300 but now it is back at 70 again and I did not reset it. I am hoping it rests at a certain amount but I cannot see that it would looking at the database it should just increment continually. thanks for the reply :D always here to offer some useless advice....
gazzzzzza Posted June 23, 2004 Author Posted June 23, 2004 i think you forgot to post the useful part of your post?? :huh: always here to offer some useless advice....
Recommended Posts
Archived
This topic is now archived and is closed to further replies.