[Zope] Checkboxes/SQL data type problem

[J.H.Whalley]

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.

Thanks,
John Whalley

On 18 Jun 02, at 23:26, Aseem Mohanty wrote:

> when you use checkboxes with the same name or for that matter similar
> names <input name="..."> in a form, the item in the REQUEST variable is a
> list or in case of Zope a list-string of the form "['a','b','c']". Write a
> python script to convert it to a list. If you need one I can give it to
> you altho I must confess I am not an expert in Python. AM
> 
> J.H.Whalley wrote:
> 
> >Hi,
> >
> >Please excuse a dumb newbie question. I've been trawling mailing list
> >archives and documentation for clues and am getting nowhere. So far I've
> >done most of what I need to do with DTML and relying on Znolk for working
> >out basic code for handling external databases, so I'm probably missing
> >something really obvious here.
> >
> >I'm using Zope 2.4.3 on NT4 connecting to Access databases via ZODBC DA.
> >
> >I'm having trouble updating a set of records in an external DB, selecting
> >the records using checkboxes on a form. Code is below.
> >
> >The form appears to be producing the expected list of integers which are
> >the record ids which need updating: if I get the results page to just
> >display action_list it comes out as [15, 18] etc.
> >
> >ActionUpdateMethod works fine when I test it with a single record number.
> >
> >The results page should iterate over the list of record ids and update
> >each record in turn.
> >
> >What actually happens is I get an error message:
> >
> >Error Type: sql.error
> >Error Value: ('22005', -3030, '[Microsoft][ODBC Microsoft Access Driver]
> >Data type mismatch in criteria expression.')
> >
> >Which looks like it isn't an integer which is getting passed via the SQL.
> >Yet as far as I can see, the list is a list of integers, the ZSQL
> >argument tells it it's an integer and the sqlvar tag tells it it's an
> >integer.
> >
> >What am I doing wrong?
> >
> >
> >Relevant code:
> >
> >Form (DTML document - extraneous stuff cut):
> >
> ><form action="ActionUpdateResult" method="post">
> >
> ><dtml-in ActionListMethod>
> ><strong>Action:</strong> <input type="checkbox"
> >name="action_list:int:list" value="<dtml-var ejournal_id>" checked>
> ></dtml-in>
> >
> ><input type="submit" value="Action selected items">
> ></form>
> >--------------------------------------------------------
> >
> >
> >ActionUpdateResult (DTML-document - results page):
> >
> ><dtml-in action_list>
> >   <dtml-call "ActionUpdateMethod(ejournal_id=_['sequence-item'])">
> ></dtml-in>
> >--------------------------------------------------------
> >
> >
> >ActionUpdateMethod (ZSQL method):
> >
> >Arguments:
> >ejournal_id:int 
> >actioned_date="<dtml-var ZopeTime fmt=%d/%m/%Y>" 
> >
> >
> >update new_ejournals set 
> >	actioned_date=<dtml-sqlvar actioned_date type=string > 
> >	 where  ejournal_id=<dtml-sqlvar ejournal_id type=int> 
> >--------------------------------------------------------
> >
> >
> >TIA for any light you can shed,
> >John Whalley
> >
> >
> >--
> >* John Whalley, Crewe Site Library, Manchester Metropolitan University *
> >email: J.H.Whalley@mmu.ac.uk * Phone: (+44) 161 247 5220 (UK) * Usual
> >disclaimer applies...........
> >
> >
> >_______________________________________________
> >Zope maillist  -  Zope@zope.org
> >http://lists.zope.org/mailman/listinfo/zope
> >**   No cross posts or HTML encoding!  **
> >(Related lists - 
> > http://lists.zope.org/mailman/listinfo/zope-announce
> > http://lists.zope.org/mailman/listinfo/zope-dev )
> >
> >
> 
> -- 
> ==================================================================
>  Aseem Mohanty							   
>  Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 
>  (R) 510 7696011 (M) 510 3014871 (O) 510 5279231		  	
> ==================================================================								
>  	
>  "I saw `cout' being shifted "Hello world" times to the left and  
>   stopped right there!!"                        -- Steve Gonedes  
> ================================================================== 
> 
> 
> 



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