Am playing around with html5 local storage on different browsers (Firefox, Opera, Safari & Chrome) and am just wondering where is the location for the local database that i create using "opendatabase".
Can i change the location of this database?
Gath
i have taken the data from databse into array now i want it to send it back into database by using the insert query.
how can i insert the array of the data into the database.
When use entity framework for DAL tier, VS 2010 can create edmx for each database.
Question:
If I have a database with many tables, should I create only one edmx for all tables or mutiple edmx files? for example, maybe all security tables for one edmx file, other tables for another edmx file. If there is more than one, then in other tiers, there will have more then on ObjectContext in code for business logic.
Which one it the best solution for this case?
i need to get an image from client and displayed(preview) before saving it into database..and then should be saved in database after getting preview..?
Is is possible in Asp.net using c#... ?
If I need to know the total number of rows in a table of database I do something like
$query = "SELECT * FROM tablename WHERE link='1';";
$result = mysql_query($query);
$rows = mysql_fetch_array($result);
$count = count($rows);
So you see the total number of data is recovered scanning through entire database
Is there a better way
Hi,
If I have an existing DataTable (already filled) but then I want to refresh/reload the data from the database directly (as I know there was a non-ADO.net process that changed data without going through the DataTable), however do I do this "refresh". Note the database data at that point can overwrite whatever is in the DataTable.
thanks
I have a number of users which are logged in at a time in my desktop application.
They are working on the same table (create, read, update, delete data) so I have to update their views, to reflect changes, every few seconds - currently I am thinking to use a different thread to do that.
I am using the MySQL database engine.
Is there a way, using JDBC, to listen for changes on a specific table in the database and triggering a Java method only when changes are made?
We have two SQL server database, and one is kept in US and being changed from day to day and the other one is in India. What is the best way of keeping two database schema in synch. Does any functionality like sql server replication help?
i'm just curious. so i ask this particular question about SQLite. I haven't use this type of database extensively. but care to explain what is the basic different between SQLite and Mysql ?
The reason behind all of this is i just want to know whether it possible to use it to store wordpress data and act as a database ?
So our web server apps need to connect to the database, and some other apps have startup scripts that execute at boot time.
What's the best way to store the name/password for these applications, in terms of
security, e.g. perhaps we don't want sysadmins to know the database password
maintainability, e.g. making the configuration easy to change when the password changes, etc.
both windows and linux solutions appreciated!
I have a requirement to have a multiline textbox that accepts any text from any language and stores this into the database for later use.
I am using Linq with ASP .NET 3.5 with a SQL Server 2005 database.
Any/all information you can provide me with is much appreciated :D
How Can I Empty The Contents Of All Tables In My Database In phpMyAdmin Without Dropping Any Of The Tables In The Database?
Since I Do This Several Times An Hour While In Development, I'd Rather Not Individually Click "Empty" On All 60+ Tables Every Time.
Thanks In Advance.
Hi ,
I have column which consists of path for example \Abc\F\E\record_123 , now i need to update the path in database where only one change i need to do is tht
\Abc\F\E\record_123 = \Abc\F\G\record_123 - i want to update E to G .
how to do that with update query in database .
Can anyone help me its urgent.
Thanks
Smartdev
I have set up an Apache server on mandriva linux 2010.1. But the problem is whenever I'm trying to connect with the database, it's giving me the following error:
Error:Database error: SQLSTATE[28000]
[1045] Access denied for user
'root'@'myhostname' (using password:
YES)
Can anyone help in this regard please?
Thanks.
Is there an option for Zend's lucene implementation (or a third-party plugin) that would allow me to put the lucene dictionary into a [MySQL] database?
The reason I need to ask is that the database is the only common resource for our two otherwise independent web servers.
I'd like to be able to specify an SQLite database as a resource in the CACHE section of a manifest file. This would allow the script on the page to use the database in offline mode.
I cannot find anything in the HTML5 spec that says this cannot be done, but I haven't had any success in getting it working either.
Is it possible?
Hi
I am new in iphone I am developing a application which is connected with sqlite database.
When we build application in simulator it show value from database to tableview in simulator. When we build that application in device this is not show the value th tableview. I am not understand what problem.
I wonder if there is a supported way to access the SharePoint 2010 SQL Server through an API?
I'm not talking about modifying any SharePoint Database directly (I know that that is still unsupported), but I'd like to store some data that my application needs, and instead of asking the user to enter a Connection String, I'd prefer to create my own database on the SQL Server that SharePoint uses.
I think I could use the new Service Application stuff, but that seems a bit overkill?
I'm developing a cms for a company that has multiple regional sites (us, uk, china, russia, etc..). Should I use a separate database for each of these sites or use a single database with a 'site' field in each table? My main concern is the table language encoding (ie, can storing strings in different langauges in the same table cause problems, such as sorting issues).
i need to get an image from client and displayed(preview) before saving it into database..and then should be saved in database after getting preview..?
Is is possible in Asp.net using c#... ?
I am researching using silverlight 4 to develop a desktop application that can be installed from a browser window, now the tricky part is that I want a lightweight database embedded into the application. The database should install with the rest of the application and it should ideally work on both windows and mac systems. Originally I was thinking sqlite would be suitable for this but I have learned that it is not compatible with silverlight. Does anyone know of a solution for this?
Hi there,
I am developing an iPhone app, which now can update Twitter account with GPS coordinates in real-time, by the Twitter API link: http://username:[email protected]/statuses/update.xml , and I am looking at how to make my own database to accept updates from iPhone, via a similar API page.
It seems a .php page can serve as the API, and MySQL can serve as the database.
What are the good ways of doing it? Any template code and tutorial please?
I would like to use an XML database like eXist to store and query editable form submissions, with a changelog storing prior versions of each document.
How should I structure the database to easily query the latest version of each document?