I had some one make a ASP page for me ( but he didn't make it in alphabetical order, and also I was wanting a search engine to search the page. I can't get intouch with him now and I have been searching the net, but have yet to find a way to do it yet.. Is there a way to put a search on the page easy, and the main one is putting them in Alpha order... Is there something I can do to put them in order of some way? Thanks for any help.. Mel...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search and organization
- Thread starter melocco
- Start date
snowboardr
Programmer
Looks like its in Alphabetic order to me.. lol well to do the search thing edit your SELECT statement...
your select statment would be something like
mySQL = "SELECT * FROM movies"
First start by making a form ...
Then above your sql statement on the main.asp page do something like this...
<%
Dim SearchWord
SearchWord = Request.Form("searchbox"
'# If Search keyword is empty or is less then 3 letters go back to the search page...
If SearchWord = "" or Len(SearchWord) < 3 then
Response.Redirect "search.asp"
End if
'# movies = table_name in db where movies are listed
'# movietitle = column_name in db of your movie title
'# Left(SearchWord) looks at the left 4 letters and returns the results (you dont want it to look at the whole word then if its spelt wrong or something it wont return good results..)
mySQL = "SELECT * FROM movies WHERE (movietitle Like '" & Left(SearchWord,4) & "%')"
Let me know if you have further questions regarding this.
Jason
your select statment would be something like
mySQL = "SELECT * FROM movies"
First start by making a form ...
Code:
<form name="form1" method="post" action="main.asp">
<input type="text" name="searchbox"><input type="submit" name="Submit" value="Submit">
</form>Then above your sql statement on the main.asp page do something like this...
<%
Dim SearchWord
SearchWord = Request.Form("searchbox"
'# If Search keyword is empty or is less then 3 letters go back to the search page...
If SearchWord = "" or Len(SearchWord) < 3 then
Response.Redirect "search.asp"
End if
'# movies = table_name in db where movies are listed
'# movietitle = column_name in db of your movie title
'# Left(SearchWord) looks at the left 4 letters and returns the results (you dont want it to look at the whole word then if its spelt wrong or something it wont return good results..)
mySQL = "SELECT * FROM movies WHERE (movietitle Like '" & Left(SearchWord,4) & "%')"
Let me know if you have further questions regarding this.
Jason
snowboardr
Programmer
oh and to alphatize go like so..
mySQL = "SELECT * FROM movies WHERE (movietitle Like '" & Left(SearchWord,4) & "%') Order by movietitle"
mySQL = "SELECT * FROM movies WHERE (movietitle Like '" & Left(SearchWord,4) & "%') Order by movietitle"
- Thread starter
- #4
OK.. Thanks for your help.. As for the list in alpha order, they are up till the end.. When I add more to the list they are not in order.. It's a access list and I can make the list in alpha order, but it doesn't make the asp in order like that.. Again, I'm still new at this but I would love to learn...
I started off by trying the alpha order but didn't see the mySQL ="Select * in the asp. also since the list is in access, is that going to work?? I have MySQL installed and my main site is running PHP with MySQL..
Anyway I thought it might help if I put the asp code up that he made.. That might help you see what he has and tell me what I need to put.. Thanks.....
<%@ Language=VBScript %>
<%
On Error Resume Next
Dim Cnn, Rs
Dim LinkToImdb
Set Cnn = Server.CreateObject("ADODB.Connection"
Set rs = Server.CreateObject("ADODB.Recordset"
With Cnn
.ConnectionString = "DSN=ODBCMelocco"
.ConnectionTimeout = 30
.CommandTimeout = 30
.Open
End With
Rs.Open "Movies", Cnn, 2, 3
Rs.MoveFirst
Response.Write ("<BR> <DIV align = center> <TABLE Cols = 2 Border = 1 Bordercolor = Black Cellspacing = 0 Cellpadding = 0>"
Do Until Rs.EOF
LinkToImdb = Rs.Fields("Information".Value
LinkToImdb = Replace(LinkToImdb, "#", ""
Response.Write("<TR> <TD>"
Response.Write Rs.Fields("Movies List".Value & "</TD><TD>"
Response.Write "<A href = '" & LinkToImdb & "'>" & LinkToImdb & "</A> </TR>"
Response.Write("<TR> <TD>"
Response.Write Rs.Fields("Movies List".Value & "</TD><TD>"
Response.Write "<A href = '" & LinkToImdb & "'>" & LinkToImdb & "</A> </TR>"
Rs.MoveNext
Loop
Response.Write ("</TABLE></DIV>"
Rs.MoveLast
Rs.Move -4
%>
<HTML>
<HEAD>
</HEAD>
<BODY>
</BODY>
</HTML>
Thanks alot.. If there is anything I can help you with let me know.. Mel
I started off by trying the alpha order but didn't see the mySQL ="Select * in the asp. also since the list is in access, is that going to work?? I have MySQL installed and my main site is running PHP with MySQL..
Anyway I thought it might help if I put the asp code up that he made.. That might help you see what he has and tell me what I need to put.. Thanks.....
<%@ Language=VBScript %>
<%
On Error Resume Next
Dim Cnn, Rs
Dim LinkToImdb
Set Cnn = Server.CreateObject("ADODB.Connection"
Set rs = Server.CreateObject("ADODB.Recordset"
With Cnn
.ConnectionString = "DSN=ODBCMelocco"
.ConnectionTimeout = 30
.CommandTimeout = 30
.Open
End With
Rs.Open "Movies", Cnn, 2, 3
Rs.MoveFirst
Response.Write ("<BR> <DIV align = center> <TABLE Cols = 2 Border = 1 Bordercolor = Black Cellspacing = 0 Cellpadding = 0>"
Do Until Rs.EOF
LinkToImdb = Rs.Fields("Information"
.ValueLinkToImdb = Replace(LinkToImdb, "#", ""
Response.Write("<TR> <TD>"
Response.Write Rs.Fields("Movies List"
.Value & "</TD><TD>"Response.Write "<A href = '" & LinkToImdb & "'>" & LinkToImdb & "</A> </TR>"
Response.Write("<TR> <TD>"
Response.Write Rs.Fields("Movies List"
.Value & "</TD><TD>"Response.Write "<A href = '" & LinkToImdb & "'>" & LinkToImdb & "</A> </TR>"
Rs.MoveNext
Loop
Response.Write ("</TABLE></DIV>"
Rs.MoveLast
Rs.Move -4
%>
<HTML>
<HEAD>
</HEAD>
<BODY>
</BODY>
</HTML>
Thanks alot.. If there is anything I can help you with let me know.. Mel
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
