This is totally bizzare. I am hoping that someone can come up with an
explanation, as I am stimied. I must have played with this for an
hour before stumbling on the answer.
Here is the code, which is not anything strange or unusual:
strSQL = "Select ADDRSAL_ADDRESSEE, DatePosted,
tblTicketExchange.DateEnd, Category, Message, TType,
tblTicketExchange.Game " & _
"From tblTicketExchange Inner Join tblTicketExchangeGames On
tblTicketExchange.Game = tblTicketExchangeGames.Game " & _
"Inner Join REviaIE..CCBioCONSTITUENT On Requestor = Bio_ID " & _
"Where tblTicketExchange.DateEnd >= '" & Date - 300 & "' Order By
tblTicketExchangeGames.DateEnd, TType, DatePosted"
objCommand.CommandText = strSQL
Set objRec = objCommand.Execute
While Not objRec.EOF
TType = objRec("TType")
Game = objRec("Game")
... etc.
This works fine and allows me to do what I need to do.
However, if the last two lines are swapped:
Game = objRec("Game")
TType = objRec("TType")
then I do not get a value for TType.
Both are varchar and dfined exactly the same, with the exception that
Game is allowed more characters.
Does anyone have a clue as to why grabbing these values in one order
works, while grabbing them in another order does not?
I am completely perplexed with this, and am hoping that someone can
shed some light on this strangeness.
Thanks -
george
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
