addfilter

On line 21 of the attached file, I am trying to filter on two fields, one of which involves a substring.

I am getting
"Recoverable fatal error: Object of class WA_MySQLi_RS could not be converted to string in /home/w72w9xoqmrbx/public_html/webassist/mysqli/queryobj.php on line 340."

What is the correct syntax for what I am trying to do?

On line 19 you have:
$UpdateQuery->Table = $rsTemp;

That should be a table name like:
$UpdateQuery->Table = "PORC_decisions";

Whoops, I forgot I tried a different approach earlier and forgot to change it back.

I changed the table name, and no longer get any errors, but it is not updating the table.

Is my syntax correct on the substring, etc.

I am trying to extract 2020 out of 1234_2020_1234 and also filter on PORC_class great than "".

$UpdateQuery->addFilter("substring(record_number,6,4)", "=", "s", "".((isset($_POST["UpdateYear"]))?$_POST["UpdateYear"]:"") ." AND PORC_class>''");

No, that is not correct.

addFilter(column,comparison,type,value);

So the first argument should be a column name.

You can't add an AND to do multiple column comparisons you should add multiple addFilter() rows.

So is there anyway to filter on substring(record_number,6,4)?

Yes, that would be the filter value. You have it in the place of the column name.

So...

$UpdateQuery->addFilter("record_number", "=", "s", "".substring(record_number,6,4) = ((isset($_POST["UpdateYear"]))?$_POST["UpdateYear"]:"");

?

That doesn't look right. I'm not sure what you are trying to do with the value:

"".substring(record_number,6,4) = ((isset($_POST["UpdateYear"]))?$_POST["UpdateYear"]:""

Where does the UpdateYear posted value come in?

I would think it would be something like:
$UpdateQuery->addFilter("record_number", "=", "s", "".substring(record_number,6,4) ."");

I want to update the records where substring(record_number,6,4) is equal to the $_POST["UpdateYear"]

Not filter on the whole "record_number" field.

That is easily done in Visual Basic for Access, but sql doesn't seem to accommodate that.

I think I'll need a phone call to understand what you are trying to do.

I'm starting to understand though... It might be:

$UpdateQuery->addFilter("substring(record_number,5,4)", "=", "s", "".((isset($_POST["UpdateYear"]))?$_POST["UpdateYear"]:"") ."");