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

RE: Prepared statement for MySQL 4.1

2004-11-11 Thread Kevin Cowley
9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > -Original Message- > From: Fagyal Csongor [mailto:[EMAIL PROTECTED] > Sent: 11 November 2004 18:10 > To: 'Mysql ' (E-mail) > Subject: Re: Prepared statement for MySQL 4.1 >

Re: Prepared statement for MySQL 4.1

2004-11-11 Thread Fagyal Csongor
Scott, I've read the article about 'prepared statement' found in MySQL 4.1, and am not sure if I understood what 'prepared statement' does and how can it benefit us. Can anyone elaborate on what 'prepared statement' could do with examples where possible? In the simplest case, consider this: You

RE: Prepared statement for MySQL 4.1

2004-11-11 Thread Scott Hamm
*THAT* one was what I already ready and could not understand it since English isn't my first language. -Original Message- From: Mark Maunder [mailto:[EMAIL PROTECTED] Sent: Thursday, November 11, 2004 12:45 PM To: Scott Hamm Cc: 'Mysql ' (E-mail) Subject: Re: Prepared stat

Re: Prepared statement for MySQL 4.1

2004-11-11 Thread Mark Maunder
Scott, http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html regards, Mark. On Thu, 2004-11-11 at 15:38, Scott Hamm wrote: > I've read the article about 'prepared statement' found in MySQL 4.1, and am > not sure if I understood what 'prepared statement' does and how can it >

Re: Prepared statement for MySQL 4.1

2004-11-11 Thread Gleb Paharenko
Hello. As said at documentation: "Prepared execution is an efficient way to execute a statement more than once." Good examples you can find in documentation to MySQL, and in tests/client_test.c. Scott Hamm <[EMAIL PROTECTED]> wrote: > I've read the article about 'prepared statement' foun

Re: Prepared Statement questions/issues

2004-08-25 Thread Leonardus Setiabudi
Hi Ken.. this might not solve your problem.. but, did you really have to do this create table raddata ( granIDinteger not null, scanIDtinyint unsigned not null, fpID tinyint not null, c1smallint, c2

Re: Prepared Statement questions/issues

2004-08-25 Thread Daniel Kasak
Ken Gieselman wrote: Hi Folks -- I'm running into some issues with large prepared statements, and would love some feedback about approaches or tweaks that I might have overlooked :) Any suggestions as to how to do this more efficiently/faster? Or how to increase the buffer space for the prepar

Re: prepared statement

2002-11-25 Thread Mark Matthews
Hamid Amjadi wrote: Hi ; I am usein the following prepared statement: insertOne = dbConnection.prepareStatement( "INSERT INTO appointment (apptId,providerId,patientId,serviceLocationId, dateTime, assistant, duration,state,statechange,memo,cancelMemo,dictationMarked, apptSeqId, clinicId, appS

Re: Prepared Statement Problem

2002-10-31 Thread Mark Matthews
Heikki Tuuri wrote: Ryan, - Original Message - From: "rcandersonmn" Newsgroups: mailing.database.mysql Sent: Thursday, October 31, 2002 4:23 PM Subject: Prepared Statement Problem >I'm new to MySQL and am having problems with Prepared Statements in >MySQL. I'm using the latest MySQL b

Re: Prepared Statement Problem

2002-10-31 Thread Heikki Tuuri
Ryan, - Original Message - From: "rcandersonmn" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, October 31, 2002 4:23 PM Subject: Prepared Statement Problem > I'm new to MySQL and am having problems with Prepared Statements in > MySQL. I'm using the latest MySQL be