p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: KIM HANSEN


Message #1 by "Elizabeta Siljanovski" <elizabetas@m...> on Sat, 15 Dec 2001 01:04:19 -0500
I took your advice about printing strSQL. It helped a lot!!! 



Thank you!



elizabeta



-----Original Message-----

From: Kim Iwan Hansen [mailto:kimiwan@k...] 

Sent: Friday, December 14, 2001 4:01 PM

To: ASP Databases

Subject: [asp_databases] RE: not able to use wild card search



You have to use the wild card % to do that ;-)



SELECT f_name FROM table WHERE f_name LIKE 'a%';



-Kim







> -----Original Message-----

> From: Manish Agarwal [mailto:mpc@c...]

> Sent: 14. december 2001 20:33

> To: ASP Databases

> Subject: [asp_databases] not able to use wild card search

> 

> 

> I am using an access database but I am not able to use the 

> wildcard search.

> If I wanted to pull only F_NAME records that started with the letter

a, 

> HOW TO DO THAT

> 

> The script which i wrote is as follows---

> 

> <%@ LANGUAGE="VBSCRIPT" %>

> 

> <html>

> <head>

> <title>Client Search Results!</title>

> 

> </head>

> 

> 

> <body>

> <%

> Dim SqlJunk

> Dim n

> n = Request.Form("dainbox")

> Set dbGlobalWeb = Server.CreateObject("ADODB.Connection")

> dbGlobalWeb.Open("poddar")

> sqlJunk = "SELECT * FROM PODDAR WHERE FNAME LIKE '"& n & "' "

> 

> 

> Set rsGlobalWeb = Server.CreateObject("ADODB.Recordset")

> rsGlobalWeb.Open SqlJunk, dbGlobalWeb, 3 

> %>

> <%

> If rsGlobalWeb.BOF and rsGlobalWeb.EOF Then%>

> 

> <h2 align="center">We did not find a match!</h2>

> <%Else%>

> 

> 

> <%If Not rsGlobalWeb.BOF Then%>

> 

> <h2>Here are the results of your search:</h2>

> 

> 

> <form action="DaEngine.asp" method="post" name="log">

> <table border="0" cellpadding="1.5" cellspacing="3" align="center">

> <tr bgcolor="#800000">

> 	

> 	<th><font color="white" face="Verdana, Arial" size=2>First 

> Name:</font></th>

> 	<th><font color="white" face="Verdana, Arial" size=2>Last 

> Name:</font></th>

> 	<th><font color="white" face="Verdana, Arial" 

> size=2>City:</font></th>

> 	<th><font color="white" face="Verdana, Arial" 

> size=2>State:</font></th>

> 	<th><font color="white" face="Verdana, Arial" 

> size=2>Country:</font></th>

> 	<th><font color="white" face="Verdana, Arial" 

> size=2>Zip:</font></th>

> 	<th><font color="white" face="Verdana, Arial" 

> size=2>HomeTown:</font></th>

> 	<th><font color="white" face="Verdana, Arial" size=2>Room 

> No.</font></th>

> 	<th><font color="white" face="Verdana, Arial" 

> size=2>View:</font></th>

> </tr>

> 

> <%

> 	Do While Not rsGlobalWeb.EOF

> 	%>

> <tr bgcolor="#DADADA">

>     

>       <td><font face="Verdana, Arial" size=2 

> color="#000080"><%=rsGlobalWeb

> ("FNAME")%>

> </td>

>       <td><font face="Verdana, Arial" size=2 

> color="#000080"><%=rsGlobalWeb

> ("LNAME")%>

> </td>

>       <td><font face="Verdana, Arial" size=2 

> color="#000080"><%=rsGlobalWeb

> ("CITY")%>

> </td>

>        <td><font face="Verdana, Arial" size=2 color="#000080"><%

> =rsGlobalWeb("STATE")%>

> </td>

>        <td><font face="Verdana, Arial" size=2 color="#000080"><%

> =rsGlobalWeb("COUNTRY")%>

> </td>

>       <td><font face="Verdana, Arial" size=2 

> color="#000080"><%=rsGlobalWeb

> ("PIN")%>

> </td>

>       <td><font face="Verdana, Arial" size=2 

> color="#000080"><%=rsGlobalWeb

> ("HOMETOWN")%>

> </td>

>       <td><font face="Verdana, Arial" size=2 

> color="#000080"><%=rsGlobalWeb

> ("ROOMNO")%>

> </td>

>       <td> <font face="Verdana, Arial" size=2 color="#000080"><A HREF 

> =      "view.asp?NAME=<%=rsGlobalWeb("sno")%>">View</A>

> </td>

> 

>       

> </TR>

> <% rsGlobalWeb.MoveNext

> 	Loop

> 	%>

> 

> <%End If%>

> <%End If%>

> <%

> rsGlobalWeb.Close

> dbGlobalWeb.Close

> %>

> 

> </table>

> </body>

> </html>

> 

> 

> Waiting for all your help

> Manish

> 




> $subst('Email.Unsub').

> 






$subst('Email.Unsub').






  Return to Index