Search Results

Search found 6988 results on 280 pages for 'if else statement'.

Page 135/280 | < Previous Page | 131 132 133 134 135 136 137 138 139 140 141 142  | Next Page >

• 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

• How to output items in Order in MySQL?

  - by RailsRor

  I have a column called "menu_order" which has no default value. When I select the contents of this column using the following select statement: SELECT * FROM categories ORDER BY menu_order ASC It lists the category items that have nothing as their menu order first and then the one's that have 1's and 2's and 3's. Is there any way to prevent SQL from take nothing to come before numbers when I am trying to list things in order? So for example, if I have: cat_name | menu_order ---------------------- Lunch | 1 Dinner | And I perform my query, the output should be: Lunch Dinner Not: Dinner Lunch

  Read the article

• How to construct these HQL statements

  - by losintikfos

  Do anyone know how to construct these two SQL statement in HQL; SELECT MIN(id) FROM Books WHERE mid < ? OR mid =? SELECT SUM(noOfBooks) FROM Bookcount WHERE mId=128

  Read the article

• Unknown Column In Where Clause

  - by Corpo

  I have a simple query: SELECT u_name AS user_name FROM users WHERE user_name = "john"; I get "Unknown Column 'user_name' in where clause". Can I not refer to 'user_name' in other parts of the statement even after select 'u_name as user_name'?

  Read the article

