[Zope] Re: Catalog Anything Problem

[Casey Duncan]

Bobby Mathew wrote:
> 
> Hi Ron / Casey,
> 
> Thanks for your support, I have made those changes as you guys suggested.
> Firstly i created a new catalog called prods under /learn/search/ and did
> nothing further
> secondly i kept the zsql method outside under the path /learn/search/
> called it getProdtoCatalog()
> it has this code...
> SELECT prodid as Number, Title,
> Descr || ' ' || Title as PrincipiaSearchSource,
> 'Product' as meta_type, prodid as id, Descr as summary
> FROM products
> 
> now i went within /learn/search/prods and put catalogProducts (python
> script) with this code
> for Product in container.getProdtoCatalog():
>     container.catalog_object(Product,
>     '/learn/search/prods/'+ Product.Number +'/proddetails.html')
>     print 'Product #' + Product.Number
> return printed
> 
> The moment i test this it gives me this error
> 
> Zope Error
> Zope has encountered an error while publishing this resource.
> 
> Error Type: AttributeError
> Error Value: Number

[snip]

Try Product.number, Databases often return field names in all lower case
regardless of the case specified in the SQL.

hth,
-- 
| Casey Duncan
| Kaivo, Inc.
| cduncan@kaivo.com
`------------------>