I have a strange one. I've modified one of my sites so that instead of an integer as the primary key, I now have a varchar and set up my URLs so that they will be more search engine friendly. For example, www.domainname.com/products/sample-product-code/

The problem is that in the admin area that I have created to manage the products, when I have my edit or delete pages, I get a SQL error, usually like this:

Unknown column 'sample' in 'where clause'

This would be if the primary key were "sample-product-code". It's like it truncates the text at the dashes. I don't have any trouble with any of the other DW server behaviors and if I remove the Delete File Before Update/Record code, it's fine. But for file management, I really want to keep this in there. I'm 99% sure the query for the Delete behavior just needs to be modified, but I have no idea how (if I were that good at PHP, I wouldn't bother with extensions <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> )

Any suggestions?

Thanks

-Bill