Re: prepared statement problems [SOLVED]

2005-08-22 Thread Darrell Cormier
On Monday 22 August 2005 15:30, Darrell Cormier wrote: > > 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: >

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 > > > Yes, thank you again. I had just upgraded and tested it about the time I got this message. The loggin

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

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, `faci

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

RE: prepared statement problems

2005-08-18 Thread Sujay Koduri
mysql_list Cc: Sujay 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 al

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 email

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

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

RE: prepared statement problems

2005-08-17 Thread Sujay Koduri
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 -Original Message- From: Darrell Cormier [mailto:[EMAIL PROTECTED] Sent: Thurs