var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: update statement
I need to update a table. Everything is a variable. The total number of fields in that table can vary and what those fields are, can also vary.
I need to take the value from each field in that table and run it through a udf if that field is not NULL.
I have to write a single update statement for the following:
For Each fldLoop In rs.Fields
strResult = dbo.mudf0_ProperCase(fldLoop.Value)
rs.Fields(fldLoop.Name) = strResult
Here rs is a recordset that contains everything from a table strTable.
Please suggest how this can be accomplished.
Last edited by archnam; 09-15-03 at 16:36.