Accessing dataset by name or enumerating fieldnames ?

Scriptcase 8 Discussion
#1

Hi,

is there a way to either enumerate the columns returned from the sc_select so that I can have the list of columns and/or is there a way to get the value of the field by using the fieldname i.e. $ds->fields[‘fieldname’];

Cheers
Sparrow

#2

[QUOTE=sparrow;31405]Hi,

… using the fieldname i.e. $ds->fields[‘fieldname’];

[/QUOTE]

Why don’t you just go ahead and try your own suggestion? :slight_smile:

jsb

#3

Hi jsbinca,

:slight_smile: Well my suggestion is something I came up with but there is no documentation on all the methods and properties available from the dataset.

I’ll try it :slight_smile:

Cheers
Sparrow

#4

[QUOTE=sparrow;31428]Hi jsbinca,

:slight_smile: Well my suggestion is something I came up with but there is no documentation on all the methods and properties available from the dataset.

I’ll try it :slight_smile:

Cheers
Sparrow[/QUOTE]

It’s not clear sadly in documentation, but sc_select returns an ADODBRecordset. You can look into it here: adodb.sourceforge.net/docs-adodb.htm