[Zope] dtml-let and MySQL

Marc DANAI mdanaii@yahoo.com
Mon, 20 Mar 2000 02:08:02 -0800 (PST)


Hi,

  I've tried to write one generic SQL method and
passing argument to my SQL method using dtml-let but I
got KeyError. I've tried it with dtml-with also but
same thing. 

In my page I use:

<dtml-let curpage=total>
  <dtml-call hitinsert>
</dtml-let>

and MySQL method is:

update zp_stat 
set <dtml-var curpage>  = <dtml-var curpage> + 1

What I want to do, is passing mySQL argument and 
using one method. Ex:

<dtml-let curpage=astro>
	<dtml-call hitinsert>
</dtml-let>

total and astro are INT in my SQL table.

I dont know if dtml-let is a right way?

Any suggestion to do this?

Thank's




__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com