OutFront Forums
     Home    Register     Search      Help      Login    

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Follow Us
On Facebook
On Twitter
RSS
Via Email

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read
 

Add a checkbox to the DRW to Delete...

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP, PHP, and Database >> Add a checkbox to the DRW to Delete... 		Page: [1]
 
 
hhammash

 

Posts: 1064
Joined: 8/19/2002
Status: offline

  		Add a checkbox to the DRW to Delete... - 9/11/2002 17:58:03   
Hi all,

I have a DRW with 4 columns (StaffID, StaffName,Departmetn,DateJoined). I put the DRW on Spooky Diet and it is working fine.

I want to insert a new column before StaffID and place a checkbox in it.

I want to be able to check more than one record when the DRW is loaded, then Press delete key to delete the selected records.

Any help out there?

Thanks
Hisham
Spooky

 

Posts: 26723
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 9/11/2002 19:35:10   
The trick for doing that, is to make sure :

1) Each check box has the same " NAME"
2) Each check box has a Value which = the ID of the record.
3) Use IN to delete records

When you make multiple selections of checkboxes, the results are passed as a comma delimited string.

ie request.form(" name" ) = " 1,4,6,8,12"

Then, use this in a delete SQL statement : 

delete from table where ID IN (" &request.form(" name" ) &" )"


_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to hhammash)
hhammash

 

Posts: 1064
Joined: 8/19/2002
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 9/12/2002 12:25:22   
Hi Spooky,

Thank you for your reply. It is short and useful.

In my post I mentioned StaffID and other fields, I will delete the records based on StaffID. So, what I should do is:

1- Insert a new column in the DRW
2- Insert a check box (it should be one and will replicate when I browse the DRW)
3- The name of the box should be " StaffID" ? is that right?
4- The SQL should be:
delete from table where ID IN (" &request.form(" StaffID" ) &" )"
5- Shall I change the .form to the name of DRW? or just keep it .form?

When I select the check boxes to delete related records. How shall I post it to the Delete Query?

Thanks
Hisham

(in reply to hhammash)
Spooky

 

Posts: 26723
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 9/12/2002 16:29:33   

1- Insert a new column in the DRW
2- Insert a check box (it should be one and will replicate when I browse the DRW)
3- The name of the box should be " StaffID"

- The value of the box will be <%=FPFIELD(fp_rs(" StaffID" ))%> (or whatever the code is for that value)

4- The SQL should be:
delete from table where ID IN (" &request.form(" StaffID" ) &" )"
5- Shall I change the .form to the name of DRW? or just keep it .form?

Using the DRW it would be :
delete from table where ID IN (::StaffID::)
I would prefer to do that part in asp, but the DRW should be ok too.


_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to hhammash)
hhammash

 

Posts: 1064
Joined: 8/19/2002
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 9/12/2002 17:29:28   
Hi Spooky,

I did the following:

1- Created a DRW
2- Inserted a column to the left
3- Inserted a checkbox
4- Gave the values to the checkbox
5- Created the Delete query

:)

When I browse the page, it displays the DRW and everything works fine, I can see a check box next to each record. I stopped here, because I don' t know how to send the parameters to the Delete query after clicking the checkbox.

Regards
Hisham




Attachment (1)

< Message edited by hhammash -- 9/11/2002 5:39:16 PM >

(in reply to hhammash)
Spooky

 

Posts: 26723
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 9/12/2002 18:53:46   
Make sure the entire DRW is contained in a form.

Now, POST this form to a test page :

Test page : 
<%
Response.write Request.form(" StaffID" )
%>


The value returned (as a test) should be a comma delimited group of numbers. This demonstrates the return of the form values.
(StaffID is Numeric isnt it?)

Now, if the test page was a DRW with a custom SQL string, " DELETE FROM TABLE WHERE StaffID IN (::StaffID::)" the records will theoretically disappear never to be seen again.....

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

Sp:)ky


