[Zope] Passing information from a form to an SQL method via a DTML methodd

[Phil Harris]

Hi Peter,

OK, I'll give you an example.

DTML Document called doc_dtml, has a form with three fields called a,b,c
respectively.

<!--#var standard_html_header-->
<form action="act_dtml">
<table>
<tr><th align=left>A</th><td><input type=text name=a></td></tr>
<tr><th align=left>B</th><td><input type=text name=b></td></tr>
<tr><th align=left>C</th><td><input type=text name=c></td></tr>
<tr><td></td><td><input type=submit></td></tr>
</table>
</form>
<!--#var standard_html_footer-->

DTML Document called act_dtml which calls a SQL Method to update/insert a
database.

<!--#var standard_html_header-->
<dtml-call "dbupdate(a=a,b=b,c=c)">
Thank you for you interest.
<!--#var standard_html_footer-->

SQL Method called dbupdate (you are better off setting the parameters entry
box to 'a:string b:string c:string')

insert into test values(
<dtml-sqlvar a type=string>,
<dtml-sqlvar b type=string>,
<dtml-sqlvar c type=string>)

Once you run these three objects starting with doc_dtml you will have
updated your db.

HTH

Phil
phil@philh.org


-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Peter
Whysall
Sent: Monday, September 27, 1999 2:01 PM
To: 'zope@zope.org'
Subject: [Zope] Passing information from a form to an SQL method via a
DTML methodd


I'm getting stuck with this.

I have a DTML document, doc.dtml, with a form whose action, act.dtml, tells
the user "thank you very much, please call again" and runs an SQL method,
new.sql, which inserts data from fields a,b,c (from doc.dtml) into the MySQL
database.

Obviously it's not working, else I wouldn't be writing this :)

What I want to know is this: how do I perform the following tasks (I've had
a look in the DTML user's guide and can't find anything to help me):

1. Pass data as an attribute/property/parameter from a DTML document to a
DTML method and hence to a ZSQL method. Do I need to set up some variables,
populate them with my data, and pass them to the DTML method which then
passes them to the SQL method?
2. Glean data from a query and pass that too (example. We know who the
logged in user is, via AUTHENTICATED_USER.name; this is a key in the USERS
table in the database and I want to look up the user_id and insert that, not
the textual name)
3. Pass the current date/time; I can get it, like this: <dtml-var ZopeTime
fmt="rfc822">. How do I squizz this along to the query?

Alternatively, am I completely missing the point here?

Many thanks in advance

Peter.

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