Error 13 Type Mismatch

[alanmac]

Hi,

I am new to this group and new to VB6.

I have an ASP page which currently calls down to the DB three times to get information. I have been given the task of writing an SP which amalgamates the three previous SP's so that only one call is made.

Having written this new SP I executed it in SQL Server management studio and it returned the information I wanted.

However, when I altered the page to make just one call to this new SP it is returning nothing, just the Err.Number 13 and the Err.Description Type Mismatch. I am passing it 4 input parameters and one output parameter (all are integers). I am not able to debug the code at the moment due to network difficulties but if anyone can think of a possible reason for this I can investigate them once the network is back up.

Any help would be much appreciated.

[debasisdas]

It is really difficult to predict anything / what is wrong with your code.
Can you kindly post your code for reference of out experts please.

[Killer42]

Yes, more info required I think.

In the meantime, can you double-check that all fields are in fact defined as numeric in the database? Any that aren't will require delimiters (probably single quotes) around them.

Also, check that you haven't left out a space or something when concatenating everything.

Another possibility - could one of your search values be null or something?

[alanmac]

Hi guys,

I found the problem: the new SP was calling 2 other Sp's internally and filling a couple of temp tables. I then joined these tables to a view to populate a third temp table, then returned this table. The problem was, I didn't set NOCOUNT ON in the new SP, so it was trying to return all 4 select statements. It had nothing to do with the code or ASP page.

Sorry about that.