Search Results

Search found 26798 results on 1072 pages for 'difference between detach attach and restore backup a db'.

Page 644/1072 | < Previous Page | 640 641 642 643 644 645 646 647 648 649 650 651  | Next Page >

• How To determine the order data is read from a MYSQL Database?

  - by Shinigami

  is there a way to change the order data from a DB are read ? you know , the default order is that they are read from the first data inserted to the latest so is there a way to change it to latest-first?

  Read the article

• Query interface for iPhone CoreData store

  - by JT

  Hi, another iPhone newbie question... I have the following: NSPersistentStoreCoordinator NSManagedObjectContext NSManagedObjectModel Is it possible to run queries directly on the store (since its a sqlite DB)? I'm trying to delete all the records from a tableview, and figured a "DELETE FROM table" would be nice and quick as opposed to looping through the records and removing them manually (which i'm also struggling with). Thanks for your time, James

  Read the article

• Getting single value from a single row with Mysql/PHP

  - by Ghostrider

  Often I just need to get a single value from MySQL that I know exists there. I use the following construct: $result = end(mysql_fetch_array(mysql_query('SELECT FOUND_ROWS()', $db))); Is there a proper single function in PHP that would do this?

  Read the article

• Can entities be attached to an ISession that weren't previously attached?

  - by TheCloudlessSky

  I'm playing around with NHibernate 3.0. So far things are pretty cool. I'm trying to attach an entity that wasn't detached previously: var post = new Post(){ Id = 2 } session.Update(post); // Thought this would work but it doesn't. post.Title = "New Title After Update"; session.Flush(); Is this possible so that only Title gets updated? This is currently possible in EntityFramework. I'd like to not have to load Post from the database when I just need to update a few properties.

  Read the article

• How to sync two folders in PHP?

  - by OM The Eternity

  I am using windows, Mysql DB, PHP I am building the Joomla Component whose one of the functionality is to synchronize the folders I want to sync two folders of different name.. How can I do this? It has to be dne in the same machine, no two different servers are involved in it.. How to sync two folders in PHP?

  Read the article

• Javascript Source to textarea value

  - by user117701

  I am creating some JSON on the fly, serializing it and saving it to the DB. To run it, i create a script element, and load it that way. Is there a way to load the script source to a textarea?

  Read the article

• What are Interfaces and Delegates in c# ?

  - by karthik

  Since i am new to c#, would like to know about Interfaces and Delegates in c#, the difference between them and scenarios both these to be used. Please don't provide any links, i would like an explanation in simple words.

  Read the article

• Magento Reindexing doesn't work

  - by Dgent

  I recently created around 700 attributes through script, all attributes look fine at backend. But when I reindex, I get following error: exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.additional_information_s' in 'field list'' in /lib/Zend/Db/Statement/Pdo.php:228 Note: this attribtue exist in Database (eav_attribtue) table. I would highly appreciate suggestion. Looking forward to heat from you geeks. Thanks

  Read the article

• TSQL to combine a date field and a time field

  - by justSteve

  Using logparser to import IIS logs to a db results in one column that has the date value and a second field for time: 2010-05-25 00:00:00.000 2010-01-01 11:11:58.000 I'd like to code an INSERT AFTER trigger that combines the 2 fields.

  Read the article

• The fundamentals of Hash tables?

  - by kylex

  I'm quite confused about the basic concepts of a Hash table. If I were to code a hash how would I even begin? What is the difference between a Hash table and just a normal array? Basically if someone answered this question I think all my questions would be answered: If I had 100 randomly generated numbers (as keys), how would I implement a hash table and why would that be advantageous over an array? Psuedo-code or Java would be appreciated as a learning tool...

  Read the article

• slot booking problem

  - by pradeep

  Hi, I am making a doctor appointment slot booking mechanism,where in doctor appointment slots will be divided into 30 mins slot each...i have achieved all the working code.. 1 problem i am facing is that..this booking is made at 2 places i.e 2 receptions..so when 1 selects a slot(radio button) not yet confirmed and saved in DB.other reception must not be able to select .how do i do it.any help on this...how do i go abt it.

  Read the article

• How do I execute an action in drupal after each time a node is saved?

  - by ford

  I'm developing an Action in Drupal which is supposed to activate after saving a node, exporting content to XML (which includes data from the node that was just saved), using the "Trigger: After saving an updated post" trigger. Unfortunately this action actually happens right before the information from the recently saved post is saved to the database. ie. when looking at the XML later, I find that the most recent change I made was not included. Saving after editing a different node will restore the previously missing data. How can I get my action to fire after the saving process is complete?

  Read the article

• SQL commands generated in Django by running sqlall

  - by k-g-f

  In my Django app, I just ran $ python manage.py sqlall and I see a lot of SQL statements that look like this, when describing FK relationships: ALTER TABLE `app1_model1` ADD CONSTRAINT model2_id_refs_id_728de91f FOREIGN KEY (`model2_id`) REFERENCES `app1_model2` (`id`); Where does "7218de91f" come from? I would like to know because I'd like to manually write SQL statements to accompany models changes in the app so that my db's can be kept up to date.

  Read the article

