Threaded Mode | Linear Mode

n1ghtwish · 02-15-2016 04:23 AM

(02-12-2016 03:24 AM)Ben Wrote: Since the error happens after the first row... It's possible the there is some data in the next row that sphere can't handle.

Ben, thanks for the reply and that's a valid assumption. However, answer the following question regarding that...

why would the same debug message show up when I query the table with only 1 row, without the loop? simply a "db.query etc...." single line of code.

At this time, I have narrowed down the issue to ONLY MySQL queries (does not happen with execute). Also, the error only seems to appear while using the * operator inside the query... if I rewrite the function as follows, I do not get the debug errors at all and the command executes properly:

Code:

local.col = acctname

local.table = accounts

db.query "select <local.col> from <local.table>"

serv.log @Test: Querying column "<local.col>"

serv.log @Test: <eval <db.row.numrows>> rows returned.

for X 0 <eval <db.row.numrows> -1>

    serv.log @Test: Row # <eval <dlocal.x> + 1> account name is <db.row.<dlocal.x>.acctname>

endfor�

Threaded Mode \| Linear Mode Strange MySQL Behavior
Author	Message