ERROR: "incorrect DOUBLE value"

Hello,

When Presenters first register for the site, they provide only first and last names and usernames and passwords. These credentials are stored in the database, and they can then access the site.

I of course need further information from them, and so have used DataAssist to create a:

presenter_switchboard_data_update.php

page to update the same database with this further info.

But unfortunately, as soon as I hit the button to hopefully update the given record with this newer information, I get the above error.


If I use DataAssist to generate an Insert Page with exactly the same listing of fields etc., that page creates and works OK, but I of course get a new record in the database, where I only really want to update.

I am usng the SecurityAssistID as the paramemter to bind by.

I attach the relevant file, if that helps.

Thank you.

This page is set up to filter and update based on the value:
$_GET['ID']

you aren't passing that value into the page, so that is why it gives the error. You probably just have to update any references on that page from:
$_GET['ID']

to:
$_SESSION['SecurityAssist_ID']

Hello,

Problem not yet resolved.

In summary:
a hidden field is in the generated form whose code is:

<input type="hidden" name="WADAUpdateRecordID" id="WADAUpdateRecordID" value="<?php echo((isset($_GET["invalid"])?ValidatedField("presenterswitchboarddataupdate","WADAUpdateRecordID"):$_GET["ID"])); ?>" />

I tried changing that last $_GET["ID"] to $_SESSION['SecurityAssist_ID']
but that only gave me that:
"This page isn't working right now" error.

A large number of coding of:
echo((isset($_GET["invalid"])
exist above that dynamic text. To what should I alter these?
I tried changing them all to $_SESSION['invalid']
but perhaps I was not careful enough in doing so.

Could you confirm that $_SESSION['invalid'] is a valid substitution?

I will try it again, but not sure that is correct.

Sorry for trouble.
KAB

Just to be clear:
I did also alter the Select query against the database to reflect $_SESSION['SecurityAssist_ID']
pushing the Test button gets "No data", and also does not offer me the chance to input a test value.
But since the "Simple" page will not open and gives a message that it will not do so because the query is to complex, I did not see that, originally, as a source of concern.
Thank you
KAB

I took a look at the page and the connection include was below the update code. I moved it above and the page seems to work now.