• Creating my own simple CMS for asp.net-mvc?

  - by coure06

  I want to create a simple CMS for my asp.net-mvc site. Needs some help to start. Will i save my whole page to db? what if my page contain links like Url.Content("~/somepage") When the admin will edit the page he will get the plain link not the Url.Content. How i can handle this in CMS?

  Read the article

• Using Oracle Zero Date

  - by Noam

  I have an application with existing data, that has Zero in the date column. When I look at it from sqlplus I see: 00-DECEMB when I use the dump function on this column, I Get: Typ=12 Len=7: 100,100,0,0,1,1,1 I need to work with the existing data from .Net (no changes to the data,or the data structure or even existing sql statements) How the hack do I read this value, or write it. The db version varies, from 8 to 11. Help would be appreciated

  Read the article

• Why is @somesynatax used on a line before people define a method for thier Model in App Engine?

  - by indiehacker

  Why are these used prior to defining a method for a model? @classmethod @staticmethod What is the difference between them? Are there others I should be aware of? Must I use them?

  Read the article

• Problem in importing the CSV file containing multiple commas in a sigle field

  - by kakaajee

  Hi Experts, I am having an issue with importing a large(60MB) CSV file in MYSQL DB. The problem arises when an address field has multiple comma seperated values e.g. home no, street no, town etc. I tried to use BigDump for it but, the problem did not solved because of a single field containing multiple comma separated values. Any idea, suggestion or solution from experts how to handle it? Please reply, because I am sick of it. Thanks

  Read the article

• LoadControl - from string variable

  - by creo

  If e.g. I keep control markup in DB instead of ascx file. How can I load control from string constant? (of course if I don't want to save copy to disk)

  Read the article

• Using YQL and Jquery to check URL validity

  - by user102533

  The answer in this post http://stackoverflow.com/questions/2119680/use-jquery-to-check-if-a-url-on-another-domain-is-404-or-not shows how to use YQL in Jquery to check if URL is valid or not. However, I can't get this to work for me. The only difference I can think of is that my URL is a text file (http://mycrossdomain.com/sometext.txt) and not HTML.I think the YQL query needs to be adjusted accordingly. Any help is appreciated.

  Read the article

• Can one use Airport (Time Capsule) with an external DHCP server?

  - by DNS

  I currently share my DSL connection using a wireless router with DHCP disabled, and dnsmasq running on a Mac Mini serving DHCP & DNS. This setup is important because I have clients doing PXE boot, and I need the control over DHCP that dnsmasq provides. There is also a Time Capsule on the network that's used purely as a backup device; its wireless functions are disabled. The wireless router is starting to get a little flaky, and since it doesn't support 802.11n I'd like to replace it. Rather than buying a new router, I'd like to just use the Time Capsule. But I see no way to disable its DHCP server; when I set the connection type to PPPoE, it insists on serving DHCP. Is there any way to use Airport PPPoE with a DHCP server elsewhere on the network?

  Read the article

• How do I set prifix to django contrib tables names?

  - by Software Enthusiastic

  HI One of my requirement is to have prefix on all the tables of the django based project (Because db is hosted on shared server). I have used db_table Meta option to set the prefix for the tables which I have created. Now my query is how do I set the prefix for tables provided by django.contrib. Instead of auth_group django should create prefix_auth_group.... How do I do that? Thank you very much...

  Read the article

• Whats is active record A design Pattern OR A module

  - by piemesons

  Whats is active record "a design Pattern" OR "a module". Basically whats the difference between design pattern, module and some other terms we use.

  Read the article

• how to store hour and minute in database table while using mktime() function?

  - by Learner Miz

  I am using a form to get the hour and minute using post method and then store it to mysql DB. Such as : $hour = $_POST['hour']; $minute = $_POST['minute']; ** There is no need of date, month and year. I just need to store the hour and minute in a column of a table (ex: exam_time) Column structure: exam_time time NOT NULL Now how to store these value into database using mktime() function. I tried but it stores 00:00:00, not the one which I am sending via form.

  Read the article

• Can I use anything other than BIGINT as Primary Key data type in SQLite?

  - by weenet

  I was psyched about the possibility of using SQLite as a database solution during development so that I could focus on writing the code first and dynamically generating the db at runtime using NHibernate's ShemaExport functionality. However, I'm running into a few issues, not the least of which is that it seems that SQLite requires me to use Int64 for my primary keys (vs, say, Int32 or Guid). Is there any way around this?

  Read the article

• openvpn and selective routing

  - by mx2323

  hi everyone, whats the best way to configure openvpn clients to go selectively go about using an openvpn connection? i want to setup a vpn server for friends in china, but i dont want them to use it for everything, just so they can access sites like youtube, facebook, cnn, etc. while they are in china through the vpn (these are blocked). it would be nice if the vpn was a backup, so for instance if they are trying to go to facebook (which is blocked), it would go through the vpn connection once finding that the normal connection does not work. this would save a lot of bandwidth cost actually, and give them a better browsing experience. is this a iptable route thing? or a dns server that i push to my clients?

  Read the article

< Previous Page | 640 641 642 643 644 645 646 647 648 649 650 651  | Next Page >