Typical! :-) I think I've found the answer! It's possible to specify the fields you want to return with GetRows(rows,start,"field1")
Cheers, Nick :> -----Original Message----- :> From: Nick Middleweek [mailto:[EMAIL PROTECTED]] :> Sent: 30 August 2002 02:07 :> To: ActiveServerPages :> Subject: One Select, 3 columns to fill 3 arrays? :> :> :> Hello, :> :> I can't think straight at the moment. Is it possible to do this... :> :> :> Perform ONE select field1, field2, field3 from ... operation on :> my MSSQL db. :> :> And then perform something similar to GetRows on the objRS so I end up :> copying the column data into the 3 arrays. :> :> Can I do this quickly? :> :> Or do I need to loop through the objRS with MoveNext - I was :> trying to avoid :> this and wanted a quick solution like GetRows. :> :> I know I can do GetRows, then loop through that 2D array but :> that's kind of :> slow as well isn't it? :> :> :> Any ideas? :> :> Thanks, :> Nick :> :> :> --- :> You are currently subscribed to activeserverpages as: :> [EMAIL PROTECTED] :> To unsubscribe send a blank email to :> %%email.unsub%% :> --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
