I have an admin interface on my client's site from which he can update the prices of his products.
My problem is that is he updates the prices and one of the fields [currency format] is left blank then i cannot perform the UPDATE statement with the null value. I can set them to zero but then i have to rewrite some code in the front end of the site which i am not keen on doing right now.
this is my SQL statment with the ASP:
curWholesale = request.querystring("wholesale")
curWholesaleL = request.querystring("wholesaleL")
strSQL = "UPDATE products SET Wholesale = " & curWholesale & ",WholesaleL = " & curWholesaleL & " WHERE ID = [x]"