July 14th, 2003, 02:50 PM
|
|
Junior Member
|
|
Join Date: Jul 2003
Posts: 20
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
If Field = 0 Then Don't Print
Hey Guys need some help I want something not to print if the field is = to zero... here is my code
Code:
If oRS.EOF OR oRS.BOF Then
Response.Write "No Records Found"
Else
oRS.MoveFirst
Do While NOT oRS.EOF
Response.Write oRS("AssemblyName") & "<br>"
Response.Write oRS("NumberOfPartA") & "<br>"
Response.Write oRS("NumberOfPartB") & "<br>"
Response.Write oRS("NumberOfPartC") & "<br>"
Response.Write oRS("NumberOfPartD") & "<br>"
Response.Write oRS("NumberOfPartEK") & "<br>"
Response.Write oRS("NumberOfPartEA") & "<br>"
Response.Write oRS("NumberOfPartEB") & "<br>"
Response.Write oRS("NumberOfPartF") & "<br>"
oRS.MoveNext
Loop
End If
What I was wanting was if say NumberOfPartA is zero then don't print it. Is there some If Then Statement that I could use?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
