Search Results

Search found 33538 results on 1342 pages for 'select query'.

Page 239/1342 | < Previous Page | 235 236 237 238 239 240 241 242 243 244 245 246  | Next Page >

• 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

• 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

• 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

• 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

• Equivalent lambda syntax for linq query

  - by ilias

  Hi, I am having a mind-freeze here, but I cant seem to find the equivalent lambda syntax for - string[] a = {"a","b","c"}; string[] b = {"1","2","3"}; var x = from a1 in a from b1 in b select new{a1, b1};

  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

• How to translate this query:

  - by xRobot

  How can I translate this 2 queries in postgresql ? : . CREATE TABLE example ( id int(10) unsigned NOT NULL auto_increment, from varchar(255) NOT NULL default '0', message text NOT NULL, lastactivity timestamp NULL default '0000-00-00 00:00:00', read int(10) unsigned NOT NULL, PRIMARY KEY (id), KEY from (from) ) DEFAULT CHARSET=utf8; . SELECT * FROM table_1 LEFT OUTER JOIN table_2 ON ( table_1.id = table_2.id ) WHERE (table_1.lastactivity > NOW()-100);

  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

• HQL query to join 2 tables with the same key

  - by kawtousse

  Hi everyone Iam trying to this in HQL: select A.a A.a1, B.b,B.b1 from A,B where A.x=B.x; It is simple to realize the join with sql but when returninig in HQL I find a problem. would you please give me the HQL syntax for the join Thanks for help.

  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

• 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

• 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

• 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

• Zend Framework Multiple Table Query

  - by Jeff

  I am looking to execute this statement via Zend Framework. As I understand it, I can use Zend_Db_Select. Is it possible to use Zend_Db_Table? Three tables: classes, students, and class_students select classes.name, students.student_id, students.fname, students.lname from students, classes, class_students where class_students.student_id=students.student_id AND class_students.class_id=classes.class_id;

  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

• how to excute a simple query use sqlapi++ with oracle

  - by areslp

  here is the code: cmd1.setCommandText("select * from lp.human_tb_meta_sex"); cmd1.Execute(); while (cmd1.FetchNext()) { SAString sas=cmd1.Field("id").asString(); cout<<"sas id:"< it gave me ORA-00932 error...I dont know why..?

  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

• 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

• 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

• 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

• OrderBy on children in a LINQ Query

  - by eka808

  Hello everybody I have a user entity who contains a one to many relationship with a role entity So with this linq expression : from user in USER_TABLE.Include("USERROLE_TABLE") order by user.Name select user I can get users with related roles as a child. My problem is that i want to get roles of each user ordered alphabetically. How can i do that ? I googled a lot and don't find anything Thank's by advance !

  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

• 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

< Previous Page | 235 236 237 238 239 240 241 242 243 244 245 246  | Next Page >