C
CLS
I have been accessing a database successfully for quite a while. Now I want
to be able to edit and delete records in the same database. I had FP create a
new Results Query Page in a new sub-directory. Also had FP create several
edit files like editor, list, delete etc. I changed the Results Query Page to
send the record data to the "list page" so I would have access to the data
for editing. The "list" program gets the data but it displays all records
rather than just those I matched up with in the Results Page. So, I tried to
add code to the edit page to select and list only records that match a search
criteria. This line of code is exactly the same as that which appears in the
Results Page. The line of code is as follows:
fp_sQry="SELECT * FROM Results WHERE (countryin = '::countryin::' AND
stateprovincein = '::stateprovincein::' AND cityin = '::cityin::') ORDER BY
Timestamp ASC"
When I try to save the page, I get the following error message:
"The contents of a front page component have been modified. These contents
will be over written when you save this page."
After the save, the new code disappears and the file return to it's original
status. What am I doing wrong?
to be able to edit and delete records in the same database. I had FP create a
new Results Query Page in a new sub-directory. Also had FP create several
edit files like editor, list, delete etc. I changed the Results Query Page to
send the record data to the "list page" so I would have access to the data
for editing. The "list" program gets the data but it displays all records
rather than just those I matched up with in the Results Page. So, I tried to
add code to the edit page to select and list only records that match a search
criteria. This line of code is exactly the same as that which appears in the
Results Page. The line of code is as follows:
fp_sQry="SELECT * FROM Results WHERE (countryin = '::countryin::' AND
stateprovincein = '::stateprovincein::' AND cityin = '::cityin::') ORDER BY
Timestamp ASC"
When I try to save the page, I get the following error message:
"The contents of a front page component have been modified. These contents
will be over written when you save this page."
After the save, the new code disappears and the file return to it's original
status. What am I doing wrong?