Search Results

Search found 32538 results on 1302 pages for 'restore database'.

Page 551/1302 | < Previous Page | 547 548 549 550 551 552 553 554 555 556 557 558  | Next Page >

• not case sensitive query in mysql

  - by Mac Taylor

  hey guys i need to query my database and find results : mysql_query("select * from ".ALU_TABLE." where username like '%$q%' or name like '%$q%'"); if i have a name in my table such as Book and i enter book in search box it wont show the Book i need to query my database as not to be case sensitive.

  Read the article

• best way to create tables with Doctrine?

  - by ajsie

  assume that i start coding an application from scratch, is the best way to create tables when using Doctrine, to manually create tables in mysql and then generate models from the tables, or is it the other way around, that is to create the models in php and then generate tables from models? and if i already have a database, will the models created be optimal? cause i have heard some say that its best to create the database from scratch when using ORM, so that the relations are optimized for OOD. share your thoughts!

  Read the article

• (Python/Django): How do I keep my production db in sync (scheme and data) and with dev pc db?

  - by Emilio

  Hello, newbie here. i have a local Postgre database which will be filled with data (daily) on my local development machine. What is a good solution to transfer/sync/mirror this data to a production postgre database. For what it's worth I'm developing in Python using Dajngo. Thanks!

  Read the article

• Eclipse question - panels don't get restored when double clicking

  - by llm

  You know how, in Eclipse, when you double click on a file tab (which shows the class name), the editor gets expanded to the whole screen minimizing other panels? Well normally I just double click again on the tab to restore everything, but all of the sudden double clicking again doesnt do anything (the editor remains in full screen and all other panels minimized)! I am not sure what I did to cause this. Any ideas how to get it back to normal? Thanks.

  Read the article

• Google App Engine - The most awaited feature

  - by systempuntoout

  This list is taken from the official Google App Engine roadmap: SSL for third-party domains Background servers capable of running for longer than 30s Ability to reserve instances to reduce application loading overhead Ability to select different availability vs. latency options for Datastore Support for mapping operations across datasets Datastore dump and restore facility Raise request/response size limits for some APIs Improved monitoring and alerting of application serving Support for Browser Push (Comet) communication Built-in support for OAuth & OpenID What is your most awaited feature and why?

  Read the article

• how to create image thumbnails using django running on jython?

  - by Nitin Garg

  Hi guys, I am a newbee to django and jython. I need to create and save image thumbnails in database. I am using django running on jython and mysql database. I was exploring python imaging library, but the i found out that i wont work with jython. How do i create image thumbnails using jython and then save them in mysql db?? Any kind of help will be appreciated. thanx

  Read the article

• How to connect the PHPMYADMIN DB to create DB

  - by NewDev

  hi All, I am trying to create the batch file which will create the table in Jommla Database, Phpmy admin, I am trying to connect DB with mysql -uroot -ptest conf but it is not connecting to the database. regards NewDev

  Read the article

• How does timezone really work in relation to PHP and MYSQL?

  - by Rick

  I am getting very strange results in terms of timezones. I am currently using Wordpress and everytime I register a new user, I see the wrong datetime in the database. Ok so I am suspecting it is picking up the server time. So then I then set in php.ini to have date.timezone = "America/Los_Angeles" but again the time is still not correct in the database...And yes I have also set the timezone in Wordpress correctly. So how can this be done?

  Read the article

• .net Studio Server-Explorer crash

  - by testerwpf

  Im programming a small databased application. It worked fine, but now when i want to add a new table, the Server - Explorer freezes and my .net Studio too. If i try to make a new app with database, - wpf application with .net studio, -ADD Local Database - then try to add Table, my Database1.sdf disconnects and again freeze! I am using Windows7 professional.

  Read the article

• Want to check fields for data fast.

  - by Tom

  We have a database setup that consists of two parts: a static structure, and dynamic additions. For each database, the dynamic can be different, and sometimes we don't have data for all the dynamic fields. Rigt now, we check for empties by looking at the total count of records in the entire table, but we want to move to a more refined method of checking for empties if possible. Is it possible to quickly check through several hundred fields and see which ones are empty and which ones are populated?

  Read the article

• button submit with 2 different behaviour

  - by kawtousse

  hi, how could i set a variable with a submit button in order to differenciate 2 behaviours, so first time the same submit button will insert in database and in second time it updates database values. Thanks.

  Read the article

• How can I connect PHP 5.1 to Oracle 7?

  - by Travis Beale

  I have been able to query newer Oracle databases using the PHP oci8 extension with the Oracle 10.2 Instant Client. Unfortunately, the Oracle Instant Client seems to be unable to connect to an Oracle 7 database (version 7.3.3 to be precise). Is there a way to query an older Oracle database from PHP?

  Read the article

