Creating dynamic database queries

[Tomas Schertel]

Hi there.

Is there someone creating queries dynamically?
I have a jquery crud table (jtable.org) that shows password filed blank when I click to edit a table row.
If I don't want to change user's password, I leave this field empty. But this way, my update query sets a blank password (web.input.password == "") for this user.
An "if password" solves my problem, but what can I do if an unchecked check box from this form is not sent to my program (web.input.checkbox doesn't exists)?
How can I include and exclude fields in my query dynamically?

Sorry if I couldn't make myself clear enough.

[Tomas Schertel]

I've created a workaround to solve this.
I'm not sure it's the cleaner nor cleverest way to get it working, but it worked. :)