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 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
