If I have a bunch of data that is never going to change (eg. an English language dictionary or the rgb values of a couple hundred color names), how do I use an SQLite database to store it? I know a database is faster than loading everything into memory when the app starts, but how do I make the database either the first time the app runs or "before" the apps ever runs?
i designed a software for testing work flow in lotus 8.51. i ran the program and it worked fine, but i found a single oddity in the application when i switch location to switch user id on my PC, the data i inputted in one location differ/not exist from the other one.
could you suggest something to correct this?
I was able to create an ODBC Data Source locally for my SQL Server 2008. Now I moved to anohter machine and want to connect from the new machine to that SQL Server 2008.
I know by default the SQL Server 2008 will not listen for the remote connection. I have enabled its Browser and TCP/IP.
Error window is like this:
Hello,
I have a PC with AMD FX CPU (Do not remember if it was FX51 or FX60)
it is 64Bit does it means that I can run 64Bit Guests? even if it does not have the Visualization extensions in the CPU?
I want to sort one column fetched from mysql DB, and stored in an array. After fetching I am doing below steps.
1- DB Fetching fields array in row format.
->Field1, Field2, Field3, Field4, Field5
2- From that fields array One columns data [Field3], swapping string keywords.
eg. AB013, DB131, RS001
to->013AB, 131DB, 001RS
Now I want to sort above value in new string format
like-> 001RS, 013AB, 131DB
Hi
i am new in iphone i am using sqlite3 database. and I am retrieve value from database into table view. when we insert new data into database this is show in the table view but this is not inserted database table. i am not able to find out where this value store.
plz tell me
The prevailing wisdom in webservices/web requests in general is to design your api such that you use as few requests as possible, and that each request returns therefore as much data as is needed
In database design, the accepted wisdom is to design your queries to minimise size over the network, as opposed to minimizing the number of queries.
They are both remote calls, so what gives?
Currently I am facing the tedious problem of exporting complete GridView data to the pdf file so that the user can save it. I am using C# as the language in Asp.net. Kindly guide me.
The gridview contains only text values.
Thanks in advance.
is there any method to get data from excel to sql ? i think that we can do without any writing C#codes. For example : select * from MyExcellFile.xls.Sheet1. Or may be any wizard in sql?
In Adobe Flex / Actionscript 3, I would love to pretty print my JSON data to a TextArea. Any libraries out there? A decent search turned up no results. Thanks!
It seems a good and clean thing to ensure that your deployed files appear on the target system with a consistent time/date. Many Applications seem to do this but other than for care of overwriting Users' existing data I guess it has no real significance. I'm having a purge on my installer packaging and I'd like to know if there any good reasons for specific date/time handling.
So I have a device:pnp like
@device:pnp:\\?\usb#vid_1871&pid_01f0&mi_00#6&d57670c&0&0000#{65e8773d-8f56-11d0-a3b9-00a0c9223196}\global
It's a web Camera Is it possible to connect FFMPEG to it and save data into some format or do anething like that?
I'm working with a visual studio 2008 - You get access to a number of special folders to use if you want to include files within. One I don't see on the list is the user's local application data folder. Is there anyway to put files in that folder from within a VS2008 setup project?
I have a JPA application that has specified JTA transactions in persistence.xml. For whatever reason, I have found that when using JTA, you MUST specify a JNDI data source within persistence.xml as well. This is fine, unless you are trying to go integration testing outside a container and JNDI is not available.
My questions are:
a) is there anyway to inject a jdbc datasource into my JTA transaction manager?
b) if not, how do a handle a JNDI lookup during integration testing?
I have a Gnome applet written in Python. In order to save configuration data/settings, it creates a file ~/.appname.
However, this prevents multiple instances of the applet from being added to the panel because each cannot have its own settings.
How can I store the settings in a way that allows each instance to have its own unique settings?
Update: I specifically want to know how to store settings per instance.
hi,
i have one problem that, i have to change type of data in column based on foreign key stored in that row.
unit_id unit_name
1 String
2 Float
3 Date
4 Int
Id spec value unit id
1 "A" 1
2 30.90 2
3 null 3
4 100 4
now i should achieve the above codition. how do i achieve it? please help me.
I have a property in umbraco that uses a dropdown data type with a set of prevalues that you can select from.
How do I retreive a list of all the possible prevalues that are in this drop down list?
I'm very surprised that it seems impossible to upload more than a few megabytes of data to mysql database through PHPMyAdmin whereas I can upload a msaccess table easily up to 2 Gigabytes.
So is there any script in php or anything that can allow to do so unlike phpmyadmin ?
hello,
I'm trying to figure out how to build a multi dimensional "array" that is:
flexible size
use 2 keys
1st key is int (flexible)
2nd key is string (kind of limited)
the use will be like
console.writelen(array[0]["firstname"]);
console.writelen(array[0]["lastname"]);
console.writelen(array[0]["phone"]);
console.writelen(array[1]["firstname"]);
console.writelen(array[1]["lastname"]);
console.writelen(array[1]["phone"]);
.....
.....
console.writelen(array[x]["firstname"]);
console.writelen(array[x]["lastname"]);
console.writelen(array[x]["phone"]);
something like this