Sql :: Result Obtained On A Select In Sqlite - Not Getting The Id Column Value
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
Similar Posts:
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
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
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
Dec 5, 2011
I tried looking on google but without luck. I have a SELECT SQLStatement and I want to use the LIKE operator but the parameters won't work and the query give me an error
public function getUsersList(username:String):SQLStatement
{
selectRecord= new SQLStatement();
selectRecord.sqlConnection = connection;
selectRecord.text =
"SELECT id_u
[Code]...
View 2 Replies
Sep 30, 2009
In a flex datagrid, by default clicking on column headers does sorting. I want it such that if a user clicks a column header the entire column is selected. I have the datagrid listening for the HEADER_RELEASE event so I know when the column header is clicked.
How can I have the column and header appear highlighted similar to how a row is highlighted when selected?
View 2 Replies
Aug 30, 2010
var imageData:ByteArray = new ByteArray();
var headshotStatement:SQLStatement = new SQLStatement();
headshotStatement.sqlConnection = dbConnection;
[code].....
View 2 Replies
Mar 30, 2010
from flex, when calling a .net web method that returns a custom class, I always recieve an ObjectProxy, even if I have the same class created on flex. How do I manage this ObjectProxy as the class I have?
View 1 Replies
Nov 4, 2011
I am trying to show the page displayed using StageWebView as a bitmap. As per thedocumentation we need to use DrawViewPortToBitMapData. While displaying the bitmap in a
UIComponent, the image is getting stretched. How can I prevent that?
bitmapData = new BitmapData(webView.viewPort.width, webView.viewPort.height, false,
0x000000 );
webView.drawViewPortToBitmapData(bitmapData);
[code].....
View 1 Replies
Nov 16, 2010
I have a Flex 4, mx:DataGrid with the following (pertinent) properties set:
width="100%"horizontalScrollPolicy="off"
I have the minWidth set on all of the DataGridColumns and the width set on one of them. If I simply maximize/minimize the display (in browser or stand-alone flash player) of the application, the columns scale up and down nicely. But if you grab the edge of the application and drag it to make it bigger, only one column grows really big. When you drag the size down again, the one column remains big, but all of the other columns get squished way down.
View 3 Replies
Sep 27, 2003
i'd like to know if its possible to save information obtained from users to files if the user is accessing the flash file from a cd. I would also like to know how it works if possible. And can the flash file be in .exe instead of .swf?
View 5 Replies
Mar 9, 2010
I want to know column index of header in AdvancedDataGrid when a user clicks on header - either left click or right click.
View 1 Replies
Jan 29, 2011
In Flex, using AdvancedDataGrid, I'm trying to achieve a drag and drop of one row's column data to another row's column or the same row but different column. Is this even possible? I've been googling for hours and all I can find are drag and drop whole columns just to rearrange their view order.
View 1 Replies
Jun 23, 2010
I have a comboBox and values like basic and advanced. And viewstack container conatains 2 grids.When i select the base option in Combobox, the first grid has to be selected. select the advanced value in comboBox, the second grid has to be selected.
<mx:ViewStack id="viewstack1" width="95%" height="85%" x="0" y="63" >
<tables:KeyMetricsBasicTable basicArrayDataProvider="{basicArrayResult1}" width="100%" height="100%"/>
<tables:KeyMetricsAdvTable advArrayDataProvider="{advArrayResult1}" width="100%" height="100%"/>
</mx:ViewStack>
View 1 Replies
May 4, 2009
How to make a table in Flash and enable the column headers on the table to sort column on click?I have seen some tutorials with mySQL but I'd like to start with something basic. Is a sortable table possible using just Flash and AS 2.0?
View 1 Replies
Dec 6, 2011
Flex 4 Combobox is extended with a Text Input that helps in getting to the item that is searched for.I have created a Check Box as an itemrenderer for this Flex 4 Combobox. I would like to Add a Select All and Select None options in the drop down of the Combobox. I know that i could accomplish by editing the dropdownfactory in case of a Flex 3 Combobox. But in Flex 4 the dropdownfactory doesnt exist.
View 2 Replies
Nov 9, 2010
I am wanting to try to use a sqlite database in my project.I have downloaded several sqlite managers from the internet and they all save the database with a sqlite extension.However I see in flash we use the db extension (is this correct?);How can I use the databases I create if they all save with a sqlite extension?
View 4 Replies
Jan 5, 2010
I'm working on a simple todo app that has a column for each day of the week. On startup, the app checks to see if there are any incomplete tasks from before the current date. If so, they're moved to the top of the current date's column. The app is cloud-based, but the tasks are backed up for offline mode with an SQLite db. I can easily move the tasks by updating their date property, but I need the order property of each task to increment starting at 0 to place them at the top. I need to be able to define a count variable in SQLite alone and increment it with each update that's performed. I know this code doesn't work, but it's an easy way of explaining what needs to be done:
[Code]....
View 4 Replies
Dec 8, 2011
I have an as3 app which utilises an sqlite db to save metrics data. It is well known that as3 is single threaded, so when I save to this db, the Stage Video I am playing becomes jumpy! I have heard that saving db data in batches can speed up this process so I save in a loop:
for (var i:int=0; i < metricsObject.metricsComponentData.length; i++){
switch (metricsObject.metricsComponentData[i].mouseType) {
case MetricsCollator.MOUSE_OVER:
this._query_txt = "INSERT INTO " + this._tablePath[0] + " VALUES (null, " + this._sessionID +
[code]...
I have looked into pseudo threading examples but they all require a sprite or stage instance, the class I am executing this code in, is not a display class, I don't really want to pass an instance of the stage into this class.
View 1 Replies
Dec 30, 2009
I am creating an application in Flex that uses an embedded SQLite database. The data in the database contains quotes and other special characters which are escaped using a backslash or ''.Before I retrieve the data and render it in a Flex text area control I want to remove the ''. Is there any function in Flex which can help me do this - some equivalent of stripslashes() in PHP?
View 1 Replies
Mar 14, 2010
I'm having a problem with an expression in my sql statement in SQLite for Adobe AIR basically I have this sql = "UPDATE uniforms SET status=@status WHERE customerId IN(19,20)"; updateStmt.parameters["@status"] = args[1]; updateStmt.execute();
if I run the above code it works, updating the status when the id are 19 and 20
but if I pass the ids list as a parameter like this
sql = "UPDATE uniforms SET status=@status WHERE customerId IN(@ids)";
updateStmt.parameters["@status"] = args[1];
updateStmt.parameters["@ids"] = "19,20";
updateStmt.execute();
it gives me and error, saying could not convert text value to numeric value, which make sense because I'm passing and string but the IN expression should convert it accordingly, like it does when I pass directly the list values, why is not working the other way,
View 1 Replies
Sep 27, 2010
I would like to save settings for an AIR application to a local SQLite database. Wherever I read, it's recommended that you use File.applicationStorageDirectory to save the database file.
My problem is that in most cases, the AIR application will be first started by an administrator that configs and setup the application (and save the settings to database) and later used by different users. And what I would like to know is if there is possible to save the database to a location that every user can load it from? As I understand it, File.applicationStorageDirectory points to the user directory? There is probably possible too make the admins set correct permissions and stuff, but I don't want to make it difficult too install...
View 2 Replies
Nov 16, 2010
I'm making an application (web based) using flex and i have a requirment to access the SQLite database on the local system. There is no server running and i've decided to give them the link to the html file and see how that works out.
So in the root directory, there will be all required swf, html files, etc and a .db file. Can i access that database thro the flex web application ?
View 2 Replies
Dec 13, 2010
I have been struggling with trying to interface with SQLite and Adobe AIR. I am using the Flex 4 SDK with AIR 2.0. I modified code from a tutorial by David Tucker on InsideRIA ([URL]). I am writing in FlashDevelop (which I suppose could be my problem), and I can compile and run the app. The issue is that when I go to search the db file, I always get some error which results in the 'BREAKER' trace (ie - the 'queryError' function is called). I have tried simply running the SQL command on the db and it works fine, so there is an issue somewhere in the way Flex or AIR is handling my query (or obviously I could have made a mistake in coding).
[Code]....
View 1 Replies
Aug 17, 2011
I am going to start doing a couple of Adobe AIR projects that will be using SQLite feature provided by AIR. Since this is the first time I am attempting to do this, Since this application will be accessing a local db, I think I can open a connection to the database at the start of the app and keep it open till the application closes. Is this a right approach to use here?
How should design my application if I am using an MVC framework like Mate or Cairngorm? Should I create some wrapper class to perform the db operations so I can reuse this in some other project? Looking forward to some valuable information...
View 1 Replies
Aug 26, 2011
This link: [URL] has an interesting class to do just that! Encrypt an unencrypted database: but I'm having difficulty with a few things: You can find where the author, @probertson! Now I've got the following error: Compiler Error: Error #2044: Unhandled error:. text=Error #3125: Unable to open the database
Let me start by saying the source file works, since I've been using it (and the path) in another application. The error arises in the call to attach the source db to the newly created db.
View 1 Replies
Jan 18, 2012
I can write to db when running in IDE(FB), while after packaging a air, the app wont write to sqlite db, Why?
View 2 Replies
Aug 30, 2010
I'm developing a desktop application in Flash, but I can't seem to find any tutorials that aren't based on FLEX to connect my application to a database file.
Do I have to write my application in FLEX to use SQLite or can I create an AIR app in Flash and still use it?
View 0 Replies
Oct 14, 2011
[URL] I build the program in Flash Builder 4.0, the program created a database file 'data.db'. I can find the file: "C:Documents and SettingsOOiApplication DataSQLiteArticleLocal Storedata.db", and open it in SQLiteSpy, I can see the three tables with data....
I created an AIR program within Flash CS 5.5, and put the lines of code on the 1st frame:
import flash.data.SQLResult;
import flash.filesystem.File;
import flash.data.SQLConnection;
[code].....
View 3 Replies
