-----Original Message-----
I have a database. I used FrontPage 2002 DRW. I
created an editor that works great. On the "results"
page I would like to add a few fields for the
viewer to add comments to the record. When I create the
update form it works fine to add the new comments, but
all of the other data in the record is deleted.
This is very difficult to diagnose with only the
information you've given. However, you need to make sure
that your UPDATE operation includes values for all the
field names you specify.
Or if you use the editor to edit the record, the
comments disapper. What am I missing?
Again, make sure that your UPDATE operation includes
values for all the field names you specify.
For example, if your UPDATE statement ends up being
UPDATE mytable SET name = '', address = '', comment
= 'howdy' WHERE recid = 12
that's going to wipe out the name and address fields. If
that's not what you want, you need to query the table
first, to get default values
UPDATE mytable SET name = 'Jim', address = 'Phoenix',
comment = 'howdy' WHERE recid = 12
or change the SQL statement to
UPDATE mytable SET comment = 'howdy' WHERE recid = 12
Also, I feel compelled to note that you are perilously
close to something that requires some ifs, some elses,
and some data handling. In other words, custom
programming.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
