Search Results

Search found 28627 results on 1146 pages for 'case statement'.

Page 40/1146 | < Previous Page | 36 37 38 39 40 41 42 43 44 45 46 47  | Next Page >

• php URI troube with if statement,

  - by sea_1987

  I am running an if statement, that looks like this, if($this->uri->segment(1) !== 'search' || $this->uri->segment(1) !== 'employment') { //dome something } My problem is that first condition works, if the uri segment 1 equals search then the method do not run however if I on the page employment, and the first segment of the uri is employment then the condition still runs, why is this?

  Read the article

• Best practice regarding returning from using blocks

  - by abatishchev

  Which way is better practice: return a value from a method inside an using statement or declare a variable before, set it inside and return it after? public int Foo() { using(..) { return bar; } } or public int Foo() { var b = null; using(..) { b = bar; } return b; }

  Read the article

• Select statement always execute/select columns in order?

  - by Aseem Gautam

  Does all the columns in select statement gets selected one after another as listed? Declare @X, @Y SELECT @X = ColumnA*.25 + ColumnB*2.5, @Y = ColumnA*.5 + ColumnC*1.33, TOTAL = @X + @Y FROM SomeTable Is the above query safe to use? Will total always be selected after @X and @Y are calculated?

  Read the article

• If/Then in SQL Embedded in VBA

  - by Daniel

  I've got a string like this in my Excel VBA: strSQL = "SELECT * FROM Total WHERE (SimulationID = (" & TextBox1.Text & ") And Test1 = (" & Example & "))" However, sometimes Test will be 'is null', which makes the query And Example = is NULL How can I change it to add an if/then statement or something to make it say And Example is null when Example has a value of "is null"?

  Read the article

• Bourne: if statement testing exit status

  - by sixtyfootersdude

  What is the difference: if IsServerStarted ; then ... and if [ IsServerStarted -eq 0 ] ; then ... Seems to me that these two statements should be equivalent? Strangely the second statement is always true.

  Read the article

• Me.Invoke in VB.NET doesn't actually "Invoke" - threads stall on Invoke statement

  - by rwmnau

  I've got the following code: Public Delegate Sub SetStatusBarTextDelegate(ByVal StatusText As String) Private Sub SetStatusBarText(ByVal StatusText As String) If Me.InvokeRequired Then Me.Invoke(New SetStatusBarTextDelegate(AddressOf SetStatusBarText), StatusText) Else Me.labelScanningProgress.Text = StatusText End If End Sub The problem is that, when I call the "SetStatusBarText" sub from another thread, InvokeRequired is True (as it should be), but then my threads stall on the Me.Invoke statement - pausing execution shows them all just sitting there, not actually invoking anything. Any thoughts about why the threads seem to be afraid of the Invoke?

  Read the article

• SQL SELECT Statement

  - by mouthpiec

  I have a table with the following columns: id, teamA_id, teamB_id Will it be possible to write a SELECT statement that gives both teamA_id and teamB_id in the same column? EDIT: Consider this example From id, teamA_id, teamB_id 1, 21, 45 2, 34, 67 I need Teams 21 45 34 67

  Read the article

• If statement with form field select in rails

  - by Elliot

  I'm trying put an if statement directly into a select field in rails, with no success. Here is what I've tried: <%= f.select (:book_id,{ if @a!=1 "Harry Potter", 1, end if @b!=2 "Lord of the Rings", 2, end end %>` Any ideas?

  Read the article

• If-Statement checking vor a value between two others

  - by iFloh

  Is there a kind of "between" check I can use in an if-statement that verifies whether a given float value is between two others? Can I write something like if (floatConstA <= checkFloatValue < foatConstB) { or must I do this using AND/OR constructs?

  Read the article

• Using an object in an if statement... (Android)

  - by James Rattray

  I have an object variable Object test = Spinner.getSelectedItem(); -It gets the selected item from the Spinner (called spinner) and names the item 'test' I want to do an if statement related to that object e.g: 'if (test = "hello") { //do something }' But it appears not to work.... Can someone give me some help? -Do I have to use a different if? or convert the object to string etc.? Thanks alot... James

  Read the article

• SQL Select statement that includes a column that isn't in the database

  - by Cypher

  I'm trying to execute a SELECT statement that includes a column of a static string value. I've done this in Access, but never with raw SQL. Is this possible? Example: Name Status John Unpaid Terry Unpaid Joe Unpaid In the above example, the "Status" column doesn't exist in the database.

  Read the article

• Python: try statement single line

  - by Brant

  Is there a way in python to turn a try/except into a single line? something like... b = 'some variable' a = c | b #try statement goes here Where b is a declared variable and c is not... so c would throw an error and a would become b...

  Read the article

• SQL Join Statement

  - by mouthpiec

  Hi I have the following SQL SELECT statement SELECT bar_id, bar_name, town_name, advert_text FROM bar, towns, baradverts WHERE town_id = town_id_fk AND bar_id = bar_id_fk My problem is that since not every bar has an advert in table "baradverts", these bars are not coming up in the results. In other words I need a NULL for those bars that do not have an advert string.

  Read the article

• 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

• 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

< Previous Page | 36 37 38 39 40 41 42 43 44 45 46 47  | Next Page >