"Date" as a field name in Access

an oddity

[txbakers]

I installed an ASP calendar on my site which was written in VBSCRIPT. The db it came with used "Date" as a field name. The calendar worked fine.

I needed to rewrite the code into JavaScript to integrate it into the rest of my site, and although the JS code can read from the table with the name "Date" it can't write to it,causing a syntax error. If I rename the field to "eDate" it works just fine.

I thought it was odd that it would work in VBSCRIPT but not in JS.

I did notice that the VB code didn't use a SQL statement while the JS code did. Would that be the difference?

[tomasz]

That only one thing I can say, is not to good thing to use restricted words like date, field, time etc...

I think VB understands SQL syntax as a field, but still it is not good programming practice to use those words

[jatar_k]

agreed, smacks of a reserved word problem across languages.

[txbakers]

Well, renaming the field fixed everything, JS and VB, but I thought it odd that it would work in VBSCRIPT at all.

[jatar_k]

me too but, as tomasz said, it isn't good to use restricted words. Oh well maybe the folk that made the calendar read this forum. ;)

[Xoc]

In Access, you can surround field names with square brackets in your SQL. Such as [date] or [field name]. Required for fields with spaces in the name.