Re: [Zope-DB] windows 2003 and sql server 2000
Hi, shahrzad khorrami wrote: Is there any body to know that what is the problem with windows 2003 and sql server 2000 ?I can't setup sql server2000 in windows 2003 ! Your question is off-topic for this list (they are both M$ products, after all), but FYI SQL Server needs to have service pack(s) applied (don't recall to which level) to work under Windows Server 2003. You should be able to install it, but you should not start it until you have service-packed it. -- Regards, PhilK Say what you mean. Bear witness. Iterate. —John M. Ford ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] A web based rewards management system for [EMAIL PROTECTED]
Hi Bob, Since this is somewhat off topic for this list, I have replied to Philip directly, cc'ing yourself. Bottom line: Implementing something like this with Plone and some RDBMS integration should be relatively simple. For my own part, I think that the RDBMS route has advantages over a pure Plone route (hey, that's why I'm on this list!), but it's important to acknowledge that others would disagree. -- Regards, PhilK Human language continually changes, innit. - Stephen Juan ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Accessing ZSQL Method properties
Hi All, I'd like to throw a warning in my application when a record-set is truncated (e.g. if the ZSQL Method has a Maximum Rows to Retrieve value lower than the size of the record-set). In a Script(Python), what is the syntax to access this value? FWIW, I've been trying to work this out from the 2.7 Zope Book, but the section in the docs tails off with the plaintive comment XXX where is that??... -- Regards, PhilK Email: [EMAIL PROTECTED] PGP Public key: http://www.xfr.co.uk Voicemail Facsimile: 07092 070518 You'll find that one part's sweet and one part's tart: say where the sweetness and the sourness start. - Tony Harrison ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Suggestions If Any Please ! ! ! ! !
Hi Rajesh, Rajesh wrote: I'm Having problem in Zsql Method ,which return recordset dictionary,containing key--.value pairs, this recordset returns only 1000 records ,Even if my Sql query satisfies more than 1000 records , Looking forward for suggestions/alternatives Look at the Advanced tab of your ZSQL method - there is a property there called Maximum rows to retrieve which is limiting your result set size. The default is 1,000 - you need to identify an appropriate value. Please don't send HTML mail with graphics to the list - plain text only, please. -- Regards, PhilK Email: [EMAIL PROTECTED] PGP Public key: http://www.xfr.co.uk Voicemail Facsimile: 07092 070518 You'll find that one part's sweet and one part's tart: say where the sweetness and the sourness start. - Tony Harrison ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] ZODBCDA
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Carlos, Carlos A. Micucci wrote: I have a problem with ZODBCDA. When query a DB which instances have a null values, this values return as cero values (0) not nulls values, and this is a problem for me, because I need differentiate them. In my opinion, it's a serious error. There is somebody who know the solution? ZODBCDA is obsolete and unmaintained - unless you are using a /really/ old version of Zope, you are likely to encounter much more serious problems than this. There is another free ODBC adapter (for Windows only) at: - http://www.zope.org/Members/timmorgan/products/ZODBCDA/document_view There is also an ADO adapter: - http://sourceforge.net/projects/zadoda/ YMMV - I have not tried these, and both are early versions. Finally there is the commercial eGenix product at: - http://www.zope.org/Members/lemburg/mxODBC_Zope_DA I /have/ worked with this one - on fact I earn my living with it, in effect. Recommended. HTH! - -- Regards, PhilK Email: [EMAIL PROTECTED] / Voicemail Facsimile: 07092 070518 Never increase, beyond what is necessary, the number of entities required to explain anything --- William of Ockham (1285-1349) -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (MingW32) iD8DBQFCjhgWuk+q3Pfz3LYRAmtRAJ996Zg8WQfAteyqOkvLXBlVnc79DQCePQc1 AOawgCkXSCz9Y58jf/4F/M8= =lNzr -END PGP SIGNATURE- ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db