else if stament not working help

Results 1 to 4 of 4

Thread: else if stament not working help

  1. #1
    Join Date
    Dec 1969
    Posts
    617

    Default else if stament not working help

    why does this not work<BR><BR>&#060;% <BR>If RecordSet.EOF Then <BR> Response.Write "&#060;TR&#062;&#060;TD&#062;&#060;H5&#062;The re are no records in the result&#060;/H5&#062;&#060;/TD&#062;&#060;/TR&#062;" <BR>Else if <BR> RecordSet ("loadstomove") = false then<BR> Response.Redirect("pending.asp")<BR>Else if<BR> RecordSet ("loadstomove") = true then<BR>%&#062;<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    2,049

    Default RE: else if stament not working help

    &#060;% <BR>If RecordSet.EOF Then <BR> Response.Write "&#060;TR&#062;&#060;TD&#062;&#060;H5&#062;The re are no records in the result&#060;/H5&#062;&#060;/TD&#062;&#060;/TR&#062;" <BR>Elseif RecordSet ("loadstomove") = false then<BR> Response.Redirect("pending.asp")<BR>Else<BR> &#039; something here<BR>End if<BR>%&#062;<BR>

  3. #3
    Join Date
    Dec 1969
    Posts
    617

    Default RE: No sorry its not the else if its the select st

    its this at the end i also need to add another AND <BR><BR>so it selects everthing where confirmend = true (but because this is a checkbox if it is unchecked it is also true how do i get around this see if it is unchecked i dont want to show it)<BR><BR>Set RecordSet = objConn.execute("Select Vehicle.*, V_Leg_Instance.* From Vehicle, V_Leg_Instance where Vehicle.Vehicle_Reg = V_Leg_Instance.Vehicle_Reg AND Comp_ID=" & session ("CompanyID") & " AND confirmed="& true &"") <BR>

  4. #4
    Join Date
    Dec 1969
    Posts
    2,049

    Default RE: No sorry its not the else if its the select st

    Dim confirmed<BR>confirmed = false<BR>If Request("checkbox") &#060;&#062; "" Then confirmed = true


Posting Permissions

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