is into my own custom
validator and keeping it external?
Thanks in advance,
Ray
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment -
On Tue, Aug 11, 2009 at 01:12:08PM -0700, Ray Van Dolson wrote:
> Using sqlobject 0.9.9 with pymssql 1.0.1 on RHEL 5.3 (the
> aforementioned have been installed with yum via either the base OS
> packaeges or EPEL).
Egg on my face. This appears to be a known issue with pymssql 1.0.1.
Upg
HERE
((SystemsInfo.SystemName) = is some funky unprintable characters and
certainly not the name of the system...
Other queries seem to show the same thing happening... strings I am
providing to sqlobject are getting transmitted as gibberish even thoug
explanation. I've filed a bug and am following your
suggestion of declaring my columns explicitly. All is well for now. :)
Ray
-
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build t
On Mon, Jul 21, 2008 at 05:31:24PM -0700, Ray Van Dolson wrote:
> Hi all, I'm running into an exception trying to create a new row in a
> table with fromDatabase = True defined (the table is pre-existing).
Hmm, I am guessing the note right above this:
http://www.sqlobject.org/SQL
when I turn on SQL debugging I see that the INSERT
query includes SystemName twice. In the first version, there is only
one occurence of SystemName, but it is not at the beginning of the
query making me think somehow sqlobject doesn't know I am specifying
the primary key via the function argument.
efined a connection for SQLObject to
use until after the class definition. Moving the connection stuff
abouve my SQLObject class resolves the issue.
Sorry for the noise; hopefully someone else finds this useful someday.
:)
Ray
---
to my
class? The above appears to be in line with most of the examples I've
come across.
This is with SQLObject 0.9.2 and MySQLdb 1.2.1.
Thanks!
Ray
-
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
fferent connection objects when you use each instance of the
object.
You'll obviously have to save a connection object for each sqlite
database you have.
I found reply I made to a similar question here:
http://sourceforge.net/mailarchive/message.php?msg_id=44F63826.2030700%40nscus.com
Regar
Ray Smith wrote:
> Ray Smith
> http://RaymondSmith.org
I know it's a trivial problem, but at 4:30am I typed
http://RaymondSmith.org instead of http://RaymondSmith.com.
Just wanted to acknowledge my error in case the Raymond Smith from
RaymondSmith.org comes to visit the mailing li
to 2 different databases each of which had a table name the same.
The table schemas though were different.
Regards,
Ray Smith
http://RaymondSmith.org
-
Using Tomcat but need to do more? Need to support web services, security?
Quoting MichaelG <[EMAIL PROTECTED]>:
Oleg,
Being dense, and having fought with this a while now, can you provide a
very brief example of \\\"pass a connection object to an every method\\\" in
this case Ray presents of two databases? I am sure there is a very
clean python
Quoting Oleg Broytmann <[EMAIL PROTECTED]>:
> > On Thu, Aug 24, 2006 at 09:30:42AM +1000, Ray Smith wrote:
>> >> Is it possible to connect to 2 databases each of which have a common
>> >> table name??
> >
> >It is. I have a program
Sorry for the extra \\\"\\\"\\\'s.
Attaching programs incase anyone wants to run them.
Thanks,
Ray
from sqlobject import *
class Test(SQLObject):
desc=StringCol()from sqlobject import *
class Test(SQLObject):
desc=StringCol()#
# test sqlobject for 2 databases with
7;sqlite:/d|/tmp/test1.db\')
if os.path.exists(\'c:test2.db\'):
os.unlink(\'d:test2.db\')
con2=connectionForURI(\'sqlite:/d|/tmp/test2.db\')
import1.Test.createTable(connection=con1)
import2.Test.createTable(connection=con2)
con1.close()
con
t.)
Oleg.
Thanks Oleg,
I added a:
dbconnection.TheURIOpener.cachedURIs={}
before opening the new connection and everything works great.
Thanks for all your help. It is very much appreciated.
Regards,
Ray Smith
---
This SF.Net email is
LObject-0.7.0-py2.4.egg\sqlobject\dbconnection.py",
line 261, in releaseConnection
conn.commit()
pysqlite2.dbapi2.ProgrammingError: Cannot operate on a closed database.
Execution finished.
---
Any help is very much appreciated.
Thanks,
Ray Smith
---
hon I'm running.
Note: I started using straight SQLite (which is still really nice) but using
SQLOject has simplified code and increased robustness. It's a nice library ;)
Any help very much appreciated.
Thanks,
Ray Smith
---
T
18 matches
Mail list logo
