Date field

[skc]

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]

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]

Any other formats I should be aware of?

What about number, Memo fields??

Thanks

 

[Thomas A. Rowe]

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]]

And http://support.microsoft.com/default.aspx?scid=kb;[LN];306430