search.asp

Originally posted by : lakshmi (sanchez@sheriff.ccso.org) I managed to get my search.asp to display data, however, i do not know how it is basing its display on. Can someone look at my code, and tell me how I can get it so that a user can enter either of all those fields whether partially or not or just one of those fields and then be able to get a list of the names. I cannot figure out how to get it to do it. I am getting data now which is better than getting a blank page, but I am not getting the correct data. <%@ Language=VBScript %> <HTML> <HEAD> <TITLE>Query Results</TITLE> </HEAD> <BODY> <TABLE BORDER=1> <% Set Conn = Server.CreateObject("ADODB.Connection") Set Buss = Server.CreateObject("ADODB.Recordset") Conn.Open "DSN=BusinessBarcode;UID=sa;pwd=;" sSQL = "SELECT * " sSQL = sSQL & " FROM [Business Master]" sSQL = sSQL & " WHERE Business LIKE Business" sSQL = sSQL & " AND Address LIKE Address" sSQL = sSQL & " AND Barcode LIKE Barcode" Buss.Open sSQL,Conn Do While Not Buss.EOF Response.Write "<tr><td>" & Buss("Business") & "</td><td>" & Buss("Address") & "</td><td>" & Buss("Barcode") & "</td></tr>" Response.Write vbcrlf Buss.MoveNext Loop Buss.Close Conn.Close %> </TABLE> </BODY> </HTML> Any suggestions or perhaps you can point me to where there is a sample of something similar? Thank you

Originally posted by : srinivas (telut@yahoo.com) Try "AND" in sSQL replaced with "OR".You might get probably what U want.There nothing wrong with asp code. ------------ lakshmi at 7/20/2000 4:14:34 PM I managed to get my search.asp to display data, however, i do not know how it is basing its display on. Can someone look at my code, and tell me how I can get it so that a user can enter either of all those fields whether partially or not or just one of those fields and then be able to get a list of the names. I cannot figure out how to get it to do it. I am getting data now which is better than getting a blank page, but I am not getting the correct data. <%@ Language=VBScript %> <HTML> <HEAD> <TITLE>Query Results</TITLE> </HEAD> <BODY> <TABLE BORDER=1> <% Set Conn = Server.CreateObject("ADODB.Connection") Set Buss = Server.CreateObject("ADODB.Recordset") Conn.Open "DSN=BusinessBarcode;UID=sa;pwd=;" sSQL = "SELECT * " sSQL = sSQL & " FROM [Business Master]" sSQL = sSQL & " WHERE Business LIKE Business" sSQL = sSQL & " AND Address LIKE Address" sSQL = sSQL & " AND Barcode LIKE Barcode" Buss.Open sSQL,Conn Do While Not Buss.EOF Response.Write "<tr><td>" & Buss("Business") & "</td><td>" & Buss("Address") & "</td><td>" & Buss("Barcode") & "</td></tr>" Response.Write vbcrlf Buss.MoveNext Loop Buss.Close Conn.Close %> </TABLE> </BODY> </HTML> Any suggestions or perhaps you can point me to where there is a sample of something similar? Thank you

Programming

Related Pages