access databse

[johnfli]

Ok, here is something strange.

For a webpage that I have, I used to keep a list of names and email address
in a delimited text file. Then for some reason, my host company did
somethign and now my page can not read teh text file, but it can write to
it. Go figure that one.

ANyway, So I created an access database to replace teh text file and I
imported the data straight from the Text file.

Everythign looks good again.
It reads all the info from teh database perfectly.
select * from email order by fname

I go to add another name and email address via my web page and when I go
back to the page that lists everythign, it does not show the new entry.
Yet, if I open my database in Access, it is there so it saved correctly.
And if my select statement is select * from email where fname = '" John "'
order by fname

then it will display the newest entry
(Which by the way is John Doe)

ANy Idea why the new entry will not display?

[Aaron Bertrand [MVP]]

Did you hit Ctrl+Refresh when you reloaded the page? Also see
http://www.aspfaq.com/2022

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"johnfli" <jo**@here.co m> wrote in message
news:##******** ******@TK2MSFTN GP09.phx.gbl...

Ok, here is something strange.

For a webpage that I have, I used to keep a list of names and email address in a delimited text file. Then for some reason, my host company did
somethign and now my page can not read teh text file, but it can write to
it. Go figure that one.

ANyway, So I created an access database to replace teh text file and I
imported the data straight from the Text file.

Everythign looks good again.
It reads all the info from teh database perfectly.
select * from email order by fname

I go to add another name and email address via my web page and when I go
back to the page that lists everythign, it does not show the new entry.
Yet, if I open my database in Access, it is there so it saved correctly.
And if my select statement is select * from email where fname = '" John "' order by fname

then it will display the newest entry
(Which by the way is John Doe)

ANy Idea why the new entry will not display?

Also, make sure that in your Browser you go to:
IE ex.
Tools
options
under temporary internet files click settings
and select "check for newer version of stored pages every
visit to the page".
this will work.

-----Original Message-----
Did you hit Ctrl+Refresh when you reloaded the page? Also seehttp://www.aspfaq.com/2022

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"johnfli" <jo**@here.co m> wrote in message
news:##******* *******@TK2MSFT NGP09.phx.gbl.. .

Ok, here is something strange.

For a webpage that I have, I used to keep a list of names and email

address

in a delimited text file. Then for some reason, my

host company did somethign and now my page can not read teh text file, but it can write to it. Go figure that one.

ANyway, So I created an access database to replace teh text file and I imported the data straight from the Text file.

Everythign looks good again.
It reads all the info from teh database perfectly.
select * from email order by fname

I go to add another name and email address via my web page and when I go back to the page that lists everythign, it does not show the new entry.

Yet, if I open my database in Access, it is there so it saved correctly. And if my select statement is select * from email

where fname = '" John"'

order by fname

then it will display the newest entry
(Which by the way is John Doe)

ANy Idea why the new entry will not display?

.

[Johnfli]

I even tried this from a differnet computer.
So it isn't a page refresh issue.
Also, when I have it display the record count and display the first item in
the record, it duplicates the second to last record info twice.

"Aaron Bertrand [MVP]" <aa***@TRASHasp faq.com> wrote in message
news:u0******** ******@TK2MSFTN GP09.phx.gbl...

Did you hit Ctrl+Refresh when you reloaded the page? Also see
http://www.aspfaq.com/2022

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"johnfli" <jo**@here.co m> wrote in message
news:##******** ******@TK2MSFTN GP09.phx.gbl...

Ok, here is something strange.

For a webpage that I have, I used to keep a list of names and email address

in a delimited text file. Then for some reason, my host company did
somethign and now my page can not read teh text file, but it can write to it. Go figure that one.

ANyway, So I created an access database to replace teh text file and I
imported the data straight from the Text file.

Everythign looks good again.
It reads all the info from teh database perfectly.
select * from email order by fname

I go to add another name and email address via my web page and when I go
back to the page that lists everythign, it does not show the new entry.
Yet, if I open my database in Access, it is there so it saved correctly.
And if my select statement is select * from email where fname = '"

John "'

order by fname

then it will display the newest entry
(Which by the way is John Doe)

ANy Idea why the new entry will not display?

[Johnfli]

