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]]

Re: access databse

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" <john@here.co m> wrote in message
news:##VDG7evDH A.2352@TK2MSFTN GP09.phx.gbl...[color=blue]
> Ok, here is something strange.
>
> For a webpage that I have, I used to keep a list of names and email[/color]
address[color=blue]
> 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[/color]
"'[color=blue]
> 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?
>
>[/color]

[Guest]

Re: access databse

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.


[color=blue]
>-----Original Message-----
>Did you hit Ctrl+Refresh when you reloaded the page?[/color]
Also see[color=blue]
>http://www.aspfaq.com/2022
>
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>
>
>
>"johnfli" <john@here.co m> wrote in message
>news:##VDG7evD HA.2352@TK2MSFT NGP09.phx.gbl.. .[color=green]
>> Ok, here is something strange.
>>
>> For a webpage that I have, I used to keep a list of[/color][/color]
names and email[color=blue]
>address[color=green]
>> in a delimited text file. Then for some reason, my[/color][/color]
host company did[color=blue][color=green]
>> somethign and now my page can not read teh text file,[/color][/color]
but it can write to[color=blue][color=green]
>> it. Go figure that one.
>>
>> ANyway, So I created an access database to replace teh[/color][/color]
text file and I[color=blue][color=green]
>> 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[/color][/color]
page and when I go[color=blue][color=green]
>> back to the page that lists everythign, it does not[/color][/color]
show the new entry.[color=blue][color=green]
>>
>>
>> Yet, if I open my database in Access, it is there so it[/color][/color]
saved correctly.[color=blue][color=green]
>> And if my select statement is select * from email[/color][/color]
where fname = '" John[color=blue]
>"'[color=green]
>> 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?
>>
>>[/color]
>
>
>.
>[/color]

[Johnfli]

Re: access databse

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]" <aaron@TRASHasp faq.com> wrote in message
news:u08TsfgvDH A.2540@TK2MSFTN GP09.phx.gbl...[color=blue]
> 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" <john@here.co m> wrote in message
> news:##VDG7evDH A.2352@TK2MSFTN GP09.phx.gbl...[color=green]
> > Ok, here is something strange.
> >
> > For a webpage that I have, I used to keep a list of names and email[/color]
> address[color=green]
> > 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[/color][/color]
to[color=blue][color=green]
> > 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 = '"[/color][/color]
John[color=blue]
> "'[color=green]
> > 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?
> >
> >[/color]
>
>[/color]

[Johnfli]

Re: access databse

http://65.160.89.126/john/email/index.asp

There are at least 110 records, but it only shows 109.


"Aaron Bertrand [MVP]" <aaron@TRASHasp faq.com> wrote in message
news:u08TsfgvDH A.2540@TK2MSFTN GP09.phx.gbl...[color=blue]
> 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" <john@here.co m> wrote in message
> news:##VDG7evDH A.2352@TK2MSFTN GP09.phx.gbl...[color=green]
> > Ok, here is something strange.
> >
> > For a webpage that I have, I used to keep a list of names and email[/color]
> address[color=green]
> > 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[/color][/color]
to[color=blue][color=green]
> > 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 = '"[/color][/color]
John[color=blue]
> "'[color=green]
> > 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?
> >
> >[/color]
>
>[/color]

[Aaron Bertrand [MVP]]

Re: access databse

> I even tried this from a differnet computer.[color=blue]
> So it isn't a page refresh issue.[/color]

Did you read the whole article I sent?

--
Aaron Bertrand
SQL Server MVP

http://www.aspfaq.com/

[johnfli]

Re: access databse

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]" <aaron@TRASHasp faq.com> wrote in message
news:Ohgky6kvDH A.3116@tk2msftn gp13.phx.gbl...[color=blue][color=green]
> > I even tried this from a differnet computer.
> > So it isn't a page refresh issue.[/color]
>
> Did you read the whole article I sent?
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>[/color]

[johnfli]

