Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Not sure what is occuring in this code

Status
Not open for further replies.
vb89

vb89

MIS
Aug 21, 2008
47
US
Can somone please explain to me what is happening in this code...

Code: 
If InStr(iTeamID,"lg") Then
	  		iLeagueID = Replace(iTeamID,"lg","")
	  		iTeamID = ""
	  		tTeamName = ""
		Else
			iLeagueID="9"  'All players (I-A and I-AA)
		End If
 
Sort by date Sort by votes
The InStr() function find strings within strings so the first InStr is looking at the string contained in iTeamID and seeing if it contains the value "lg". If it find it, then the second function Replace() is run and in the string contained in iTeamID, it is replacing "lg" with an empty (blank) string value "".
Else it sets the iLeagueID to 9.

Paul
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Question
Code does not run in Microsoft Edge - it does in Google Chrome
Replies
3
Views
332
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
write HTML code within ASP line
Replies
1
Views
379
xwb
xwb
leifoet
  • Locked
  • Question
Wrong code in a href ?
Replies
1
Views
278
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
Parse a database field that is comma delimited and input the results into another table
Replies
0
Views
261
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
How to check if a datatable is empty ?
Replies
0
Views
281
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top