Re: prepared statement problems

2005-08-22 Thread Gleb Paharenko
Hello. Use 4.1.13. Logging for prepared statements works as of that version. See: http://bugs.mysql.com/bug.php?id=8367 050822 17:28:13 122 Connect [EMAIL PROTECTED] on test 122 Prepare [1] select product from lth where

Re: prepared statement problems

2005-08-22 Thread Darrell Cormier
On Monday 22 August 2005 09:31, Gleb Paharenko wrote: Hello. Use 4.1.13. Logging for prepared statements works as of that version. See: http://bugs.mysql.com/bug.php?id=8367 SNIP Yes, thank you again. I had just upgraded and tested it about the time I got this message. The loggin is

Re: prepared statement problems [SOLVED]

2005-08-22 Thread Darrell Cormier
On Monday 22 August 2005 15:30, Darrell Cormier wrote: SNIP Yes, thank you again. I had just upgraded and tested it about the time I got this message. The loggin is working fine now. Now I get this for the log output: /usr/sbin/mysqld-max, Version: 5.0.11-beta-Max-log. started with: Tcp

Re: prepared statement problems

2005-08-19 Thread Gleb Paharenko
Hello. I've modified your source code, and it works now. Use diff to see the changes. My test table is: mysql show create table lth\G; *** 1. row *** Table: lth Create Table: CREATE TABLE `lth` ( `product` char(255) default NULL,

Re: prepared statement problems

2005-08-19 Thread Darrell Cormier
On Thursday 18 August 2005 17:52, Gleb Paharenko wrote: Hello. I've modified your source code, and it works now. Use diff to see the changes. snip Thank you, but I made the changes and I still get no returned data. Below is the contents of the logfile when I run my program. It appears

Re: prepared statement problems

2005-08-18 Thread Darrell Cormier
Sujay Koduri said the following on 08/18/2005 12:31 AM: Hi, The problem here is that you have two input bind variables, but you declaring MysQL BIND array as parm_bind[1], which can hold only one input bind variable. Make it parm_bind[2]. That should work. sujay Thank you for your

RE: prepared statement problems

2005-08-18 Thread Sujay Koduri
Send the code if it is still not working. sujay -Original Message- From: Darrell Cormier [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 7:16 PM To: mysql_list Subject: Re: prepared statement problems Sujay Koduri said the following on 08/18/2005 12:31 AM: Hi, The problem

Re: prepared statement problems

2005-08-18 Thread Darrell Cormier
/ Developer: Darrell Cormier Date : 10-Aug-2005 App Name : msql_conn_env Purpose : Test MySQL connection using an environment variable for the connection string.

Re: prepared statement problems

2005-08-18 Thread Darrell Cormier
Sorry, the text of my message did not come through for some reason. I have included it below. DC Sujay Koduri said the following on 08/18/2005 08:48 AM: Send the code if it is still not working. sujay Not sure what you mean by send the code since it is included at the end of this

RE: prepared statement problems

2005-08-18 Thread Sujay Koduri
Koduri Subject: Re: prepared statement problems Sujay Koduri said the following on 08/18/2005 08:48 AM: Send the code if it is still not working. sujay Not sure what you mean by send the code since it is included at the end of this email. However, I have also attached the file

Re: prepared statement problems

2005-08-18 Thread Darrell Cormier
Sujay Koduri said the following on 08/18/2005 09:33 AM: hi, you should use strlen() instead of sizeof() to pass the length of input bind parameter, otherwise it will read past the actual parameter and tries to compare with the whole thing which is not intended. str_length[0]= sizeof(facility);

prepared statement problems

2005-08-17 Thread Darrell Cormier
Greetings, I am trying to figure out prepared statements in the C-API. The problem I am having is passing parameters to a prepared statement. If I hard code everything in my SQL statement, like: static char *sql_stmt = { select product from lth where facility

RE: prepared statement problems

2005-08-17 Thread Sujay Koduri
: Thursday, August 18, 2005 1:23 AM To: mysql_list Subject: prepared statement problems Greetings, I am trying to figure out prepared statements in the C-API. The problem I am having is passing parameters to a prepared statement. If I hard code everything in my SQL statement, like: static char