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.