The syntax is wrong in this clause (and similar ones)

        CASE lkey WHEN lkey &gt; 5 THEN
            lkey + 2
        ELSE
            lkey
        END

It&#39;s either

        CASE WHEN [condition] THEN [expression] ELSE [expression] END

or

        CASE [expression] WHEN [value] THEN [expression] ELSE [expression] END

So in your case it would read:

        CASE WHEN lkey &gt; 5 THEN
            lkey + 2
        ELSE
            lkey
        END



Check out the documentation (The CASE expression):

http://www.sqlite.org/lang_expr.html

Also, you do not have to use nested CASEs. You can use several WHEN-THEN lines and the ELSE line is also optional eventhough I recomend it

    CASE 
       WHEN [condition.1] THEN [expression.1]
       WHEN [condition.2] THEN [expression.2]
       ...
       WHEN [condition.n] THEN [expression.n]
       ELSE [expression] 
    END



I&#39;m currently developing a site using ASP.Net MVC3 with Razor. Inside the &quot;View/Shared&quot; folder, I want to add a subfolder called &quot;Partials&quot; where I can place all of my partial views (for the sake of organizing the site better.

I can do this without a problem as long as I always reference the &quot;Partials&quot; folder when calling the views (using Razor):

    @Html.Partial(&quot;Partials/{ViewName}&quot;)

My question is if there is a way to add the &quot;Partials&quot; folder to the list that .Net goes through when searching for a view, this way I can call my view without having to reference the &quot;Partials&quot; folder, like so:

    @Html.Partial(&quot;{ViewName}&quot;)

Thanks for the help!


Adding sub-directory to &quot;View/Shared&quot; folder in ASP.Net MVC and calling the view

I am trying to access an XML file store in the resources directory. I am using NSURL to access this file using NSURLConnection( this file is going to be swapped out for a remote service in the future). 

	NSURLRequest *request = [NSURLRequest requestWithURL:[NSURL 
    URLWithString:@&quot;file:///XMLTest.xml&quot;] 
    cachePolicy:NSURLRequestUseProtocolCachePolicy timeoutInterval:60.0];
	
	NSURLConnection *connection=[[NSURLConnection alloc] initWithRequest:request delegate:self];
	if (connection) {
		// Create the NSMutableData to hold the received data.
		// receivedData is an instance variable declared elsewhere.
		response = [[NSMutableData data] retain];
	} else {
		NSLog(@&quot;Could not create connection&quot;);
	}

The class that starts the connection implements the NSURLConnection methods:

    connection:willCacheResponse: 
    connection:didReceiveData: 
    connectionDidFinishLoading: 
    connectionDidFinishLoading:

Once I launch this the simulator dies, no messages are printed to the console so I am at a loss for where to look. Any ideas, or am I just doing this completely wrong?

Accessing Local file using NSURL

Why this query doesn&#39;t work? :( I tried to replace nested IF statement &quot;...SET lkey = IF(lkey &gt;= 11, lkey - 5, IF(lkey &gt; 5, lkey + 2,lkey))&quot;


    UPDATE pages
    SET lkey = CASE lkey WHEN lkey &gt;= 11 THEN
    		lkey - 5
    	ELSE
    		CASE lkey WHEN lkey &gt; 5 THEN
    			lkey + 2
    		ELSE
    			lkey
    		END
    	END,
    	rkey = CASE lkey WHEN lkey &gt;= 11 THEN
    		rkey - 5
    	ELSE
    		CASE rkey WHEN rkey &lt; 11 THEN
    			rkey + 2
    		ELSE
    			rkey
    		END
    	END
    WHERE rkey &gt; 5 AND
    	lkey &lt; 12;



CASE statement in SQLite query

Why this query doesn't work? :( I tried to replace nested IF statement "...SET lkey = IF(lkey >= 11, lkey - 5, IF(lkey > 5, lkey + 2,lkey))"
<pre><code class="hljs language-sql">UPDATE pages
SET lkey = CASE lkey WHEN lkey >= 11 THEN
		lkey - 5
	ELSE
		CASE lkey WHEN lkey > 5 THEN
			lkey + 2
		ELSE
			lkey
		END
	END,
	rkey = CASE lkey WHEN lkey >= 11 THEN
		rkey - 5
	ELSE
		CASE rkey WHEN rkey &#x3C; 11 THEN
			rkey + 2
		ELSE
			rkey
		END
	END
WHERE rkey > 5 AND
	lkey &#x3C; 12;
</code></pre>

I&#39;d like to use a regular expression in sqlite, but I don&#39;t know how.

My table has got a column with strings like this: &quot;3,12,13,14,19,28,32&quot;
Now if I type &quot;where x LIKE &#39;3&#39;&quot; I also get the rows which contain values like 13 or 32,
but I&#39;d like to get only the rows which have exactly the value 3 in that string.

Does anyone know how to solve this?


How do I use regex in a SQLite query?

Where is the SQLite database stored i.e. directory path on windows 7 when created ?

Where is SQLite database stored on disk?

I am trying to develop a Windows based application with multiple users accessing the same database at the same time. Can SQLite support multiple accesses at one time? Is SQLite stable in this regard? What makes SQLite better or worse than MS SQL CE?

Thanks.

Can SQLite support multiple users?

Please help me with exporting a MySQL database into a SQLite database.

Export a MySQL Database to SQLite Database

I&#39;m trying to create a simple Login form, where I compare the login id and password entered at the login screen with that stored in the database.

I&#39;m using the following query:

    final String DATABASE_COMPARE =
    &quot;select count(*) from users where uname=&quot; + loginname + &quot;and pwd=&quot; + loginpass + &quot;);&quot; ;

