I am new to CF and databases, so this question is probably a no brainer for
most of you. I am trying to retrieve a hyperlink from my access database and
when I view the .cfm file in my broweser the output shows
922#[url]http://www.pinnaclespokane.com#[/url]. Is this a CF issue or Access, and does
anyone know what I'm doing wrong or how to fix it?
here is the code
<cfquery datasource="listingstest" name="listing">
SELECT LISTNUM, PROPERTY, LANDSF, BLDGSF, PRICE, DOLLPERSF, AGENT, URL
FROM LISTINGS
</cfquery>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>LIST#</TITLE>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.2900.2627" name=GENERATOR></HEAD>
<BODY lang=EN-US vLink=#800080 link=#0000ff bgColor=#ffef00>
<TABLE cellSpacing=0 cellPadding=0 width=500 border=1>
<TBODY>
<TR>
<TD width=500>
<TABLE cellSpacing=0 cellPadding=0 border=1>
<TBODY>
<TR>
<TD width=50> <P style="TEXT-ALIGN: center"
align=center><B>LIST#</B></P></TD>
<TD width=237> <P style="TEXT-ALIGN: center"
align=center><B>PROPERTY</B></P></TD>
<TD width=56> <P style="TEXT-ALIGN: center"
align=center><B>LAND<BR>
SQFT</B></P></TD>
<TD width=56> <P style="TEXT-ALIGN: center"
align=center><B>BLDG<BR>
SQFT</B></P></TD>
<TD width="91"> <P style="TEXT-ALIGN: center"
align=center><B>PRICE</B></P></TD>
<TD width=51> <P style="TEXT-ALIGN: center"
align=center><B>$/SF</B></P></TD>
<TD width="63"> <P style="TEXT-ALIGN: center"
align=center><B>AGENT</B></P></TD>
</TR>
<cfoutput query="listing">
<TR>
<TD>#LISTING.LISTNUM#</TD>
<TD width=237>#LISTING.PROPERTY#</TD>
<TD align=middle width=56>#LISTING.LANDSF#</TD>
<TD align=middle width=56>#LISTING.BLDGSF#</TD>
<TD align=right>#LISTING.PRICE#</TD>
<TD align=right width=51>#LISTING.DOLLPERSF#</TD>
<TD align=center>#LISTING.AGENT#</TD>
<TD align=center>#LISTING.URL#</TD>
</TR>
</cfoutput>
</TBODY>
</TABLE></TD></TR>
</TBODY></TABLE></BODY></HTML>