Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Checkbox's Delete Command not Working Properly

Posted on 2003-03-24
6
Medium Priority
?
148 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
  • 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
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
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…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…
Suggested Courses
Course of the Month13 days, 7 hours left to enroll

581 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