Update form not functioning correctly (VB/SQL)

[Red_Star20]

Does anyone see anything wrong with the If statement? It has not been working
as it should. It does update the accepted_program field to dropped....
I am totally perplexed


checkStatus = false
For i = 0 to 6

'response.Write(i)
updateStatus = Request.Form("sltStatus" & i + 1)
choice = rsUpdateStatus("choice" & i + 1)
'Response.Write(updateStatus)
'Response.Write(choice)

'Response.Write(i & "<br />")
if updateStatus <> "Accepted" And Not choice = "India Add on" Then
checkStatus = true
' response.Write("where in first")
' response.Write(checkStatus & "i is " & i)
else
'response.write("finallay")
'Response.Write(choice)
checkStatus = false
exit for
End if

Next

If checkStatus = true Then
strSQL = "UPDATE student_data SET Accepted_Program = 'Dropped' WHERE
BannerID = "& CurrentBannerID
dbConnection.execute(strSQL)
end if

 

[p c]

it is perplexing.

 

[Tom [Pepper] Willett]

Why do you continue trolling these newsgroups with cr*p answers?

--
===
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---
FrontPage Support:
http://www.frontpagemvps.com/

About FrontPage 2003:
http://office.microsoft.com/home/office.aspx?assetid=FX01085802
===
| it is perplexing.
|
| Red_Star20 wrote:
| > Does anyone see anything wrong with the If statement? It has not been
working
| > as it should. It does update the accepted_program field to dropped....
| > I am totally perplexed

 

[p c]

are you the police?