select problem with dbreader

[GeorgeLarson]

I am trying to execute a query via dbreader and everytime I input my sql statement, it gives me a error and changes the * to \*.

[nhabib]

If you are running LMS 2.2 (CS 2.2 + RME 3.5), backup up the following file:

NMSROOT/cgi-bin/dbadmin/pdbadmin/nph-dbreader.pl

Edit nph-dbreader.pl and insert the following line after line 50:

$stmt =~ s/\\//g;

That should take care of the issue you are running into.

[GeorgeLarson]

Just to be sure I don't screw this up, what does line 50 say so I make sure I am in the right spot.

[nhabib]

Looks like line 50 is:

$stmt = $input{'stmt'};

[GeorgeLarson]

That worked. Thanks so much.

[nhabib]

Glad I could help.