From: "Dike" <[EMAIL PROTECTED]> Err, mo tanya lagi nih... Ane punya table dengan nama "test" kayak di bawah misalnya, cuman ada problem soalnya ada yang isi fieldnya NULL, mo di rubah nggak bisa nih, ada yang tau nggak gimana ngeupdatenya? +---------------------+------------+ | Date | UserID | +---------------------+------------+ | 11/24/00 8:32:33 AM | NULL | | 11/22/00 7:25:26 AM | NULL | | 11/22/00 7:39:07 AM | NULL | | 11/24/00 9:21:52 AM | 0000000007 | | 11/24/00 9:33:04 AM | 0000000008 | +---------------------+------------+ Yang udah di coba dan nggak bisa : update test set UserID='0000000000' where UserID=(NULL); update test set UserID='0000000000' where UserID='NULL'; update test set UserID='0000000000' where UserID="NULL"; update test set UserID='0000000000' where UserID=type(NULL); update test set UserID='0000000000' where UserID=''; update test set UserID='0000000000' where UserID=; etc.. belon ada yang berhasil nih :( TIA, Dike -- Compu-Mania MailingList, provided by PT Centrin Utama Unsubscribe: [EMAIL PROTECTED], body: unsubscribe Compu-Mania Archive: http://www.mail-archive.com/[email protected]/ Info: [EMAIL PROTECTED], body: help
