RE: C API: mysql_data_seek
Hi,
Thanks for ur reply.
When i commented out the mysql_data_seek() function, mysql_fetch_row()
returns me a non-NULL value (this should be the first row from the MResult).
This results show that I've a valid connection and/or query. And when I
call mysql_fetch_row() again (retrieving the 2nd row from the MResult,
which is the desired row), it returns me a non-NULL value too. From this
result, I know that I've not seek past the result set. However, with the
addition of the mysql_data_seek(MResult, 1) function, a NULL value is
returned. And that's where I don't know how the mistake was made.
Please advice and thanks.
wv
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2002 23:03
To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED]
Subject: Re: C API: mysql_data_seek
Hi,
It's ok but you must retrieve data from row.
int sql_result;x,i;
MYSQL_RES *MResult;
MYSQL_ROW *row;
MYSQL *MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);//mysql_store_result return in
MResult not in MQuery (here was :...mysql_store_result(MQuery))
mysql_data_seek(MResult, 1); //it's ok here...i suppose you whish to
retrieve data from 2-nd row
row = mysql_fetch_row( MResult) ;// if you have a valid connection(or
query) mysql_fetch_row should return non NULL value.
i = mysql_num_fields(MResult) ;
for ( x = 0 ; x i ; x++ )
{
printf(Data from MYSQL_ROW : %s \n,row[x]);
}
mysql_free_result( res ) ;
I hope it's help.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 9:29 PM
Subject: C API: mysql_data_seek
Hi,
I'm using the MySQL built-in C function, mysql_data_seek, for accessing a
particular row from the Result (MYSQL_RES) returned by mysql_store_result.
int sql_result;
MYSQL_RES *MResult;
MYSQL_ROW row;
MYSQL MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);
mysql_data_seek(MResult, 1);
row = mysql_fetch_row(MResult);
However, row returns NULL. I wonder if I've made any mistake in the
process. Can someone please help to check? In addition, is there any
special considerations when using this function?
Thanks in advance.
wv
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C API: mysql_data_seek
Hi,
If i understand well you use twice mysql_data_seek.If you use
mysql_data_seek() after mysql_fetch_row() the effect is NULL.
Because mysql_data_seek() (in fact) set the cursor (if we can said like
this...) in the MResult (MYSQL_RES) and not in the row (MYSQL_ROW).
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 10:13 AM
Subject: RE: C API: mysql_data_seek
Hi,
Thanks for ur reply.
When i commented out the mysql_data_seek() function,
mysql_fetch_row()
returns me a non-NULL value (this should be the first row from the
MResult).
This results show that I've a valid connection and/or query. And when I
call mysql_fetch_row() again (retrieving the 2nd row from the MResult,
which is the desired row), it returns me a non-NULL value too. From this
result, I know that I've not seek past the result set. However, with the
addition of the mysql_data_seek(MResult, 1) function, a NULL value is
returned. And that's where I don't know how the mistake was made.
Please advice and thanks.
wv
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2002 23:03
To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED]
Subject: Re: C API: mysql_data_seek
Hi,
It's ok but you must retrieve data from row.
int sql_result;x,i;
MYSQL_RES *MResult;
MYSQL_ROW *row;
MYSQL *MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);//mysql_store_result return
in
MResult not in MQuery (here was :...mysql_store_result(MQuery))
mysql_data_seek(MResult, 1); //it's ok here...i suppose you whish to
retrieve data from 2-nd row
row = mysql_fetch_row( MResult) ;// if you have a valid connection(or
query) mysql_fetch_row should return non NULL value.
i = mysql_num_fields(MResult) ;
for ( x = 0 ; x i ; x++ )
{
printf(Data from MYSQL_ROW : %s \n,row[x]);
}
mysql_free_result( res ) ;
I hope it's help.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 9:29 PM
Subject: C API: mysql_data_seek
Hi,
I'm using the MySQL built-in C function, mysql_data_seek, for accessing
a
particular row from the Result (MYSQL_RES) returned by
mysql_store_result.
int sql_result;
MYSQL_RES *MResult;
MYSQL_ROW row;
MYSQL MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);
mysql_data_seek(MResult, 1);
row = mysql_fetch_row(MResult);
However, row returns NULL. I wonder if I've made any mistake in the
process. Can someone please help to check? In addition, is there any
special considerations when using this function?
Thanks in advance.
wv
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: C API: mysql_data_seek
Hi Gelu,
Thnx for the prompt reply.
I called mysql_data_seek() once and I called it before mysql_fetch_row().
With this, mysql_fetch_row() returns NULL row.
Then I decided to check if the connection (and query) is valid by commented
out mysql_data_seek(). I called only mysql_fetch_row() and it returns
non-NULL row. From the result, I know that the connection and the query
are valid.
The next thing I check is the number of rows in the MResult. I have 3 rows
altogether. Hence, it should return me something if I set the cursor (using
mysql_seek_data() ) to the 2nd row and then get the row with
mysql_fetch_row(). However, this does not work.
I've checked my concept on mysql_data_seek() against the description you
have provided in the first reply, and I do not detect any different. Hence I
presume the mistake was made due to some special considerations which I do
not know. Please advice.
Once again, thnx for replying.
Regards,
wv
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: 10 July 2002 09:38
To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED]
Subject: Re: C API: mysql_data_seek
Hi,
If i understand well you use twice mysql_data_seek.If you use
mysql_data_seek() after mysql_fetch_row() the effect is NULL.
Because mysql_data_seek() (in fact) set the cursor (if we can said like
this...) in the MResult (MYSQL_RES) and not in the row (MYSQL_ROW).
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 10:13 AM
Subject: RE: C API: mysql_data_seek
Hi,
Thanks for ur reply.
When i commented out the mysql_data_seek() function,
mysql_fetch_row()
returns me a non-NULL value (this should be the first row from the
MResult).
This results show that I've a valid connection and/or query. And when I
call mysql_fetch_row() again (retrieving the 2nd row from the MResult,
which is the desired row), it returns me a non-NULL value too. From this
result, I know that I've not seek past the result set. However, with the
addition of the mysql_data_seek(MResult, 1) function, a NULL value is
returned. And that's where I don't know how the mistake was made.
Please advice and thanks.
wv
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2002 23:03
To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED]
Subject: Re: C API: mysql_data_seek
Hi,
It's ok but you must retrieve data from row.
int sql_result;x,i;
MYSQL_RES *MResult;
MYSQL_ROW *row;
MYSQL *MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);//mysql_store_result return
in
MResult not in MQuery (here was :...mysql_store_result(MQuery))
mysql_data_seek(MResult, 1); //it's ok here...i suppose you whish to
retrieve data from 2-nd row
row = mysql_fetch_row( MResult) ;// if you have a valid connection(or
query) mysql_fetch_row should return non NULL value.
i = mysql_num_fields(MResult) ;
for ( x = 0 ; x i ; x++ )
{
printf(Data from MYSQL_ROW : %s \n,row[x]);
}
mysql_free_result( res ) ;
I hope it's help.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 9:29 PM
Subject: C API: mysql_data_seek
Hi,
I'm using the MySQL built-in C function, mysql_data_seek, for accessing
a
particular row from the Result (MYSQL_RES) returned by
mysql_store_result.
int sql_result;
MYSQL_RES *MResult;
MYSQL_ROW row;
MYSQL MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);
mysql_data_seek(MResult, 1);
row = mysql_fetch_row(MResult);
However, row returns NULL. I wonder if I've made any mistake in the
process. Can someone please help to check? In addition, is there any
special considerations when using this function?
Thanks in advance.
wv
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C API: mysql_data_seek
Hi,
If i understand well, mysql_fetch_row() work fine but if you add
mysql_data_seek() the row is NULL.
...you use pointers when declare variables ?In my pre-previuos e-mail i fill
what (i considered) it's not was OK.
MYSQL_RES *MResult;
MYSQL_ROW *row;
MYSQL *MQuery;
instead...
MYSQL_RES *MResult;
MYSQL_ROW row;
MYSQL MQuery;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 11:42 AM
Subject: RE: C API: mysql_data_seek
Hi Gelu,
Thnx for the prompt reply.
I called mysql_data_seek() once and I called it before mysql_fetch_row().
With this, mysql_fetch_row() returns NULL row.
Then I decided to check if the connection (and query) is valid by
commented
out mysql_data_seek(). I called only mysql_fetch_row() and it returns
non-NULL row. From the result, I know that the connection and the query
are valid.
The next thing I check is the number of rows in the MResult. I have 3
rows
altogether. Hence, it should return me something if I set the cursor
(using
mysql_seek_data() ) to the 2nd row and then get the row with
mysql_fetch_row(). However, this does not work.
I've checked my concept on mysql_data_seek() against the description you
have provided in the first reply, and I do not detect any different. Hence
I
presume the mistake was made due to some special considerations which I do
not know. Please advice.
Once again, thnx for replying.
Regards,
wv
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: 10 July 2002 09:38
To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED]
Subject: Re: C API: mysql_data_seek
Hi,
If i understand well you use twice mysql_data_seek.If you use
mysql_data_seek() after mysql_fetch_row() the effect is NULL.
Because mysql_data_seek() (in fact) set the cursor (if we can said like
this...) in the MResult (MYSQL_RES) and not in the row (MYSQL_ROW).
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 10:13 AM
Subject: RE: C API: mysql_data_seek
Hi,
Thanks for ur reply.
When i commented out the mysql_data_seek() function,
mysql_fetch_row()
returns me a non-NULL value (this should be the first row from the
MResult).
This results show that I've a valid connection and/or query. And when I
call mysql_fetch_row() again (retrieving the 2nd row from the MResult,
which is the desired row), it returns me a non-NULL value too. From
this
result, I know that I've not seek past the result set. However, with
the
addition of the mysql_data_seek(MResult, 1) function, a NULL value is
returned. And that's where I don't know how the mistake was made.
Please advice and thanks.
wv
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2002 23:03
To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED]
Subject: Re: C API: mysql_data_seek
Hi,
It's ok but you must retrieve data from row.
int sql_result;x,i;
MYSQL_RES *MResult;
MYSQL_ROW *row;
MYSQL *MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);//mysql_store_result return
in
MResult not in MQuery (here was :...mysql_store_result(MQuery))
mysql_data_seek(MResult, 1); //it's ok here...i suppose you whish to
retrieve data from 2-nd row
row = mysql_fetch_row( MResult) ;// if you have a valid
connection(or
query) mysql_fetch_row should return non NULL value.
i = mysql_num_fields(MResult) ;
for ( x = 0 ; x i ; x++ )
{
printf(Data from MYSQL_ROW : %s \n,row[x]);
}
mysql_free_result( res ) ;
I hope it's help.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 9:29 PM
Subject: C API: mysql_data_seek
Hi,
I'm using the MySQL built-in C function, mysql_data_seek, for
accessing
a
particular row from the Result (MYSQL_RES) returned by
mysql_store_result.
int sql_result;
MYSQL_RES *MResult;
MYSQL_ROW row
RE: C API: mysql_data_seek
Hi Gelu,
Yes, you are right in getting my problem.
I tried using pointers when declaring the variables
MYSQL_ROW *row;
MYSQL *MQuery;
However, I do not get the desired result too.
Besides pointer, do you know any other possible mistakes?
Really appreciate your response.
wv
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: 10 July 2002 11:02
To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED]
Subject: Re: C API: mysql_data_seek
Hi,
If i understand well, mysql_fetch_row() work fine but if you add
mysql_data_seek() the row is NULL.
...you use pointers when declare variables ?In my pre-previuos e-mail i fill
what (i considered) it's not was OK.
MYSQL_RES *MResult;
MYSQL_ROW *row;
MYSQL *MQuery;
instead...
MYSQL_RES *MResult;
MYSQL_ROW row;
MYSQL MQuery;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 11:42 AM
Subject: RE: C API: mysql_data_seek
Hi Gelu,
Thnx for the prompt reply.
I called mysql_data_seek() once and I called it before mysql_fetch_row().
With this, mysql_fetch_row() returns NULL row.
Then I decided to check if the connection (and query) is valid by
commented
out mysql_data_seek(). I called only mysql_fetch_row() and it returns
non-NULL row. From the result, I know that the connection and the query
are valid.
The next thing I check is the number of rows in the MResult. I have 3
rows
altogether. Hence, it should return me something if I set the cursor
(using
mysql_seek_data() ) to the 2nd row and then get the row with
mysql_fetch_row(). However, this does not work.
I've checked my concept on mysql_data_seek() against the description you
have provided in the first reply, and I do not detect any different. Hence
I
presume the mistake was made due to some special considerations which I do
not know. Please advice.
Once again, thnx for replying.
Regards,
wv
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: 10 July 2002 09:38
To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED]
Subject: Re: C API: mysql_data_seek
Hi,
If i understand well you use twice mysql_data_seek.If you use
mysql_data_seek() after mysql_fetch_row() the effect is NULL.
Because mysql_data_seek() (in fact) set the cursor (if we can said like
this...) in the MResult (MYSQL_RES) and not in the row (MYSQL_ROW).
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: 'Gelu Gogancea' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 10:13 AM
Subject: RE: C API: mysql_data_seek
Hi,
Thanks for ur reply.
When i commented out the mysql_data_seek() function,
mysql_fetch_row()
returns me a non-NULL value (this should be the first row from the
MResult).
This results show that I've a valid connection and/or query. And when I
call mysql_fetch_row() again (retrieving the 2nd row from the MResult,
which is the desired row), it returns me a non-NULL value too. From
this
result, I know that I've not seek past the result set. However, with
the
addition of the mysql_data_seek(MResult, 1) function, a NULL value is
returned. And that's where I don't know how the mistake was made.
Please advice and thanks.
wv
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2002 23:03
To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED]
Subject: Re: C API: mysql_data_seek
Hi,
It's ok but you must retrieve data from row.
int sql_result;x,i;
MYSQL_RES *MResult;
MYSQL_ROW *row;
MYSQL *MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);//mysql_store_result return
in
MResult not in MQuery (here was :...mysql_store_result(MQuery))
mysql_data_seek(MResult, 1); //it's ok here...i suppose you whish to
retrieve data from 2-nd row
row = mysql_fetch_row( MResult) ;// if you have a valid
connection(or
query) mysql_fetch_row should return non NULL value.
i = mysql_num_fields(MResult) ;
for ( x = 0 ; x i ; x++ )
{
printf(Data from MYSQL_ROW : %s \n,row[x]);
}
mysql_free_result( res ) ;
I hope it's help.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED
Re: C API: mysql_data_seek
Hi, Resume I understand that you use C API functions in the right order: mysql_init() mysql_option() mysql_real_connect() mysql_real_query() mysql_store_result() mysql_data_seek() mysql_fetch_field() mysql_fetch_row() mysql_free_result() mysql_close() Question : What version of libmysql.dll and what compilers you used ? I put this question because i wish to send to you an example with mysql_data_seek(); Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chan WieVia ICM N MC MI E3 Extern [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 3:03 PM Subject: RE: C API: mysql_data_seek Hi Gelu, Yes, you are right in getting my problem. I tried using pointers when declaring the variables MYSQL_ROW *row; MYSQL *MQuery; However, I do not get the desired result too. Besides pointer, do you know any other possible mistakes? Really appreciate your response. wv -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: 10 July 2002 11:02 To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED] Subject: Re: C API: mysql_data_seek Hi, If i understand well, mysql_fetch_row() work fine but if you add mysql_data_seek() the row is NULL. ...you use pointers when declare variables ?In my pre-previuos e-mail i fill what (i considered) it's not was OK. MYSQL_RES *MResult; MYSQL_ROW *row; MYSQL *MQuery; instead... MYSQL_RES *MResult; MYSQL_ROW row; MYSQL MQuery; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chan WieVia ICM N MC MI E3 Extern [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 11:42 AM Subject: RE: C API: mysql_data_seek Hi Gelu, Thnx for the prompt reply. I called mysql_data_seek() once and I called it before mysql_fetch_row(). With this, mysql_fetch_row() returns NULL row. Then I decided to check if the connection (and query) is valid by commented out mysql_data_seek(). I called only mysql_fetch_row() and it returns non-NULL row. From the result, I know that the connection and the query are valid. The next thing I check is the number of rows in the MResult. I have 3 rows altogether. Hence, it should return me something if I set the cursor (using mysql_seek_data() ) to the 2nd row and then get the row with mysql_fetch_row(). However, this does not work. I've checked my concept on mysql_data_seek() against the description you have provided in the first reply, and I do not detect any different. Hence I presume the mistake was made due to some special considerations which I do not know. Please advice. Once again, thnx for replying. Regards, wv -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: 10 July 2002 09:38 To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED] Subject: Re: C API: mysql_data_seek Hi, If i understand well you use twice mysql_data_seek.If you use mysql_data_seek() after mysql_fetch_row() the effect is NULL. Because mysql_data_seek() (in fact) set the cursor (if we can said like this...) in the MResult (MYSQL_RES) and not in the row (MYSQL_ROW). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chan WieVia ICM N MC MI E3 Extern [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 10:13 AM Subject: RE: C API: mysql_data_seek Hi, Thanks for ur reply. When i commented out the mysql_data_seek() function, mysql_fetch_row() returns me a non-NULL value (this should be the first row from the MResult). This results show that I've a valid connection and/or query. And when I call mysql_fetch_row() again (retrieving the 2nd row from the MResult, which is the desired row), it returns me a non-NULL value too. From this result, I know that I've not seek past the result set. However, with the addition of the mysql_data_seek(MResult, 1) function, a NULL value is returned. And that's where I don't know how the mistake was made. Please advice and thanks. wv -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Sent: 09 July 2002 23:03 To: Chan WieVia ICM N MC MI E3 Extern; [EMAIL PROTECTED] Subject: Re: C API: mysql_data_seek Hi, It's ok but you must retrieve
Re: C API: mysql_data_seek
Hi,
It's ok but you must retrieve data from row.
int sql_result;x,i;
MYSQL_RES *MResult;
MYSQL_ROW *row;
MYSQL *MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);//mysql_store_result return in
MResult not in MQuery (here was :...mysql_store_result(MQuery))
mysql_data_seek(MResult, 1); //it's ok here...i suppose you whish to
retrieve data from 2-nd row
row = mysql_fetch_row( MResult) ;// if you have a valid connection(or
query) mysql_fetch_row should return non NULL value.
i = mysql_num_fields(MResult) ;
for ( x = 0 ; x i ; x++ )
{
printf(Data from MYSQL_ROW : %s \n,row[x]);
}
mysql_free_result( res ) ;
I hope it's help.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Chan WieVia ICM N MC MI E3 Extern
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 9:29 PM
Subject: C API: mysql_data_seek
Hi,
I'm using the MySQL built-in C function, mysql_data_seek, for accessing a
particular row from the Result (MYSQL_RES) returned by mysql_store_result.
int sql_result;
MYSQL_RES *MResult;
MYSQL_ROW row;
MYSQL MQuery;
char SQLQuery[];
sprintf( SQLQuery, SELECT * FROM Profile );
sql_result = mysql_query(SQLQuery);
MResult = mysql_store_result(MQuery);
mysql_data_seek(MResult, 1);
row = mysql_fetch_row(MResult);
However, row returns NULL. I wonder if I've made any mistake in the
process. Can someone please help to check? In addition, is there any
special considerations when using this function?
Thanks in advance.
wv
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
