[office politics]

i got this code to check if a user set only one of three values. With this code as is i get Line:18 Col:0 Expected 'End' Syntax Error:. I think its telling me to change my first else to a end if. when i change all my else's to end if's then i get the following error Line:18 Col:4 Expected 'Function' Syntax Error:.

i=0

if SEND_TO = NC then
i=i+1
end if

if UW_USERID = NC then
i=i+1
end if

if GOTO_AUTH = NC then
i=i+1
end if

if i = 0 then GETTRUEFALSE = FALSE
else
if i < 2 then GETTRUEFALSE = TRUE
else
if i = 3 then GETTRUEFALSE = FALSE
end if

[Emily]

I don't know vbscript but my guess would be that you need another End If at the end of your code, since you have one if/else statement nested within another one, but only one end if.

[office politics]

i modeled after an example at http://www.w3schools.com/vbscript/tr...=vbdemo_elseif

function greeting()
i=hour(time)
If i = 10 then
	document.write("Just started...!")
elseif i = 11 then
	document.write("Hungry!")
elseif i = 12 then
	document.write("Ah, lunch-time!")
elseif i = 16 then
	document.write("Time to go home!")
else
	document.write("Unknown")
end if
end function

[Emily]

In that example there's only one if/elseif statement, but in your code you have nested statements. I indented the statements so you can see where you need the extra end if.

i=0

if SEND_TO = NC then
    i=i+1
end if

if UW_USERID = NC then
     i=i+1
end if

if GOTO_AUTH = NC then
     i=i+1
end if

if i = 0 then GETTRUEFALSE = FALSE
else
     if i < 2 then GETTRUEFALSE = TRUE
     else
          if i = 3 then GETTRUEFALSE = FALSE
     end if
END IF 

The end if in capitals is the one I added that you were missing.

[mack]

Because it's wrong.

Wrong:

if i = 0 then 
 GETTRUEFALSE = FALSE
else
if i < 2 then GETTRUEFALSE = TRUE
else
if i = 3 then GETTRUEFALSE = FALSE
end if

Right (faster)

Select Case i
  Case 0: GetTrueFalse = False
  Case < 2: GetTrueFalse = True
  Case 3:  GetTrueFalse = False
End Select

Should work if you have i as in integer (Dim as integer) if you're using VB6 but if you're not youll need to convert it to an integer by doing:

int(i)

So change:

Select Case int(i)

Hope it helps

[mack]

If you want to see some good examples of the use of Visual Basic, visit http://sidrahq.com and click "Downloads" and download the source code.