Adobe Community : All Content - All Communities

Binding Form Elements to Query Data

forums_noreply@adobe.com — Fri, 15 Mar 2013 03:07:43 GMT

Hello,

I have a simple form thatI'm binding query data to so I can populates a cselect box and, based on the selection, populate cfinput boxes. I have the code for this form in a <cfinclude template> and it is working just as designed.

But strangely enough, if I wrap the <cfinclude> code that contains my form in <cfdiv> tags, the binding breaks.

What would be causing that? Any help would be super greatly appreciated.

-Brian

Main Page Code with form:

<cfdiv>

</cfdiv>

CFInclude File:

<img src="images/service_vehicle.png" alt="Vehicle Log" /> <strong>Vehicle Log </strong> </legend>

<tr>

<td><label>Service Vehicle:</label></td>

</cfselect> </td>

</tr>

<tr>

<td>Origin:<br />

</tr>

<tr>

<td>Destination:</td>

</tr>

<tr>

<td><label>Start Odometer:</label></td>

</tr>

<tr>

<td>End Odometer:</td>

</tr>

<tr>

<td><label>Total mileage:</label></td>

</tr>

<tr>

<td><label>Expenses:</label></td>

</tr>

<tr>

</tr>

</table>

</fieldset>

</td></tr></table></cfform>

CFCS

select vehicle_name

from vehicles

where active = '1'

</cfquery>

</cfoutput>

</cffunction>

SELECT mileage

FROM vehicles

WHERE vehicle_name = <cfqueryparam value="#ARGUMENTS.vehicle_name#" cfsqltype="cf_sql_varchar">

</cfquery>

</cfoutput>

</cffunction></cfcomponent>

Bind with CFSelect Not Showing Data

forums_noreply@adobe.com — Mon, 24 Sep 2012 18:25:09 GMT

I have a CFC that I can access directly and get data. I am binding the cfc to a cfselect like so.

</cfform>

My cfc is located in a directory named cfcs at the application root. The name is menudata.cfc and the method is getData. I can access it fine by goign to the URL as so.

http://siteurl/cfcs/menudata.cfc?method=getData

It displays the data fine:
DinnerFridayMondaySaturdaySundayThursdayTuesdayWednesday

However when I try to look at the page the cfselect is on it shows me an empty drop down box with no selections. The function is just a simple query that return the records. Here is my cfc:

select description

from service_descriptions

</cfquery>

</cffunction>

</cfcomponent>

I have been banging my head against this one for a few days now so any outside eyes would be helpful. Anybody else run into this issue where the cfc works fine but does not appear to be binding to the cfselect for whatever reason? ColdFusion 8 is my server.

Many thanks.

-Brian

Binding Data to a CFTEXTAREA

forums_noreply@adobe.com — Thu, 27 Sep 2012 15:04:34 GMT

Hello,

Continuing on with my binding questions.

I am finally populating 2 realted select boxes using the bind attribute. I'd like to be able to make my two selection from the drop downs and then populate a CFTEXTAREA based on those selection. I though I could just issue a similar bind attribute command by the textarea outbputs:

[object Object]

CF8 documentation says that this ss possible? What am I missing?

Here is my form:

Here is my CFC:

select description

from service_descriptions

order by description

</cfquery>

</cffunction>

SELECT ID

from service_descriptions

WHERE description = '#ARGUMENTS.description#'

ORDER BY ID ASC

</cfquery>

</cffunction>

SELECT service_detail

from service_descriptions

WHERE ID = '#ARGUMENTS.detail#'

</cfquery>

</cffunction>

</cfcomponent>

Thanks

-Brian