rsItem.Filter ="model ='ALFA ROMEO'"
ok, jeg har følgende problem. Jeg har en access db omkring nogle biler. Disse biler vil jeg gerne have sorteret efter mærke såsom Alfa romeo mm, men hvordan slipper jeg for bilmærkets overskrif hvis der ikke er nogle biler af den type i db.<%
dim rsItem, sql
set rsItem = Server.CreateObject("ADODB.Recordset")
sql = "SELECT PersonID, Surname, FirstName, Telefon, StreetAddress1, City, PostalCode, Model, Description, AskingPrice, ListingDate, BilID FROM Person INNER JOIN Item ON Person.PersonID = Item.BilID"
rsItem.Open sql, db
bNew = False
if not rsItem.EOF then
%>
<%
rsItem.Filter ="model ='ALFA ROMEO'"
Response.Write "<TABLE WIDTH=510 BORDER=0 CELLSPACING=0 CELLPADDING=0>"
Response.Write "<TR>"
Response.Write "<TD WIDTH=460 bgcolor=white>"
Response.Write "<FONT COLOR=black SIZE=-1 FACE=Arial, Helvetica, sans-serif>"
Response.Write "<B>"
Response.Write " ALFA ROMEO"
Response.Write "<a name=a></a>"
Response.Write "</B></TD>"
Response.Write "<TD WIDTH=50>"
Response.Write "<img src=images/overgang.gif></TD></TR>"
Response.Write "</TABLE>"
Response.Write "<BR>"
do while not rsItem.EOF
Response.Write rsItem("Model")
Response.Write "<br>"
Response.Write rsItem("Description")
Response.Write "<br>"
Response.Write "Pris....."
Response.Write FormatCurrency(rsItem("AskingPrice"))
Response.Write "<br>"
Response.Write rsItem("Firstname")
Response.Write " "
Response.Write rsItem("Surname")
Response.Write " , "
Response.Write rsItem("StreetAddress1")
Response.Write " , "
Response.Write rsItem("PostalCode")
Response.Write " "
Response.Write rsItem("City")
Response.Write " , Tlf: "
Response.Write rsItem("Telefon")
Response.Write "<br>"
Response.Write "<hr width=410 align=left>"
rsItem.MoveNext
loop
%>
