subject:"\"Query to structure\""

Re: Query to structure

2003-11-19 Thread Deanna Schneider

There's also a UDF on cflib.org that does this.
-d

- Original Message - 
From: "Ryan Mitchell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 19, 2003 7:14 AM
Subject: Re: Query to structure

> Thanks :)
>
> On 19/11/03 12:51 pm, "Tim Blair" <[EMAIL PROTECTED]> wrote:
>
> > Ryan,
> >
> >> > I want to take the query and convert it to a structure, with
> >> > the key being the column name and the value being the value
> >> > of the column...
> >
> > Simply loop over the column list:
> >
> > 
> > 
> > 
> > 
> >
> > Tim.
> >
> > ---
> > RAWNET LTD - Internet, New Media and ebusiness Gurus.
> > Visit our new website at http://www.rawnet.com for
> > more information about our company, or call us free
> > anytime on 0800 294 24 24.
> > ---
> > Tim Blair
> > Web Application Engineer, Rawnet Limited
> > Direct Phone : +44 (0) 1344 393 441
> > Switchboard : +44 (0) 1344 393 040
> > ---
> > This message may contain information which is legally
> > privileged and/or confidential.  If you are not the
> > intended recipient, you are hereby notified that any
> > unauthorised disclosure, copying, distribution or use
> > of this information is strictly prohibited. Such
> > notification notwithstanding, any comments, opinions,
> > information or conclusions expressed in this message
> > are those of the originator, not of rawnet limited,
> > unless otherwise explicitly and independently indicated
> > by an authorised representative of rawnet limited.
> > 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Query to structure

2003-11-19 Thread Ryan Mitchell

Thanks :)

On 19/11/03 12:51 pm, "Tim Blair" <[EMAIL PROTECTED]> wrote:

> Ryan,
> 
>> > I want to take the query and convert it to a structure, with
>> > the key being the column name and the value being the value
>> > of the column...
> 
> Simply loop over the column list:
> 
> 
> 
> 
> 
> 
> Tim.
> 
> ---
> RAWNET LTD - Internet, New Media and ebusiness Gurus.
> Visit our new website at http://www.rawnet.com for
> more information about our company, or call us free
> anytime on 0800 294 24 24.
> ---
> Tim Blair
> Web Application Engineer, Rawnet Limited
> Direct Phone : +44 (0) 1344 393 441
> Switchboard : +44 (0) 1344 393 040
> ---
> This message may contain information which is legally
> privileged and/or confidential.  If you are not the
> intended recipient, you are hereby notified that any
> unauthorised disclosure, copying, distribution or use
> of this information is strictly prohibited. Such
> notification notwithstanding, any comments, opinions,
> information or conclusions expressed in this message
> are those of the originator, not of rawnet limited,
> unless otherwise explicitly and independently indicated
> by an authorised representative of rawnet limited.
> ---
> 
> 
> 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Query to structure

2003-11-19 Thread Tim Blair

Ryan,

> I want to take the query and convert it to a structure, with 
> the key being the column name and the value being the value 
> of the column...

Simply loop over the column list:



    


Tim.

---
RAWNET LTD - Internet, New Media and ebusiness Gurus.
Visit our new website at http://www.rawnet.com for
more information about our company, or call us free
anytime on 0800 294 24 24.
---
Tim Blair
Web Application Engineer, Rawnet Limited
Direct Phone : +44 (0) 1344 393 441
Switchboard : +44 (0) 1344 393 040
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of rawnet limited,
unless otherwise explicitly and independently indicated
by an authorised representative of rawnet limited.
---


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Query to structure

2003-11-19 Thread Mike Townend

You could try something like...

 


 


    


 


HTH

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 19, 2003 12:42
To: CF-Talk
Subject: Query to structure

Hello

I have a query which returns one row with a lot of columns...
I want to take the query and convert it to a structure, with the key being
the column name and the value being the value of the column...

How do you do this?

Ryan

  _  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Query to structure

2003-11-19 Thread Ryan Mitchell

Hello

I have a query which returns one row with a lot of columns...
I want to take the query and convert it to a structure, with the key being
the column name and the value being the value of the column...

How do you do this?

Ryan

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: Query to Structure with keys...

2002-12-11 Thread Che Vilnonis

Thanks...you gotta love CFLIB.org!
I can't believe I forgot about that resource.

-Original Message-
From: Matthew Friedman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:37 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...

