prepared statement problems

istake that would prevent this from working properly. Sorry for the length. I will greatly appreciate any assistance I can get. Regards, Darrell -- Darrell Cormier <[EMAIL PROTECTED]> Registered Linux user #370711 http://counter.li.org // The following is my code// /

Re: prepared statement problems

Does anyone see where I have made a mistake that would prevent this from working properly. Sorry for the length. I will greatly appreciate any assistance I can get. Regards, Darrell -- Darrell Cormier <[EMAIL PROTECTED]> Registered Linux user #370711 http://counter.li.org // The follo

Re: prepared statement problems

/ 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

email. However, I have also attached the file. Since I am not sure if the list will accept files, I have also copied you on this message. Please forgive me if this is not what you intended. Kindest regards, Darrell Cormier -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: prepared statement problems

I still get no rows returned. Thank you for your help. I will keep searching. Regards, DC -- Darrell Cormier <[EMAIL PROTECTED]> Registered Linux user #370711 http://counter.li.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SQL statement generated from prepared statement

Is there a way to get MySQL to report the SQL statement it receives from a prepared statement execution (from a program using the C-API )? I am wondering what the SQL statement looks like that is being generated from my program to help debug it. Thanks, DC -- Darrell Cormier <[EM

Re: SQL statement generated from prepared statement

On Thursday 18 August 2005 16:37, Gleb Paharenko wrote: > Hello. > > These links might be helpful: > http://dev.mysql.com/doc/mysql/en/query-log.html > http://dev.mysql.com/doc/mysql/en/debugging-client.html > http://dev.mysql.com/doc/mysql/en/debugging-server.html > > Use a fresh ver

Re: prepared statement problems

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

) So now I just have to figure out what is wrong with my code that is causing it to cut off the "TEX6" from the facility and getting extra characters on lot. Thanks again for your help, Darrell Cormier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: prepared statement problems [SOLVED]

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-

Connection Failure

ES; in mysql as root and it did not change anything. I have also verified that the mysql.db table shows the users with the proper db and privileges. Has anyone experienced this? Any ideas? Thanks, Darrell Cormier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Connection Failure

and perl-DBI are old. I will just use the OLD_PASSWORD() function for now until I have more time to address the old DBI/DBD. Thanks, Darrell Cormier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Newbie problem

x27;15001-02',NULL,'9269 ',-32000,0,0,0,0,0,0,'S',0,' ',1,95,'PT',2,0) Could not execute query! ERROR: 1064(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'l

Re: Newbie problem

for you. > > If sprintf() fix/check does not help, get valgrind from > http://valgrind.kde.org/ ( or use your favorite memory error detection > tool), and see what it says. Thanks, that truly was the problem. I found that another sprintf() statement was overwriting the first. I will t