add counting in DRW

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

add counting in DRW

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> add counting in DRW

Page: [1]

ACEDISH

Posts: 176
Joined: 9/30/2002
From: Manassas, Virginia
Status: offline

add counting in DRW - 12/21/2004 10:36:39

I want to add a count when creating session varibles as it loops through the database.....
for example:
<% Session("header")=FP_FieldHTML(fp_rs,"header")%>

will create the session for header but i need to add 1,2,3,4 etc to the session varible
<% Session("header1")=FP_FieldHTML(fp_rs,"header")%>

and the next to be
<% Session("header2")=FP_FieldHTML(fp_rs,"header")%>

and so on:

here is the drw code on a diet

thanks,
Coz

<%
fp_sQry="SELECT * FROM Results WHERE (exp <=  '::todaysdate::' AND site = '::site::')"
fp_sDefault="todaysdate=&site=site23"
fp_sNoRecords=""
fp_sDataConn="dblinks"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&ID=3&header=202&message=203&link=202&exp=202&site=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&"
fp_iDisplayCols=5
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->

<% Session("header")=FP_FieldHTML(fp_rs,"header")%>
<% Session("message=FP_FieldHTML(fp_rs,"message")%>
<% Session("link")=FP_FieldHTML(fp_rs,"link")%>
<% Session("site")=FP_FieldHTML(fp_rs,"site")%>
<%count=count=1 %>

<!--#include file="../../_fpclass/fpdbrgn2.inc"-->

_____________________________

" Anyone who can only think of one way to spell a word obviously lacks imagination"


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: add counting in DRW - 12/21/2004 10:47:04 quote: <% Session("header")=FP_FieldHTML(fp_rs,"header")%> How about this: <% Session("header" & FP_iCount)=FP_FieldHTML(fp_rs,"header")%> That should give you session names of "header1", "header2", etc. That help any? _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to ACEDISH)


ACEDISH Posts: 176 Joined: 9/30/2002 From: Manassas, Virginia Status: offline	RE: add counting in DRW - 12/21/2004 12:18:51 thanks.... that will work _____________________________ " Anyone who can only think of one way to spell a word obviously lacks imagination" (in reply to rdouglass)