I've got an editor on my site and when a user edits his content I check the content in the db to see if he actually made any changes. If he did then I update the fields and if not I stop the execution and tell the user that nothing changes.
The way I do this is by calling a stored procedure and the populate a recordset with the content I then compare it via VBScript. My question is : Is it not possible to do that compare in SQL and the return a boolean flag? I can't figure out the SQL to do that and I don't know how to return calculated value (ie. true or false) from a stored proc... Only a field value.
Any help would be nice. I might just need a point in the right direction.
Regards - Jon