If you are looking at moving a query to a structure there is a great UDF on
cflib that I use all the time.

Try this below (this is not my code!!!)

and then put the output into a cfdump to see the outcome.

For full documentation look at www.CFlib.org.

/**
 * Converts a query object into a structure of structures accessible by its
primary key.
 *
 * @param theQuery   The query you want to convert to a structure of
structures.
 * @param primaryKey Query column to use as the primary key.
 * @return Returns a structure.
 * @author Shawn Seley ([EMAIL PROTECTED])
 * @version 1, March 27, 2002
 */
function QueryToStructOfStructures(theQuery, primaryKey){
  var theStructure  = structnew();
  // remove primary key from cols listing
  var cols  = ListToArray(ListDeleteAt(theQuery.columnlist,
ListFindNoCase(theQuery.columnlist, primaryKey)));
  var row   = 1;
  var thisRow   = "";
  var col   = 1;

  for(row = 1; row LTE theQuery.recordcount; row = row + 1){
thisRow = structnew();
for(col = 1; col LTE arraylen(cols); col = col + 1){
  thisRow[cols[col]] = theQuery[cols[col]][row];
}
theStructure[theQuery[primaryKey][row]] = duplicate(thisRow);
  }
  return(theStructure);
}

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:20 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...

Code examples would be great!!!

-Original Message-
From: Matthew Friedman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:24 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...

you could use the valuelist(query.colname) function to do this with out the
loop

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:13 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...

First of all, if you want to use the Product ID's you need to return them
with the Select Clause.  Just using a field in the where clause does not
return them.

SELECT Product_ID, PartNumber, ProductTitle
FROM   Products P
WHEREProduct_ID IN

(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)

Then what I've done in the past is just loop over the query and create a
structure.  I'd love to know if there are any more direct ways to do this.

productStruct = newStruct();
for (i=1;i<=getProductDetails.recordcount;i=i+1)
{
tempArray = newArray(1);
tempArray[1] = getProductDetails.PartNumber;
tempArray[2] = getProductDetails.ProductTitle;
productStruc[getProductDetails.Product_ID][i] = tempArray;
}

Then you should be able to play with your new structure something like this.

PartNumberProductTitle

#productStruct['9911'][1]##productStruct['9911'][2]#

Please pardon in problem with my  code.  I just wrote that off the
top of my head, and I don't use  all that often.

I hope this helps.

Ian Skinner

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:13 AM
To: CF-Talk
Subject: Query to Structure with keys...

Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.

I have this query...

SELECT PartNumber, ProductTitle
FROM   Products P

WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)

I would to place this query into a structure. The keys need to come from the
Product_IDs
in the where clause of the query. Each key has as its value, the column
names that are returned.

Any ideas on how to do this???  based code samples would be
appreciated.

Ché Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

RE: Query to Structure with keys...

2002-12-11 Thread Matthew Friedman

If you are looking at moving a query to a structure there is a great UDF on
cflib that I use all the time.

Try this below (this is not my code!!!)

and then put the output into a cfdump to see the outcome.


For full documentation look at www.CFlib.org.


/**
 * Converts a query object into a structure of structures accessible by its
primary key.
 *
 * @param theQuery   The query you want to convert to a structure of
structures.
 * @param primaryKey Query column to use as the primary key.
 * @return Returns a structure.
 * @author Shawn Seley ([EMAIL PROTECTED])
 * @version 1, March 27, 2002
 */
function QueryToStructOfStructures(theQuery, primaryKey){
  var theStructure  = structnew();
  // remove primary key from cols listing
  var cols  = ListToArray(ListDeleteAt(theQuery.columnlist,
ListFindNoCase(theQuery.columnlist, primaryKey)));
  var row   = 1;
  var thisRow   = "";
  var col   = 1;

  for(row = 1; row LTE theQuery.recordcount; row = row + 1){
thisRow = structnew();
for(col = 1; col LTE arraylen(cols); col = col + 1){
  thisRow[cols[col]] = theQuery[cols[col]][row];
}
theStructure[theQuery[primaryKey][row]] = duplicate(thisRow);
  }
  return(theStructure);
}


-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:20 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...



Code examples would be great!!!

-Original Message-
From: Matthew Friedman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:24 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...


you could use the valuelist(query.colname) function to do this with out the
loop



-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:13 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...



First of all, if you want to use the Product ID's you need to return them
with the Select Clause.  Just using a field in the where clause does not
return them.


