[mso] Re: FrontPage Included Content - ASP
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 6 Apr 2003 07:47:47 -0500
I've written a fair amount of ASP pages, but not sure about using them =
as
Includes, as I've never created a page that way. You might want to post =
to
this group: active-server-pages@xxxxxxxxxxxxxxx
As for your code, it's hard to read, due to all the 3Ds showing up in =
the
message...but, from reading this portion...and removing the renegade =
3Ds...
<%
count =3D count + 1
If count =3D 1 Then
%>
<tr>
<%
End If
%>
<% starts the script code and
%> ends that portion of code
count is an integer variable and it says that count equals count =
(itself)
plus 1...this is an incremental code.
Then it says, if count is equal to 1 then...
But there is no code to tell it to do anything else. There is just a new
table row code, but that is not part of the script code, since it's not
within the <% %> markers...so that will appear whether count is equal to =
1
or not. The End If just closes out the If Then statement. So it appears =
that
something is missing...it should be more like this...
<%
count =3D count + 1
If count =3D 1 Then
'...do something here or...
Response.Write "<tr>" 'this would add a new row if count =3D 1
End If
%>
I'm just GUESSING that you want to add a row if some count you're =
checking
is equal to 1????? Since I don't know all the code, it's hard to say =
what
you're trying to do.
Hope this helps...
Dian Chapman
Technical Consultant
& Microsoft MVP
Free Word Tips & Tricks eBook: http://www.mousetrax.com/books.html
Free Tutorial site: http://www.mousetrax.com/techpage.html
Free Support Ezine: http://www.mousetrax.com/techtrax/
=20
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On =
Behalf
Of Carol Parent
Sent: Saturday, April 05, 2003 6:47 PM
To: mso@xxxxxxxxxxxxx
Hello,
Being quite new to this whole ASP/FrontPage/DRW scenario I want to know =
=3D if
there is anything inherently wrong with using ASP pages as Includes?
I have a page that I am wanting to include different Database results in
different areas of the page. It seems to be working but since I am just
learning I don't know if this is something that may cause big time =3D
problems down the road.
Also too, I have created DB results to break into columns. I would like =
=3D
to know exactly what these two sections of code do:
<%
count =3D3D count + 1
If count =3D3D 1 Then
%>
<%
If count =3D3D 2 Then
count =3D3D 0
%>
I understand part of it but not all and would like to know what it is =
=3D
about these two sections of code do.
_________________________________________________________________________=
=3D
___
_____________________________
<table border=3D3D"0" cellpadding=3D3D"0" cellspacing=3D3D"0" =
width=3D3D"80%" =3D
id=3D3D"table1"> <tbody> <!--#include file=3D3D"_fpclass/fpdblib.inc"--> =
<% if 0
then %> <SCRIPT Language=3D3D"JavaScript"> document.write("<div
style=3D3D'background: yellow; color: black;'>The =3D Database Results =
component
on this page is unable to display database content. =3D The page must =
have a
filename ending in '.asp', and the web must be hosted =3D on a server =
that
supports Active Server Pages.</div>"); </SCRIPT> <% end if %> <%
fp_sQry=3D3D"SELECT * FROM Results WHERE (city LIKE '%Federal%') ORDER =
BY
resortname ASC"
fp_sDefault=3D3D""
fp_sNoRecords=3D3D"<tr><td colspan=3D3D1 align=3D3Dleft =
width=3D3D""100%"">No =3D
records returned.</td></tr>"
fp_sDataConn=3D3D"resorts"
fp_iMaxRecords=3D3D256
fp_iCommandType=3D3D1
fp_iPageSize=3D3D0
fp_fTableFormat=3D3DTrue
fp_fMenuFormat=3D3DFalse
fp_sMenuChoice=3D3D"resortname"
fp_sMenuValue=3D3D"resortname"
fp_iDisplayCols=3D3D1
fp_fCustomQuery=3D3DFalse
BOTID=3D3D0
fp_iRegion=3D3DBOTID
%>
<!--#include file=3D3D"_fpclass/fpdbrgn1.inc"-->
<%
count =3D3D count + 1
If count =3D3D 1 Then
%>
<tr>
<%
End If
%>
<td>
<%=3D3DFP_FieldVal(fp_rs,"resortname")%><br>
<span style=3D3D"background-color: #B1D1AF">
<%=3D3DFP_FieldVal(fp_rs,"lakename")%></span><br>
<%=3D3DFP_FieldVal(fp_rs,"address")%><br>
<%=3D3DFP_FieldVal(fp_rs,"city")%>,=3D20
<%=3D3DFP_FieldVal(fp_rs,"state")%> =3D20
<%=3D3DFP_FieldVal(fp_rs,"zipcode")%><br>
<%=3D3DFP_FieldVal(fp_rs,"phone")%><br>
<% If fp_rs("email") > " " then %><a
href=3D3D"mailto:<%=3D3DFP_FieldLink(fp_rs,"email")%>"><%=3D3DFP_FieldVal=
(fp_rs=3D
,"email")
%></a><% End If %><br>
<% If fp_rs("website") > " " then %><a target=3D3D_blank
href=3D3D"http://<%=3D3DFP_FieldLink(fp_rs,"website")%>"><%=3D3DFP_FieldV=
al(fp_=3D
rs,"websi
te")%></a><% End If %><br>
<br>
</td>
<%
If count =3D3D 2 Then
count =3D3D 0
%>
</tr>
<%
End If
%>
<!--#include file=3D3D"_fpclass/fpdbrgn2.inc"-->
<%If count <> 0 Then Response.Write "</tr>"%> </tbody> </table>
Thanks much,
Carol
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx =
or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to =
mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will =
also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, =
send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an =
invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
