I am only submitting one record to populate the table on the third page. -----Original Message----- From: Randi Knutson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 11:32 AM To: CF-Newbie Subject: Re: radio button selection
If multiple form fields with the same name are submitted, ColdFusion puts all the values in a comma-delimited list. That would be a complex object type: a list. I'd check the source code on your form to see what sort of values you are actually passing to the query. [email protected] on Wednesday, October 04, 2006 at 8:14 AM -0800 wrote: >I am working on a simple app, and I am trying to populate a table with >data from a query submitted on another page. One the first page the user >selects an input from a list dynamically populated from the database. >After a submit, the next page loads and the user is asked to choose, >using radio buttons, is asked to choose another input. Both of these >pages work fine. the problem happens when the users chooses an input >from the second page, and is redirected to the page with the table. > >When the page loads i get this error: Complex object types cannot be >converted to simple values. I am more or less doing the same thing. > >Here is the query from the third page: > ><cfset ownerid="#Form.owners#"> > ><cfquery name="worksheetfill" > datasource="#Request.MainDSN#"> > SELECT * > FROM OWNERS > WHERE RENTERID = <cfqueryparam value="#ownerid#"> ></cfquery> > >When i do a cfdump on the query, it pulls the right record from the >database, but once i try and output any of the fields i get the error. > >here is the first cfoutput tag: ><cfoutput query="#worksheetfill#">#FIRSTNAME#</cfoutput> > >Now I'm fairly new to coldfusion, but i did the same thing on the second >page and it worked fine. I have a feeling that using the radio buttons, >an array is getting passed. And since i'm new to cf, I'm not really sure >how to get at the data in an array. > >Here the query from the 2nd page: ><cfset hoa="#form.Properties#"> > ><cfquery name="owners" > datasource="#Request.MainDSN#"> > SELECT * > FROM HOAs INNER JOIN owners ON HOAs.hoaID = owners.project > WHERE HOAS.NAME = <cfqueryparam value="#hoa#" > ></cfquery> > >and here is the cfoutput loop: > ><cfform name="owner_data" method="post" action="rentalworksheet.cfm">The >are the owners at <cfoutput>#hoa#</cfoutput> are: > <cfoutput query="owners"> > <tr> > <td><input type="radio" name="owners" value='#OWNERS.RENTERID#' /></td> > <td>#OWNERS.FIRSTNAME# #OWNERS.LASTNAME#</td> > <td>#OWNERS.STREET# #OWNERS.CTY#, #OWNERS.STATE# #OWNERS.ZIP#</td> > </tr> > > </cfoutput> > >Any help with this would be greatly apprciated. Thank in advance. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2104 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
