Question

Hi, I am using DatabasePlugin. I am able to query the MS SQL table and get the data out but when displayed, it seems to be appended with a space. For example, when I run the command

%DATABASE_SQL{description="staff" sql="select StaffName from staffdetails where staffid='2'" format="$StaffName"}%

from the database:

The output is Xyz .(with a space after Xyz) and not just Xyz. This will create problems when I want to do some operations on the retrieved data (like compare etc). What could be the problem and how do I get around it ?

Environment

-- ChengappaCB - 10 Dec 2008

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

Looks like I jumped the gun. It was not the space but the newline. I used the separator parameter and changed the command to:

%DATABASE_SQL{description="staff" sql="select StaffName from staffdetails where staffid='2'" format="$StaffName" separator="$nop"}%

Now it seems to be working fine. But I have another problem mentioned in UseDatabasePluginSpreadsheetPlugin

-- ChengappaCB - 10 Dec 2008