returning hyperlinks with active server pages built in frontpage 98

Results 1 to 2 of 2

Thread: returning hyperlinks with active server pages built in frontpage 98

  1. #1
    dmartin Guest

    Default returning hyperlinks with active server pages built in frontpage 98

    is there any way to return a field (such as company)as a hyperlink when .asp pages have been created with frontpage 98&#039s database region wizard?<BR><BR>here is what i have now.<BR><BR>&#060;!--webbot<BR> bot="DatabaseRegionStart" i-checksum="31925" endspan --><BR>&#060;p>&#060;img<BR> src="../images/3D_Diamond.gif" alt="3D Diamond.gif (591 bytes)" WIDTH="17" HEIGHT="17">&#060;font<BR> size="4">&#060;strong>&#060;!--webbot bot="DatabaseResultColumn" startspan<BR> s-columnnames="company,url,address,city,state,zip,ph one" s-column="company"<BR> b-tableformat="FALSE" clientside local_preview="Database: company"<BR> preview="Database: company" -->&#060;% <BR>If Not IsEmpty(fp_rs) And Not (fp_rs Is Nothing) Then Response.Write CStr(fp_rs("company")) <BR>&#037;&#062;<BR>&#060;!--webbot bot="DatabaseResultColumn" i-checksum="27603"<BR> endspan -->&#060;/strong>&#060;/font>&nbsp; <BR><BR> &#060;!--webbot bot="DatabaseResultColumn" startspan<BR> s-columnnames="address,city,company,phone,state,url, zip" s-column="url"<BR> b-tableformat="FALSE" clientside local_preview="Database: url" preview="Database: url" -->&#060;% <BR>If Not IsEmpty(fp_rs) And Not (fp_rs Is Nothing) Then Response.Write CStr(fp_rs("url")) <BR>&#037;&#062;<BR>&#060;!--webbot<BR> bot="DatabaseResultColumn" i-checksum="27639" endspan --><BR><BR> &#060;!--webbot bot="DatabaseResultColumn" startspan<BR> s-columnnames="company,url,address,city,state,zip,ph one" s-column="city"<BR> b-tableformat="FALSE" clientside local_preview="Database: city" preview="Database: city" -->&#060;% <BR>If Not IsEmpty(fp_rs) And Not (fp_rs Is Nothing) Then Response.Write CStr(fp_rs("city")) <BR>&#037;&#062;<BR>&#060;!--webbot<BR> bot="DatabaseResultColumn" i-checksum="29768" endspan -->&#060;!--webbot<BR> bot="DatabaseResultColumn" startspan<BR> s-columnnames="company,url,address,city,state,zip,ph one" s-column="state"<BR> b-tableformat="FALSE" clientside local_preview="Database: state" preview="Database: state" -->&#060;% <BR>If Not IsEmpty(fp_rs) And Not (fp_rs Is Nothing) Then Response.Write CStr(fp_rs("state")) <BR>&#037;&#062;<BR>&#060;!--webbot<BR> bot="DatabaseResultColumn" i-checksum="25371" endspan -->&#060;!--webbot<BR> bot="DatabaseResultColumn" startspan<BR> s-columnnames="company,url,address,city,state,zip,ph one" s-column="zip"<BR> b-tableformat="FALSE" clientside local_preview="Database: zip" preview="Database: zip" -->&#060;% <BR>If Not IsEmpty(fp_rs) And Not (fp_rs Is Nothing) Then Response.Write CStr(fp_rs("zip")) <BR>&#037;&#062;<BR>&#060;!--webbot<BR> bot="DatabaseResultColumn" i-checksum="27735" endspan --><BR><BR> &#060;!--webbot bot="DatabaseResultColumn" startspan<BR> s-columnnames="company,url,address,city,state,zip,ph one" s-column="phone"<BR> b-tableformat="FALSE" clientside local_preview="Database: phone" preview="Database: phone" -->&#060;% <BR>If Not IsEmpty(fp_rs) And Not (fp_rs Is Nothing) Then Response.Write CStr(fp_rs("phone")) <BR>&#037;&#062;<BR>&#060;!--webbot<BR> bot="DatabaseResultColumn" i-checksum="26293" endspan -->&#060;/p><BR> &#060;hr><BR> &#060;!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"<BR> local_preview="&lt;TABLE width=&quot;100%&quot; align=&quot;center&quot; bgcolor=&quot;#FFFF00&quot;&gt;&lt;td&gt;&lt;p align=&quot;Center&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;End of Database Region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"<BR> preview="&lt;p&gt;&lt;b&gt;Database: End&lt;/b&gt;&lt;/p&gt;" clientside tag="BODY" -->&#060;%<BR> &#039 Close the loop iterating records<BR> fp_rs.MoveNext<BR> Loop<BR> End If<BR> fp_rs.Close<BR> &#039 Close the If condition checking for a connection error<BR> End If<BR>&#039 Close the If condition checking for a parse error when replacing form field params<BR>End If<BR>set fp_rs = Nothing<BR>&#037;&#062;<BR>&#060;!--webbot<BR> bot="DatabaseRegionEnd" i-checksum="55813" endspan --><BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    73

    Default RE: returning hyperlinks with active server pages built in frontpage 98

    &#060;a href="&#060;%=rslist("url")&#037;&#062;"> URL<BR>something like that..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •