Hi Wolfgang, On Wed, Feb 19, 2003 at 08:59:24AM +0100, Wolfgang Rosenauer wrote:
> > > But now I get many errors because many statements are doing things like > > > this: > > > > > > SELECT count(*) FROM ticket as st, queue as sq, personal_queues as suq, > > > ticket_state tsd, ticket_lock_type slt ... > > > > > > the keyword "as" is not accepted by SAPDB and its right. IMHO is this > > > keyword not allowed here. > > > > Is it working if you use the same statement without "as"? > > it seems so. The modified statement doesn't throw an error any longer. > But I was not able to log in as root yet, because I didn't have the time > to modify all statements, which are performed while login. > So I cannot really decide if the system works. Hmm... Wolfgang, is it possible to get a shell account on a machine with SAPDB? So I could play a little bit! > CU, > Wolfgang Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneier _______________________________________________ OpenTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
