Code:
sql="INSERT INTO account (uin,key_id,createdate,loginname,password,status_id,srv_id,point,bill_expiry,planype_id,phonepwd,EMAIL,SockID,statussex,inviteCount,inviteFlag,pointplantype,promoGiftRedeem,realname,idnumber,gender,homephone,mobilephone,recvnews,dob,proexp,testac) VALUES ('"0"','"100001"','"2005-02-01 00:00:00"','"&UserID&"','"&password&"','"1"','"1"','"0"','"2100-01-01 00:00:00"','"2"','""','"&Email&"','"6"','"0"','"0"','"0"','"1"','"0"','"&UserName&"',''"",'"1"','""','""','""','"1"','"2100-01-01 00:00:00"','"1970-01-01 00:00:00"','""')
Trying to make this registration asp code to work , is this right please tell me. :P