|
|
You're in the
inetserver asp general
group:Create in access
inetserver asp general:
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. [quoted text, click to view] "Jeff" <gig_bam_takemeout_@verizon.net> wrote in message news:udhzEqydEHA.1760@TK2MSFTNGP10.phx.gbl... > 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 > >
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
uh, yeah. If you say so.
What makes you think that the actual table name has to be displayed? I've followed your previous threads on this tournament database of yours, and you seem hellbent on employing bad practices - against the advice of people who know better -, creating problems, and then coming up with goofy work-arounds for the problems instead of fixing them. Why is that? Bob Lehmann [quoted text, click to view] "Jeff" <gig_bam_takemeout_@verizon.net> wrote in message news:u77EOLzdEHA.2888@TK2MSFTNGP10.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" <nospam@dontbotherme.zzz> wrote in message > news:%23JgSpvydEHA.3380@TK2MSFTNGP12.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" <gig_bam_takemeout_@verizon.net> wrote in message > > news:udhzEqydEHA.1760@TK2MSFTNGP10.phx.gbl... > > > 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 > > > > > > > > > > > >
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 [quoted text, click to view] "Bob Lehmann" <nospam@dontbotherme.zzz> wrote in message news:%23JgSpvydEHA.3380@TK2MSFTNGP12.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" <gig_bam_takemeout_@verizon.net> wrote in message > news:udhzEqydEHA.1760@TK2MSFTNGP10.phx.gbl... > > 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 > > > > > >
Think "outside the box". There is no reason that the text displayed on the
page has to match the database object names ... Bob Barrows [quoted text, click to view] Jeff wrote: -- > 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 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"
LOL. i am trying to get better at that
[quoted text, click to view] "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message news:%23v4VLVzdEHA.1652@TK2MSFTNGP09.phx.gbl... > 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: > > 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 > 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" > >
Well... if you look at one of my last posts about that tourney DB, I did say
that I changed to be like they instructed. I learned the hard way on that. The only other thing that I am doing different, is creating a folder with the tourney ID. But I am still learning this stuff, and yes.. I do have a hard head about somethings. But I usually end up doing what was requested. I guess I call it learning the hard way. Jeff [quoted text, click to view] "Bob Lehmann" <nospam@dontbotherme.zzz> wrote in message news:OEpSywzdEHA.3988@tk2msftngp13.phx.gbl... > uh, yeah. If you say so. > > What makes you think that the actual table name has to be displayed? > > I've followed your previous threads on this tournament database of yours, > and you seem hellbent on employing bad practices - against the advice of > people who know better -, creating problems, and then coming up with goofy > work-arounds for the problems instead of fixing them. > > Why is that? > > Bob Lehmann > > "Jeff" <gig_bam_takemeout_@verizon.net> wrote in message > news:u77EOLzdEHA.2888@TK2MSFTNGP10.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" <nospam@dontbotherme.zzz> wrote in message > > news:%23JgSpvydEHA.3380@TK2MSFTNGP12.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" <gig_bam_takemeout_@verizon.net> wrote in message > > > news:udhzEqydEHA.1760@TK2MSFTNGP10.phx.gbl... > > > > 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 > > > > > > > > > > > > > > > > > > > >
We did answer the question - "Don't allow spaces in DB tablle names."!
Allowing a DB to have table and column names with spaces IS bad design. The problem isn't with the value, but what it is being used for. There is a big difference between an Address and a DB Table name. Would you categorize ALLOWING alphas in a phone number column as bad data, or bad design? PS - The thread was never "off track". He made a bad design decision and was given alternatives to fix or kludge his *design*. Bob Lehmann [quoted text, click to view] "David C. Holley" <DavidCHolley@netscape.net> wrote in message news:eVqPHZ1dEHA.3632@TK2MSFTNGP11.phx.gbl... > And we still haven't answered the original question, which I believe is > quite valid because there are instances where inserting values with > spaces is warranted and NOT the symptom of a bad db design. (How many > times have you seen a street address without spaces as in "5490 Willard > Norris Road"?) > > I seem to recall encountering this problem before, but when I looked > around my pages, I could find where I had the problem. Hopefully, I've > gotten the thread back on track which at least should help you get the > answer. > > David H > > Jeff wrote: > > Well... if you look at one of my last posts about that tourney DB, I did say > > that I changed to be like they instructed. I learned the hard way on that. > > The only other thing that I am doing different, is creating a folder with > > the tourney ID. But I am still learning this stuff, and yes.. I do have a > > hard head about somethings. But I usually end up doing what was requested. I > > guess I call it learning the hard way. > > Jeff > > > > "Bob Lehmann" <nospam@dontbotherme.zzz> wrote in message > > news:OEpSywzdEHA.3988@tk2msftngp13.phx.gbl... > > > >>uh, yeah. If you say so. > >> > >>What makes you think that the actual table name has to be displayed? > >> > >>I've followed your previous threads on this tournament database of yours, > >>and you seem hellbent on employing bad practices - against the advice of > >>people who know better -, creating problems, and then coming up with goofy > >>work-arounds for the problems instead of fixing them. > >> > >>Why is that? > >> > >>Bob Lehmann > >> > >>"Jeff" <gig_bam_takemeout_@verizon.net> wrote in message > >>news:u77EOLzdEHA.2888@TK2MSFTNGP10.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" <nospam@dontbotherme.zzz> wrote in message > >>>news:%23JgSpvydEHA.3380@TK2MSFTNGP12.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" <gig_bam_takemeout_@verizon.net> wrote in message > >>>>news:udhzEqydEHA.1760@TK2MSFTNGP10.phx.gbl... > >>>> > >>>>>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 > >>>>> > >>>>> > >>>> > >>>> > >>> > >> > > > > >
I guess you must get paid by the hour.
Good luck with your learning the hard way. Bob Lehmann [quoted text, click to view] "Jeff" <gig_bam_takemeout_@verizon.net> wrote in message news:OIu3U5zdEHA.2864@TK2MSFTNGP12.phx.gbl... > Well... if you look at one of my last posts about that tourney DB, I did say > that I changed to be like they instructed. I learned the hard way on that. > The only other thing that I am doing different, is creating a folder with > the tourney ID. But I am still learning this stuff, and yes.. I do have a > hard head about somethings. But I usually end up doing what was requested. I > guess I call it learning the hard way. > Jeff > > "Bob Lehmann" <nospam@dontbotherme.zzz> wrote in message > news:OEpSywzdEHA.3988@tk2msftngp13.phx.gbl... > > uh, yeah. If you say so. > > > > What makes you think that the actual table name has to be displayed? > > > > I've followed your previous threads on this tournament database of yours, > > and you seem hellbent on employing bad practices - against the advice of > > people who know better -, creating problems, and then coming up with goofy > > work-arounds for the problems instead of fixing them. > > > > Why is that? > > > > Bob Lehmann > > > > "Jeff" <gig_bam_takemeout_@verizon.net> wrote in message > > news:u77EOLzdEHA.2888@TK2MSFTNGP10.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" <nospam@dontbotherme.zzz> wrote in message > > > news:%23JgSpvydEHA.3380@TK2MSFTNGP12.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" <gig_bam_takemeout_@verizon.net> wrote in message > > > > news:udhzEqydEHA.1760@TK2MSFTNGP10.phx.gbl... > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
And we still haven't answered the original question, which I believe is
quite valid because there are instances where inserting values with spaces is warranted and NOT the symptom of a bad db design. (How many times have you seen a street address without spaces as in "5490 Willard Norris Road"?) I seem to recall encountering this problem before, but when I looked around my pages, I could find where I had the problem. Hopefully, I've gotten the thread back on track which at least should help you get the answer. David H [quoted text, click to view] Jeff wrote:
> Well... if you look at one of my last posts about that tourney DB, I did say > that I changed to be like they instructed. I learned the hard way on that. > The only other thing that I am doing different, is creating a folder with > the tourney ID. But I am still learning this stuff, and yes.. I do have a > hard head about somethings. But I usually end up doing what was requested. I > guess I call it learning the hard way. > Jeff > > "Bob Lehmann" <nospam@dontbotherme.zzz> wrote in message > news:OEpSywzdEHA.3988@tk2msftngp13.phx.gbl... > >>uh, yeah. If you say so. >> >>What makes you think that the actual table name has to be displayed? >> >>I've followed your previous threads on this tournament database of yours, >>and you seem hellbent on employing bad practices - against the advice of >>people who know better -, creating problems, and then coming up with goofy >>work-arounds for the problems instead of fixing them. >> >>Why is that? >> >>Bob Lehmann >> >>"Jeff" <gig_bam_takemeout_@verizon.net> wrote in message >>news:u77EOLzdEHA.2888@TK2MSFTNGP10.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" <nospam@dontbotherme.zzz> wrote in message >>>news:%23JgSpvydEHA.3380@TK2MSFTNGP12.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" <gig_bam_takemeout_@verizon.net> wrote in message >>>>news:udhzEqydEHA.1760@TK2MSFTNGP10.phx.gbl... >>>> >>>>>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 >>>>> >>>>> >>>> >>>> >>> >> > >
Well. I use access DB for my stuff. And when you are looking at the tables..
with the DB opened, if you right click a table and click save as.... it automatically gives you the option of " copy of tablename". and that itself has spaces in it. But anyway, I do understand what you mean my bad design. It makes things a lot easier without the spaces. Thanks again Jeff [quoted text, click to view] "Bob Lehmann" <nospam@dontbotherme.zzz> wrote in message news:eGkusG2dEHA.3864@TK2MSFTNGP10.phx.gbl... > We did answer the question - "Don't allow spaces in DB tablle names."! > > Allowing a DB to have table and column names with spaces IS bad design. > > The problem isn't with the value, but what it is being used for. There is a > big difference between an Address and a DB Table name. > > Would you categorize ALLOWING alphas in a phone number column as bad data, > or bad design? > > PS - The thread was never "off track". He made a bad design decision and was > given alternatives to fix or kludge his *design*. > > Bob Lehmann > > "David C. Holley" <DavidCHolley@netscape.net> wrote in message > news:eVqPHZ1dEHA.3632@TK2MSFTNGP11.phx.gbl... > > And we still haven't answered the original question, which I believe is > > quite valid because there are instances where inserting values with > > spaces is warranted and NOT the symptom of a bad db design. (How many > > times have you seen a street address without spaces as in "5490 Willard > > Norris Road"?) > > > > I seem to recall encountering this problem before, but when I looked > > around my pages, I could find where I had the problem. Hopefully, I've > > gotten the thread back on track which at least should help you get the > > answer. > > > > David H > > > > Jeff wrote: > > > Well... if you look at one of my last posts about that tourney DB, I did > say > > > that I changed to be like they instructed. I learned the hard way on > that. > > > The only other thing that I am doing different, is creating a folder > with > > > the tourney ID. But I am still learning this stuff, and yes.. I do have > a > > > hard head about somethings. But I usually end up doing what was > requested. I > > > guess I call it learning the hard way. > > > Jeff > > > > > > "Bob Lehmann" <nospam@dontbotherme.zzz> wrote in message > > > news:OEpSywzdEHA.3988@tk2msftngp13.phx.gbl... > > > > > >>uh, yeah. If you say so. > > >> > > >>What makes you think that the actual table name has to be displayed? > > >> > > >>I've followed your previous threads on this tournament database of > yours, > > >>and you seem hellbent on employing bad practices - against the advice of > > >>people who know better -, creating problems, and then coming up with > goofy > > >>work-arounds for the problems instead of fixing them. > > >> > > >>Why is that? > > >> > > >>Bob Lehmann > > >> > > >>"Jeff" <gig_bam_takemeout_@verizon.net> wrote in message > > >>news:u77EOLzdEHA.2888@TK2MSFTNGP10.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" <nospam@dontbotherme.zzz> wrote in message > > >>>news:%23JgSpvydEHA.3380@TK2MSFTNGP12.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" <gig_bam_takemeout_@verizon.net> wrote in message > > >>>>news:udhzEqydEHA.1760@TK2MSFTNGP10.phx.gbl... > > >>>> > > >>>>>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 > > >>>>> > > >>>>> > > >>>> > > >>>> > > >>> > > >> > > > > > > > > > >
If by chance you turn on the system tables in an access database, you will find that your tables and
queries in the MSysObjects table are just items in a system table. This is used to give your table name a unique ID. So the name you actually give it means nothing. This is how JET Ticks. This is built to allow names with spaces for boneheads. dlbjr Pleading sagacious indoctrination!
Ahhh.. well, that explains a bunch. Well, I started learning this stuff on
my own, been doing it for a short time. So all the advice you all give me does not go to waste. And it is much appreciated. Jeff [quoted text, click to view] "dlbjr" <oops@iforgot.com> wrote in message news:uKwhN%232dEHA.3732@TK2MSFTNGP11.phx.gbl... > If by chance you turn on the system tables in an access database, you will find that your tables and > queries in the MSysObjects table are just items in a system table. This is used to give your table > name a unique ID. So the name you actually give it means nothing. This is how JET Ticks. This is > built to allow names with spaces for boneheads. > > > dlbjr > Pleading sagacious indoctrination! > >
[quoted text, click to view]
David C. Holley wrote: > And we still haven't answered the original question, which I believe > is > quite valid because there are instances where inserting values with > spaces is warranted and NOT the symptom of a bad db design. (How many > times have you seen a street address without spaces as in "5490 > Willard Norris Road"?) > David, I must respectfully disagree. The problem was not about inserting/displaying data with spaces: it was about the creation of database objects with spaces in their names. This question certainly was dealt with, and the OP did solve his problem. Bob Barrows -- 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"
PS - Who exactly is it that you seem to think is "chasing rabbits", Alice?
Bob Lehmann [quoted text, click to view] "David C. Holley" <DavidCHolley@netscape.net> wrote in message news:eVqPHZ1dEHA.3632@TK2MSFTNGP11.phx.gbl... > And we still haven't answered the original question, which I believe is > quite valid because there are instances where inserting values with > spaces is warranted and NOT the symptom of a bad db design. (How many > times have you seen a street address without spaces as in "5490 Willard > Norris Road"?) > > I seem to recall encountering this problem before, but when I looked > around my pages, I could find where I had the problem. Hopefully, I've > gotten the thread back on track which at least should help you get the > answer. > > David H > > Jeff wrote: > > Well... if you look at one of my last posts about that tourney DB, I did say > > that I changed to be like they instructed. I learned the hard way on that. > > The only other thing that I am doing different, is creating a folder with > > the tourney ID. But I am still learning this stuff, and yes.. I do have a > > hard head about somethings. But I usually end up doing what was requested. I > > guess I call it learning the hard way. > > Jeff > > > > "Bob Lehmann" <nospam@dontbotherme.zzz> wrote in message > > news:OEpSywzdEHA.3988@tk2msftngp13.phx.gbl... > > > >>uh, yeah. If you say so. > >> > >>What makes you think that the actual table name has to be displayed? > >> > >>I've followed your previous threads on this tournament database of yours, > >>and you seem hellbent on employing bad practices - against the advice of > >>people who know better -, creating problems, and then coming up with goofy > >>work-arounds for the problems instead of fixing them. > >> > >>Why is that? > >> > >>Bob Lehmann > >> > >>"Jeff" <gig_bam_takemeout_@verizon.net> wrote in message > >>news:u77EOLzdEHA.2888@TK2MSFTNGP10.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" <nospam@dontbotherme.zzz> wrote in message > >>>news:%23JgSpvydEHA.3380@TK2MSFTNGP12.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" <gig_bam_takemeout_@verizon.net> wrote in message > >>>>news:udhzEqydEHA.1760@TK2MSFTNGP10.phx.gbl... > >>>> > >>>>>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 > >>>>> > >>>>> > >>>> > >>>> > >>> > >> > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |