SQL not Updating Access Database

[wk6pack]

Hi,

I have an ASP page that updates an Access 2000 database. It doesnt seem to
update the date field of the table.

Here is the SQL: Update functionline set rowno=1, enddate=#2004/06/30#
where recid = 22

I dont get an error either. When I run the query in Access, it updates it
no problem.

What is wrong with updating dates in ASP? I can update textboxes though.

thanks,
Will

[Aaron Bertrand - MVP]

Try using a standard date format, e.g.

Update functionline set rowno=1, enddate=#2004-06-30# where recid = 22

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"wk6pack" <wkwan@sd61.bc.ca> wrote in message
news:Oy$DmLcuDHA.3532@TK2MSFTNGP11.phx.gbl...

> Hi,
>
> I have an ASP page that updates an Access 2000 database. It doesnt seem

to

> update the date field of the table.
>
> Here is the SQL: Update functionline set rowno=1, enddate=#2004/06/30#
> where recid = 22
>
> I dont get an error either. When I run the query in Access, it updates it
> no problem.
>
> What is wrong with updating dates in ASP? I can update textboxes though.
>
> thanks,
> Will
>
>

[wk6pack]

Hi,

I figured it out. If you do more than one execute of a SQL statement in
your asp, you need to do a committrans.
I thought it would do that automatically for you?

anyways, it works.

thanks,
Will

"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:%23N1U%23NcuDHA.1744@TK2MSFTNGP12.phx.gbl...

> Try using a standard date format, e.g.
>
> Update functionline set rowno=1, enddate=#2004-06-30# where recid = 22
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>
>
>
> "wk6pack" <wkwan@sd61.bc.ca> wrote in message
> news:Oy$DmLcuDHA.3532@TK2MSFTNGP11.phx.gbl...

> > Hi,
> >
> > I have an ASP page that updates an Access 2000 database. It doesnt seem

> to

> > update the date field of the table.
> >
> > Here is the SQL: Update functionline set rowno=1, enddate=#2004/06/30#
> > where recid = 22
> >
> > I dont get an error either. When I run the query in Access, it updates

it

> > no problem.
> >
> > What is wrong with updating dates in ASP? I can update textboxes

though.

> >
> > thanks,
> > Will
> >
> >

>
>

[Aaron Bertrand - MVP]

> I figured it out. If you do more than one execute of a SQL statement in

> your asp, you need to do a committrans.

Umm, that's weird. I have many web sites committing many SQL statements in
single pages, and not one instance of a commtTrans command.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]