Re: [sqlite] Empty all rows from table

On Wed, 13 Feb 2008 17:45:20 +1100 BareFeet <[EMAIL PROTECTED]> dijo: > > DELETE FROM worktable > > That is correct. You need a trailing semicolon though, on any command, > ie: > > delete from workTable; > > > But that just throws error messages. I tried adding the trailing semicolon:

Re: [sqlite] Sorting Japanese records

On Feb 12, 2008 9:17 PM, Mahalakshmi.m <[EMAIL PROTECTED]> wrote: > Hi, > I am working in 3.3.6 > > My database looks as follows: > "Create table MUSIC (id integer primary key,Track text);" > > I have inserted some Japanese records inside and I tried to list all the > tracks sorted by Tracks. > >

Re: [sqlite] Empty all rows from table

Hi John, > DELETE FROM worktable That is correct. You need a trailing semicolon though, on any command, ie: delete from workTable; > But that just throws error messages. What error messages? Tom BareFeet ___ sqlite-users mailing list

[sqlite] Empty all rows from table

The table I want to empty is called worktable. Can't figure how to do it with the GUI. Went to: http://www.sqlite.org/lang.html Which said the correct syntax should be DELETE FROM worktable But that just throws error messages. Surely there is a way to delete all rows from a table. What is

[sqlite] Sorting Japanese records

Hi, I am working in 3.3.6 My database looks as follows: "Create table MUSIC (id integer primary key,Track text);" I have inserted some Japanese records inside and I tried to list all the tracks sorted by Tracks. "select Tracks from MUSIC order by Track;" [ All records are

Re: [sqlite] Selecting all and some columns

"jose isaias cabrera" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > The PM is the same for the same ProjID because the split is a one to > one > assignment, so that should not happen. So, if there is a case like > this, > the PM has been set wrong. What I would like to have is a

Re: [sqlite] Selecting all and some columns

"Igor Tandetnik" wrote... > "jose isaias cabrera" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> imagine almost the same data, >> >> Class|ProjID|ProjFund|Invoice|PM|Split >> Finishers|1045|73||JIC| >> Finishers|1045|75|30|LED| >> Finishers|1045|75|30|SAN| >>

Re: [sqlite] Help for sqlite syntax

Hi Igor, Thank you very much, it working :-) Cheers, 2008/2/13, Igor Tandetnik <[EMAIL PROTECTED]>: > > "li yuqian" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL PROTECTED] > > now my sql working, but result different mysql result. > > > > sqlite> SELECT t.variable, t.value,

Re: [sqlite] Help for sqlite syntax

Hi Igor, Thanks for your kind of help :-) now my sql working, but result different mysql result. 1. mysql: --- mysql> SELECT t.variable, t.value, d.value state FROM `globals` t JOIN (SELECT x.variable, x.value FROM globals x WHERE x.variable LIKE 'OUTDISABLE\_%') d ON

Re: [sqlite] LIKE clauses with prepared statements

On Feb 12, 2008, at 3:51 PM, Igor Tandetnik wrote: > Diego Souza <[EMAIL PROTECTED]> > wrote: >> I wasn't able to figure this out. I'm trying to execute a query like >> this: >> >> SELECT columns FROM table WHERE column LIKE ? >> >> However, I'd like to use % or _ placeholders. For instance in

Re: [sqlite] LIKE clauses with prepared statements

Diego Souza <[EMAIL PROTECTED]> wrote: > I wasn't able to figure this out. I'm trying to execute a query like > this: > > SELECT columns FROM table WHERE column LIKE ? > > However, I'd like to use % or _ placeholders. For instance in the > following > code: > > sqlite3_prepare_v2(db, "SELECT

[sqlite] LIKE clauses with prepared statements

Hi there, I wasn't able to figure this out. I'm trying to execute a query like this: SELECT columns FROM table WHERE column LIKE ? However, I'd like to use % or _ placeholders. For instance in the following code: sqlite3_prepare_v2(db, "SELECT columns FROM table WHERE column LIKE ?", -1,

[sqlite] Well-Known Users of SQLite

