Hi Elke.
I understand ( not as well as you do ) that there is a fair amount of
difficulty involved in providing the feature we are asking afer.
However from our side, a purely implementation perspective, the following
example may assist in my needs from a functional level:
When we do a keyword search in content stored in our DB (SAPDB) it would be
great to be able to utilise a feature such as is available in MS SQL Server
(using the LIKE predicate and the % wildcard) as follows:
select id from content where content like "%mykeyword%"
obviously this is in the case where the colum content is a LONG....
The % wildcard would be chars on that side of any value(s) and vise versa
(as in pre- and -post)
Anyway, hope that helps!
Regards,
Carl
-----Original Message-----
From: Zabach, Elke [mailto:[EMAIL PROTECTED]]
Sent: 22 May 2002 10:59
To: '[EMAIL PROTECTED]'; 'Markus Gieppner'; Koetter, Thomas Theodor;
'Srdjan Josipovic'; [EMAIL PROTECTED]
Subject: RE: Problem with Selecting value of LONG data type column on
WebPage ADO/ASP on IIS/WIN2k
Hi,
after some discussions internally now the question to the whole list:
LONG-columns cannot be used in WHERE-condition (except for IS
NULL-qualification).
Some people ask for LIKE in LONGs or ask for '=' for LONGs.
Do you really want LONG columns to be checked for LIKE (longcol LIKE
'abc*def', the star standing for 1.4325GB or so?)
or do you need some longer character values, may be up to 64 KB?
We here cannot imagine unformatted text with a length of more than
(let's say) 64KB.
Let us think of WORD-docs, but they are not unformatted and therefore
comparing will usually
not return the wanted result.
It is easy to ask for this feature. It is not that easy to implement it. And
therefore we would like
to know what you need. What you need, not what is easy to write down without
thinking about
the usage, performance, ...
Thank you
Elke
SAP Labs Berlin
> -----Original Message-----
> From: Carl Olivier [mailto:[EMAIL PROTECTED]]
> Sent: Mittwoch, 22. Mai 2002 08:14
> To: Zabach, Elke; 'Markus Gieppner'; Koetter, Thomas Theodor; 'Srdjan
> Josipovic'; [EMAIL PROTECTED]
> Subject: RE: Problem with Selecting value of LONG data type column on
> WebPage ADO/ASP on IIS/WIN2k
>
>
> Hmm.
>
> Seems like a slight oversight that! We have had to do major
> work-arounds
> the LONG datatype for many different applications in code,
> which obviously
> causes performance issues.
>
> Is there no way that you could look at prioritising this
> slightly higher
> than it seems to be at the moment? Having to used Prepared
> Statements in
> updates in tables where there are LONG columns is cumbersome
> in smallish
> level applications, but the major problem is not being able
> to compare LONG
> columns or use the LIKE predicate...
>
> Anyway, my 2 cents, use it, don;t use it, I leave it with you ;)
>
> Regards,
>
> Carl
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Zabach, Elke
> Sent: 22 May 2002 07:57
> To: 'Markus Gieppner'; Koetter, Thomas Theodor; 'Srdjan Josipovic';
> [EMAIL PROTECTED]
> Subject: RE: Problem with Selecting value of LONG data type column on
> WebPage ADO/ASP on IIS/WIN2k
>
>
> Markus Gieppner wrote:
>
>
> > "in SAP DB you cannot use long columns like "usual" ones in a where
> clause."
> >
> > Is this (even in a very basic/simple/limited form) planned
> for a future
> release?
>
>
> This is not planned in a foreseeable release
>
> Elke
> SAP Labs Berlin
>
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Koetter, Thomas
> Theodor
> > Sent: Tuesday, May 21, 2002 4:25 AM
> > To: 'Srdjan Josipovic'; [EMAIL PROTECTED]
> > Subject: RE: Problem with Selecting value of LONG data type
> column on
> WebPage ADO/ASP on IIS/WIN2k
> >
> >
> > Hi Srdjan,
> >
> > > 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.
> >
> > in SAP DB you cannot use long columns like "usual" ones in
> a where clause.
> >
> >
> > > "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 !
> >
> >
> > Please send me a VB-project and what else is needed to reproduce the
> error.
> >
> >
> >
> > Regards Thomas
> >
> > ----------------------------------------------
> > Dr. Thomas K�tter
> > SAP DB, SAP Labs Berlin
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