SELECT Product_ID, PartNumber, ProductTitle
FROM   Products P
WHEREProduct_ID IN

(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)


Then what I've done in the past is just loop over the query and create a
structure.  I'd love to know if there are any more direct ways to do this.


productStruct = newStruct();
for (i=1;i<=getProductDetails.recordcount;i=i+1)
{
tempArray = newArray(1);
tempArray[1] = getProductDetails.PartNumber;
tempArray[2] = getProductDetails.ProductTitle;
productStruc[getProductDetails.Product_ID][i] = tempArray;
}


Then you should be able to play with your new structure something like this.


PartNumberProductTitle

#productStruct['9911'][1]##productStruct['9911'][2]#


Please pardon in problem with my  code.  I just wrote that off the
top of my head, and I don't use  all that often.

I hope this helps.

Ian Skinner

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:13 AM
To: CF-Talk
Subject: Query to Structure with keys...


Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.

I have this query...


SELECT PartNumber, ProductTitle
FROM   Products P

WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)


I would to place this query into a structure. The keys need to come from the
Product_IDs
in the where clause of the query. Each key has as its value, the column
names that are returned.

Any ideas on how to do this???  based code samples would be
appreciated.

Ché Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

RE: Query to Structure with keys...

2002-12-11 Thread Che Vilnonis

Code examples would be great!!!

-Original Message-
From: Matthew Friedman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:24 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...

you could use the valuelist(query.colname) function to do this with out the
loop

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:13 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...

First of all, if you want to use the Product ID's you need to return them
with the Select Clause.  Just using a field in the where clause does not
return them.

SELECT Product_ID, PartNumber, ProductTitle
FROM   Products P
WHEREProduct_ID IN

(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)

Then what I've done in the past is just loop over the query and create a
structure.  I'd love to know if there are any more direct ways to do this.

productStruct = newStruct();
for (i=1;i<=getProductDetails.recordcount;i=i+1)
{
tempArray = newArray(1);
tempArray[1] = getProductDetails.PartNumber;
tempArray[2] = getProductDetails.ProductTitle;
productStruc[getProductDetails.Product_ID][i] = tempArray;
}

Then you should be able to play with your new structure something like this.

PartNumberProductTitle

#productStruct['9911'][1]##productStruct['9911'][2]#

Please pardon in problem with my  code.  I just wrote that off the
top of my head, and I don't use  all that often.

I hope this helps.

Ian Skinner

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:13 AM
To: CF-Talk
Subject: Query to Structure with keys...

Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.

I have this query...

SELECT PartNumber, ProductTitle
FROM   Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)

I would to place this query into a structure. The keys need to come from the
Product_IDs
in the where clause of the query. Each key has as its value, the column
names that are returned.

Any ideas on how to do this???  based code samples would be
appreciated.

Ché Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

RE: Query to Structure with keys...

2002-12-11 Thread Matthew Friedman

you could use the valuelist(query.colname) function to do this with out the
loop

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 3:13 PM
To: CF-Talk
Subject: RE: Query to Structure with keys...

First of all, if you want to use the Product ID's you need to return them
with the Select Clause.  Just using a field in the where clause does not
return them.

SELECT Product_ID, PartNumber, ProductTitle
FROM   Products P
WHEREProduct_ID IN

(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)

Then what I've done in the past is just loop over the query and create a
structure.  I'd love to know if there are any more direct ways to do this.

productStruct = newStruct();
for (i=1;i<=getProductDetails.recordcount;i=i+1)
{
tempArray = newArray(1);
tempArray[1] = getProductDetails.PartNumber;
tempArray[2] = getProductDetails.ProductTitle;
productStruc[getProductDetails.Product_ID][i] = tempArray;
}

Then you should be able to play with your new structure something like this.

PartNumberProductTitle

#productStruct['9911'][1]##productStruct['9911'][2]#

Please pardon in problem with my  code.  I just wrote that off the
top of my head, and I don't use  all that often.

I hope this helps.

Ian Skinner

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:13 AM
To: CF-Talk
Subject: Query to Structure with keys...

Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.

I have this query...

SELECT PartNumber, ProductTitle
FROM   Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)

I would to place this query into a structure. The keys need to come from the
Product_IDs
in the where clause of the query. Each key has as its value, the column
names that are returned.

Any ideas on how to do this???  based code samples would be
appreciated.

Ché Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: Query to Structure with keys...

2002-12-11 Thread Ian Skinner

