Jquery validate file extension even after rename file

Question

I am trying to make a web application where I want to validate the file extension even after name change on File Upload Control, I did some research and found Dataview solution but it is still with some lack since I found extension doc, xls, msi with the same Header Signature. If you can help me out with this it would be great. I can't use server side code since it has to be validate before uploading file. My main Goal is to Prevent the User from Uploading the Wrong File Type on any Condition.

 

 

Answer 1

here is an example

 

you may have to change according to your table:

CREATE TRIGGER trg_Update_Qty
   ON  Stock
   AFTER UPDATE
AS
    UPDATE Stock SET Keterangag = 0 FROM inserted WHERE inserted.qty = 0 and inserted.kode_barang = Stock.kode_barang
GO

 please mark the answer as accepted if it satisfies your question

Answer 2

I assume you want to delete the data in the last column from table when qty = 0.

 

write a trigger on that table in check if qty=0, then delete data in last column i.e. set it to 0

Answer 3

you can show me example code?