need help

Results 1 to 2 of 2

Thread: need help

  1. #1
    matias Guest

    Default need help

    CREATE Procedure sp sample <BR>(@aid int, <BR>@bID int) <BR>AS <BR>Select Count(*) From SAMPLETABLE <BR>Where Entered = @aid <BR><BR>From this stored procedure i am getting the result and it is an integer. <BR>What i need now is using this result <BR>i have to write a funtion in a ASP page <BR>which will show "Ordinary" when the count is 1 <BR>and "Special" when the count is greater than 1 <BR>when the function is called in the ASP page. <BR><BR>can any body help me to write the code in function <BR>Thanks in Advance. <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: need help

    what language you using&#062;?<BR><BR>not that it metters - here&#039s the abstract :<BR><BR>your SP returns an integer (or you can convert it to an integer)<BR><BR>If int &#062; 1 then<BR>.. do something<BR>else<BR>.. do something else<BR>end if <BR><BR>or<BR><BR>if(int&#062;1) {<BR>.... do something<BR>}<BR>else {<BR>..... do something else<BR>}<BR><BR><BR><BR>your name einstein or what?<BR><BR>j

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts