访问数据库 [英] access databse
问题描述
好的，这里有点奇怪。
对于我所拥有的网页，我曾经保留一份姓名和电子邮件地址列表
in a分隔的文本文件。然后由于某种原因，我的主办公司确实在某些情况下花了
，现在我的页面无法读取文本文件，但它可以写入
它。去看看那个。
ANyway，所以我创建了一个访问数据库来替换文本文件，我直接从文本文件导入数据。
Everythign再次看起来很好。
它完全从数据库中读取所有信息。
从电子邮件订单中选择*由fname
我通过我的网页添加另一个名称和电子邮件地址，当我去
回到列出everythign的页面时，它不会显示新的输入。
但是，如果我在Access中打开我的数据库，那么它就可以正确保存。
如果我的select语句是select * from email fname =' " John"''
按fname订购
然后它会显示最新的条目
（顺便说一句，约翰Doe）
ANy想知道为什么新条目不会显示？
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?
推荐答案
你有没有按Ctrl +重新加载页面时刷新？另见
http://www.aspfaq.com/2022
-
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
" johnfli" <乔** @ here.com>在消息中写道
新闻：## ************** @ TK2MSFTNGP09.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.com> wrote in message
news:##**************@TK2MSFTNGP09.phx.gbl...
好的，这里是奇怪的是。
对于我的网页，我曾经保留一个名单，并在分隔的文本文件中通过电子邮件发送
地址。然后由于某种原因，我的主办公司做了一些签名，现在我的页面无法读取文本文件，但它可以写入
它。去看看那个。
ANyway，所以我创建了一个访问数据库来替换文本文件，我直接从文本文件导入数据。
Everythign再次看起来不错。
它完全从数据库中读取所有信息。
从fname中选择*来自电子邮件订单
我将通过我的网页添加其他名称和电子邮件地址当我回到列出everythign的页面时，它没有显示新条目。
但是，如果我在Access中打开我的数据库，它就在那里，所以它保存正确。
如果我的select语句是select * from email fname =''"约翰
"''由fname命令
然后它会显示最新的条目
（顺便说一句是John Doe）
任何想法为什么新条目不会显示？
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?
另外，请确保在您的浏览器中访问：
IE ex。
工具
选项
在临时互联网文件下单击设置
并选择check for更新版本的存储页面每页
访问页面。
这将有效。
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.
-----原创消息-----
重新加载页面时是否按下了Ctrl + Refresh？
另见 http://www.aspfaq.com/2022
-
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
" johnfli" <乔** @ here.com>在消息中写道
新闻：## ************** @ TK2MSFTNGP09.phx.gbl ...
-----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.com> wrote in message
news:##**************@TK2MSFTNGP09.phx.gbl...
好的，这里有点奇怪。
对于我所拥有的网页，我曾经在一个分隔的文本文件中保留
名称列表并发送电子邮件
Ok, here is something strange.
For a webpage that I have, I used to keep a list of names and email
地址
。然后由于某种原因，我的
in a delimited text file. Then for some reason, my
主机公司做了一些事情，现在我的页面无法读取文本文件，
但它可以写入它。去找那一个。
ANyway，所以我创建了一个访问数据库来替换teh
文本文件，我直接从文本文件中导入数据。
Everythign再次看起来不错。
它完全从数据库中读取所有信息。
从fname中选择*来自电子邮件订单
我将通过我的网站添加另一个名称和电子邮件地址
页面，当我回到列出everythign的页面时，它没有
显示新条目。
然而，如果我在Access中打开我的数据库，它就在那里它正确保存了
。如果我的select语句是select * from email
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
其中fname =''" John"''
where fname = ''" John"''
按fname排序
然后它会显示最新的条目
（顺便说一句是John Doe）
> ANY想知道为什么新条目不会显示？
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]" < AA *** @ TRASHaspfaq.com>在消息中写道
news：u0 ************** @ TK2MSFTNGP09.phx.gbl ...
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***@TRASHaspfaq.com> wrote in message
news:u0**************@TK2MSFTNGP09.phx.gbl...
你按Ctrl +重新加载页面时刷新？另见
http://www.aspfaq.com/2022
-
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
" johnfli" <乔** @ here.com>在消息中写道
新闻：## ************** @ TK2MSFTNGP09.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.com> wrote in message
news:##**************@TK2MSFTNGP09.phx.gbl...
好的，这里有点奇怪。
对于我的网页，我曾经在一个分隔的文本文件中保留了一个名单和电子邮件地址列表
Ok, here is something strange.
For a webpage that I have, I used to keep a list of names and email address
。然后由于某种原因，我的主办公司做了一些签名，现在我的页面无法读取文本文件，但它可以写入
。去看看那个。
ANyway，所以我创建了一个访问数据库来替换文本文件，我直接从文本文件导入数据。
Everythign再次看起来不错。
它完全从数据库中读取所有信息。
从fname中选择*来自电子邮件订单
我将通过我的网页添加其他名称和电子邮件地址当我回到列出everythign的页面时，它没有显示新条目。
但是，如果我在Access中打开我的数据库，它就在那里，所以它保存正确。
如果我的select语句是select * from email其中fname =''"
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"''
John "''
按fname命令
然后它会显示最新的条目
（顺便说一句是John Doe）
ANY想知道为什么新条目不会显示？
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?
这篇关于访问数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
