Search Results

Search found 6988 results on 280 pages for 'with statement'.

Page 19/280 | < Previous Page | 15 16 17 18 19 20 21 22 23 24 25 26  | Next Page >

• using count and group by at the same select statement

  - by Stavros

  Hello, I have an sql select query that has a group by. I want to count all the records after the group by statement. Is there a way for this directly from sql? For example, having a table with users I want to select the different towns and the total number of users select town, count(*) from user group by town I want to have a column with all the towns and another with the number of users in all rows.

  Read the article

• Java: JPQL select statement

  - by bguiz

  select x from X x where x.a.id = :a_id -- Always 0 objects selected Why does the above JPQL statement not work, but the one below work? select a from A a where a.id = :a_id -- a_obj select x from X x where x.a = :a_obj -- Always correct number of objects selected Neither query throws an exception during execution, but a different number of results are obtained. Thanks

  Read the article

• Switch statements: do you need the last break? (Javascript mainly)

  - by Jon Raasch

  When using a switch() statement, you add break; in between separate case: declarations. But what about the last one? Normally I just leave it off, but I'm wondering if this has some performance implication I'm not thinking about? I've been wondering about this for a while and don't see it asked elsewhere on Stack-O, but sorry if I missed it. I'm mainly asking this question regarding Javascript, although I'm guessing the answer will apply to all switch() statements.

  Read the article

• Should a function have only one return statement?

  - by David

  Are there good reasons why it's a better practice to have only one return statement in a function? Or is it okay to return from a function as soon as it is logically correct to do so, meaning there may be many return statements in the function?

  Read the article

• The order of a SQL Select statement without Order By clause

  - by Yousui

  As I know, from the relational database theory, a select statement without an order by clause should be considered has not particular order. But actually in SQL Server and Oracle (I've tested on those 2 platforms), if I query from a table without an order by clause multiple times, I always get the results in the same order. Does this behavior can be relied on? Anyone can help to explain a little? Thanks!

  Read the article

• sql statement to Expression tree

  - by Joo Park

  I'm wondering how one would translate a sql string to an expression tree. Currently, in Linq to SQL, the expression tree is translated to a sql statement. How does on go the other way? How would you translate select * from books where bookname like '%The%' and year > 2008 into an expression tree in c#?

  Read the article

• how to create a dynamic sql statement w/ python and mysqldb

  - by Elias Bachaalany

  I have the following code: def sql_exec(self, sql_stmt, args = tuple()): """ Executes an SQL statement and returns a cursor. An SQL exception might be raised on error @return: SQL cursor object """ cursor = self.conn.cursor() if self.__debug_sql: try: print "sql_exec: " % (sql_stmt % args) except: print "sql_exec: " % sql_stmt cursor.execute(sql_stmt, args) return cursor def test(self, limit = 0): result = sql_exec(""" SELECT * FROM table """ + ("LIMIT %s" if limit else ""), (limit, )) while True: row = result.fetchone() if not row: break print row result.close() How can I nicely write test() so it works with or without 'limit' without having to write two queries?

  Read the article

• c# Is this a valid conditional Statement?

  - by Pandiya Chendur

  I have two methods A and B only after the success of two methods i have to insert into database... So is this a valid conditional Statement in c#? if(A() && B()) { //insert into db } After the execution of method A i have to execute B If both are successful i have to insert...

  Read the article

• jquery if statement animate back

  - by user295292

  how do i add a if statement when the right image is at +400px then animate back to -400px... when hovering the right image? $('#left img').mouseenter(function() { $('#right img').animate({ left: '+=400px' }, 700); }); $('#right img').mouseenter(function() { $('#left img').animate({ left: '-=400px' }, 700); }); something similar to this - http://www.hyundaiusa.com/ (the two main images on the site)

  Read the article

• SQL statement to grab table names, views, and stored procs, order by schema

  - by sunpech

  Is there a SQL statement that will list the names of all the tables, views, and stored procs from MS SQL Server database, ordered by schema name? I would like to generate an Excel spreadsheet from this list with the columns: schema, type (table, view, stored proc), and name.

  Read the article

• returning statement created by mysqli_stmt_bind_param

  - by bigmac

  I am using mysqli_stmt_bind_param() to create an INSERT statement. For some reason I am getting an error. I used mysqli_error() to see the error message, but it's not especially useful. Is there a way to just see what query is actually being executed?

  Read the article

• Why is the ( ) mandatory in the SQL statement select * from gifts INNER JOIN sentgifts using (giftID

  - by Jian Lin

  Why is the ( ) mandatory in the SQL statement select * from gifts INNER JOIN sentgifts using (giftID); ? The ( ) usually is for specifying grouping of something. But in this case, are we supposed to be able to use 2 or more field names... in the example above, it can be all clear that it is 1 field, is it just that the parser is not made to bypass the ( ) when it is all clear? (such as in the language Ruby).

  Read the article

• mysql statement with nested SELECT - how to improve performance

  - by ernie

  This statement appears inefficient because only one one out of 10 records are selected and only 1 of 100 entries contain comments. What can I do to improve it ? $query = "SELECT A,B,C, (SELECT COUNT(*) FROM comments WHERE comments.nid = header_file.nid) as my_comment_count FROM header_file Where A = 'admin' " edit: I want header records even if no comments are found.

  Read the article

• mysql statement with inner SELECT - how to improve performance

  - by ernie

  This statement appears inefficient because only one one out of 10 records are selected and only a of 100 entries contain comments. What can I do to improve it ? $query = "SELECT A,B,C, (SELECT COUNT(*) FROM comments WHERE comments.nid = header_file.nid) as my_comment_count FROM header_file Where A = 'admin' "

  Read the article

• Is using the break statement bad practice?

  - by Lchi

  I've been told by professors and peers at my university that using the break statement is bad practice, but through my coursework haven't come up with a great reason why. Those who claim that it is bad say that it's a "get out of jail free card" and that you can always avoid using it. My guesses for why its considered bad would be that you could possibly skip some cleanup code after the break, or similarly exit some control structure in an inconsistent state. Is there any reason why using break is(n't) bad practice?

  Read the article

• iPhone Game Having a statement checked every 50 points

  - by user298261

  Hello! I've run into a little hurdle and wanted to see if somebody could help me! I want to write an algorithm for an if statement that says: if (for every 50 points) { //do something } I thought += 50 would do the trick, but nope. Any ideas? Thanks!

  Read the article

• VB.NET Select...Case Statement Equivalent in C#

  - by Alex Essilfie

  I just started using C# and I've got a couple of issues. Is there any way to code the C# equivalent of the VB.NET Select statement like the following? Select Object.Name.ToString() Case "Name1" 'Do something Case "Name2" 'Do something else Case Else 'Do the default action End Select Any help would be greatly appreciated.

  Read the article

• "with" scope and properties with square bracket notation

  - by Anurag

  Is it possible to access object properties that can only be accessed with the square bracket notation when inside a "with" statement. Example: var o = { "bad:property": 1, "goodProperty": 2 }; with(o) { console.log(goodProperty); // works awesome console.log(???) // how to access "bad:property"? }

  Read the article

• IF Statement in VBA

  - by Edmond

  How would I code a IF statement if I was trying to say IF the date today is equal to Monday THEN Have Outlook prepare 3 emails ELSE Have Outlook prepare 2 emails END IF I just need help setting up the "IF the date today is equal to Monday." How would that code look.

  Read the article

• IF statement error

  - by Jasl

  I have the following columns in TableA TableA Column1 varchar Column2 int Column3 bit I am using this statement IF Column3 = 0 SELECT Column1, Column2 FROM TableA WHERE Column2 > 200 ELSE SELECT Column1, Column2 FROM TableA WHERE Column2 < 200 But the statment does not compile. It says Invalid Column Name 'Column3'

  Read the article

• Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing

  - by Paresh

  I am getting the error from the application as following with SQL server 2005 "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0" How can i find the stage where this error raised? how can i found the missing transaction or the stored procedure where it is not committ or rollback?

  Read the article

• jquery if else, why does not work?

  - by Cesar Lopez

  In the following function it goes through the if and the else, why is that? function test(){ $(".notEmpty").each(function() { if($(this).val() === ""){ alert("Empty Fields!!"); return; } else{ AddRow_OnButtonClick('tblMedicationDetail',6); } }); } Is there any if and else statement on jquery that I am not aware of? Thanks

  Read the article

• multiple params in a mysql statement

  - by Kaartz

  i use this statement for a single where condition ('SELECT * FROM users WHERE id = ?', 1) if I want to check two conditions, how would I do that ('SELECT * FROM users WHERE id=? AND age=?', 1,23)- is this correct?

  Read the article

• Ternary operator in if-statement?

  - by Pindatjuh

  I've written the following if-statement in Java: if(methodName.equals("set" + this.name) || isBoolean() ? methodName.equals("is" + this.name) : methodName.equals("get" + this.name)) { ... } Is this a good practice to write such expressions in if, to separate state from condition? And can this expression be simplified?

  Read the article

• convert a sql statement to class?

  - by walter

  Is there a tool or code to convert a sql statement to class? Something like: Dim sqlText = "SELECT CustomerID, Name, Address, City FROM dbo.Customer WHERE CustomerID = 1" Dim obj As New ***SqlStatementTool***(sqlText) obj.GetTables() 'Will Return Tables in sqlText obj.GetWheres() 'Will Return conditions in sqltext obj.GetParameters() 'will return parameters in sqltext

  Read the article

< Previous Page | 15 16 17 18 19 20 21 22 23 24 25 26  | Next Page >