All that does is display any linefeed / carriage returns your db field has
- what other formatting are you looking for
--
| didn't work. what else can i do?
|
| "Stefan B Rusynko" wrote:
|
| > Find
| >
| > <%=FP_FieldVal(fp_rs,"Detailed_Description")%>
| >
| > Replace it w/
| >
| > <%=Replace(FP_FieldVal(fp_rs,"Detailed_Description"),vbCRLF,"<br>")%>
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | here is the code from the results page, what should i replace?
| > |
| > | <html>
| > |
| > | <head>
| > | <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
| > | Edit.
| > | FP_CharSet = "windows-1252"
| > | FP_CodePage = 1252 %>
| > | <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| > | <title>Project Results Page</title>
| > | <meta name="GENERATOR" content="Microsoft FrontPage 6.0">
| > | <meta name="ProgId" content="FrontPage.Editor.Document">
| > | </head>
| > |
| > | <body bgcolor="#FFFFFF">
| > |
| > | <table width="100%" align="left" id="table2">
| > | <tr>
| > | <td width="40%"><b><font size="7">
| > | <img border="0" src="../../images/floppy.gif" width="90"
| > | height="90"></font><font size="+3" color="#000080">Project
| > | Results Page </font></b></td>
| > | <td width="59%" align="right">
| > | <table id="table3">
| > | <tr>
| > | <td>
| > | <div align="right">
| > | <table id="table4">
| > | <tr>
| > | <td><a href="../../select.aspx">Main Selection</a> |
| > | View Results |
| > | <a href="editor/submission_form.asp">Website Submission
| > | Form</a> | <a href="editor/submitted.asp">Project
| > | Placement</a> | <a href="../../logout.htm">Logout</a>
| > | </td>
| > | </tr>
| > | </table>
| > | </div>
| > | <p> </p>
| > | </td>
| > | </tr>
| > | </table>
| > | </td>
| > | </tr>
| > | </table>
| > | <p><br clear="all">
| > | </p>
| > | <hr>
| > | <p></p>
| > | <div align="center">
| > | <form botid="0" method="POST" action="results_page.asp">
| > | <input type="hidden" name="fpdbr_0_PagingMove" value=" |< ">
| > | <table border="0">
| > | <tr>
| > | <td><b>Website Name</b></td>
| > | <td>
| > | <input type="TEXT" name="Website_Name"
| > | value="<%=Server.HtmlEncode(Request("Website_Name"))%>"></td>
| > | </tr>
| > | </table>
| > | <br>
| > | <input type="Submit"><input type="Reset"><!--webbot bot="SaveAsASP"
| > | clientside suggestedext="asp" preview=" " startspan --><!--webbot
| > | bot="SaveAsASP" endspan --><p> </p>
| > | </form>
| > | <table width="100%" border="1" bordercolor="#000080">
| > | <thead>
| > | <tr>
| > | <th align="LEFT">
| > | <p align="center"><b>Posters Name</b></p>
| > | </th>
| > | <th align="LEFT">
| > | <p align="center"><b>Detailed Description</b></p>
| > | </th>
| > | <th align="LEFT">
| > | <p align="center"><b>Website Name</b></p>
| > | </th>
| > | <th align="LEFT">
| > | <p align="center"><b>Timestamp</b></p>
| > | </th>
| > | </tr>
| > | </thead>
| > | <!--webbot bot="DatabaseRegionStart"
| > |
| >
s-columnnames="Key,Posters_Name,Website_Name,Detailed_Description,Remote_computer_name,User_name,Browser_type,TimeStamp,Timestamp1"
| > | s-columntypes="3,202,202,203,202,202,202,202,135" s-dataconnection="webforum"
| > | b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="Posters_Name"
| > | s-menuvalue="Posters_Name" b-tableborder="TRUE" b-tableexpand="TRUE"
| > | b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| > | i-listformat="0" b-makeform="TRUE" s-recordsource="Results"
| > | s-displaycolumns="Posters_Name,Detailed_Description,Website_Name,Timestamp1"
| > | s-criteria="[Website_Name] EQ {Website_Name} +" s-order="[Key] +"
| > | s-sql="SELECT * FROM Results WHERE (Website_Name = '::Website_Name::') ORDER
| > | BY Key ASC" b-procedure="FALSE" clientside suggestedext="asp"
| > | s-defaultfields="Website_Name=" s-norecordsfound="No records to be returned
| > | for that website. Please Try again or if you believe you entered the right
| > | website name contact the Information Technology Department." i-maxrecords="0"
| > | i-groupsize="0" botid="0" u-dblib="../../_fpclass/fpdblib.inc"
| > | u-dbrgn1="../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../_fpclass/fpdbrgn2.inc"
| > | tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font
| > | color="#000000">This is the start of a Database Results
| > | region.</font></td></tr>" startspan b-usedotnet="FALSE" currentext
| > | sa-inputtypes="202" b-datagridformat="FALSE" b-dgridalternate="TRUE"
| > | sa-crittypes="202" b-wastableformat="TRUE" --><!--#include
| > | file="../../_fpclass/fpdblib.inc"-->
| > | <% if 0 then %>
| > | <SCRIPT Language="JavaScript">
| > | document.write("<div style='background: yellow; color: black;'>The Database
| > | Results component on this page is unable to display database content. The
| > | page must have a filename ending in '.asp', and the web must be hosted on a
| > | server that supports Active Server Pages.</div>");
| > | </SCRIPT>
| > | <% end if %>
| > | <%
| > | fp_sQry="SELECT * FROM Results WHERE (Website_Name = '::Website_Name::')
| > | ORDER BY Key ASC"
| > | fp_sDefault="Website_Name="
| > | fp_sNoRecords="<tr><td colspan=4 align=""LEFT"" width=""100%"">No records to
| > | be returned for that website. Please Try again or if you believe you entered
| > | the right website name contact the Information Technology
| > | Department.</td></tr>"
| > | fp_sDataConn="webforum"
| > | fp_iMaxRecords=0
| > | fp_iCommandType=1
| > | fp_iPageSize=0
| > | fp_fTableFormat=True
| > | fp_fMenuFormat=False
| > | fp_sMenuChoice="Posters_Name"
| > | fp_sMenuValue="Posters_Name"
| > |
| >
fp_sColTypes="&Key=3&Posters_Name=202&Website_Name=202&Detailed_Description=203&Remote_computer_name=202&User_name=202&Browser_type=202&TimeStamp=202&Timestamp1=135&"
| > | fp_iDisplayCols=4
| > | fp_fCustomQuery=False
| > | BOTID=0
| > | fp_iRegion=BOTID
| > | %>
| > | <!--#include file="../../_fpclass/fpdbrgn1.inc"-->
| > | <!--webbot bot="DatabaseRegionStart" endspan i-checksum="34856" --><tr>
| > | <td>
| > | <p align="center"><font color="#008000"><b>
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="Key,Posters_Name,Website_Name,Detailed_Description,Remote_computer_name,User_name,Browser_type,TimeStamp,Timestamp1"
| > | s-column="Posters_Name" b-tableformat="TRUE" b-hashtml="FALSE"
| > | b-makelink="FALSE" clientside b-menuformat preview="<font
| > | size="-1"><<</font>Posters_Name<font size="-1">>></font>"
| > | startspan --><%=FP_FieldVal(fp_rs,"Posters_Name")%><!--webbot
| > | bot="DatabaseResultColumn" endspan i-checksum="29771" --></b></font></p>
| > | </td>
| > | <td>
| > | <p align="left"><font color="#000080">
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="Key,Posters_Name,Website_Name,Detailed_Description,Remote_computer_name,User_name,Browser_type,TimeStamp,Timestamp1"
| > | s-column="Detailed_Description" b-tableformat="TRUE" b-hashtml="FALSE"
| > | b-makelink="FALSE" clientside b-menuformat preview="<font
| > | size="-1"><<</font>Detailed_Description<font size="-1">>></font>"
| > | startspan --><%=FP_FieldVal(fp_rs,"Detailed_Description")%><!--webbot
| > | bot="DatabaseResultColumn" endspan i-checksum="52753" --></font></p>
| > | </td>
| > | <td>
| > | <p align="center"><b>
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="Key,Posters_Name,Website_Name,Detailed_Description,Remote_computer_name,User_name,Browser_type,TimeStamp,Timestamp1"
| > | s-column="Website_Name" b-tableformat="TRUE" b-hashtml="FALSE"
| > | b-makelink="FALSE" clientside b-menuformat preview="<font
| > | size="-1"><<</font>Website_Name<font size="-1">>></font>"
| > | startspan --><%=FP_FieldVal(fp_rs,"Website_Name")%><!--webbot
| > | bot="DatabaseResultColumn" endspan i-checksum="28728" --></b></p>
| > | </td>
| > | <td>
| > | <p align="center"><b><font color="#FF0000">
| > | <!--webbot bot="DatabaseResultColumn"
| > |
| >
s-columnnames="Key,Posters_Name,Website_Name,Detailed_Description,Remote_computer_name,User_name,Browser_type,TimeStamp,Timestamp1"
| > | s-column="Timestamp1" b-tableformat="TRUE" b-hashtml="FALSE"
| > | b-makelink="FALSE" clientside b-menuformat preview="<font
| > | size="-1"><<</font>Timestamp1<font size="-1">>></font>" startspan
| > | --><%=FP_FieldVal(fp_rs,"Timestamp1")%><!--webbot bot="DatabaseResultColumn"
| > | endspan i-checksum="22896" --></font></b></p>
| > | </td>
| > | </tr>
| > | <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
| > | b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="0"
| > | clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00"
| > | width="100%"><font color="#000000">This is the end of a Database Results
| > | region.</font></td></tr>" startspan --><!--#include
| > | file="../../_fpclass/fpdbrgn2.inc"-->
| > | <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="65064" --></table>
| > | </div>
| > |
| > | </body>
| > |
| > | </html>
| > |
| > |
| > | "Ronx" wrote:
| > |
| > | > On the results page.
| > | > --
| > | > Ron Symonds
| > | > Microsoft MVP (FrontPage)
| > | > Reply only to group - emails will be deleted unread.
| > | >
| > | > | > | > > On what page should i do that, on the submission page or on the
| > | > > results page?
| > | > >
| > | > > "Ronx" wrote:
| > | > >
| > | > >> Write your own code to format the results.
| > | > >> You need to replace carriage returns with <br>
| > | > >>
| > | > >> example, find in the code where the comments are displayed, and
| > | > >> replace the FP code with
| > | > >>
| > | > >> <%= replace(fp_rs("fieldname"),vbCRLF,"<br>") %>
| > | > >> --
| > | > >> Ron Symonds
| > | > >> Microsoft MVP (FrontPage)
| > | > >> Reply only to group - emails will be deleted unread.
| > | > >>
| > | > >> | > | > >> >I used the database results wizard which i like because it has a
| > | > >> >db
| > | > >> >editor.
| > | > >> > Is there any other way i can format those posts?
| > | > >> >
| > | > >> > "Ronx" wrote:
| > | > >> >
| > | > >> >> See your original post.
| > | > >> >> --
| > | > >> >> Ron Symonds
| > | > >> >> Microsoft MVP (FrontPage)
| > | > >> >> Reply only to group - emails will be deleted unread.
| > | > >> >>
| > | > >> >> | > | > >> >> >I have a submission form and the whole thing was made with fp03
| > | > >> >> >and
| > | > >> >> >some of
| > | > >> >> > my users make very long post and on the results page it's all
| > | > >> >> > put
| > | > >> >> > together.
| > | > >> >> > How can i format those posts on the results page?
| > | > >> >> >
| > | > >> >> >
| > | > >> >>
| > | > >> >>
| > | > >> >>
| > | > >>
| > | > >>
| > | > >>