Re: access databse

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]" <aaron@TRASHasp faq.com> wrote in message
news:Ohgky6kvDH A.3116@tk2msftn gp13.phx.gbl...[color=blue][color=green]
> > I even tried this from a differnet computer.
> > So it isn't a page refresh issue.[/color]
>
> Did you read the whole article I sent?
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>[/color]

[Aaron Bertrand - MVP]

Re: access databse

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

--
Aaron Bertrand
SQL Server MVP

http://www.aspfaq.com/

"johnfli" <john@here.co m> wrote in message
news:OJ2xnVqvDH A.2408@tk2msftn gp13.phx.gbl...[color=blue]
> 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[/color]
leave[color=blue]
> out what would be the last 2 records that are in the database.
>
>
>
>
>
> "Aaron Bertrand [MVP]" <aaron@TRASHasp faq.com> wrote in message
> news:Ohgky6kvDH A.3116@tk2msftn gp13.phx.gbl...[color=green][color=darkred]
> > > I even tried this from a differnet computer.
> > > So it isn't a page refresh issue.[/color]
> >
> > Did you read the whole article I sent?
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >[/color]
>
>[/color]

[Chris Hohmann]

Re: access databse

"johnfli" <john@here.co m> wrote in message
news:OJ2xnVqvDH A.2408@tk2msftn gp13.phx.gbl...[color=blue]
> 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[/color]
EOF[color=blue]
> being true.
>
> If I sort it differently, it will list record 110 and 111, but it will[/color]
leave[color=blue]
> out what would be the last 2 records that are in the database.
>
>
>
>
>
> "Aaron Bertrand [MVP]" <aaron@TRASHasp faq.com> wrote in message
> news:Ohgky6kvDH A.3116@tk2msftn gp13.phx.gbl...[color=green][color=darkred]
> > > I even tried this from a differnet computer.
> > > So it isn't a page refresh issue.[/color]
> >
> > Did you read the whole article I sent?
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/[/color][/color]

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

[johnfli]

Re: access databse

OK, here you go.
I am just including the asp stuff as I don't think you need to see teh HTML
junk, unless you really want to.

This is at the very top of my asp page;

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

html stuff in here

then;
<%
Dim strSortOrder
dim objConn
dim rsUsers
dim strUserSQL

strSortOrder=re quest("Sort")
if trim(strSortOrd er) = "" then
strSortOrder = "FName"
end if

Set objConn = Server.CreateOb ject ("ADODB.Connect ion")
Set rsUsers = Server.CreateOb ject ("ADODB.Records et")

strUserSQL = "SELECT Email.ID, Email.Fname, Email.Lname, Email.email,
Email.year, Email.city, Email.state FROM Email order by " & strSortOrder


objConn.Open "DSN=IVHS_Email "
rsUsers.Open strUserSQL, objConn, 3,3

response.write "==== " & rsUsers.Recordc ount & " ====="

strRecordCount = rsUsers.Recordc ount


If not (rsUsers.BOF and rsUsers.EOF) then
rsUsers.movelas t
rsUsers.movefir st

do until rsUsers.eof = true


%>

Then the html stuff that displays the info goes here
then at the end is;


<%

rsUsers.moveNex t
loop
end if

%>






"Aaron Bertrand - MVP" <aaron@TRASHasp faq.com> wrote in message
news:ucw0$iqvDH A.2000@TK2MSFTN GP11.phx.gbl...[color=blue]
> Instead of narrating, can you show the actual code you're talking about?
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
>
>
> "johnfli" <john@here.co m> wrote in message
> news:OJ2xnVqvDH A.2408@tk2msftn gp13.phx.gbl...[color=green]
> > 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[/color]
> leave[color=green]
> > out what would be the last 2 records that are in the database.
> >
> >
> >
> >
> >
> > "Aaron Bertrand [MVP]" <aaron@TRASHasp faq.com> wrote in message
> > news:Ohgky6kvDH A.3116@tk2msftn gp13.phx.gbl...[color=darkred]
> > > > 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/
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[johnfli]

Re: access databse

When you have it sorting by first name, it lists all 112 items in order?


