Update Memo field in Access via Frontpage asp page

[jezmondo]

I have a range of .asp pages developed in Frontpage which
filter results of a query down to the one the user wishes
to update. Everything works without error. However, when I
look at the underlying Access db, all of the memo fields
(some of which contained data) have been overwritten with
the default value.

All other fields: Dates, Boolean, Text & Numbers update
correctly. There just appears to be an issue with the Memo
fields.

My custom query is similar to below where ProductName is a
Text field, ProductCost is a Number field, InStock is a
Boolean and ProdComments is a Memo field;

UPDATE Product SET [ProductName]=':roductName::',
[ProductCost]=:roductCost::, [InStock]=::InStock,
[ProdComments]=':rodComments::' WHERE [ProductId]
=':roductId::'

Any help, much appreciated

 

[Noconi]

I would suggest that you look in the code at the update.asp page. It sounds like, perhaps you have a discrepency in the field name from the edit page to the update page perhaps. The value of your ProdComments field isn't being passed properly through the update script to the database. I recently had something very similar happen when adding a new record - the values of two fields were not being added to the database. I didn't get an error, but it turned out that the field names in the new.asp page and the database weren't exactly the same.

Tiffany

Microsoft MVP - FrontPage

http://www.at-frontpage.com

http://www.anyfrontpage.com

http://www.frontpage-webtemplates.com