Marquees

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This question was asked a week ago but got no replies - anyone any ideas?
Raymondo :

Is it possible to insert a database result into a marquee? If I simply past
in the result field it only displays the field name. Is their a way to
overcome this or a script that would work in the same way? Anna
 
Is it possible to insert a database result into a marquee?

Certainly.

<marquee ...><%= result %></marquee>

Why would that not work?
 
Hi Murray,
OK so perhaps it should work and I expect I am doing something wrong.
i have used <marquee><%= description%></marquee> (where description matches
a field in my database) and nothing shows in the browser. If i remove the =
then I get a Type Mismatch error.
The other fieldsof the dbr show correctly on the page.

Any thoughts welcome....
 
Sorry, murray - don't understand quite what you mean.

description is the name of a database field which is populated from a
scrolling text box in a form. database table is called Results, Dtabase is
called postjobs. I could post you the source code but it's very long. The
description field posts ok if I don't insert it into the marquee. When I do
the whole of the webbot description in the source code dissapears and I am
just left with the <marquee> %=description% </marquee> code

Raymondo
 
Can you show me what you have between <marquee> and </marquee>, including
the <marquee> tags?
 
Hmm - I can't tell if that's really all it is or some cosmic trick of your
access to the newsgroup. 8)

Really? That's all it is?

Would it be possible for you to just copy the 20 or so lines of code before
and after this marquee and paste it into a reply here?
 
That's life Jim....

Here's the code,

<!--webbot bot="DatabaseResultColumn" startspan

s-columnnames="ID,Sector,Company,Contact,Website,Email,Telephone,Address,Position,Area,Salary,Per,Description,Remote_computer_name,Timestamp,Ref,subject,User_name,Browser_type"
s-column="Salary" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Salary<font
size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Salary<font
size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Salary")%><!--webbot
bot="DatabaseResultColumn" endspan i-CheckSum="14755" -->
<p><!--webbot bot="DatabaseResultColumn" startspan

s-columnnames="ID,Sector,Company,Contact,Website,Email,Telephone,Address,Position,Area,Salary,Per,Description,Remote_computer_name,Timestamp,Ref,subject,User_name,Browser_type"
s-column="Per" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>Per<font
size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>Per<font
size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Per")%><!--webbot
bot="DatabaseResultColumn" endspan i-CheckSum="2823" -->
</p>
<marquee>%= Description %</marquee>
<p> </p>
<p> </p>
</td>
</tr>
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left"
width="100%"><font color="#000000">This is the end of a Database Results
region.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left"
width="100%"><font color="#000000">This is the end of a Database Results
region.</font></td></tr>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="62730" -->
</tbody>
</table>
</td>
<center>
<td width="260" bordercolor="#800000">

I guess from what you are saying that you expect much more between the tags?
I initially just pasted the <<Description>> into the marque and then did
what you suggested.

Let me know what you think!

Raymondo
 
You are using the FP wizard
So you can't use std ASP, which you applied incorrectly as:
<marquee>%= Description %</marquee>
and would apply correctly as
<marquee><%=Description%></marquee>

In your case you need to use the wizard syntax
<marquee><%=FP_FieldVal(fp_rs,"Description")%></marquee>

--

