Simcha, I think #521 is the error number for that day in that namespace. In the control panel, go to Logs, and then either Application errors (if this is Cache direct or Objectscript code), or ODBC errors (if this is generated through and ODBC access). Then open up the namespace you are running the query in, and then the date the error occurred. It should give you a lot more information about the error. Mark
"Gershon Simcha" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi > > Just for the knowledge. > > The problem is when i have a query with a WHERE %STARTWITH together with > HAVING and the %STARWITH is a STRING ( when an INTEGER there is no problem). > So as usually i didn't solve but by passed the problem by cutting out the > WHERE as not neede when i have the HAVING. > When i'll have more time i'll do some reasarch on the problem. > Simcha > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.737 / Virus Database: 491 - Release Date: 11/08/04 > >
