[sqlite] Need moderator to contact me regarding a security issue.

Will the moderator please contact me. I have found a security hole with the list software that they will want to fix. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Need-moderator-to-contact-me-regarding-a-security-issue-tp71237.html Sent from the SQLite mailing list archi

Re: [sqlite] select with date

Sorry for the double post :( Thanks for your explanation. The other folks where kind enough to provide good working examples but I did not know what logical error I had made. Thanks again. -- View this message in context: http://sqlite.1065341.n5.nabble.com/select-with-date-tp71216p71231.html

Re: [sqlite] Select with dates

Thank! This worked great! -- View this message in context: http://sqlite.1065341.n5.nabble.com/Select-with-dates-tp71222p71229.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://s

[sqlite] select with date

I have not used the date function in select statements before. I have valid entries for the current month, what am I doing wrong? SELECT * FROM "entry" WHERE bankdate > date('now','end of month','-1 month') AND bankdate < date('now','start of month','+1 month') -- Vi

[sqlite] Select with dates

I have not used the date function in select statements before. I have valid entries for the current month, what am I doing wrong? SELECT * FROM "entry" WHERE bankdate > date('now','end of month','-1 month') AND bankdate < date('now','start of month','+1 month') -- View

[sqlite] Time zones

Where can I find a complete list of Sqlite timezones. I Google searched without success. i.e hawaiin ?? date_default_timezone_set('America/Los_Angeles'); // pacific timezone date_default_timezone_set('America/Denver'); // mountain timezone central ?? date_default_timezone_set('America/New_York);

Re: [sqlite] accessing multiple databases

As a follow up... Sqlite finds the first db fine useing a relative path but the ATTACH command needs the FULL PATH. Ugg! Are you sure it's really opening the DB you think it's opening? I think SQLite will create the file if it's not there, and you'll have nothing in it. Perhaps you should tr

Re: [sqlite] [SOLVED] accessing multiple databases

VERY NICE!!! You were right! I tried ./filename and that did not work, then I tried $_SERVER[DOCUMENT_ROOT]/path/filename BINGO! Thanks for teh help. jan zumwalt Are you sure it's really opening the DB you think it's opening? I think SQLite will create the file if it's not there, and you'll

[sqlite] accessing multiple databases

I'm attempting to do a test accessing multiple databases with the code listed below. It errors on the 2nd db select statement and says that the "table does not exist". I am using 2 identical db for the test with different names. Any idea what I am doing wrong? - Thanks, Jan Zumwalt '; echo 'Use

Re: [sqlite] Need trigger

Thanks for the help! It turned out that the trigger was correct (and I also was using a default value). I am using SQLITE3 Managment Studio v3.7.9 and the default value was not being picked up during a insert using the IDE. For unknown reasons the trigger solves the problem. Thanks again for all

[sqlite] Need trigger

I am attempting to crete a trigger that fills a field with "unknown" if a update leaves it empty. the trigger I tried is shown below, but it does not seem to work. Any ideas what I am doing wrong? Thanks - JZ $query = "CREATE TRIGGER update_editby AFTER INSERT ON employee BEGIN UPD