Solved

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

Posted on 2009-04-02
2
1,148 Views
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
</cfquery>
 
<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 --->
</cfform>
 
 
 
<!---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#">
</cfquery>
 
<cfoutput>
#serializeJSON(Recordset2)#
</cfoutput>
<!---  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

0
Comment
Question by:LeadCo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
azadisaryev earned 500 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...

Azadi
0
 

Author Closing Comment

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

Thanks!
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Setting Up Local Lan Web Server 1 84
Internal to DMZ IIS Authentication. 3 65
Company website 6 50
Standalone trial or freeware to do SSL scan 4 61
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
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…

730 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