Search Results

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

Page 893/1300 | < Previous Page | 889 890 891 892 893 894 895 896 897 898 899 900  | Next Page >

• 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

• Rails view - user enters minutes, we save seconds?

  - by sscirrus

  Hi everyone, I have a simple text_field in my form where a user enters a time in minutes, i.e. 60. How can I multiply that number by 60 before saving the form, such that the database stores the number in seconds? Then, how do I reverse that and show the field in minutes on another view? 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

• unix timestamps and php

  - by sea_1987

  I have a list of unix timestamps in a database, and I wanting to select the ones that are from today. i.e If today is Tueday, I want to get all the timestamps that were made today? Is it possible? Is there such a things as strtotime("Today")? Any help would be great

  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

• 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

• 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

• mysql query fails.It gives me invalid result

  - by user2941349

  I have to write mysql query for fetching result from my database with a specified date and code like ABH18 or ABH17 or ABH19.I write the querly like below. select * from tbl_transaction where trans_name like 'ABH19%' or trans_name like 'ABH18%' or trans_name like 'ABH17%' or trans_name like 'ABH15%' and date_of_vazhipad='2013-11-20' and trans_status='Completed successfully.' There are no result in the DB satisfying all above conditions.But i got result with different dates.But i want to ensure the date_of_vazhipad='2013-11-20' so that the query may work properly Thanks in advance

  Read the article

• SSIS with different table structures

  - by Grace

  I have a flat file source from Excel that has a structure like this: **People** Day1 Day2 Day3 Day4 Person1 someValue ... Person2 Person3 And i would like the package to put this information in a database with standard columns 'Person', 'Day', 'Value'. Does anybody know how to do this - at the moment because the days are going along the top, the package is assuming these are seperate data columns when they are not really and the mapping is not working.

  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

• php tool - Extracting domain names from a zone file?

  - by Steve

  hi, i have access to the zone file for a tld. How can I extract just the domain names in the fastest possible way? Any suggestions on how to store them in a database/file? There are millions of them.

  Read the article

• How do I see the results of unique records added after adding records to mysql

  - by billy

  I'm a PHP noob. I have a database that I will update weekly with a CSV. So far I've managed to upload the file to the server, open the file with PHP, and insert the data in my table. Now I want to return the unique records that were added (on screen or in a file). How do I do this?

  Read the article

• Is this SQL is valid?

  - by Beck

  UPDATE polls_options SET `votes`=`votes`+1, `percent`=ROUND((`votes`+1) / (SELECT voters FROM polls WHERE poll_id=? LIMIT 1) * 100,1) WHERE option_id=? AND poll_id=? Don't have table data yet, to test it properly. :) And by the way, in what type % integers should be stored in database? Thanks for the help!

  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

• Does anyone know what is the 32 character string before the product image filename in Magento ?

  - by Daniel Higgins

  I ask this question, since I am trying to get the images I have just copied from Domain A to work in Domain B, (which is using the same database). http://DOMAIN_A/magento/media/catalog/product/cache/1/image/9df78eab33525d08d6e5fb8d27136e95/b/0/b0041-1.jpg I think knowing what the 32 character string is, which help me find a good explanation why the images are not being found in the front or backend of Magento after reinstall on DOMAIN B. RE: Magento version 1.4.0.1

  Read the article

• Subsonic class has reference to HttpContext.Current.User in a Windows app

  - by Darkwater23

  Hello! I'm using SubSonic 2.1. I ran it against a database and it created all the files seemingly correctly. However, when I went to use one of the classes, the app wouldn't built. I'm making a Windows application, but in the SubSonic file there's a reference to HttpContext.Current.User. Does anyone know why that would happen?

  Read the article

• Can I use an ORM (as Subsonic) to work with an API?

  - by Gabotron

  Hello ... I´m new to ORMs and I have a new project I´ll do in .Net MVC. In the Model Layer I´ll create my classes: Videos and I´ll work with APIs as a DataLayer (BrightCove & YouTube APIs). So, I dont have a Relational Database as a Data Layer. Is it possible to work with an ORM (as Subsonic)? Thanks!

  Read the article

• Difference between various string comparisons in Java

  - by Gandalf StormCrow

  Is there a difference between these ? if(myString.equals("")){ } if(myString.equals(null)){ } if(myString == ""){ } I have a string, I don't know is it empty or has some emtpy spaces I just wan't to stop it to be written in database if it is invalid(if empty or with some blank spaces).

  Read the article

• how to order string logically

  - by just_name

  Q: I have the following case : set of letters (grades) A,A+,A-,B,B+,B- stored as strings in the database i wanna to order these grades logically from the small one to the big one ,, but this not what happen in real.. because these are strings the order is: A,A+,A- i wanna ASC A-,A,A+ DESC A+,A,A- i bind those grades in drop down list and i wanna these grades with this logical order in it.. is there any idea how to do something like this..

  Read the article

• Validation library for PHP/mysql

  - by Industrial

  Hi! Is there any lightweight validation library available for PHP that easily can check if a specific string or value is valid for a known database type - Something like this: if (is_MEDIUMINT($var)) { $this->db->insert($anothervar); } Thanks!

  Read the article

• MIgrations and Rspec

  - by pablorc

  Hi, I'm developing a Rails application with Rspec for unit testing. Weeks ago, Rspec used to migrate the database to the last version automatically when executing 'rake spec', but now it doesn't do it automatically, I have to implement everything for myself. This happens in test environment, because my development data doesn't desappear. Is my fault? I didn't change anything, I think :) Thanks in advance.

  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

• How to enforce unique field value in java Google App Engine

  - by supercobra

  Hello there, I am try to find out how to enforce uniqueness in fields other than the unique id. Example: @PersistenceCapable(identityType = IdentityType.APPLICATION) public class User implements IsSerializable { @PrimaryKey @Persistent(valueStrategy = IdGeneratorStrategy.IDENTITY) private Long id; @Persistent private String name; @Persistent private String email; // <= I want this to be unique as well } In the example above, how can I enforce uniqueness of the email value across the database? Daniel

  Read the article

• Batch save in CastleProject ActiveRecord

  - by Alex

  I need to save thousand of records in a database. I am using CastleProject ActiveRecord. The cycle which stores that amount of objects works too long. Is it possible to run saving in a batch using ActiveRecord? What is recommended way to improve performance?

  Read the article

• hibernate proxy ..

  - by abc

  load() just returns a proxy by default and database won’t be hit until the proxy is first invoked. what does it mean by proxy exactly here ?

  Read the article

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