Create javascript array of ColdFusion query for use with ajax function

Question

I'm building a page that displays my clients projects. In the database, each project record has a boolean flag indicating which category and class the projects belong to.

The projects categories; planning, landscape, environmental. And the classes; industrial, government, education, residential.

When the user wants to see "planning" projects for an "industrial" application, I query the database accordingly using URL parameters when the page loads:

SELECT project_id, name, location, description, planning, landscape
      , environment, industrial, government, education, residential 
FROM   projects 
WHERE  planning = 1 and 
       industrial = 1

.. and display the first project in the result set on the page.

Here's where I need some help

Above the project display there are links to the other classes. Additionally, if other projects in the selected category/class exists there is a link that says "One of three - see the next project" if the query returns more projects in the planning category that are in the industrial class. I want to use an ajax function to load another project into the page when a user clicks any of the aforementioned links via .load() or .ajax(). How can I store the project ID's returned from the query by class so that I can access it later with the ajax call via the links on the page?

I'm familiar with the javascript/jQuery ajax part of the work - no problem there. I'm just not certain how to store the information on the page to access it.

I think I need to delete this because I'm going to go a different direction. I don't think a fully javascript array is a well thought-out solution. I need to figure out how to create the arrays in my ColdFusion application or session scope and access them that way... — Ofeargall
– Ofeargall, Commented Mar 23, 2012 at 20:12
Don't delete the question or answer or comments. Just explain why you chose to go a different route, if that's what you choose to do. — Evik James
– Evik James, Commented Mar 23, 2012 at 20:34
Got it. Sad thing is, now I need to ask a different question. I need to build this same array with just ColdFusion. I'll post that new question and see where it goes. Thanks Evik. — Ofeargall
– Ofeargall, Commented Mar 23, 2012 at 20:56

Evik James · Accepted Answer · 2012-03-16 18:22:01Z

1

It's hard telling exactly what data you need to pass without more code from you. I would suggesting outputting your links and using microdata like this:

<a data-project="#project_id#">#name#</a>

To access this, you just do this:

$("a").click(function(e) {
    e.preventDefault();
    var project_id = $(this).data("project");
    // You could load in your new data here
});

answered Mar 16, 2012 at 18:22

Evik James

10.5k19 gold badges78 silver badges124 bronze badges

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

2 Comments

Ofeargall Over a year ago

I'll get a code sample shortly. I think you've got me in the right track though..

Josh Over a year ago

You should use graceful degredation. If the user doesn't have Javascript enabled (or is using something like Noscript), you don't want your page to completely break. Just fill out the href to an actual page that displays the information, but add a click handler that overrides the click action to perform an Ajax load.

Collectives™ on Stack Overflow

Create javascript array of ColdFusion query for use with ajax function

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related