Search Results

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

Page 292/1146 | < Previous Page | 288 289 290 291 292 293 294 295 296 297 298 299  | Next Page >

• MySQL Order By Problem, Why is 1000 being seen as Smaller than 2?

  - by Jack

  I have a strange problem, I am trying to order the output of a set of records by a field called displayOrder. Now even though record A has a displayOrder of 2 and record B has a displayOrder of 1000, record B still shows up before record A. Here's my select statement: SELECT * FROM items ORDER BY displayOrder ASC It works fine until I have a record greater than 9, then 10, 11, 12, etc are seen as smaller than 2, 3, 4 because they start with the number 1. Any way to fox this?

  Read the article

• String.IsNullOrEmpty() Check for Space

  - by Asim Sajjad

  What does below statement return String.IsNullOrEmpty(" ") is IsNullOrEmpty will need to pass by applying Trim() function of string. String.IsNullOrEmpty(" ".Trim()) or it will trim the string inside ?

  Read the article

• Is it standard behavior for this code to throw a NullPointerException?

  - by Eric

  I've had a big problem in some library code, which I've pinned down to a single statement: System.out.println((String) null); Ok, the code doesn't actually look like that, but it certainly calls println with a null argument. Doing this causes my whole applicaio to throw an unexpected NullPointerException. In general, should println throw this exception under that circumstance, or is this non-standard behavior due to a poor implementation of the out instance?

  Read the article

• How do I combine two rows of same part, but add quantities?

  - by Tom

  I have table "PICKITEM" PARTID QTY A 1 A 3 B 11 C 8 D 5 D 3 I need a select statement that will return one line for like PARTIDs and add the qty field to together, yet also return the rest of the lines in the table as is PARTID QTY A 4 B 11 C 8 D 8 Probably a newb question, but I am new to SQL syntax and queries. Any help in getting me on the right path would be appreciated!

  Read the article

• SEHException External component has thrown exception in VS2005

  - by sdz

  Hello! I imported inpout32.dll to the program and tried to do the parallel port interfacing for outputting and inputting through the port. But when the execution reaches the statement PortAccess.Output(888,0); it throws the above exception. The PortAccess class is defined in the inpout32.dll file which i downloaded from www.logix4u.net. Can anyone help me with this?

  Read the article

• C++ switch table performance

  - by asap

  Does the time taken by a switch statement (or jump table in compiled form) to "decide" where to jump rise by the number of casees it contains?

  Read the article