• Why does this code sometimes throw a NullPointerException?

  - by Tiberiu Hajas

  Consider the following Java source: if( agents != null ) { for( Iterator iter = agents.keySet().iterator(); iter.hasNext(); ) { // Code that uses iter.next() ... // } } The agents is a HashMap. Why does the for statement sometimes throw a NullPointerException? Thank you.

  Read the article

• Switch case in where clause (sql server)

  - by user685565

  I want to use case in sql statement where clause but I have a problem as I want to create a where clause condition on the basis of some value and I want to set a not in clause values on the basis of it here is the query where am facing an issue WHERE CODE = 'x' and ID not in ( case when 'app'='A' then '570','592' when 'Q' then ID 592,90 else 592,90 END but its not syntax

  Read the article

• Need batch file code to replace filepath with cd-rom drive letter.

  - by user361726

  Here is the copy statement I have currently. I am looking to replace the F: with %cdrom% so that this script will work no matter what computer it is used on. XCOPY F:\*.* .\disk2\ /C /S /D /Y /I

  Read the article

• Display the Element ID

  - by Gokul

  I am using this statement alert(el.parent().next()); But I am getting [object] [object] as an alert. How do I display the ID of the element?

  Read the article

• AppendTo does not work as desired

  - by Gokul

  When I say, msg.appendTo(ele.parent().next()), the msg successfully gets appended to a <p> with class=foo How can I specify it explicitly in the statement? I tried msg.appendTo(ele.parent().next().find('.foo')); but it doesn't work

  Read the article

• Page Fault Interrupt Problems

  - by Vikas

  This is a statement referring to problem caused by page fault:(from Silberschatz 7th ed P-310 last para) 'We cant simply restart instructions when instruction modifies several different location Ex:when a instruction moves 256 bytes from source to dest and either src or dest straddles on page boundary , then,after a partial move, if a page fault occurs, 'we can't simply restart the instructions' My question is Why not? Simply restart the instruction again do the same copy after page is in. Is there any problem in it?

  Read the article

• Indexing one-dimensional numpy.array as matrix

  - by Alain

  I am trying to index a numpy.array with varying dimensions during runtime. To retrieve e.g. the first row of a n*m array a, you can simply do a[0,:] However, in case a happens to be a 1xn vector, this code above returns an index error: IndexError: too many indices As the code needs to be executed as efficiently as possible I don't want to introduce an if statement. Does anybody have a convenient solution that ideally doesn't involve changing any data structure types?

  Read the article

• Adding a Image to UITable View Cell

  - by Graeme

  Hi, I have a table in which I want a dynamic image to load in at the left-hand side. The table needs to use an IF statement to select the appropriate image from the "Resources" folder, and needs to be based upon [dog types]. The [dog types] is extracted from an RSS feed, and so the image in the table cell needs to match the each cell's [dog types] tag. I suspect I need to use - (UIImage *)imageForTypes:(NSString *)types { to do such a thing. Thanks.

  Read the article

• Jquery .text() call returns null?

  - by Alex

  Hey all, I'm practicing Jquery and I've written this simple Jquery statement: var someText = $("table tr td").text(); Should this not return all text of td elements found within tr's that are found within tables? How do I fix this? Currently when I run this, it says that table tr td is null, but I have a table on the page I'm testing on. Thanks!

  Read the article

• SSIS to copy data from one table to another, where not in destination table

  - by alex

  I'm in the process of creating an SSIS package on a server (server1) that looks at the data in a sql db on another site (server2) and copies relevant rows across. The SQL statement required is: SELECT * FROM server2.ordersTable WHERE OrderID Not In (SELECT OrderID FROM server1.ordersTable This selects data from server1 which isn't in the table on server2 (based on order id) I then need to insert the result into a table on server1 How would I approach this? What components do I need etc...?

  Read the article

• PHP function, return by value or by reference?

  - by Andree

  Hi there! When I use return statement in PHP, will the result be returned by value or by reference? Thanks! Andree.

  Read the article

• Why do I get an Enum constant reference cannot be qualified in a case label?

  - by maleki

  Why does the following code fail to compile while changing the case statement to case ENUM1: doSomeStuff(); works? public enum EnumType { ENUM1, ENUM2, ENUM3; void doSomeStuff() { switch(this) { case EnumType.ENUM1: doSomeStuff(); } } }

  Read the article

• What was the most stupid code mistake you have ever made?

  - by Ramesh

  What was the most stupid code mistake you have ever made that had great consequences, e.g. you were fired? For example, a friend of mine wrote a cycle with conditional statement for break that was never true, which caused one high-loaded site to hang up for the whole night.

  Read the article

• Escapeing values in PDO statements

  - by Pardoner

  Doesn't prepare() escape any quotes(') in a PDO statement? For some reason when I do this: $sql = "INSERT INTO sessions (id, name) VALUES (1,'O'brian')"; $query = $this->connection->prepare($sql); $query->execute(); I get this error: Could not insert record SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'brian'. How could this be if I'm using prepare()?

  Read the article

• How do I conditionally redirect the output of a command to /dev/null?

  - by Lawrence Johnston

  I have a script. I would like to give this script a quiet mode and a verbose mode. This is the equivalent of: if $verbose then redirect="> /dev/null" fi echo "Verbose mode enabled" $redirect # This doesn't work because the redirect isn't evaluated. I'd really like a better way of doing this than writing if-elses for every statement affected. eval could work, but has obvious side effects on other variables.

  Read the article

• Easy mysql question regarding primary keys and an insert

  - by MPX

  In mysql, how do I get the primary key used for an insert operation, when it is autoincrementing. Basically, i want the new autoincremented value to be returned when the statement completes. Thanks!

  Read the article

• iPhone time comparison

  - by Rob

  I am trying to figure out how to create an 'if' statement that uses a time value as a condition. For example: if (time <= 10:00) { score = 3; } else if (time <= 20:00) { score = 5; } else { score = 9; } I know that a string of "5:23" cannot be compared this way but I don't think I can just turn a string value like that directly into an integer. Any thoughts?

  Read the article

• Is the Sleep operation no longer used in VBscript?

  - by Cheesus Toast

  The "Sleep" command as stated in many places over the internet (including here on this forum) DOES NOT WORK. Is it now an obsolete command? I am writing the VBScript code like this: sub button1_onclick() Wscript.Sleep 1000 div1.innerHTML = textbox1.value end sub It should wait 1 second and then execute that simple command. This is an utterly simple statement but it does not work. Plain and simple. It comes up with an error every time saying: Object Required: 'Wscript'

  Read the article

• C++ header file and function declaration ending in "= 0"

  - by Adam

  hi, I have the following code inside the .h file and I'm not sure what does the assignment statement do and how is it called properly? virtual void yield() = 0; I thought that the function returns a value of 0 by default but since this function returns void I am a little bit confused. Can anyone comment on this and maybe say how can I refer to this assignment, I mean how is it called in C++ jargon? Thanks.

  Read the article

• What is the difference between JOIN, Inner Join, Left Join and Outer Join.

  - by theband

  What is the difference between JOIN, Inner Join, Left Join and Outer Join. Let me put you on what i know. JOIN Statement is used to join two tables and fetch the result.

  Read the article

• What is the use of "Partition" keyword in MySQL?

  - by chandru_cp

  As I am a MySQL newbie. What does PARTITION mean in this MySQL statement? CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', separated DATE NOT NULL DEFAULT '9999-12-31', job_code INT NOT NULL, store_id INT NOT NULL ) PARTITION BY RANGE (store_id) ( PARTITION p0 VALUES LESS THAN (6), PARTITION p1 VALUES LESS THAN (11), PARTITION p2 VALUES LESS THAN (16), PARTITION p3 VALUES LESS THAN (21) );

  Read the article

< Previous Page | 131 132 133 134 135 136 137 138 139 140 141 142  | Next Page >