RE: [Zope] INTERBASE cannot do this type of query ?
For chuckles try 'MOUSE' instead of "MOUSE" Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Francois-regis Chalaoux Sent: Thursday, December 14, 2000 8:12 AM To: [EMAIL PROTECTED] Subject: [Zope] INTERBASE cannot do this type of query ? Sensitivity: Personal Error, Products.gvibDA.gvib.gvibExceptions.ProgrammingError: - Dynamic SQL Error -- SQL error code = -206 -- Column unknown -- MOUSE SQL used: select IND_SPECIE from ZEB_INDIVIDU where IND_SPECIE = "MOUSE" ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Problem with an INTERBASE connection
Is it sysadm or should it be sysdba as the user? _ Robert E. Tierney EMail: [EMAIL PROTECTED] Going VirtualHTTP: www.goingv.com 10800 Independence Pointe Pkwy Phone: 1-704-849-0731 x109 Matthews, NC 28105Fax: 1-704-849-2279 AIM: RETierney _ On Tue, 28 Nov 2000, Francois-regis Chalaoux wrote: > Trying to run a connection with this Database Connection String : 'C:?Program >Files?Borland?InterBase?examples?Database?employee.gdb sysadm > masterkey', I got the following error : Invalid connection string: 'C:?Program >Files?Borland?InterBase?examples?Database?employee.gdb sysadm > masterkey'. > > where is the bug!? > > FRC > > ___ > Zope maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Anyone put Images in Interbase 6 and view via Zope? (fwd)
_ Robert E. Tierney EMail: [EMAIL PROTECTED] Going VirtualHTTP: www.goingv.com 10800 Independence Pointe Pkwy Phone: 1-704-849-0731 x109 Matthews, NC 28105Fax: 1-704-849-2279 AIM: RETierney _ -- Forwarded message -- Date: Thu, 28 Sep 2000 15:15:47 -0400 (EDT) From: Bob Tierney <[EMAIL PROTECTED]> To: Brad Clements <[EMAIL PROTECTED]> Subject: Re: [Zope] Anyone put Images in Interbase 6 and view via Zope? Brad, I think I can provide some information. I have added a jpg to an interbase table and have successfuly displayed it in ZOPE. First off you may know that Interbase does not store BLOB data directly in a table's blob column. It stores the data elsewhere and then stores a "pointer" to it in the table column. This means that BLOB data MUST be inserted via program code and thus you cannot do the following in a Zope SQL Method: insert into the_table (blob_column) values (blob_data) If you are using the gvibDA you can code an external method to do this: import gvib cn = gvib.connect(...) cr = cn.cursor() cr.execute('insert into the_table (blob_column values (?)', (blob_data,)) cn.commit() cr.close() cn.close() What I did to display the JPG may or may not be legal but here is what I did. Code an external method (saveimage) to save the jpg to a temporary file. My codewas: def saveimage(ifile, idata): fout = open(ifile, 'wb') fout.write(idata) fout.close() Then I coded an SQL Method to select the blob column. My example table has one row in it. select picture from sela Then I coded a DTML Method to do the rest: Just wondering if anyone can report success or failure storing .jpgs as > blobs in Interbase and viewing same via Zope. > > Thanks > > > Brad Clements,[EMAIL PROTECTED] (315)268-1000 > http://www.murkworks.com (315)268-9812 Fax > netmeeting: ils://ils.murkworks.com AOL-IM: BKClements > > ___ > Zope maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] gvib
I forgot to mention that the 0.9.2 version contains a Windows DLL contributed by Brad Clements. Sorry about that. Regards, Bob _ Robert E. Tierney EMail: [EMAIL PROTECTED] Going VirtualHTTP: www.goingv.com 10800 Independence Pointe Pkwy Phone: 1-704-849-0731 x109 Matthews, NC 28105Fax: 1-704-849-2279 AIM: RETierney _ ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] gvib
Hello everyone! We released version 0.9.2 of the gvibDA Interbase database adapter. This version is a bug fix release. The new version can be had at http://www.zope.org/Members/RETierney/gvibDA. Thank you. Bob _ Robert E. Tierney EMail: [EMAIL PROTECTED] Going VirtualHTTP: www.goingv.com 10800 Independence Pointe Pkwy Phone: 1-704-849-0731 x109 Matthews, NC 28105Fax: 1-704-849-2279 AIM: RETierney _ ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] New Release of gvibDA Interbase Adapter
Hello Everyone, We just release Version 0.9.1 of our Interbase Database Adapter. This release fixes a memory leak when fething BLOB data and also dramtically improves performance when fetching BLOB data. Thank you and the code is at http://www.zope.org/Members/RETierney/gvibDA Regards, Bob Tierney _ Robert E. Tierney EMail: [EMAIL PROTECTED] Going VirtualHTTP: www.goingv.com 10800 Independence Pointe Pkwy Phone: 1-704-849-0731 x109 Matthews, NC 28105Fax: 1-704-849-2279 AIM: RETierney _ ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] problems connections to database
Tom, Have you tried deleting the Interbase connection object, then restarting Zope and then adding the Interbase connection object back in. It may not help but it might provide more clues as to where the problem lies. Regards, Bob _ Robert E. Tierney EMail: [EMAIL PROTECTED] Going VirtualHTTP: www.goingv.com 10800 Independence Pointe Pkwy Phone: 1-704-849-0731 x109 Matthews, NC 28105Fax: 1-704-849-2279 AIM: RETierney _ On Mon, 14 Aug 2000, Tom Deprez wrote: > Hi, > > I get a strange error here. Suddenly the connection to my interbase db > doens't works anymore. I get the following message : > > Zope Error > Zope has encountered an error while publishing this resource. > > Products.gvibDA.gvib.gvibExceptions.Error > > Sorry, a Zope error occurred. >
Re: [Zope] database functions & zope
One of the requirements of a DA is to return information about the result set columns. Does Sybase give a name to column "count(*)". Some database products do and some don't. Try giving the column an alias name like so select count(*) as total from db_table assuming Sybase supports this of course. Regards, Bob -- Robert E. Tierney[EMAIL PROTECTED] Going Virtualhttp://www.goingv.com 10800 Independence Pointe Pkwy Phone: 1-704-849-0731 x109 Matthews, NC 28105Fax: 1-704-849-2279 AOL-IM: RETierney -- On 8 Aug 2000, Stephen Nosal wrote: > Folks - > > How do I execute SQL statements such as select count(*) from db_table? > > I'm running zope 2.2 with the SybaseDA 2.0b2. My connection to the database works >fine, ie select * from small_table where amount>1000 produces a valid result set. > > Using just the DA connection test, the statement select count(*) from db_table comes >up with the error: > > Error Type: ValueError > Error Value: Empty column name, > > Any insight here would be great - I couldn't find anything documented about database >functions. > > - Steve > > > __ > Get your Private, Anti-Spam, Free Email at http://e3mil.com > and Step into a Friendly Universe! > > ___ > Zope maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )