Hi again, This is my zsql method. p_number:string="%" title_description:string="%" document_type="%" select * from document_control where (p_number like <dtml-sqlvar number type="string">) and (title_description like <dtml-sqlvar title_description type="string">) and (document_type like <dtml-sqlvar document_type type="string">); -----Original Message----- From: nitin@borwankar.com [mailto:nitin@borwankar.com] Sent: Friday, July 12, 2002 4:37 PM To: McDonnell, Larry Subject: Re: [Zope] (no subject) You'll have to be a little more detailed about what exactly your "Part Numbering System" is before anyone can help. As described it seems like a black box and I don't know how to help you. What you're doing is not impossible and it needs some redoing of ZSQL queries probably but I can't tell, unless I know more about the black box. Nitin Borwankar McDonnell, Larry wrote:

Hi,

I have a strange problem that I thought someone out there knows the answer. In my pilot, using Zope technology, I have been able to create a simple search engine for our company. Since I have no money (yet) for this project. I used MS Access as my DB. Mainly so the users can use the reporting tools. Each search was place in it's own table, to make thing easier for me. Everyone like what they saw but it also got them thinking and the decision was made to combine the tables into one.

Now I was dealing with test data and I would take the excel spreadsheets and import them into Access. This worked, the users could see the data from one interface. Again, I was asked to add our New Part Numbering data into this one table. Again the spreadsheet was imported and I have a total of 3000 records (stop laughing). My problem is Zope can not see the part number information. Using Z SQL Method, I can view all the old data but no part number information. I can see everything in Access but not through Zope.

To make things worst for me, before this last decision was made, I had written an Zope interface to the Part Numbering system. At the time I had 1500 part numbers that was imported (excel) into Access and I was able to view the information as well as add new records. I wrote this because I found duplicate part numbers under their filtered spreadsheet method. I have tried several different ways to import the information but I still hit the same brick wall, Any thoughts??

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://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-announce http://rd.mailshell.com/lists.zope.org/mailman/listinfo/zope-dev )