Date field

skc · Jan 15, 2004

I use '::xxx::' for text in my custom SQL when saving to a
database.

What about date, number, memo format fields???

Thanks,

skc

MD WebsUnlimited.com · Jan 15, 2004

The ::FieldName:: is the delimiters that are replaced by the field name. For
a date value SQL wants the value to be in hash marks
#::FieldName::#

skc · Jan 15, 2004

Any other formats I should be aware of?

What about number, Memo fields??

Thanks

Thomas A. Rowe · Jan 15, 2004

See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vtoriVBScript.asp

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

Kathleen Anderson [MVP - FP] · Jan 15, 2004