Well, in your debugging, you are passing a list (your list of radio values)
to the query, which I am assuming is looking for an int.
Just to get your debugging working right, try this:
<cfquery name="worksheetfill"
datasource="#Request.MainDSN#">
SELECT *
FROM OWNERS
WHERE OWNERID IN (<cfqueryparam cfsqltype="CF_SQL_INTEGER"
value="#FORM.owners#" list="Yes">)
</cfquery>
<cfdump var="#worksheetfill#">
> -----Original Message-----
> From: Robert Makowski [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 06, 2006 10:20 AM
> To: CF-Newbie
> Subject: RE: radio buttons
> Importance: High
>
> 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:2110
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
