🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.database
Article #380

JBuilders SQL Builder, using functions?!?!?!?

#380
From: N
Date: Fri, 16 Feb 2007 22:13
12 lines
1736 bytes
I have been unable to find a single example on how to utilize the USER() function under SQL Builder, I have an easier way to run my query:
SELECT ORADBA.PS_PROJECT_INFO.PROJECT_ID,ORADBA.PS_PROJECT_INFO.PROJECT_NAME,ORADBA.PS_PROJECT_INFO.PROJECT_DESC
FROM ORADBA.PS_PROJECT_INFO
WHERE ORADBA.PS_PROJECT_INFO.PROJECT_ID = (SELECT ORADBA.PS_PROJECT_EMPLOYEES.PROJECT_ID 
                                    FROM ORADBA.PS_PROJECT_EMPLOYEES
                                    WHERE ORADBA.PS_PROJECT_EMPLOYEES.EMPLOYEE_ID = (SELECT ORADBA.PS_EMPLOYEE_LOOKUP.EMPLOYEE_ID FROM ORADBA.PS_EMPLOYEE_LOOKUP WHERE ORADBA.PS_EMPLoYEE_LOOKUP.USERNAME = (SELECT USER from dual)));


But for some reason it will not accept the this query ( i already ran it as a script via command line and it works)... So now I am trying to use the USER() function... Is there any documentation about these functions and how to use them. What I found in the help section was useless?
Thank you for your help in advance..
N
Technical Details
Message-ID: <45d62c8a$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,9a57ca76b54fe400,start
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "N" <nmperez@water.ca.gov>
Sender: "N" <nmperez@water.ca.gov>
Reply-To: "N" <nmperez@water.ca.gov>
Subject: JBuilders SQL Builder, using functions?!?!?!?
Newsgroups: borland.public.jbuilder.database
X-User-Info: 136.200.198.98     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <45d62c8a$1@newsgroups.borland.com>
Date: 16 Feb 2007 14:13:30 -0800
X-Trace: newsgroups.borland.com 1171664010 207.105.83.66 (16 Feb 2007 14:13:30 -0800)
Lines: 12
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail