My next project is that I like to know how to get coldfusion to recongnize duplicate entries in my database.
Now I have a page that will query the database by entering in the Asset Tag Number and then it will <CFOUTPUT> the information.
And I have another page with a form that will insert information to the database.
What I want is when someone tries to add to the ASSETTAG Number to the database, it will catch a duplicate ASSETTAG Number and send the person off to another page not allowing them to enter this information and diplaying a message like " Asset Already entered."
Can any point me in the right direction?