Thank you for the response. So then is this a case where I need to retreive the information in the same order as it was selected? I would have thought that one could obtain the column value from a record regardless of its position. I've just never come across this before, and I have written quite a few programs using ASP.
If this is the case then I guess it is another tick in favor of using GetRows instead of looping. Cheers - george --- In [email protected], Adrian Forbes - ITD <[EMAIL PROTECTED]> wrote: > 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/
