Re: Create in access (Please stop chasing rabbits)

From: Bob Lehmann (nospam_at_dontbotherme.zzz)
Date: 08/01/04 

Date: Sun, 1 Aug 2004 16:10:26 -0600

PS - Who exactly is it that you seem to think is "chasing rabbits", Alice?

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

Relevant Pages

  • Return to Original Question
    ... Jeff & MikeD: ... Guys thanks for your contributions so far. ... the original question with the requested clarifications. ...
    (microsoft.public.vb.general.discussion)
  • Re: The "Cantenna" has not 12 dBi!!!
    ... Jeff Liebermann;122698 Wrote: ... dipole elements might be 50 ohms ... Duz it have anything to do with the original question? ... the world record wireless distance is 237.36miles, ...
    (alt.internet.wireless)
Quantcast