nullable params for a sproc

Posts   
 
    
yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 09-Feb-2008 19:31:59   

version 1.0.2005.1 final (adapter) VS2005 asp.net 2.0


hiya,

I'm using the retrievalProcedures to call sprocs. Some of my sprocs have nullable params, so that they'll bring back:

1) data for a single row if I pass in the ID int paremeter. 2) data for every row if the ID int paremeter is null.

I generate the llblGenPro project, but the param list for the retrievalProcedure won't letme call the sproc without specifying an int param.

Why isn't there an overload that doesn't take an int paremeter?

How can I tweak llblgenPro so that it provides this overload?

Or maybe there is another appraoch that I should take?

Many thanks,

yogi

goose avatar
goose
User
Posts: 392
Joined: 06-Aug-2007
# Posted on: 09-Feb-2008 20:47:57   

see this thread: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=6959

If it was my code I would rather use a -1 or another flag value instead of a null.