Hi, On Tue, 18 Feb 2003, Martin Edenhofer 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. CU, Wolfgang _______________________________________________ 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
