Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 5th, 2004, 03:52 PM
Friend of Wrox
 
Join Date: Jul 2004
Location: , , .
Posts: 119
Thanks: 0
Thanked 0 Times in 0 Posts
Default text boxes do not disappear in an asp

When the user hits delete button, the text boxes assigned
do not disapper from the web, but records get deleted from database.
I want text boxes to disappear from the web.

  if Request.Form("txtMode")="R" then
   ' objHistoryRate.Requery
    delFrom = Request.Form("txtdelFrom")
    delTo = Request.Form("txtdelTo")
    delRate = Request.Form("txtdelRate")

   ' strDel = " delete from tblCustRate "&_
            '" where iEmpID = " & iEmpID &_
            '" and iTaskiD = " & iTaskID&_
            '" and iProjDetiD = " & iProjDetID&_
            '" and dtRateFrom ='" & delFrom& "'" &_
            '" and dtRateTo ='" & delTo& "'" &_
            '" and decHourlyRate = " & delRate
    strDel = "delete from tblCustRate"
    if resType ="E" then
      strDel = strDel & " where iEmpID =" & iEmpID
    else
      strDel = strDel & " where iSubcontID =" & iSubcontID
    end if
      strDel = strDel & " and iTaskiD = " & iTaskID&_
            " and iProjDetiD = " & iProjDetID&_
            " and dtRateFrom =' " & delFrom& "'"&_
            " and dtRateTo =' " & delTo& "'"&_
            " and decHourlyRate = " & delRate
    'end if

        'if dateFrom = "" then
         if delFrom ="" then
            strDel = strDel + " and dtRateFrom is null"
        else
            strDel = strDel + " and dtRateFrom='" & delFrom &"'"
        end if
        'if dateUntil = "" then
        if delTo="" then
            strDel = strDel + " and dtRateTo is null"
        else
            strDel = strDel + " and dtRateTo='" & delTo &"'"
        end if




  set rsStrDelete=Server.CreateObject("ADODB.Recordset")
  rsStrDelete.ActiveConnection = objConn
  Response.Write strDel
  objConn.Execute(strDel)
  'rsStrDelete.Open strDel
  'objHistoryRate.Requery
  end if

Reply With Quote
  #2 (permalink)  
Old November 6th, 2004, 12:51 PM
Friend of Wrox
 
Join Date: Jul 2004
Location: , , .
Posts: 119
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I guess I was not able to explain the question in a better way. Let me explain it one more time. When I hit "new" button three text boxes appear horizontally without any contents in it. Know the user enter the contents and hit "save" button and gets saved in the database. Know when the user tries to hit an "image" which is delete button located horizontaly with three txt boxes. It deletes the contents in the database, but in an asp remains unchanged. The user doesnot notice any change in the web. So I want text boxes and contents to get deleted from the web. I hope this makes sense. The code you wrote I assume it will only clear the contents not the txt boxes.
Shoakat


Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cycling through all text boxes sjf905 C# 2 September 21st, 2006 12:43 AM
I want text boxes and values to disappear in asP shoakat ASP.NET 1.0 and 1.1 Basics 4 April 26th, 2005 04:55 PM
text boxes do not disappear in an aspI shoakat ASP.NET 1.0 and 1.1 Basics 6 November 10th, 2004 08:20 AM
HELP with text boxes on webpage rwheeleragco Javascript How-To 1 November 2nd, 2004 03:32 AM



All times are GMT -4. The time now is 08:06 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.