Kenny:

It appears that Remedy uses cursors to hold the data so that the various
sub-fields can be parsed. It may be that you will have to do the same thing
through the Oracle ODBC.

James Mckenzie

-----Original Message-----
From: Kenny Young [mailto:Kenneth.Young@ALLTEL.COM]
Sent: Tuesday, December 31, 2002 7:00 AM
To: ARSLIST@ARSLIST.ORG
Subject: ODBC Query issue


Hello all. I am building an external app that uses some Remedy data. It is
a combination of Flash and ASP, but my problem is with the ASP, before the
Flash is ever considered.

I am using a wire-protocol Oracle ODBC (not the standard Remedy ODBC that
installs with User) on my W2K Web Server to query data from my Oracle 8.1.7
arsystem db which in on Sun OS 5.8.

The issue is this...if I issue a simple query such as "SELECT caseid,
status, worklog FROM hpdhelpdesk where caseid='HD0000000231111'", the
query does NOT throw an error, and it DOES return my record, but the
worklog field contains no data (well, I haven't parsed the return yet to
determine if it is Null or ""). The other fields ARE returned with the
appropriate data.

As an additional note, if I use sqlplus at the command line and issue the
same query, the field IS returned with data.

Does anyone know why this might be? I have heard in passing that the data
type used for diary fields makes them difficult to query directly, but never
heard why, or how to get around it.

Thanks,
Kenny Young
(501)905.4438
Sr. C/S Developer
ACI Remedy IT Support
ALLTEL


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

Hello all. I am building an external app that uses some Remedy data. It is a combination of Flash and ASP, but my problem is with the ASP, before the Flash is ever considered.

I am using a wire-protocol Oracle ODBC (not the standard Remedy ODBC that installs with User) on my W2K Web Server to query data from my Oracle 8.1.7 arsystem db which in on Sun OS 5.8.

The issue is this...if I issue a simple query such as "SELECT caseid, status, worklog FROM hpdhelpdesk where caseid='HD0000000231111'", the query does NOT throw an error, and it DOES return my record, but the worklog field contains no data (well, I haven't parsed the return yet to determine if it is Null or ""). The other fields ARE returned with the appropriate data.

As an additional note, if I use sqlplus at the command line and issue the same query, the field IS returned with data.

Does anyone know why this might be? I have heard in passing that the data type used for diary fields makes them difficult to query directly, but never heard why, or how to get around it.

Thanks,
Kenny Young
(501)905.4438
Sr. C/S Developer
ACI Remedy IT Support
ALLTEL