Building a structure dynamically from a query

[Scott Stewart]

Hey all, 

 

I’m building a structure dynamically from a query:

 

<cfquery name="qGetPageList" datasource="#request.dsn#">

SELECT *

            FROM tbl_page_indentifier

</cfquery>

<!--- creates structure to list pages --->

<cfset pageStruct=StructNew()>

<cfloop query="qGetPageList">

<cfset
Temp=StructInsert(pageStruct,qGetPageList.PK_page_id,qGetPageList.page_id_na
me,TRUE)>

</cfloop>

Then trying to loop over it to build a cfgrid

 

<cfloop collection="pageStruct" item="">

         <cfgridrow data ="#StructFind(pageStruct,
"qGetPageList.PK_page_id")#,#StructFind(pageStruct,
qGetPageList.page_id_name)#">

    </cfloop>

 

And I get this error

 


500 Cannot find key qGetPageList.PK_page_id in struct.


Cannot find key qGetPageList.PK_page_id in struct.

 

 

Any ideas?

 





Scott Stewart
ColdFusion Developer 

HYPERLINK
"http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=7241+Jillspring+Ct&csz=Sprin
gfield%2C+VA.+22152&country=us" \n7241 Jillspring Ct
Springfield, VA. 22152 


HYPERLINK "mailto:[EMAIL PROTECTED]" [EMAIL PROTECTED]
HYPERLINK "http://www.sstwebworks.com"; \nhttp://www.sstwebworks.com 


tel: 
mobile: 

HYPERLINK
"http://www.plaxo.com/click_to_call?src=jj_signature&To=703-912-3076&Email=s
[EMAIL PROTECTED]" \n703-912-3076 
HYPERLINK
"http://www.plaxo.com/click_to_call?src=jj_signature&To=703-220-2835&Email=s
[EMAIL PROTECTED]" \n703-220-2835 

 



HYPERLINK
"https://www.plaxo.com/add_me?u=25770055805&src=client_sig_212_1_card_join&i
nvite=1" \nAlways have my latest info

HYPERLINK "http://www.plaxo.com/signature?src=client_sig_212_1_card_sig";
\nWant a signature like this?

 


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.8/714 - Release Date: 3/8/2007
10:58 AM
 
  


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & 
Flex 2. 
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272232
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4