It's common to have these problems when retrieving SQL Server TEXT fields or Access MEMO fields. If it is an issue then retrieve the results in SELECT order into local vars and then use the local vars in any order you want.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of GLSmyth Sent: 15 April 2005 3:37 To: [email protected] Subject: [ASP] Does Order Matter? 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 The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited --------------------------------------------------------------------- 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/
