[Zope] Compare String to Integer
Hi, I can't compare a string (pid) to an integer (brand_id); what's is wrong with my code below? pid is being passed in the URL as pid= , brand_id is an integer from a database table. Could someone help me with this so that I could make the if statement comparison work? Thanks. dtml-in getTable() OPTION VALUE=dtml-var brand_id dtml-if expr=brand_id==pidSELECTED /dtml-if / dtml-var brand_name /dtml-in getTable ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
Looked at mxODBC but it's not free and MSSQL didn't worked for me either :(. Is there some other free DB Adapter that I could use? Can I do an external method using Perl or a Python script to connect? Thanks. --- On Tue, 4/14/09, Andreas Jung li...@zopyx.com wrote: From: Andreas Jung li...@zopyx.com Subject: Re: [Zope] Database Adapter For Windows DB To: cybercruis...@yahoo.com Cc: zope@zope.org Date: Tuesday, April 14, 2009, 12:22 AM -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 13.04.2009 23:33 Uhr, Bobby wrote: Hi, I'm running Zope on a Linux box and need to connect to a Window's SQL Server machine. Which Zope's DB Adapter should I use? Thanks. mxODBC - -aj -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAknkK5gACgkQCJIWIbr9KYxwSwCeNGeygGhPPfcRtT3f1/fvRcEr sKUAoKoU8l49M4OSNhtFFaNnNYQhPvMw =tOvV -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
Thanks for the suggested reading Gary. The problem is I'm running Zope on a Linux box and Z ODBC DA only works on a Windows platform :( --- On Tue, 4/14/09, ga...@schoolteachers.co.uk ga...@schoolteachers.co.uk wrote: From: ga...@schoolteachers.co.uk ga...@schoolteachers.co.uk Subject: Re: [Zope] Database Adapter For Windows DB To: zope@zope.org Date: Tuesday, April 14, 2009, 3:17 AM Quoting Bobby cybercruis...@yahoo.com: Hi, I'm running Zope on a Linux box and need to connect to a Window's SQL Server machine. Which Zope's DB Adapter should I use? Thanks. I found this, I hope it is useful to you http://www.zope.org/Members/roberth/ZMSSQLServer Regards Garry ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
Free and OpenSource kinda go together :) Time is tough right now and Obama didn't include software licenses in his stimulus package :). The problem is I'm the only one using Zope and Linux in my company. IT are a bunch of Windows and ASP worshipers, they hate Linux and fear of supporting it because they don't know anything about it. morons! Could have saved the company thousands of dollars by going with open source instead! haha, j/k didn't meant to offend y'all Uncle Gates' cult followers/comrades out there :). So it's mxODBC or nothing at all for the Linux users? --- On Wed, 4/15/09, Andreas Jung li...@zopyx.com wrote: From: Andreas Jung li...@zopyx.com Subject: Re: [Zope] Database Adapter For Windows DB To: cybercruis...@yahoo.com Cc: zope@zope.org Date: Wednesday, April 15, 2009, 9:57 AM -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 15.04.2009 17:33 Uhr, Bobby wrote: Looked at mxODBC but it's not free and MSSQL didn't worked for me either :(. It's cheap enough, well supported and worth the mone (please no further discussions about that everything must be free :-)) Andreas -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAknmA+AACgkQCJIWIbr9KYymFwCcCejKq8Phe6kHanPgAibreOLB aVgAnRPNly09xUr4JDv9PMjOvf5aTXZs =rdnq -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Database Adapter For Windows DB
Hi, I'm running Zope on a Linux box and need to connect to a Window's SQL Server machine. Which Zope's DB Adapter should I use? Thanks. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] dtml-in pagination
Hi, I'm trying to do pagination with dtml-in; could one of you show my why i can't get the next and previous button from my code below to work? Also, i need to do view per page: 1,2,3,etc. and allow the user select the number of records displayed per page (size) as well. Thanks in advance for any advice. dtml-in getTable(table=table,order_by=order_by,sort=sort) size=10 start=0 dtml-if sequence-end tr td colspan=3 a href=?table=dtml-var tableorder_by=dtml-var order_bysort=dtml-var sortstart=dtml-var previous-sequenceprevious/a a href=?table=dtml-var tableorder_by=dtml-var order_bysort=dtml-var sortstart=dtml-var next-sequencenext/a /td /tr /dtml-if sequence-end /dtml-in ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] dtml-in pagination
Could someone point me to some documentation on how to do pagination? Thanks. --- On Tue, 4/7/09, Bobby cybercruis...@yahoo.com wrote: From: Bobby cybercruis...@yahoo.com Subject: [Zope] dtml-in pagination To: zope@zope.org Date: Tuesday, April 7, 2009, 10:58 AM Hi, I'm trying to do pagination with dtml-in; could one of you show my why i can't get the next and previous button from my code below to work? Also, i need to do view per page: 1,2,3,etc. and allow the user select the number of records displayed per page (size) as well. Thanks in advance for any advice. dtml-in getTable(table=table,order_by=order_by,sort=sort) size=10 start=0 dtml-if sequence-end tr td colspan=3 a href=?table=dtml-var tableorder_by=dtml-var order_bysort=dtml-var sortstart=dtml-var previous-sequenceprevious/a a href=?table=dtml-var tableorder_by=dtml-var order_bysort=dtml-var sortstart=dtml-var next-sequencenext/a /td /tr /dtml-if sequence-end /dtml-in ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Mod_Rewrite port 8080
Hi, I want to use mod_rewrite on Apache to redirect http://internal:80/internal to http://internal:8080/internal so that when the user request http://internal:80/internal, the Zope folder foo will be served up. I still want http://internal:80/ to stay intact so that the contents from port 80 will still be served; just the http://internal:80/internal to point to the Zope folder http://internal:8080/internal. Hope that makes sense. Could someone help me out with the syntax? Tried the syntax below but not getting desired results. Thanks! VirtualHost internal ServerName internal RewriteEngine On RewriteRule ^/(.*) http://internal:8080/VirtualHostBase/http/internal:80/internal/VirtualHostRoot/$1 [L,P] /VirtualHost ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] dtml-in
that works, thanks. --- On Wed, 4/1/09, Andreas Jung li...@zopyx.com wrote: From: Andreas Jung li...@zopyx.com Subject: Re: [Zope] dtml-in To: cybercruis...@yahoo.com Cc: zope@zope.org Date: Wednesday, April 1, 2009, 10:56 PM -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02.04.2009 5:20 Uhr, Bobby wrote: Hi, I have a variable called checkGroup where its values are the record ids that the user selected to be deleted. I have a deleteRecord method that takes two arguements, one the sql table and the record id to be deleted. The code below works fine except for when the user only select one item from the checkGroup list, I get an error string not allow in in. Any suggestions of how I could fix this? Thanks. dtml-in checkGroup dtml-let deleteItem=sequence-item dtml-var deletedRecord(table,deleteItem) /dtml-let /dtml-in Trible check that your form parameters use the ':list' directive within the NAME attributes (check with the Zope Book (docs.zope.org). - -akj -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAknURWAACgkQCJIWIbr9KYyepgCcCv5yINX6+DenO0SayWY3HnML Jo8AoOlY7ykeWzI/g2jPfklXUVy5wgIS =L0Im -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] dtml-in
Hi, I have a variable called checkGroup where its values are the record ids that the user selected to be deleted. I have a deleteRecord method that takes two arguements, one the sql table and the record id to be deleted. The code below works fine except for when the user only select one item from the checkGroup list, I get an error string not allow in in. Any suggestions of how I could fix this? Thanks. dtml-in checkGroup dtml-let deleteItem=sequence-item dtml-var deletedRecord(table,deleteItem) /dtml-let /dtml-in ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] SiteRoot Issues
Hi, I've created a SiteRoot to point to a subfolder of the root folder /subfolder. Now I can't get back to the root folder / or remove the SiteRoot entry. How do I get back to the / root folder or go back and edit/remove the SiteRoot entry that I've just did. I checked the Undo tab by my SiteRoot entry wasn't there. Thanks for any suggestions. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SiteRoot Issues
nvm, found the answer on google, will try VirtualHostMonster instead. _SUPPRESS_SITEROOT/manage btw, am I on the wrong mailing list or something? Usually, the Zope community is very responsive but I haven't been getting any responses to my emails lately...Hell! Is anyone out there? Cam you guys see me? Earth to Zope, please give me some dope back if you see this :). --- On Mon, 3/30/09, Bobby cybercruis...@yahoo.com wrote: From: Bobby cybercruis...@yahoo.com Subject: [Zope] SiteRoot Issues To: zope@zope.org Date: Monday, March 30, 2009, 10:32 AM Hi, I've created a SiteRoot to point to a subfolder of the root folder /subfolder. Now I can't get back to the root folder / or remove the SiteRoot entry. How do I get back to the / root folder or go back and edit/remove the SiteRoot entry that I've just did. I checked the Undo tab by my SiteRoot entry wasn't there. Thanks for any suggestions. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Importing .zexp files
Hi, I’ve just downloaded the ZMultiTab_0_2.zexp from http://www.zope.org/Members/dgeorgieff/zMultiTab and put it in the import folder. I can see it from the import drop down list but can’t import it. Zope says “The object ZMultiTab does not support his operation”. At first I thought it was a file permission but that wasn’t it as I could import other .zexp files from the import folder with the same permission; I’m on a linux box. Any suggestions of what might be happening here? Thanks. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Importing .zexp files
Maybe the product is broken? I can't figure it out, Zope didn't give me enough debugging info. Do any of you know of a good tab bar navigation builder tool with images included? Thanks. --- On Wed, 3/25/09, Bobby cybercruis...@yahoo.com wrote: From: Bobby cybercruis...@yahoo.com Subject: [Zope] Importing .zexp files To: zope@zope.org Date: Wednesday, March 25, 2009, 2:17 PM Hi, I’ve just downloaded the ZMultiTab_0_2.zexp from http://www.zope.org/Members/dgeorgieff/zMultiTab and put it in the import folder. I can see it from the import drop down list but can’t import it. Zope says “The object ZMultiTab does not support his operation”. At first I thought it was a file permission but that wasn’t it as I could import other .zexp files from the import folder with the same permission; I’m on a linux box. Any suggestions of what might be happening here? Thanks. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )