Search Results

Search found 7116 results on 285 pages for 'nested queries'.

Page 146/285 | < Previous Page | 142 143 144 145 146 147 148 149 150 151 152 153  | Next Page >

• Data access layer using Linq to SQL

  - by Andrei Tanasescu

  I am building a c# - linq - sql server winforms/asp.net application, accessing a database. I would like my business logic layer to be easily testable, and that means not littering it with Linq database queries everywhere. What design patterns/ best practices are available for the following use cases - inserting/updating a new object - searching for an object - loading a bunch of related data into a sort of "presentation" object that could be displayed by various views ?

  Read the article

• memcached vs. internal caching in PHP?

  - by waitinforatrain

  Hey, I'm working on some old(ish) software in PHP that maintains a $cache array to reduce the number of SQL queries. I was thinking of just putting memcached in its place and I'm wondering whether or not to get rid of the internal caching. Would there still be a worthwihle performance increase if I keep the internal caching, or would memcached suffice?

  Read the article

• PHP+MySQL Update TimeStamp and get NOW() back

  - by Ben

  Is it possible to merge these two mysql queries into one? I want to get NOW() returned to a php variable. mysql_query('INSERT INTO translate (IDRef, RefType, Lang, Text, LastChangeTS) VALUES ('.$id.', \''.$reftype.'\', \''.$lang.'\', \''.$text.'\', NOW()) ON DUPLICATE KEY UPDATE text = \''.$text.'\', LastChangeTS = NOW()'); mysql_query('SELECT LastChangeTS FROM translate WHERE IDRef = '.$id.' AND RefType = \''.$reftype.'\' AND Lang = \''.$lang.'\'');

  Read the article

• How to join two query in SQL (Oracle)

  - by MAHESH A SONI

  How can I join these queries? SELECT RCTDT, SUM(RCTAMOUNT), COUNT(RCTAMOUNT) FROM RECEIPTS4 WHERE RCTDT BETWEEN '01-nov-2009' AND '30-nov-2009' AND RCTTYPE='CA' AND RCTAMOUNT>0 GROUP BY RCTDT --- SELECT RCTDT, SUM(RCTAMOUNT), COUNT(RCTAMOUNT) FROM RECEIPTS4 WHERE RCTDT BETWEEN '01-nov-2009' AND '30-nov-2009' AND RCTTYPE='CQ' AND RCTAMOUNT>0 GROUP BY RCTDT

  Read the article

• Optimize SELECT DISTINCT CONCAT query in MySQL

  - by L. Cosio

  Hello! I'm running this query: SELECT DISTINCT CONCAT(ALFA_CLAVE, FECHA_NACI) FROM listado GROUP BY ALFA_CLAVE HAVING count(CONCAT(ALFA_CLAVE, FECHA_NACI)) > 1 Is there any way to optimize it? Queries are taking 2-3 hours on a table with 850,000 rows. Adding an index to ALFA_CLAVE and FECHA_NACI would work? Thanks in advanced

  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

• how to intersect two "selects" and then put another condition for the result

  - by Shadi

  Hi, I want to intersect two "select" queries and then put another condition for the whole result. I mean: (select ... intersect select ...) where ... is it possible? Thanks.

  Read the article

• Ado.net Entities + get table by T

  - by john

  Hi all Is it posible to get a table to do queries on with Ado.net Entities? In linq ou could do DataContext.GetTable.Where...... Thanks in advance

  Read the article

• Need help to understand :source option of has_one/has_many through of Rails

  - by Tri Vuong

  Hi Please help me in understanding the :source option of has_one/has_many through association. The Rails api explanation makes very little sense to me "Specifies the source association name used by has_many :through queries. Only use it if the name cannot be inferred from the association. has_many :subscribers, :through = :subscriptions will look for either :subscribers or :subscriber on Subscription, unless a :source is given. " Thanks.

  Read the article

• Jquery Quicksearch plugin issue with dynamic pages

  - by TheDarkMist

  Quicksearch is really cool... but it has a usability issue that makes it behave weird. A lot of users presses enter after inserting a string so the page is reloaded with no parameters and the queries are destroyed. look at that: http://www.parksmania.it/parco_list.php?rid=1 Adding $('form#filtroRapido').submit(function () { return false; }); doesn't work! Has someone already solved this?

  Read the article

• Does the for foreach construct in java create a hard or soft copy?

  - by Doug

  Say I have the following piece of java code ArrayList<Double> myList = new Double[100]; for (Double x : myList) x = randomDouble(); Does this actually modify myList or just the dummy variable? I realize I should just try this code segment out, but I think this is the sort of thing I should be able to google or search for on this site, and several queries so far have turned up nothing useful.

  Read the article

