[Resolved] [Resolved] Data is Not Refreshing!!

superDavecyber

I am building a web site that allows people to submit records and see records they have submitted... The problem is that it is always one step behind!!!

I bite at explaining so if you need any clarifacation let me know....

stolzyboy

clarify

superDavecyber

So I have a page that allows the person to add records. eg

1 Bob
4 Jan
3 Frank

At the end of this list they can add more...
The problem is that it is always one behind.. So when I was entering Frank all I could see was Bob

leatherback

Hi,

could you post the query which gets the data from your database, which doesn't give you the correct data?

superDavecyber

The query runs great! I have another part of the page where I can refresh and the data will show up... I've built apps in access so this isn't to far from what I've done there. I just can't get the data to refresh!!!! Do I have to send it to another page to refresh or what?? Here is the query to give you and Idea...

SELECT TblArchive.EmployeeId, TblEmployee.EmployeeFname, TblEmployee.EmployeeLname, format(TblArchive.ArchiveDate,'mm/dd/yyyy'), Tblabsreason.absreasonName, TblArchive.ArchiveAmount * -1 as expr1
FROM (TblEmployee INNER JOIN TblArchive ON TblEmployee.EmployeeId = TblArchive.EmployeeId) INNER JOIN Tblabsreason ON TblArchive.absreasonId = Tblabsreason.absreasonId
WHERE (((TblArchive.EmployeeId)=$em) AND ((TblArchive.absreasonId)<>11) AND ((TblArchive.ArchiveComitted)=No));

leatherback

hm..
Is it possible that you insert the new name AFTER you get the names from the database?

So:

Select $names from table

blablabla...

if (update)
{
insert into table () values ()
}

That would be the only explanation for me IF your query is correct. (Which it seems to be)

superDavecyber

That Was It... I never had to think about order in access... Well not with refreshing any way!! Thanks!

leatherback

Please mark the thread as resolved (Use link at bottom of page. It works a bit hesitant, you may have to press it a few times..)