You can delete the webbot code that surrounds the current data value and
paste in something like this instead:
<%=Right((FP_FieldVal(fp_rs,"ProductName")),2)%>
which would select the first two digits starting from the end of the
ProductName in the Products table of the Northwind database.
Once you start messing with that code, though, you are on a slippery slope.
"Art" <(E-Mail Removed)> wrote in message
news:2b1d01c3afaf$f6886f60$(E-Mail Removed)...
> Since the query was generated by FP wizard, it does not
> allow for changes to be made. It over-writes all changes
> when the file is saved.
>
>
> >-----Original Message-----
> >Where you want to display the text insert the following
> into html view:
> >
> ><%=Left(recordset("fieldname"),10)%>
> >
> >--
> >
> >==============================================
> >Thomas A. Rowe (Microsoft MVP - FrontPage)
> >WEBMASTER Resources(tm)
> >http://www.ycoln-resources.com
> >FrontPage Resources, Forums, WebCircle,
> >MS KB Quick Links, etc.
> >==============================================
> >To assist you in getting the best answers for FrontPage
> support see:
> >http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> >"Art" <(E-Mail Removed)> wrote in
> message
> >news:068101c3af81$9577e350$(E-Mail Removed)...
> >> I am stumped.........
> >>
> >> I am using FP to query a SQL table and return results.
> >> That all works fine.
> >>
> >> Two of my columns of data at about 50 characters in
> length
> >> (actually a hyperlink). Since I have the values being
> >> returned as a link, all I want to display on the table
> in
> >> the last 10 characters of the link.
> >>
> >> I have tried forcing the column width size, trying
> >> different justifications and even setting the no wrap.
> >>
> >> Anyone have any ideas on how to limit the display of the
> >> large field return?
> >>
> >> Thanks
> >>
> >>
> >
> >
> >.
> >
Similar Threads
