Re: Dynamically changing background HELP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxxxxx> wrote in message
news:un$RoLWOGHA.4052@xxxxxxxxxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: Send Data to URL Without Browser
    ... >I've never opened a recordset via a URL, but I assume it does not open the ... >then creating the recordset at the asp level (our SQL Server is not on the ... >browser, do you think I can merely use this method to pass the query string ... condition is checked just prior to the code that opens the ...
    (microsoft.public.vb.general.discussion)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... If you plan to do much more ASP, I would advise looking for tutorials ... return another column from the database that stores the users 1st name ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
    (microsoft.public.inetserver.asp.db)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... If you plan to do much more ASP, I would advise looking for tutorials ... return another column from the database that stores the users 1st ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
    (microsoft.public.inetserver.asp.db)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... I have Beginning ASP 2.0 and ASP Developer's Guide. ... return another column from the database that stores the users 1st name ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
    (microsoft.public.inetserver.asp.db)
  • Re: Me.Recordset -> DoCmd.RunSQL "UPDATE ...............
    ... DAO is the preferred library for interacting with Jet database engine. ... primary method by which data are manipulated in ACCESS databases since ... >> the form based on DAO recordset SQL statement: ... >> form's Recordsource to the SQL statement itself ("SELECT * FROM ...
    (microsoft.public.access.modulesdaovba)