Had a question on printing search results,
to a network printer?
what command would I use for this?
TKS -
Richard
Cory Nelson wrote:
3.0.8, and I'm using sqlite3_bind_text16 to give the string.
On Thu, 27 Jan 2005 14:31:04 -0800, Will Leshner <[EMAIL PROTECTED]> wrote:
On Thu, 27 Jan 2005 13:59:45 -0800, Cory Nelson <[EMAIL PROTECTED]> wrote:
Are there some limitations in SQLite's Unicode support?
I'm
I am trying to install SQlite3.0.8 on Solaris 9 Sparc. I have no issues when
configuring, but when I try to make I get errors (see below.) I am using gcc
3.2.4 and the GNU ld, as, ETC. I have tried using both /usr/ccs/bin/make and
the GNU make. Help!
Thanks!
M
P.S. I don't know if it has
--- Brass Tilde <[EMAIL PROTECTED]> wrote:
> > I'm new to SQL, and SQLite, and I find myself needing
> to
> > identify duplicate records in a SQLite table (there are
> > about 2K duplicates in a 36K row table). Any
> suggestions
> > or magic SQL queries appreciated :-)
>
> Here are a couple of
--- Klint Gore <[EMAIL PROTECTED]> wrote:
> On Wed, 26 Jan 2005 21:25:19 -0500, "D. Richard Hipp"
> <[EMAIL PROTECTED]> wrote:
> > On Wed, 2005-01-26 at 17:45 -0800, Clark Christensen
> wrote:
> > > I'm new to SQL, and SQLite, and I find myself needing
> to
> > > identify duplicate records in a SQ
3.0.8, and I'm using sqlite3_bind_text16 to give the string.
On Thu, 27 Jan 2005 14:31:04 -0800, Will Leshner <[EMAIL PROTECTED]> wrote:
> On Thu, 27 Jan 2005 13:59:45 -0800, Cory Nelson <[EMAIL PROTECTED]> wrote:
> > Are there some limitations in SQLite's Unicode support?
> >
> > I'm trying to s
On Thu, 27 Jan 2005 13:59:45 -0800, Cory Nelson <[EMAIL PROTECTED]> wrote:
> Are there some limitations in SQLite's Unicode support?
>
> I'm trying to select some rows that contain Japanese in them. It
> seems that when I do "where value='ãã'" I get no results. But with
> "where value like '%ãã%
Are there some limitations in SQLite's Unicode support?
I'm trying to select some rows that contain Japanese in them. It
seems that when I do "where value='ãã'" I get no results. But with
"where value like '%ãã%'", it returns results. This happens when
value is an exact match! Doesn't happen w
Drew, Stephen said:
> Yet Starteam (version control system) is still interfering with the file
> - causing unexpected errors while the application is running. Is this
> because the locking in Windows is below-par in comparison with the Unix
> locking? The thing is that Starteam is not even inter
"Dennis Cote" <[EMAIL PROTECTED]> writes:
> The Makefile generated does not contain the -DNDEBUG flag.
Richard already answered your primary question. Just for explanation, though,
defining NDEBUG *turns off* assert() statements. Think of the NDEBUG macro to
mean "No DEBUG".
NAME
asser
teoh <[EMAIL PROTECTED]> writes:
> does that mean. i just create "timedate int" in sql.
> and use unixepox to store the date+time inside it.
> and query it using unixepox for range ?
Yes, approximately. Note that the specified type is unimportant here. In the
following example, I use "TIMESTA
Hello,
I'm using SQLite 2.8.15
on Windows 2000, and am still getting the error mentioned in the subject
line. It was my understanding that once my application had opened the
database, nothing else could touch it
Yet Starteam (version
control system) is still interfering with the fil
Another possibility is to store dates as strings in ISO8601 format:
'20041220'
'20050114'
The conversion is simple (doesn't need epoch functions), and the strings
compare the same as dates. It doesn't give you a way to compute the
difference between two dates, but does let you select a range.
-
On Thu, 2005-01-27 at 10:34 -0700, Dennis Cote wrote:
> Hi,
>
> I'm trying to track down a crash in SQLite 3.1a. I have built a debug
> version using
>
> ./sqlite/configure --enable-debug
>
> The Makefile generated does not contain the -DNDEBUG flag. When I use the
> explain command to dump an
Hi,
I'm trying to track down a crash in SQLite 3.1a. I have built a debug
version using
./sqlite/configure --enable-debug
The Makefile generated does not contain the -DNDEBUG flag. When I use the
explain command to dump an SQL statement, I get the additional comments in
the explain output.
My
Look into the pragmas for querying the database schema:
http://www.sqlite.org/pragma.html
In particular, you want "pragma table_info(tablename)"
Your code is trying to determine which column is the primary key. That
information is in the results of table_info (though not the ordering of the
colu
does that mean. i just create "timedate int" in sql.
and use unixepox to store the date+time inside it.
and query it using unixepox for range ?
select * from table1 where timedate >=
unixepox_number1 and timedate <= unixepox_number2;
is this correct? thank you.
--- [EMAIL PROTECTED] wrote:
I made a little python code below that fetches a sqlite3 table description
(using apsw) but it won't work when the table is empty. ÂI made it tell me
the table is empty in this case. Â
Is there a way to get the columns in a table without having to parse the SQL
that created the table, when the
teoh <[EMAIL PROTECTED]> writes:
> does anyone knows algorithm use to quote date range?
> let say, user wants to quote for result from
> 20-12-2004 until 14-1-2005 ?(dd-mm-)
This page contains all of the information about supported date and time
functions in SQLite:
http://www.sqlite.o
Have you considered using the date functionality supported by SQLite?
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
-Original Message-
From: teoh [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 4:22 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] sqlite search by
hi, i created
date_year smallint,date_month smallint, date_day
smallint, time text in sqlite database.
does anyone knows algorithm use to quote date range?
let say, user wants to quote for result from
20-12-2004 until 14-1-2005 ?(dd-mm-)
thank you for clarifying.
On Thu, Jan 27, 2005 at 03:35:27PM +0530, Anirban Sarkar wrote:
> How can I set the maximum length of a text entry widget in TCL?
> I am giving the code below where I want to implement this.
> I want to set the maximum length of the text widget .f2.t1 to 50 characters
>
...
> Any help will be hig
> I'm new to SQL, and SQLite, and I find myself needing to
> identify duplicate records in a SQLite table (there are
> about 2K duplicates in a 36K row table). Any suggestions
> or magic SQL queries appreciated :-)
Here are a couple of strategies I've used successfully for finding and
potentially
How can I set the maximum length of a text entry widget in TCL?
I am giving the code below where I want to implement this.
I want to set the maximum length of the text widget .f2.t1 to 50 characters
CODE:
label .f2.l1 -text "Name" -font $fnt9
place .f2.l1 -x 0 -y 25
text .f2.t1 -bd 1 -highli
Hi Ulrik,
I've finally reolved the problem in the way you suggested:
1- Open the file with the database directly
2- Use "SELECT sql FROM sqlite_master" to store all SQL commands that
create the tables
3- Close the database
4- Open a :memory: database
5- Execute all SQL querys stored in pass 2 to c
25 matches
Mail list logo