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:2112
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
