Help!!On how to code A-Z title search, PLEEEAASE!

<i><b>Originally posted by : Trinity (the_matrix_ad@hotmail.com)</b></i><br />To anyone out there, I really need some help for my school project, on how to code an <br />A-Z title link search.<br />For example: if the user clicks on C, it will take he/she to a page with all the movies starting<br />with the letter C.<br />I need to see what the SQL query would look like for this type of search.<br />My html file will have something like this...<br /><br /><b>View showtimes for movie titles that begin with:</b><br><br /> <a HREF="title_search.asp#A">A</a> <br /> <a HREF="title_search.asp#B">B</a> <br /> <a HREF="title_search.asp#C">C</a> <br /> .<br /> .<br /> .<br /> <a HREF="title_search.asp#Z">Z</a><br />I got this little code of some web site. I've just started learning ASP on the side, therefore I'm not <br />very familiar with it.<br />I do not understand why they're using the '#' in the HREF.<br />I have successfully built in a little ASP prototype that selects all the movie title from <br />my database. But the question is now, how to do this particular feature A-Z ????<br /><br />Thank you for taking your time to ready my humble help message.<br />I would reaaaally appreciate if anybody could help on this ASAP.<br /><br />Thaks again <br /><br />Trinity )<br />

<i><b>Originally posted by : yusuf (y_sheikh@hotmail.com)</b></i><br />you have to make a table of movies.<br /><br />and when the user clicks on "C"<br />you .htm page<br /><a HREF="title_search.asp?val=a">A</a> <br /><a HREF="title_search.asp?val=b">B</a> <br /><a HREF="title_search.asp?val=c">C</a> <br /><br />this is the syntax of .asp page <br />UrlValue = request.querystring("val")<br /><br />SQLStmt="select * from movies where name like" & UrlValue & "%"<br /><br />set rsSet = Server.Createobject("ADODB.Recordset")<br />rsSet.cursorlocation=adUseClient<br />rsSet.open SQLStmt,<your connection string> <br /><br />after this make a loop and display record.<br /><br />check this site for more help on syntax<br /><br />www.learnasp.com<br /><br />all the best<br />yusuf<br /><br /><br /><br /><br /><br />------------<br />Trinity at 2/23/2000 7:02:48 AM<br /><br />To anyone out there, I really need some help for my school project, on how to code an <br />A-Z title link search.<br />For example: if the user clicks on C, it will take he/she to a page with all the movies starting<br />with the letter C.<br />I need to see what the SQL query would look like for this type of search.<br />My html file will have something like this...<br /><br /><b>View showtimes for movie titles that begin with:</b><br><br /> <a HREF="title_search.asp#A">A</a> <br /> <a HREF="title_search.asp#B">B</a> <br /> <a HREF="title_search.asp#C">C</a> <br /> .<br /> .<br /> .<br /> <a HREF="title_search.asp#Z">Z</a><br />I got this little code of some web site. I've just started learning ASP on the side, therefore I'm not <br />very familiar with it.<br />I do not understand why they're using the '#' in the HREF.<br />I have successfully built in a little ASP prototype that selects all the movie title from <br />my database. But the question is now, how to do this particular feature A-Z ????<br /><br />Thank you for taking your time to ready my humble help message.<br />I would reaaaally appreciate if anybody could help on this ASAP.<br /><br />Thaks again <br /><br />Trinity )<br />