First of all, if you want to use the Product ID's you need to return them
with the Select Clause.  Just using a field in the where clause does not
return them.


SELECT Product_ID, PartNumber, ProductTitle
FROM   Products P
WHEREProduct_ID IN

(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)


Then what I've done in the past is just loop over the query and create a
structure.  I'd love to know if there are any more direct ways to do this.


productStruct = newStruct();
for (i=1;i<=getProductDetails.recordcount;i=i+1)
{   
tempArray = newArray(1);
tempArray[1] = getProductDetails.PartNumber;
tempArray[2] = getProductDetails.ProductTitle;
productStruc[getProductDetails.Product_ID][i] = tempArray;
}


Then you should be able to play with your new structure something like this.


PartNumberProductTitle

#productStruct['9911'][1]##productStruct['9911'][2]#


Please pardon in problem with my  code.  I just wrote that off the
top of my head, and I don't use  all that often.

I hope this helps.

Ian Skinner

-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:13 AM
To: CF-Talk
Subject: Query to Structure with keys...


Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.

I have this query...


SELECT PartNumber, ProductTitle
FROM   Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)


I would to place this query into a structure. The keys need to come from the
Product_IDs
in the where clause of the query. Each key has as its value, the column
names that are returned.

Any ideas on how to do this???  based code samples would be
appreciated.

Ché Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Query to Structure with keys...

2002-12-11 Thread Che Vilnonis

Hey its Brainfart Wednesday. Everyday lately seems to be a brainfart.

I have this query...


SELECT PartNumber, ProductTitle
FROM   Products P
WHEREProduct_ID IN
(9909,9910,9911,9912,9913,9914,9371,9372,9378,9380,9855,8081,9631)


I would to place this query into a structure. The keys need to come from the
Product_IDs
in the where clause of the query. Each key has as its value, the column
names that are returned.

Any ideas on how to do this???  based code samples would be
appreciated.

Ché Vilnonis
Application Developer
Advertising Systems Incorporated
8470C Remington Avenue
Pennsauken, NJ 08110
p: 856.488.2211
f: 856.488.1990
www.asitv.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: How to convert 1-record query to structure (EBW)

2002-11-24 Thread Jeffry Houser

At 12:47 AM 11/25/2002 -0500, you wrote:
>Thanks for the input.  I usually work with the Query object when getting
>record sets, but when I'm creating new or editing existing records (e.g.
>user or event), the form will pass all these fields to target tag (actually
>to index.cfm using Fusebox architecture), which will then validate them and
>pass them to a model fuseaction, which will finally pass them to a
>StoredProc to insert/update the table.
>
>So, in this case I'm looking to pass just the UserDetails structure, instead
>of the 10+ fields that it contains.  Hence, my apparently suboptimal desire
>to convert the 1-record query into a structure.

  I did not understand that this is what you were trying to do from the 
original post.  I bet writing a function to return a single row of a query 
might be good for these situations, because I can't think of a way off the 
top of my head to accomplish the task.

  I just looked.  Here is the function:

  It looks as if it uses a method similar to what we discussed, except it 
is using CFScript.  The function should work in both CF5 and CFMX.

>Thanks for your input and advice.  I do have & have read CF WACK (Forta),
>Instant CF (yours) and CFML Reference, but will flip through them again for
>variations on passing numerous fields for processing.

  ( Thanks for the support )

--
Jeffry Houser | mailto:[EMAIL PROTECTED]
DotComIt, Putting you on the web
AIM: Reboog711  | Phone: 1-203-379-0773
--
My CFMX Book: 

My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: How to convert 1-record query to structure (EBW)

2002-11-24 Thread Erik Britt-Webb

Jeffry,

Thanks for the input.  I usually work with the Query object when getting
record sets, but when I'm creating new or editing existing records (e.g.
user or event), the form will pass all these fields to target tag (actually
to index.cfm using Fusebox architecture), which will then validate them and
pass them to a model fuseaction, which will finally pass them to a
StoredProc to insert/update the table.

So, in this case I'm looking to pass just the UserDetails structure, instead
of the 10+ fields that it contains.  Hence, my apparently suboptimal desire
to convert the 1-record query into a structure.

Thanks for your input and advice.  I do have & have read CF WACK (Forta),
Instant CF (yours) and CFML Reference, but will flip through them again for
variations on passing numerous fields for processing.

Thanks,
Erik

-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 24, 2002 1:41 PM
To: CF-Talk
Subject: Re: How to convert 1-record query to structure (EBW)

