Saving current date and time in ASP and ACCESS

[Amcasperforu]

Hi all,

Im developing a simple web page and Im new to ASP.

I want to save the current date and time in my MS ACCESS table

I have a field in MS ACCESS and the data type is Date/Time is this correct or
do I have to have it in Text???

what should be the code here???

adoRecordset.Fields("date") = Request.Form(Now)


Is this correct??? But Im getting an error which says its expecting a string
.....


thanks for any help.

[Julian Roberts]

Try

adoRecordset.Fields("date") = Now

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Anthony Brown]

Actually the easiest way is in access to make the default value for that
column Now();

Whenever a new record is inserted then the current date and time will
automatically be entered as well.




"Amcasperforu" <webforumsuser@macromedia.com> wrote in message
news:d43aic$e4k$1@forums.macromedia.com...

> Hi all,
>
> Im developing a simple web page and Im new to ASP.
>
> I want to save the current date and time in my MS ACCESS table
>
> I have a field in MS ACCESS and the data type is Date/Time is this correct
> or
> do I have to have it in Text???
>
> what should be the code here???
>
> adoRecordset.Fields("date") = Request.Form(Now)
>
>
> Is this correct??? But Im getting an error which says its expecting a
> string
> ....
>
>
> thanks for any help.
>
>
>
>
>
>
>
>
>

[Drew]

Not to second guess you Julian, but wouldn't it be,

adoRecordset.Fields("date")=Now()

Drew

"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d43bjl$fmm$1@forums.macromedia.com...

> Try
>
> adoRecordset.Fields("date") = Now
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>
>

[Julian Roberts]

Either can be used. VB Script isn't very fussy :)

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Amcasperforu]

Thanks guys

Another one,

Any suggestion from these : ?

I'm planning to use the check box for a particular question, since checkbox is
zero to n choices, what do you suggest to be the best should be done, do I need
to create separate fields for each of the check boxes choices???

Or just a single field with a Text data type and just combine the choices
delimited with a comma (or any character) ???
If that would be the case, how should I do it to combine all the chosen
choices?

Thanks again for the immediate response.