> But I'm still puzzled as to how to fire the proper SQL statement for each > drop; essentially it's an INSERT [URL from drop] INTO table WHERE column = > [the drop acceptor's label string].
So it's [URL from drop] and [the drop acceptor's label string] values that you need, essentially?, or you've already got those and want to know how to pass them elsewhere/use them to update the database? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of David Kramer Sent: 30 January 2009 21:20 To: [email protected] Subject: RE: [flexcoders] drag and drop ('into' the list items, while not adding to the list itself; Ex: iTunes) Yes! Last night around 2 AM I thought "Oh, the item renderer should accept it" and then I went to sleep. But I'm still puzzled as to how to fire the proper SQL statement for each drop; essentially it's an INSERT [URL from drop] INTO table WHERE column = [the drop acceptor's label string]. Example code rocks, of course, but small nudges will help me get through the fog. Thanks to all who keep illuminating... From: [email protected] [mailto:[email protected]] On Behalf Of Jim Hayes Sent: Friday, January 30, 2009 2:06 PM To: [email protected] Subject: RE: [flexcoders] drag and drop ('into' the list items, while not adding to the list itself; Ex: iTunes) So I think what you really need to be doing is to have the list item renderer accept the drop, rather than the list itself? I'm sure I did this with the datagrid about a year and a half ago, unfortunately I don't have that project to hand just now or I'd have a look and see how I did it. All I remember was it wasn't all that hard to do once I'd got that concept. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of David Kramer Sent: 30 January 2009 20:52 To: [email protected] Cc: [email protected] Subject: [flexcoders] drag and drop ('into' the list items, while not adding to the list itself; Ex: iTunes) Hello All. I've run into a problem, need other perspective(s)/solutions: Simply put: I want to implement drag and drop, like iTunes, in an AIR app. Seems easy, but...this particular scenario is puzzling. Right now, just like iTunes, I have two list-based controls (both are populated from collections of data within SQLite), one is a DataGrid and one is a List. Dragging and dropping from the Grid to the List is simple, yes, but I would like to drop on the list item's label/text/name in the List and perform another function (specifically an update to SQLite) and NOT simply drop the item and append to the list. Follow? As in iTunes, you can drag a song into a folder and it adds the song "into" the folder. (I would make that reference in SQLite in this case). It doesn't make a new folder by appending (wrongly) the dropped song to the folder list. (Which is what I have now: If I drag a item from the grid and drop it on the list, it's appended to the list, but I want it to become a value within the list item (pseudo nested) not a value in the list itself.) Is there a simple solution here I'm not seeing? Now, I can do all that neat stuff by dragging a grid item unto a mx:Button, but with only one button. Maybe I could "loop/repeater" to make a vertical stack of buttons from an array? But then it gets unclear as to how each button is created with the necessary dragEnter and dragDrop event handlers... any help here? This wheel has been invented before. So how in Flex? David (You can email me off of list if you'd like, I'll gladly post the solution at the end. [email protected]) ______________________________________________________________________ This communication is from Primal Pictures Ltd., a company registered in England and Wales with registration No. 02622298 and registered office: 4th Floor, Tennyson House, 159-165 Great Portland Street, London, W1W 5PA, UK. VAT registration No. 648874577. This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient. If you have received it in error, please contact the sender immediately by return e-mail or by telephoning +44(0)20 7637 1010. Please then delete the e-mail and do not disclose its contents to any person. This email has been scanned for Primal Pictures by the MessageLabs Email Security System. ______________________________________________________________________ ______________________________________________________________________ This communication is from Primal Pictures Ltd., a company registered in England and Wales with registration No. 02622298 and registered office: 4th Floor, Tennyson House, 159-165 Great Portland Street, London, W1W 5PA, UK. VAT registration No. 648874577. This e-mail is confidential and may be privileged. It may be read, copied and used only by the intended recipient. If you have received it in error, please contact the sender immediately by return e-mail or by telephoning +44(0)20 7637 1010. Please then delete the e-mail and do not disclose its contents to any person. This email has been scanned for Primal Pictures by the MessageLabs Email Security System. ______________________________________________________________________
