[Zope] Compare String to Integer

2009-04-21 Thread Bobby

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

2009-04-15 Thread Bobby

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

2009-04-15 Thread Bobby

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

2009-04-15 Thread Bobby

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

2009-04-13 Thread Bobby

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

2009-04-07 Thread Bobby

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

2009-04-07 Thread Bobby

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

2009-04-06 Thread Bobby

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

2009-04-02 Thread Bobby
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

2009-04-01 Thread Bobby

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

2009-03-30 Thread Bobby

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

2009-03-30 Thread Bobby

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

2009-03-25 Thread Bobby

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

2009-03-25 Thread Bobby

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 )