hi all,
I need to be able to flash a database with the sql def'ns I have, and it
works if I pipe my file into sqlite, but when I execute the same data as
a giant string I get no error, but the database isn't flashed.
anyone have any ideas ? Ive tried stripping out newlines, all whitespace
reduced to single spaces etc etc ...
--
Dave Harrison
Nullcube da**@nullcube.com http://www.nullcube.com 2 1785
Dave Harrison wrote: I need to be able to flash a database with the sql def'ns I have, and it works if I pipe my file into sqlite, but when I execute the same data as a giant string I get no error, but the database isn't flashed.
anyone have any ideas ? Ive tried stripping out newlines, all whitespace reduced to single spaces etc etc ...
Did you commit() before closing the connection?
Peter
On Sun, 28 Mar 2004 21:59:35 +1000,
Dave Harrison <da**@nullcube.com> wrote: I need to be able to flash a database with the sql def'ns I have, and it works if I pipe my file into sqlite, but when I execute the same data as a giant string I get no error, but the database isn't flashed.
anyone have any ideas ? Ive tried stripping out newlines, all whitespace reduced to single spaces etc etc ...
Is there a final newline on the string?
Regards,
Heather
--
Heather Coppersmith
That's not right; that's not even wrong. -- Wolfgang Pauli This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Martin Maney |
last post by:
Apologies if this isn't news here - I've been too busy this last week
or so for even skimming the traffic here, in part because I've been
messing around with Ubuntu's preview release on a spare machine... and,
of course, spending time on their very busy mailing list. :-) I didn't
find any mention of Ubuntu in a quick scan of recent messages,...
|
by: F. GEIGER |
last post by:
I've troubles to let my app take off using pysqlite.
What I wonder most for now is that "pysqlite2.dbapi2.OperationalError:
cannot commit transaction - SQL statements in progress" when I do this:
t = time.time()
n = len(self)
while len(self):
del self
self.commit()
|
by: F. GEIGER |
last post by:
In my wxPython-app a part of it gathers data, when a button is pressed, and
stores it into a db.
The GUI part should display the stuff being stored in the db.
When both parts work on the same connection, I get "SQL statements in
progress errors". Seems ok to me, you can't do that.
So, next step: Both parts get a separate connection. Now...
|
by: Rob Cowie |
last post by:
Hi all,
I'm having difficulty installing pysqlite 2.1.3 on Mac OS X 10.4.4
There are some notes on the pysqlite wiki regarding modification of the
setup.py script and I've followed them to no avail.
Build and install appear to go smoothly but attempting to run the tests
from the python interpreter fails. Likewise any attempt to utilise...
|
by: DurumDara |
last post by:
Hi !
I have this code in my program. Before this I use APSW, but that
project's connection object doesn't have close method...
.... crs.execute(*'''create table files
(*f_id integer not null primary key, f_name varchar(255), f_size long,
f_attr integer, f_crtime varchar(20), f_mdtime varchar(20), f_hash long
)*''') ......
| |
by: Thomas |
last post by:
Hi there!
Installing TurboGears out-of-the-box (egg-based) on Windows doesn't
work because I can't
compile the extensions needed for the required pysqlite (also egg-
based):
Installed c:\programme\python24\lib\site-packages\turbogears-1.0.1-
py2.4.egg
Processing dependencies for TurboGears>=1.0
|
by: Nader Emami |
last post by:
I have installed "TurboGears" and I would install 'pysqlite' also. I am
a user on a Linux machine. If I try to install the 'pysqlite' with
'easy_install' tool I get the next error message. The error message is
longer than what I send here.
% easy_install pysqlite
Searching for pysqlite
Reading http://cheeseshop.python.org/pypi/pysqlite/...
|
by: =?ISO-8859-1?Q?Gerhard_H=E4ring?= |
last post by:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
pysqlite 2.5.0 released
=======================
I'm pleased to announce the availability of pysqlite 2.5.0. This is
a release with major new features.
Go to http://pysqlite.org/ for downloads, online documentation and
|
by: Tilman Kispersky |
last post by:
I am trying to install sqlite for use with python on cygwin. I have
installed the sqlite packages from cygwin (that is libsqlite3-devel
and libsqlite3_0). When attempting to easy_install pysqlite I get:
$ easy_install pysqlite
Searching for pysqlite
Reading http://pypi.python.org/simple/pysqlite/
Reading http://pysqlite.org/
Reading...
|
by: Kurda Yon |
last post by:
Hi,
I try to "build" and "install" pysqlite? After I type "python setup.py
build" I get a lot of error messages? The first error is "src/
connection.h:33:21: error: sqlite3.h: No such file or directory". So,
I assume that the absence of the "sqlite3.h" is the origin of the
problem.
I found on the web, that this file should be either in...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |