conditional updating

I have a form with two fields tied to the same table field.

One is a display of the current value, the other is a dropdown list to select a new value.

On the form, only one of those fields is displayed based on the content of the table field.

In the update query, I want to designate which form field to bind based on the same criteria I use to display those fields.

Lets say the table name is PORC_dates and the field is date1 and the two form fields in question are datepicker1 and currentdate1.

If PORC_dates.date1 already has data in it, I don't want to update it at all. But if it has no data, then update it from datepicker1.

Is that possible?

Everything is possible. It sounds like you would need a few IF statements. It might be easier to set a variable above the insert code to get the value you want updated. If you attach the page you are working on I could take a look and give you sample code. It is a bit too complex to talk about generally and expect you to implement it.

See attached file.

I want to update PORC_decisions.batch_date depending on the following.

If PORC_decisions.batch_date already has a date in it, do nothing.

If PORC_decisions.batch_date is blank, update it from the form-select-field "batchdate."

I think you can just update line 27 to:

$UpdateQuery->bindColumn("batch_date", "t", "".($rsBatchDates->getColumnVal("Batch_Date")?"":$_POST["batch_date"]) ."", "WA_IGNORE");

When I run that code, I get "there is an error in your SQL"

I have since changed the code to"

$UpdateQuery->bindColumn("batch_date", "t", "".($rsDecisions->getColumnVal("batch_date")?"":$_POST["batch_date"]) ."", "WA_IGNORE");

As the field to check is $rsDecisions->getColumnVal("batch_date"") rather than the rsBatch_dates one.

Now when I submit, it just goes to a blank page (without updating).

Is the rsDecisions recordset code above the Update code? If you attach the page I can see the code and answer your questions more efficiently.