Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.javascript > #37764

Re: End of selected items.

Show all headers | View raw

Arno Welzel <usenet@arnowelzel.de> wrote on 12 Nov 2019 in 
comp.lang.javascript:

> In a database one would just not query element types you don't want.
> 
> For example with an SQL query:
> 
> select * from articles where location='bookshelf'
> 
> and NOT:
> 
> "select * from articles" followed by a script which goes thru the result
> just to find the last article with the condition "location=='bookshelf'".

In SQL one should look at the top one of an "inversed" order to find the 
last one, while not trusting an "intrinsic" order.

SELECT TOP 1 * 
FROM [articlesTable] 
WHERE [locationField] = 'bookshelf'
ORDER BY [indexField] DESC

And yes, if the engine/browser/infrastructure allows it,
WebSQL [or even ADODB Recordset] 
could be an enjoyable programming diversion.

-- 
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Back to comp.lang.javascript | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

End of selected items. Jonas Thörnvall <jonas.thornvall@gmail.com> - 2019-11-11 02:52 -0800
  Re: End of selected items. John G Harris <niam@jghnorth.org.uk.invalid> - 2019-11-11 11:22 +0000
    Re: End of selected items. Jonas Thörnvall <jonas.thornvall@gmail.com> - 2019-11-11 05:58 -0800
  Re: End of selected items. Arno Welzel <usenet@arnowelzel.de> - 2019-11-12 15:31 +0100
    Re: End of selected items. "Evertjan." <exxjxw.hannivoort@inter.nl.net> - 2019-11-12 15:46 +0100

csiph-web