i have made fairly substantial progress in the Oracle port, in
fact I am running up against limitations due to stubs and
I have attached a new schema file as I had not updated the Tickets table (my apologies). There is also one more change in the In DBIx/EasySearch.pm file: Routine _DoSearch Change # $QueryString = "SELECT distinct main.* FROM " . $self->_TableAliases; $QueryString = "SELECT main.* FROM " . $self->_TableAliases; Since all tables have primary keys I believe the DISTINCT clause is redundant. If I am wrong please let me know. Functionality that has been tested this week rt -response rt -comments rt -resolve rt -stall rt -open rt -due rt -show rt -subject rt -queue rt -prio rt -finalprio rt -notify rt -kill
Senior Database Administrator
Internet Barter Inc.
schema.Oracle (22 KB)