[Zope] database connection in zope

ethan mindlace fremen mindlace@digicool.com
Tue, 27 Jun 2000 13:01:18 -0400


Mohideen,

The zope mailing lists are the best place to answer these sorts of
questions.
To subscribe, go to http://lists.zope.org/mailman/listinfo/zope .

In the mean time, I am forwarding this message to the list, perhaps they
can help:

Forwarded message:

hi
 thanks for your replay
 
 from the zope documentation, i cannot get  the
relevent information(datbase connection method)

 sorry for the distrub?????
 can i discuss my project wiht you
 now i discuss the my project(i,e sample project)
documentation
  i created a table in demo gadfly database (table
name is login table  and field is userid and pass)
  i have three page  and all three pages under the
MakSampleProject folder
 (1)index.html page ,it contains username field and
pass word field  and 'submit' and 'new user register'
button(i.e., two field and two button)
 if i am new user and i press the 'new user register'
button,registration page will display
 (2)registerpage.html page contains three field (i.e
username,password and confirmation) and submit button
 when you click the submit button ,at that time the
3rd page is call
 (3)fieldcheck.html page,this page contains both
validation code and insert value part code
 i have code to validate three field is not empty ,if
any one field is empty i will through the exception. 
if three field values are correct i go to write the
values in login table
 validation part is
 <dtml-if user>
 </dtml-if>
 <dtml-if pass>
 </dtml-if>
 <dtml-if confpass>
 </dtml-if>
 if any one field is empty ,just i call the
registerpage by using form acion method
 "http://localhost:8080/makhomepage/registerpage
 if all the field is not empty just i print the page
 "thnaks for registeration"
 and i goto insert the value to login table(i have no
idea about this part)
 ?there is a problem in that area i dodn't no idea
about how can i write the values in  login table
 pls help me how can i connect the database  and get
the value and give the sample

if In java 
 just write the follwing code
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 Connection con=DriverManager("Jdbc:Odbc:login","","")
 Statement stmt=con.createStatement();
 ResultSet rs= stmt.execute("slect * from login");
 ResultSetMetaData rsmd= rs.getMetaData();
 while(rs.nex())
 {
 }
 
 pls give the python sample its help for me
 
 if i am using sqlserver database, for the all above
prodecure,how can i do in sqlserver?
 
 i think,in india it is the first time to use the zope
server technology,in chennai i am first man to use the
server

waiting for reply???
bye
MAK
Precious Microtech Private Limited
Chennai-34
Phone -8210977/6
www.preciousmicrotech.com


__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/