What do you see in Firebug? I cannot stress enough (and this it to
_everyone_ who is playing with Ajax for the first time) the CRITICAL
important of Firebug. it lets you see the Ajax requests and what they
are returning.
Now if I had to guess - I'd bet that this.dsn doesn't equal anything
as I didn't see it set. This is where Firebug would help. You would be
able to see the request, and response, and possibly the error I just
mentioned in the response.
On 8/11/07, Jeremy Rottman <[EMAIL PROTECTED]> wrote:
> I am playing around with my new coldfusion 8 install. I am trying to use Ben
> Forta's example to bind data from two of my cfc's. But for some reason, my
> tests don't work at all. It does not populate any of the inputs and gives no
> errors
>
>
> Here is the code I am using
>
> test.cfm
>
> <cfform>
> <table>
> <tr>
> <td>Select Media Type:</td>
> <td><cfselect name="catUUID"
> bind="cfc:com.UtilityManager.List_Categories()"
> bindonload="true" /></td>
> </tr>
> <tr>
> <td>Select Art:</td>
> <td><cfselect name="secUUID"
> bind="cfc:com.UtilityManager.List_Sections({catUUID})" /></td>
> </tr>
> </table>
> </cfform>
>
>
> Function: List_Categories
> <cffunction name="List_Categories" access="remote" output="false"
> returntype="array">
> <cfquery name="GetCats" datasource="#this.DSN#">
> SELECT
> fld_category_UUID as catUUID,
> fld_category_Name as catName,
> fld_category_Alias
> FROM
> tbl_classAd_Categories
> ORDER BY
> fld_category_Order ASC
> </cfquery>
> <cfset catArr = arrayNew(1)>
> <cfset i = 1>
> <cfloop query="GetCats">
> <cfset catArr[i] = structNew()>
> <cfset catArr[i].catUUID = GetCats.fld_category_UUID>
> <cfset catArr[i].catName = GetCats.fld_category_Name>
> <cfset catArr[i].catAlias = GetCats.fld_category_Alias>
> <cfset i = i + 1>
> </cfloop>
> <cfreturn GetCats />
> </cffunction>
>
> Function: List_Sections
>
> <cffunction name="List_Sections" access="remote" output="false"
> returntype="array">
> <cfargument name="catUUID" required="yes" type="string" />
> <cfquery name="GetSections" datasource="#this.DSN#">
> SELECT
> fld_section_UUID,
> fld_section_Name,
> fld_section_Alias,
> fld_category_UUID
> FROM
> tbl_classAd_Sections
> WHERE
> fld_category_UUID = <cfqueryparam cfsqltype="cf_sql_varchar"
> value="#arguments.catUUID#" />
> </cfquery>
>
> <cfset secArr = arrayNew(1)>
> <cfset i = 1>
> <cfloop query="GetSections">
> <cfset secArr[i] = structNew()>
> <cfset secArr[i].secUUID = GetSections.fld_section_UUID>
> <cfset secArr[i].secName = GetSections.fld_section_Name>
> <cfset secArr[i].secAlias = GetSections.fld_section_Alias>
> <cfset secArr[i].catUUID = GetSections.fld_category_UUID>
> <cfset i = i + 1>
> </cfloop>
> <cfreturn secArr />
> </cffunction>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286034
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
