Search Results

Search found 30225 results on 1209 pages for 'columnar database'.

Page 340/1209 | < Previous Page | 336 337 338 339 340 341 342 343 344 345 346 347  | Next Page >

• Faster way to know the total 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 this: $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 the entire database. Is there a better way?

  Read the article

• How does one concatenate database values into a string?

  - by ggg

  I would like to string together database values into a string. Something like $a "text" $b. And then use the entire string as a variable, let's say $c. Is it better to do this at the database level? Will php use lots of resources to do this?

  Read the article

• setting the datetime in jquery datetime picker with database datetime.

  - by sagar

  hi,i am developing a multi language site.My problem is i need to set the date and time in the datepicker from the database as the user may have choose the different timezone while registering in the site.At present i am getting the server time on my jquery datepicker. Thanks in advance. Technology used:Asp.net mvc,Jquery. Database:Sql server2005. O/s :winxp.

  Read the article

• How do I specify a recovery model (full, simple or bulk-logged) when creating a database in T-SQL co

  - by Ivan

  How do I specify a recovery model (full, simple or bulk-logged) when creating a database in a CREATE DATABASE query in T-SQL code?

  Read the article

• Where is the html5 local database located on a client machine?

  - by gath

  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

  Read the article

• How are lookup columns for lists maintained in Sharepoint Content database?

  - by Abhishek Rao

  Can someone explain how are lookup columns for lists maintained in Sharepoint Content database? How is the relationship maintained in the database?

  Read the article

• how to write the array into the sqlite database for objective-c ?

  - by uttam

  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.

  Read the article

• one or more Entity models for one database for entity framework?

  - by KentZhou

  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?

  Read the article

• 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

• In Asp.net (c#) ,how to store an image in database(linq to 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

• 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

• 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

• 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

• 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

• 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

< Previous Page | 336 337 338 339 340 341 342 343 344 345 346 347  | Next Page >