Display text when GroupID Changes
i've got asp recordset pulling sqldb. each row db includes groupid, indicating group row belongs too. @ each change in groupid, i'd display header introduce group. how tell asp page display header text when groupid changes 1 2 or 3 4, etc.
if header information included in recordset code
is relatively simple , this.
above repeat region place code
<% dim testid, thisid
testid = 0
%>
then in repeat region want header following
<%
thisid = recordset.field.item("groupid").value
if testid <> thisid
response.write recordset.field.item("headername").value
end if
testid = thisid
%>
however if heading not in database rather want enter
them code inside repeat region change
<%
thisid = recordset.field.item("groupid").value
if testid <> thisid
select case thisid
case 1
response.write ("header 1 name")
case 2
response.write ("header 2 name")
end select
testid = thisid
%>
--
paul whitham
certified dreamweaver mx2004 professional
adobe community expert - dreamweaver
valleybiz internet design
www.valleybiz.net
"lucky kitty" <webforumsuser@macromedia.com> wrote in message
news:f1ndl3$cm3$1@forums.macromedia.com...
> i've got asp recordset pulling sqldb. each row db
> includes
> groupid, indicating group row belongs too. @ each change in
> groupid, i'd display header introduce group. how
> tell
> asp page display header text when groupid changes 1
> 2 or
> 3 4, etc.
>
>
is relatively simple , this.
above repeat region place code
<% dim testid, thisid
testid = 0
%>
then in repeat region want header following
<%
thisid = recordset.field.item("groupid").value
if testid <> thisid
response.write recordset.field.item("headername").value
end if
testid = thisid
%>
however if heading not in database rather want enter
them code inside repeat region change
<%
thisid = recordset.field.item("groupid").value
if testid <> thisid
select case thisid
case 1
response.write ("header 1 name")
case 2
response.write ("header 2 name")
end select
testid = thisid
%>
--
paul whitham
certified dreamweaver mx2004 professional
adobe community expert - dreamweaver
valleybiz internet design
www.valleybiz.net
"lucky kitty" <webforumsuser@macromedia.com> wrote in message
news:f1ndl3$cm3$1@forums.macromedia.com...
> i've got asp recordset pulling sqldb. each row db
> includes
> groupid, indicating group row belongs too. @ each change in
> groupid, i'd display header introduce group. how
> tell
> asp page display header text when groupid changes 1
> 2 or
> 3 4, etc.
>
>
More discussions in Develop server-side applications in Dreamweaver
adobe
Comments
Post a Comment