Search Results

Search found 40870 results on 1635 pages for 'database design'.

Page 553/1635 | < Previous Page | 549 550 551 552 553 554 555 556 557 558 559 560  | Next Page >

• Faster way to know the tolal number of rows in Mysql Database?

  - by Starx

  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

  Read the article

• ADO.net - how do I reload database data into an existing & filled DataTable?

  - by Greg

  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

  Read the article

• What is best way of keeping two database schema in synch?

  - by ebeworld

  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?

  Read the article

• Is there a way to listen for changes in an MySQL database table using Java and JDBC?

  - by adrian7

  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?

  Read the article

• Is SQLlite strong enough to use as wordpress database ?

  - by justjoe

  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 ?

  Read the article

• Best way to store a database password in a startup script / config file?

  - by Mark Harrison

  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!

  Read the article

• I have a problem saving foriegn text to a SQL Server database table with a nvarchar field.

  - by user307840

  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

  Read the article

• How Can I Delete The Contents Of All Tables In My Database In phpMyAdmin Without Dropping The Databa

  - by Joshua

  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.

  Read the article

• How to update database when using wild characters for example like .

  - by SmartDev

  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

  Read the article

• Why do I get "Access denied for user 'root'@'myhostname" when connecting to my database in PHP?

  - by eishita

  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.

  Read the article

• Can zend's lucene implementation be configured to use a mysql database instead of the file system?

  - by soulmerge

  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.

  Read the article

• Sqlit3 database content show in simulator but this is not show in devise.

  - by Ajeet Kumar Yadav

  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.

  Read the article

• HTML5: Can an SQlite database be specified in a manifest's Cache section?

  - by ghenne

  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?

  Read the article

• Can I use the SharePoint 2010 SQL Database through SharePoint from my App?

  - by Michael Stum

  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?

  Read the article

• Should multiple regional websites all use the same database?

  - by John Himmelman

  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).

  Read the article

• How to set up a database and API web page to accept POST updates from iPhone?

  - by lionfly

  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?

  Read the article

• Out of browser silverlight 4 application with local database that will run and install on windows or

  - by user360894

  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?

  Read the article

• In Asp.net (c#) ,how to store an image in database(sql) ?

  - by Anand

  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#... ?

  Read the article

• How should I represent revisions in an XML database?

  - by joeforker

  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?

  Read the article

• Copy a table from an SQL Server CE 3.5 database to another in Visual Studio 2008?

  - by ipapasa

  How can I copy a table from an SQL Server CE 3.5 database to another (also CE database) in Visual Studio 2008, using the design tools? Note: When right clicking on a table there is a "copy" command, but I couldn't find any "paste" command so far...

  Read the article

• How do I remove database name from SQL Server generated script?

  - by bucha

  Anytime I use 'script table as' - 'Insert To' (or other command), the script generated automatically places the database name in the script. Such as: INSERT INTO [DatabaseName].[dbo].[tblToBeInserted] ... While not a huge problem to just delete it, it has slipped by a few times and the script breaks if run on a different server with a different database name but has the same schema. (Such as running on [DatabaseName.Test]) Is there an option I can change, or can I modify the output in any way to remove this?

  Read the article

• Query to get the names of all tables in SQL Server 2008 Database.

  - by John H.

  Is it possible to write a query that will give me the names of all the tables in an SQL Server database? I'm working on some 'after the fact' documentation on a system I didn't create and am looking for a shortcut to get a listing of the tables in a database.

  Read the article

• How to retrive content of one table from database in sqlite for iphone?

  - by Warrior

  I am using Sqlite database in my app.I Have 3 tables in database(group, category & categorygroup).I want to retrieve the contents from the category table with reference to the primary key of the group table.category group act as a junction table which as both the primary keys of group and category .How can i achieve that.Please help me out,Thanks

  Read the article

• insert contacts into database but does not want to duplicate already existing contact.

  - by Frank Nwoko

  I am trying to insert contacts into database but does not want to duplicate already existing contact. Not sure INSERT has WHERE CLAUSE. Any ideas? //Insert INTO contact database $user_id = userid; $sql_insert = "INSERT into `jt_members_external_contacts` (`j_user_id`,`contact_email`,`firstname` ) VALUES ('$user_id','$email','$name') WHERE j_user_id !=$user_id AND contact_email != $email;";

  Read the article

• How to copy list of stored procs from one database to another in one go?

  - by LS

  I just copied my current database to a new database to find out only the tables are copied, How do I copy all stored procs the same way in one go? I do not want to create each stored proc one by one again running create queries Thank you in advance

  Read the article

< Previous Page | 549 550 551 552 553 554 555 556 557 558 559 560  | Next Page >