[**SQLFiddle**](http://sqlfiddle.com/) will let you test out your queries, while it doesn&#39;t explicitly correct syntax etc. per se it does let you play around with the script and will definitely let you know if things are working or not.

A lot of people, including me, use sqlfiddle.com to test SQL. 

When my page loads, I try to `send` a message to the server to initiate a connection, but it&#39;s not working. This script block is near the top of my file:

    var connection = new WrapperWS();
    connection.ident();
    // var autoIdent = window.addEventListener(&#39;load&#39;, connection.ident(), false);

Most of the time, I see the error in the title:

&gt; Uncaught InvalidStateError: Failed to execute &#39;send&#39; on &#39;WebSocket&#39;: Still in CONNECTING state

So I tried to `catch` the exception, as you can see below, but now it seems `InvalidStateError` is not defined and that produces a `ReferenceError`.


Here&#39;s the wrapper object for my websocket connection:

&lt;pre&gt;&lt;code&gt;// Define WrapperWS

function WrapperWS() {
    if (&quot;WebSocket&quot; in window) {
        var ws = new WebSocket(&quot;ws://server:8000/&quot;);
        var self = this;

        ws.onopen = function () {
            console.log(&quot;Opening a connection...&quot;);
            window.identified = false;
        };
        ws.onclose = function (evt) {
            console.log(&quot;I&#39;m sorry. Bye!&quot;);
        };
        ws.onmessage = function (evt) {
            // handle messages here
        };
        ws.onerror = function (evt) {
            console.log(&quot;ERR: &quot; + evt.data);
        };

        this.write = function () {
            if (!window.identified) {
                connection.ident();
                console.debug(&quot;Wasn&#39;t identified earlier. It is now.&quot;);
            }
            ws.send(theText.value);
        };

        this.ident = function () {
            var session = &quot;Test&quot;;
            try {
                ws.send(session);
            } catch (error) {
                if (error instanceof InvalidStateError) {
                    // possibly still &#39;CONNECTING&#39;
                    if (ws.readyState !== 1) {
                        var waitSend = setInterval(ws.send(session), 1000);
                    }
                }
            }
	    window.identified = true;
            theText.value = &quot;Hello!&quot;;
            say.click();
            theText.disabled = false;
        };

    };

}
&lt;/code&gt;&lt;/pre&gt;

I am testing using Chromium on Ubuntu.

Uncaught InvalidStateError: Failed to execute &#39;send&#39; on &#39;WebSocket&#39;: Still in CONNECTING state

when I have a web page with a scrollable content. With css property &quot;overflow:auto&quot; or &quot;overflow:visible&quot; the scrollbar is visible on desktop browsers, but when I open the page on mobile browsers the scrollbar appears only when I try to scroll. 
Is there a way to make the scrollbar always visible on mobile devices? I have tried some JQuery libraries but none of them have worked.

The html code is trivial, I have a scrollable div with an IFrame inside:

    &lt;div id=&quot;wrapper&quot;&gt;
        &lt;iframe id=&quot;frameContent&quot; src=&quot;mysite&quot; scrollable=&quot;yes&quot;&gt;&lt;/iframe&gt;
    &lt;/div&gt;

The css:

    #wrapper{
	    overflow: scroll;
	    -webkit-overflow-scrolling: touch;
	    width: 500px;
	    height: 200px;
    }

    #frameContent{
	    width: 100%;
	    height: 100%;
    } 



Make scrollbar visible in mobile browsers

I need an online sql query syntax validator. 

I searched online but didn&#39;t find anything good. 

I saw the references in this question too:

https://stackoverflow.com/questions/3138022/syntax-checker-and-validator-for-sql

Online SQL Query Syntax Checker

I need an online sql query syntax validator.
I searched online but didn't find anything good.
I saw the references in this question too:
<a href="https://stackoverflow.com/questions/3138022/syntax-checker-and-validator-for-sql" target="_blank" rel="noopener noreferrer">https://stackoverflow.com/questions/3138022/syntax-checker-and-validator-for-sql</a>

Postgres - Transpose Rows to Columns

How to get all the dates between two dates?

I have a variable `@MAXDATE` which is storing the maximum date from the table. Now I want to get the all dates between `@Maxdate` and `GETDATE()` and want to store these dates in a cursor.

So far I have done as follows:

    ;with GetDates As  
    (  
        select DATEADD(day,1,@maxDate) as TheDate
        UNION ALL  
        select DATEADD(day,1, TheDate) from GetDates  
        where TheDate &lt; GETDATE()  
    )  

This is working perfectly but when I am trying to store these values in a cursor

    SET @DateCurSor = CURSOR FOR
    				SELECT TheDate
    				FROM GetDates

Compilation Error

&gt; Incorrect syntax near the keyword &#39;SET&#39;.

How to solve this?

Get all dates between two dates in SQL Server

If I have to work with `localdb`, do we need to install it separately?

I have SQL Server 2008 R2 Management Studio installed, SQL Server 2012 installed, .net 4.0.2 update installed. But I don&#39;t see localdb in the PC yet.

How to install localdb separately?

I am trying to query my postgresql db to return results where a date is in certain month and year. In other words I would like all the values for a month-year. 

The only way i&#39;ve been able to do it so far is like this:

    SELECT user_id 
    FROM user_logs 
    WHERE login_date BETWEEN &#39;2014-02-01&#39; AND &#39;2014-02-28&#39;

Problem with this is that I have to calculate the first date and last date before querying the table. Is there a simpler way to do this?

Thanks 

Postgresql query between date ranges

What does `||` do in SQL?

    SELECT &#39;a&#39; || &#39;,&#39; || &#39;b&#39; AS letter

Content Type	Original Author	Original Content on Stackoverflow
Question	sa_nyc	View Question on Stackoverflow
Solution 1 - Sql	serakfalcon	View Answer on Stackoverflow
Solution 2 - Sql	DeanOC	View Answer on Stackoverflow

Online SQL Query Syntax Checker

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Make scrollbar visible in mobile browsers

Uncaught InvalidStateError: Failed to execute 'send' on 'WebSocket': Still in CONNECTING state

Attributions