"Chris Hohmann" <nospam@thankyo u.com> wrote in message
news:upBk3vqvDH A.3116@TK2MSFTN GP11.phx.gbl...[color=blue]
> "johnfli" <john@here.co m> wrote in message
> news:OJ2xnVqvDH A.2408@tk2msftn gp13.phx.gbl...[color=green]
> > 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[/color]
> EOF[color=green]
> > being true.
> >
> > If I sort it differently, it will list record 110 and 111, but it will[/color]
> leave[color=green]
> > out what would be the last 2 records that are in the database.
> >
> >
> >
> >
> >
> > "Aaron Bertrand [MVP]" <aaron@TRASHasp faq.com> wrote in message
> > news:Ohgky6kvDH A.3116@tk2msftn gp13.phx.gbl...[color=darkred]
> > > > 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/[/color][/color]
>
> 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
>
>
>[/color]

[johnfli]

Re: access databse

Forgot one thing;
to get the EOF error I used

"for intRecord = 0 to strRecordCount -1"

in place of the "do until rsUsers.eof = true"

Then naturally I had a "next" in place of the "loop"


So in doing that, I would get the error when it hit rsUsers.moveNex t for
record 110


"johnfli" <john@here.co m> wrote in message
news:ujaEHXrvDH A.3140@TK2MSFTN GP11.phx.gbl...[color=blue]
> OK, here you go.
> I am just including the asp stuff as I don't think you need to see teh[/color]
HTML[color=blue]
> junk, unless you really want to.
>
> This is at the very top of my asp page;
>
> <%@ LANGUAGE=VBSCRI PT %>
> <%
> pStr = "private, no-cache, must-revalidate"
> Response.Expire sAbsolute = #2000-01-01#
> Response.AddHea der "pragma", "no-cache"
> Response.AddHea der "cache-control", pStr
> %>
>
> html stuff in here
>
> then;
> <%
> Dim strSortOrder
> dim objConn
> dim rsUsers
> dim strUserSQL
>
> strSortOrder=re quest("Sort")
> if trim(strSortOrd er) = "" then
> strSortOrder = "FName"
> end if
>
> Set objConn = Server.CreateOb ject ("ADODB.Connect ion")
> Set rsUsers = Server.CreateOb ject ("ADODB.Records et")
>
> strUserSQL = "SELECT Email.ID, Email.Fname, Email.Lname, Email.email,
> Email.year, Email.city, Email.state FROM Email order by " & strSortOrder
>
>
> objConn.Open "DSN=IVHS_Email "
> rsUsers.Open strUserSQL, objConn, 3,3
>
> response.write "==== " & rsUsers.Recordc ount & " ====="
>
> strRecordCount = rsUsers.Recordc ount
>
>
> If not (rsUsers.BOF and rsUsers.EOF) then
> rsUsers.movelas t
> rsUsers.movefir st
>
> do until rsUsers.eof = true
>
>
> %>
>
> Then the html stuff that displays the info goes here
> then at the end is;
>
>
> <%
>
> rsUsers.moveNex t
> loop
> end if
>
> %>
>
>
>
>
>
>
> "Aaron Bertrand - MVP" <aaron@TRASHasp faq.com> wrote in message
> news:ucw0$iqvDH A.2000@TK2MSFTN GP11.phx.gbl...[color=green]
> > Instead of narrating, can you show the actual code you're talking about?
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
> >
> >
> > "johnfli" <john@here.co m> wrote in message
> > news:OJ2xnVqvDH A.2408@tk2msftn gp13.phx.gbl...[color=darkred]
> > > 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[/color][/color][/color]
EOF[color=blue][color=green][color=darkred]
> > > being true.
> > >
> > > If I sort it differently, it will list record 110 and 111, but it will[/color]
> > leave[color=darkred]
> > > out what would be the last 2 records that are in the database.
> > >
> > >
> > >
> > >
> > >
> > > "Aaron Bertrand [MVP]" <aaron@TRASHasp faq.com> wrote in message
> > > news:Ohgky6kvDH A.3116@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/
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[johnfli]

