Re: AMD64
MySQL converts MYSQL_TYPE_LONG to float before storing http://dev.mysql.com/doc/refman/5.1/en/c-api-prepared-statement-datatypes.html ? Where does it say that? All in all, datatypes are datatypes, despite platform. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Newbie --- JOINS
Picture does not seem to have been carried in the message, posts with attachment did not seem to get through either. So hope the link works. Below is the ER diagram in an exercise I am trying to do. http://www.probowluk.co.uk/images/er_ECA_001.jpg It's been going well so far, and several ColdFusion pages written already. Need to do one for a Purchase Order Report for ... - given SupplierCode - given StartDate and EndDate of Orders My problem is in the CFquery - understanding what JOINS to use and in what order to use them. (it is a MyISAM database --- no constraints) -- I am using the free version of SPAMfighter. We are a community of 6 million users fighting spam. SPAMfighter has removed 12908 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message
Re: Problem compiling mysql-5.1.33
most likely a missing include it should have at least: #include sys/time.h #include sys/resource.h Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem schrieb: make all-am Making all in mysql-test Making all in lib/My/SafeProcess g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -MT safe_process.o -MD -MP -MF .deps/safe_process.Tpo -c -o safe_process.o safe_process.cc In file included from safe_process.cc:48: /usr/include/sys/resource.h:63: field `ru_utime' has incomplete type /usr/include/sys/resource.h:64: field `ru_stime' has incomplete type why is this taking place? Compile options ./configure --prefix=/usr/contrib --localstatedir=/usr/contrib/mysqld --without-innodb --disable-debug --with-ssl=/usr/contrib --enable-thread-safe-client -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
success return from mysql_query() when error return was expected
Hi everyone -- I'm a MySQL noob. I have MySQL queries in my C code and I was surprised to find I'm getting a success return from: mysql_query(pmysql, select * from usrs where(usr=\illegal name\); In this table called usrs, usr is the primary key and the engine is myisam. I expected an error return from this query on illegal name, which is not in the table. An error is not returned until I call: prow = mysql_fetch_row(pmysqlres)); which returns NULL, which is great. If I run that same select from the command line, I see: mysql select * from usrs where (usr=illegal name); Empty set (0.00 sec) My question, finally: Is this response to my program call expected and normal for MySQL? I suppose it is, but I just want to make sure that the behavior is OK, that indeed the program call to mysql_query(select ...) must always in these circumstances return success. Thanks! -- Pete Wilson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org