FP and SQL Database values

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

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
 
FP 2002

-----Original Message-----
Which version of FrontPage are you using?

--
Thanks!
John Jansen
Micosoft Office FrontPage
This posting is provided "AS IS" with no warranties, and confers no rights.



.
Click to expand...
 
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)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
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.
 
Then add another field to your database and use that for the description of
the link or consider learning to hand code your ASP.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
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.
 
Back
Top