Returning Multiple Rows - Urgent

[jkwtek]

I have a form that has 10 "keywords" that a user can insert. When I do an update how do I return all 10 rows for this one database object even if thier are nulls. Currently it will only return the fields that were not null, but what if I ientered 5 and want to add 5 more because thier wee 10 fields when I did a add.

I have attempted to use and array on the coldfusion side and creating SQL to do it on the back. Neither works. [sig]<p>Julius<br><a href=mailto:jweems@infotek-intl.com>jweems@infotek-intl.com</a><br>"Imagination is more important than Knowledge"[/sig]

 

[wouter]

Maybe the problem lies in your database. Maybe the fields in your database currently can't contain null-value. You should alter their properties, so they can contain null-value (ie. be empty...)

Wouter [sig][/sig]