Datatype fra DB - HJÆÆÆÆLLLLLPPPPP
Hej jeg henter nogle data fra DB (access) og hvor der er type ja/nej hvis det er sat til ja kommer den ud som sand og ovendt falsk !!! se under:x-tender: Sand
Transfer from airport: Sand
Transfer from marina: Sand
Skipper: Sand
Gennaker: Sand
Hostess: Sand
Koden ser sådan ud:
FUNCTION showAll
Set c = new DBConnection
c.getConnection()
Set RSSQ2 = c.objConn.Execute(_
"SELECT boatmodel, arrivalday, arrivalmonth, arrivalyear,departuredate,xtender,transferfromair, transferfrommar, skipper, spy,gennaker,hostess FROM reservation WHERE bookingID=" & Request("bookingID"))
IF NOT RSSQ2.EOF or RSSQ2.BOF then
%>
<form method="POST" action="changeStatus.asp?bookingID=<%=Request("bookingID")%>">
<table>
<tr><td><font size=5 color=navy><strong>Reservation nr. <%=Request("bookingID")%></strong></tr></td>
<tr><td><font size=3 color=navy><strong>Boat model: </strong><td><font size=3 color=navy><%=RSSQ2("boatmodel")%></td></td></tr>
<tr><td><font size=3 color=navy><strong>Arrival date: </strong><td><font size=3 color=navy><%=RSSQ2("arrivalday")%>-<%=RSSQ2("arrivalmonth")%>-<%=RSSQ2("arrivalyear")%></td></td></tr>
<tr><td><font size=3 color=navy><strong>Departure date: </strong><td><font size=3 color=navy><%=RSSQ2("departuredate")%></td></td></tr>
<tr><td><font size=3 color=navy><strong>X-tender: </strong><td><font size=3 color=navy><%=RSSQ2("xtender")%></td></td></tr>
<tr><td><font size=3 color=navy><strong>Transfer from airport: </strong><td><font size=3 color=navy><%=RSSQ2("transferfromair")%></td></td></tr>
<tr><td><font size=3 color=navy><strong>Transfer from marina: </strong><td><font size=3 color=navy><%=RSSQ2("transferfrommar")%></td></td></tr>
<tr><td><font size=3 color=navy><strong>Skipper: </strong><td><font size=3 color=navy><%=RSSQ2("skipper")%></td></td></tr>
<tr><td><font size=3 color=navy><strong>Gennaker: </strong><td><font size=3 color=navy><%=RSSQ2("gennaker")%></td></td></tr>
<tr><td><font size=3 color=navy><strong>Hostess: </strong><td><font size=3 color=navy><%=RSSQ2("hostess")%></td></td></tr>
<td><input type="submit" value="Confirm"></td>
<%
END IF
END FUNCTION
%>Hvad skal jeg ændre for at få yes istedet for Sand eller no for falsk ??? har prøvet alt !!!
HJÆÆÆÆLLLLLPPPPP!!!