(in reply to hhammash)
hhammash

 

Posts: 1064
Joined: 8/19/2002
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 9/13/2002 2:09:36   
Thanks Spooky,

I' ll give it a try and notify you.

Thanks a lot
Hisham

(in reply to hhammash)
Cookie

 

Posts: 297
Joined: 2/7/2002
From: UK
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 12/12/2002 9:20:53   
OK, what if I don' t want to delete the records, but display them?

I have tried: 

fp_sQry=" SELECT * Deals where dealID IN (" &request.form(" mailerInput" ) &" )"


But with no luck!

Any Ideas?

Thanks

(in reply to hhammash)
rdouglass

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 12/12/2002 11:03:09   
How about:

fp_sQry=" SELECT * FROM Deals where dealID IN (" &request.form(" mailerInput" ) &" )"

:) (I do that all the time....:))

(in reply to hhammash)
Cookie

 

Posts: 297
Joined: 2/7/2002
From: UK
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 12/12/2002 11:10:57   
doh....[:' (]

thats an afternoon wasted! Been trying loads of different strings!

Thanks rdouglass, at least someones on the ball!:)

(in reply to hhammash)
rharriso

 

Posts: 28
Joined: 3/8/2002
From: Derby United Kingdom
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 12/31/2003 5:58:28   
Can anyone tell me why this doesn't work?

When I move the form tags so its only one form rather than one per record the form is not submitted at all? 
<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Internal Telephone Directory</title>
<link rel="stylesheet" type="text/css" href="http://citynet/stylesheets/citynet.css">
<meta name="Microsoft Theme" content="nhs 010, default">
</head>

<body>

<form BOTID="0" METHOD="POST" ACTION="delete.asp">
  <h1>Phone book maintenance - Update/Delete </h1>
  <table BORDER="0">
    <tr>
      <td><b><font size="2" face="Arial">  
        Search for</font></b></td>
      <td><font size="2" face="Arial"><input NAME="Criteria" VALUE="<%=Request("Criteria")%>" size="20" tabindex="1"><input TYPE="submit" value="OK"></font></td>
    </tr>
  </table>
</form>
<table width="100%" border="1">
  <thead>
  </thead>
</table><form method="POST" action="new.asp"><table width="100%" border="1">
  <thead>
    <tr>
      <td> </td>
      <td><b>id</b></td>
      <td><b>email</b></td>
      <td><b>Title</b></td>
      <td><b>FirstName</b></td>
      <td><b>LastName</b></td>
      <td><b>Dept</b></td>
      <td><b>JobTitle</b></td>
      <td><b>Extension</b></td>
      <td><b>Bleep</b></td>
      <td><b>Hidden</b></td>
      <td><b>Voicemail</b></td>
      <td> </td>
      <td> </td>
    </tr>
  </thead>
  <tbody>
    <!--webbot bot="DatabaseRegionStart" startspan
    s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
    s-columntypes="202,202,202,202,202,202,202,202,5,202,3,135,202,135,202"
    s-dataconnection="phone" b-tableformat="TRUE" b-menuformat="FALSE"
    s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
    b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
    i-ListFormat="0" b-makeform="FALSE" s-recordsource
    s-displaycolumns="id,email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail"
    s-criteria s-order
    s-sql="SELECT * FROM NCH where (hidden = NO) and (lastname like '%::Criteria::%' or Firstname like '%::Criteria::%' or Dept like '%::Criteria::%' or jobtitle like '%::Criteria::%' or email like '%::Criteria::%' or extension like '%::Criteria::%' or bleep like '%::Criteria::%' or voicemail like '%::Criteria::%' or ID like '%::Criteria::%') ORDER BY Lastname, Firstname;<br>"
    b-procedure="FALSE" clientside SuggestedExt="asp"
    s-DefaultFields="Criteria=&Criteria=&Criteria=&Criteria=&Criteria=&Criteria=&Criteria=&Criteria=&Criteria="
    s-NoRecordsFound="Sorry no matching records found." i-MaxRecords="0"
    i-GroupSize="5" BOTID="1" u-dblib="../../_fpclass/fpdblib.inc"
    u-dbrgn1="../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../_fpclass/fpdbrgn2.inc"
    tag="TBODY"
    local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.</font></td></tr>"
    preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" --><!--#include file="../../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM NCH where (hidden = NO) and (lastname like '%::Criteria::%' or Firstname like '%::Criteria::%' or Dept like '%::Criteria::%' or jobtitle like '%::Criteria::%' or email like '%::Criteria::%' or extension like '%::Criteria::%' or bleep like '%::Criteria::%' or voicemail like '%::Criteria::%' or ID like '%::Criteria::%') ORDER BY Lastname, Firstname; "
