RE: [sqlite] What does this mean???

[prabhu kumaravelu]

From: "Anderson, James H (IT)" <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: 
Subject: [sqlite] What does this mean???
Date: Wed, 7 Feb 2007 17:33:21 -0500

not an error(21) at dbdimp.c line 398

I'm using DBD::SQLite and got this error. What does it mean and how best
to hanle it?

Thanks,

jim


NOTICE: If received in error, please destroy and notify sender. Sender does 
not intend to waive confidentiality or privilege. Use of this email is 
prohibited when received in error.


_
Latest updates from the world of sports 
http://content.msn.co.in/Sports/Default



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Please unsubscribe

[prabhu kumaravelu]

Please unsubscribe

_
Gossips, movie reviews, photogallery and more 
http://content.msn.co.in/Entertainment/Default



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Please un subscribe me from sqlite. Dont send me email

[prabhu kumaravelu]

Please un subscribe me from sqlite



From: "Rob Richardson" <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: 
Subject: [sqlite] The meaning of times in julianday()
Date: Fri, 28 Jul 2006 10:50:52 -0400

Greetings!



My test query is:



select tag_key,value,

   datetime(value_timestamp, 'localtime') AS localtime,

   datetime(value_timestamp) AS UTCtime

from trend_view

where trend_key=1

and value_timestamp >= julianday('2006-07-27 10:08:32.000')

order by value_timestamp desc



My table has records recorded every hour, roughly on the hour.  This
program that generated this query wanted to get the last 24 hours' worth
of data.  It was run at 10:08 on June 28th.



The earliest data returned was recorded at 11:01 UTC on June 27th, or
7:01 AM EDT on June 27th.  That's too far back by four hours (the
difference between EDT and UTC time).



When I changed the query to use julianday('2006-07-27 10:08:32.000',
'utc'), the earliest data returned was recorded at 15:01 UTC on June
27th, which is 11:01 EDT on June 27th, which is what I want.



When I changed the query to use julianday('2006-07-27 10:08:32.000',
'localtime'), the earliest data returned was recorded at 07:01 UTC on
June 27th, which is 03:01 AM EDT on June 27th, which is far too much.



So, I conclude the following:

If no modifier is provided to the julianday() method, the given date is
assumed to be UTC.

If the 'utc' modifier is used, the given date is assumed to be local
time.  It is converted to UTC before the comparison is made.

If the 'localtime' modifier is used, the given date is assumed to be UTC
time, and it is converted to local time before the comparison is made.

Are those conclusions correct?  And I presume the datetime() method
operates the same way?



Thanks again!



Rob Richardson

RAD-CON INC.





_
Who will win Bollywood’s most coveted IIFA awards? You decide! Cast your 
vote! http://server1.msn.co.in/sp06/IIFA2006/static/weekend.asp

[sqlite] Please unsubscribe me from sqlite

[prabhu kumaravelu]

Please unsubscribe me from sqlite



From: mycmos <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
CC: Vivek R <[EMAIL PROTECTED]>
Subject: [sqlite] re£º [sqlite] Retriving data from SQLite
Date: Thu, 27 Jul 2006 15:31:24 +0800 (CST)


--- Vivek R <[EMAIL PROTECTED]>дµÀ:

> Hi ,
>  I am new bee to SQLite, I am using SQLite in one of
> the embedded
> applications. What I wanted to know how to retrive
> the data from table once
> the query is exected?  how to store the results of
> the query executed.
>
> Regards,
>   Vivek R
>

int sqlite_get_table(
  sqlite *db,
  const char *zSql,
  char ***pazResult,
  int *pnRow,
  int *pnColumn,
  char **pzErrMsg
)

All results of the query executed is stored in
*pazResult.







___
Mp3·è¿ñËÑ-иèÈȸè¸ßËÙÏÂ
http://music.yahoo.com.cn/?source=mail_mailbox_footer


_
Sexy, sultry, sensuous. - see why Bipasha Basu is all that and more. Try MSN 
Search http://server1.msn.co.in/Profile/bipashabasu.asp

[sqlite] Please unsubscribe me from sqlite

[prabhu kumaravelu]

Please unsubscribe me from sqlite




From: Peter van Dijk <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] "SQL Error: near 'Table': Syntax error"
Date: Thu, 27 Jul 2006 08:44:59 +0200


On Jul 26, 2006, at 5:33 PM, Dennis Cote wrote:


John Newby wrote:


Is there any other names I need to look out for other than the  "sqlite_" 
and
"table" that SQLite doesn't like as being a table name that anyone  knows 
of?



John,

