cray0000

SELECT * FROM users WHERE id=5;

cray0000

SELECT name, surname FROM employees WHERE name='Вася';

cray0000

SELECT * FROM students WHERE age>16 AND address LIKE '%Гоголя%';

cray0000

SELECT * FROM students WHERE age>18 OR year>=2;

cray0000

SELECT * FROM Persons
ORDER BY LastName DESC

cray0000

INSERT INTO users (name, age)
VALUES ('Вася', 20), ('Петя', 30);

cray0000

UPDATE Persons
SET Address='Nissestien 67', City='Sandnes'
WHERE LastName='Tjessem' AND FirstName='Jakob'

cray0000

DELETE FROM Persons
WHERE LastName='Tjessem' AND FirstName='Jakob'

cray0000

[20:54] <cray0000> Hi, guys! Could you help me with a noob question please? I've added derby-auth to default console project and now I'm getting error "Unauthorized: No access control declared for path rooms.home"
[20:56] == smtudor [~smtudor@static-71-185-69-210.phlapa.fios.verizon.net] has quit [Quit: Leaving...]
[20:57] <cray0000> I've read AccessControl readme at /lib/AccessControl, but it says that security is off by default
[20:59] <switz213> yeah I can help you
[20:59] <cray0000> thanks a lot
[20:59] <switz213> so you've enabled security
[20:59] <cray0000> I've tried both ways
[20:59] <switz213> but you haven't added an access control for rooms.*
[20:59] <cray0000> yea, think that is the problem
[21:00] <cray0000> could you give me a hint please?

cray0000

var toParam,
  __hasProp = {}.hasOwnProperty;

toParam = function(object) {
  var key, params, val;

  params = [];
  for (key in object) {
    if (!__hasProp.call(object, key)) continue;
    val = object[key];