Shot in the dark, because one of the columns you've put in really might not
exist, but try getting rid of createodbcdate and use the to_date() function
in Oracle, as it is very particular about date formatting.
For example, instead of:
AND (STSERVICE.DATE_BEGIN BETWEEN #createodbcdate('07/01/00')
Generally, I think "all" is used as a qualifier to a subquery, much like you
would use "IN" or "BETWEEN." So, if you did:
select * FROM mytable WHERE mycolumn = ALL(1,2,3)
This would select everything where myid was equal to 1, 2 and 3.
-d
Deanna Schneider
Interactive Media Developer
[EMAIL PRO
Instead of createodbcdate(), try using Oracle's TO_DATE() function on your
dates like this:
STSERVICE.DATE_BEGIN BETWEEN TO_DATE('07/01/00','mm/dd/yy') AND
TO_DATE('06/30/01','mm/dd/yy')
Chris Lofback
Sr. Web Developer
TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL 33761
www.trxi.com
I got it... Fogot to remove one of my dummy variables xstart... Duh...
-Original Message-
From: Kris Pilles
Sent: Tuesday, October 15, 2002 3:54 PM
To: CF-Talk
Subject: Oracle query help
Heres the query:
SELECT ALL STUDENT.STUDENT_NUM,
STUDENT.LASTNAME, STUDENT.FIRSTNAME, STUDENT.BIRT
are you connected to the correct schema
On Tue, 15 Oct 2002, Kris Pilles wrote:
> Heres the query:
>
> SELECT ALL STUDENT.STUDENT_NUM,
> STUDENT.LASTNAME, STUDENT.FIRSTNAME, STUDENT.BIRTHDATE, STUDENT.SEX,
> STUDENT.SSNUM,
> STSERVICE.DATE_BEGIN, STSERVICE.DATE_END, STSERVICE.LOCATION,
> STSERVI
Remove "ALL"?
> Heres the query:
>
> SELECT ALL STUDENT.STUDENT_NUM,
> STUDENT.LASTNAME, STUDENT.FIRSTNAME, STUDENT.BIRTHDATE, STUDENT.SEX,
> STUDENT.SSNUM,
> STSERVICE.DATE_BEGIN, STSERVICE.DATE_END, STSERVICE.LOCATION,
> STSERVICE.HANDICAP,
> STSERVICE.CSIZE_RATIO, STSERVICE.ST_CLASS, STSERVICE
6 matches
Mail list logo
