View Single Post
  #1 (permalink)  
Old October 10th, 2003, 10:27 PM
U.N.C.L.E. U.N.C.L.E. is offline
Friend of Wrox
Points: 422, Level: 7
Points: 422, Level: 7 Points: 422, Level: 7 Points: 422, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2003
Location: La Jolla, CA, USA.
Posts: 112
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL SELECT & aliases

I have a query:

SELECT ClientID AS ID, Name AS [User Name]
FROM tblClients

Is it possible to use both in ADO? (my explanation of why I need to do this is too long):

rs.fields("ClientID")
  ...or...
rs.fields("ID")

I get an error saying that field is not a member of the collection...


Reply With Quote