I'm trying to figure out how to bind parameters by name (:VVV or @VVV or
$VVV ) using the DBI Perl module. I can't find any examples.
All the bind_param methods look like they want a param num ($p_num).
Maybe some %attr's need to be set?
I want to be able to use SQL like this:
$sql =
6:03 PM, Bill McCormick wrote:
What is the easiest way to return a text field with double () quotes?
SELECT quote(text_field) FROM table; is close, but I'd rather have a
SELECT double_quote(text_field) FROM table;
I'm not sure I understand the nature of the problem. What's wrong with
simply
What is the easiest way to return a text field with double () quotes?
SELECT quote(text_field) FROM table; is close, but I'd rather have a
SELECT double_quote(text_field) FROM table;
Thanks!!
___
sqlite-users mailing list
sqlite-users@sqlite.org
I need to develop a light-weight, custom property editor using SQLite,
Perl, thttpd and HTML/CSS for building and editing recipes. I'm thinking
of something like the classic folder/tree/property sheet interface and
it will (obviously) run in a web browser
I suppose I could use XML as well,
Is there no way to force columns added to a table with alter table to be
added at certain column positions?
Alternatively, if there is some way to save the data in an existing
table; drop the table; re-create the table with the desired schema; and
then reload the data, this would be useful as
Gerry Snyder wrote, On 2/6/2012 9:48 AM:
On 2/6/2012 8:36 AM, Bill McCormick wrote:
Is there no way to force columns added to a table with alter table to
be added at certain column positions?
Alternatively, if there is some way to save the data in an existing
table; drop the table; re-create
Nico Williams wrote, On 2/6/2012 12:44 PM:
On Mon, Feb 6, 2012 at 9:36 AM, Bill McCormickwpmccorm...@gmail.com wrote:
Is there no way to force columns added to a table with alter table to be
added at certain column positions?
Alternatively, if there is some way to save the data in an existing
Does SQLite have FIRST and LAST aggregate function?
I don't see it in the docs, but I thought I might ask anyway. Or maybe
someone out there knows a slick way to do this:
Anyway, it would be sort of like MIN MAX, but would return the first
and last values of the requested field over a
Mr. Puneet Kishor wrote, On 2/2/2012 9:57 AM:
On Feb 2, 2012, at 9:46 AM, Petite Abeille wrote:
On Feb 2, 2012, at 4:37 PM, Bill McCormick wrote:
Does SQLite have FIRST and LAST aggregate function?
No, sadly, SQLite doesn't support any analytic functions (aka window function
Igor Tandetnik wrote, On 2/2/2012 10:50 AM:
Petite Abeillepetite.abei...@gmail.com wrote:
On Feb 2, 2012, at 5:26 PM, Igor Tandetnik wrote:
ORDER BY applies to groups, not to rows within each group (is this different
with Oracle?)
analytic functions works in term of the result set itself.
In the following statement ...
my $dbh = DBI-connect(dbi:SQLite:dbname=$dbfile,,) or croak
$DBI::errstr;
if $dbfile does not exist, it is created. I would like to croak if this
happens.
Is there some option for this?
Thanks!!
___
From the sqlite command line interface, the .output command will output
the result of a query to a file.
How can I do this from a Perl script? I'm not finding any built-in
facility to do this in the Perl module.
I found this
(http://members.toast.net/strycher/perl/example_dbi_sql.htm), but
Where exactly to I put the PRAGMA journal_mode=WAL; line?
Either I have some incorrect version or don't understand how to use this:
#include sqlite3.h
int main(int argc, char** argv)
{
sqlite3 *db;
PRAGMA journal_mode=WAL;
...
gcc -g -Wall -lrt -I.. -I../../include -I../ini-parse
Simon Slavin wrote, On 1/31/2012 8:34 AM:
On 31 Jan 2012, at 2:32pm, Bill McCormick wrote:
Where exactly to I put the PRAGMA journal_mode=WAL; line?
You execute it as a SQL command, the same way you'd execute an INSERT command.
You only need to do it once for the database file. The setting
Larry Brasfield wrote, On 1/31/2012 8:40 AM:
Either I have some incorrect version or don't understand how to use
this:
#include sqlite3.h
int main(int argc, char** argv)
{
sqlite3 *db;
PRAGMA journal_mode=WAL;
...
gcc
[various errors]
The PRAGMA is something you pass
Larry Brasfield wrote, On 1/31/2012 11:36 AM:
Bill McCormick wrote:
PRAGMA journal_mode=WAL;
...
So when I run an update command (to update some arbitrary record) from
the sqlite3 command line, do I need to do something to do a checkpoint?
By checkpoint, I presume you mean some
Darren Duncan wrote, On 1/27/2012 1:41 AM:
Puneet Kishor wrote:
On Jan 26, 2012, at 2:53 PM, Bill McCormick wrote:
Puneet Kishor wrote, On 1/26/2012 12:02 PM:
$ cpanm DBD::SQLite
there is no step two
Actually, that's not correct. In my case it took the following:
Step 1: cpan DBI
Step 2
I have a date stored in a numeric field like this: 2012-01-27 16:47:50.
I want to update the date using the date function, like this:
update table set TIME_STAMP = date('TIME_STAMP', '+ 2 years');
Reference: http://www.sqlite.org/lang_datefunc.html
I also tried this:
update table set
Bill McCormick wrote, On 1/27/2012 12:12 PM:
I have a date stored in a numeric field like this: 2012-01-27 16:47:50.
I want to update the date using the date function, like this:
update table set TIME_STAMP = date('TIME_STAMP', '+ 2 years');
Reference: http://www.sqlite.org/lang_datefunc.html
I need to get going with Perl SQLite and I'm wondering what I need to
get off CPAN, if anything.
Here's what I think I have now:
root@fiberio:/etc/cron.daily# locate perl | grep SQLite
/usr/share/perl/5.10.1/CPANPLUS/Internals/Source/SQLite
Puneet Kishor wrote, On 1/26/2012 12:02 PM:
On Jan 26, 2012, at 11:59 AM, Bill McCormick wrote:
I need to get going with Perl SQLite and I'm wondering what I need to get off
CPAN, if anything.
$ cpanm DBD::SQLite
there is no step two
Actually, that's not correct. In my case it took
Puneet Kishor wrote, On 1/26/2012 3:01 PM:
On Jan 26, 2012, at 2:53 PM, Bill McCormick wrote:
Puneet Kishor wrote, On 1/26/2012 12:02 PM:
On Jan 26, 2012, at 11:59 AM, Bill McCormick wrote:
I need to get going with Perl SQLite and I'm wondering what I need to get
off CPAN, if anything
The documentation I see for the sqlite3_bind_text 5th argument (a
destructor used to dispose of the BLOB or string after SQLite has
finished with it) isn't clear:
1. I assume the string that we're talking about here is the 3rd
argument (const char*)
2. What will be void* argument be to the
Stephan Beal wrote, On 1/25/2012 11:01 AM:
On Wed, Jan 25, 2012 at 5:45 PM, Bill McCormickwpmccorm...@gmail.comwrote:
2. What will be void* argument be to the destructor?
3. What void* should the destructor return?
int sqlite3_bind_text(sqlite3_stmt*, int, const char*, int n,
Stephan Beal wrote, On 1/25/2012 11:36 AM:
On Wed, Jan 25, 2012 at 6:33 PM, Bill McCormickwpmccorm...@gmail.comwrote:
http://www.sqlite.org/**capi3ref.html#sqlite3_bind_**blobhttp://www.sqlite.org/capi3ref.html#sqlite3_bind_blob
Ha! That's the full description that left me with my questions in
Pavel Ivanov wrote, On 1/17/2012 9:42 AM:
I attempted all of the above and the call stacks do not change. That leads
me to one of two conclusions:
1. The call stacks are inaccurate
2. There is some side effect which is causing malloc to be called inside
of a procedure which should not be
What happens if my application fails to call sqlite3_close() before it
exits? Does it leave the db in some unknown state or open to corruption?
If I have a daemon type program, will I need to catch signals that try
to close/kill the program and call sqlite3_close() before exiting?
Thanks!!
I'm trying to write a function with a sig like this:
int BindParameter(sqlite3_stmt* stmt, int sqlType, const char* pname,
char* value);
Somewhere before the call(s) to BindParameter, I'll have a string that
looks like this:
(FOO=some text value, BAR=3.141, ZIP=45, TIMESTAMP1=01/17/12
David Garfield wrote, On 1/17/2012 7:05 PM:
I believe the secret is: don't bother.
sqlite does type conversion as needed, so you can just pass the strings
you've parsed out of your larger string to sqlite3_bind_text().
Excellent! Exactly what I was looking for.
If the issue is that you need
Is tcl the only scripting interface for SQLite? I'm just wondering what
the options are.
I'm trying to write a script to setup my database on new systems (create
the db, add tables, etc.), but I don't have much experience using Tcl.
My fist attempt is not going so well and I'm not finding
James Pearson wrote, On 1/16/2012 12:28 PM:
If it's just for setting up databases, tables, etc, why not just use a
sql script?
Throw all your database object creation sql into a file and then
execute that file from within sqlite using the .read FILE command.
I think this is what I'm looking
Stephan Beal wrote, On 1/16/2012 12:15 PM:
On Mon, Jan 16, 2012 at 7:12 PM, Bill McCormickwpmccorm...@gmail.comwrote:
Is tcl the only scripting interface for SQLite? I'm just wondering what
the options are.
There are few scripting languages which don't have an sqlite3 binding. Just
to name
Oliver Peters wrote, On 1/16/2012 1:02 PM:
Am 16.01.2012 19:59, schrieb Bill McCormick:
James Pearson wrote, On 1/16/2012 12:28 PM:
If it's just for setting up databases, tables, etc, why not just use a
sql script?
Throw all your database object creation sql into a file and then
execute
Simon Slavin wrote, On 1/16/2012 1:45 PM:
On 16 Jan 2012, at 7:34pm, Bill McCormick wrote:
Looks like pipes work as well (cat yoursql.sql|sqlite3 yourdb.db3).
Also, can I safely delete the database file (yourdb.db3, using your example) if
I just want to start again? It appears that I can
I'm looking for an example c program makefile for compiling and linking
in the SQLite lib to gcc compiled programs.
I'm not sure which lib to include between libsqlite.so.0 and
libsqlite3.so.0 and what options I should pass to gcc.
Where is this documented?
Thanks!!
-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Bill McCormick [wpmccorm...@gmail.com]
Sent: Sunday, January 15, 2012 2:23 PM
To: sqlite-users@sqlite.org
Subject: EXT :[sqlite] makefile for c
I'm looking for an example c program makefile for compiling and linking
in the SQLite
Tim Streater wrote, On 1/15/2012 3:00 PM:
On 15 Jan 2012 at 20:44, Bill McCormickwpmccorm...@gmail.com wrote:
What is the problem with the shared lib stuff?
Thanks!!
Black, Michael (IS) wrote, On 1/15/2012 2:27 PM:
A simple one -- and please compile sqlite3.c into your program and make
37 matches
Mail list logo