Talk:Web storage

From Wikipedia, the free encyclopedia
Jump to: navigation, search
          This article is of interest to the following WikiProjects:
WikiProject Internet (Rated C-class, Low-importance)
WikiProject icon This article is within the scope of WikiProject Internet, a collaborative effort to improve the coverage of the Internet on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
C-Class article C  This article has been rated as C-Class on the project's quality scale.
 Low  This article has been rated as Low-importance on the project's importance scale.
 
WikiProject Software / Computing  (Rated C-class, Low-importance)
WikiProject icon This article is within the scope of WikiProject Software, a collaborative effort to improve the coverage of software on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
C-Class article C  This article has been rated as C-Class on the project's quality scale.
 Low  This article has been rated as Low-importance on the project's importance scale.
Taskforce icon
This article is supported by WikiProject Computing.
 
WikiProject Computing / Websites (Rated C-class, Low-importance)
WikiProject icon This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
C-Class article C  This article has been rated as C-Class on the project's quality scale.
 Low  This article has been rated as Low-importance on the project's importance scale.
Taskforce icon
This article is supported by WikiProject Websites (marked as Low-importance).
 

Compatibility table[edit]

Plz add compatibility chart that shows which browser at which version supports which feature. --Bxj (talk) 10:30, 27 October 2011 (UTC)

Capitalization[edit]

I recently moved the page from "Web Storage" to "web storage", and it looks like it has been controversial, so let me explain here. Unlike the sciences and the computer industry, which often prefer capitalization, Wikipedia usually prefers not to capitalize. To pick an example from computing, most sources refer to Object Oriented Programming with capital letters, but the Wikipedia article is named object-oriented programming. The actual standard for whether we should use capitals is not what the industry normally uses, but whether the word or phrase is a proper noun. Usually concepts in programming aren't proper nouns (hence we have a lowercase "cookie" in HTTP cookie), and while I realise there can be exceptions, I don't see a good reason for making one here. A good acid test for whether something is a proper noun is to check if it is consistently capitalized in sources. I admit that most of the references to web storage are capitalized, but a little searching easily turned up some counterexamples.[1][2] If it turns out that "Web Storage" is actually a trademarked phrase or similar, then I will be happy to reconsider my views, but in the meantime I shall restore the lower-case version. Of course, if anyone has any questions, I'll be happy to answer them. All the best — Mr. Stradivarius 13:29, 23 January 2012 (UTC)

Sandbox[edit]

People often don't connect these 2 things together, but it's really worth to mention that web storage is a sandbox...or let's say it's THE sandbox: http://en.wikipedia.org/wiki/Sandbox_(computer_security). 178.197.235.113 (talk) 13:44, 13 February 2013 (UTC)

DOM Storage[edit]

Periodically, turn off DOM storage and delete all cookies. Close the browser. As some sites will not work without you being tracked, reenable DOM storage when you reopen your browser. This will help prevent sites from keeping too much data about you. — Preceding unsigned comment added by 66.169.103.80 (talk) 12:17, 31 October 2015 (UTC)

Vba Code for excel[edit]

Sub sbADOExample() Dim sSQLQry As String 'Dim ReturnArray Dim conn As Object Dim mrs As Object Set conn = CreateObject("ADODB.connection") Set mrs = CreateObject("ADODB.Recordset") Dim DBPath As String, sconnect As String

DBPath = "D:\InputData.xlsx" sconnect = "Provider=MSDASQL.1;DSN=Excel Files;DBQ=" & DBPath & ";HDR=Yes;" conn.Open sconnect sSQLSting = "SELECT * From [Sheet1$]" ' Your SQL Statement (Table Name= Sheet Name=[Sheet1$]) 'conn.Execute (sSQLSting) mrs.Open sSQLSting, conn '=>Load the Data into an array 'ReturnArray = mrs.GetRows OR '=>Paste the data into a sheet Sheet1.Range("A2").CopyFromRecordset mrs 'Close Recordset mrs.Close 'Close Connection conn.Close Set conn = Nothing End Sub


insert


Sub sbADOExample() Dim sSQLQry As String 'Dim ReturnArray Dim conn As Object Set conn = CreateObject("ADODB.connection") Dim DBPath As String, sconnect As String DBPath = "D:\InputData.xlsx" sconnect = "Provider=MSDASQL.1;DSN=Excel Files;DBQ=" & DBPath & ";HDR=Yes;" conn.Open sconnect 'sSQLSting = "SELECT * From [Sheet1$]" ' Your SQL Statement (Table Name= Sheet Name=[Sheet1$]) 'sSQLSting = "Insert Into [Sheet1$] (Name,Amt,Mob) Values('Suraj',248,742855458)" sSQLSting = "Insert Into [Sheet1$] (Name,Amt,Mob) Values(" sSQLSting = sSQLSting & "'" & Range("C4").Value & "'," sSQLSting = sSQLSting & Range("D4").Value & "," sSQLSting = sSQLSting & Range("E4").Value & ")" conn.Execute (sSQLSting) 'mrs.Open sSQLSting, Conn '=>Load the Data into an array 'ReturnArray = mrs.GetRows OR '=>Paste the data into a sheet 'Sheet2.Range("A2").CopyFromRecordset mrs 'Close Recordset 'mrs.Close 'Close Connection conn.Close Set conn = Nothing Range("C4").Clear Range("D4").Clear Range("E4").Clear End Sub — Preceding unsigned comment added by Akash497 (talkcontribs) 07:16, 13 April 2016 (UTC)