fp_sDefault="Criteria=&Criteria=&Criteria=&Criteria=&Criteria=&Criteria=&Criteria=&Criteria=&Criteria="
fp_sNoRecords="<tr><td colspan=11 align=left width=""100%"">Sorry no matching records found.</td></tr>"
fp_sDataConn="phone"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=11
fp_fCustomQuery=True
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="25535" endspan -->
    <tr>
      <td>
        
          <p><input type="checkbox" name="deleteid" value="<%=FP_FieldVal(fp_rs,"id")%>">
        <p> </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="id" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>id<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>id<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"id")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="3421" endspan -->
      </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="email" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>email<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>email<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"email")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="10376" endspan -->
      </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="Title" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>Title<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>Title<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Title")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="8773" endspan -->
      </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="FirstName" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>FirstName<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>FirstName<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"FirstName")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="18712" endspan -->
      </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="LastName" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>LastName<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>LastName<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"LastName")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="14417" endspan -->
      </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="Dept" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>Dept<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>Dept<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Dept")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="3805" endspan -->
      </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="JobTitle" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>JobTitle<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>JobTitle<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"JobTitle")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="16244" endspan -->
      </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="Extension" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>Extension<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>Extension<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Extension")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="21582" endspan -->
      </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="Bleep" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>Bleep<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>Bleep<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Bleep")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="8020" endspan -->
      </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="Hidden" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>Hidden<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>Hidden<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Hidden")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="14933" endspan -->
      </td>
      <td><!--webbot bot="DatabaseResultColumn" startspan
        s-columnnames="email,Title,FirstName,LastName,Dept,JobTitle,Extension,Bleep,Hidden,Voicemail,id,CreatedOn,CreatedBy,UpdatedOn,UpdatedBy"
        s-column="Voicemail" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
        local_preview="<font size="-1">&lt;&lt;</font>Voicemail<font size="-1">&gt;&gt;</font>"
        preview="<font size="-1">&lt;&lt;</font>Voicemail<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Voicemail")%><!--webbot
        bot="DatabaseResultColumn" i-CheckSum="20971" endspan -->
      </td>
      <td><font size="2" face="Arial"><a href="edit.asp?id=<%=FP_FieldURL(fp_rs,"id")%>">update</a></font></td>
      <td><font size="2" face="Arial"><a href="delete.asp?id=<%=FP_FieldURL(fp_rs,"id")%>">delete</a></font></td>
    </tr>
    <td>
    <input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2">
        </form>
    <!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="TRUE"
    b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="5"
    clientside tag="TBODY"
    local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><FORM><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/5]</NOBR></FORM></td></tr>"
    preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/5]</NOBR><BR></td></tr>" --><!--#include file="../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" i-CheckSum="65064" endspan -->
  </tbody>
</table>
<p align="center"><b><font face="Arial" size="2"> </font></b><font face="Arial" size="2">Last Updated <!--webbot
bot="Timestamp" S-Type="EDITED" S-Format="%d-%b-%Y" --></font></p>
</body>

</html>

(in reply to hhammash)
FrogMan

 

