keijen
|
Posted: 06/12/2003, 8:42 PM |
|
Hi All,
CCS2.1, ASP (vbscript)
Just need a pointer on a how-to...
Confirm please - when a grid (grdProducts) is filled will there be a
recordset addressable as grdProducts.Recordset ??
Assuming that's so, (?)...
One of the fields in grdProducts.Recordset is LevelColor, containing a color
value.
How do I use CCGetValue() to get the actual color value in the field. I'd
prefer not to use a hidden field to achieve this.
In a Before Show of a label in the grid I have:
**
Dim mColor
mColor = CCGetValue(grdProducts.Recordset,"LevelColor")
but I get no values
Can someone explain how I use CCGetValue correctly.
TIA
Mike.
|
|
|
DonB
|
Posted: 06/13/2003, 4:46 AM |
|
Keep in mind the recordset behind your grid will have its "current" record
change as the grid populates. It is likely the recordset is positioned at
EOF when the label "show event" fires.
To manipulate fields in the recordset on a row-by-row basis, put your code
into the BeforeShowRow event, which will ensure it executes while each row
of the recordset is "current".
DonB
"keijen" <keijen@ozemail.com.au> wrote in message
news:bcbh6p$b3$1@news.codecharge.com...
> Hi All,
>
> CCS2.1, ASP (vbscript)
>
> Just need a pointer on a how-to...
>
> Confirm please - when a grid (grdProducts) is filled will there be a
> recordset addressable as grdProducts.Recordset ??
> Assuming that's so, (?)...
> One of the fields in grdProducts.Recordset is LevelColor, containing a
color
> value.
>
> How do I use CCGetValue() to get the actual color value in the field. I'd
> prefer not to use a hidden field to achieve this.
> In a Before Show of a label in the grid I have:
> **
> Dim mColor
> mColor = CCGetValue(grdProducts.Recordset,"LevelColor")
>
> but I get no values
> Can someone explain how I use CCGetValue correctly.
>
> TIA
>
> Mike.
>
>
|
|
|
keijen
|
Posted: 06/15/2003, 4:50 PM |
|
Thanks DonB,
>>>It is likely the recordset is positioned at EOF when the label "show
event" fires.
I'll change to Before Show Row and see what I get.
Mike
"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:bccdi6$rp1$1@news.codecharge.com...
> Keep in mind the recordset behind your grid will have its "current" record
> change as the grid populates. It is likely the recordset is positioned at
> EOF when the label "show event" fires.
>
> To manipulate fields in the recordset on a row-by-row basis, put your code
> into the BeforeShowRow event, which will ensure it executes while each row
> of the recordset is "current".
>
> DonB
>
>
> "keijen" <keijen@ozemail.com.au> wrote in message
>news:bcbh6p$b3$1@news.codecharge.com...
> > Hi All,
> >
> > CCS2.1, ASP (vbscript)
> >
> > Just need a pointer on a how-to...
> >
> > Confirm please - when a grid (grdProducts) is filled will there be a
> > recordset addressable as grdProducts.Recordset ??
> > Assuming that's so, (?)...
> > One of the fields in grdProducts.Recordset is LevelColor, containing a
> color
> > value.
> >
> > How do I use CCGetValue() to get the actual color value in the field.
I'd
> > prefer not to use a hidden field to achieve this.
> > In a Before Show of a label in the grid I have:
> > **
> > Dim mColor
> > mColor = CCGetValue(grdProducts.Recordset,"LevelColor")
> >
> > but I get no values
> > Can someone explain how I use CCGetValue correctly.
> >
> > TIA
> >
> > Mike.
> >
> >
>
>
|
|
|
|