[Zope] MySQL connection string.

2001-01-20 Thread Indra Gunawan

Hello,
could anyone tell me how to make connection string to MySQL in Linux?
I use Zope 2.3 and I've tried the 

database@[host] username password

format, and still no luck,
TIA,

-IGUN-


___
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] String Module ??? newbie question

2000-08-15 Thread Indra Gunawan

Hello,
my installation is Zope 2.2.0 on W2K.
I try to use the find method as follow, why can't it runs?
dtml-var "_.find('doraemon','dora')"
it said Attribute error: find
-IGUN-


___
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] Parameter in ZSQL

2000-08-13 Thread Indra Gunawan

Hello All
here's the problem
my Zope 2.2.0 is running on win98
my Database is a MySQL

I created a ZSQL method named ShowProduct with parameter product_id

the template as follows : select * from products where sqltest product_id
type=string

why can't I call the ZSQL method directly (without using the GET/POST
variables)?
I try to call it like this

dtml-let product_id="1"
dtml-in ShowProduct
...(i would like to insert some of programs here if this is working)

/dtml-in
/dtml-let

it always returns error like this
Error Type: Bad Request
Error Value: ['product_id']

can anyone help please? is there any workaround for this?
TIA

-IGUN-
ICQ:1474584




___
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] Fw: [Zope] Parameter in ZSQL

2000-08-13 Thread Indra Gunawan


 Thanks man that really works..!!...
 I want to ask another question
 can I retrieve a random row from a table?
 if can, could anyone tell me 
 (using the same table and scheme from the previous question)
 
 Thanks again Mr Philipp Auersperg 
 
 -IGUN-
 ICQ:1474584
 
 
  call :
  dtml-in "ShowProduct(product_id=1)"
  
  with let you just define a variable in the current namespace
  
  Philipp Auersperg (zwork)
  
 
  
 


___
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] A very newbie question

2000-08-13 Thread Indra Gunawan

I need to know the value of (sequence-index mod 3)=0
in something like
dtml-if "sequence-index mod 3)=0"
how do I use the mod function correctly? since the divmod function is
actualy returning 2 pair of value.
Thanks guys.

-IGUN-
ICQ:1474584


___
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] Zope server Dies

2000-07-08 Thread Indra Gunawan

My Zope server dies miserably after I install the mysql adapter
(it still dies after I delete the adaper files manually.)
These are the only error messages I could retrieve from the server.
could anyone help me?
I use win98

Thanks
-IGUN-

asynchat.async_chat.handle_error (self)
  File "H:\Program Files\WebSite\ZServer\medusa\asyncore.py", line 321, in
hand
e_error
self.close()
  File "H:\Program Files\WebSite\ZServer\HTTPServer.py", line 356, in close
p.more() # free up resources held by producer
  File "H:\Program Files\WebSite\ZServer\Producers.py", line 108, in more
getattr(self.logger, self.method)(self.bytes)
  File "H:\Program Files\WebSite\ZServer\medusa\http_server.py", line 275,
in l
g
' - - [%s] "%s" %d %d "%s" "%s"\n' % (
  File "H:\Program Files\WebSite\ZServer\medusa\logger.py", line 243, in log
self.logger.log ('%s%s' % (ip, message))
  File "H:\Program Files\WebSite\ZServer\medusa\logger.py", line 77, in log
self.write (message)
  File "H:\Program Files\WebSite\ZServer\medusa\logger.py", line 53, in
write
self.maybe_flush()
  File "H:\Program Files\WebSite\ZServer\medusa\logger.py", line 65, in
maybe_f
ush
self.file.flush()
IOError: [Errno 9] Bad file descriptor



___
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] Zope server Dies

2000-07-08 Thread Indra Gunawan


 Have you read the how-to on http://www.zope.org/Members/philh/mysql ?
 It worked perfectly for me, except that the libmysql.dll that came with
 mySQL gave me troubles, but after replacing it with the version mentioned
in
 the how-to everything worked perfectly: Win2000, Zope 2.1.6, mySQL
 3.23.19-beta.

 Gijs Reulen
Yes..
I have read that documentation too. I've decided to reinstall the Zope, and
everything seems working perfectly now. Thanks for the assistance.
But I'm still curious what cause the previous error though.

-IGUN-


___
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 )