Search Results

Search found 30279 results on 1212 pages for 'database drift'.

Page 804/1212 | < Previous Page | 800 801 802 803 804 805 806 807 808 809 810 811  | Next Page >

• How can I extract a range of lines from a text file on unix?

  - by Adam J. Forster

  I have a ~23000 line sql dump containing several databases worth of data. I need to extract a certain section of this file (i.e. the data for a single database) and place it in a new file. I know both the start and end line numbers of the data that I want. Does anyone know a unix command (or series of commands) to extract all lines from a file between say line 16224 and 16482 and then redirect them into a new file?

  Read the article

• mysql: Can I use two "where"s? Like, "SELECT * FROM table WHERE something and something"?

  - by KeriLynn

  I have a table with my products and I'm trying to write a page that would pull bracelets with certain colors from the database. So here's what I have right now (in php): $query = "SELECT * FROM products WHERE (products.colors LIKE '%black%')"; But I only want to select rows where the value for the column "category" equals "bracelet". I've tried a few different things, but I keep getting warnings and errors. I appreciate any help you can give, thank you!

  Read the article

• IIS 6.0 Server and Unicode Characters

  - by Srikanth

  We are performing a pen test on a simple asp application that uses MS SQL Database. It seems for the authentication they are using dynamic constructed queries but escaping single qoutes. When we use Unicode quotes like %uFFO7,%u02b9 etc we are able to successfully inject SQL injections. Want to understand is it more a kind of configuration issue of IIS server to cannonicalize Unicode characters or the way the validation function to escape single quotes is written is the cause of the problem?

  Read the article

• How to remove all data about some Web Application from aspnet tables ?

  - by nCdy

  Is there some way to remove data about all users , roles e t c from some Web application into aspnet database tables ? tables like dbo.aspnet_Applications (here is this application that I want to remove) but also I need to remove all data with this application in other tables...

  Read the article

• How do I get SQL Server 2005 data stored as windows-1252 as UTF-8?

  - by Diodeus

  I have a client database with English and French data in windows-1252 encoding. I need to fetch this data as part of an AJAX call and send it in UTF-8 format. Is there a way I can pass the data through a stored proc to perform this conversion? My web app cannot be altered to perform this conversion itself.

  Read the article

• problem with IN clause in SQL

  - by user179056

  Hello, We have observed that there seems to be a maximum number of ids/variables which one can pass in the IN clause of SQL as comma seperated values. To avoid this we are storing all the ids in a table and doing a SELECT within the IN clause. This however means extra database operations to store and retrieve ids. Is there any other way to use IN without SELECT? regards Sameer

  Read the article

• ListPreference, how can you make it to NOT save to SharedPreference?

  - by Pentium10

  I am resuing ListPreference for a setting which I store in the database. I do not want it stored in the preference file. How can I reuse ListPreference in such way that it does not save to SharedPreference file?

  Read the article

• Object in NSMutableArray crushed in memory

  - by Yoot

  Hi, I have some big problem with an NSMutableArray I'm filling with objects in a database. I'm using [appDelegate.myArray addObject:myObject], then somehow the object gets crushed in the memory, I don't know why, I didn't release anything... Thanks for your answers (and sorry for my poor english xD)

  Read the article

• Shell script that iterates through a sql "delete" statement

  - by ming yeow

  I need a shell script that deletes 1000 rows from a massive database until it is done. It is very simple, but i am very weak in shell scripting, and the many tutorials online offer extremely similar, but different nuances in syntax

  Read the article

• MySQL: Digits (1.75) to Friendly Time (1 hour and 45 minutes)

  - by Nick

  In my MySQL database, I have a float field named "HoursSpent" with values like "0.25", "1.75", "2.5", etc. Is there a way that I can have my SELECT statement format those values in a friendly format like this?: 0.25 = 15 minutes 1.75 = 1 hour and 45 minutes 2.5 = 2 hours and 30 minutes The "HoursSpent" field is supposed to only have values in 0.25 increments, but if somebody were to put something random like 0.16, it would be nice if the SELECT statement handled that by rounding it up to the nearest 0.25 (so in this case 0.16 would become 0.25, or 15 minutes).

  Read the article

• log error and warning info in iphone

  - by Shibin Moideen

  Hi, I need to get the error, warning log when the iphone application is running and want to save it as a file in the database. i am using phpmysql as backend. is there any way to get this.?\ Help needed Thanks, Shibin

  Read the article

