[toucan42]

I have a question - I am running a web query against a custom table for which many columns are NULL allowed. When I am looping the recordset in the WebQuery it seems that as soon as I encounter a NULL it stops processing that record.

Say my query is:

SELECT field1,field2,field3 FROM sometable WHERE condition = somecondition

in the WebQuery Query Result Row I am assigning the values of fields 1,2 and 3 to a string to be output to the screen:

var someString = '$WQfield[field1]' + ' some words ' + '$WQfield[field2]' + ' more words ' + '$WQfield[field3]'

If field2 is NULL - a valid data condition - field3 never shows up

Not sure if you have a tip on how to preserve NULL but also how to handle it within the WebQuery Query Result Row window?