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:
>
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
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
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
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
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);
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
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
/
Developer: Darrell Cormier
Date : 10-Aug-2005
App Name : msql_conn_env
Purpose : Test MySQL connection using an environment
variable for the connection string.
*
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,
>
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.
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
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
>
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
*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
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
>
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
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
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
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
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
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
22 matches
Mail list logo