The issue is, I don&#39;t know, how can I execute the above query and store the count returned.


Here&#39;s how the database table looks like ( I&#39;ve manged to create the database successfully using the execSQl method)

    private static final String
    DATABASE_CREATE =
    	      	&quot;create table users (_id integer autoincrement, &quot;
    	        + &quot;name text not null, uname primary key text not null, &quot; 
    	        + &quot;pwd text not null);&quot;;//+&quot;phoneno text not null);&quot;;

Can someone kindly guide me as to how I can achieve this? If possible please provide a sample snippet to do the above task. 


SQLite Query in Android to count rows

I&#39;m using LESS to improve my CSS and am trying to nest a class within a class. There&#39;s a fairly complicated hierarchy but for some reason my nesting doesn&#39;t work.
I have this:

    .g {
        float: left;
        color: #323a13;
        .border(1px,#afc945);
        .gradient(#afc945, #c8da64);
        .common;
        span {
            .my-span;
    	    .border-dashed(1px,rgba(255,255,255,0.3));
        }
        .posted {
             .my-posted;
             span {
    	        border: none;
             }
        }
    }

I can&#39;t get the `.g.posted` to work. it just shows the `.g` bit.
If i do this it&#39;s fine:

    .g {
        float: left;
        color: #323a13;
        .border(1px,#afc945);
        .gradient(#afc945, #c8da64);
        .common;
        span {
            .my-span;
    	    .border-dashed(1px,rgba(255,255,255,0.3));
        }
    }
    
    .g.posted {
             .my-posted;
             span {
    	        border: none;
             }
        }

I&#39;d like to nest the `.posted` in `.g` though. Any ideas?


LESS CSS nesting classes

I hope someone can help me with this Javascript.

I have an Object called &quot;Settings&quot; and I would like to write a function that adds new settings to that object.

The new setting&#39;s name and value are provided as strings. The string giving the setting&#39;s name is then split by the underscores into an array. The new setting should get added to the existing &quot;Settings&quot; object by creating new nested objects with the names given by each part of the array, except the last part which should be a string giving the setting&#39;s value. I should then be able to refer to the setting and e.g. alert its value. I can do this in a static way like this...

    var Settings = {};
    var newSettingName = &quot;Modules_Video_Plugin&quot;;
    var newSettingValue = &quot;JWPlayer&quot;;
    var newSettingNameArray = newSettingName.split(&quot;_&quot;);

    Settings[newSettingNameArray[0]] = {};
    Settings[newSettingNameArray[0]][newSettingNameArray[1]] = {};
    Settings[newSettingNameArray[0]][newSettingNameArray[1]][newSettingNameArray[2]] = newSettingValue;
    
    alert(Settings.Modules.Mediaplayers.Video.Plugin);

... the part that creates the nested objects is doing this ...

    Settings[&quot;Modules&quot;] = {};
    Settings[&quot;Modules&quot;][&quot;Video&quot;] = {};
    Settings[&quot;Modules&quot;][&quot;Video&quot;][&quot;Plugin&quot;] = &quot;JWPlayer&quot;;


However, as the number of parts that make up the setting name can vary, e.g. a newSettingName could be &quot;Modules_Floorplan_Image_Src&quot;, I&#39;d like to do this dynamically using a function such as...

    createSetting (newSettingNameArray, newSettingValue);

    function createSetting(setting, value) {
    	// code to create new setting goes here
    }

Can anyone help me work out how to do this dynamically?

I presume there has to be a for...loop in there to itterate through the array, but I haven&#39;t been able to work out a way to create the nested objects.

If you&#39;ve got this far thanks very much for taking the time to read even if you can&#39;t help.



Javascript: how to dynamically create nested objects using object names given by an array

I&#39;m trying to make a set of sets in Python.  I can&#39;t figure out how to do it.

Starting with the empty set `xx`:

    xx = set([])
    # Now we have some other set, for example
    elements = set([2,3,4])
    xx.add(elements)

but I get
 
    TypeError: unhashable type: &#39;list&#39;

or 

    TypeError: unhashable type: &#39;set&#39;

Is it possible to have a set of sets in Python?

I am dealing with a large collection of sets and I want to be able to not have to deal duplicate sets (a set B of sets A1, A2, ...., An would &quot;cancel&quot; two sets if Ai = Aj)

How can I create a Set of Sets in Python?

Is it possible to create an LDAP query which will return (or check for) users in a nested group? e.g. UserA is a member of GroupA, and GroupA is a member of GroupB. I want a query on GroupB to return that UserA is a member. LDAP only. The server is Active Directory.

ldap nested group membership

I have a data structure like this :

    var someObject = {
        &#39;part1&#39; : {
            &#39;name&#39;: &#39;Part 1&#39;,
            &#39;size&#39;: &#39;20&#39;,
            &#39;qty&#39; : &#39;50&#39;
        },
        &#39;part2&#39; : {
            &#39;name&#39;: &#39;Part 2&#39;,
            &#39;size&#39;: &#39;15&#39;,
            &#39;qty&#39; : &#39;60&#39;
        },
        &#39;part3&#39; : [
            {
                &#39;name&#39;: &#39;Part 3A&#39;,
                &#39;size&#39;: &#39;10&#39;,
                &#39;qty&#39; : &#39;20&#39;
            }, {
                &#39;name&#39;: &#39;Part 3B&#39;,
                &#39;size&#39;: &#39;5&#39;,
                &#39;qty&#39; : &#39;20&#39;
            }, {
                &#39;name&#39;: &#39;Part 3C&#39;,
                &#39;size&#39;: &#39;7.5&#39;,
                &#39;qty&#39; : &#39;20&#39;
            }
        ]
    };

And I would like to access the data using these variable :

    var part1name = &quot;part1.name&quot;;
    var part2quantity = &quot;part2.qty&quot;;
    var part3name1 = &quot;part3[0].name&quot;;

part1name should be filled with `someObject.part1.name` &#39;s value, which is &quot;Part 1&quot;. Same thing with part2quantity which filled with 60.

Is there anyway to achieve this with either pure javascript or JQuery?

Accessing nested JavaScript objects and arrays by string path

The `OR` operator in the `WHEN` clause of a `CASE` statement is not supported. How can I do this?

    CASE ebv.db_no 
        WHEN 22978 OR 23218 OR 23219 THEN &#39;WECS 9500&#39; 
        ELSE &#39;WECS 9520&#39; 
    END as wecs_system 


OR is not supported with CASE Statement in SQL Server

We have a log table that has a message column that sometimes has an exception stack trace. I have some criteria that determines if the message has this. We do not want to show these messages to the customer but instead have a message like:

&gt; Internal Error Occured. Contact US
&gt; with reference code
&gt; xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

where xxx etc is a guid column in the table. I am writing stored proc like this:

    declare @exceptionCriteria nvarchar(50)
    select @exceptionCriteria = &#39;%&lt;enter criteria etc&gt;%&#39;
    
    select LogDate,
           case
           when Message like @exceptionCriteria
           then &#39;Internal Error Occured. Reference Code: &#39; + str(RequestID)
           else Message
           end
      from UpdateQueue

`RequestID` is a Guid datatype in SQL Server and does not convert to string here. I&#39;ve seen some code on how to convert a Guid to string, but it is multi-lined and I don&#39;t think it would work in a case statement. Any ideas?


SQL Server: converting UniqueIdentifier to string in a case statement

I have a two tables.  One has manufacturer information and includes the regions where they can sell.  The other has their products for sale.  We have to limit visibility of the product based on the regions.  This is like Netflix have videos in their system that can only be viewed Everywhere (1), only in Canada (2), only in USA (3).

I am trying to make a query that tells me where the product can be viewed based on the settings in the manufacturer table.

For example, in the manufacturer table, there are two fields called expose_new and expose_used each of which will have a value of  1,2 or 3 to limit where their new or used videos can seen.

When the videos are added, they are not assigned an &#39;expose&#39; value and this is meant to be done on the fly when adding them to our index depending on the current manufacturer&#39;s expose_new or expose_used values.

**What I am trying to get is the item details and the computed value for where it can be seen based on whether it is new or used and the rule/value assigned to the manufacturer for all their new or used products.**  I need this single digit on a per-product basis to conditionally display it in a list.

The following does not work, but you will get the idea of what I am trying to do.  I have tried this with CASE statements and the following WRONG IF/ELSEIF statement.

Any help to debugger this and point me in the right direction would be appreciated.

    SELECT 
    t2.company_name,
    t2.expose_new,  // 1,2 or 3
    t2.expose_used, // 1,2 or 3
    t1.title,
    t1.seller,
    t1.status,  //can be new or used
    (SELECT 
    IF(status =&#39;New&#39;,
      (select expose_new from manufacturers where id = t1.seller),1
    )
    ELSEIF(t1.status =&#39;Used&#39;,
      (select expose_used from manufacturers where id = t1.seller),1
    )
    END IF
    ) as &#39;expose&#39;
    FROM `products` t1
    join manufacturers t2 on t2.id = t1.seller
    where t1.seller = 4238

Here is a CASE version that actually seems to execute but always results in the first value no matter what happens to be true (in this case 1).  I am not sure that I can have the addition of another test with the AND in each WHEN statement but it does not give an error, only the wrong result.

    SELECT 
    t2.company_name,
    t2.expose_new,
    t2.expose_used,
    t1.title,
    t1.status,
     CASE status
       when &#39;New&#39; and t2.expose_new = 1 then 1
       when &#39;New&#39; and t2.expose_new = 2 then 2
       when &#39;New&#39; and t2.expose_new = 3 then 3
       when &#39;Used&#39; and t2.expose_used = 1 then 1
       when &#39;Used&#39; and t2.expose_used = 2 then 2
       when &#39;Used&#39; and t2.expose_used = 3 then 3
    END as expose
    FROM `products` t1
    join manufacturers t2 on t2.id = t1.seller
    where t1.seller = 4238




MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result

I am working with a query which contains &quot;CASE&quot; statement within &quot;WHERE&quot; clause. But SQL Server 2008 is giving some errors while executing it. Can anyone please help me with the correct query? Here is the query:

    SELECT
        tl.storenum &#39;Store #&#39;, 
        co.ccnum &#39;FuelFirst Card #&#39;, 
        co.dtentered &#39;Date Entered&#39;,
        CASE st.reasonid 
            WHEN 1 THEN &#39;Active&#39; 
	   WHEN 2 THEN &#39;Not Active&#39; 
	   WHEN 0 THEN st.ccstatustypename 
	   ELSE &#39;Unknown&#39; 
        END &#39;Status&#39;,
        CASE st.ccstatustypename 
            WHEN &#39;Active&#39; THEN &#39; &#39; 
	   WHEN &#39;Not Active&#39; THEN &#39; &#39; 
	   ELSE st.ccstatustypename 
        END &#39;Reason&#39;,
        UPPER(REPLACE(REPLACE(co.personentered,&#39;RT\\\\&#39;,&#39;&#39;),&#39;RACETRAC\\\\&#39;,&#39;&#39;)) &#39;Person Entered&#39;,
        co.comments &#39;Comments or Notes&#39;
    FROM 
        comments co
        INNER JOIN cards cc ON co.ccnum=cc.ccnum
        INNER JOIN customerinfo ci ON cc.customerinfoid=ci.customerinfoid
        INNER JOIN ccstatustype st ON st.ccstatustypeid=cc.ccstatustypeid
        INNER JOIN customerstatus cs ON cs.customerstatuscd=ci.customerstatuscd
        INNER JOIN transactionlog tl ON tl.transactionlogid=co.transactionlogid
        LEFT JOIN stores s ON s.StoreNum = tl.StoreNum
    WHERE 
        CASE LEN(&#39;TestPerson&#39;)
            WHEN 0 THEN co.personentered  = co.personentered
	   ELSE co.personentered LIKE &#39;%TestPerson&#39;
        END 
        AND cc.ccnum = CASE LEN(&#39;TestFFNum&#39;)
            WHEN 0 THEN cc.ccnum 
	   ELSE &#39;TestFFNum&#39; 
        END 
        AND CASE LEN(&#39;2011-01-09 11:56:29.327&#39;) 
            WHEN 0 THEN co.DTEntered = co.DTEntered 
	   ELSE 
	       CASE LEN(&#39;2012-01-09 11:56:29.327&#39;) 
	           WHEN 0 THEN co.DTEntered &gt;= &#39;2011-01-09 11:56:29.327&#39; 
		  ELSE co.DTEntered BETWEEN &#39;2011-01-09 11:56:29.327&#39; AND &#39;2012-01-09 11:56:29.327&#39; 
	       END 
        END
        AND tl.storenum &lt; 699 
    ORDER BY tl.StoreNum


&quot;CASE&quot; statement within &quot;WHERE&quot; clause in SQL Server 2008

I am a newbie when it comes to JavaScript and it was my understanding that using one SWITCH/CASE statements is faster than a whole bunch of IF statements.  

However, I want to use a SWITCH/CASE statement with two variables.

My web app has two sliders, each of which have five states.  I want the behavior to be based on the states of these two variables.  Obviously that is a whole heck of a lot of IF/THEN statements.

One way I thought about doing it was concatenating the two variables into one and then I could SWITCH/CASE that.

Is there a better way of accomplishing a SWITCH/CASE using two variables ?

Thanks !



Content Type	Original Author	Original Content on Stackoverflow
Question	VeroLom	View Question on Stackoverflow
Solution 1 - Sqlite	Lukas Eder	View Answer on Stackoverflow
Solution 2 - Sqlite	Hrusilov	View Answer on Stackoverflow

CASE statement in SQLite query

Sqlite Problem Overview

Sqlite Solutions

Solution 1 - Sqlite

Solution 2 - Sqlite

Accessing Local file using NSURL

Adding sub-directory to "View/Shared" folder in ASP.Net MVC and calling the view

Attributions