2. ASPRunner.NET General questions
  3. Error Description - Invalid Cast
This topic is locked

Error Description - Invalid Cast

 		3/6/2007 4:58:33 AM
ASPRunner.NET General questions
M
 mickj author

Hi

I am running Asp Runner .Net ( .net V 2.0.5)
Have built project OK from MS Access DB.
I can login OK but users page has error stating
Error description: Invalid cast from 'DateTime' to 'Double'.
If I try to " Add Record" I receive Server Runtime Error
Within the Db the date field name is called 'date ' and the Data Type is Date / Time. No other parameters set.
Has anyone any idea what this means and where to fix it?
Regards

Mick
Eugene 3/6/2007

Could you please send me your project (including project file, output directory and database backup) with this error on support@xlinesoft.com? I will investigate it on my box.
M
 		mickj author 3/6/2007

Hi Eugene,
I have just deleted all of the output files and then re-created the project and it is now working.

Sorry about that but the original flies have now gone

Regards

Mick
M
 		mickj author 3/6/2007

Hi again Eugene,

Trying to do 10 things at once and forgot to ask.
The fields I have are numeric and I have selected TOTAL.

However when the pages display there is no total except for an addition of the USer ID numbers ! !

Is this a limitation of the Trial version or have I done something wrong?

Regards

Mick
M
 		mickj author 3/7/2007

Just to update, I worked it out and this is for anyone else who has the same problem.
When choosing either TOTAL, COUNT or AVERAGE, those tags are applied to EACH field and not a global parameter, as I thought.
Select each field in the list and then select the T,C, or A attribute for that field. Repeat for all of the required fields