Anonymous

Answered

Don't understand cffunction and cfcomponent

Forum|Forum|15 years ago
October 20, 2010
3 replies
1955 views

I am trying to alter Forta's ajax related select tutorial to fit my needs. I am having trouble understanding the details of this .cfc though.

<cffunction name="get_states" access="remote" returnType="array">

<cfquery name="data" datasource="mydsn">
        SELECT id,states
        FROM state
        </cfquery>

<cfloop index="i" from="1" to="#data.RecordCount#">
            <cfset result[1]=data.id>
            <cfset result[2]=data.state>
        </cfloop>

<cffunction name="get_waters" access="remote" returnType="array">

<cfset var data="">
        <cfset var result=ArrayNew(2)>
        <cfset var i=0>

<cfquery name="data" datasource="mydsn">
        SELECT id,name
        FROM waters
        WHERE bow_state = '#arguments.location#'
        </cfquery>

        
        <cfloop index="i" from="1" to="#data.RecordCount#">
            <cfset result[1]=data.id>
            <cfset result[2]=data.name>
        </cfloop>

<cfreturn result>
    </cffunction>

</cfcomponent>

When I put '#arguments.id#' into the second query, I get results. However, I'd like to query by the name instead, so I am trying location. I don't fully understand so I am hacking around with this a bit but I'd like to 1 - get results by name instead of id and 2 - understand the arguments variable so I really know what is going on.

Thanks!

This topic has been closed for replies.

Correct answer existdissolve

I agree with the other poster--more context (and code--like the selects to which these are bound) would be helpful.

However, you might start by using Firebug or the CF ajax debugging tools to see what's being passed into the second function. If "arguments.id" is what was in the original example, then it's likely that the value of <cfset result[1]=data.id> from the first function is what's being populated into the first select's "value" for each option. Then, when the option is selected, its value (in this case, data.id) is being passed as the argument to the second function.

If this is right, you could try making the "state" the first value in the array. Without seeing the select bindings and what-not, however, it's hard to tell.

BTW, you might want to take a look at this:

<cfquery name="data" datasource="mydsn">
SELECT id,states
FROM state
</cfquery>

<cfloop index="i" from="1" to="#data.RecordCount#">
<cfset result[1]=data.id>
<cfset result[2]=data.state>
</cfloop>

In your query, you select "id" and "states" (plural). However, in your loop, you reference the "state" column (singular) from the query.

Anonymous

Here is the form.

Location: <cfselect class="dropdown" multiple="no" name="states" bind="cfc:_ffc_cfc_select_jump.get_states()" bindonload="true"/>

Water: <cfselect class="dropdown" multiple="no" name="waters" bind="cfc:_ffc_cfc_select_jump.get_waters({states})" bindonload="false"></cfselect>

Here is the cfc

<cfcomponent output="false">

<cffunction name="get_states" access="remote" returnType="array">

<cfquery name="data" datasource="mydsn">
        SELECT id,states
        FROM state
        </cfquery>

<cfloop index="i" from="1" to="#data.RecordCount#">
            <cfset result[1]=data.id>
            <cfset result[2]=data.state>
        </cfloop>

<cffunction name="get_waters" access="remote" returnType="array">

<cfargument name="location" type="string" required="true" default="">

<cfset var data="">
        <cfset var result=ArrayNew(2)>
        <cfset var i=0>

<cfreturn result>
    </cffunction>

</cfcomponent>

existdissolveCorrect answer

Inspiring
Forum|Forum|15 years ago
October 20, 2010

I agree with the other poster--more context (and code--like the selects to which these are bound) would be helpful.

If this is right, you could try making the "state" the first value in the array. Without seeing the select bindings and what-not, however, it's hard to tell.

BTW, you might want to take a look at this:

<cfquery name="data" datasource="mydsn">
SELECT id,states
FROM state
</cfquery>

<cfloop index="i" from="1" to="#data.RecordCount#">
<cfset result[1]=data.id>
<cfset result[2]=data.state>
</cfloop>

In your query, you select "id" and "states" (plural). However, in your loop, you reference the "state" column (singular) from the query.

TheRealAgentK

Participating Frequently
Forum|Forum|15 years ago
October 20, 2010

Hi,

I think it'd help if you provided the context of the tutorial you're trying to modify, e.g. which one and where can people find that.

Cheers

Kai

Anonymous

http://www.forta.com/blog/index.cfm/2007/5/31/ColdFusion-Ajax-Tutorial-2-Related-Selects

existdissolve

Inspiring
Forum|Forum|15 years ago
October 20, 2010

Sorry, didn't see this before I posted.

But I think my suggestion was in keeping with the example. If you need to select on "state", then make the "state" column of your first query to be the first value in the array that you return:

<cfquery name="data" datasource="mydsn">
SELECT id,states
FROM state
</cfquery>

<cfloop index="i" from="1" to="#data.RecordCount#">
<cfset result[1]=data.state>
<cfset result[2]=data.state>
</cfloop>

This will make your select look something like this in the rendered HTML:

<select id="states" name="whatever...">

<option value="Alabama">Alabama</option>

<option value="Alaska">Alaska</option>

...

</select>

So then, on your second, dependent select, you'd specify the binding like so (just like you did, really):

<cfselect name="waters" bind="cfc:_ffc_cfc_select_jump.get_waters({states})" bindonload="false"></cfselect>

However, now, because the value of the "states" select options are state names, rather than ids, you should now be able to use the argument in your query based on state names:

<cffunction name="get_waters" access="remote" returnType="array">

<cfargument name="location" type="string" required="true" default="">

<cfquery name="data" datasource="mydsn">
        SELECT id,name
        FROM waters
        WHERE bow_state = <cfqueryparam value="#arguments.location#" cfsqltype="varchar" /> 
     </cfquery>

     
     <cfloop index="i" from="1" to="#data.RecordCount#">
          <cfset result[1]=data.id>
          <cfset result[2]=data.name>
     </cfloop>

<cfreturn result>
</cffunction>

Powered by Gainsight
Terms & Conditions Accessibility statement

Sign up

Already have an account? Login

To post, reply, or follow discussions, please sign in with your Adobe ID.
Sign in

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.
Sign in

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.
OK

Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information AdChoices