Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE

[Shibu.Narayanan]

There should be no single quotes around question marks

-Shibu

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of P Kishor
Sent: Monday, February 02, 2009 6:14 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] sqlite3_bind_int returns SQLITE_RANGE

Farzana,

You can save a lot of email back-and-forth by showing your code in the
first place. The very minimum information that you (that anyone)
should provide when asking a code-related question is --

1. db schema
2. code

adding info about computer and operating system, plus any driver
version being used, is also advisable.

On Mon, Feb 2, 2009 at 6:40 AM, hussainfarzana
 wrote:
>
> Yes,the SQL prepared statement has got 14 placeholders.
>
> The statement is "INSERT INTO CollDataNum
> values(?,?,?,?,?,?,?,?,'?',?,?,?,?,?)"
>
> Regards,
> Farzana.
>
>
> SimonDavies wrote:
>>
>> 2009/2/2 hussainfarzana :
>>>
>>> Dear All,
>>>
>>> We are working with SQLite Version 3.6.10.
>>> We tried to insert or update the records in the database using
>>> sqlite3_prepare and binding the values using sqlite3_bind
functions.We
>>> have
>>> started with the index 1.We have a table with 14 columns and when we
use
>>> sqlite3_bind_int,for the first 13 columns its returning 0 and for
the
>>> last
>>> 14th column which is also an integer datatype, but the function is
>>> returning
>>> value 25(SQLITE_RANGE) error.
>>
>> Your table may have 14 columns, but has the SQL for your prepared
>> statement got 14 parameter placeholders?
>>
>>>
>>> Please help us how to proceed further.
>>>
>>> Regards,
>>> Farzana.
>>
>> Rgds,
>> Simon
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
> --
> View this message in context:
http://www.nabble.com/sqlite3_bind_int-returns-SQLITE_RANGE-tp21788383p2
1788991.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Puneet Kishor
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


DISCLAIMER:
This message contains privileged and confidential information and is intended 
only for an individual named. If you are not the intended recipient, you should 
not disseminate, distribute, store, print, copy or deliver this message. Please 
notify the sender immediately by e-mail if you have received this e-mail by 
mistake and delete this e-mail from your system. E-mail transmission cannot be 
guaranteed to be secure or error-free as information could be intercepted, 
corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The 
sender, therefore,  does not accept liability for any errors or omissions in 
the contents of this message which arise as a result of e-mail transmission. If 
verification is required, please request a hard-copy version.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite file security

[Shibu.Narayanan]

I think the question by the original poster was about data security and
not file security.  He probably does not mind if the file is copied, but
the data should be decipherable only by his application.

-Shibu

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kees Nuyt
Sent: Thursday, November 20, 2008 2:17 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite file security

On Wed, 19 Nov 2008 12:31:22 +0530, "Satish"
<[EMAIL PROTECTED]> wrote in General Discussion of SQLite
Database :

>Hi!
>
>  
>
>I am basically a windows application developer. I am developing an
>application for desktop which uses a database. I choose SQLite as my
>database and my issue is if any one finds my application is using
SQLite
>database they can corrupt my database or they can see the contents of
my
>database using a program(they can open my SQLite file).

The SQLite database is a normal file. The only thing that
can protect it is the security the Windows filesystem
offers. With NTFS, you have fine grained control over file
access.

>  Now my question is how I can provide security to my database for
>example no one can access my database except my application .how can I
>provide security
>
>Plz provide me best solution to provide security to my database without
any
>Data loss.

Use ACL. Run the application in an account that has access
to the file, Refuse access to all other accounts.

>Regards,
>
>Satish.G
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


DISCLAIMER:
This message contains privileged and confidential information and is intended 
only for an individual named. If you are not the intended recipient, you should 
not disseminate, distribute, store, print, copy or deliver this message. Please 
notify the sender immediately by e-mail if you have received this e-mail by 
mistake and delete this e-mail from your system. E-mail transmission cannot be 
guaranteed to be secure or error-free as information could be intercepted, 
corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The 
sender, therefore,  does not accept liability for any errors or omissions in 
the contents of this message which arise as a result of e-mail transmission. If 
verification is required, please request a hard-copy version.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] export to SQL insert statements with column names

