Updating Access database

[Jennifer]

I am creating a site with FP2003. I have an .asp page
where folks can update a record.

Using the DRW, I created my update query.

UPDATE JobPostings SET TitleType=::TitleType:: WHERE
JobID=::JobID::
(TitleType is a text field; JobID is an Autonumber field)

I have set default values for each of these fields within
the DRW.

When I execute the page I get the error
message "Description: No value given for one or more
required parameters."

I have no idea what I am doing wrong and it's driving me
crazy. Any help would be greatly appreciated.

 

[Net55]

Check your spelling and table name....is the table
tblJobPostings ?

Also try:

"UPDATE JobPostings SET TitleType = '::TitleType::' WHERE
(JobID=::JobID:"

 

[Mark Fitzpatrick]

Because TitleType is a text field, any values entered need to be in a string
format. You do this by enclosing the value to be passed with single quotes.

UPDATE JobPostings SET TitleType='::TitleType::' WHERE JobID=::JobID::


Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[Jennifer]

I've done that and I still get the errors. Any other
thoughts?

 

[Jon]

Hi Jennifer,
are your form fields named TitleType and JobID? - I'm guessing not

Jon
Microsoft MVP - FP

 

[Jennifer]

Jon- Yes, my form fields are named TitleType and JobID.

 

[Jennifer]

Ok, so now I can the item to update, but it changing ALL
the records, not just the one I want to update.

Again, the update query reads:
UPDATE JobPostings SET TitleType='::TitleType::' WHERE
JobID=::JobID::

All help is appreciated.