Select Sum errors

Results 1 to 2 of 2

Thread: Select Sum errors

  1. #1
    Join Date
    Dec 1969

    Default Select Sum errors

    Why is the "maxid = 0 If statement firing" every time? I have 1 record in my database with a magic value of 1. (I broke my code down to the rawest form and I&#039;m still getting "damnit!" <BR><BR><BR>Usql = "select Sum(magic) as maxid from permissions"<BR> Set acrs2 = acConn.Execute(Usql)<BR> <BR> If maxid = 0 then<BR> Response.write "damnit!"<BR><BR> Else<BR> Response.Write "Great"<BR> End if <BR><BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Select Sum errors

    try this<BR><BR>If clng(acrs2("maxid")) = 0 then

Posting Permissions

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