Re: access databse

Sorry all, I found the problem.

It was me.

I thought is was sorting by the ID field, but it was sorting by the First
Name.

So as a result, record 109's first name start with a 'V' thus meaning that
it will always be last.

I thank you for your assistance with me. Sorry it turned out to be an
ignorance issue.





"johnfli" <john@here.co m> wrote in message
news:usp4VarvDH A.2408@tk2msftn gp13.phx.gbl...[color=blue]
> Forgot one thing;
> to get the EOF error I used
>
> "for intRecord = 0 to strRecordCount -1"
>
> in place of the "do until rsUsers.eof = true"
>
> Then naturally I had a "next" in place of the "loop"
>
>
> So in doing that, I would get the error when it hit rsUsers.moveNex t for
> record 110
>
>
> "johnfli" <john@here.co m> wrote in message
> news:ujaEHXrvDH A.3140@TK2MSFTN GP11.phx.gbl...[color=green]
> > OK, here you go.
> > I am just including the asp stuff as I don't think you need to see teh[/color]
> HTML[color=green]
> > junk, unless you really want to.
> >
> > This is at the very top of my asp page;
> >
> > <%@ LANGUAGE=VBSCRI PT %>
> > <%
> > pStr = "private, no-cache, must-revalidate"
> > Response.Expire sAbsolute = #2000-01-01#
> > Response.AddHea der "pragma", "no-cache"
> > Response.AddHea der "cache-control", pStr
> > %>
> >
> > html stuff in here
> >
> > then;
> > <%
> > Dim strSortOrder
> > dim objConn
> > dim rsUsers
> > dim strUserSQL
> >
> > strSortOrder=re quest("Sort")
> > if trim(strSortOrd er) = "" then
> > strSortOrder = "FName"
> > end if
> >
> > Set objConn = Server.CreateOb ject ("ADODB.Connect ion")
> > Set rsUsers = Server.CreateOb ject ("ADODB.Records et")
> >
> > strUserSQL = "SELECT Email.ID, Email.Fname, Email.Lname, Email.email,
> > Email.year, Email.city, Email.state FROM Email order by " & strSortOrder
> >
> >
> > objConn.Open "DSN=IVHS_Email "
> > rsUsers.Open strUserSQL, objConn, 3,3
> >
> > response.write "==== " & rsUsers.Recordc ount & " ====="
> >
> > strRecordCount = rsUsers.Recordc ount
> >
> >
> > If not (rsUsers.BOF and rsUsers.EOF) then
> > rsUsers.movelas t
> > rsUsers.movefir st
> >
> > do until rsUsers.eof = true
> >
> >
> > %>
> >
> > Then the html stuff that displays the info goes here
> > then at the end is;
> >
> >
> > <%
> >
> > rsUsers.moveNex t
> > loop
> > end if
> >
> > %>
> >
> >
> >
> >
> >
> >
> > "Aaron Bertrand - MVP" <aaron@TRASHasp faq.com> wrote in message
> > news:ucw0$iqvDH A.2000@TK2MSFTN GP11.phx.gbl...[color=darkred]
> > > Instead of narrating, can you show the actual code you're talking[/color][/color][/color]
about?[color=blue][color=green][color=darkred]
> > >
> > > --
> > > Aaron Bertrand
> > > SQL Server MVP
> > > http://www.aspfaq.com/
> > >
> > >
> > >
> > >
> > > "johnfli" <john@here.co m> wrote in message
> > > news:OJ2xnVqvDH A.2408@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[/color][/color]
> EOF[color=green][color=darkred]
> > > > being true.
> > > >
> > > > If I sort it differently, it will list record 110 and 111, but it[/color][/color][/color]
will[color=blue][color=green][color=darkred]
> > > leave
> > > > out what would be the last 2 records that are in the database.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Aaron Bertrand [MVP]" <aaron@TRASHasp faq.com> wrote in message
> > > > news:Ohgky6kvDH A.3116@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/
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]