close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Using a time_stamp field on Search and Results pages via DataAssist

Thread began 5/19/2014 3:34 pm by david_allen | Last modified 5/19/2014 4:57 pm by david_allen | 499 views | 4 replies |

david_allen

Using a time_stamp field on Search and Results pages via DataAssist

Regarding a time_stamp field in the db, may I check facts for the Search and the Results pages generated by DataAssist, please?

So far I am not succeeding to use that field effectively.

On the Search page, the time_stamp field is set to display as Datepicker, the default. (I tried setting it to Text, for one iteration. Did not improve things.)

On the Results page, the results displayed for the time-stamp show only the date, not the time also.


Two issues, here:

One, an entry on the Search page, in the time_stamp field (of course via Datepicker), does not return any result.

However, when using another field (a field that is entered upon Insert, a date field selected manually), results can be satisfactorily retrieved. And the display on the Results page – now visible for the time_stamp too – then shows what was entered in the failed attempt previously, to Search on the time_stamp field,.

Puzzling, of course. Can time_stamp be used as a field to search, and of course what will make it work if so?

Two, can the display on the Results page be set to show time with the date?

Thanks,

David

Sign in to reply to this post

Jason ByrnesWebAssist

A time stamp field can only be queried by exact match, so a date picker field cannot be used to query it.

a timestamp stores the data in the format:

yyyy-mm-dd hh:ii:ss

when querying the time stamp, you need to match the entire time stamp including the time portion.

a datepicker will only send the year month day portion of the date. since it doesn't include the time portion, it will not be able to make a match.


as for dis[p;laying it on the results page, it probably uses the date function and converts the format to not include the time, you could edit the formatting to include the time,

Sign in to reply to this post

david_allen

Thanks, much, Jason. That clarifies.

And a search, to w3c, showed formats. Adding

h:i:sa

in the existing date function, did it. (Though I am a little mystified why there is an 'n,' rather than an 'm,' for the month, in the existing function … but it works.)

Again thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

n for the month is numeric representation without leading 0s:
http://php.net/manual/en/function.date.php


so it will show January as:
1

instead of:
01

Sign in to reply to this post

david_allen

Right. And that PHP documentation is now top of my tech bookmarks. Now it is clear where to find.

Thanks.

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