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

How to enter data and time

Thread began 11/13/2010 7:30 pm by clive.henderson222953 | Last modified 11/18/2010 9:56 am by Jason Byrnes | 942 views | 5 replies |

clive.henderson222953

How to enter data and time

Hi
'd like the user to be able to enter a date and time on a form.
Currently my form only allows me to choose a date format
The datepicker functions OK.
But what is the best way for a user to be able to add a time
Any help appreciated.
Thnks
Clive

Sign in to reply to this post

Jason ByrnesWebAssist

When adding a form element to the page, select Text for the field type and set the vaidation type to Time.

Sign in to reply to this post

clive.henderson222953

Originally Said By: Jason Byrnes
  When adding a form element to the page, select Text for the field type and set the vaidation type to Time.  


Thanks Jason
I think your solution will allow a time field to be set up
Iwould like the user to enter an event in a calendar so typically they would enter a title,description start and end date/time
I thought there may be a way to use datepicker to select a date and perhaps adds the time afterwards in the same field e.g 21/11/2010 09:45

Hope this makes sense and you can help
Thanks Clive

Sign in to reply to this post

Jason ByrnesWebAssist

no, the date picker only allows for picking the date, you need a separate element for inputting the time.

Sign in to reply to this post

clive.henderson222953

Originally Said By: Jason Byrnes
  no, the date picker only allows for picking the date, you need a separate element for inputting the time.  




Thanks again Jason

Another question (please bear with me)

I have a table field with a which is defined as datetime in mysql.

I'm trying to get the user to enter the date and time from a form.

How would this normally be achived usingwebassist extensions?

I suppose I could set up 2 form fields
1. a date field which they could use datepicker to enter the date
2. a separate time field

How could I then amalgamate them into the into the datetime field?

Maybe I'm not even thinking along the right lines.

Any ointers really appreciated

Thanks
Clive

Sign in to reply to this post

Jason ByrnesWebAssist

you have one of two ways to go:

1) Use two separate database columns, one for date, one for time.

2) Use one date time column. The issue with using the date time column is that you need to process the date / time input in 2 ways:
a) Concatenate the two values into one,
b) convert them to the MySQL Date Time YYYY-MM-DD HH:MM:SS format

My recommendation is to use 2 separate columns.

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