Problem with Selecting value of LONG data type column on WebPage ADO/ASP on IIS/WIN2k

[Srdjan Josipovic]

Can someone see this , I will appreciate any help . Thanks .     I create table   CREATE TABLE PROFILES ( ID INTEGER , PROFILE LONG )   Table created and populated ..   When trying to make a search procedure to search within text of profiles , if condition is PROFILE LIKE...something >> ERROR  >>   Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [SAP AG][SQLOD32 DLL][SAP DB]General error;-7032 POS(49) SQL statement not allowed for column of data type LONG.   Next Situation . I tried  to Search for specific profile regarding it;s ID , and to show it on the ASP , ( Web Page ) ..   "SELECT PROFILE WHERE ID = something "   Recordset returns Name of the Field , and all properties which you can get with ADO , but value of the PROFILE , text for DB field  NONE !!!!!   Page stay empty !     ADO 2.6. on ASP , running on IIS on WIN 2k , ODBC Driver .     Srdjan