-----Original Message----- From: ainis [mailto:ainis@impro.mii.lt] Sent: Thursday, July 29, 1999 5:26 AM To: zope@zope.org Subject: [Zope] importing data to mysql from zope

Well, it's easy to pass variables to ZSQL Methods and create new records in this way in database. The question is: Is there any way to pass whole data files to be imported to the database? I know "LOAD DATA bla bla bla" stuff but this is done from the mysql client. The whole point would be doing this from browser.

By whole data fields do you mean elements of an HTML list? This is quite easy. Configure a ZSQL method called 'mySQLMethod' to accept a number of arguments, let's call them 'a', 'b', and 'c'. Now create a form: <form action="insertData"> <input name="a"> <input name="b"> <input name="c"> <input type=submit value=" Click "> Then a DTML method called 'insertData' containing: <!--#call mySQLMethod--> 'mySQLMethod' will automagicly look in the namespace of the REQUEST for the values of a b and c. Since a b and c were passed into insertData in a form, it will find them there. This is equivelent to calling the ZSQL method like this: <!--#call "mySQLMethod(a=a, b=b, c=c)"--> -Michel

Any ideas?

_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope

(To receive general Zope announcements, see: http://www.zope.org/mailman/listinfo/zope-announce

For developer-specific issues, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )