Re: Referencing data column by it's name



Bob wrote on Mon, 27 Nov 2006 06:38:03 -0500:

Daniel Crichton wrote:
What nobody else spotted is that ADO uses a zero based field numbering
system, so the first column is actually rs(0), not rs(1).

What do you mean? That idea iss certainly featured in my second reply ...
:-)

Missed that. Sorry.

And how do you kn ow he wasn't using "COLUMN 1" to refer to the second
field in his resultset? ;-)

Hmm, true, I guess I interpreted that as meaning "the first column", rather
than column ordinal 1.

(again ... the problem with using selstar)

Indeed.

Dan


.



Relevant Pages

  • Re: Referencing data column by its name
    ... Daniel Crichton wrote: ... system, so the first column is actually rs, not rs. ... That idea iss certainly featured in my second reply ... ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • SV: Combobox
    ... The C items in the first column, ... > Yes Dan, I know. ... >>> I found the KeyPress event. ... I can get the Key Code for each ...
    (microsoft.public.fox.programmer.exchange)
  • Re: forms, tables, codes, and their relations --HELP!
    ... in the table, i have each row committed to a particular student, with ... each code has a particularl meaning. ... with the first column being the code and the second ... The width of the second column can be whatever you want it to be, ...
    (microsoft.public.access.forms)
  • creating tables in word, 2 colums, not 50% each
    ... I'm using VBScript to create a word document, ... first column to be 30%, and the second column to be 70% - how can I acheive ... Dan ...
    (microsoft.public.scripting.vbscript)