Rstat wrote:
> Hi, Im building a database for my company. We are a rather small size book
> company with a lot of references and still growing.
>
> We have a Mysql database here and are trying to find some good tools to use
> it at its best. Basically we are just starting up the database after
ns failed, err = $err"
> }
> '
>
> Now select returns this goofy looking data. I've chopped off the output.
>
> \ \ set\ ver\ 7.1\r\n\r\n\ \ set\ callName\ \\\r\n\ \ \ \
> \[NamingAttributes_T\ \$ver\ \\\r\n\ \ \ \ \ \ \ \ \[NVSList_T\ \$ver\
> \\\r\n\ \
>
Th
users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
The following works for me
delete from item where rowid not in (
select rowid from item
group by type, container_id
having max(item_id)
)
Regards
Lawrence Chitty
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
denys wrote:
Hi all,
I'm trying to create a table but I always get an "assertion failed"
crash :-(
Here is the statement:
CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original
INTEGER, used INTEGER, picture TEXT, note INTEGER, comment BLOB, note
INTEGER, type INTEGER, idSpec
Ralf Junker wrote:
In risk of asking the obvious, I wonder if the following division should be
considered correct:
| Query | Result Value | Result Type| OK?
---
1 | SELECT 5 / 2; | 2| SQLITE_INTEGER | No?
DuenosEnLaWEB.com.ar wrote:
hi
I have this format for dates: mmdd
I want this format to be returned from a query: dd/mm/
The only way i have found is doing this... but i do not like it very =
much
SELECT =
strftime('%d/%m/%Y',substr('20050605',1,4)||'-'||substr('20050605',5,2)||=
Clark Christensen wrote:
Using Sqlite v3.2.5 on both Linux, and Windows, I'm having
some difficulty reconciling unixepoch seconds with other
tools. Consider this:
select strftime('%s', '2005-08-30 15:19:00');
returns 1125415140
This is the UTC time (sort of the same as GMT I think). You
[EMAIL PROTECTED] wrote:
Hello,
I'm using the TCL binding of sqlite3
One of the columns in my table has a date and time stamp, something like
this:
07/20/2004 01:35:40
06/20/2005 01:37:01
06/20/2005 12:10:07
06/20/2005 12:17:08
06/20/2005 01:35:00
If I want to get all dates that are later
Noel Frankinet wrote:
Hello,
Is there a better way to list all table making a view than parsing
SQL. Is there an API ?
You may be able to do this using the 'explain' statement
for example, I have a view called 'myview'. Wrapping this into an sql
select statement and proceeding this with
David Wheeler wrote:
On Mar 18, 2005, at 1:31 PM, Witold Czarnecki wrote:
You don't need to register. Just place the ticket:
http://www.sqlite.org/cvstrac/tktnew
I did that before, but then I received no notifications when the
ticket was updated or resolved. I'd love to get that information in
Clark Christensen wrote:
I've been agonizing over the best way to store date/time values in my
databases (perl will be the app platform).
So, my question is, true or false:, if I want to use SQLite's
date/time functions against field values, my only real option is to
store -MM-DD HH:MM:SS
Hi Anirba
your best place to ask questions on Tcl is the 'comp.lang.tcl' usenet
newsgroup (or Google groups), unless the question refers directly to the
Sqlite Tcl bindings.
Another great source of info is the Tcler's Wiki which has answers and
example code to this and hundreds of other
- Original Message -
From: "Tim McDaniel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 04, 2004 11:23 PM
Subject: [sqlite] SQL help
> Given a table T like this:
> A B
> -
> 1 5
> 2 5
> 3 5
>
> I need a query to give me just the row with
- Original Message -
From: "Downey, Shawn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 30, 2004 7:26 PM
Subject: [sqlite] complex query question
> The query should return exactly 3 records:
>
> Hoyhoy | 2 | 1 | 1
> Fred | 0 | 2 | 0
> Tony | 1 | 1 | 0
- Original Message -
From: "Cena, Resty" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 07, 2004 9:31 PM
Subject: [sqlite] Error: Can't find package sqlite
> Hi,
> I'm trying to use TclSqlite, but when I try to load sqlite with the
command:
>
> % package require
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 20, 2004 10:02 PM
Subject: [sqlite] How to handle slashes (\) in text columns
> I'm using the TCL binding of SQLITE and was trying to figure out how to
> enter various characters into a text
- Original Message -
From: "Schurack, Harald" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 19, 2004 7:51 AM
Subject: [sqlite] SQLITE DLL with TCL Bindings tclsqlite-2_8_14.zip does not
contain the right files
> Hello SQLITE users
> i downloaded the current version of
Hi
- Original Message -
From: "Frank Fabbrocino" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 24, 2004 4:22 AM
Subject: [sqlite] Date/Time as Default Value
> I would like to have a default value for a column be the current time.
This is basically a poor man's row
Hi
having recently started playing with sqlite and I am very impressed. As my
primary interest is to use it with Tcl, I'm wondering if a pre-compiled
tclsqlite.dll can be made available for release 3.0 .
I also notice that the tclsqlite.dll for 2.8.14 appears to have dissapeared
from the
19 matches
Mail list logo