[Shibu.Narayanan]

Hi,
Is there a way to export/dump SQLite data into INSERT statements which
also have column names?

As of now, a sqlite dump looks like this

INSERT INTO "ric_tb_language" VALUES('ENG','English');
INSERT INTO "ric_tb_language" VALUES('SPN','Spanish');
INSERT INTO "ric_tb_language" VALUES('GER','German');

Is it possible to have it like below(column names included)?

INSERT INTO "ric_tb_language" (ID, language) VALUES('ENG','English');
INSERT INTO "ric_tb_language" (ID, language) VALUES('SPN','Spanish');
INSERT INTO "ric_tb_language" (ID, language) VALUES('GER','German' );

Regards
Shibu Narayanan 
Consultant, PrimeSourcing Division, Investment Banking Group 
Tel.Office: 91-80-2208-6270 or 91-80-6659-6270 
e-mail: [EMAIL PROTECTED] 
The answer is 42. 
-bin/mailman/listinfo/sqlite-users


DISCLAIMER:
This message contains privileged and confidential information and is intended 
only for an individual named. If you are not the intended recipient, you should 
not disseminate, distribute, store, print, copy or deliver this message. Please 
notify the sender immediately by e-mail if you have received this e-mail by 
mistake and delete this e-mail from your system. E-mail transmission cannot be 
guaranteed to be secure or error-free as information could be intercepted, 
corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The 
sender, therefore,  does not accept liability for any errors or omissions in 
the contents of this message which arise as a result of e-mail transmission. If 
verification is required, please request a hard-copy version.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Query to Find number of distinct records

[Shibu.Narayanan]

Try
select count(DISTINCT Name) nameCount from TableA

Shibu Narayanan 
Consultant, PrimeSourcing Division, Investment Banking Group 
Tel.Office: 91-80-2208-6270 or 91-80-6659-6270 
e-mail: [EMAIL PROTECTED] 
The answer is 42. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bharath Booshan L
Sent: Wednesday, February 27, 2008 12:35 PM
To: Discussion of SQLite Database
Subject: [sqlite] Query to Find number of distinct records

Hello All,

 This might be simple question, but am not getting the SQL query right
for
my problem.


For eg, consider following table

NonUniqueNo  Name
-
23 A
23 B
24 C
25 A
23 E


How can I find the number of people for which an entry has been recorded
in
my table?

The answer I am expecting is 4 ( i.e. A,B,C,E)

Using query "select count(DISTINCT Name) from TableA" results in an
error.

Could anyone please post a SQL query for my problem?

Thanks in advance,

Bharath 



---
Robosoft Technologies - Come home to Technology

Disclaimer: This email may contain confidential material. If you were
not an intended recipient, please notify the sender and delete all
copies. Emails to and from our network may be logged and monitored. This
email and its attachments are scanned for virus by our scanners and are
believed to be safe. However, no warranty is given that this email is
free of malicious content or virus.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


DISCLAIMER:
This message contains privileged and confidential information and is intended 
only for an individual named. If you are not the intended recipient, you should 
not disseminate, distribute, store, print, copy or deliver this message. Please 
notify the sender immediately by e-mail if you have received this e-mail by 
mistake and delete this e-mail from your system. E-mail transmission cannot be 
guaranteed to be secure or error-free as information could be intercepted, 
corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The 
sender, therefore,  does not accept liability for any errors or omissions in 
the contents of this message which arise as a result of e-mail transmission. If 
verification is required, please request a hard-copy version.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] trying to locate older version of SQLite

[Shibu.Narayanan]

Thank you Dennis.  Martin from this mailing list sent me an email
detailing the same thing.
This ticket is closed :)

