FP and SQL Database values

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

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.
"Art" <anonymous@discussions.microsoft.com> wrote in message
news:068101c3af81$9577e350$a001280a@phx.gbl...
> 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.
>"Art" <anonymous@discussions.microsoft.com> wrote in
message
>news:068101c3af81$9577e350$a001280a@phx.gbl...
>> 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
>>
>>
>
>
>.
>

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" <anonymous@discussions.microsoft.com> wrote in message
news:068101c3af81$9577e350$a001280a@phx.gbl...
> 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
>
>

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" <anonymous@discussions.microsoft.com> wrote in
message
>news:068101c3af81$9577e350$a001280a@phx.gbl...
>> 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
>>
>>
>
>
>.
>

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)
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" <anonymous@discussions.microsoft.com> wrote in message
news:2b1d01c3afaf$f6886f60$a601280a@phx.gbl...
> 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" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:068101c3af81$9577e350$a001280a@phx.gbl...
> >> 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
> >>
> >>
> >
> >
> >.
> >

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" <anonymous@discussions.microsoft.com> wrote in message
news:2b1d01c3afaf$f6886f60$a601280a@phx.gbl...
> 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" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:068101c3af81$9577e350$a001280a@phx.gbl...
> >> 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
> >>
> >>
> >
> >
> >.
> >