Re: [Zope] strange behaviour of ZSQL methods
> At 15:30 29.11.2000, Oliver Bleutgen wrote: >>You didn't tell what SQL-Database you use, but Postgres and Mysql allow >>logging/monitoring of the queries they get. So you are able to get the >>information straight before/while it hits the backend. > Yes, I'm using Postgres - just discovered the "-o"-flag, but I don't know > exactly how to log all SQL-queries right now. Guess, I'll read a bit in > the > Postgres book and the manpages. Perhaps this spares some time, digged out of my .bash_history, a relic from LoginManager experiments (really handy there...). First stop postgres and then ... /usr/local/pgsql/bin/pg_ctl -o "-i -d 3" -D /var/lib/pgsql/data start (YMMV with the path etc...) This logs everything to the console. You can vary the debugging level, 3 is a bit "vocal", try 2. cheers, oliver ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] strange behaviour of ZSQL methods
How about: -steve > "Oliver" == Oliver Bleutgen <[EMAIL PROTECTED]> writes: >> Hi listies, >> something strange is happening with my ZSQL methods. I have a >> huge query that works great when testing it in the >> management-interface - it returns about 10 records or so. but >> when I implement it into a dtml-method getting the parameters >> via X-Y-GMX: $flush REQUEST as usual, I am getting the whole >> database in return. I'm quite sure that it's my own fault, so >> I'd like to see the translated SQL-query in the dtml-method to >> check for the wrong fields. Is there a tag for it like: >> ? Oliver> You didn't tell what SQL-Database you use, but Postgres Oliver> and Mysql allow logging/monitoring of the queries they Oliver> get. So you are able to get the information straight Oliver> before/while it hits the backend. Oliver> cheers, oliver Oliver> ___ Zope Oliver> maillist - [EMAIL PROTECTED] Oliver> http://lists.zope.org/mailman/listinfo/zope ** No cross Oliver> posts or HTML encoding! ** (Related lists - Oliver> http://lists.zope.org/mailman/listinfo/zope-announce Oliver> http://lists.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] strange behaviour of ZSQL methods
> Hi listies, > something strange is happening with my ZSQL methods. I have a huge query > that works great when testing it in the management-interface - it returns > about 10 records or so. > but when I implement it into a dtml-method getting the parameters via > X-Y-GMX: $flush > REQUEST as usual, I am getting the whole database in return. > I'm quite sure that it's my own fault, so I'd like to see the translated > SQL-query in the dtml-method to check for the wrong fields. Is there a tag > for it like: ? You didn't tell what SQL-Database you use, but Postgres and Mysql allow logging/monitoring of the queries they get. So you are able to get the information straight before/while it hits the backend. cheers, oliver ___ Zope maillist - [EMAIL PROTECTED] 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] strange behaviour of ZSQL methods
Hi listies, something strange is happening with my ZSQL methods. I have a huge query that works great when testing it in the management-interface - it returns about 10 records or so. but when I implement it into a dtml-method getting the parameters via X-Y-GMX: $flush REQUEST as usual, I am getting the whole database in return. I'm quite sure that it's my own fault, so I'd like to see the translated SQL-query in the dtml-method to check for the wrong fields. Is there a tag for it like: ? This problem drives me nuts since already two days :-(( Martin ___ Zope maillist - [EMAIL PROTECTED] 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 )