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

Truncated incorrect DOUBLE value

Thread began 11/13/2018 9:48 am by vernon webb | Last modified 11/14/2018 1:23 pm by Ray Borduin | 150 views | 8 replies |

vernon webb

Truncated incorrect DOUBLE value

When select multiple records to search I get the error message:

Truncated incorrect DOUBLE value:

Sign in to reply to this post

Ray BorduinWebAssist

I'm on vacation and I don't have access to your FTP information or the login for your site. Please reply with that information in the private area and I'll take a look.

This error means that you have the data type set for a recordset set to an integer or number value and you are passing in text. If you attached a copy of the page that shows the error I could probably tell from that as well.

Sign in to reply to this post

vernon webb

I have a few things to work on today so am hoping I don't need a lot of help. However the FTP is as follows:

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

Ray BorduinWebAssist

Please send the login information for the site itself. Also attach the results page, I think that is the one showing the error.

Sign in to reply to this post

vernon webb

here you go

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

Ray BorduinWebAssist

In your file: admin/plugins/clientcompany_clientname.php you have:

php:
<option value=" ">Please select one..</option>


It expects a number to be passed in for the contact to be a number and you are passing a space. You just have to update it to:

php:
<option value="">Please select one..</option>


since blank values are ignored. I've updated it for you.

Sign in to reply to this post

vernon webb

Disregard my last message here, I fixed this

Sign in to reply to this post

vernon webb

Ok so I made a change here because it wasn't working at all and now it's broke what you did.
I added an All option on line 290:

<option value="" selected="selected">All..</option>

The reason I've added it is if nothing is selected it was returning no results on the results page. But now that I added that, selecting Active or Inactive in the Client Status no longer works.

Sign in to reply to this post

Ray BorduinWebAssist

It looks like you made an update to the page without downloading the page that I fixed first and undid my changes. I have fixed it again now. Please make sure to download the page before making any changes so that this doesn't happen again.

Sign in to reply to this post

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...