Re: Complicated database problem
- From: Paul <paul@xxxxxxxxxxxxxx>
- Date: Sun, 17 Jul 2005 12:16:26 +0100
bilaribilari@xxxxxxxxx wrote:
>Input: 400
>Output:
>FROM | TO
>---------+-----
>100 | 999
For starters, FROM and TO are reserved words in SQL, so *_DO NOT_* use
them as your column names.
I find that using a different language for my column names can help
avoid this problem.
>Please help me solve this problem.
>Thanks in advance.
What db do you use? Nobody can answer unless we know that - any sort
of "strange" question like this is normally going to be system
dependent.
Paul...
>Best regards.
--
plinehan __at__ yahoo __dot__ __com__
XP Pro, SP 2,
Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;
When asking database related questions, please give other posters
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
Furthermore, as a courtesy to those who spend
time analysing and attempting to help, please
do not top post.
.
- Follow-Ups:
- Re: Complicated database problem
- From: Bill Karwin
- Re: Complicated database problem
- References:
- Complicated database problem
- From: bilaribilari
- Complicated database problem
- Prev by Date: Re: untypical problem
- Next by Date: Re: untypical problem
- Previous by thread: Re: Complicated database problem
- Next by thread: Re: Complicated database problem
- Index(es):
Relevant Pages
|