CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 custom SQL is not executed

Print topic Send  topic

Author Message
JohannesP

Posts: 3
Posted: 06/29/2005, 4:04 AM

Hello!
I have a serious problem with some custom SQL (on page "xxx" in the beforeShow - Event) that is not executed after i redirected the user to page "xxx" using java-script: window.open(...)

The page is loaded and the code IS executed (i inserted some code that sets a field to test, if he executes the before Show function).

The SQL IS executed, if i load the page by getting to this page by a normal link, or if i press the refresh browser button after i have been redirected!

I hope there is some solution to this problem!
_________________
mfG
JohannesP
View profile  Send private message
ju2au


Posts: 7
Posted: 06/29/2005, 5:29 AM

What does your custom code look like?
What does it do?

If it depends on GET variables, then maybe those variables weren't passed along properly by the javascript.
View profile  Send private message
JohannesP

Posts: 3
Posted: 07/01/2005, 5:43 AM

javascript code:
window.open("http://infocube.gud.siemens.at:81/CCS_Solutions/Solution_maint_onunload.php" + window.location.search, "_blank");
codechargecode is execute in the beforeshow event on the redirect page
$db = new clsDBOracle();
$SQL = "UPDATE CCS_SOLUTIONS SET EDIT_BY = NULL WHERE NAME = 'Aktuelles Datum'";
$db->query($SQL);
$db->close();
_________________
mfG
JohannesP
View profile  Send private message
JohannesP

Posts: 3
Posted: 07/04/2005, 12:45 AM

*update*
If i do a CCDLookup the before the query the edit_by field is still set - after the query: is set NULL (but NOT in the database?????)
_________________
mfG
JohannesP
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.

Web Database

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.