Data Type Question

I do a lot of work in my db apps with race timing. I use ADO with SQL Server or MSAccess. I have a hard time working with performance times (where 5:15 means a performance time of 5 minutes and 15 seconds, for instance). AS nearly as I can tell, the datetime data types refer to 'time-of-day' things which processes a little differently. As a result, when I submit this type of data I just drop it in as a string but this causes problems when doing comparison-types of things.

Can someone steer me towards a better way to work with this kind of data?

Thanks!!!varchar()|||store as seconds, so smallint

rudy|||...written code to convert to seconds when I need to process it and then convert back. I just thought there had to be an easier way.

Data type mismatch in criteria expresioin

Hi again, I'm having problems with an insert record page to insert records into a msaccess database via sql and dreamweaver mx.asp pages.

There are four date fields that can be entered (all not required), but it keep getting the

ERROR;Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

from my documentation there seems to be a known problem with msaccess and update/insert server behaviours....

Has anyone managed to overcome this issue, and if so, how ??

thanks for your help...That may be because of the Date format on the access database.
Try to insert the date in this format:
aaaa-mm-dd

______________
Paulo Gonalves|||thanks heaps...I actually got it sorted about 20 minutes before I read your reply...and you were right...I had the msaccess date formats set to an input mask that I don't think dreamweaver took a liking to...

cheers.