|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
|
||||
|
||||
|
Radio Button Search Form
Can someone please tell me what is wrong with this code? I keep getting an: Expeted 'Then' Error.
////////////////////////////////////////////////////////////////// <FORM NAME="frmLNsearch" ACTION="results.asp" METHOD="GET"> <TABLE BORDER=1 bordercolorlight="#FF0000" cellspacing="0" cellpadding="0" bordercolordark="#FF0000" background="images/back.jpg" style="border-collapse: collapse" bordercolor="#111111"> <TR> <TH COLSPAN=2><font face="Verdana" size="2" color="#FFFFFF">Search For Actor or Director</font></TH> </TR> <TR> <TD COLSPAN=2 ALIGN=CENTER> <INPUT NAME="txtLNsearch" VALUE=" Enter Last Name Here" onFocus='this.value=""' size="29"> <INPUT TYPE="SUBMIT" NAME=btnSearch" VALUE="Search"></TD> </TR> <TR> <TD><font face="Verdana" size="2" color="#FFFFFF">Actor's Last Name</font><font face="Verdana" color="#FFFFFF"><INPUT TYPE="RADIO" NAME="rdoLname" VALUE="alname"></font></TD> <TD><font face="Verdana" size="2" color="#FFFFFF">Director's Last Name</font><font face="Verdana" color="#FFFFFF"><INPUT TYPE="RADIO" NAME="rdoLname"VALUE="dlname"></font></TD> </TR> </TABLE> </FORM> <% Dim frmLNsearch If frmLNsearch.txtLNsearch Value="alname" Then sql="SELECT tblActors.fldAFname, tblActors.fldALname, tblMovies.fldMovieName, tblGenres.fldGenre, tblMovies.fldNotes FROM (tblGenres INNER JOIN tblMovies ON tblGenres.fldGenreID = tblMovies.fldGenreID) INNER JOIN (tblActors INNER JOIN tblMovieActor ON tblActors.fldActorID = tblMovieActor.fldActorID) ON tblMovies.fldMovieID = tblMovieActor.fldMovieID ORDER ASC" ElseIf frmLNsearch.txtLNsearch Valu ="dlname" Then sql="SELECT tblDirectors.fldDLname, tblDirectors.fldDFname, tblMovies.fldMovieName, tblMovies.fldYear, tblGenres.fldGenre, tblMovies.fldNotes FROM (tblGenres INNER JOIN tblMovies ON tblGenres.fldGenreID = tblMovies.fldGenreID) INNER JOIN (tblDirectors INNER JOIN tblMovieDirector ON tblDirectors.fldDirectorID = tblMovieDirector.fldDirectorID) ON tblMovies.fldMovieID = tblMovieDirector.fldMovieID ORDER ASC" Else Msg="Please Choose Which Last Name You Would Like To Search For. ACtor or Director" EndIf EndIf %> |
|
#2
|
|||
|
|||
|
Looks like you have an extra endif
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain |
|
#3
|
|||
|
|||
|
Possible Typo
seem like you might also have a typo, shouldn't Valu be Value
ElseIf frmLNsearch.txtLNsearch Valu ="dlname" Then |
|
#4
|
||||
|
||||
|
Quote:
Where? There is an If and ElseIf
__________________
Genki Dave
|
|
#5
|
||||
|
||||
|
Wait a second! That radio button search isn't even mine!
I never even thought of using a radio button search form, but someone is using my nick to submit it. How did that happen??? ![]() |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Radio Button Search Form |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|