The official newsgroups for ASP and databases are
microsoft.public.inetserver.asp.general and
microsoft.public.inetserver.asp.db
In your case, you have to add some statements to your IF block; however I
really don't understand your use of the comparaison "If Record3 = Record4
Then" so I cannot help you more on this.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"SIMON GARE" <sg[ at ]simongare.com> wrote in message
news:un$RoLWOGHA.4052[ at ]TK2MSFTNGP15.phx.gbl...
[Quoted Text] > Hi,
>
> I have a table with dynamic values form the a recordset, one matches upto
> the other and sets the background images accordingly and everything is
> working ok to a point.
>
> Problem is that there are more than 2 options (i.e. types of vehicle) I
> need
> 4 options, types of vehicle are
>
> Standard
> Executive
> MPV
> Estate
>
> The snippet below only returns 2 values and need 2 more.
>
>
> <td width="80" <%
> Record3 = Recordset1.Fields.Item("VEHICLE_TYPE").Value
> Record4 = Recordset3.Fields.Item("vehicle").Value
> If Record3 = Record4 Then
> strbackground="images/VTypeStandard.gif"
> Else
> strbackground="images/VTypeExec.gif"
> End If
> %> Background="<%=strbackground%>">
>
> Thanks in advance
>
> Simon
>
>
|