02-28-2006 11:21 AM
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 \*.
02-28-2006 11:36 AM
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.
02-28-2006 12:18 PM
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.
02-28-2006 12:42 PM
Looks like line 50 is:
$stmt = $input{'stmt'};
02-28-2006 12:58 PM
That worked. Thanks so much.
02-28-2006 01:46 PM
Glad I could help.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide