[Zope] Checkboxes/SQL data type problem

[J.H.Whalley]

Hi,

You're right: something else was wrong! Thanks to Chris Withers for 
pointing me in the right direction: it was the ZSQL method which was 
the problem. Changing it to the following made everything work:

---------------------------------------
Argument: ejournal_id:int

update new_ejournals set 
	actioned_date='<dtml-var ZopeTime fmt=%d/%m/%Y>' 
	 where  ejournal_id=<dtml-sqlvar ejournal_id type=int> 
---------------------------------------

Thanks to everyone for your help,

John Whalley


On 20 Jun 02, at 21:53, Dieter Maurer wrote:

> J.H.Whalley writes:
>  > As a complete Python newbie an example would be really useful.
>  > 
>  > I'd got the impression that using the form <input type="checkbox" >
>  name="action_list:int:list"... would make Zope realise it was dealing >
>  with a list of integers. It doesn't seem to, unfortunately.
> It does!
> 
> Something else must be wrong.
> 
> You already know the "<dtml-var REQUEST>" tip to analyse what
> you get from an HTTP summit?
> 
>   Use "showRequest" as the form action. "showRequest" is a DTML method
>   with the following content:
> 
>        <dtml-var standard_html_header>
>        <dtml-bar REQUEST>
>        <dtml-var standard_html_footer>
> 
> 
> Dieter



--
* John Whalley, Crewe Site Library, Manchester Metropolitan University
* email: J.H.Whalley@mmu.ac.uk
* Phone: (+44) 161 247 5220 (UK)
* Usual disclaimer applies...........