• Centralizing / Abstracting MSSQL Data from Multiple Tables / Databases

  - by davemackey

  If one has a number of databases (due to separate application front-ends) that provide a complete picture - for example a CRM, accounting, and product database - what methods are available to centralize/abstract this data for easy reporting? Essentially, I'm wondering if there is a way to automatically pull data from multiple databases into a central repository that is continuously updated from the three databases and which can be used for reporting? I'm also open to alternative best practice suggestions?

  Read the article

• Not getting the token secret value

  - by Lincy

  I am using my application for twitter oauth with .Net. My problem is that though i am getting oauth token, iam unable to receive the token secret. Also I need the token pairs to be stored in my applications database for exchanging request token for access token. Can some one help?

  Read the article

• How to search a hybrid ASP.NET Intranet site?

  - by user343416

  How would you implement a search facility within an ASP.NET hybrid application? I'm really tempted to start rebuilding our Intranet application using ASP.NET MVC & Web Forms (mainly MVC though). I know how to search the dynamic content from a database, but I'm struggling with the static content in the Views. Surely this should be an easy task with routing and a sitemap.

  Read the article

• How to manipulate sql connection string in C#

  - by Liveonthree

  Hi i'm trying to manipulate the sql connection string so instead of running the original copy of our database it runs from the copy one folder up in our C# project.

  Read the article

• Check if a connection is in a transaction

  - by acidzombie24

  I am getting a SqlConnection does not support parallel transactions. exception and this answer mentions its when a connection tries to open two transactions. This is exactly what i am doing. I thought nested transactions were ok (i was using sqlite for the prototype). How do i check if the connection is already in a transaction? I am using Microsoft SQL Server Database File.

  Read the article

• Is there any Gmail API for Java

  - by chenxgre

  I am trying to crawling google gmail inbox and download messages into the database, is there any gmail java api can best do this job?

  Read the article

• Doubt about odbc's in c#

  - by aF

  Hello, I run a c# process and in the middle of the night this happens: ERROR [HY000][DataDirect][ODBC Sybase Wire Protocol driver] Timeout exceeded I know for sure that the database is allways active! But this keeps happening! Do you how can I fix this error? Thanks in advance!

  Read the article

• how to submit a form and show the result in that page

  - by Mac Taylor

  hey guys im using a form in php to submit some information into my database so i used two function to do this but how to show the result in th same page that has the form

  Read the article

• Upload & Link an Image with php

  - by Jason

  I know this should be really simple, but im having trouble getting this to work right, basically i want to have an image upload box that uploads an image and then puts the new url into a mysql database. Anyone have any advice on how to do this, as i may be having developer block but im over complicating it in my head :P Thanks

  Read the article

• How would Sphinx Search index / handle JSON files?

  - by ming yeow

  I have a mysql database that stores mainly JSON objects. I am thinking of using Sphinx to search through it - but i was wondering how would i index and retrieve these json objects?

  Read the article

• How much memory does a hashtable use?

  - by Michael

  Would a hashtable/hashmap use a lot of memory if it only consists of object references and int's? As for a school project we had to map a database to objects (that's what being done by orm/hibernate nowadays) but eager to find a good way not to store id's in objects in order to save them again we thought of putting all objects we created in a hashmap/hashtable, so we could easily retrieve it's ID. My question is if it would cost me performance using this, in my opinion more elegant way to solve this problem.

  Read the article

• Simple tool/steps for obfuscating/scrubbing production data

  - by Krishna Kumar

  I am involved in a project where I need to provide subset of our production data (for a date range) to one of my co-workers for trouble shooting.I would like to insert a scrubbed subset of the production data into a new database table that my co-worker can access. Please suggest best approach to achieve this.

  Read the article

• how to write oracle two instance information in single query?

  - by rsaravanakumar

  i using oracle 10g database, i installed two instance in my machine(dev and dev10g), i using query "select instance_name,status from v$instance" this query return one instance information but i need two (dev and dev10g) instance information, how i write a query. it is possible without using dblink. pls help me.

  Read the article

• Some questions about using NDK for faster programming results.

  - by Pentium10

  I have the following questions, please if you know the answers share it with me. How can I transform my working Java code to NDK? (it's an algoritm not activity) I am able to access the database from NDK? Will a backtracking algorithm with 10 millions of iterations run faster if was written with NDK?

  Read the article

< Previous Page | 800 801 802 803 804 805 806 807 808 809 810 811  | Next Page >