I have a question about a Select Case, and how to go about writting it.
In my pages, I call to a SQL Database, that returns values from a column. The columns present two types of data, numeric and varchar
2N or .10 (they present nickles)
I would like my onscreen to display images, instead of that value (once they have been found).
Where 2N = imageNickle + imageNickle, as well as .10 = imageNickle + imageNickle (or display 2 of the images in place, rather)
I would like to just focus on the (varchar) at this point. Is their an easier way to write a select statement than say:
Select Case howManyImages
If columnValue = 2N then
displayValue = "/imageNickle.jpg" & "/imageNickle.jpg"
ElseIf columnValue = 3N Then
displayValue = "/imageNickle.jpg" & "/imageNickle.jpg & "/imageNickle.jpg"
or is this pretty simple as it is?
View Complete Post