Creare Un Motore Di Ricerca Totale O Parziale

[larossa87]

CIAO A TUTTI...APRO QUESTO NUOVO TOPIC PER CERCARE AIUTO PER RISOLVERE UN PROBLEMA.PREMETTO CHE E' IL MIO PRIMO LAVORO IN ASP..DOVREI CREARE UN MOTORE DI RICERCA IN ASP/JS COLLEGATO AD ACCESS CHE STAMPI IN UNA TABELLA I RISULATI SECONDO I CRITERI SELEZIONATI.PER FARLO HO REALIZZATO 2 PAGINE ASP DOVE IN UNA INSERISCO IL FORM PER L'INSERIMENTO DEI DATI E NELL'ALTRA ESEGUO IL CODICE ASP PER LA RICERCA...IL CODICE è IL SEGUENTE:
PAG1:
Response.Write("<form name=f3 metod=get action=http://localhost/acquisti.asp>")
Response.Write("Cerca titolo o parole nel titolo: <input type=text name=titolo>")
Response.Write("


")
Response.Write("Costo:<select name=")
Response.Write("costo")
Response.Write(">")
Response.Write("<option selected>")
Response.Write("nessun limite")
Response.Write("</option>")
Response.Write("<option>10</option>")
Response.Write("<option>20</option>")
Response.Write("<option>50</option>")
Response.Write("


")
Response.Write("<input type=submit value=")
Response.Write("'GENERA SELEZIONE'")
Response.Write(">")
Response.Write("</form>


")




PAG2.



<% @LANGUAGE="JavaScript" %>
<%

var pers = String (Request.Cookies("persona")("nome"));
var titolof = String(Request.QueryString("titolo"));
var costof = Number(Request.QueryString("costo"));


if (costof=="nessun limite" ) {costof=60}


if (titolof==""){
var con;
var conString;
con= Server.CreateObject("ADODB.Connection");
conString = "Provider = Microsoft.Jet.OLEDB.4.0; "
+ "Data Source = " + Server.MapPath("./bookstore.mdb");
con.Open(conString);
var rst;
var sSQLString;
rst = Server.CreateObject("ADODB.Recordset");
var pers= String (Request.Cookies("persona")("nome"));
sSQLString = "SELECT * FROM users WHERE name='" + pers + "';"
rst = con.Execute(sSQLString);


var con3;
var conString3;
con3= Server.CreateObject("ADODB.Connection");
conString3 = "Provider = Microsoft.Jet.OLEDB.4.0; "
+ "Data Source = " + Server.MapPath("./bookstore.mdb");
con3.Open(conString3);
var rst3;
var sSQLString3;
rst3 = Server.CreateObject("ADODB.Recordset");
sSQLString3 = "SELECT * FROM books WHERE cost <= '" + costof + "';"
rst3 = con3.Execute(sSQLString3);
Response.Write("

Nome = ")
Response.Write(Request.Cookies("persona")("nome"))
Response.Write("</p>")
Response.Write("

Deposito = ")
Response.Write(rst("deposit"))
Response.Write("</p>")

Response.write("<table border=1>")
Response.write("<tr>")
Response.write("<th>")
Response.write("Id Libro");
Response.write("</th>")
Response.write("<th>")
Response.write("Titolo Libro");
Response.write("</th>")
Response.write("<th>")
Response.write("Nome Autore");
Response.write("</th>")
Response.write("<th>")
Response.write("Costo");
Response.write("</th>")
Response.write("</tr>")
if(!rst3.EOF){
while(!rst3.EOF){
Response.write("<tr>")
Response.write("<td>")
Response.write(rst3("book_id"));
Response.write("</td>")
Response.write("<td>")
Response.write(rst3("title"));
Response.write("</td>")
Response.write("<td>")
Response.write(rst3("authors"));
Response.write("</td>")
Response.write("<td>")
Response.write(rst3("cost"));
Response.write("</td>")
Response.write("</tr>")
rst3.MoveNext( );
}
}
con.close()
con3.close()
}
else
{

var con2;
var conString2;
con2= Server.CreateObject("ADODB.Connection");
conString2 = "Provider = Microsoft.Jet.OLEDB.4.0; "
+ "Data Source = " + Server.MapPath("./bookstore.mdb");
con2.Open(conString2);
var rst2;
var sSQLString2;
rst2 = Server.CreateObject("ADODB.Recordset");
var pers= String (Request.Cookies("persona")("nome"));
sSQLString2 = "SELECT * FROM books WHERE title LIKE "+"%"+titolof+"%"+" and cost <="+costof+";"
rst2 = con2.Execute(sSQLString2);

var con;
var conString;
con= Server.CreateObject("ADODB.Connection");
conString = "Provider = Microsoft.Jet.OLEDB.4.0; "
+ "Data Source = " + Server.MapPath("./bookstore.mdb");
con.Open(conString);
var rst;
var sSQLString;
rst = Server.CreateObject("ADODB.Recordset");
var pers= String (Request.Cookies("persona")("nome"));
sSQLString = "SELECT * FROM users WHERE name='" + pers + "';"
rst = con.Execute(sSQLString);


Response.Write("

Nome = ")
Response.Write(Request.Cookies("persona")("nome"))
Response.Write("</p>")
Response.Write("

Deposito = ")
Response.Write(rst("deposit"))
Response.Write("</p>")

Response.write("<table border=1>")
Response.write("<tr>")
Response.write("<th>")
Response.write("Id Libro");
Response.write("</th>")
Response.write("<th>")
Response.write("Titolo Libro");
Response.write("</th>")
Response.write("<th>")
Response.write("Nome Autore");
Response.write("</th>")
Response.write("<th>")
Response.write("Costo");
Response.write("</th>")
Response.write("</tr>")
if(!rst2.EOF){
while(!rst2.EOF){
Response.write("<tr>")
Response.write("<td>")
Response.write(rst2("book_id"));
Response.write("</td>")
Response.write("<td>")
Response.write(rst2("title"));
Response.write("</td>")
Response.write("<td>")
Response.write(rst2("authors"));
Response.write("</td>")
Response.write("<td>")
Response.write(rst2("cost"));
Response.write("</td>")
Response.write("</tr>")
rst2.MoveNext( );
}
con.close()
con2.close()
con3.close() }
}

%>





HO PROVATO A STAMPARE I RISULTATI DELLE QUERY E PRENDE IL VALORE DELLE VARIABILI MA POI NON FUNZIONA E NON STAMPA NULLA...QUALCUNO SAPREBBE AIUTARMI?GRAZIE MILLE

[larossa87]

Sono riuscita a beccare l'errore...era tutta questione di apici!!!..