[sqlite] Fwd: query regarding sqlite

Hello, I'm trying to fetch data from database, my database contains UTF8 characters and when i'm doing so i get SQLite3.Exception: database disk image is malformed in exception. Getting SQLite3.Exception: database disk image is

[sqlite] windows 8.1 cerification - APTCA Check failed

Dear sirs, how is it possible to pass the APTCA Check test? Our Application is using .NET Framework 2.0 and .NET Framework 3.5 Kind regards Uwe Seibt -- Uwe Seibt, Dipl.-Phys. t +49 (731) 151 899-32 | @ se...@axaris.demailto:se...@axaris.de | web www.axaris.dehttp://www.axaris.de/ axaris

[sqlite] Documentation bug: CAST syntax

On http://www.sqlite.org/lang_expr.html#castexpr the text reads: A CAST expression of the form CAST(expr TO type-name) is used to convert the value of expr to a different storage class specified by type-name. Note the TO there; the expression syntax diagram

[sqlite] insert statements with user input in bash script

Ls, In a bash script I want to get some user input to be stored in a table #get the user input: echo -n 'give new value for xxx : ' read TERM NEWVALUE=$TERM # now insert into db sqlite3 $DB.sqlite insert into ga_table values (1,$NEWVALUE); but then I get an error: script.sh: line 24: ee:

Re: [sqlite] insert statements with user input in bash script

On 1/29/2014 8:27 AM, Raymond van Daelen wrote: NEWVALUE=$TERM Try single quotes: NEWVALUE='$TERM' -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] insert statements with user input in bash script

Works! Thanks. Raymond This document is strictly confidential and intended only for use by the addressee unless otherwise indicated Dr. Ir. Raymond A. J. J. van Daelen Project Manager KEYGENE N.V. Bio-Informatics P.O. Box 216 6700 AE Wageningen The Netherlands Tel. (+31) 317 46 68 66 Fax.

Re: [sqlite] insert statements with user input in bash script

On 1/29/2014 9:30 AM, Raymond van Daelen wrote: Works! However, see what happens if you type this as user input: Robert'); DROP TABLE ga_table; -- See also: http://xkcd.com/327/ -- Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] insert statements with user input in bash script

All kind of things. Tried some version of this 'sql injection' but most variants I tried just give an error, or an entry in the table with the value drop table, or a whole new database named: Robert'); ! never was the table gone. But, the scripts will be run in a quite closed environment, and

Re: [sqlite] Fwd: query regarding sqlite

Ayush Tripathi wrote: i get SQLite3.Exception: database disk image is malformed in exception. http://stackoverflow.com/questions/21403632/getting-sqlite3-exception-database-disk-image-is-malformed This is a duplicate of

Re: [sqlite] windows 8.1 cerification - APTCA Check failed

On Wed, Jan 29, 2014 at 1:21 AM, Uwe Seibt se...@axaris.de wrote: Dear sirs, how is it possible to pass the APTCA Check test? Our Application is using .NET Framework 2.0 and .NET Framework 3.5 I doubt you'll get a lot of feedback on this, as this is the SQLite mailing list not the Windows

[sqlite] Boolean and DataReader

Sorry, I have again a question about reading a sqlite db from c#. Suppose you have a simple Boolean column in a table. I want to use a .net DataReader (connected layer). My question is: Why I get a cast exception when calling the getBoolean method (solution A)? Casting the DataReader to Boolean

Re: [sqlite] Boolean and DataReader

On 1/29/2014 1:08 PM, Johnny wrote: Sorry, I have again a question about reading a sqlite db from c#. Suppose you have a simple Boolean column in a table. I want to use a .net DataReader (connected layer). My question is: Why I get a cast exception when calling the getBoolean method (solution

Re: [sqlite] pragmas in subselects?

Would the implementation of a subset of Information schema also allow the Alter table function to work in more (SQL) standard situations ? (killing two birds with one stone) http://en.wikipedia.org/wiki/Information_schema ___ sqlite-users mailing list

Re: [sqlite] Boolean and DataReader

From the db standpoint your answer is perfect and you also replied very quickly, so thank you! Just of curiosity, who is the developer team (or the support team) of sqlite software products like sqlite admin or .net data driver? I mean - from the client connection layer, how can you miss the

Re: [sqlite] pragmas in subselects?

On Jan 29, 2014, at 9:58 PM, big stone stonebi...@gmail.com wrote: (killing two birds with one stone) No. One bird only. Enhancing ‘alter table’ is another kettle of fish altogether. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Boolean and DataReader

For the sake of clarity. Now I'm using the sql browser to create a table column of type numeric Boolean. Now also my c# DataReader method getBoolean is working fine.. It correctly interprets the type Boolean defined on the sqlite db. Problem solved, I think :-) -- View this message in context:

Re: [sqlite] Boolean and DataReader

On 29 Jan 2014, at 10:19pm, Johnny cinemageddon2...@gmail.com wrote: Now I'm using the sql browser to create a table column of type numeric Boolean. No you're not. See section 1.1 of http://www.sqlite.org/datatype3.html If some application presents a boolean type to you and then it's being

Re: [sqlite] Boolean and DataReader

Simon, as I wrote before the native type is numeric. You're right about typeof showing that type, of course. But inside sqlite the dump command reads Boolean. I also confirm that the application is working, in particular the getBoolean does not throw any exception and Properly reads the value.

[sqlite] Keeping Track of Records of IDs in one table. Possible?

Greetings! I have two tables: OpenProjects and OpenJobs. OpenJobs have jobs that belong to one unique project (ProjID). OpenProjects are projects that have one project fathers a bunch of jobs. The design below is found in a localDB on the user's PC and also on a SharedDB file in a server

Re: [sqlite] Keeping Track of Records of IDs in one table. Possible?

Others on the list can give you a better advise. Mine: If you do not need id column in OpenProjects, get rid of it and make ProjID the primary key. Otherwise, create index on ProjID. Either way create index on ProjID in OpenJobs. Better, to make ProjID a foreign key in OpenJobs to refer to

Re: [sqlite] Keeping Track of Records of IDs in one table. Possible?

On 29 Jan 2014, at 10:42pm, jose isaias cabrera cabr...@wrc.xerox.com wrote: The tables are created this way: CREATE TABLE OpenProjects (id integer primary key, ProjID integer, createDnT, unique(id)); CREATE TABLE OpenJobs (id integer primary key, ProjID integer, Task, unique(id)); Thank

Re: [sqlite] Keeping Track of Records of IDs in one table. Possible?

On Wed, 29 Jan 2014 23:37:43 + Simon Slavin slav...@bigfraud.org wrote: By the way, once you have this working I would suggest (from my experience) that you change your database design a little. Instead of having a table containing just your open jobs, have a table containing all jobs,

Re: [sqlite] Keeping Track of Records of IDs in one table. Possible?

Simon Slavin wrote... On 29 Jan 2014, at 10:42pm, jose isaias cabrera cabr...@wrc.xerox.com wrote: The tables are created this way: CREATE TABLE OpenProjects (id integer primary key, ProjID integer, createDnT, unique(id)); CREATE TABLE OpenJobs (id integer primary key, ProjID integer,

Re: [sqlite] Keeping Track of Records of IDs in one table. Possible?

James K. Lowden wrote... On Wed, 29 Jan 2014 23:37:43 + Simon Slavin slav...@bigfraud.org wrote: By the way, once you have this working I would suggest (from my experience) that you change your database design a little. Instead of having a table containing just your open jobs, have a