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

UNABLE TO UPDATE DATABASE WITH CORRECTLY FORMAT DATE YYYY-MM-DD

Thread began 10/31/2019 12:06 pm by software.current355386 | Last modified 11/01/2019 8:38 pm by Ray Borduin | 56 views | 9 replies |

software.current355386

UNABLE TO UPDATE DATABASE WITH CORRECTLY FORMAT DATE YYYY-MM-DD

looked though forum posts, tried several of the solutions suggested without success can you help please


dbmReviews_update

datepicker used
can get it to display dd/mm/yyyy ok
field initially null
trying to update date yyyy-mm-dd so sorting works correctly all it puts in is 0000 -00-00

Sign in to reply to this post

Ray BorduinWebAssist

Your update server behavior has the data type for the date field set to be number. Set it to date and the formatting should be done properly to allow the insert and updates to take place.

Sign in to reply to this post

software.current355386

PLEASE HOW DO U. DO THAT, I DONT WANT TO CAUSE PROBLEMS

Sign in to reply to this post

Ray BorduinWebAssist

Double click on the insert or update server behavior. Then click the second tab to update the column bindings. Select the date column and choose "Date" from the column type list below.

Sign in to reply to this post

software.current355386

done that

UPDATE: format looks ok indatepicker
DETAIL: date shoes as 1/1/1970 ur year shown a s -0001

IJUST CANT WORKIT OUT.. I SUSPECT ITS SOMETHING SO SIMPLE I HAVE FORGOTTEN TO DO

HELP!!!!

Sign in to reply to this post

Ray BorduinWebAssist

The Submit as value for that column is still set to "Double"... it has to be updated to "Date"

Sign in to reply to this post

software.current355386

6found corruption an live site ,deleted and r=uploded agin still living problems

Sign in to reply to this post

Ray BorduinWebAssist

Highlight the column you are updating and see what is displayed in the "Save As" list below. It should be set to "Date".

Sign in to reply to this post

software.current355386

c pm

Sign in to reply to this post

Ray BorduinWebAssist

This is about the Update server behavior and the data type that you are submitting. On the page it is set to a double, but you want to submit a Date.

1) Open up the update server behavior
2) Select the date column that isn't updating properly
3) Choose "Date" from the Save As select list on the bottom of that page
4) Click OK to save your changes
5) Upload the page to your site

If you still have issues, please attach the actual .php page to your reply to this thread and I can open it with Dreamweaver directly. Please mention the column name you are looking at so I can be sure we are looking at the same thing.

Sign in to reply to this post
loading

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