Hi All, I was just invited to use LiveStation (http://www.livestation.com/), the LiveStation player installs sqlite3.dll. This might be why Microsoft developers are seen in the sqlite mailing list. http://www.livestation.com/news/18-livestation_showcased_at_microsoft_innova tion_day Kind

Re: [sqlite] tclsqlite3

dick128 wrote: > cannot load dll - 2nd attempt, different, tcl (protcl) > 1st attempt was with a different commerically compiled tcl and it just > exited on load of dll - no error msgs. > > tclsqlite 3.5.6 loading dll blows away tcl > (tclsqlite3.dll) > > can load other dll's and use them,such

[sqlite] tclsqlite3

cannot load dll - 2nd attempt, different, tcl (protcl) 1st attempt was with a different commerically compiled tcl and it just exited on load of dll - no error msgs. tclsqlite 3.5.6 loading dll blows away tcl (tclsqlite3.dll) can load other dll's and use them,such as tbcload161.dll that comes

[sqlite] fts2 data in a different table

Hello All, (my first post here) I have various tables which all relate to the same central object, all of them contain various pieces of information about this object. And I want to full-text-search for these objects. I.e. in my case sounds (which have tags, comments, metadata, categories,

Re: [sqlite] Igor's Emails come as NewsGroups Posts

jose isaias cabrera <[EMAIL PROTECTED]> wrote: > Aaah, my friend, I wish it was that easy. .-) You are young and have > not being touched by the "security" of the enterprise/corporate > world, yet. .-) You see, your message comes to sqlite-users as a news > post, as you can see in the first two

Re: [sqlite] Igor's Emails come as NewsGroups Posts

"Igor Tandetnik" wrote in message news:[EMAIL PROTECTED] > "jose isaias cabrera" <[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] >> why is it that your sqlite replies come as NewsGroups posts? > > I'm posting via GMane interface (www.gmane.org) > >> I can >> not reply to them

Re: [sqlite] Updatable views

I agree very much with your suggestion. Although all those vendor specific "extensions" generally make the designers and coders lives easier, the wheels tend to come off in onerous ways when a heavily extended project migration is attempted. Even when using a given vendor's product I have, based

Re: [sqlite] Help for sqlite syntax