_____________________________________________
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.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| That's life Jim....
|
| Here's the code,
|
| <!--webbot bot="DatabaseResultColumn" startspan
|
|
s-columnnames="ID,Sector,Company,Contact,Website,Email,Telephone,Address,Position,Area,Salary,Per,Description,Remote_computer_name,Timestamp,Ref,subject,User_name,Browser_type"
| s-column="Salary" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
| local_preview="<font size="-1">&lt;&lt;</font>Salary<font
| size="-1">&gt;&gt;</font>"
| preview="<font size="-1">&lt;&lt;</font>Salary<font
| size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Salary")%><!--webbot
| bot="DatabaseResultColumn" endspan i-CheckSum="14755" -->
| <p><!--webbot bot="DatabaseResultColumn" startspan
|
|
s-columnnames="ID,Sector,Company,Contact,Website,Email,Telephone,Address,Position,Area,Salary,Per,Description,Remote_computer_name,Timestamp,Ref,subject,User_name,Browser_type"
| s-column="Per" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
| local_preview="<font size="-1">&lt;&lt;</font>Per<font
| size="-1">&gt;&gt;</font>"
| preview="<font size="-1">&lt;&lt;</font>Per<font
| size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"Per")%><!--webbot
| bot="DatabaseResultColumn" endspan i-CheckSum="2823" -->
| </p>
| <marquee>%= Description %</marquee>
| <p> </p>
| <p> </p>
| </td>
| </tr>
| <!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="TRUE"
| b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
| clientside tag="TBODY"
| local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left"
| width="100%"><font color="#000000">This is the end of a Database Results
| region.</font></td></tr>"
| preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left"
| width="100%"><font color="#000000">This is the end of a Database Results
| region.</font></td></tr>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
| <!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="62730" -->
| </tbody>
| </table>
| </td>
| <center>
| <td width="260" bordercolor="#800000">
|
| I guess from what you are saying that you expect much more between the tags?
| I initially just pasted the <<Description>> into the marque and then did
| what you suggested.
|
| Let me know what you think!
|
| Raymondo
|
| "Murray" wrote:
|
| > Hmm - I can't tell if that's really all it is or some cosmic trick of your
| > access to the newsgroup. 8)
| >
| > Really? That's all it is?
| >
| > Would it be possible for you to just copy the 20 or so lines of code before
| > and after this marquee and paste it into a reply here?
| >
| > --
| > Murray
| > --------------
| > MVP FrontPage
| >
| >
| > | > > That would be: %=description%
| > >
| > > "Murray" wrote:
| > >
| > >> Can you show me what you have between <marquee> and </marquee>, including
| > >> the <marquee> tags?
| > >>
| > >> --
| > >> Murray
| > >> --------------
| > >> MVP FrontPage
| > >>
| > >>
| > >> | > >> > Sorry, murray - don't understand quite what you mean.
| > >> >
| > >> > description is the name of a database field which is populated from a
| > >> > scrolling text box in a form. database table is called Results, Dtabase
| > >> > is
| > >> > called postjobs. I could post you the source code but it's very long.
| > >> > The
| > >> > description field posts ok if I don't insert it into the marquee. When
| > >> > I
| > >> > do
| > >> > the whole of the webbot description in the source code dissapears and I
| > >> > am
| > >> > just left with the <marquee> %=description% </marquee> code
| > >> >
| > >> > Raymondo
| > >> >
| > >> > "Murray" wrote:
| > >> >
| > >> >> Show me what you have for "description", please.
| > >> >>
| > >> >> --
| > >> >> Murray
| > >> >> --------------
| > >> >> MVP FrontPage
| > >> >>
| > >> >>
| > >> >> | > >> >> > Hi Murray,
| > >> >> > OK so perhaps it should work and I expect I am doing something
| > >> >> > wrong.
| > >> >> > i have used <marquee><%= description%></marquee> (where description
| > >> >> > matches
| > >> >> > a field in my database) and nothing shows in the browser. If i
| > >> >> > remove
| > >> >> > the
| > >> >> > =
| > >> >> > then I get a Type Mismatch error.
| > >> >> > The other fieldsof the dbr show correctly on the page.
| > >> >> >
| > >> >> > Any thoughts welcome....
| > >> >> >
| > >> >> > "Murray" wrote:
| > >> >> >
| > >> >> >> > Is it possible to insert a database result into a marquee?
| > >> >> >>
| > >> >> >> Certainly.
| > >> >> >>
| > >> >> >> <marquee ...><%= result %></marquee>
| > >> >> >>
| > >> >> >> Why would that not work?
| > >> >> >>
| > >> >> >> --
| > >> >> >> Murray
| > >> >> >> --------------
| > >> >> >> MVP FrontPage
| > >> >> >>
| > >> >> >>
| > >> >> >> | > >> >> >> > This question was asked a week ago but got no replies - anyone
| > >> >> >> > any
| > >> >> >> > ideas?
| > >> >> >> > Raymondo :
| > >> >> >> >
| > >> >> >> > Is it possible to insert a database result into a marquee? If I
| > >> >> >> > simply
| > >> >> >> > past
| > >> >> >> > in the result field it only displays the field name. Is their a
| > >> >> >> > way
| > >> >> >> > to
| > >> >> >> > overcome this or a script that would work in the same way? Anna
| > >> >> >> >
| > >> >> >>
| > >> >> >>
| > >> >> >>
| > >> >>
| > >> >>
| > >> >>
| > >>
| > >>
| > >>
| >
| >
| >
 
<marquee>%= Description %</marquee>
should be
<marquee><%= FP_FieldVal(fp_rs,"Description")%></marquee>
 
Back
Top