Waspman
Posts: 948
|
Posted: 10/23/2012, 9:15 AM |
|
Haven't used ASP for over 7 years so..
I'm trying to fix this script but the despatched date just doesn't get updated.
DBConnection1.Execute ("UPDATE orders SET Despatched=1, item_despatched = #" & Now() & "# where cart_session_id='"& Request.QueryString("cartID") &"'")
Any help would be appreciated.
:)
(it's an Access db)
_________________
http://www.waspmedia.co.uk |
|
|
bannedone
Posts: 273
|
Posted: 10/23/2012, 9:45 PM |
|
Try something like this
http://stackoverflow.com/questions/4488383/set-a-dateti...se-field-to-now
_________________
John Real
CodeCharge Studio Support, Training, Consulting, Development, Web based solutions
http://realsites.biz
http://ccselite.com
Other Banned IDs on this Forum. jjrjr1, jjrjr2 |
|
|
Waspman
Posts: 948
|
Posted: 10/24/2012, 12:11 AM |
|
Thanks Bannedone, I made it work using Date()
But here's a funny thing. Just got back to work and opened the project and all custom code on that page has been removed.
There were several labels doing lookups for their content and the custom update script.
Sometime CCS has a mind of it's own. haha
_________________
http://www.waspmedia.co.uk |
|
|
|