query regarding recordset

pgtips · August 22nd, 2003, 03:24 AM

Well your hyperlink just has to point to an asp page that runs the sql query and displays the results. Here's a crude example:

Code:

your hyperlink would be something like this:
<a href="viewAllCustomers.asp">view all customers</a>

then viewAllCustomers.asp should contain something like this:
<%
...
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "connection string goes here"
Set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Select * from customerinfo", conn
Do While Not rs.EOF
   ' this just writes the data out to the page
   ' you can add any HTML you like to make the
   ' page appear how you want
   Response.Write(rs("Field1").Value)
   Response.Write(rs("Field2").Value)
   Response.Write("etc...")
   rs.MoveNext
Loop

rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
%>

hth
Phil

spraveens · August 22nd, 2003, 06:00 AM

Hello Mr.Phil

Thankz for Your information, I would like to know whether I can pass any parameters through the hyperlink.i.e. if I want the query "select * from customerinfo where customername='tom' "
I want to send the customername =tom through the hyperlink.How to do it?

pgtips · August 22nd, 2003, 07:29 AM

OK, just change your hyperlink to

Code:

<a href="viewAllCustomers.asp?customername=tom">view tom</a>

then you can pick it up in viewAllCustomers.asp using

Code:

sCustomerName=Request.QueryString("customername")
...
rs.Open "Select * from customerinfo where customername='" & Replace(sCustomerName, "'", "''") & "'", conn
...

but this opens up a can of worms, really. You have to be very careful
when using direct SQL which embeds information passed from the client. Do a search on "SQL injection attacks" to see what you could be letting yourself in for.

If customername contains a ' (e.g. customername=o'reilly) then you have to replace the ' with a '' as shown above.

hth
Phil

spraveens · August 25th, 2003, 12:27 AM

Hello mr.phil

When I execute the query " select * from customer where name='bush' " , and there are no records matching this condition then I would like to have a message saying "no records available" .How do I do this?

Thank You
Praveen

spraveens · August 25th, 2003, 05:45 AM

Hello Mr.phil

I have used three hyper reference statements to pass the parameter "servername", now
I have also saved the value of the parameter "servername" in a variable called "temp" .

Now If I replace the statement :
<a href ="http:\\localhost\project1\disphard.asp?servernam e=wiproecmx2">HARDWARE
CONFIGURATION </a>

With the Statement:

<a href ="http:\\localhost\project1\disphard.asp?<%=temp%> ">HARDWARE CONFIGURATION </a>

Iam getting a VB compilation Error.

My query is that : What is the Error in above statement? and How do I pass the value of variable
"temp" using the Link ?

================================================== ========================
This Is The Program:
================================================== ===========================
<html>
<title>Server Docket</title>
<head><center>
<%
serverName=Request.QueryString("servername")
response.write (servername)
dim temp
temp=request.querystring("servername")

%></center>
</head>
<body>

<PRE><CENTER>

<a href ="http:\\localhost\project1\disphard.asp?servernam e=wiproecmx2">HARDWARE CONFIGURATION </a> 

<a href ="http:\\localhost\project1\dispsoft.asp?servernam e=wiproecmx2">SOFTWARE CONFIGURATION </a> 

<a href ="http:\\localhost\project1\displaygen.asp?servern ame=wiproecmx2">GENERAL DETAILS </a> 

%>

</body>
</html>
================================================== =====================

How do I replace "servername=wiproecmx2" with <%=temp%> ???

Thank You

Jonax · August 25th, 2003, 06:26 AM

Try this:

Code:

<a href ="http:\\localhost\project1\disphard.asp?servername=<%=temp%>">HARDWARE CONFIGURATION</a>

... and you might want to flip your slashes ...

Code:

<a href ="http://localhost/project1/disphard.asp?servername=<%=temp%>">HARDWARE CONFIGURATION</a>

spraveens · August 26th, 2003, 02:42 AM

Hi

How can I flood a combo box (drop down box) with an entire column of a table. ex : if I want all the names of customers from table customerinfo in the drop down box how do i do it?

Thank You

Praveen

spraveens · August 26th, 2003, 10:29 PM

Hi
If I execute a query "select * from customerinfo where name= 'steve' " and if there are no queries matching the criteria , then I would like to have a "no records available " message displayed. How do I do It?

pgtips · August 27th, 2003, 02:40 AM

Quote:

quote:Originally posted by spraveens
Hi
If I execute a query "select * from customerinfo where name= 'steve' " and if there are no queries matching the criteria , then I would like to have a "no records available " message displayed. How do I do It?

After you execute the query and get a recordset back, just test for an end-of-file marker, like this

Code:

If rsName.EOF Then
  ' no records
Else
  ' records exist, rsName points to the first one
End If

hth
Phil

spraveens · August 27th, 2003, 05:49 AM

Hi Mr.phil

How do I display a messagebox to confirm the deletion of a record?
When i click delete , a message box should be displayed to confirm my deletion .PLease give code :)

regards
Praveen...