Simple Solutions to Nagging Coding Problems

Posts in category spry

Using Spry to Auto-select a Form Value

Mar01
2007 4 Comments Written by rabidgadfly

So far I’ve covered how to use multi-related selects in Spry and how to dynamically update the select list upon a database update. That’s good enough for a simple ‘add record’ form but when it comes to an editing an existing record I want to be able to have the saved column’s value automatically selected in its select box.

Adobe’s samples didn’t seem to cover this scenario so it became a matter of trial and error, and a lot of wading through documentation. In the end, however, it turned out to be a matter of changing only a few lines of code.
READ MORE »

Posted in ajax, coldFusion

Updating a Spry Dataset from a Popup

Feb27
2007 13 Comments Written by rabidgadfly

Last week I posted a method of using multi-related selects with Spry and ColdFusion. In my example I updated a subbrands dataset when a brand select was updated. I implemented a similar process at work and decided that it would be nice to offer the option of adding new subbrands from the data entry form. To do so, I placed an ‘add’ button next to the subbrands select which opens a popup where the user can add a new subbrand. Then came the question, how do I update the dataset on the parent window once the new subbrand is added.

It actually ended up being quite easy.
READ MORE »

Posted in ajax, coldFusion

Experimenting with Multi-related Selects using Spry

Feb22
2007 12 Comments Written by rabidgadfly

I recently found myself in need of a multi-related select solution and decided to give Adobe’s new Spry framework a shot.

The first thing I noticed was that, still being in development, there isn’t much Spry documentation. In lieu of docs Adobe provides several samples which, though useful, did not provide the solution I was looking for. My goal is to have two select boxes, each populated by separate but related datasets. In the example I use below, my datasets are brands and subbrands. The subbrands dataset contains a brandID column which is related to the brandID column in the brands dataset. Read on to see how I did it and feel free to leave a comment telling me how I should have done it ;) .
READ MORE »

Posted in ajax, coldFusion, XML