At 10:15 AM 11/24/2002 -0500, you wrote:
>I'm selecting a single record from SQL Server and want to pass the results
>as a structured variable, rather than a query variable.  How do I obtain
the
>list of fields in the query so that I can loop through them?

  queryname.columnlist will give you the list of fields, but I'm not sure
why you would want to do this.

  First off, you do understand that you can access a query as a structure
of arrays?

  If you want to access the 10th record of a query, you can do this:
Queryname.Column[10]

  If you leave out the array index, the first row is automatically returned
(Unless you are looping over the query, the current row is returned )

  As far as this code:

>
>
>  
>
>
>Looping through collection:  works for valid struct or COM object, but not
>for query object
>
>
>
> UserRole.#var# = #UserRole[var]#
>
>

  You can loop through a query, using either cfloop or cfoutput, both with
the query attribute.  And then you can use cfloop to loop over the column
list.  So all of the above code can be condensed into something like this:

  http://livedocs.macromedia.com/cfmxdocs/dochome.jsp
  There is similar documents in the ColdFusion 5 Docs.

  If you want to buy a book, I can plug some of my own
  ( ColdFusion: A Beginner's Guide
<http://www.amazon.com/exec/obidos/ASIN/0072191090/instantcoldfu-20> or
ColdFusion: The Complete Reference:
<http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20> )

--
Jeffry Houser | mailto:[EMAIL PROTECTED]
DotComIt, Putting you on the web
AIM: Reboog711  | Phone: 1-203-379-0773
--
My CFMX Book:
<http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20>
My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Re: How to convert 1-record query to structure (EBW)

2002-11-24 Thread Jeffry Houser

At 10:15 AM 11/24/2002 -0500, you wrote:
>I'm selecting a single record from SQL Server and want to pass the results
>as a structured variable, rather than a query variable.  How do I obtain the
>list of fields in the query so that I can loop through them?

  queryname.columnlist will give you the list of fields, but I'm not sure 
why you would want to do this.

  First off, you do understand that you can access a query as a structure 
of arrays?

  If you want to access the 10th record of a query, you can do this:
Queryname.Column[10]

  If you leave out the array index, the first row is automatically returned 
(Unless you are looping over the query, the current row is returned )

  As far as this code:

>
>
>  
>
>
>Looping through collection:  works for valid struct or COM object, but not
>for query object
>
>
>
> UserRole.#var# = #UserRole[var]#
>
>

  You can loop through a query, using either cfloop or cfoutput, both with 
the query attribute.  And then you can use cfloop to loop over the column 
list.  So all of the above code can be condensed into something like this:

  http://livedocs.macromedia.com/cfmxdocs/dochome.jsp
  There is similar documents in the ColdFusion 5 Docs.

  If you want to buy a book, I can plug some of my own
  ( ColdFusion: A Beginner's Guide 
 or 
ColdFusion: The Complete Reference: 
 )

--
Jeffry Houser | mailto:[EMAIL PROTECTED]
DotComIt, Putting you on the web
AIM: Reboog711  | Phone: 1-203-379-0773
--
My CFMX Book: 

My Books: http://www.instantcoldfusion.com
My Band: http://www.farcryfly.com 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

How to convert 1-record query to structure (EBW)

2002-11-24 Thread Erik Britt-Webb

I'm selecting a single record from SQL Server and want to pass the results
as a structured variable, rather than a query variable.  How do I obtain the
list of fields in the query so that I can loop through them?

I know how to loop through a collection of fields in a structured variable
and I know how to loop through a list of fields that I define, but I don't
know how to obtain the list of fields in a query.  Any tips would be great.
Below are the examples I do know.

Looping through query based on explicit list of fields



 


Looping through collection:  works for valid struct or COM object, but not
for query object



UserRole.#var# = #UserRole[var]#



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Re: Query to structure

Re: Query to structure

RE: Query to structure

RE: Query to structure

Query to structure

RE: Query to Structure with keys...

RE: Query to Structure with keys...

RE: Query to Structure with keys...

RE: Query to Structure with keys...

RE: Query to Structure with keys...

Query to Structure with keys...

RE: How to convert 1-record query to structure (EBW)

RE: How to convert 1-record query to structure (EBW)

Re: How to convert 1-record query to structure (EBW)

How to convert 1-record query to structure (EBW)

15 matches

Site Navigation

Mail list logo

Footer information