• How to save links in Django

  - by xRobot

  I have a simple Blog model with a TextFields. What is the best way to save link ? 1) Saving link in the database in this form: http://www.example.com and then using some filter in the template to trasform it in form: <a rel="nofollow" href="http://www.example.com>http://www.example.com</a> 2) Saving link in the database directly in this form: <a rel="nofollow" href="http://www.example.com>http://www.example.com</a>

  Read the article

• Externalize BIRT queries

  - by shikarishambu

  Hi, Is there a way to externalize report queries for BIRT reports. We need to support multiple database engines and so our queries are different depending on the underlying database. I would like to use a config parameter to tell BIRT report to use a specific query file

  Read the article

• weekly Automatic running sql server script

  - by AmRoSH

  I have sql server script and i want to automatic run it on the database every week. any help. i tried sql server agent job but i have alot of data bases on my server and i should make step to every database and it will run in the same day and same time.

  Read the article

• Getting random values in mySql query

  - by Roland

  I have a query which selects 6 names in the database. eg SELECT names FROM users LIMIT 6 Now I want this query to select a random 6 names in the database table, is this possible? And how

  Read the article

• How to create a "copy" of SQL Server transaction log file

  - by Salman A

  I want a copy of SQL Server transaction log file for "raw" analysis. What is the safest way to get a copy of that file without shutting down the database and disturbing the existing log/backups/backup schedules and just about everything. FYI, Its a SQL Server 2000 database server and I can see the log file (its about 4GB in size) and I cannot copy it as is; I get the "access denied" error when copying from explorer or command line.

  Read the article

• How to reformat date in PHP?

  - by Lisa

  I am pulling the dates of various posts from a database. The dates are in the following format: 2009-08-12 Numeric Year - Numeric Month - Numeric Day How can I reformat these dates to something more user friendly like: August 12, 2009 Numeric Month Numeric Date, Numeric Year Assuming that the date gotten from the mysql database is stored in a variable called: $date = $row['date_selected'];

  Read the article

• MYSQL: Copying a table from a snapshot into production

  - by ming yeow

  Hi folks, i have a snapshot of the database that I took before i did some data migration. The data migration messed up, so I want to retrieve the data from the snapshot to migrate over to the production database. Question: How do i access the snapshot, and how do i retrieve the available data? Thanks!

  Read the article

• How to automatically reseed after using identity_insert?

  - by Earlz

  Hello, I recently migrated from a PostgreSQL database to a SQL Server database. To switch the data over I had to enable IDENTITY_INSERT. Well come to find out that I get all sorts of strange errors due to duplicate identity values(which are set as primary keys) upon doing an insert in any of the tables. I have quite a few tables. What would be the easiest way of automatically reseeding the identity of every table so that it is after max(RID)?

  Read the article

• How to prevent users to change url parameter in PHP?

  - by Sachin

  I am developing a site where I am sending parameters like ids by url. I have used urlencode and base64encode to encode the parameters. My problem is that how can I prevent the users or hackers to play with url paramenters Or give access only if the parameter value is exist in database? I have at least 2 and at most 5 parameter in url so is this feasible to check every parameter is exist in database on every page? Thanks

  Read the article

• how to use data caching with sqldatabase and asp& c#.net

  - by subash

  i have a large database which is updated every now and then. The application has been developed in asp.net and c#.net. i need to fetch data from the datbase to griview on a button click event . i am planning to use data caching , so that i can improve the performance of the application how can i use DATA caching mechanism so that i could see the updated result of the database in a gridview.

  Read the article

• Service Broker is not starting

  - by Costa

  Hi ALTER DATABASE [Database Name] SET ENABLE_BROKER; Does not respond, and works infinitely. SQL Agent service is running, what is chances? Thanks

  Read the article

• restoring with mysqldump, but where is the data?

  - by Ole Media

  Ok, so I'm in need to restore a table and I do: mysqldump --opt database table_name < table_name.sql I hit enter and Done! Well, not really, when I go to see if there is anything on the table it show 0 records. I have look into the table_name.sql and I see two records. What am I doing wrong?

  Read the article

• MySQL: what data type to use for hashed password field and what length?

  - by z-boss

  I'm not sure how password hashing works (will be implementing it later), but need to create database schema now. I'm thinking of limiting passwords to 4-20 characters, but as I understand after encrypting hash string will be of different length. So, how to store these passwords in the database?

  Read the article

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