Flex :: Sqlite - Spark List With SQL Result
Nov 4, 2011
I'm trying to populate a spark list component from SQLite in an AIR application statusList = new ArrayCollection(statement.getResult().data); myList.dataprovider = statusList; From the debug session I know the data is structured as statusList->unnamed object->array
[Code]...
View 1 Replies
Similar Posts:
Jan 26, 2005
statusList = new ArrayCollection(statement.getResult().data);yList.dataprovider = statusList;From the debug session I know the data is structured as statusList->unnamed object->array
<s:List width="100%" height="100%" id="listUploadStatus" dataProvider="{statusList}">
<s:itemRenderer>
<fx:Component>
[code].....
View 11 Replies
Mar 21, 2012
I try to display the Total sum() from a sqlStmt but all i got is [object, object], any idea how?
private function displayAmountHeading():void {
sqlStmt = new SQLStatement();
sqlStmt.sqlConnection = sqlConn;
sqlStmt.text = "SELECT SUM(Amount) FROM MainTable";
sqlStmt.execute();
[Code]...
View 2 Replies
Apr 12, 2012
Using the following SQLite statement:
SELECT Customer, SUM(OrderAmount) AS TotalOrder FROM OrdersTable GROUP BY Customer
I get the result of total sum (total order) of each customer. How can I put the above result into a itemRenderer label.text ?
<s:ItemRenderer>
<s:Label id="customerName" text=??? />
<s:Label id="totalOrder" text=??? />
</s:ItemRenderer>
View 2 Replies
Jul 1, 2011
I have a renderer that looks like this:
[Code]...
Loading thumbnails using this method works perfectly. The issue happens when you scroll the List.
View 1 Replies
May 26, 2011
Flex 3 List control had a itemRollOver event. Flex 4 List doesn't have it. Is there an equivalent or a workaround for this issue?
View 2 Replies
Jun 28, 2010
I'm trying to animate a list as I delete the top row. All the examples I can find use itemsChangeEffect to bind to the effect, but this property exists only in MX lists, not spark lists.
Any idea how I can get the same effect done in Spark Lists?
I'm trying to remove the top most item in the list with a slight fade out effect before the rest of the items move up to replace the gap.
View 2 Replies
Jun 29, 2011
I'm having a problem with the result obtained on a select in my sqlite. I already have a database fed, and I'm doing queries in my application in adobe air. In my table I have 6 columns:
[Code]....
All information came right, but the id value is incorrect ( correct is not 30 ) . It seems to me that i'm getting the numerical order and not getting the id column value. Has anyone had this problem? UPDATE My query is:
[Code]....
View 1 Replies
Aug 25, 2011
I have a Spark List with a data provider consisting of a list of filled out form applications. What is the best way to add a button to each List Item (form application)? This button will be named Open and will navigate to the specified form application.
View 2 Replies
Mar 31, 2010
How to enumerate items of Spark List component after setting dataProvider property?
I mean accessing them as DisplayObject instances.
View 1 Replies
Apr 29, 2010
I have a spark list, which is based on a dataProvider. As the application runs, the data in the dataprovider can change, and also the dataProvider can be swapped for a different one
What I need to do is make sure that something is always selected in the list (unless it is empty)
View 1 Replies
Jun 25, 2010
I have two spark lists and want to drag items from one list to the other. When im dragging an item and over the other list item, i want the target item to change the background coloer.Basically instead of showing the black line indicating that I will drop between elements, I want to see the target item highlight.
View 1 Replies
Aug 2, 2010
How to skin spark List component so that every adjacent itemRenderer has different color (something like mx DataGrid)?
View 1 Replies
Nov 29, 2010
How do I wordwrap in a spark list w/ an itemrenderer? This posting at[URL] works 100% but when I try to set a separate item renderer, I can't get the word wrapping...instead, I get an ugly horizontal scroll bar. HEre is my mxml:
[Code].....
View 1 Replies
Mar 7, 2011
I would like to add custom right clicks to a number of spark list controls. I have tried the following as an item renderer. (as per the flex 4 cook book). Full Render code here [URL] When I right click on the Spark List I simply get the Adobe Default Context menu. This is the same default behaviour I had before I added any code to this.
View 2 Replies
Aug 22, 2011
I'm building a mobile app, using spark list control. When user tap on a list item, i want it to navigate to that correspondence page
<s:List id="list" width="100%" height="100%" labelField=" label">
<s:dataProvider>
<s:ArrayList>
[Code].....
how do i code it so that when user tap on item label="Page One" it will navigate to PageOneView.mxml and if it tap on "Page Two" it will go to PageTwoView.mxml and so on.
View 1 Replies
May 21, 2010
I have a s:List where I've defined my own itemRenderer, and would like to insert a horizontal line separating items, similar to the way the mx:LinkBar works. I don't want to have a line at the top or bottom of the list, so I can't just include an upper or lower border in the itemRenderer. I was hoping the itemRenderer could be made aware of its index in the list, but I don't see how.
View 2 Replies
Aug 9, 2010
How can I set the scroll position for a Spark List control?
View 1 Replies
Oct 26, 2010
I have a Flex Spark List (well it's a Tree to be precise but it renders as a list) and as I'm scrolling through it I want to provide information about the item that is currently at the top of the list in context to the viewport. So this could be the 100th item in the list depending on how far you've scrolled down.
View 1 Replies
Oct 26, 2010
In Flex I can create an ItemRenderer to represent each item in the Lists DataProvider but how do I access the instance of the ItemRenderer via the DataProviders Object? Something like myList.getItemRenderer(dp.getItemAt(10));
View 2 Replies
Jan 3, 2011
I'm trying to make a simple flash application providing interface for taking tests as a high school assignment. One of the requirements is to use an XML file as data source.Now, having a List component bound to the XML file with questions consisting of data such as question body, question type (ie. single choice, multiple choice, open, image etc.) and possible answers (where applicable), I was wondering if I could add some additional data (and what is the best possible way to do so) to each question upon its transfer to the List component.
I am trying to achieve two main goals with this: firstly, to mark the questions to which an answer has already been given, like with such code in ItemRenderer class:
<s:Label color="{data.color}" text="{data.label}"/>
Where data.color would be set whenever the user gives an answer to a question.
Secondly, while at it, I thought of such possibility as a great way to store answers given to particular questions. In this case, the Class of the answer object would have been Object, since there has to be many type of questions (where the answer could also be a Bitmap for example).
View 2 Replies
Mar 4, 2011
[code]I want to extend the list with hyperlinks. For example in every node I should have an href attribute also. Then I need to redirect users to the selected item. I know Flash has the URLRequest class. The little problem I have now is to get the selected item. It propably is because of the dataprovider is xml and I haven't done the correct casting.
View 2 Replies
Mar 8, 2011
I'm developing a Calendar application, and I'm using a Spark List inside a Panel for each individual day, in a 5x7 grid. I'd like to make sure that the individual lists stay the same size and simply add scrollbars when needed, but I'd also like to avoid setting an explicit width or height to maintain compatibility with multiple screen resolutions.
View 1 Replies
Mar 13, 2011
[code]When I hover the upper (red) part of the List (I would like to have the List scroll downward, the higher the mouse position is, the faster it should scroll). Similarly, If the mouse hovers over the bottom (red) part, the List scrolls upwards, and the lower the mouse is hovered, the faster the list would scroll. The current code does work - Though, the trace outs make it obvious that:this.layout.verticalScrollPosition += (mouseY - 220)*0.5.or this.layout.verticalScrollPosition += (mouseY -86)*0.5;are giving jumping effects, is there a way to make these values change more linearly or smoother? I created an AnimateProperty, but that works well only if I would like to scroll to a selectedIndex, In this case, I would like the scroller to keep scrolling linearly as the mouse is hovered to a particular red area, and increase in speed when I scroll to either extremity.The Objective: While the mouse is over the Bottom (red part )of the List, the verticalScrollPosition scrolls faster as it gets farther than the center of the ticket list... yet there is jumping effect going on, I suppose due to the EnterFrame. the Same with Upper Part... the higher the cursor is, the faster the List should scroll.I feel this is a common problem to Flash CSx developers.
View 1 Replies
Apr 4, 2011
I have a Spark.List with several items ("folders") each containing an ArrayList of files inside, when I select one of these "folders" it should display the list of "files" on another Spark.List. Its working right now by doing this:
private function onFolderChange (event:*):void {
var list:List = event.currentTarget as List;
if (list.selectedIndex != -1) {
currentFolder = null;
currentFolder = list.selectedItem;
fileListDataProvider = currentFolder.files;
fileList.selectedIndex = -1;
}}
The problem is that when the "file" thumbnails cover more then the List viewport and a scroll is needed sometimes by changing from a "folder" to another "folder" the file List loses files. For example lets say there is a "Folder 1" with 30 "files" in it (10 visible and 20 hidden by the scroller) and "Folder 2" has 5 "files" (all visible), if I switch back and forth between "folders" sometimes it will display everything right. Sometimes it will display a scroll on "Folder 2" when there is no need and sometimes it will only display a few (5 or 10) "files" in "Folder 1" even though it has 30. Something is wrong with the fileList, its updating its items but not really updating well. I've tried setting the itemRenderer to null and reapplying, setting the dataProvider to null and reapplying, doing validateNow().
View 1 Replies
Apr 25, 2011
I need to create a slideshow using data received from another view.I'm calling the slideshow's view like this:
<s:List id = "list" dataProvider = "{actions}"
change = "navigator.pushView (DetailsProduct, list.selectedItem) ">
<s:itemRenderer>
[code].....
View 1 Replies
Jun 1, 2011
I'm creating a spark list in my flex mobile application and i want to do like a list on the iphone with a corner radius Unfortunately there is no cornerRadius or simply radius in list styles.
[Code]...
View 1 Replies
Jun 17, 2011
I have a list with custom item renderers. What I would like is when one of the list items is selected to position another control OUTSIDE the list to the same vertical position as the selected item.
View 2 Replies
Jul 5, 2011
I want my list control has its content height as I don't want scroll bars. For the scrolling purpose I have my own scroller in parent container.
Now, The problem is when list control exceeds the maxHeight 10000, then it will start clipping remaining data. I think the solution is increase the maxheight.
how I can set maxheight more than 10000.
For Example..
</s:Scroller width="100%" height="100%">
</s:VGroup>
<s:List id="myList" dataProvider="arrData" useVirtualLayout="false" />
</s:VGroup>
</s:Scroller>
In this case assume that I have arrData.length = 9999999, and for that mylist's height will become 10000+ (Lets assume 15000). now mylist will clipped after 10000px height or list's vertical scrollbar will visible and as I adready have scroller of my own It will have two scrollbars at that particular time.
View 4 Replies
Jul 13, 2011
how in Flex can I display a message within a Spark List component that states that the List is empty. For example if I have a List showing number of jobs outstanding, if my List is empty then I want a message displayed across the List stating "there are no jobs to perform".
I'd rather not use an Item Renderer because then it's an Item (the list is not empty) and the item can be selected.
View 2 Replies