Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

select problem with dbreader

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 \*.

5 REPLIES
Red

Re: select problem with dbreader

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.

New Member

Re: select problem with dbreader

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.

Red

Re: select problem with dbreader

Looks like line 50 is:

$stmt = $input{'stmt'};

New Member

Re: select problem with dbreader

That worked. Thanks so much.

Red

Re: select problem with dbreader

Glad I could help.

136
Views
0
Helpful
5
Replies
CreatePlease to create content