// SQL statement and instance of a cursor to execute it var myStatement = 'SELECT * FROM family WHERE pic = null'; var myCursor = database.cursor(myStatement); // Iterate through the returned rows while(myCursor.next()){ // Assign 'blank.gif' in the PIC column of the returned rows myCursor.pic = blob("/pictures/blank.gif"); myCursor.updateRow("family"); } // Close the cursor and write it to the page if there was an error var dbError = myCursor.close(); if(dbError) write(myCursor.close());