Subj : Re: Documentation Update
To   : Al
From : Blue White
Date : Sat Nov 09 2019 19:56:00

-=> Al wrote to Blue White <=-

 BW>     update users set seclevel=99 where loginname LIKE "apam";

 BW> Should read:

 BW>     update users set sec_level=99 where loginname LIKE "apam";

 Al> Ah, good catch. I've tried adjusting sec_level with no success. I don't
 Al> remember why it failed but I'll try again with sec_level.

Actually, I don't know if it is required or not but, when I had success, I
also put a space before and after the equal sign, i.e. sec_level = 99.  I
forgot to add the spaces when I copied and changed the line from the docs.

 BW> Might also want to include a note about issuing an ".open users.sq3"
 BW> first, or sqlite3 won't be able to find the "users" table.  :)

 Al> That might be part of my problem too.. thanks for the update.. :)

It is possible that .open statement is not required, but I sure needed it
here to get sqlite3 to find the table.



.... Computer Hacker wanted. Must have own axe.
--- MultiMail
 * Origin: Possum Lodge South * possumso.fsxnet.nz:7636/SSH:2122 (21:4/134)

.