FP and SQL Database values

[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

 

[John Jansen \(MSFT\)]

Which version of FrontPage are you using?

 

[Art]

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.



.

 

[Thomas A. Rowe]

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.
==============================================

 

[Art]

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.

 

[Thomas A. Rowe]

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.
==============================================

 

[John Clark]

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.