• function_exists php

  - by user527800

  Hi all I'm trying to write a function that could receive it's second arg a name of a function. In order to validate function's name (that will be used in an eval statement) I use function_exists such as: if(function_exists($type)){ $toEval= $type.'(\''.$file.'\');'; }else{ But if the arg sent is include or require (with 'once' variations) this code fails (function_exists returns false). How could this be fixed? Thanks, Alex

  Read the article

• Fastest way to add prefix to array keys?

  - by Kirzilla

  Hello, What is the fastes way to add string prefixes to array keys? was $array = array( '1' => 'val1', '2' => 'val2', ); needed $array = array( 'prefix1' => 'val1', 'prefix2' => 'val2', ); According to http://www.phpbench.com/ (see Modify Loop) I should use "for" statement, but probably there is more elegant way? Thank you.

  Read the article

• django update object

  - by John

  Hi, How do I run an update and select statement on the same queryset rather than having to do 2 querys, ones to select the object and one to update the object? the sql would be something like update my_table set field_1 = 'some value' where pk_field = some_value Thanks

  Read the article

• Catching TransactionRolledbackLocalException in Java

  - by user271858

  I receive javax.ejb.TransactionRolledbackLocalException in Websphere 7 from the container and I wonder how is it possible to catch this exception? I have a timeout set in Websphere and get this message after this time. I run session beans. I am trying to find what SQl statement was the cause of this exception. Where can i find that?

  Read the article

• SQL like conditions

  - by garpunkal

  Hi, What does this mean within my like statement? LIKE '%[ .,!?]' + keyword + '[ .,!?]%' I'm trying to get something, that will match for whole words

  Read the article

• In C#, how do I know which exceptions to catch?

  - by user327918

  I've gotten in the habit of using a general catch statement and I handle those exceptions in a general manner. Is this bad practice? If so, how do I know which specific exceptions could be thrown and which ones do I catch?

  Read the article

• Determining whether jQuery doesn't find any element

  - by Bardock

  Hi, I'm using jQuery's selectors, especially id selector: $("#elementId")... How should I determine whether jQuery has found the element or not? Even If the element with the specified id doesn't exist the next statement give me: [object Object] alert($("#idThatDoesnotexist"));

  Read the article

• How to check the existence of a row in SQLite with Python?

  - by fx

  I have the cursor with the query statement as follows: cursor.execute("select rowid from components where name = ?", (name,)) I want to check for the existence of the components: name and return to a python variable. How do I do that?

  Read the article

• unprotected access to member in property get

  - by Lenik

  I have a property public ObservableCollection<string> Name { get { return _nameCache; } } _nameCache is updated by multiple threads in other class methods. The updates are guarded by a lock. The question is: should I use the same lock around my return statement? Will not using a lock lead to a race condition?

  Read the article

• Doubt in Conditional inclusion

  - by Philando Gullible

  This is actually extracted from my module (Pre-processor in C) The conditional expression could contain any C operator except for the assignment operators,increment, and decrement operators. I am not sure if I am getting this statement or not since I tried using this and it worked.Also for other manipulation a probable work around would be to simply declare macro or function inside the conditional expression,something like this to be precise. Also I don't understand what is the rationale behind this rule. Could somebody explain? Thanks

  Read the article

• Exclude some ids from result in Rails ActiveRecord

  - by Beer Brother

  I have following statement for query articles from some sections Article.all(:joins => :sections, :conditions => { :sections =>{ :id => [3, 4, 6, 7, 8, 9] }, :id_not_in => @some_ids }, :limit => 4) Variable @some_ids is array with ids of articles wich must be excluded from result.

  Read the article

• Using 'this': where is good and where is not [closed]

  - by abatishchev

  I like to use 'this' statement for all non-local variables: for properties, for class variables, etc. I do this for code easy reading, easy understanding where from this variable has got. object someVar; object SomeProperty { get; set } void SomeMethod(object arg1, object arg2) { this.SomeProperty = arg1; this.someVar = arg2; } How do you think, what is proper way to use 'this'?

  Read the article

• C# - Check a bool for a value and then flip it

  - by halivingston

  for (int i = 0; i < X; i++) myitem = (checkedDB) ? dirtyItem : cleanItem; I wanted to know if there's a way of flipping checkedDB in the same statement, i.e. the next iteration checkedDB is the opposite of it's value, so like XORing.

  Read the article

• Randomly selecting a limited number of records with two conditions in MySQL

  - by andyashton

  I have a MySQL table with a column called "priority". The column can have two values: high or low. I want to select 8 records from the table at random, but I want 6 of them to be high priority, and 2 of them to be low priority. If possibly, I would like to do it in one SQL statement. Is there any way to do two LIMITS in one query based on this kind of criteria?

  Read the article

• What is wrong in this code?

  - by nepc

  The is a very simple echo statement but I can't solve it? echo '"What is your name?'";

  Read the article

• how to run a query from the VBA Editor window in ACCESS?

  - by every_answer_gets_a_point

  i would like to do something like this: DoCmd.OpenQuery "select * from some_table;" how would i do this? please keep in mind i don't want create a new query, save it, and run it, i just want to type the select statement in the vba code and run it.

  Read the article

• How to return a value based on the type of the generic T

  - by Blankman

  I have a method like: public T Get<T>(string key) { } Now say I want to return "hello" if the type is a string, and 110011 if it is type int. how can I do that? typeof(T) doesn't seem to work. I ideally want to do a switch statement, and return something based on the Type of the generic (string/int/long/etc). Is this possible?

  Read the article

• MySQL: How to do a conditional update?

  - by Tom

  Hi, I'm trying to a create an update statement along the following lines: TABLE car: id | owner_id | type | status An owner can have multiple cars. UPDATE car c SET c.type = 1 WHERE c.owner_id IN ($ids) AND c.status = [1 IF IT EXISTS, ELSE 0] $ids is reasonably small (under 50 values). It seems simple but I can't seem to get my head around it because I can't use a SELECT subquery with an UPDATE to the same table. Anyone? Thanks

  Read the article

• TSQL - MSSQL 2008 add a column and update it in same stored procedure

  - by TortTupper

  if I have a stored procedure say create procure w AS ALTER TABLE t ADD x char(1) UPDATE t set x =1 Even when it lets me create that stored procedure (if I create it when x exists), when it runs, there is an error on the UPDATE statement because column x doesn't exist. What's the conventional way to deal with this, it must come up all the time? I can work around it by putting the UPDATE inside EXEC, is there another/better way? Thanks

  Read the article

< Previous Page | 288 289 290 291 292 293 294 295 296 297 298 299  | Next Page >