Problem with Edit and view

This topic is locked

Problem with Edit and view	7/24/2008 12:29:57 PM
ASPRunnerPro General questions
W wisdom2009 author Hi, I created a databases where user can add different kind of request, if the requestor add a request an chose my name, I will receive an email with all the data entered, if they chose another name, the chosen one will receive an email with the data, everything is find and work, when I update the request the request receive an email about the changes, so far everything work good. But when someone else add a new request for me of anyone else, when I click on view I can see only the first request added, if there a new request added for the other agent they can't update because when they click on that request that was reassigned to them, the first request show up, if I delete everything from database and asked to add request, I will be only to update the first one. Is this is a bug? Please help me to solve the problem.


W	wisdom2009 author 7/25/2008
	Hi, I just figure out what was happening. When an agent add a case, there is a field called creation date, the creation date by default pick up the date was created function NOW(), after the agent create the case and can view the case, when I looked at the date it was showing it as Date Time by default time was 12:00:00 AM, when someone else create case same day I can only view and edit the first one created, I tried to create a case and just change the current date to future date and I was able to updated, so what I did I change the creation date on the add page as Date time so it will automatically showing the correct time and will be a unique case. Thank you all. Hicham