Robert Rodgers
|
| Posted: 04/29/2003, 6:14 AM |
|
Hi All,.
Using CCS2.06, ASP
I need to get the Value of a field that is returned in the select statement
in a list box. It is not the Bound column or the Text (Displayed) column.
Form Name = GameStatistics
ListControlName = GameSysID
GameStatistics.GameSysID.Recordset.Fields("AwayTeamSysID") ' AwayTeamSysID
is not either bound or text property
This is not generating an error but it is also not returning a value. My
guess is that it is because the recordset is at eof or bof. When I try to
do a .MoveFirst I get the error
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'Recordset'
/scweb/hanfordflames/Classes.asp, line 2066
Line 2066 is the Recordset.MoveFirst line in the MoveFirst Method of the
clsDataSource Object.
So this error makes me think the Recordset object has been set to nothing?
So the question is (Finally<g>)
How do I get the value of a Column that is in the select statement of a list
that is not the bound or text properties with out issuing a second select
statement?
thanks.
Rob
--
"Every absurdity has a champion to defend it"
Oliver Goldsmith
++++++++++++++++++++++++++++++
--
"Every absurdity has a champion to defend it"
Oliver Goldsmith
++++++++++++++++++++++++++++++
|
|
|
 |
Kevin
|
| Posted: 04/29/2003, 2:05 PM |
|
put a hidden textbox on you form or learn about CCS's CLASS OBJECTS. While
you can code your way around not using a hidden field it makes it simple on
whoever is going to maintain the code to use a hidden field.
"Robert Rodgers" <rrodgers@sylvancomputing.com> wrote in message
news:b8ltru$1hi$1@news.codecharge.com...
> Hi All,.
>
> Using CCS2.06, ASP
>
> I need to get the Value of a field that is returned in the select
statement
> in a list box. It is not the Bound column or the Text (Displayed) column.
>
> Form Name = GameStatistics
> ListControlName = GameSysID
>
> GameStatistics.GameSysID.Recordset.Fields("AwayTeamSysID") '
AwayTeamSysID
> is not either bound or text property
>
> This is not generating an error but it is also not returning a value. My
> guess is that it is because the recordset is at eof or bof. When I try to
> do a .MoveFirst I get the error
>
> Error Type:
> Microsoft VBScript runtime (0x800A01A8)
> Object required: 'Recordset'
> /scweb/hanfordflames/Classes.asp, line 2066
>
>
> Line 2066 is the Recordset.MoveFirst line in the MoveFirst Method of the
> clsDataSource Object.
>
> So this error makes me think the Recordset object has been set to nothing?
>
>
> So the question is (Finally<g>)
> How do I get the value of a Column that is in the select statement of a
list
> that is not the bound or text properties with out issuing a second select
> statement?
>
> thanks.
>
> Rob
>
> --
> "Every absurdity has a champion to defend it"
> Oliver Goldsmith
> ++++++++++++++++++++++++++++++
>
>
>
> --
> "Every absurdity has a champion to defend it"
> Oliver Goldsmith
> ++++++++++++++++++++++++++++++
>
>
|
|
|
|
Robert Rodgers
|
| Posted: 04/30/2003, 5:03 AM |
|
Kevin,
Can you clarify?
>>put a hidden textbox on you form
And how do I fill it?
I appreciate the time you took to answer my question but if you re read your
answer will see that it is a little vague. At least for me.
Thanks.
Rob
--
"Every absurdity has a champion to defend it"
Oliver Goldsmith
++++++++++++++++++++++++++++++
"Kevin" <kangus@acats.com> wrote in message
news:b8mpea$kf$1@news.codecharge.com...
> put a hidden textbox on you form or learn about CCS's CLASS OBJECTS. While
> you can code your way around not using a hidden field it makes it simple
on
> whoever is going to maintain the code to use a hidden field.
>
>
> "Robert Rodgers" <rrodgers@sylvancomputing.com> wrote in message
>news:b8ltru$1hi$1@news.codecharge.com...
> > Hi All,.
> >
> > Using CCS2.06, ASP
> >
> > I need to get the Value of a field that is returned in the select
> statement
> > in a list box. It is not the Bound column or the Text (Displayed)
column.
> >
> > Form Name = GameStatistics
> > ListControlName = GameSysID
> >
> > GameStatistics.GameSysID.Recordset.Fields("AwayTeamSysID") '
> AwayTeamSysID
> > is not either bound or text property
> >
> > This is not generating an error but it is also not returning a value.
My
> > guess is that it is because the recordset is at eof or bof. When I try
to
> > do a .MoveFirst I get the error
> >
> > Error Type:
> > Microsoft VBScript runtime (0x800A01A8)
> > Object required: 'Recordset'
> > /scweb/hanfordflames/Classes.asp, line 2066
> >
> >
> > Line 2066 is the Recordset.MoveFirst line in the MoveFirst Method of the
> > clsDataSource Object.
> >
> > So this error makes me think the Recordset object has been set to
nothing?
> >
> >
> > So the question is (Finally<g>)
> > How do I get the value of a Column that is in the select statement of a
> list
> > that is not the bound or text properties with out issuing a second
select
> > statement?
> >
> > thanks.
> >
> > Rob
> >
> > --
> > "Every absurdity has a champion to defend it"
> > Oliver Goldsmith
> > ++++++++++++++++++++++++++++++
> >
> >
> >
> > --
> > "Every absurdity has a champion to defend it"
> > Oliver Goldsmith
> > ++++++++++++++++++++++++++++++
> >
> >
>
>
|
|
|
|
|
