CfSelect Bind using URL:page.cfm?state={firstselect.value}

Posted on 2009-04-02
Medium Priority
Last Modified: 2013-12-20
I am having an issue returning a value for the code below: I get JSON Parsing error

I have the form that is bind to URL - works fine but I get the error on the parse.

All code is below.
<!---Page 1 the form--->
<cfquery name="Recordset1" datasource="mydsn">
SELECT distinct State
FROM zipcodeworld
order by state
<cfform name="form1" action="#CGI.SCRIPT_NAME#">
  <cfselect name="firstselect" query="Recordset1" value="state" display="state"/> <!--- works great =--->
  <cfselect name="secondselect" bind="url:citylookup.cfm?mystate={firstselect.value}" value="city" display="city"/>  <!---   This part does not work --->
<!---Page 2 the URL its binded to:--->
<cfquery name="Recordset2" datasource="mydsn">
SELECT distinct city
FROM zipcodeworld
WHERE state = <cfqueryparam cfsqltype="cf_sql_VARCHAR" value="#url.mystate#">
<!---  it needs to return all cities in state selected from bind on form page --->
When I run the code i get a JSOn Parsing error on form page.

Open in new window

Question by:LeadCo
LVL 27

Accepted Solution

azadisaryev earned 2000 total points
ID: 24057790
do you use Application.cfm?
does it output anything, like site header/footer, or a <DOCTYPE ...> declaration or some javascript?
that all will break the returned json because it will be appended to the response from the url...


Author Closing Comment

ID: 31566136
I did have some html in application removed and works great.


Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
The Super Bowl is just days away. Millions of advertising dollars will be spent in just a few hours to drive people to websites around the globe. Optimizing your site in anticipation of a big event like this (and the traffic surges that follow) will…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question