Search Results

Search found 40287 results on 1612 pages for 'try statement'.

Page 214/1612 | < Previous Page | 210 211 212 213 214 215 216 217 218 219 220 221  | Next Page >

• 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

• 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

• 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

• 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

• 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

• 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

• 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 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

• 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

• 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

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

  - 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

• Javascript switch vs. if...else if...else

  - by John Hartsock

  Guys I have a couple of questions: Is there a preformance difference in Javascript between a switch statement and an if...else if....else? If so why? Is the behavior of switch and if...else if...else different across browsers? (FireFox, IE, Chrome, Opera, Safari)

  Read the article

• if action class method throw exception where is the handler and how to get control after that....???

  - by rozer

  If action class method signature have throws statement and in that method any exceoption occurs then how the flow will move. then suppose we need to take contol of flow and want to show our jsp , what will be the steps please help out.....

  Read the article

• Handling macro redefinition without modifying .h files ... C / C++ language

  - by user310119

  Background: Let assume that I have two header files a.h and b.h. a.h contains: #define VAR 1 b.h contains: #define VAR 2 Note: The name of both of the macro is same. Let say I have some file myFile.c which includes both of the header files i.e. a.h and b.h. When I try to access VAR, I get a redefinition error of VAR. In order to resolve this problem, I inserted #ifndef VAR statement in both a.h and b.h files to prevent this error. a.h file becomes #ifndef VAR #define VAR 1 #endif b.h file becomes #ifndef VAR #define VAR 2 #endif Note: The header file can contain multiple macros, not just one macro. Problem: Let's assume that a.h and b.h files are obtained from third party library. These files don't contain #ifndef VAR statement. I am not allowed to change their header files. Can I resolve macro 'VAR' redefinition error in myFile.c or myFile.cpp file which uses VAR macro? I know I #undef VAR can be used to undefine a macro VAR. How can I selectively include VAR later in my program? i.e. on line 10 of myFile.c code I should be able to refer to VAR definition from a.h file, on line 15 of my code I should be able to refer to VAR from b.h file and on line 18 again I should be able to refer to VAR from a.h file. In short, am I able to do macro polymorphism ? Given a name of header file, it should refer to macro definition present in that file. I thought of using namespace trick to resolve an issue. Define first header file in namespace first and second header file in namespace second. I tried defining two namespaces. First namespace contains #include a.h and second namespace contains b.h. However, namespace trick does not work with macro. When I tried to access firstns::VAR, compiler reports an error message. Can you please suggest some way?

  Read the article

• How to log SQL output to text file on client from C#

  - by Rob Packwood

  I have a large auditing stored procedure that prints values and runs some SELECT statements. When running within SQL Management Studio we have the use select to display "Results to Text" so all of the SQL results and print statement display in one place. Now I need to have some C# code also call this auditing procedure at the end of the process and basically store all data that would be in the "Results to Text" window into a .txt file. How can this be done?

  Read the article

• want to extend from java.sql.ResultSet

  - by dora

  hi, i would like to create myRecordSet object that extends java.sql.ResultSet and to implement a method that returns UTC date from sql statement. how can i extend from java.sql.ResultSet, i need an example 10X

  Read the article

• Actual AccessDataSource Query With Replaced Parameters

  - by Steven

  I am getting an "Invalid SQL statement" error in my VB code. I have set several SelectQuery parameters. How can I get the actual query with the parameters replaced with actual values?

  Read the article

• Ternary operators in C#

  - by pm_2

  With the ternary operator, it is possible to do something like the following (assuming Func1() and Func2() return an int: int x = (x == y) ? Func1() : Func2(); However, is there any way to do the same thing, without returning a value? For example, something like (assuming Func1() and Func2() return void): (x == y) ? Func1() : Func2(); I realise this could be accomplished using an if statement, I just wondered if there was a way to do it like this.

  Read the article

• How I can set a column value for all my rows that already exist in the database with some sort of my

  - by zeckdude

  I want to set the value of the column 'character_hold' to 'no' for all my rows in my MYSQL database. Is there a SQL statement I can use in phpmyadmin to set them all to 'no'?

  Read the article

• Without width printing format in C

  - by yCalleecharan

  Hi, in C if I have a printf statement containing say "%.2f", it says that the precision is 2 digits after the decimal place. I haven't explicitly specify the width. I have two questions: Is this good programming practice?; Is without specifying the width means that the width of the field will get adjusted automatically when printing the number, irrespective of the number of digits it contains? Thanks a lot...

  Read the article

• Convert opacity to hex in Javascript

  - by John

  What would be the preferred way to convert opacity (0 - 1) to hex (00 - ff) in Javascript? My thoughts are to use an if statement to check if opacity is between 1 and 0.95 then use ff. Work my way down to 0.

  Read the article

• Query to get data from a main table

  - by Thu Thuy

  I have an Information table with 3 colums tableName/FieldName/Value and its data like this: TableName|FieldName | Value Films |DateSortie |NULL Films |Duree |NULL Films |CodeLangue |NULL Films |Documentaire |NULL Could you show me a SQL statement to put data into the Value Field, please! Note that I also have table Films and its fields like data in FieldName field of the Information table Thanks in advance TNT

  Read the article

• How do I pass the resulting files from one grep pass to another so that I only grep through the subs

  - by NSA

  Hello All, I want to be able to take the files I found with my first grep statement, something like this for example: grep -r Makefile * And then pass the files found in that pass of grep to a second grep with something like this for example: grep {files} '-lfoo' How do I do this? I know there must be a way. Thank you.

  Read the article

• mysql: what is a temporary table?

  - by every_answer_gets_a_point

  what is the purpose of a temporary table like in this statement? how is it different than a regular table? CREATE TEMPORARY TABLE tmptable SELECT A.* FROM batchinfo_2009 AS A, calibration_2009 AS B WHERE A.reporttime LIKE '%2010%' AND A.rowid = B.rowid;

  Read the article

< Previous Page | 210 211 212 213 214 215 216 217 218 219 220 221  | Next Page >