Vijaya
|
Posted: 05/03/2004, 11:20 PM |
|
I am using SQL Server as database and using PHP.
My Date Columns are not getting displayed in the pages,
Label - Not Displayed
Text - Not Displayed
I have set the property
Data Type As Date
DBFormat As mm/dd/yyyy
my connnection also have Date Format mm/dd/yyyy.
When I Use Date Picker for the text box :
Default date is displayed
but when t select the record from the grid ,
in the record form the date text is blank
Thanks for the time spent
Regards
Vijaya
|
|
|
peterr
Posts: 5971
|
Posted: 05/03/2004, 11:33 PM |
|
Hi,
Please use Label but change the "Data Type" property value to "Text" and then see what will be displayed. You will probably see the date being displayed in certain format, which then should be specified in Date Format in your connection.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Vijaya
|
Posted: 05/03/2004, 11:46 PM |
|
Thanks For The Help
The Solution Is Available in The forum
Sub Date Time
Posted On 04/07/2004
|
|
|
donsafar
Posts: 90
|
Posted: 05/04/2004, 8:41 AM |
|
I believe this is the actual post - http://forums.codecharge.com/posts.php?post_id=44518
_________________
Don Safar
|
|
|
donsafar
Posts: 90
|
Posted: 05/04/2004, 1:04 PM |
|
Here is probably a better solution.
We observed that datetime values returned through the mssql functions were in a different format to that observed in Enterprise Manager / Query Analyzer.
i.e. EM said: 2002-08-16 09:58:06
PHP-MSSQL said: 16 Aug 2002 9:58
The following php.ini setting stopped this from happening:
mssql.datetimeconvert = Off
System: PHP 4.2.2, SQL Server 2000, Win 2000 Server
_________________
Don Safar
|
|
|