2. PHPRunner General questions
  3. Using a button to execute CustomQuery
This topic is locked

Using a button to execute CustomQuery

 		6/24/2010 8:33:53 PM
PHPRunner General questions
S
 salus1 authorDevClub member

I created a button on a list page that I want to execute a custom SQL query.
I cleared the Client Before and Client After event code.
I set the Server event code to the following...

____
$sql = "Insert into requests (CustomerId,RequestStatus) values ('100023','open')";

CustomQuery($sql);

___
The syntax checker indicates no problems but the query does not add a record to the requests table.
Does anyone have any ideas as to what I am missing?
A
 		ann 6/25/2010

Hi,
It's difficult to tell you what's happening without seeing actual files.

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error. 'Demo Account' button can be found on the last screen in the program.
S
 		salus1 authorDevClub member 6/25/2010

Hi Ann,

Thanks for your reply. In order to recreate the error using a DEMO account I need a MySQL database to connect to. Is there a database available for DEMO accounts?

Thanks!
J
 		Jane 6/25/2010

PHPRunner re-create your database on the Demo Account and point your fiels to this database.
S
 		salus1 authorDevClub member 6/25/2010

Hi Jane,

In order to recreate the database I need a database server. Is there a MySQL database server available to DEMO accounts that I can I use to recreate the database on?

Thanks
J
 		joker 6/25/2010

Salus 1,
I believe when you publish to the DEMO account there is a checkbox to copy source tables. Once you have done this, your tables should be published to http://demo.asprunner.net/Account/Projects_list.aspx
I think that's all i did...