msomohanojr
asked on
Checkbox's Delete Command not Working Properly
I created this application which includes 5 particular database table folders. (I'll explain this better). I used the Database Interface Wizard. This creates certain pages which are called "Submission Form", "Results Page" and a Database Editor (between other but this are the main ones). All are connected to a database (in access). The Database Editor can edit or delete fields in t database. Each record has a checkbox and it's supposed to control each record particularly. When i check the checkbox to delete a record it tries to delete everyone.
Now, when I created the application with the wizard it only included one folder. I added the other ones from the same database. The original folder's Database Editor works just fine. It's the other 4 that have that particular problem (also in the UPDATE and DELETE queries). I've tried everything. Search everything. They all look identical. I have no idea what the problem could be. If anybody has an idea, let me know please. I hope I explained this well. I believe that people with experience in FrontPage and the Wizards probably would understand.
Now, when I created the application with the wizard it only included one folder. I added the other ones from the same database. The original folder's Database Editor works just fine. It's the other 4 that have that particular problem (also in the UPDATE and DELETE queries). I've tried everything. Search everything. They all look identical. I have no idea what the problem could be. If anybody has an idea, let me know please. I hope I explained this well. I believe that people with experience in FrontPage and the Wizards probably would understand.
ASKER
yes that's exactly what happens. It opens up another window and says "do you want to delete all this records". I don't know if have to check the global.asa cause i don't know exactly what i have to be on the look for. Let me give more info about it. the checkbox has the following code as a name <%=FP_FieldURL(fp_rs, "Territory Key")%>. It reads from a Key in the table which has a hyperlink also, and it's :
detail.asp?Territory+Key=<
what do you think it could be?
detail.asp?Territory+Key=<
what do you think it could be?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Remove the space in the field name.
hhammash
Remove the space in the field name.
hhammash
ASKER
thanks buuuuuuuddy jejeje
Hi,
You are welcome
hhammash
You are welcome
hhammash
When you click the checkbox before the record and hit delete, the program tries to erase the whole table instead of the particular record you checked?
Regards
hhammash