Re: [sqlite] Problems compiling php 5.0.3 with sqlite3

On Wed, 26 Jan 2005 00:21:52 +0100, José Miguel López Coronado <[EMAIL PROTECTED]> wrote: > Hello everybody. > I'm trying to compile php 5.0.3 using the > --with-sqlite=/usr/local/sqlite/lib option among some others and I > obtain the following error code: > checking whether to enable UTF-8

Re: [sqlite] SQLite 3.1.0 Column Names

Steve, Well, you forced me to download v3.1 (;-). I confirmed your results in the SQLite shell; I think it's a bug. Also, there are some typos in the docs: the section on short_column-names is labeled full_column_names, and there are words missing from both sections. I think probably someone

Re: [sqlite] SQLite 3.1.0 Group By problem

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > Hi All, > > First, Thank you for excellent piece of software! > I am finding following problem would like to share: > --- > SELECT a FROM [table] GROUP BY a; > Error Message in Sqlite 3.1.0 alpha: "SQL error: GROUP BY may only be used

Re: [sqlite] SQLite 3.1.0 Group By problem

> SELECT a FROM [table] GROUP BY a; > Error Message in Sqlite 3.1.0 alpha: "SQL error: GROUP BY may only be > used on aggregate queries" > ... Hope this can be fixed. The behavior in 3.1 is correct. It makes no sense to write 'select c from t group by c'. If you want to get distinct values of c,

[sqlite] SQLite 3.1.0 Group By problem

Hi All, First, Thank you for excellent piece of software! I am finding following problem would like to share: --- SELECT a FROM [table] GROUP BY a; Error Message in Sqlite 3.1.0 alpha: "SQL error: GROUP BY may only be used on aggregate queries" --- I test this sql in

Re: [sqlite] How to create and uses a stored procedure for Sqlite

Dennis Do you have an example on how to do this? Steve Dennis Cote wrote: Steve Frierdich wrote: Anyone know of any links or have example on how to create a stored procedure and how to use that stored procedure in code on a sqlite database? Thanks Steve As someone pointed out earlier, SQLite does

Re: [sqlite] one SQL statement that will insert a new row in a table if a certain string is not found in a column?

On Tue, 2005-01-25 at 09:05 -0700, Dennis Cote wrote: > [REPLACE] works as long as the column containing the string you want to > search > for is the primary key of the table (like user above). If the primary key > doesn't exist, it does an insert. If it does, it replaces that row with the >

[sqlite] INSERT OR REPLACE INTO or REPLACE INTO does work

I was incorrect REPLACE INTO is working as stated in the sqlite reference. Sorry about that. Steve Steve Frierdich wrote: I tried using REPLACE INTO in an sql statement that was suppose to insert a user into a table if the user did not already in the table and it did not work. The error was

Re: [sqlite] embedded TCL and sqlite in one app

FYI: for those interested.. >> Re: Schema change error when using sqlite >> with TCL as a macro language inside an >> application that already has an open db I took a look at the code (tclsqlite.c) and saw I could easily change it to support passing in a pointer to an existing database

[sqlite] INSERT OR REPLACE INTO or REPLACE INTO does not work

I tried using REPLACE INTO in an sql statement that was suppose to insert a user into a table if the user did not already in the table and it did not work. The error was SQL error? In the sqlite document it states that REPLACE INTO is an alias for INSERT OR REPLACE. Any one know why this

Re: [sqlite] CHECKING fOR A STRING IN A COLUMN IN A TABLE AND IF STRING IS NOT IN THE COLUMN ADD IT

Try the UNIQUE keyword when creating your table.. On Tue, 25 Jan 2005 09:34:53 -0500, Steve Frierdich <[EMAIL PROTECTED]> wrote: > Does anyone have any code they can send me that shows how to check for a > string in a column in a table, and if the string is not there on how to > insert the

RE: [sqlite] SQLite 3.1.0 Column Names

