[Zope] (no subject)

[McDonnell, Larry]

Hi,

Sorry, the db is broken up into the following fields are all text at a size
of 255:

released
doc_type
part_number
title_despcription
date_of_origin
file_hyperlink

The field in question is part_number. This record can be found AOP-18-01 but
this record 01-0102-0000, for example, cannot. Part_number is the primary
key. 

Again, I can see all info within Access but if I try to query from ZSQL
method I'll see the first but not the second record.
-----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 )
>  
>