• Add table to SPDatabase object

  - by Ramnik

  I have created a database using a SPDatabase class. How can i add a table to it? and how to execute SQL queries in this database? Thanx....

  Read the article

• Is CodeIgniter's ActiveRecord resource intensive?

  - by iamdadude

  I’m coding an application with server resources in mind, so I don’t want to use too much so that this application scales in the future. I don’t mind writing my own queries. So, is ActiveRecord resource intensive for my application? Or does it not make a difference? Thanks!

  Read the article

• SQL Math in Excel VBA

  - by Scott

  Excel seems to have a problem with doing math in SQL queries. SELECT ( SELECT sum(column) FROM table1 ) + ( SELECT sum(column) FROM table2 ) AS total This technique works completely fine in ASP and ASP.NET. Has anyone had success doing this in Excel VBA? (My database engine is SQL Server 2000.)

  Read the article

• where to get this Java.exe file for ORacle installation

  - by vas

  Hi just installed oracle 11g and tried to start the "Oracle SQL developer" so as to start writing queries. Its asking me Enter the full pathname for the java.exe file . Where do i find this. I did a global search for java.exe and am sure did not got some oracle related pdf files. Also my Oracle is installed out of users/vas

  Read the article

• php check if record exist.

  - by user329394

  hi all, i found this to check if file exist. is there a way how to check if record exist first? php.net i want to check if record exist first, if exist then do update, else do insert. i do understand how to make a queries for select and insert and i dont have problem with it. if(record exist) { update query} else { insert query}

  Read the article

• PHP Doctrine: filtering data which is already loaded?

  - by ropstah

  I'm new to Doctrine and ActiveRecord. How should I filter a table after it has been loaded? (i suppose this is preferred over sending multiple queries?) Is this 'good' or 'bad'? class UserTable extends Doctrine_Table { function filterByGroup($group) { $ut = new UserTable(); foreach($this as $u) { if($u->group = $group) $ut->add($u); } return $ut; } }

  Read the article

• Java connecting to Http which method to use?

  - by jax

  I have been looking around at different ways to connect to URLs and there seem to be a few. My requirements are to do POST and GET queries on a URL and retrieve the result. I have seen URL class DefaultHttpClient class And there were some others in apache commons which method is best?

  Read the article

• i want to copy the output of unix and sqlplus into a file .

  - by randeepsp

  I am using Solaris. I have to log into sql plus and run some queries, which give a huge result set. I want to copy all that into a file. Is there any command for it in unix or sqlplus ?

  Read the article

• Need Help Writing SQL query

  - by user204588

  I have two product tables Product1 and Product2. There is a one 2 one mapping on the field ProductId. What I want is to get all the product ids where the Product2.Exported field is false AND Where the product ids that are in Product1 but not in Product2 table. Right now I have two queries that I'm trying to mash into one. SELECT ProductId FROM Product1 WHERE ProductId NOT IN(Select ProductId From Product2) SELECT ProductId FROM Product2 WHERE Exported = 0

  Read the article

• Can't stop Hibernate from writing log to console (log4j.properties is ok)

  - by blackliteon

  I've already set <property name="show_sql">false</property> & disable all messages in log4j.properties But Hibernate shit to console with all queries & statements.

  Read the article

• ADO.net Data Services - Querying

  - by Prajuvan

  Just I started learning ADO.NET Data Services. Some Pages show the querying like (sample) http://localhost:1705/ServiceExample/SomeService.svc/Persons(1)/Name http://localhost:1705/ServiceExample/SomeService.svc/Persons(1)/Name/$value Is it XPath or XQuery? Where can i get complete rules for forming such queries with examples? Thanks in advance.

  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

• Good book for sql

  - by Uday

  I always considered database as a storage . but never thought it can be used for querying across tables etc. Which is a good book for sql for a developer. not just the syntax. How to write a query in different ways How internally queries are executed.etc especially related to microsoft sql server

  Read the article

• Sample code for POST + cookie?

  - by OverTheRainbow

  Hello, I've been googling for some VB.Net code to authenticate to a web server with the POST method, receive a session ID in a cookie, and then send this cookie along with all GET queries... but all I found is half-working code or C# code, ie. difficult to use for a VB.Net newbie. Would someone have some code handy or some pointer that I could use to get started? Thank you.

  Read the article

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