All keywords need to be quoted to use them as identifiers. There is  a 
comprehensive list of keywords at http://www.sqlite.org/ 
lang_keywords.html


I would also suggest that you stick with the SQL standard method of  
quoting identifiers using double quotes (rather than the other  extensions 
that SQLite accepts for compatibility with other non- standard database 
systems).


Using double quotes to quote identifiers in sqlite is dangerous, as  
mistyping

a fieldname will not yield an error. Currently the only safe way to  quote
identifiers is using backticks, as in MySQL.

Cheers, Peter.


_
Sexy, sultry, sensuous. - see why Bipasha Basu is all that and more. Try MSN 
Search http://server1.msn.co.in/Profile/bipashabasu.asp

[sqlite] Please unsubscribe me from sqlite

[prabhu kumaravelu]

Please unsubscribe me from sqlite





From: "Igor Tandetnik" <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: "SQLite" 
Subject: [sqlite] Re: User function in WHERE clause
Date: Thu, 27 Jul 2006 10:47:35 -0400

Stan <[EMAIL PROTECTED]> wrote:

is there a way to create user function similar to LIKE?
I'd like to use my function in clause WHERE. E.g. this selection:
SELECT * FROM Table WHERE Name MYFUNCTION param
Param is integer.


Not like this, but you can create a function and use it this way:

SELECT * FROM Table WHERE MYFUNCTION(Name, param)

Igor Tandetnik


_
Fall in Love... Get married! Join FREE! 
http://www.shaadi.com/ptnr.php?ptnr=msnhottag

[sqlite] Please un-subscribe

[prabhu kumaravelu]

Please un-subscribe from sqlite please me know how to do it.
Dont send me email

_
Who will win Bollywood’s most coveted IIFA awards? You decide! Cast your 
vote! http://server1.msn.co.in/sp06/IIFA2006/static/weekend.asp

RE: [sqlite] unsubscribe me please

[prabhu kumaravelu]

unsubscribe me please



From: "Shi, Chunde CTR DISA PEO-C2C" <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: 
Subject: [sqlite] unsubscribe me please RE: [sqlite] sqlite3_interrupt() 
and threads

Date: Tue, 25 Jul 2006 19:17:01 -0400



Chunde Shi

[EMAIL PROTECTED]
703 882 1466
703 882 2325



From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tue 7/25/2006 7:06 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite3_interrupt() and threads



Michael Scharf <[EMAIL PROTECTED]> wrote:
> Rob,
> > I notice in the documentation that the sqlite3_progress_handler() 
method

> > is marked "experimental".  Is that significant?
>
> No idea, that's a question Richard Hipp may answer..
>

I need to remove the experimental marking.  Perhaps
somebody could create a ticket to remind me ;-)

While you are at it, consider creating an enhancement
ticket to allow sqlite3_interrupt to be called from
a different thread.
--
D. Richard Hipp   <[EMAIL PROTECTED]>



_
Best IT jobs on naukri.com 
http://www.naukri.com/tieups/tieups.php?othersrcp=3246

Re: [sqlite] Database design questions

[prabhu kumaravelu]

i want to unsubscribe. I have been email from sqlite and fill up my inbox 
please unsubcribe this





From: Darren Duncan <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Database design questions
Date: Tue, 27 Jun 2006 10:33:03 -0700

At 10:17 AM -0700 6/27/06, Bud Beacham wrote:

I am using SQLite to add a database engine to a product I hope
to sell.  One thing that is desirable is to allow the customers
to enhance the database for their specific needs.  For example,
they could add new tables to reflect their environment, and then
design queries that look at both the standard and added tables.

However, since this all new to me I have two questions.

If I offer an upgrade version with new tables how difficult will
it be for the user to merge their database into the latest
version?  I will insure that any customer table names will not
conflict with my table names.

Would it make more sense to have the customers create a new
database and then design their queries to deal with two
databases?


Keeping everything that belongs together in a single disk file is usually 
simpler for users.  Within that constraint, the simplest way to incorporate 
both your own tables plus arbitrary user-defined ones is for you to rename 
the user-defined table names in a reversable fashion, to guarantee their 
uniqueness from yours.  The simplest way to do this is simply add a common 
name prefix to all user-defined names behind the scenes, but hide that 
implementation detail from the user; eg, prepend "udt_" (user defined 
table) to each name the user picks, and make sure that none of your 
application defined tables start with that.  FYI, this practice simulates 
multiple name-spaces / schemas in a single disk file, which SQLite doesn't 
do natively. -- Darren Duncan


_
How good are you in a Formula One car? Play now 
http://server1.msn.co.in/sp05/tataracing/onlinegame.asp