Search Results

Search found 32492 results on 1300 pages for 'reporting database'.

Page 895/1300 | < Previous Page | 891 892 893 894 895 896 897 898 899 900 901 902  | 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

• sql delete from rows value

  - by gloris

  The database includes a table with a rows: html/css/java/php How with sql query delete "java"? The result would be: html/css/php

  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

• Cascading drop down list in asp.net mvc 2.0?

  - by mary

  hello i want to implement cascading drop down list in asp.net mvc 2.0 from database. i had implementated it on mvc 1.0 but its not working in mvc 2.0 thank you.

  Read the article

• show data from sql server in blackberry using .Net

  - by Cuil

  Hi all, i want to ask about development in blackberry. I have background in .Net winform. If i want to develop an application to show data from Ms.SQL server 2008 database in blackberry. what should i learn and what should i do ? thank you for your advice.

  Read the article

• Remove all styles from dynamic label in asp.net

  - by kad1r

  I have a label and I got some text from database. text format like: Windows Server 2008 ...etc But sometimes there are different fonts or something like style. How can I remove all of them quickly? I know I can make it with replace command. But is there any quick way for it?

  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

• Automatic backup

  - by xRobot

  I need to backup automatically daily my database in mysql and all image files on the server. Is there a way to backup these things and send it on my email address ?

  Read the article

• bat file. delete until success?

  - by acidzombie24

  I run a bat file to clean up and sometimes it takes a few seconds for my app to full close. In it i delete a database. Instead of waiting or running it multiple times i would like the bat file to continue its attempts until it has a success. How can i do that?

  Read the article

• Auto update after specific day passed

  - by Crays

  Hey guys, i've this theme of the week script, easy, just post like normally, save in database and echo it in a column. But since its theme of the week, i would like it to automatically renew the value to say "none" or "not set" after a week. I know cron jobs could do this but is there another way? [Running in PHP]

  Read the article

• MySQL Backup Procedure

  - by mouthpiec

  Is there a way to backup an MySQL database so that if something wrong occurs, it will be easy to recreate the tables with the same data?

  Read the article

• SQL Server Text type v.s. varchar data type

  - by George2

  Hello everyone, I have variable length character and want to store in SQL Server (2005) database. I want to learn some best practices about how to choose TEXT SQL type or choose VARCHAR SQL type, pros and cons in performance/footprint/function. thanks in advance, George

  Read the article

• Update XML as Upper Case in SQL Server

  - by monO

  I store an XML string in a column in my SQL Server database. I'm trying to run an UPDATE statement that will make a certain field into Upper Case. I can do that easily during a SELECT but can't get it to work with an update. This SELECT statement works select Upper(XmlTest.value('(/CodeFiveReport/Owner/@UnitNumber)[1]', 'varchar(10)')) as UnitNumber from uploadreport But I want to update it the XML as that permanently Update table Set XmlString.Modify('replace value of (/Root/Node/@Field)[1] with ?

  Read the article

• implement multithreading

  - by Neo

  how to to implement multithreading where one thread updating UI and other one is reading the database record in windows application Any guidelines really appreciated...

  Read the article

• Is it expensive to hold on to PreparedStatements? (Java & JDBC)

  - by sbook

  I'm trying to figure out if it's efficient for me to cache all of my statements when I create my database connection or if I should only create those that are most used and create the others if/when they're needed.. It seems foolish to create all of the statements in all of the client threads. Any feedback would be greatly appreciated.

  Read the article

• i m new to sharepoint , where coding take place in sharepoint application as other normar asp.net a

  - by girish

  hello, i m new to sharepoint and bit confuse, i don't understand where coding take place in sharepoint as other asp.net application. how it work if i have to create a page for adding record to database.

  Read the article

• Importing old mysql data folder

  - by samgoody

  After a reinstall, all of the old data still shows inside the MySQL/data folder, but is not actually loaded into the database. Is there any way to have MySQL scan it's data folder and / or reimport the old folders it has from its previous install? [Some data was changed after the last backup / export - partially my fault - so I would rather it recognize the folders rather than reimporting the SQL files.]

  Read the article

• Hibernate (JPA) Entity with Static collection as a member

  - by Kyle Partridge

  Is it possible to have a static collection as a member of a hibernate entity? Say I have an object Question: public class Question { private String category; ... } Would it be possible to populate a static Set<String> that is a distinct set of all categories in the Database? I know I could just query this, but I was wondering if there was a more elegant solution, as it seems like something that other people may have come across.

  Read the article

• Where is all_nested_table_cols in 9i?

  - by thecoop

  Oracle 9i has nested tables, however it doesn't have the all_nested_table_cols sysview (like 10g and 11g) which lets me see what the columns are for these nested tables. How can I find this information on a 9i database?

  Read the article

• add item to combobox outside of the array - flex

  - by Adam

  I've got a combo box that's data provider is coming form a database query. Now I'd like to add one hard coded item to be included in the combobox a sort of reset item that would reset the combobox to display its prompt message. Any idea how to do this? Thanks!

  Read the article

• Appropriate data field type for true/false value?

  - by Industrial

  Hi everybody, What's the most appropriate (read least data consuming) data field to store a true/false/1/0 value in a mySQL database? I have previously used a one character long tinyint, but I am not sure if it's the best solution? Thanks!

  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

• SQL select order by decimal precision desc

  - by user267272

  I'm interested in finding the most precise decimal values in a database field. I'd like to be able to sort results by descending precision. Is this possible? e.g. 10.1781253 12345.12435 89.763 1.1 2

  Read the article

• how to get a formatted text output for a data posted using tinymce (in symfony)??

  - by vesselyp

  I'm working on a first symfony project, i am using the sfWidgetFormTextareaTinyMCE widget for a form tinymce text area. It works fine, but while retrieving from database, instead of showing me the formated text, i have the <strong>,<p>,<br>tags in the text. help me please

  Read the article

• How to show only few lines from a body text

  - by saquib

  Hi, I have a mySql database i want to display only 10 words from its body field which contain html codes, How i can do that, is there any php function to do that.

  Read the article

< Previous Page | 891 892 893 894 895 896 897 898 899 900 901 902  | Next Page >