Robert I think it is because you are using hash/pound signs around the query name in the cfoutput
You want to reference the literal name of the query in this piece of code so you want to remove the hashes/pound signs: <cfoutput query="worksheetfill">#firstname#</cfoutput> try that and see how you get on? On 10/6/06, Robert Makowski <[EMAIL PROTECTED]> wrote: > Ok, so I changed it so it just had #firstname#, and I still received the > error. > > Here is the code from the radio button 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> > <!--<cfdump var="#owners#"></cfdump>--> > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> > <html xmlns="http://www.w3.org/1999/xhtml";> > <head> > <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" > /> > <title>HOA Owner Infomation</title> > </head> > > <body> > <center> > <table border="1"> > <tr> > <td></td> > <td align="center">Names</td> > <td align="center">Addresses</td> > </tr> > <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.OWNERID#' checked/></td> > <td>#OWNERS.FIRSTNAME# #OWNERS.LASTNAME#</td> > <td>#OWNERS.STREET# #OWNERS.CTY#, #OWNERS.STATE# > #OWNERS.ZIP#</td> > </tr> > > </cfoutput> > </table> > <br /> > > <input type="submit" /> > </cfform> > > So really all I'm trying to do is enable the user to choose a owner from > the list using a radio button selection, then submit it, and I want the > table on the worksheet page to fill with the appropriate data. > > -----Original Message----- > From: RichL [mailto:[EMAIL PROTECTED] > Sent: Friday, October 06, 2006 10:26 AM > To: CF-Newbie > Subject: Re: radio buttons > > Robert > > Do you need the 'owners.' in prefixed before the 'firstname' variable? > I am not too sure why you have got this? > > If firstname is a column in the 'worksheetfill' query and you have > specified that you are outputting that query in the opening <cfoutput> > tag then you should be able to reference firstname just as > '#firstname#' > > On 10/6/06, Robert Makowski <[EMAIL PROTECTED]> wrote: > > Well I'm trying to populate a table, but when that didn't work I > started > > debugging. Here is the code: > > > > <cfset ownerid="#Form.owners#"> > > > > <cfquery name="worksheetfill" > > datasource="#Request.MainDSN#"> > > SELECT * > > FROM OWNERS > > WHERE OWNERID = <cfqueryparam value="#ownerid#"> > > </cfquery> > > <!-- <cfdump var="#worksheetfill#"> --> > > <cfoutput query="#worksheetfill#">#owners.firstname#</cfoutput> > > > > When I try to output the firstname variable, I get this error message: > > Complex object types cannot be converted to simple values. > > > > The expression has requested a variable or an intermediate expression > > result as a simple value, however, the result cannot be converted to a > > simple value. Simple values are strings, numbers, boolean values, and > > date/time values. Queries, arrays, and COM objects are examples of > > complex values. > > > > So at this point I'm stumped. Any help would be appreciated. Thanks > in > > advance. > > > > > > > > -----Original Message----- > > From: Mike Chytracek [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 06, 2006 10:02 AM > > To: CF-Newbie > > Subject: RE: radio buttons > > > > The fun thing with radios is you have to check to see if they are > > defined. > > If you do not require a radio group to be selected it will not come > thru > > defined. > > > > What kind of problems are you having? > > > > Mike > > > > -----Original Message----- > > From: Robert Makowski [mailto:[EMAIL PROTECTED] > > Sent: Friday, October 06, 2006 8:45 AM > > To: CF-Newbie > > Subject: radio buttons > > > > I am trying to populate a table from a dynamically generated list > using > > radio buttons. I am running into problems with this, can someone > > explain how this is done or give an example? > > > > > > > > Robert Makowski > > > > IT Manager > > > > Patriot Residential Management > > > > phone: 904.483.5160 x5165 > > > > [EMAIL PROTECTED] > > > > > > > > ! vv!11 pwnz0r |_| > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2113 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
