I'm not even an Oracle novice so apologies if some of this is a bit vague.
We have the following query in an ASP page to return values from an Oracle DB:
SELECT ""Case-ID+"" as Case-ID, Create-Time, Description, Eng-1-Despatched, Eng-1-Name, FROM HPD:HelpDesk WHERE Create-Time > {ts '2003-01-29 00:00:00'} AND Create-Time < {ts '2003-01-29 23:59:59'} ORDER BY Create-Time DESC"
All of the values are returned fine and displayed on screen apart from Description. We know this value works as this field is displayed with exactly the same query through an ODBC Client.
Is there any answer for why this is happening? From what i've been told the Description field is set-up as a LONGVARCHAR.
Any help appreciated!
We have the following query in an ASP page to return values from an Oracle DB:
SELECT ""Case-ID+"" as Case-ID, Create-Time, Description, Eng-1-Despatched, Eng-1-Name, FROM HPD:HelpDesk WHERE Create-Time > {ts '2003-01-29 00:00:00'} AND Create-Time < {ts '2003-01-29 23:59:59'} ORDER BY Create-Time DESC"
All of the values are returned fine and displayed on screen apart from Description. We know this value works as this field is displayed with exactly the same query through an ODBC Client.
Is there any answer for why this is happening? From what i've been told the Description field is set-up as a LONGVARCHAR.
Any help appreciated!