Database Results - No Records Returned

[Sharon]

I have an Access database in FP that I want to update. I
have the update page created with a custom query (see
next).

UPDATE bios
SET FName='::FName::'
WHERE FName="'FName'"

My problem is this... when I submit a record, it returns a
message "No Records Returned" and the record is not
updated. Is this because the database table is not
closing, or moving to the next record so that the change
cannot be saved? If so, what do I need to add to the code
above to achieve this?

Thanks in advance for any help offered.

 

[dave]

Theres an extra quote?

UPDATE bios
SET FName='::FName::'
WHERE FName='::xxxxx::'

Are you using 2 form inputs for submitting a change?
if so - youll need 2 as above

 

[Sharon]

I finally got the form submission to update a single field
in a record. I have a form that send the data to an
update page that contains a database results field. The
form has this code in each textbox (with the " " area
naming the field in the record in the database).

<%request=("FName")%>

Then this form is set to send the data to the page with
the database results field. That form is set with a
custom query that is like this:

UPDATE table
SET FName='::FName::', LName='::LName::'
WHERE ID=::ID::

The ID field is an autonumber field.

So far I have been able to get the FName field to update,
but have not been able to update any other fields in the
record.

It should update both the first name field and the last
name field, but it only does the first name field.

Thanks for replying, and I hope you have an idea for me.

Sharon