?
Solved

Checkbox's Delete Command not Working Properly

Posted on 2003-03-24
6
Medium Priority
?
147 Views
Last Modified: 2013-12-24
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.  
0
Comment
Question by:msomohanojr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 14

Expert Comment

by:hhammash
ID: 8196461
Hi,

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
0
 

Author Comment

by:msomohanojr
ID: 8196967
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=<%=FP_FieldURL(fp_rs,"Territory Key")%>

what do you think it could be?
0
 
LVL 14

Accepted Solution

by:
hhammash earned 150 total points
ID: 8197013
Hi,

Change the field name in the database (ACCESS):
From
Territory Key
To
TerritoryKey

Leave out the spaces then re-do the Database Results Wizard and let me know.

Regards
hhammash
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 14

Expert Comment

by:hhammash
ID: 8197016
Hi,

Remove the space in the field name.

hhammash
0
 

Author Comment

by:msomohanojr
ID: 8203908
thanks buuuuuuuddy jejeje
0
 
LVL 14

Expert Comment

by:hhammash
ID: 8203942
Hi,

You are welcome

hhammash
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…
Suggested Courses

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question