[Zope] [possibly OT] gadfly sql question

[AM]

Nope I still get the same error. thanks anyway.
AM

Ed Leafe wrote:

> On Tuesday, February 4, 2003, at 03:14  PM, AM wrote:
>
>> I have a zsql method with the following query:
>>
>> update data set down_count = down_count + 1
>>
>> now down_count is in the table data in a gadfly db and is defined as 
>> an int.
>>
>> However on testing this gives "cannot add int to string" error. It 
>> does consider the digit 1 to be an int. So what am I doing wrong > 
>> here??
>
>
>     Should work, but I've never worked with gadfly. What if you try 
> qualifying the field names:
>
>     update data set data.down_count = data.down_count + 1
>
>      ___/
>     /
>    __/
>   /
>  ____/
>  Ed Leafe
>  http://leafe.com/
>  http://opentech.leafe.com
>
>
>

-- 
==================================================================
 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  
==================================================================