Updating Access database

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

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.
 
Check your spelling and table name....is the table
tblJobPostings ?

Also try:

"UPDATE JobPostings SET TitleType = '::TitleType::' WHERE
(JobID=::JobID::)"
 
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
 
Hi Jennifer,
are your form fields named TitleType and JobID? - I'm guessing not :-)

Jon
Microsoft MVP - FP
 
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.
 
Back
Top