[sqlite] authenticating user before allosw to use sql_lite?

hi , Is it possible to prompt user for username and password before allow to use database like in mysql? __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo

Re: [sqlite] bogus output for strftime('%s', 'now')

nope. that doesnt work either. i got no problem outputing other recoard. but got problem with strftime('%s', 'now') --- Jeff Thompson <[EMAIL PROTECTED]> wrote: > On Tue, 1 Feb 2005 06:51:49 -0800 (PST), teoh > <[EMAIL PROTECTED]> wrote: > > > > sqlite3::reader re

Re: [sqlite] bogus output for strftime('%s', 'now') ermm..

nope. reader.getint32(0) will return 0 i tried changed datetime to "text" and did the query by getsring(0) and i get same invalid output output: á " i still cant use strftime('%s', 'now') . --- [EMAIL PROTECTED] wrote: > teoh <[EMAIL PROTECTED]> wri

Re: [sqlite] bogus output for strftime('%s', 'now') .errm..

if i want it to show only records before 2005-01-01 0:0:00 ? i believe that is impossible if I unable to use strftime('%s', 'now') . please comment. thank you. --- Jay <[EMAIL PROTECTED]> wrote: > > Does this fix it? > insert into each_transaction(datetime) > values(datetime('now'

[sqlite] bogus output for strftime('%s', 'now')

create table each_transaction(datetime int); insert into each_transaction values( datetime('%s', 'now')); this is how I create table and insert the strftime('%s', 'now'). But when I did query with sql3_plus. sqlite3::reader reader=con.executereader("select * from each_transaction;");

Re: [sqlite] sqlite search by "DATE" range ?

PROTECTED] wrote: > teoh <[EMAIL PROTECTED]> writes: > > > does anyone knows algorithm use to quote date > range? > > let say, user wants to quote for result from > > 20-12-2004 until 14-1-2005 ?(dd-mm-) > > This page contains all of the informatio

[sqlite] sqlite search by "DATE" range ?

hi, i created date_year smallint,date_month smallint, date_day smallint, time text in sqlite database. does anyone knows algorithm use to quote date range? let say, user wants to quote for result from 20-12-2004 until 14-1-2005 ?(dd-mm-) thank you for clarifying.