Re: Complicated database problem





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



Relevant Pages

  • Re: New Cobol compiler written in Cobol
    ... It didn't have a visible operating system. ... > If I were writing a Cobol compiler, I wouldn't look at today's market. ... > What will a programming language need to be successful in that world? ... They'll use a language they can understand at a glance. ...
    (comp.lang.cobol)
  • Re: Alternative tof Microsoft Windows vis a vis Lisp
    ... language and with the realization that it does indeed possess the necessary power to be language of the future, ... operating system, open sourced and with all the consequent liberating effects that this would entail. ... still only a dream today for all but the few who still have such machines. ... to design and maintain - but we are now 20 years in the future. ...
    (comp.lang.lisp)
  • Re: Compiling C++ kernel module + Makefile
    ... C++ was designed as an object-oriented language. ... the details of the actual execution mechanisms ... and the actual execution paths. ... the Operating System programmer makes ...
    (Linux-Kernel)
  • Re: Creating an operating system
    ... >>I'm looking to write an custom operating system designed for one ... > - this design took care of few memory, industry standards, small programmers ... > To share algorythm, i propose an interpreted language structured, object ...
    (comp.os.linux.development.system)
  • Re: Creating an operating system
    ... >>I'm looking to write an custom operating system designed for one ... > - this design took care of few memory, industry standards, small programmers ... > To share algorythm, i propose an interpreted language structured, object ...
    (comp.programming)