CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 Custom insert problem

Print topic Send  topic

Author Message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.