[Zope] Re: [Psycopg] Strange Psycopg and Zope behaviours

[Federico Di Gregorio]

thank you very much for your reports. we are investigating. i'll answer
to this list when the problems will be solved.

thank you,
federico

On 03 Jul 2001 12:42:04 +0200, Paul Zwarts wrote:
> Hi all,
> 
> I've found some strange things with the ZpsycopgDA (v0.99.4)  and Zope233.
> Through several areas of my zopesite that were migrated to psycoPG I've
> notived the following:
> 
> a) It seems that a psycopg ZSQL method that dont DIRECTLY pass variables
> through the <dtml-call> does not throw an error nor does it affect the
> database. It simply does nothing which is not good.
> 
> b) <dtml-in>item:records</dtml-in> constructions dont work either. It seems
> to not be able to understand that it will decode a list through iteration.
> (no exception raised either)
> 
> c) As the adapter for SQLSession, Something causes SQLSession to generate a
> new session ID each request, which makes me guess that no insert is done on
> the SQLSessionCreate method.
> 
> Note that all of the above has worked for a year and a half with PoPy,
> though not reliably.
> 
> Can anyone offer some suggestions as to why this may be or methods to look
> at as far as debugging the code? I have pasted one of the examples where
> coding does not work:
> 
> 
> store(DTML Method):
> ...
> ...
>    <dtml-in "getPostData(transactID=transactID)">
>       <dtml-call
> "RESPONSE.redirect('https://foo.com/paymenow.p?transnr=%s&amount=%s&company=
> %s&firstname=%s&lastname=%s&address=%s&zip=%s&city=%s&state=%s&country=%s&em
> ail=%s&version=engels&currency=USD&vat=%s&method=ss' %
>              (transactID, url_quote(totalamount),
> url_quote(company),url_quote(firstname),
>               url_quote(lastname), url_quote(address), url_quote(zipcode),
>               url_quote(city), url_quote(usstate), url_quote(country),
>               url_quote(email), url_quote(vat)))">
>    </dtml-in>
> ...
> ...
> 
> The <dtml-in "getPostData(transactID=transactID)"> (among others) returns no
> data. The page returns blank instead of redirecting, and if you put text in
> various places, the code seems to execute with no results. Run the ZSQL
> method stand-alone and it works properly. What gives? Is it my coding?
> 
> 
> Thanks in advance,
> Paul Zwarts
> 
> _______________________________________________
> Psycopg mailing list
> Psycopg@lists.initd.org
> http://lists.initd.org/mailman/listinfo/psycopg



-- 
Federico Di Gregorio
MIXAD LIVE Chief of Research & Technology              fog@mixadlive.com
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
  Put a GNOME on your desktop! [http://www.gnome.org]
                                      -- brought to you by One Line Spam

_______________________________________________
Psycopg mailing list
Psycopg@lists.initd.org
http://lists.initd.org/mailman/listinfo/psycopg