Search Results

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

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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• C++: Life span of temporary arguments?

  - by shoosh

  When creating a new instance of a MyClass as an argument to a function like so: class MyClass { MyClass(int a); }; myFunction(MyClass(42)); does the standard make any grantees on the timing of the destructor? Specifically, can I assume that the it is going to be called before the next statement after the call to myFunction() ?

  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

• Created query is not supported by my DB

  - by stacker

  I created an application using seam-gen. The created operation to search the DB ends with and exception (syntax error). The query has a where clause like this: lower(barcode0_.barcode_ean) like lower((?||'%')) limit ? Does hibnerate or seam create the where clause which my DB can't understand? Or is there a workaround for SQL statement related issues in seam?

  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

• 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

• Subclassing Cocoa means no subclass ivars in some cases?

  - by Michael

  The question is generally coming from self = [super init]. In case if I'm subclassing NSSomething and in my init's method self = [super init] returns object of different class, does it mean I am not able to have my very own ivars in my subclass, just because self will be pointing to different class? Appreciate if you could bring some examples if my statement is wrong.

  Read the article

• DELETE and ACCESS

  - by Alex

  Where is the error in this statement? query = "DELETE TOP 10 FROM table WHERE field LIKE \"something*\"" I get an error on the query sytax. Thanks.

  Read the article

• Clustered Index

  - by Charu

  Which type of index(clustered/non clustrered) should be used for Insert/Update/Delete statement in SQL Server. I know it creates an additional overhead but is it better in performance as comparison to non clustered index? Also which index should be use for Select statements in SQL Server?

  Read the article

• How can I remove the unique option from a column in MySQL ?

  - by Tom Nipravsky

  Hello, I have a field in my db called "user" which is unique. I would like to remove the "unique" option so I can have couple of users with the same nickname. Which sql statement should I execute to perform this action ? Thanks

  Read the article

• How do I add css to be loaded last in drupal?

  - by wamp

  drupal_add_css('override/files/style.css'); This kind of statement can't ensure the css is loaded last, how can I do the trick?

  Read the article

• insert values with different delimiter

  - by every_answer_gets_a_point

  i want to insert values into a table, with an INSERT INTO statement but i would like to use a different delimiter (not a comma) how do i do this?

  Read the article

• SQL Syntax for multiple conditions in the same field

  - by Jonathan

  I can't seem to find this in the mysql manual: How do you enter multiple conditions for the same field in a select statement? e.g.: SELECT * FROM table WHERE ID = '1, 2, 3, 4' Is there a way to do this without using this: SELECT * FROM table WHERE ID = '1' OR ID = '2' OR ID = '3' OR ID = '4'

  Read the article

• && operation in actionscript

  - by wcpro

  In the following code the line after the if statement gets run even when "BITMAP" is null. Why is this? public function get BitmapHeight () { if (_bitmapHeight == 0 && BITMAP != null) _bitmapHeight = BITMAP.bitmapData.height; return _bitmapHeight; }

  Read the article

• Display BLOB (image) through JSP

  - by jMarcel

  I have a code to show a chart o employees. The data (name, phone, photo etc) are stored in SQLServer and displayed through JSP. Showing the data is ok, except the image .jpg (stored in IMAGE=BLOB column). By the way, I've already got the image displayed (see code below), but I dont't know how to put it in the area defined in a .css (see code below, too), since the image got through the resultSet is loaded in the whole page in the browser. Does anyone knows how can I 'frame' the image ? <% Connection con = FactoryConnection_SQL_SERVER.getConnection("empCHART"); Statement stSuper = con.createStatement(); Statement stSetor = con.createStatement(); Blob image = null; byte[] imgData = null; ResultSet rsSuper = stSuper.executeQuery("SELECT * FROM funChart WHERE dept = 'myDept'"); if (rsSuper.next()) { image = rsSuper.getBlob(12); imgData = image.getBytes(1, (int) image.length()); response.setContentType("image/gif"); OutputStream o = response.getOutputStream(); //o.write(imgData); // even here we got the same as below. //o.flush(); //o.close(); --[...] <table style="margin: 0px; margin-top: 15px;"> <tr> <td id="photo"> <img title="<%=rsSuper.getString("empName").trim()%>" src="<%= o.wite(imageData); o.flush(); o.close(); %>" /> </td> </td> <td id="empData"> <h3><%=rsSuper.getString("empName")%></h3> <p><%=rsSuper.getString("Position")%></p> <p>Id:<br/><%=rsSuper.getString("id")%></p> <p>Phone:<br/><%=rsSuper.getString("Phone")%></p> <p>E-Mail:<br/><%=rsSuper.getString("Email")%></p> </td> </table> And here is the fragment supposed to frame the image: #photo { padding: 0px; vertical-align: middle; text-align: center; width: 170px; height: 220px; } Thanks in advance !

  Read the article

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