http://65.160.89.126/john/email/index.asp
There are at least 110 records, but it only shows 109.
"Aaron Bertrand [MVP]" <aa***@TRASHasp faq.com> wrote in message
news:u0******** ******@TK2MSFTN GP09.phx.gbl...

Did you hit Ctrl+Refresh when you reloaded the page? Also see
http://www.aspfaq.com/2022

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"johnfli" <jo**@here.co m> wrote in message
news:##******** ******@TK2MSFTN GP09.phx.gbl...

Ok, here is something strange.

For a webpage that I have, I used to keep a list of names and email address

in a delimited text file. Then for some reason, my host company did
somethign and now my page can not read teh text file, but it can write to it. Go figure that one.

ANyway, So I created an access database to replace teh text file and I
imported the data straight from the Text file.

Everythign looks good again.
It reads all the info from teh database perfectly.
select * from email order by fname

I go to add another name and email address via my web page and when I go
back to the page that lists everythign, it does not show the new entry.
Yet, if I open my database in Access, it is there so it saved correctly.
And if my select statement is select * from email where fname = '"

John "'

order by fname

then it will display the newest entry
(Which by the way is John Doe)

ANy Idea why the new entry will not display?

[Aaron Bertrand [MVP]]

> I even tried this from a differnet computer.

So it isn't a page refresh issue.

Did you read the whole article I sent?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

[johnfli]

Yes I read it.
I even added the code they showed

<%
pStr = "private, no-cache, must-revalidate"
Response.Expire sAbsolute = #2000-01-01#
Response.AddHea der "pragma", "no-cache"
Response.AddHea der "cache-control", pStr
%>

I even went so far as to restart the Machine that is hosting the pages.
Still it only shows the first 109 records.
If I have it sort by a differnet field, it will show the newly added
records, but then it wont show a couple of other records.


"Aaron Bertrand [MVP]" <aa***@TRASHasp faq.com> wrote in message
news:Oh******** ******@tk2msftn gp13.phx.gbl...

I even tried this from a differnet computer.
So it isn't a page refresh issue.

Did you read the whole article I sent?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

[johnfli]

When I do a response.write for the Record count, it tells me, 111.
When I take out the line that says "On error resume next"
After it displays record 109, I get an error that is complaing about EOF
being true.

If I sort it differently, it will list record 110 and 111, but it will leave
out what would be the last 2 records that are in the database.

"Aaron Bertrand [MVP]" <aa***@TRASHasp faq.com> wrote in message
news:Oh******** ******@tk2msftn gp13.phx.gbl...

I even tried this from a differnet computer.
So it isn't a page refresh issue.

Did you read the whole article I sent?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

[Aaron Bertrand - MVP]

Instead of narrating, can you show the actual code you're talking about?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/


"johnfli" <jo**@here.co m> wrote in message
news:OJ******** ******@tk2msftn gp13.phx.gbl...

When I do a response.write for the Record count, it tells me, 111.
When I take out the line that says "On error resume next"
After it displays record 109, I get an error that is complaing about EOF
being true.

If I sort it differently, it will list record 110 and 111, but it will leave out what would be the last 2 records that are in the database.

"Aaron Bertrand [MVP]" <aa***@TRASHasp faq.com> wrote in message
news:Oh******** ******@tk2msftn gp13.phx.gbl...

I even tried this from a differnet computer.
So it isn't a page refresh issue.

Did you read the whole article I sent?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

[Chris Hohmann]

"johnfli" <jo**@here.co m> wrote in message
news:OJ******** ******@tk2msftn gp13.phx.gbl...

When I do a response.write for the Record count, it tells me, 111.
When I take out the line that says "On error resume next"
After it displays record 109, I get an error that is complaing about EOF being true.

If I sort it differently, it will list record 110 and 111, but it will leave out what would be the last 2 records that are in the database.

"Aaron Bertrand [MVP]" <aa***@TRASHasp faq.com> wrote in message
news:Oh******** ******@tk2msftn gp13.phx.gbl...

I even tried this from a differnet computer.
So it isn't a page refresh issue.

Did you read the whole article I sent?

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Seems to work just fine. Note, record 111 is listed as "Jane Doe".
Similarly, record 110 is listed as "John Doe". As such, they appear in
the middle of the list. Also, please remove record 112. That was me. ;-)

HTH
-Chris Hohmann