[possibly OT] gadfly sql question
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?? Thanks AM -- ================================================================== 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 ==================================================================
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
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 ==================================================================
participants (2)
-
AM -
Ed Leafe