在访问中创建 [英] Create in access

问题描述

确定。我正在基于表单提交在访问数据库中创建一个表。这个

工作正常。我遇到的问题是，如果

提交中有空格。例如......当asp脚本使用SQL创建数据库时，有人提交The Island

，它将其创建为The。只有。

所以我猜它在名字中有空格时会停止。是否有一些

的方法可以解决这个问题？

Jeff

Ok. I am creating a table in an access DB based on a form submission. This
works fine. The problem I am having is, if there is a space in the
submission. For example.... someone submits "The Island"
when the asp script uses SQL to create the DB, it creates it as "The" only.
SO I am guessing it stops when there is a space in the name. Is there some
way to get around this??
Jeff

推荐答案

为什么不呢只是禁止空间开始，并避免问题？


您可以将名称放在[] - [The Island]中。但是，这是一种糟糕的工作方式，并且会导致更多令人头痛的问题。


鲍勃。

" Jeff" < GI **************** @ verizon.net>在消息中写道

news：ud ************** @ TK2MSFTNGP10.phx.gbl ...

Why not just disallow spaces to begin with, and avoid the problems?

You may be able to put the name in [] - [The Island]. But, that''s a crappy
way of doing things and will result in more headaches than it''s worth.

Bob.
"Jeff" <gi****************@verizon.net> wrote in message
news:ud**************@TK2MSFTNGP10.phx.gbl...

好的。我正在基于表单提交在访问数据库中创建一个表。这个
工作正常。我遇到的问题是，如果
提交中有空格。例如......当asp脚本使用SQL创建数据库时，有人提交The Island，它将其创建为The。仅限
。所以我猜它在名字中有空格时就会停止。有没有办法解决这个问题？
杰夫

Ok. I am creating a table in an access DB based on a form submission. This
works fine. The problem I am having is, if there is a space in the
submission. For example.... someone submits "The Island"
when the asp script uses SQL to create the DB, it creates it as "The" only. SO I am guessing it stops when there is a space in the name. Is there some
way to get around this??
Jeff

我的团队中有一名队长选择我们播放的未来课程。

选择之后，他们会在课程列表页面上显示。对于看起来像The_Island的课程来说，它看起来很糟糕。或者TheIsland


我发现我可以使用替换...例如：


variable = Replace（Request.Form） （课程），，和_。


Thx

杰夫


Bob Lehmann <无**** @ dontbotherme.zzz>在消息中写道

新闻：％2 **************** @ TK2MSFTNGP12.phx.gbl ...

I have a captain on my team that picks the future courses that we play.
After he picks them, they display on a course listing page. It would look
pretty crappy for courses to look like "The_Island" or TheIsland"

I figured out I could use a replace for this... such as:

variable = Replace(Request.Form("course") , " ", "_")

Thx
Jeff

"Bob Lehmann" <no****@dontbotherme.zzz> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

为什么不呢只是禁止空间开始，并避免问题？

您可以将名称放在[] - [The Island]中。但是，这是一种糟糕的做事方式，会导致更多令人头痛的问题。

鲍勃。

" Jeff" < GI **************** @ verizon.net>在消息中写道
新闻：ud ************** @ TK2MSFTNGP10.phx.gbl ...

Why not just disallow spaces to begin with, and avoid the problems?

You may be able to put the name in [] - [The Island]. But, that''s a crappy
way of doing things and will result in more headaches than it''s worth.

Bob.
"Jeff" <gi****************@verizon.net> wrote in message
news:ud**************@TK2MSFTNGP10.phx.gbl...

好的。我正在基于表单提交在访问数据库中创建一个表。
这很好用。我遇到的问题是，如果
提交中有空格。例如....有人提交The Island
当asp脚本使用SQL创建数据库时，它会将其创建为The

Ok. I am creating a table in an access DB based on a form submission. This works fine. The problem I am having is, if there is a space in the
submission. For example.... someone submits "The Island"
when the asp script uses SQL to create the DB, it creates it as "The"

。

所以我猜它在名字中有空格时就会停止。有什么方法来解决这个问题吗？
杰夫

SO I am guessing it stops when there is a space in the name. Is there some way to get around this??
Jeff

想想在盒子外面。没有理由显示在

页面上的文本必须与数据库对象名称相匹配......


鲍勃巴罗斯

杰夫写道：

Think "outside the box". There is no reason that the text displayed on the
page has to match the database object names ...

Bob Barrows

Jeff wrote:

我的团队中有一名队长，负责选择我们未来的课程。在他选择之后，他们会在课程列表页面上显示。对于看起来像The_Island的课程来说，它看起来很糟糕。或者
TheIsland"

I have a captain on my team that picks the future courses that we
play. After he picks them, they display on a course listing page. It
would look pretty crappy for courses to look like "The_Island" or
TheIsland"

-

Microsoft MVP - ASP / ASP.NET

请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我

不经常检查它。如果您必须离线回复，请删除

无垃圾邮件

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"

这篇关于在访问中创建的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！