using actionscript with a cfgrid

[none9898]

I am looking for a way to bind a cfinput type="button" to a cfgrid then use
action script to open a new window and query the db for the information based
upon the bounded id. I know that sounds funny so let me break it down. I
have a grid full of info about my dvd collection which I like to let other
people borrow them. I have the id, name of dvd, and the person that has
borrowed it. Its hard to keep up with friends that like to borrow so yes i'm a
nerd and am building a system to keep up. Now back to my problem, i have
created a form that binds all the info in a given row to the text fields.
Instead of having all the info in text fields I would like a new page to show
the complete details. My solution would be to bind to a button and when you
click the button it goes to the new page and then querys the db with the
correct id and display the info. Does anyone have any ideas?

Thanks for looking,
Nick

[none9898]

I don't know why I even post here. No one ever replys to anything I put up
here. Its lack of support for anything other simple questions answered that
can be found in Ben Forta's books, which I own many of and is a good start.
Does anyone know of a site that can really help with solutions to complex
concepts such as actionscript in a flash forms (sarcasim). Is there a support
forum with real MM CFMX7 professionals to answer questions? Who wants to
start coldfusionrecipies.com? A site for solutions/tutorials to concepts and
complex questions. Better support for coldfusion as the web has for php means
more sales for MM and more people are building and developing the worlds best
web applications for the worlds best application server.

[nimer]

something like this? ---nimer P.S. next time post in the Rich Form forumn.
------------------------------------ <cfform format='flash'> <cfgrid
name='grid' selectmode='edit' insert='Yes' delete='Yes' label='edit row'>
<cfgridcolumn name='id'> <cfgridcolumn name='city'> <cfgridcolumn
name='state' select='No'> <cfgridrow data='1,Rockville,MD'>
<cfgridrow data='2,Washington,DC'> <cfgridrow data='3,Arlington,VA'>
</cfgrid> <cfinput type='button' name='btn1' value='submit'
onClick='getUrl('mycollection.cfm?id=' +grid.selectedItem.id, '_blank')'>
</cfform>

[none9898]

nimer, your the man... thanks for the actionscript and your absolute
dedication. Also for setting me in the right direction on where to post
flash forms questions, I had no idea.

Thanks,
Nick