Unable to access JavaScript variables in ColdFusion tags in script

Question

I was trying to take the selected value from the select tag and pass it to cold fusion tags in jquery as follows.

select tag code:

<select id="selectco">
<cfoutput query="colist">
<option value="#cid#">#coname#</option>
</cfoutput>
</select>

jQuery code:

$(document).ready(function() 
{
    $("#selectco").change(function() 
    {
        var e=document.getElementById("selectco");
        var opt=e.options[e.selectedIndex].value;
         $("#selectst").html("<cfquery name='stlist' datasource='tasks'>
select * from state where cid='"+opt+"'
</cfquery><select id='selectct'><cfoutput query='stlist'><option>#stname#</option></cfoutput>");
    });
});

I was able to take the value to opt variable.But am unable to pass the value to the cfquery tag. Please help me.

possible duplicate of Reference: Why does the PHP (or other server side) code in my Javascript not work? — Quentin
– Quentin, Commented Jul 31, 2013 at 9:12
@Quentin No, it's not a duplicate of that. Is it possible for you to remove your close vote? It'll just encourage other people who don't understand the ColdFusion side of the question to likewise vote to close. — Adam Cameron
– Adam Cameron, Commented Jul 31, 2013 at 10:13

Adam Cameron · Accepted Answer · 2013-07-31 10:13:45Z

3

CFML is parsed on the ColdFusion server; Javascript runs on the client browser. The two never "exist" in the same space.

I recommend you read my blog article describing how CF participates in a request.

What you need to do is to read up on data binding in ColdFusion (or in general), which is fairly well documented, so there's little point in replicating it here.

edited Jul 31, 2013 at 10:13

answered Jul 31, 2013 at 9:10

Adam Cameron

29.9k4 gold badges39 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

uvk Over a year ago

Thanks @Adam Cameron will you please suggest me any possible method.

SOS Over a year ago

@AdamCameron - Good blog entry. Really helps clarify things. Since CF binding is now discouraged, you may want to update the second half of the answer.

SOS · Accepted Answer · 2019-03-20 14:04:13Z

0

Jquery is executed in client/browser side, while ColdFusion is executed server side.

I have done a lot of implementations of that using a CFC. You can try to fire a $.get() request after every select change event.

Lets say I have a component named "myApplication.cfc" saved in mywebsite/cfc.

myApplication.cfc

<cfcomponent>
    <cffunction name="getstateList" access="remote" returntype="string"
        returnformat="plain">
        <cfargument name="cid" required="no" default="" type="string">

        <cfset var stlist = "">

        <cfquery name="stlist" datasource="tasks">
            SELECT  stateCode 
            FROM    state 
            WHERE   cid = <cfqueryparam value="#arguments.cid#" 
                               cfsqltype="cf_sql_varchar">
         </cfquery>


        <cfreturn stlist.stateCode> 
    </cffunction>
</cfcomponent>

Where the $.get('mywebsite/cfc/myApplication.cfc?method=getstateList&cid='+yourParam). So after that you can use the result and populate your select list.

edited Mar 20, 2019 at 14:04

SOS

6,5602 gold badges14 silver badges29 bronze badges

answered Aug 9, 2013 at 11:45

delroekid

887 bronze badges

1 Comment

Leigh Over a year ago

Always var/local scope function local variables (including query names) and use cfqueryparam on client supplied parameters. Also, no need for the # signs around stlist.Code (or the extra variable for that matter).

Collectives™ on Stack Overflow

Unable to access JavaScript variables in ColdFusion tags in script

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related