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 >

  • android : SQL Exception while querying

    - by Ram
    Team, Can you please help me to understand why I m getting the following exception. 05-07 10:57:20.652: ERROR/AndroidRuntime(470): android.database.sqlite.SQLiteException: near "1": syntax error: , while compiling: SELECT Id,Name FROM act WHERE Id 1-IJUS-1 Thanks in advance,

    Read the article

  • "Ambiguous column name" error on one particular server

    - by jazbit
    This simple query throws the "Ambiguous column name TaskID" error on one db-server only. This is ridiculous. We tested this with the same database structure on different servers and different versions of ms sql (2005/2008), and it's only THIS particular client's server that throws the error. I'm actually frustrated. SELECT Tasks.TaskID FROM Tasks INNER JOIN TaskHelpers ON TaskHelpers.TaskID = Tasks.TaskID order by TaskID Yes, I know I can put "Tasks.TaskID" into the order by clause, but for some reasons I can't.

    Read the article

  • Comparing arrays with sql

    - by Nissim
    I want to perform a 'SELECT' statement with a byte array (binary) parameter as a condition. I tried to google it, but didn't find anything useful. In general, I keep information of files in the database. one of the properties is the file's hash (binary). I want to give a hash to the SELECT statement, and get all rows with the same hash value.

    Read the article

  • Handling ties when ranking from the highest to the lowest

    - by Undgerman
    I am trying to make a ranking manager for a small project.The totals are stored in the database.I can easily get the max and min using mysql and also arrange the records descending.The problem comes in when there is a tie.I need to show a tie in the form:1,2,3,3,4,5,6,7,7,7,7, etc.The repeated numbers will show the ties.I have been thinking of ways of achieving the above but i need more ideas;mine is seems long and complicated. Can anybody share his/her idea of doing the ties.

    Read the article

  • storing images in sqlserver using c#

    - by barq
    i want to store images of my employees with thier profiles in sql server database. i have following reservations. whether i should compress images or not if yes please provide me sample code or article how should i retrieve images efficiently, i an afraid of asp.net application performance issue. i think with ten thousand employee records it will halt or slow down

    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

  • 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

  • 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

  • Passing data between asp.net pages

    - by user204588
    Hello, I'm wondering the opinion of what is the best way to pass a lot of values between pages. I was thinking of either saving the values to a database, using context.Items[], or Session[]. I'm not sure about what is the best method. I'm passing probably around 40 variables.

    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

  • Most efficient way to move a few SQL Server tables to SQLite?

    - by wom
    I have a fairly large SQL Server database; I'd like to pull 4 tables out and dump them directly into an sqlite.db for remote querying (via nightly batch). I was about to write a script to step through(most likely on a unix host kicked off via cron); but there should be a simpler method to export the tables directly (SQLite not an option in the included DTS Import/Export wizard) What would the most efficient method of dumping the SQL Server tables to SQLite via batch be?

    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

  • WCF channel timed out error

    - by stackuser3
    Hi, I have devloped an application which connects the database thrugh WCF + LINQ. I am able invoke the service from my asp.net application successfuly. But the problem here is that, when i navigate from end to end in my application almost after four or five clicks, i am getting the late response and says channel timed out error. If anyone is aware about the soltion for this. It would be really helpful for me. Thanks,

    Read the article

  • Can Django be used for non web apps?

    - by Leeks and Leaks
    I noticed in the main Django introductin they show a feature that maps python objects to the database. This doesn't strike me as being mutually exclusive with with development, is there any reason why this can't be used for non web apps? Is it easy to separate out?

    Read the article

  • What values do the walkback array in the SocketException contain?

    - by akhilss
    Recently I have debugging into a problem where a connection to a database server from the application server get reset. I am pretty sure there is no reset being called from either end. But while I was debugging into the problem, while inspecting the SocketException, I found the walkback variable. arg0 SocketException (id=11532) cause SocketException (id=11532) detailMessage "Connection reset" stackTrace null walkback long[50] (id=11618) What do the values in this variable represent?

    Read the article

  • configuring UltraLiteJ with eclipse plugin

    - by rupesh
    hi all i am using eclipse plug-in for developing blackberry application, i want to use database in my program i am not getting a proper tutorial or any stuff for configuring Ultralitej with eclipse plug-in. can any one please provide me with any tutorial or any guidance. Thanks a lot

    Read the article

  • <object> pasted into textarea is removed... why?

    - by swt83
    I have a textarea that saves data into a database. For some reason it is removing <object> tags from anything that I paste into it -- none of the other tags are removed, only <object> tags. I've never had this problem before and have done this same thing in times past -- any ideas as to what could cause this? I'm not filtering the data before it's saved to the db at all.

    Read the article

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