Posts: 108
From: Lewiston, Idaho US
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 1/30/2006 19:10:08   
Spooky,

I have been out here looking for this type of a feature. It was very easy to set up, but I am having a problem.

I have nade it all the way to the test step and I can see that the test.asp shows record numbers. But when I go back into the DRW page and click on the Database Results Properties, select Use Existing Database Connection, Record Source is selected as Table1 but I changed to Custom Query and clicked Edit. Then I entered this in the SQL Statemnt area:

delete from Table1 where ID IN ("ID")

Next I clicked the OK and then Next and the screen does not show any fields selected as shown here.

When I click the next, the choices for Table or column view show, but when I finish, there are no fields ion the output ASP page.

What have I missed?

Apprciate it.






Thumbnail Image
:)

Attachment (1)

(in reply to Spooky)
rdouglass

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 1/31/2006 8:08:28   
quote:

delete from Table1 where ID IN ("ID")


I'm by no means a DRW expert (haven't used it in quite a while) but to me it looks as tho your query wouldn't return any results (it's not a SELECT query) so there would be no fields to choose from.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to FrogMan)
FrogMan

 

Posts: 108
From: Lewiston, Idaho US
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 1/31/2006 11:11:43   
rdouglas,

Thanks for the reply. I think I need to clarify. The image I uploaded is the next screen in the sequence of setting up the Custom Query.
Here are the choices I made. From FP I placed the cursor in the previously established DRW next to the Delete check box I created (it is named ID). Next I right moused next to the Delete box and from the pop up menu I chose Database Results Properties. I left the defaults and clicked next. On the following screen I selected Custom Query and then clicked Edit. In the SQL Statement field I entered
delete from ClassifiedAdEntry where ID IN ('ID') and then clicked Verify Query and did not receive any errors. So I clicked OK and it returned to the previous Database Results Wizard Screen. I then clicked Next and that's where we are at now. No fields to display in the Database Results as depicted in my previous message.

I have gone through the Spooky's Databases>Things You Need to Know - and several other writtings of his, but nothing in reference to this issue of the Database Results Wizard not displaying Fields.

If, on the otherhand, I do not use the custom query and just go all the way through accepting the defaults, I get a nice Database Results page of everything.

I have placed here images in sequence of what I see as I go through the DRW in this instance.

As I just found out, I can only upload one image, so I have pasted all the images in sequence in one instead of five. Sorry about the quality, but I had to get it under 50K.

Does this clarify where I am at?

Thanks




Thumbnail Image
:)

Attachment (1)

(in reply to rdouglass)
rdouglass

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 1/31/2006 13:39:01   
quote:

your query wouldn't return any results


I still stick with that and have tested it. Since you're using a Custom Query that is *not* a SELECT query, there will be *no* fields to return hence you have no fields to select in the DRW.

I have confirmed this on FP 2000 running on XP Pro.

NOTE: If this is still an issue, let's start another thread since this is a FAQ.

_____________________________

Don't take you're eye off your final destination.

ASP Checkbox Function Tutorial.

(in reply to rdouglass)
FrogMan

 

Posts: 108
From: Lewiston, Idaho US
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 1/31/2006 14:00:24   
rdouglas,

Okay. Sounds good to me. New Thread.
But, looking at the SELECT issue next, that must be where I am messing up.

I am going to try something first and then I will send new thread.

Thanks

(in reply to rdouglass)
FrogMan

 

Posts: 108
From: Lewiston, Idaho US
Status: offline

  		RE: Add a checkbox to the DRW to Delete... - 1/31/2006 14:20:14   
rdouglas,

Just tried a couple things, but quick question:
How do we start a new thread and still have the reference to this one?

Thanks

(in reply to rdouglass)
Page:   [1]

All Forums >> Web Development >> ASP, PHP, and Database >> Add a checkbox to the DRW to Delete... 		Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Copyright © 2009 Thomas Brunt's OutFront Inc. All Rights Reserved.