li yuqian <[EMAIL PROTECTED]> wrote: > now i try follow sql > SELECT t.variable, t.value, ifnull(d.value, ''||'off') state FROM > globals t LEFT JOIN globals d ON (substr(t.variable,5) = > substr(d.variable,12) and t.variable LIKE 'OUT\_%' ESCAPE '\' and > d.variable LIKE 'OUTDISABLE\_%' ESCAPE

Re: [sqlite] View update performance (was: Updatable views)

Stephen Oberholtzer wrote: > > If only you'd been around when I'd posted my message! Nobody said > *anything*, so I figured nobody else cared about it. > I have been around for quite some time, but I don't recall your message. However, I do occasionally take a vacation, or get busy and just

Re: [sqlite] Updatable views

John Stanton wrote: > That ia a nice idea. To have a pragma which specied the dialect. There > could be "strict" or "ansi" and "mysql", "oracle", "sqlserver" etc etc. > It would give tighter control over hard to track annoying minor syntax > errors. > I don't think we need anything that

Re: [sqlite] Updatable views

BareFeet wrote: > > I thought I saw syntax of some other SQL engines that > permit if/then or case/when type branching within a trigger, but I may > be mistaken. > A case/when expression is just that an expression. It can appear any where an expression can be used. It can contain multiple

Re: [sqlite] Innovative examples / user stories

Hi, (Sorry, I lost original mail to reply) Mohd Radzi Ibrahim yazmış: > [snipped usage example] > > - Original Message - > From: "Lars Aronsson" <[EMAIL PROTECTED]> > To: > Sent: Tuesday, February 12, 2008 1:51 AM > Subject: [sqlite] Innovative examples / user

Re: [sqlite] Selecting all and some columns

Hi José, > I have one more ask for help, imagine almost the same data, > > Class|ProjID|ProjFund|Invoice|PM|Split > Finishers|1045|73||JIC| > Finishers|1045|75|30|LED| > Finishers|1045|75|30|SAN| > Finishers|1045|75|30|JIC| > Finishers|1045|75||ELI| > Finishers|1045|75|75|ELI|y >

Re: [sqlite] Help for sqlite syntax

Hi Igor, we want porting the FreePBX(freepbx.org) to our project www.astfin.org, Actually i don't know this substr(t.value,1,0) means :-( now i try follow sql SELECT t.variable, t.value, ifnull(d.value, ''||'off') state FROM globals t LEFT JOIN globals d ON (substr(t.variable,5) =

Re: [sqlite] Help for sqlite syntax

"li yuqian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > i follow the documents for sqlite function and change the sql to: > --- > SELECT t.variable, t.value, ifnull(d.value, > group_concat(substr(t.value,1,0),'off')) > state FROM globals t LEFT JOIN globals d ON

Re: [sqlite] Help for sqlite syntax

Hi Igor, thank you very much. i follow the documents for sqlite function and change the sql to: --- SELECT t.variable, t.value, ifnull(d.value, group_concat(substr(t.value,1,0),'off')) state FROM globals t LEFT JOIN globals d ON (substr(t.variable,5) = substr( d.variable,12) and

Re: [sqlite] Serious problem: lower/upper malfunction

It's OK, found a README... :] -- pozdrawiam / regards Zbigniew Baniewski ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Help for sqlite syntax

"li yuqian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > i tried your sql, but get a error: > - > SQL error: no such function: substring > In SQLite, it's named substr. Check the documentation to make sure it expects the same parameters as substring in MySQL

Re: [sqlite] Serious problem: lower/upper malfunction

On Mon, Feb 11, 2008 at 02:23:54PM +0100, Z.B. wrote: > > There is an icu extension to make it work with UTF-8/UTF-16 as > > far as I know. > > Is it a special extension for SQLite? Perhaps someone could tell me, how one is supposed to use an extension

Re: [sqlite] Selecting all and some columns

"jose isaias cabrera" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > imagine almost the same data, > > Class|ProjID|ProjFund|Invoice|PM|Split > Finishers|1045|73||JIC| > Finishers|1045|75|30|LED| > Finishers|1045|75|30|SAN| > Finishers|1045|75|30|JIC| > Finishers|1045|75||ELI| >

Re: [sqlite] Help for sqlite syntax

Hi Igor, Thanks for your reply. i tried your sql, but get a error: - SQL error: no such function: substring is something wrong? thanks 2008/2/12, Igor Tandetnik <[EMAIL PROTECTED]>: > > "li yuqian" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL PROTECTED] > > i am a

Re: [sqlite] Igor's Emails come as NewsGroups Posts

"jose isaias cabrera" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > why is it that your sqlite replies come as NewsGroups posts? I'm posting via GMane interface (www.gmane.org) > I can > not reply to them because my company does not allow replies to > newsgroups. I don't

Re: [sqlite] Help for sqlite syntax

"li yuqian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > i am a newbie of sqlite3, we want porting the Freepbx(freepbx.org) to > our > project www.astfin.org, the freepbx can support sqlite3, but not very > well, > now i got a problem about sqlite3 > - > SELECT

Re: [sqlite] Selecting all and some columns

Hi José, >> The benefits of normalizing increase with the amount and/or >> complexity of your data. Notice there are no case statements to get >> what you want. You just start with the table you want (Split, in >> this case) and join any needed related data, so SQLite only scans >> the

[sqlite] php connections strings

Despite over 12 years in software development, I have been able to avoid databases for a great part of that time. The real bane in my side when it comes to SQL databases is connection strings. I would like to use SQLite 3 in my PHP project, but I need some help on how to construct the connection

Re: [sqlite] Blob incremental i/o via Python

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Norman Young wrote: > Can this same interface be accessed in Python? That API has to be wrapped. > Can this be done from Python via the sqlite3 module? Can you point me to > examples? I have implemented it in APSW in the development code (ie not

Re: [sqlite] Help for sqlite syntax

I tried this, but sqlite3 show: --- SQL error: no such column: d.variable --- any idea? thanks 2008/2/12, Mohd Radzi Ibrahim <[EMAIL PROTECTED]>: > > Could you just use ORDER BY 1 ? > > best regards > -- radzi -- > - Original Message - > From: "li yuqian" <[EMAIL PROTECTED]> >