Kurt, Apologies. I believe I have also tried: Exec("PRAGMA full_column_names=1;") Steve -Original Message- From: Drew, Stephen Sent: Tuesday, January 25, 2005 4:33 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] SQLite 3.1.0 Column Names Kurt, Thanks for the reply. Assume my

RE: [sqlite] SQLite 3.1.0 Column Names

Kurt, Thanks for the reply. Assume my pseudo-calls below do the following: Open: calls sqlite3_open Exec: calls sqlite3_exec Query: calls sqlite3_prepare, sqlite3_step, ..., sqlite3_finalize Close: calls sqlite3_close And check return values of these functions. I am doing

Re: [sqlite] Are there any links on how to use a stored procedure in Sqllite

Steve Frierdich said: > Is there any reference on links on how to used a stored procedure in > sqlite/ The lack of links is directly related to the level of support for Stored Procedures. Simply put, they aren't available, except for functions that you write in C that are tied specifically to

Re: [sqlite] SQLite 3.1.0 Column Names

> PRAGMA full_column_names; > > PRAGMA short_column_names; Did you really set them, or just query them? : PRAGMA full_column_names; PRAGMA full_column_names = 0|1; Query or change the short-column-names flag. ... Regards

Re: [sqlite] one SQL statement that will insert a new row in a table if a certain string is not found in a column?

Steve Frierdich wrote: Is there a way to write one SQL statement that will insert a new row in a table if a certain string is not found in a column in that same table? Instead of having two write two SQL statements where one checks to see if a user in a table, and the other that either updates the

[sqlite] Are there any links on how to use a stored procedure in Sqllite

Is there any reference on links on how to used a stored procedure in sqlite/ Thanks Steve

[sqlite] one SQL statement that will insert a new row in a table if a certain string is not found in a column?

Is there a way to write one SQL statement that will insert a new row in a table if a certain string is not found in a column in that same table? Instead of having two write two SQL statements where one checks to see if a user in a table, and the other that either updates the current user if

Re: [sqlite] CHECKING fOR A STRING IN A COLUMN IN A TABLE AND IF STRING IS NOT IN THE COLUMN ADD IT

Oh thought maybe there was a trigger I could use to this operation for me. Thanks for your input. Steve Mrs. Brisby wrote: On Tue, 2005-01-25 at 09:34 -0500, Steve Frierdich wrote: Does anyone have any code they can send me that shows how to check for a string in a column in a table, and if

Re: [sqlite] CHECKING fOR A STRING IN A COLUMN IN A TABLE AND IF STRING IS NOT IN THE COLUMN ADD IT

On Tue, 2005-01-25 at 09:34 -0500, Steve Frierdich wrote: > Does anyone have any code they can send me that shows how to check for a > string in a column in a table, and if the string is not there on how to > insert the string in the column in the table in a new row. Then finally > on how to

[sqlite] CHECKING fOR A STRING IN A COLUMN IN A TABLE AND IF STRING IS NOT IN THE COLUMN ADD IT

Does anyone have any code they can send me that shows how to check for a string in a column in a table, and if the string is not there on how to insert the string in the column in the table in a new row. Then finally on how to update the table? And if possible on how to maybe write a trigger

[sqlite] SQLite 3.1.0 Column Names

Hello,   I have two tables:   "CREATE TABLE A (a_col TEXT, PRIMARY KEY (a_col))" "CREATE TABLE B (b_col TEXT, a_col TEXT, PRIMARY KEY (b_col))" I am trying to test the column names returned by the following query: SELECT A.*, B.* FROM A, B WHERE A.a_col = B.a_col Now whether or not I have

[sqlite] How to make a text widget hidden?

Hi all, I need to store some values in a hidden text widget which is in a frame in tcl so that I can use those values to perform some mathematical operations when I click on the submit button. My problem is that I cannot make a text widget hidden. I am giving below the text widget code which I