Shibu Narayanan 
Consultant, PrimeSourcing Division, Investment Banking Group 
Tel.Office: 91-80-2208-6270 or 91-80-6659-6270 
e-mail: [EMAIL PROTECTED] 
The answer is 42. 


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote
Sent: Friday, February 22, 2008 9:40 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] trying to locate older version of SQLite

[EMAIL PROTECTED] wrote:
> 
> I have a website on a shared hosting which has PHP 5 installed on it.
I
> ran a test program and created a SQLite database from it.  When I
opened
> the database file, it has as its first line "This file contains an
> SQLite 2.1 database".  I am trying to download the 2.1 version of
SQLite
> from the internet(google) but unable to get any windows binary for it.
> The SQLite.org website does not carry binaries of older versions.
> 
> I also tried to search in the sqlite-users mailing list, but the site
> does not have a search option, and the messages are stored month wise,
> so I do not know whether this has been answered before on this mailing
> list.
> 
> Where can I get it?  Any help would be greatly appreciated.
> 

Older version of SQLite are aviable from the website, but there are no 
direct links on the web pages. You need to manually edit the links to 
get the file you need.

The 2.1 version of the database file implies that it was created with a 
2.X.Y version of SQLite. You should get the latest version which is 
2.8.17 (I believe).

If you go the download page http://www.sqlite.org/download.html and the 
right click on the link to download the latest Windows binary file, then

select Copy Link Location (at least using Firefox, in IE the command is 
Copy Shortcut). Now open a new tab or window and paste the link into the

address bar. You can edit the link and replace the version number with 
the version you want to download. In your case you need to change 
http://www.sqlite.org/sqlitedll-3_5_6.zip to 
http://www.sqlite.org/sqlitedll-2_8_17.zip and then press enter to start

the download.

This process can be used to get previous versions of the DLL and the 
command line shell program (and probably all other files as well).

HTH
Dennis Cote
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


DISCLAIMER:
This message contains privileged and confidential information and is intended 
only for an individual named. If you are not the intended recipient, you should 
not disseminate, distribute, store, print, copy or deliver this message. Please 
notify the sender immediately by e-mail if you have received this e-mail by 
mistake and delete this e-mail from your system. E-mail transmission cannot be 
guaranteed to be secure or error-free as information could be intercepted, 
corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The 
sender, therefore,  does not accept liability for any errors or omissions in 
the contents of this message which arise as a result of e-mail transmission. If 
verification is required, please request a hard-copy version.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] trying to locate older version of SQLite

[Shibu.Narayanan]

Hi,

I have a website on a shared hosting which has PHP 5 installed on it.  I
ran a test program and created a SQLite database from it.  When I opened
the database file, it has as its first line "This file contains an
SQLite 2.1 database".  I am trying to download the 2.1 version of SQLite
from the internet(google) but unable to get any windows binary for it.
The SQLite.org website does not carry binaries of older versions.

I also tried to search in the sqlite-users mailing list, but the site
does not have a search option, and the messages are stored month wise,
so I do not know whether this has been answered before on this mailing
list.

Where can I get it?  Any help would be greatly appreciated.

 

Shibu Narayanan 
Consultant, PrimeSourcing Division, Investment Banking Group 
Tel.Office: 91-80-2208-6270 or 91-80-6659-6270 
e-mail: [EMAIL PROTECTED]
  
The answer is 42. 

 



DISCLAIMER:
This message contains privileged and confidential information and is intended 
only for an individual named. If you are not the intended recipient, you should 
not disseminate, distribute, store, print, copy or deliver this message. Please 
notify the sender immediately by e-mail if you have received this e-mail by 
mistake and delete this e-mail from your system. E-mail transmission cannot be 
guaranteed to be secure or error-free as information could be intercepted, 
corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The 
sender, therefore,  does not accept liability for any errors or omissions in 
the contents of this message which arise as a result of e-mail transmission. If 
verification is required, please request a hard-copy version.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users