Hi all.

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

__________________
- mega
Aspiring JavaScript Ninja

You could try:

SELECT False AS isEdited FROM myTable WHERE myField1 = 'userValue1' AND myField2 = 'userValue2' AND myField3 = 'userValue3'

If the recordset is .EOF, then no records matched, so the user has made changes. If the recordset is not .EOF then the user hasn't made changes. As far as I know, Access does not support output parameters, so you can't just return a true/false value.

Cheers
Ken

www.adOpenStatic.com