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
Solved

How to handle a click event in asp

Posted on 2004-09-13
7
278 Views
Last Modified: 2010-04-17
Hi,
I have a text box on a page and a command button. When user enter data into the textbox and then click on the button, a search will be done in the database and data will be returned and displayed on the page. I am able to return the data but how do I set up the click event to tahe the data from the textbox and insert it into my sql string. This is the code I have so far

<%@ LANGUAGE="VBSCRIPT" %>
<%  
Option Explicit
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Search_Result</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">




</head>

<body>
<p>&nbsp;</p>

<table width="210" border="0" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
  <tr>
    <td>Search by Invoice Number </td>
  </tr>
  <tr>
    <td><form action="result" method="get/post" name="invoice" id="invoice">
      <input name="invoice" type="text" class="title" id="invoice" value="123456" size="10" maxlength="10">
      <input name="Button" type="button" class="button" align="right" onmouseover="this.className='buttonon'" onmouseout="this.className='button'" value="Search">
    </form></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>

</body>

</html>


<%

' -- Declare Variables
Dim objConn                  ' Our Connection Object
Dim objRS                  ' Our Recordset Object
Dim strSQL                  ' Our SQL String to access the database
Dim strConnection            ' Our Connection string to access the database
Dim i      
                  ' a counter variable

' -- Create objects
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")




objConn.Open "Provider=sqloledb;" & _
           "Data Source=localhost;" & _
           "Initial Catalog=test;" & _
           "Integrated Security=SSPI"







' -- Our SQL Statement

strSQL = "select * from tinvoice where inv_no =12345"

' -- Populate our Recordset with data
set objRS = objConn.Execute (strSQL)


if (objRS.BOF and objRS.EOF) then
      response.write "No records found"
      response.end
End if

%>

<TABLE BORDER="1" CELLPADDING="2" CELLSPACING="1" WIDTH="100%">



<%
      ' -- Output the Field Names as the first row in the table
      Response.Write "<TR BGCOLOR=""#CCffCC"">"
      For i = 0 to objRS.Fields.Count -1
            Response.Write "<TH>" & objRS.Fields(i).Name  & "</TH>"
      Next
      Response.write "</TR>"

' -- Now output the contents of the Recordset
      objRS.MoveFirst
      Do While Not objRS.EOF
            ' -- output the contents
            Response.Write "<TR>"
            For i = 0 to objRS.Fields.Count - 1
                  Response.Write "<TD>" & objRS.Fields(i) & "</TD>"
            Next
            Response.write "</TR>"
            ' -- move to the next record
            objRS.MoveNext
      Loop

objRS.Close
      set objRS = Nothing
      objConn.Close
      set objConn = Nothing





%>
0
Comment
Question by:delcom5
  • 2
7 Comments
 
LVL 35

Accepted Solution

by:
YZlat earned 25 total points
ID: 12045108
you should use form submit. Put <form> tag on the form and replace your Button with Submit button. Set the form's action to your page name.asp. For example if you mage is result.asp, have <form name="form1" method="post" action="result.asp">:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Search_Result</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">




</head>

<body>
<p>&nbsp;</p>

<table width="210" border="0" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
  <tr>
    <td>Search by Invoice Number </td>
  </tr>
  <tr>
    <td><form action="result.asp" method="post" name="invoice" id="invoice">
      <input name="invoice" type="text" class="title" id="invoice" value="123456" size="10" maxlength="10">
      <input name="Button1" type="submit" class="button" align="right" onmouseover="this.className='buttonon'" onmouseout="this.className='button'" value="Search">
    </form></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>

</body>

</html>

0
 

Assisted Solution

by:sajithnair
sajithnair earned 25 total points
ID: 12053023
In the form tab give the name or the script .. right now you have given result.. I assume your page name is result.asp so change the form tag as follows.

<form action="result.asp" method="post" name="invoice" id="invoice">

Now in the SQL query replace 12345 with the value from textbox as follows

' -- Our SQL Statement

strSQL = "select * from tinvoice where inv_no =" & Request.form("invoice")

Now change the type of the button from "button" to "submit" as follows

<input name="Button" type="submit" class="button" align="right" onmouseover="this.className='buttonon'" onmouseout="this.className='button'" value="Search">


Hope this should help you :)
Cheers
Sajith
0
 

Expert Comment

by:sajithnair
ID: 12359291
I have an objection. The chosen comment doesn't fullfill the answer. It has not described how to take the data in the query after the form is submitted.

Thanks
Sajith
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

861 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