Updating a DB

[Matt]

Hi,

I am trying to update a db field that is formatted as a
date/time field. Using fp's wizard what should I type
into the custom query box to update that field? The form
field is called Time and the db column is also called
Time... So it should look something like this right?

UPDATE MyTable
SET Time=::Time::
WHERE ID=::ID::

Thanks,

Matt

 

[Thomas A. Rowe]

Time is a reserve word, rename the field to another name.

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

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

 

[Matt]

Which field needs to be changed the db column or the form
box? After that is completed would the ::Tme:: with no 's
be right?

Thanks,

Matt

 

[Matt]

Are Month, Day, Year reserved words too?

Matt

-----Original Message-----
Time is a reserve word, rename the field to another name.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp




.

 

[Thomas A. Rowe]

Yes.

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

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

 

[Thomas A. Rowe]

Try using something similar to:

Just call the fields anything but: Time, Month, Day, Date, Now, Year.

User will never see the field names, so you could name them like:

MattTime, MattMonth, MattDay, MattDate, MattNow, MattYear

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

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

 

[Matt]

Thanks Thomas,

Matt

-----Original Message-----
Try using something similar to:

Just call the fields anything but: Time, Month, Day, Date, Now, Year.

User will never see the field names, so you could name them like:

MattTime, MattMonth, MattDay, MattDate, MattNow, MattYear

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp




.

 

[Jon Spivey]

Hi,

It's probably going to be easier to change your query then change the
database. In wihich case your query would be
UPDATE MyTable
SET [Time]=::Time::
WHERE ID=::ID::

Putting [ ] around a reserved word makes it OK.

 

[Matt]

Thanks Jon, it's working now..

Matt

-----Original Message-----
Hi,

It's probably going to be easier to change your query then change the
database. In wihich case your query would be
UPDATE MyTable
SET [Time]=::Time::
WHERE ID=::ID::

Putting [ ] around a reserved word makes it OK.

--
Cheers,
Jon
Microsoft MVP

Hi,

I am trying to update a db field that is formatted as a
date/time field. Using fp's wizard what should I type
into the custom query box to update that field? The form
field is called Time and the db column is also called
Time... So it should look something like this right?

UPDATE MyTable
SET Time=::Time::
WHERE ID=::ID::

Thanks,

Matt

.