hi guys..
i am new to this mailing list...i am sujay from andale...
I have a problem in getting multiple records from my store procedure when I
tried calling it using C API...
I included the flag CLIENT_MULTI_STATEMENTS..but it is still giving the same
error..
1296 :SELECT in a stored procedure must have INTO..
i am also including my code here..
1 #include <stdio.h>
2 #include "/usr/include/mysql/mysql.h"
3
4 int main(int argc,char *argv[])
5 {
6 MYSQL mysql;
7 MYSQL_RES *result;
8 MYSQL_ROW row;
9
10 long int i;
11 if(!mysql_init(&mysql))
12 {
13 fprintf(stderr,"Initialization failed");
14 exit(1);
15 }
16
17
if(!mysql_real_connect(&mysql,"localhost","root","","test",0,NULL,CLIENT_MUL
TI_RESULTS))
18 {
19 fprintf(stderr,"%d
:%s\n",mysql_errno(&mysql),mysql_error(&mysql));
20 exit(2);
21 }
22
23 if(mysql_query(&mysql,"call sujay1()")!=0)
24 {
25 fprintf(stderr,"%d :%s\n",mysql_errno(&mysql),mysql_error(&mysql));
26 }
27
28 else
29 {
30 result = mysql_store_result(&mysql);
31 i = mysql_num_rows(result);
32 printf("No of rows are %d\n",i);
33 //row = mysql_fetch_row(result);
34 while(row = mysql_fetch_row(result))
35 {
36 printf("%s %s\n",row[0],row[1]);
37 }
38 mysql_free_result(result);
39 }
40
41 mysql_close(&mysql);
42 return 0;
43 }//end of main
The procedure sujay1() which i am using in my program is
create procedure sujay1()
begin
select name,species from pet;
end
Thanx
sujay koduri
(plez sent back the corrected one)
I am using..
Red hat-9.0
MySQL - 5.0
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
