Stephen,
Do you have the possibility to manipulate the query? You could perhaps
transpose/pivot it, if your database server supports that.
/Hugo
--
Hugo Ahlenius
-------------------------------------------------------------
Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
Project Officer Phone: +46 8 412 1427
UNEP GRID-Arendal Fax: +46 8 723 0348
Stockholm Office Mobile: +46 733 467111
WWW: http://www.grida.no
Skype: callto:fraxxinus
-------------------------------------------------------------
| -----Original Message-----
| From: [EMAIL PROTECTED]
| [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Adams
| Sent: Tuesday, February 21, 2006 11:04
| To: [email protected]
| Subject: Re: [CFCDev] Is it possible to get a section of a structure?
|
| Hi,
|
| I found that the structure I wanted to manipulate, which is returned
| from a query, only has one row but loads of columns.
| It comes returnes a dataset from a database which was designed by some
| one else so I have no control over its structure.
|
| So my original idea of taking a subsection of the structure, which I
| was going to use to display sections of these columns would not be
| possible, but these columns do have a ColumnList. I am now trying to
| step through this list in groups of 10. So I' get the first ten
| elements of the column list, loop through these and then get the next
| ten and then the next ten until I've been through all the elements in
| the list.
|
| I'm trying to create a next and previous section, where the user can
| see results in groups of ten and go back a forth through the result.
| But unfortunately due to the odd structure of the database table, with
| one row and loads of columns I can't simply step through the CFOUTPUT.
|
|
|
| On 2/21/06, Charlie Griefer <[EMAIL PROTECTED] > wrote:
|
| Not sure that's really practical, as a structure is unordered.
|
| for example, if i have a structure for employee data
| (containing keys
| firstname, lastname, address, and phone)...i don't
| believe i have any
| control over how the struct is...um...structured.
|
| quick test:
|
| <cfscript>
| foo = structNew();
| foo.firstName = "charlie";
| foo.lastName = "griefer";
| foo.address = "123 Main Street";
| foo.phone = "555-1212";
| </cfscript>
|
| <cfoutput>
| <cfloop collection="#foo#" item="key">
| #key#: #foo[key]#<br />
| </cfloop>
| </cfoutput>
|
| <br /><br />
|
| <cfscript>
| for (key in foo) {
| writeOutput(key & ": " & foo[key] & "<br />");
| }
| </cfscript>
|
| now, i used tags and cfscript to see if there was any
| difference in
| the order of output between the two (there was
| not)...but both output
| in the following order:
|
| phone
| lastname
| address
| firstname
|
| even though the structure was created in the order of:
|
| firstname
| lastname
| address
| phone
|
| ...so if this is a consistent (and unpredictable) behavior...is
| 'paging thru' a structure 'n' keys at a time really what you're
| looking to do?
|
| On 2/20/06, Stephen Adams <[EMAIL PROTECTED]> wrote:
| > Hi,
| >
| > Is it possible to get a section of a structure, for
| example can I get the
| > first ten key/value pairs of a structure then the
| next ten. I trying to page
| > through a structure ten rows at a time.
| >
| > I was thinking of using StructCount to get a number
| for the amount of values
| > in the structure then using that some how to step
| through the structure. Has
| > anyone every done something like this?
| >
| > Stephen
| > ----------------------------------------------------------
| > You are subscribed to cfcdev. To unsubscribe, send
| an email to
| > [email protected] with the words 'unsubscribe
| cfcdev' as the subject of the
| > email.
| >
| > CFCDev is run by CFCZone (www.cfczone.org) and
| supported by CFXHosting
| > (www.cfxhosting.com).
| >
| > An archive of the CFCDev list is available at
| > www.mail-archive.com/[email protected]
|
|
| --
| Charlie Griefer
|
| ================================================
| "...All the world shall be your enemy, Prince with a
| Thousand Enemies,
| and whenever they catch you, they will kill you. But
| first they must catch
| you, digger, listener, runner, prince with a swift warning.
| Be cunning and full of tricks and your people shall
| never be destroyed."
|
|
| ----------------------------------------------------------
| You are subscribed to cfcdev. To unsubscribe, send an
| email to [email protected] with the words 'unsubscribe
| cfcdev' as the subject of the email.
|
| CFCDev is run by CFCZone (www.cfczone.org) and
| supported by CFXHosting (www.cfxhosting.com).
|
| An archive of the CFCDev list is available at
| www.mail-archive.com/[email protected]
|
|
|
|
|
| ----------------------------------------------------------
| You are subscribed to cfcdev. To unsubscribe, send an email
| to [email protected] with the words 'unsubscribe cfcdev' as
| the subject of the email.
|
| CFCDev is run by CFCZone (www.cfczone.org) and supported by
| CFXHosting (www.cfxhosting.com).
|
| An archive of the CFCDev list is available at
| www.mail-archive.com/[email protected]
|
###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
