Delete Where UserID=($_GET['UserID']) AND Rating=ISNULL

How do you add a 2nd filter containing a null statement?

Here is the full code.

<?php
if ((((isset($_GET["btn1_x"]))?$_GET["btn1_x"]:"") != "")) {
$DeleteQuery = new WA_MySQLi_Query($xxx);
$DeleteQuery->Action = "delete";
$DeleteQuery->Table = "tblRatings";
$DeleteQuery->addFilter("UserID", "=", "i", "".($_GET['UserID']) ."");
THIS LINE -------> $DeleteQuery->addFilter("Rating", "=", "s", "''");
$DeleteQuery->execute();
$DeleteGoTo = "";
if (function_exists("rel2abs")) $DeleteGoTo = $DeleteGoTo?rel2abs($DeleteGoTo,dirname(__FILE__)):"";
$DeleteQuery->redirect($DeleteGoTo);
}
?>



tblRatings.Rating is a string, so I put an s. Is that right?

I think you could use:

$DeleteQuery->addFilter("Rating", "IS", "s", null);

The data type shouldn't really matter for a null comparison, but technically, yes 's' is for string comparisons.

<?php
if ((((isset($_GET["btn1_x"]))?$_GET["btn1_x"]:"") != "")) {
$DeleteQuery = new WA_MySQLi_Query($ThreeDW);
$DeleteQuery->Action = "delete";
$DeleteQuery->Table = "tblRatings";
$DeleteQuery->addFilter("UserID", "=", "i", "".$_SESSION['sessUserID'] ."");
$DeleteQuery->addFilter("Rating", "IS", "s", null);
$DeleteQuery->execute();
$DeleteGoTo = "AboutUs.php";
if (function_exists("rel2abs")) $DeleteGoTo = $DeleteGoTo?rel2abs($DeleteGoTo,dirname(__FILE__)):"";
$DeleteQuery->redirect($DeleteGoTo);
}
?>

Can I get FTP access to debug? You might be the first person to do a delete based on a NULL value and I might have to update the code to address it.

I really appreciate your help.

FTP information attached in Private Message

I made an update to queryobj.php that should fix the problem. It wouldn't work with IS or IS NOT comparisons and nulls for delete in the current version.

I'll do an update to DataBridge to fix the problem, but it should be fixed in your queryobj.php file if you want to download it to make sure it isn't overwritten in the meantime.

Excellent customer service. Thank you

I can help you work on your site in a screen sharing session. You explain what you want, and I do it in front of you so you can see what I'm doing and ask questions. That service is $100/hr. You can just call the number at the bottom of every page on the webassist site to schedule a meeting.

This could probably be done in a 1 hour session.