Delete all button

Hi buddy,
from the visual editor, on the list page, insert a new button:
http://xlinesoft.com/phprunner/docs/inserting_button.htm
In the "Client before" section type the code for a confirm message.
In the "Server" section type the code, using a query, to delete all records.
In the "Client after" section type the code for alert the user with a message: "all records deleted".

This is the part I'm having a problem with.
---

In the "Server" section type the code, using a query, to delete all records.

---
I saw another post indicating I should use:
if request.querystring("delete")="all" then

dbConnection.Execute "delete from Source"
but cannot seem to get the syntax to work right. I get
syntax error, unexpected T_STRING, expecting '(' in line 2
Thanks for the help
Buddy

If you are using PHPrunner and not ASPrunner:
Client before:

Server:

Client after:

Thanks cgphp.
The Client before pops up the window ok, but no records are deleted. Tried IE and Firefox.
I appreciate your help
Buddy

Try this for the server section:

Thanks but same result. No records are deleted.
I'm assuming $strTableName is changed to $strSource although no records were deleted either way.
Buddy

Try this non-parametric solution:

Still no result after clicking OK in popup.
Buddy

Probably, there are some errors in your app.

Run firebug before click the button and check the debug info.

Firebug returns:
JSON.parse

throw new SyntaxError('JSON.parse');};}}());
I should have mentioned before that I have "Before record deleted" event that adds the record to another table. Is it possible that is what may be causing the problem?
Event code is:
{

global $conn;

$str = "select * from Source where ".$where;

$rs = db_query($str,$conn);

$data = db_fetcharray($rs);
$strSQLInsert = "insert into AllData (Company,First,Last,Email,Website,Salutation,Middle,Suffix,Title,Function,Phone,Mobile,Fax,Address1,Address2,Address3,City,State,Zip,Country,Campaign,Listset,Industry) values ('".$data["Company"]."','".$data["First"]."', '".$data["Last"]."', '".($value = $data["First"].''.$data["Last"]."@".$data["Website"])."', '".$data["Website"]."','".$data["Salutation"]."','".$data["Middle"]."','".$data["Suffix"]."','".$data["Title"]."','".$data["Function"]."','".$data["Phone"]."','".$data["Mobile"]."','".$data["Fax"]."','".$data["Address1"]."','".$data["Address2"]."','".$data["Address3"]."','".$data["City"]."','".$data["State"]."','".$data["Zip"]."','".$data["Country"]."','".$data["Campaign"]."','".$data["Listset"]."','".$data["Industry"]."')";
db_exec($strSQLInsert,$conn);
return true;

}

I deleted that event and got the same result.

Post a demo without the "Before record deleted" event set.