Yep you could use GetRows instead. That'll give you better performance, but I find arrays more fiddly to work with.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of GLSmyth Sent: 15 April 2005 3:54 To: [email protected] Subject: Re: [ASP] Does Order Matter? 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 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/
