Thanks for the pointer! This is what I did with your help:

<dtml-in sqlGetTableColumns>
<dtml-call "REQEST.set('tbldata', _.str(Field1)+':'+_.str(Field2))">
<dtml-call "sqlInsertDump(DumpCol=tbldata,User=AUTHENTICATED_USER)">
</dtml-in>

That worked perfectly! All the fields were inserted into another table, delimited by ':' for later retrieval. If the fields were null, they showed as None.

Greg

Lennart Regebro wrote:

From: "Greg" <sysman@techgroupinc.com>

Field3 and Field4 are usually NULL, but not always, so I want to capture
them as well.

Any suggestions?


Depends on what you want a "None" should be converted to. using str(Field3)
will make it return 'None', which may be wrong. Then you can use (Field3 or
''), which will return '' when Field3 is none.