 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Joseph Stateson
Guest
|
 Posted: Mon Mar 28, 2005 8:26 pm Post subject: how does one access "non field" values (datepart) |
 |
|
select datepart("dd",MyDate) from table where ....
works just fine useing the database explorer. For a particular month I can
retrieve (for example)
COLUMN1
-------
2
3
5
24
showing me there are 4 days from that month in the database for that
particular year in the query.
problem is I cannot seem to cleanly get those results back into my C++ code,
inspecting MySqlQuery-> showed me the fields, fieldnames and values but i
dont what those. I want the values that are listed under "COLUMN1" ie: the
2,3,5 and 24 plus it would be nice to know there are 4 of them.
MySqlQuery->SQL = "select datepart("dd",MyDate) from MyTable";
MySqlQuery->ExecSQL();
.....????....
where can i extract the fact that there are 4 items whose values are 2,3,5
and 24?? If worse comes to worse, I assume one can fetch each record and
pull out the "day" field, but I would think that the sql query object would
have those values somewhere accessible already. Maybe not???
...thanks in advance..
Joseph "Beemer Biker" Stateson
http://ResearchRiders.org
|
|
| Back to top |
|
 |
Arnie
Guest
|
| Posted: Tue Mar 29, 2005 2:41 pm Post subject: Re: how does one access "non field" values (datepart) |
|
|
Comments in line.
"Joseph Stateson" <jstateson (AT) swri (DOT) edu> wrote
| Quote: | select datepart("dd",MyDate) from table where ....
works just fine useing the database explorer. For a particular
month I can
retrieve (for example)
COLUMN1
-------
2
3
5
24
showing me there are 4 days from that month in the database for
that
particular year in the query.
problem is I cannot seem to cleanly get those results back into
my C++ code,
inspecting MySqlQuery-> showed me the fields, fieldnames and
values but i
dont what those. I want the values that are listed under
"COLUMN1" ie: the
2,3,5 and 24 plus it would be nice to know there are 4 of them.
MySqlQuery->SQL = "select datepart("dd",MyDate) from
MyTable";
|
Try naming the column so you can easily reference it. For
example "... MyDate) AS Column1 FROM MyTable".
Then read it in the normal way (FieldByName).
| Quote: | MySqlQuery->ExecSQL();
|
Don't you mean ->Open() here?
| Quote: | ....????....
where can i extract the fact that there are 4 items whose
values are 2,3,5
and 24?? If worse comes to worse, I assume one can fetch each
record and
pull out the "day" field, but I would think that the sql query
object would
have those values somewhere accessible already. Maybe not???
..thanks in advance..
Joseph "Beemer Biker" Stateson
http://ResearchRiders.org
|
- Arnie
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
