-----Original Message-----
I have a probelm with the time stamp field in an asp page
that displays database results.
The timestamp field is in the database, and it is also
added to the database results region together with all
the other fields.
All the fields show except for the timestamp which comes
empty. I did select the format already in the database
under design view but still does not show.
You may need to modify your SQL statement to enclose the
field name "timestamp" in square brackets, as in
[timestamp].
Refer to MSKB article 289317
http://support.microsoft.com/default.aspx?scid=kb;en-
us;289317
which, although not an exact match, may be close enough.
BTW, date formats you specify in Access have no effect on
the DRW. To format a date, you must code the field like:
Format([timestamp],"dd-MMM-yyyy") AS fmtdate
in your SQL statement, and then display the fmtdate value
rather than the timestamp value.
Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
