|
Home > Archive > MS SQL Server ODBC > June 2005 > Retrieving entire columns from a resultset
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Retrieving entire columns from a resultset
|
|
| MithilaP 2005-06-24, 8:23 pm |
| Hi,
I would like to know if there is anyway of retreiving an entire column of
data from a resultset into say an array or a vector.
e.g. If the resultset contains columns ID (int), Name(varchar), age(int)
then I'd like retrieve the ID values from each tuple in one go into say an
int array or a vector.
(I am using a mysql database and a mysql ODBC driver to connect to it)
Thanks,
Mithila
| |
| Scot T Brennecke 2005-06-25, 3:23 am |
| It sounds like you may be able to use what's called "bulk row fetching".
What language, version, libraries, etc. are you using?
In article <F6874AB5-D7C4-4B22-A675- FAA2F3039DE0@microso
ft.com>,
MithilaP@discussions
.microsoft.com says...
> I would like to know if there is anyway of retreiving an entire column of
> data from a resultset into say an array or a vector.
>
> e.g. If the resultset contains columns ID (int), Name(varchar), age(int)
> then I'd like retrieve the ID values from each tuple in one go into say an
> int array or a vector.
>
> (I am using a mysql database and a mysql ODBC driver to connect to it)
| |
| MithilaP 2005-06-28, 1:23 pm |
| Hi,
I am using C++ (compatible with visual studio 6), mysql odbc driver 3.51,
mysql 4.0.12.
Thanks,
Mithila
"Scot T Brennecke" wrote:
> It sounds like you may be able to use what's called "bulk row fetching".
> What language, version, libraries, etc. are you using?
>
> In article <F6874AB5-D7C4-4B22-A675- FAA2F3039DE0@microso
ft.com>,
> MithilaP@discussions
.microsoft.com says...
>
| |
| Scot T Brennecke 2005-06-28, 8:23 pm |
| Are you using MFC and a class derived from CRecordset to perform the
ODBC? If so, you can use the built-in support for "bulk record field
exchange" in your application. If not using MFC, you can still use the
same methodology that MFC uses and call the ODBC functions directly, if
you look at the MFC source code and the DBFETCH sample.
In article <35887A32-F785-4841-A46A- 202CA49B19B3@microso
ft.com>,
MithilaP@discussions
.microsoft.com says...[color=darkred]
> Hi,
>
> I am using C++ (compatible with visual studio 6), mysql odbc driver 3.51,
> mysql 4.0.12.
>
> Thanks,
> Mithila
>
> "Scot T Brennecke" wrote:
>
|
|
|
|
|