CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 [Resolved] Connection.Execute doesn't work without Response.End???

Print topic Send  topic

Author Message
Slopey

Posts: 33
Posted: 05/09/2007, 4:33 AM

Hi All,

I'm trying to do the following in the server side on-click event of a button:

  
dim SQL  
SQL = "UPDATE PendingReq SET ReqPendingStatus = 3 WHERE ReqId = " & CCGetParam("ReqId",0)  
DBConnection1.execute(SQL)  

This doesn't do anything unless I add

  
Response.End  

after the DBConnection1.execute, and if I check for errors I don't get any. The SQL statement is valid and DOES work with the response.end, but does'nt do anything without it - no error.

Help????
View profile  Send private message
Slopey

Posts: 33
Posted: 05/09/2007, 5:58 AM

Resolved - the code was executing but was being over ridden by the record's Update event, so the value was being reset. The Response.End stopped the record update firing which is why it worked with that. :)
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.

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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