[Zope] Another strange problem within ZSQL Method

[McDonnell, Larry]

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 )