Search Results

Search found 17762 results on 711 pages for 'sr query'.

Page 148/711 | < Previous Page | 144 145 146 147 148 149 150 151 152 153 154 155  | Next Page >

• Hibernate Native Query problem with named parameters

  - by dime

  I have a problem with Hibernate Native Query. I have one SELECT that selects array slice (PostgreSQL database). The problem is that hibernate recognizes the following part: ":300" from "SELECT my_array[1:300]..." as named parameter and I get the following exception: Not all named parameters have been set. I tried to escape the colon (:) with '\:' , '::' but with no success. The Hibernate version is 3.2

  Read the article

• Cannot use ternary operator in LINQ query

  - by Nissan Fan

  I can't figure out why I get a Object reference not set to an instance of an object. error if I use a ternary operator in my LINQ query. var courses = from d in somesource orderby d.SourceName, d.SourceType select new { ID = d.InternalCode, Name = string.Format("{0} - {1}{2}", d.InternalCode, d.SourceName, (d.SourceType.Length > 0 ? ", " + d.SourceType : string.Empty)) }; Any thoughts?

  Read the article

• Can I override a query in DJango?

  - by stinkypyper

  I know you can override delete and save methods in DJango models, but can you override a select query somehow to intercept and change a parameter slightly. I have a hashed value I want to check for, and would like to keep the hashing internal to the model.

  Read the article

• sql Query Time out error

  - by prakashbhatt

  Hi, I have a table which have 6 million recods,when a fire select query with where condition in that table it is timing out. How can I make it run, Please help

  Read the article

• Query having 2 Where Clause

  - by Harsha M V

  i am trying to login and want to validate username and password against the records in the database. I am not sure how to pass two Where clause public Boolean login(String username, String password) throws SQLException { Cursor mCursor = db.query(TABLE_USERS, new String[] { ID, KEY_NAME, KEY_USERNAME}, KEY_USERNAME + "=" + "'"+username+"'", KEY_PASSWORD + "=" + "'"+password+"'", null, null, null, null, null); if (mCursor.moveToFirst()) { return true; } return false; } Am getting a Syntax Error.

  Read the article

• ORDERING A MYSQL QUERY WITH JOINS AND GROUPS

  - by Oliver

  I have this mysql query: SELECT * FROM Customer c JOIN eHRDemographic ehD ON ehD.CxID = c.CustomerID JOIN CustPrimaryWeight cpW ON cpW.CxID = c.CustomerID WHERE c.CustomerID =22703 GROUP BY c.CustomerID ORDER BY cpW.CustPrimaryWeightID DESC This doesn't really work correctly as the CustPrimaryWeight table has multiple enteries and it's simply joining the first entry and not the more recent one as the ORDER statement doesn't seem to do anything. Any ideas?

  Read the article

• save 20 users with one sql query?

  - by fayer

  i save a user like this in doctrine: $user = User(); $user->name = 'peter'; $user->save(); is there a way to save 20 users in one sql query? or do i have to loop the above code 20 times hence creating 20 sql queries? thanks

  Read the article

• easy mysql query question

  - by Ahmet vardar

  Hi, here is the "msg" table on mysql sent_to customer msg read ------- -------- ------ ----- 45 3 bla 0 34 4 bla 1 34 6 bla 0 45 3 bla 0 56 7 bla 1 45 8 bla 0 for example user whose id number is 45 logs in, i want him to see this, you have 2 unread msg to your "number 3" customer you have 1 unread msg to your "number 8" customer like a news feed what query should i use for this ? thx

  Read the article

• Usage of Memcache to improve performance of MySQL Query

  - by Rachel

  Is is always advantages to use memcache to improve performance of MySQL query ? Are there any downsides of extensive use of Memcache ?

  Read the article

• Mysql query to fetch data

  - by hnihar

  i have a table "request" with 4 columns namely: 1.recId :long primary key 2.interactionId:long 3.requestedBy:boolean 4.requestedType:boolean and data is as follows: VALUES (185,455699,0,5), (186,455746,0,1), (187,455746,1,1), (188,455752,0,1), (189,455753,0,1), (190,455753,1,1), (191,455754,1,1) i want a query to fetch all the rows where interactionId is same and having requestedBy both 1 and 0 values and requestType=1; regards, Nihar

  Read the article

• Selecting events from SQL Profiler in 2005 for profiling a query

  - by user279521

  Hi, I need to profile a large SQL query (in a particular database, not the whole server), and I cant figure out how to setup the profiler. I tried reading MSDN SQL web site, but it has not helped. I am stuck at the Trace Properties "Events Selection" window. I need help as to which items to select in "Events Selection" window. Thanks

  Read the article

• Help with this JET Sql Query [SOLVED]

  - by yae

  Hi: I need help to do this query select. for example I have these fields: idInvoice date amount Depending of the date I need multiply the field "amount" for x number or other one. For example, if the date is less 01/01/2010 to multiply for 20 . But if it is major or equal to multiply for 35 Select idInvoice, date, amount, amount * varNumber from invoices

  Read the article

• how to query the settingspropertyvaluecollection

  - by amitha

  I have a settingspropertyvaluecollection.I dont want to loop through all the properties using a for each loop.Instead i want to query the collection.How do i do that?is there a way to use LINQ and do it? Thanks

  Read the article

• Query for second maximum salary from employee table

  - by Dinesh

  how to find out second maximum salary from all employee in employee table ? please give me sql query.

  Read the article

• Linqbuilder Query with an OrderBy

  - by Renshai

  I have a 1 : M relationship. I built a dynamic query based on input from users to return the listing of parents entities along with their children (using predicate builder: (done successfully new TDataContext().Ps.Where(predicate) )... but need to order the results by a field found only on the child entities. I'm at a loss: new TDataContext().Ps.Where(predicate).OrderBy(p = p.Cs. ??) where Ps = parents collection relationship with Cs = child entities any help appreciated.

  Read the article

• Is a https query string secure?

  - by Mark

  I am creating a secure web based API that uses HTTPS however if I allow the users to configure it (include sending password) using a query string will this also be secure or should I force it to be done via a POST?

  Read the article

• Hibernate query cache automatically refreshed on external update?

  - by artgon

  I'm creating a service that has read-only access to the database. I have a query cache and a second level cache enabled (READ_ONLY mode) in Hibernate to speed up the service, as the tables being accessed change rarely. My question is, if someone goes into the DB and changes the tables manually (i.e. outside of Hibernate), does the cache recognize automatically that it needs to be cleared? Is there a time limit on the cache?

  Read the article

• Parse query string in JavaScript

  - by sinaw

  I need to parse the query string www.mysite.com/default.aspx?dest=aboutus.aspx. How do I get the dest variable in JavaScript?

  Read the article

• Query Entity Framework 4

  - by nick

  Hi, Is it possible to run a query on an EF4.0 data context and get all objects of a certain type? Say the context has books, genres & authors but I only have a generic parameter, t. Is it possible to get all of type just by using this t? I don't think it is :(

  Read the article

• Assign query results to MySQL variable

  - by 5un5

  I'm querying a big mysql database with only read privileges, and I'd like to set some slow query results to a variable, 'foo', so I can use them again in other queries. I get, ERROR 1193 (HY000): Unknown system variable '$foo' when I enter: set $foo := (select * from table1 join table2 where bar = 0 group by id); Is there a way to do this with variables, since I don't have privileges to create temporary tables?

  Read the article

• What Mysql query will return this result?

  - by Lost_in_code

  I have two tables A,B which are related to each other (simplified): A: +-------+---------+ | id | type | +-------+---------+ | 1 | apple | | 2 | orange | | 3 | banana | +-------+---------+ B: +-------+---------+-----------+ | id | a_id | rank | +-------+---------+-----------+ | 1 | 1 | 0.0 | | 2 | 1 | 7.7 | | 3 | 2 | 3.3 | | 4 | 2 | 8.8 | | 5 | 2 | 1.1 | | 6 | 3 | 3.3 | | 7 | 3 | 5.5 | | 8 | 1 | 9.5 | +-------+---------+-----------+ What mysql query will return the following result? Result +-------+---------+-----------+ | id | type | rank | +-------+---------+-----------+ | 1 | apple | 9.5 | | 2 | orange | 1.1 | | 3 | banana | 5.5 | +-------+---------+-----------+

  Read the article

• Warning: sqlite_query() [function.sqlite-query]: attempt to write a readonly database

  - by Surya sasidhar

  The error-Warning: sqlite_query() [function.sqlite-query]: attempt to write a readonly database is coming whenever i try to insert values into a sqllite 1.1 database thru php program. php version is 5.2.

  Read the article

• Help with query in Microsoft Access

  - by Gold

  I have 2 tables: Table A: code | name Table B: barcode | name Table B has full barcode and name, Table A has only code. I need to run update query that fill name in Table A. I tried something like: update A set name = (select top 1 Name from B where B.Code = mid(A.Barcode,1,8)) but it doesn't work.

  Read the article

• SQL Query to return both distinct and total logins from a login table in sql2005

  - by Prescott

  Hey all, I have a table Logins { Id, AccessTime }, I'd like to write a query that returns 3 columns, Total Logins during a time period, Unique Logins for a time period, and the Id of the user. I know I could do this with two passes and a join, is there a better way to do it in a single pass? Thanks, ~P

  Read the article

• How to match "input" and "select" elements in jQuery with 1 query

  - by MarkL

  re, I have a simple query that works: $("#test fieldset input").each(function() { }) However, I want to select "input" and "select" elements without having to write 2 "each" queries. Is this possible? thanks.

  Read the article

< Previous Page | 144 145 146 147 148 149 150 151 152 153 154 155  | Next Page >