Skip to main content
A
Anonymous
September 12, 2012
Question

Cfselect and bind

  • September 12, 2012
  • 1 reply
  • 639 views

Hello,

I am trying to use the cfselect and bind feature but i keep getting the following error when i run the debugger

window:global: SyntaxError: parseJSON (http://www.domain.com/CFIDE/scripts/ajax/package/cfajax.js, line 803)

info:http: CFC invocation response:

Here is the code that i am using

==================================

root directory/addacount.cfm

==================================

<cfform action="addaccountSubmit.cfm" method="post" name="frmAddAccount">

    <table align="center">

        <tr>

            <td>First Name</td>

            <td><cfinput type="text" name="firstname" required="yes" message="Please enter a first name." maxlength="100">

        </tr>

        <tr>

            <td>Last Name</td>

            <td><cfinput type="text" name="lastname" required="yes" message="Please enter a last name." maxlength="100">

        </tr>

        <tr>

            <td>Email</td>

            <td><cfinput type="text" name="email" required="yes" message="Please enter a valid email address" maxlength="150" validate="email"></td>

        </tr>

        <tr>

            <td>Address</td>

            <td><cfinput type="text" name="address" required="no" maxlength="150"></td>

        </tr>

        <tr>

            <td>State</td>

            <td>

            <cfselect name="state" bind="cfc:cfc.actions.getStates()" bindonload="true"/>

            </td>

        </tr>

    </table>

</cfform>

 

rootdirectory/cfc/actions.cfc
=======================================================

<cffunction name="getStates" access="remote" returntype="array">
    <cfset var data="">
    <cfset var result=ArrayNew(2)>
    <cfset var i=0>
   
    <!--- Get data --->
    <cfquery name="data">
    SELECT DISTINCT(state), stateabr
    FROM tbl_zips
    ORDER BY state
    </cfquery>

    <!--- Convert results to array --->
    <cfloop index="i" from="1" to="#data.RecordCount#">
        <cfset result[1]=data.stateabr>
        <cfset result[2]=data.state>
    </cfloop>

    <!--- And return it --->
    <cfreturn result>

</cffunction>

Also if i try to navigate to the cfc and run the method it runs fine and shows that its getting all the states and putting them into an array

http://www.domain.com/cfc/misc.cfc?method=getStates

Can someone please help me out with this, not sure what i am doing wrong?

    This topic has been closed for replies.

    1 reply

    A
    Anonymous
    September 23, 2012

    Finally, i figured out what was causing the issue, don't know why this would be causing the issue though.

    In my Application.cfc i have the following code:

    <cffunction name="OnRequestStart">

        <cfargument name = "request" required="true"/>

        <cfif IsDefined("form.logout")>

            <cflogout>

        </cfif>

        <cflogin>

            <cfif NOT IsDefined("cflogin")>

                <cfinclude template="index.cfm">

                <cfabort>

            <cfelse>

                <cfif cflogin.name IS "" OR cflogin.password IS "">

                    <cfoutput>

                        <h2>You must enter text in both the User Name and Password fields.

                        </h2>

                    </cfoutput>

                    <cfinclude template="index.cfm">

                    <cfabort>

                <cfelse>

                    <cfquery name="loginQuery">

                        SELECT uid, firstname, lastname, rTrim(type) as UserRolename

                        FROM tbl_users LEFT OUTER JOIN tbl_roles

                        On tbl_users.roleid = tbl_roles.roleid

                        WHERE username  = <cfqueryparam cfsqltype="cf_sql_varchar" value="#cflogin.name#">

                        AND   password  = <cfqueryparam cfsqltype="cf_sql_varchar" value="#cflogin.password#">

                    </cfquery>

                    <cfif loginQuery.UserRoleName NEQ "">

                        <cfloginuser name="#cflogin.name#" Password = "#cflogin.password#"

                            roles="#loginQuery.UserRoleName#">

                             

                    <cfelse>

                        <cfoutput>

                            <H2>Your login information is not valid.<br>

                            Please Try again</H2>

                        </cfoutput>    

                        <cfinclude template="index.cfm">

                        <cfabort>

                    </cfif>

                </cfif>    

            </cfif>

        </cflogin>

        <cfif GetAuthUser() NEQ "">

            <cfoutput>

                 <form action="main.cfm" method="Post">

                    <input type="submit" Name="Logout" value="Logout">

                </form>

            </cfoutput>

        </cfif>

    </cffunction>

    Can someone please explain to me why this code would be causing an issue?

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices