CodeCharge Studio
search Register Login  

Visual Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 calling a stored procedure

Print topic Send  topic

Author Message
peshao

Posts: 17
Posted: 12/18/2012, 5:13 PM

i need to call a stored procedure in a before show event. I tried to do this in a before show event:

$db = new clsDBlocal();
$SQL = "call update";
$db->query($SQL);
$db->close();

but nothing happens

any clue?

The stored procedure just do a cumulative sum for some records.
View profile  Send private message
peshao

Posts: 17
Posted: 12/20/2012, 1:22 PM

I think is working but i realize that i am using a user Variable @x into the SP. The problem is when i update a table the variable take a number (ID) that is used by the SP after (first an update, and then the SP), work perfect in phpadmin or other mysql admin program, but seem like the variable @x dont take the ID when i do an update via web (codecharge generate page)...Why? any help? :(
View profile  Send private message
peshao

Posts: 17
Posted: 12/20/2012, 3:00 PM

i was look for a solution and i found a very similar case in this post http://forums.codecharge.com/posts.php?post_id=82711

i am not sure how to do it in PHP and my triggers do not work when i update the table. any help pls?
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.