I've written an application in which the user can choose certain things.
Depending on this choice a table in the Database is selected.
Therefore, i've use the objRS.Fields().Value to get the data.

All the table have the following layout: 

ID - Name - Catalog - Image

When using it on the server here at home objRS.Fields(1).Value refers to 
Column 'Name'.

When using the same page on the website however, i need to use objRS.Fields
(2).Value to refer to the column 'Name'

What is wrong over here?

Thankz

> ID - Name - Catalog - Image
>
> When using it on the server here at home objRS.Fields(1).Value refers to
> Column 'Name'.
>
> When using the same page on the website however, i need to use
objRS.Fields
> (2).Value to refer to the column 'Name'

Do you select like this:
SELECT ID, Name, Catalog, Image FROM tbYourTable"

... or like this:
SELECT * FROM tbYourTable
?

If you are using the asterisk-version try the first one instead!

HTH
~J

Yes, i do use the * version; haven't tryed the other option yet, but how 
it it possible that the asterisk version works fine on the test server, 
while the page on the internet server gives problems?



> > ID - Name - Catalog - Image
>
> When using it on the server here at home objRS.Fields(1).Value refers to
> Column 'Name'.
>
> When using the same page on the website however, i need to use
objRS.Fields
> (2).Value to refer to the column 'Name'

Do you select like this:
SELECT ID, Name, Catalog, Image FROM tbYourTable"

... or like this:
SELECT * FROM tbYourTable
?

If you are using the asterisk-version try the first one instead!

HTH
~J

objRS("Name") would work with both versions, for the current record of 
course.


> Yes, i do use the * version; haven't tryed the other option yet, but how 
i> t it possible that the asterisk version works fine on the test server, 
w> hile the page on the internet server gives problems?

> 

> > > ID - Name - Catalog - Image
>> 
>>  When using it on the server here at home objRS.Fields(1).Value refers 
to
>>  Column 'Name'.
>> 
>>  When using the same page on the website however, i need to use
o> bjRS.Fields
>>  (2).Value to refer to the column 'Name'

> Do you select like this:
S> ELECT ID, Name, Catalog, Image FROM tbYourTable"

> ... or like this:
S> ELECT * FROM tbYourTable
?> 

> If you are using the asterisk-version try the first one instead!

> HTH
~> J

>> Yes, i do use the * version; haven't tryed the other option yet, but how
>> it it possible that the asterisk version works fine on the test server,
>> while the page on the internet server gives problems?

With the * version, you can never be *sure* in what order your fields get
returned...

~J