close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

ERROR: "incorrect DOUBLE value"

Thread began 1/19/2022 10:06 am by yogastudents362523 | Last modified 1/19/2022 5:11 pm by Ray Borduin | 41 views | 4 replies |

yogastudents362523

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.

Attached Files
presenter_switchboard_data_update.php
Sign in to reply to this post

Ray BorduinWebAssist

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']

Sign in to reply to this post
Did this help? Tips are appreciated...

yogastudents362523

is $_SESSION['invalid'] the correct substitution for $_GET["invalid"]?

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

Sign in to reply to this post

yogastudents362523

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...