We use cell.getContents to read the values of a cell, the content contains data (e.g. 10.2327), the data gets read as "10.233". Not sure why we are unable to read the string as it is
Hello,
i am working with APE Engine (http://www.ape-project.org) and up until now i had no actual problem.
The problem is that i would like to use the MySQL module and push data to a channel each time a row is inserted into a table.
I've tried to setup a server side module, i created an SQL query but data is fetched only when the server boots.
How can i make this work?
i have a program that receives data from a wireless device over bluetooth...i now need to do some operations in the data and then send it to the website (web server!!!) as a .csv file...i also need to authenticate the device itself from it hardware address which is also obtained in the program.i am coding this in gcc linux compiler using C...can anyone tell me how do i go about doing this?
Hello Experts,
I have 100000 Ids to store into our DataBase.Id is in string format.each id contain 10 char.so what is the best data type is for this data?
i have been used vrchar(max),text but my problem is not solved.
so please experts help me.
Hi all,
I have to make a custom webpart in sharepoint 2010 to customize defaults form of SP List.
But, the custom form i make have a field must get/set data to field of other list.
Sample :
I make a custom create custom Editform.aspx for List A by add a webpart to this page, that add. but in it have a text box that load data from a field in List B. is it possible to use method FieldName in TextField class ?
Thank alot.
If there a way to protect against concurrent modifications of the same data base entry by two or more users?
It would be acceptable to show an error message to the user performing the second commit/save operation, but data should not be silently overwritten.
I think locking the entry is not an option, as a user might use the "Back" button or simply close his browser, leaving the lock for ever.
Hi
I am displaying all the users in the form using php where the data are fetched from db.
When i click on the icon all users data should be show in a pdf with a good table structure.
i am hereby using fpdf to generate it. i created pdf but the records are not in formatted structure.
How should this can be done.
kindly advice.
thanks in advance
strong text
Hello All:
I am using entity framework 3.5 for my application.
I want load data based on some condition e.g.
var data = from e in context.Employee.Include("Employee.Projects") where e.IsActive select e;
Using this, I will get all the Employees which are active with their project details. But I want to load only those projects which are active. So, how to load only active projects using the query?
Thanks
Ashwani
How can I plot (a 3D plot) a matrix in Gnuplot having such data structure. I cannot find a way to use the first row and column as a x and y ticks (or to ignore them)
,5,6,7,8
1,-6.20,-6.35,-6.59,-6.02
2,-6.39,-6.52,-6.31,-6.00
3,-6.36,-6.48,-6.15,-5.90
4,-5.79,-5.91,-5.87,-5.46
Is the splot 'data.csv' matrix the correct parameter to use ?
I read an article around schema-less database which sounds cool. (http://bret.appspot.com/entry/how-friendfeed-uses-mysql)
But what isn't clear to me is how do they run search queries on this data? Since the data is in JSON format how do we look for it?
Quick question, my data model is a singleton object and it contains a list of names I want archive. My idea is to make the model responsible for loading / saving this data. The ModelLoad will then be called by the ViewControllerviewDidLoad and the ModelSave by ViewControllerapplicationWillTerminate. I could do the load / save directly within the ViewController, but this would be messy as the list of names are on instance variable of the model.
gary
When I read a sheet into a DataTable using the OleDbDataReader, floating point numbers loose their precision.
I tried forcing OleDb to read the excel data as string, but although the data is now contained in a DataRow with each Column defined as System.String it looses precision (18.125 - 18.124962832).
Any idea how to avoid this behaviour?
hi--
my goal is to send an NSView over the wire. i was wondering whether there was a way to get the raw display data contained in an NSView so that I can send this data over the wire and re-display this at the destination.
thanks.
This is really just a conceptual question for me at this point.
In Lisp, programs are data and data are programs. The REPL does exactly that - reads and then evaluates.
So how does one go about getting input from the user in a secure way? Obviously it's possible - I mean viaweb - now Yahoo!Stores is pretty secure, so how is it done?
I've noticed with Xcode 3.2.2 that all the custom data formatters are no longer working. Some searching around the mailing lists and google confirms others are having the same issue.
A) Anyone else seen this
B) Got a work around or an example custom data formatter plugin that still works in 3.2.2 that I can look to for hints on how to fix the ones I have?
Has anyone written a YQL open data table for accessing Wikipedia? I've had a hunt around the internet and found mention of people using YQL for extracting various bits of information from Wikipedia pages such as microformats, links or content but I haven't been able to find an open data table that ties it all together.
What approach is considered to be the best to store and manage video files? As databases are used for small textual data, are databases good enough to handle huge amounts of video/audio data? Are databases, the formidable solution?
Apart from size of hard disk space required for centrally managing video/audio/image content, what are the requirements of hosting such a server?
Is there any way to export a Microsoft SQL Server database to an sql script?
I'm looking for something which behaves similarly to mysqldump, taking a database name, and producing a single script which will recreate all the tables, stored procedures, reinsert all the data etc.
I've seen http://vyaskn.tripod.com/code.htm#inserts, but I ideally want something to recreate everything (not just the data) which works in a single step to produce the final script.
hi,
i am using display tag jar 1.0 in my struts base application,
i have 5 million rows to showing reports of all rows data by paging with 50 records.
it takes 5 minutes to rendering the data can we reduce this one.
Please suggest how make it with in one minutes.
I have an Excel Spreadsheet that contains all my data that I need to put into an SQL Server database. I am fairly new o ASP.NET and have never had to export from Excel to SQL Server before.
My Excel spreadsheets looks like this
Trade Heading - ArtID - BusinessName - AdStyleCode - Address - Suburb
In SQL Server I have created a table named "Listings" which is in this format
intListingID - intCategoryID - BusinessName - ArtID - intAdCode -Address - Suburb
What would be the best way to export the data from Excel and then import it into SQLServer 2005.
Thanks...
A book beginning linux programming 3ed says "Note that fread and fwrite are not recommended for use with structured data.Part of the problem is that files written with fwrite are potentially nonportable between different machines." What does that mean exactly? what calls should I use if I want to write a portable structured data reader or writer? direct system calls?
Hi,
We are using JSF in UI, Spring in business layer, Hibernate in persistence layer. Now my question is how to pass data from the JSF UI to spring business layer. Can I directly use my business object in my backing bean or should I transfer data between the layer through DTO? Can one explain me with clear explanation if possible with piece of code and that related websites?
i am trying to store large data more than 255 characters in a string datatype but it truncates after 255. how can i achive this basically i need to pass this data to database
Hi
In my app I use a ListView to display data from the database. The data changes sometimes, for example when the user applies new filters or changes the sorting method. I use AsyncTask to get the databsase cursor that points to the new data set because sometimes data needs to be loaded from the net which can take some time.
What I do now looks something like this:
private class updateTask extends AsyncTask<Void, Void, Void> {
/*
* runs on the UI thread before doInBackground
*/
@Override
protected void onPreExecute(){
// prepare some stuff...
}
/*
* runs in a separate thread
* used for time-consuming loading operation
*/
@Override
protected Void doInBackground() {
//get new database cursor
mCursor = mDbAdapter.getCursor();
return null;
}
/*
* runs on the UI thread after doInBackground
*/
@Override
protected void onPostExecute(Void result){
if(mCursor!=null){
MyActivity.this.startManagingCursor(mCursor);
mCursorAdapter = new MyCustomCursorAdapter(MyActivity.this, mCursor);
mListView.setAdapter(mCursorAdapter);
}
}
}
This works so far but I realize that creating a new CursorAdapter and calling setAdapter on my ListView each time isn't the correct way to do it.
Also, after setAdapter the scroll position of the list is set back to the top. I found this post which describes how to do it properly. So now I want to do something like this:
onCreate(){
// ...
// create the CursorAdapter using null as the initial cursor
MyCustomCursorAdapter cursorAdapter = new MyCustomCursorAdapter(this, null);
mListView.setAdapter(cursorAdapter);
// ...
}
private class updateTask extends AsyncTask<Void, Void, Void> {
/*
* runs on the UI thread before doInBackground
*/
@Override
protected void onPreExecute(){
// prepare some stuff...
}
/*
* runs in a separate thread
* used for time-consuming loading operation
*/
@Override
protected Void doInBackground() {
//get new database cursor
mCursor = mDbAdapter.getCursor();
return null;
}
/*
* runs on the UI thread after doInBackground
*/
@Override
protected void onPostExecute(Void result){
// this returns null!
MyCustomCursorAdapter cursorAdapter = (MyCustomCursorAdapter)mListView.getAdapter();
Cursor oldCursor = cursorAdapter.getCursor();
if(oldCursor!=null){
MyActivity.this.stopManagingCursor(oldCursor);
oldCursor.close();
}
if(mCursor!=null){
MyActivity.this.startManagingCursor(mCursor);
cursorAdapter.changeCursor(mCursor);
}
}
}
This however doesn't work for me because
(MyCustomCursorAdapter)mListView.getAdapter();
always returns null.
Why does this happen? What am I doing wrong?
Edit:
Some additional information: my adapter implements SectionIndexer. I don't really think that this has anything to do with my problem but it has caused me some troubles before so I thought I'd mention it.