Ben Forta - Where are you?...How to Count items in aSession Variable

[smokin_joe]

Borrowing off of the Shopping Cart program in Ben Forta's book CF 4.0.... I am
using session variables to create a list of entities that will print to mailing
labels. After playing with spacing and such I finally have the first column of
lables printing.

There are ten labels for each of 3 columns. When session basket count reaches
11 records I want to start printing in the next column.

I was considering using the "Session.Basket" as a counter, so that when the
record count of items in the session basket reaches 11 and then 21 I would
move the print to a different portion of the table to print the output.

When I do a CFDUMP is can see the contents of the session basket, and there
seems to be a row count for each of the records. Is there a way of accessing
that counter to do any sort of calculations?

Or, can anyone have any suggestions as to how to do this?

Thanks

[mpwoodward *TMM*]

On 2005-06-09 09:30:48 -0500, "smokin_joe" <webforumsuser@macromedia.com> said:

> Borrowing off of the Shopping Cart program in Ben Forta's book CF
> 4.0.... I am using session variables to create a list of entities that
> will print to mailing labels. After playing with spacing and such I
> finally have the first column of lables printing.
> There are ten labels for each of 3 columns. When session basket count
> reaches 11 records I want to start printing in the next column.
>
> I was considering using the "Session.Basket" as a counter, so that
> when the record count of items in the session basket reaches 11 and
> then 21 I would move the print to a different portion of the table to
> print the output.
>
> When I do a CFDUMP is can see the contents of the session basket, and
> there seems to be a row count for each of the records. Is there a way
> of accessing that counter to do any sort of calculations?
>
> Or, can anyone have any suggestions as to how to do this?
>
> Thanks

What kind of data is Session.Basket--is it an array, struct, or something else?

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[smokin_joe]

The session is set up in the "custom tag" page as <cfset session.basket =
queryNew("ProductID, CustomerID, SHLastName, SHFirstName, Prefix, BuildingNo,
StreetName, Suffix, Apt, SHCity, SHState, SHPostalCode")>"

While playing with different scenarios.... I have been able to retrieve the
number of records that have been written to the session variable by
outputting.... "session.basket.recordcount"... NOW the question becomes.... How
can I reference a particular record in the session.... any suggestions....
session.basket.recordID - - doesn't work ?

Thanks !!

[mpwoodward *TMM*]

On 2005-06-09 13:28:41 -0500, "smokin_joe" <webforumsuser@macromedia.com> said:

> The session is set up in the "custom tag" page as <cfset session.basket
> = queryNew("ProductID, CustomerID, SHLastName, SHFirstName, Prefix,
> BuildingNo, StreetName, Suffix, Apt, SHCity, SHState, SHPostalCode")>"
>
> While playing with different scenarios.... I have been able to
> retrieve the number of records that have been written to the session
> variable by outputting.... "session.basket.recordcount"... NOW the
> question becomes.... How can I reference a particular record in the
> session.... any suggestions.... session.basket.recordID - - doesn't
> work ?
>
> Thanks !!

From what you post here session.basket is a query, so you would
reference the items as you would any CF query object. Here's a couple
of links that should help:

[url]http://tinyurl.com/3w82w[/url]
(note the "attributes" like RecordCount, etc.)

[url]http://tinyurl.com/bou9q[/url]
(check out the Dot Notation, Index Notation, and Mixing Notation sections)

To get a count of items, if I'm understanding what you're saying it
would just be Session.Basket.RecordCount. That second link will give
you a lot of info about how to access specific query records.

Hope that helps,
Matt
--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[mpwoodward *TMM*]

On 2005-06-09 13:44:15 -0500, mpwoodward *TMM* <mpwoodward@gmail.com> said:

> On 2005-06-09 13:28:41 -0500, "smokin_joe" <webforumsuser@macromedia.com> said:
>

>> The session is set up in the "custom tag" page as <cfset session.basket
>> = queryNew("ProductID, CustomerID, SHLastName, SHFirstName, Prefix,
>> BuildingNo, StreetName, Suffix, Apt, SHCity, SHState, SHPostalCode")>"
>>
>> While playing with different scenarios.... I have been able to
>> retrieve the number of records that have been written to the session
>> variable by outputting.... "session.basket.recordcount"... NOW the
>> question becomes.... How can I reference a particular record in the
>> session.... any suggestions.... session.basket.recordID - - doesn't
>> work ?
>>
>> Thanks !!

>
> From what you post here session.basket is a query, so you would
> reference the items as you would any CF query object. Here's a couple
> of links that should help:
>
> [url]http://tinyurl.com/3w82w[/url]
> (note the "attributes" like RecordCount, etc.)

Sorry, that first link doesn't take you right to the cfquery discussion:
[url]http://tinyurl.com/crus3[/url]

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion