Thread: tag is not displaying in vb

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

How are you displaying it in VB?

like this
vsAllResults = vsAllResults & vsResult & vbNewLine

Okay, but how is it output to the user? popup box? Is it assigned to a Visual Basic form value? Is this being used in conjunction with ASP?

What happens if you replace '<blank>' in your stored procedure with 'testing'?

this output goes to in a txt file.and let me check for this
What happens if you replace '<blank>' in your stored procedure with 'testing'?

yeah JMH u are rite
What happens if you replace '<blank>' in your stored procedure with 'testing'?

i chnaged <blank> with 'testing' but even testing also not getting.but in analyzer i m getting.what the hail going on?

Any idea?
thanks

guys gotted now.actaully from my dll i was passing blank and in my procedure checking for null.
now changed in vb blank to null.

JMH thanks a lot