This topic is locked

4.1 image and date issues

10/30/2006 6:51:06 AM
ASPRunnerPro General questions
M
maurello author

Hi,
I just upgraded to version 4.1 and unfortunately some fields are not diplayed correctly anymore.
First of all images are now showed as a small black and white square with 0 and 1 inside, instead the pictures I could see before the upgrade.
Second the dates are now a mess. I used shortdate as datetype, but now part of the year disappeared. Example: Before --> 01/12/2003 ... Now --> 01-Dec-3.
I use SQL Server 2005 as database.
Please help with this, because I already tried to fix this with the new editor, but everything seems to be in correctly place (as it was before the upgrade), but the application does not work as before.

Sergey Kornilov admin 10/30/2006

Mauro,
just in case make sure you have correct regional settings selected.
If this doesn't help send me your project file, generated files and database dump for investigation.

M
maurello author 10/31/2006

Mauro,

just in case make sure you have correct regional settings selected.
If this doesn't help send me your project file, generated files and database dump for investigation.


The date issue was indeed a regional setting problem.
The image datatype does not work. I had to change it to file-based image to fix the problem. This is something I had to do anyway to improve the performance, so no big deal.

Sergey Kornilov admin 11/1/2006

Tell me what is the image field datatype in the database and what are View/Edit settings in ASPRunnerPro. This could be a misconfiguration issue.