Hi, This is my Pilot project using Zope for my company. I am using MS Access2000 on both machines as well as Windows2000 Pro.

...

Have you tried submitting these same queries directly to the database outside of Zope? Yes I can do the same search from Access.

The kicker is all the employees will be looking up part numbers by the first six digits. If this died on the seventh I would have never known. -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Casey Duncan Sent: Wednesday, July 17, 2002 9:03 AM To: McDonnell, Larry; 'Zope@Zope. Org' (E-mail) Subject: Re: [Zope] Another strange problem within ZSQL Method What database are you using? Have you tried submitting these same queries directly to the database outside of Zope?

From what I see in the message, this looks like a problem with the database backend. Is it the same version as on the PC, and is it configured the same?

What is a Zope Pilot? -Casey On Wednesday 17 July 2002 08:01 am, McDonnell, Larry wrote:

Hi,

I use my pc as the development platform for my Zope pilot. Everything works on my PC. Since this is a pilot, I have the main Zope server on an older machine. After coping over the db and exporting/import the programs I notice a strange problem. I wrote basically a search engine. I started to test this new installation. I noticed that I was not able to retrieve a part number using a wild card. I open the zsql method and started to test. If I entered the following I can see part number inofrmation:

part_num 54%

As I added more of the variable I was limiting the search and it worked. Until I inputed the following 54-070% worked but 54-0700% :

The sql statement is as follows:

select * from document_control where (part_num like '54-0700%') and (document_type like 'Numbering');

This did not work and does not until I put the whole number 54-0700-0001.

Process Owner Originator Posted Location Y Numbering 54-0700-0001 pes01387.asm panel, rear filter housing A promain1/Current Master\Drawings\54-0700-0001_rev_a.pdf S. Balcezak SQL used: select * from document_control where (part_num like '54-0700-0001') and (document_type like 'Numbering');

Any ideas?? Thanks.

Larry McDonnell

Proton Energy Systems 50 Inwood Rd. Rocky Hill, CT 06067 (860) 571-6533 ext. 531 Email:lmcdonnell@protonenergy.com www.protonenergy.com

_______________________________________________ Zope maillist - Zope@zope.org 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 - Zope@zope.org 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 )