[Zope] MySQL

2000-11-30 Thread K H Subrahmanyan

hi,
   I want to add MySQL to my ZOPE.

Please help me in installing it.

Please give the links, necessary information.

thanks
bye
subrahmayan.



___
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] is it possible to import from Excel

2000-12-26 Thread K H Subrahmanyan

Hello,


Now we have developed some database using gadfly in zope.
Actually there are some datum which are there in Excel. I would like to know
is it possible to import all that datum from Excel to zope database, instead
of giving all the data to zope manually.

Actually all those data are the Emp. records. Currently they are
maintaining it in Excel. Now they want to make it web based stuff. We have
developed a tool for that.
Since all that data are there in Excel I wanted some stuff to import that.
Hoping your reply.

bye
yours
subrahmanyan.


___
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 : SQL methods

2001-01-12 Thread K H Subrahmanyan

hi,

  I am using zope and gadfly for my project.
but while using the SQL methods, I get the error if I use the "like" option.

E.g..   select  *
from  table
where
 Emp_name   like   "*rama*"

I will get the following error.



 Zope Error
Zope has encountered an error while publishing this resource.
Error Type: SyntaxError
Error Value: unexpected token sequence.near :: 'est\012where \012Emp_name'*'
like "*rama*"' *** current state = 57 expects:
'HAVING', 'UNION', 'GROUP', 'VARCHAR', 'DESC', 'SELECT', 'ORDER', 'WHERE',
'AS', 'EXCEPT', '*', 'IN', 'INTERSECT', 'FLOAT', '+', '(', ')', '.', '/',
',', '-', 'AND', 'FROM', '*', ';', 'INTEGER', 'NOT', '>', 'OR', '=',
'BETWEEN', 'ASC', '<', 'VALUES', ('nomatch1',) current token = ((-8,
'user_defined_name'), 'LIKE')



kindly help
thanks
bye
subrahmanyan.


___
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] : installation of MySQL

2001-01-16 Thread K H Subrahmanyan


hi,

  I am using ZOPE in Linux.
Now I want to install MySQL to that.
I have installed MySQLDA and MySQLdb to that.
but still that is giving the following error.
kindly help me.





ZMySQLDA Import Traceback

Traceback (innermost last):
  File "/zope/zope-linux/lib/python/OFS/Application.py", line 397, in
import_products
product=__import__(pname, global_dict, global_dict, silly)
  File "/zope/zope-linux/lib/python/Products/ZMySQLDA/__init__.py", line
106, in ?
import sys, os, Globals, DA
  File "/zope/zope-linux/lib/python/Products/ZMySQLDA/DA.py", line 108, in ?
from db import DB
  File "/zope/zope-linux/lib/python/Products/ZMySQLDA/db.py", line 106, in ?
import MySQL, regex, sys
ImportError: Bad magic number in /zope/zope-linux/lib/python1.5/MySQL.pyc



___
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] : Postgre installation problem

2001-01-23 Thread K H Subrahmanyan

I have installed postgre SQL in my linux server.
I have installed ZpopyDA to my zope installation.

but when  I run the server I get the following error.

help me.
what else I have to do.
kindly give the necessary links.
thanks in advance.



ZPoPyDA Import Traceback

Traceback (innermost last):
  File "/Zope-2.2.5-linux2-x86/lib/python/OFS/Application.py", line 397, in
import_products
product=__import__(pname, global_dict, global_dict, silly)
  File "/Zope-2.2.5-linux2-x86/lib/python/Products/ZPoPyDA/__init__.py",
line 32, in ?
import sys, os, Globals, DA
  File "/Zope-2.2.5-linux2-x86/lib/python/Products/ZPoPyDA/DA.py", line 35,
in ?
from PoPy_db import DB
  File "/Zope-2.2.5-linux2-x86/lib/python/Products/ZPoPyDA/PoPy_db.py", line
35, in ?
raise "The PoPy module is not installed"
The PoPy module is not installed


___
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] : Postgre installation problem

2001-01-23 Thread K H Subrahmanyan

but where can I get Popy and how to install it.
kindly give the links.
thanks


  -Original Message-
  From: Jerome Alet [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, January 23, 2001 6:22 PM
  To: K H Subrahmanyan
  Cc: [EMAIL PROTECTED]
  Subject: Re: [zope] : Postgre installation problem
  
  
  On Tue, 23 Jan 2001, K H Subrahmanyan wrote:
  
  > I have installed postgre SQL in my linux server.
  > I have installed ZpopyDA to my zope installation.
  > 
  > but when  I run the server I get the following error.
  > 
  > ZPoPyDA Import Traceback
  > raise "The PoPy module is not installed"
  > The PoPy module is not installed
  
  This is very clear.
  
  You don't have installed the PoPy module
  
  PoPy is needed by ZPoPyDA
  
  PoPy is the layer between PostgreSQL and ZPoPyDA:
  
  PostgreSQL <--> PoPy <--> ZPoPyDA <--> Zope
  
  hoping this will help
  
  bye,
  Jerome Alet
  

___
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 : postgre sql

2001-01-23 Thread K H Subrahmanyan

I am using zope in linux redhat 6. I have installed zope2.2.5.
python version in zope is 1.5.2  I have also install python2.0

I have install postgresql 7.03

I have ZPoPyDA_0_7_tar.tar
I have used

   tar -xovf ZPoPyDA_0_7_tar.tar

it is installed in /Zope-dir/lib/python/Products/ZPoPyDA/  directory.

>>  what else I have to do in this satage.


I have PoPy_2_0_1_tar.gz
I have used gunzip PoPy_2_0_1_tar.gz
and tar  -xovf PoPy_2_0_1_tar.tar

then
cd PoPy-2.0.1
./configure
make
make install

--->>  what else I have to do here.

I have python-popy_1.2.1_i386.deb
  what to do with that.

how to install python-popy1.2.1_i386.deb.

in INSTALL file in the directory PoPy-2.0.1 , he has given as follows.


  Download PoPy's debian packages from
ftp://popy.sourceforge.net/pub/popy/debian

  and install it using:

  dpkg -i python-popy_2.0.1_.deb

if I try ftp://popy.sourceforge.net/pub/popy/debian
it fails.

what is dpkg.
if I typed as above it will say dpkg command not found.

->>  now how to install debian package.

now ignoring that error, if I run the start server,
  I will get the following error.:


ZPoPyDA Import Traceback

Traceback (innermost last):
  File "/Zope-2.2.5-linux2-x86/lib/python/OFS/Application.py", line 397, in
import_products
product=__import__(pname, global_dict, global_dict, silly)
  File "/Zope-2.2.5-linux2-x86/lib/python/Products/ZPoPyDA/__init__.py",
line 32, in ?
import sys, os, Globals, DA
  File "/Zope-2.2.5-linux2-x86/lib/python/Products/ZPoPyDA/DA.py", line 35,
in ?
from PoPy_db import DB
  File "/Zope-2.2.5-linux2-x86/lib/python/Products/ZPoPyDA/PoPy_db.py", line
35, in ?
raise "The PoPy module is not installed"
The PoPy module is not installed


what is the problem

Kindly help me.
thanks in advance.


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