CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> ASP

 Custom insert problem

Print topic Send  topic

Author Message

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

Posts: 273
Posted: 10/23/2012, 9:45 PM

Try something like this

John Real
CodeCharge Studio Support, Training, Consulting, Development, Web based solutions
Other Banned IDs on this Forum. jjrjr1, jjrjr2
View profile  Send private message

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

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

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

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