hi
through my stored procedure i m returning such a string
Code:
 SET @vsResult = 'SUPPLIER CODE / ' + ISNULL(CONVERT(VARCHAR,@vnSupplierID),'<BLANK>') 
 SET @vsResult = @vsResult + ' ' + 'PRODUCT CODE / ' + ISNULL(CONVERT(VARCHAR,@vsProductCode),'<BLANK>')
 SET @vsResult = @vsResult + ' ' +'GL CATEGORY CODES / ' + ISNULL(CONVERT(VARCHAR,@vsGLCategoryCode),'<BLANK>') 
 SET @vsResult = @vsResult + ' ' + 'RESULT: '
in my procedure its returning string as i expected.but problem is in my vb it does not showing <BLANK> TAG.
Code:
With mobjDatabaseReader
                    .SPRun msMsgStoreConnection, _
                    SP_BULKIMPORT_PRODUCTGLCATEGORYDATA, _
                    .MakeParameter("@vnMemberID", adtInteger, apdParamInput, , vlSender), _
                    .MakeParameter("@vnSupplierID", adtInteger, apdParamInput, , asLineCols(lCount, 0)), _
                    .MakeParameter("@vsProductCode", adtVarChar, apdParamInput, 50, asLineCols(lCount, 1)), _
                    .MakeParameter("@vnIsStock", adtInteger, apdParamInput, , IIf(asLineCols(lCount, 2) = "Y", 1, 0)), _
                    .MakeParameter("@vsGLCategoryCode", adtVarChar, apdParamInput, 1000, asLineCols(lCount, 3)), _
                    .MakeParameter("@rsResult", adtVarChar, apdParamOutput, 1000), _
                     vsResult
                End With
what could be problem.
thanks