[Zope] [possibly OT] gadfly sql question

[Ed Leafe]

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