Compile Problem

Hi, I am getting the following errore when trying to link the MySQL client library with a C++ program I have written. /usr/local/mysql/lib/libmysqlclient.a(my_open.o): In function `my_open': my_open.o(.text+0x14): undefined reference to `open64' /usr/local/mysql/lib/libmysqlclient.a(mf_format.o

Web Host

Hi, Could someone please recommend a web host that has support for at the very least MySQL, C++ compiler (gcc), and an updated copy of glibc so I can properly compile and link programs written using the MySQL C API. I have been searching for a proper host.. for a very long time. Is there anyon

More Link Probs

Hi, My problems with open64 and fopen64 have been solved by using a newer version of glibc, however now I get the following errors when trying to link the MySQL C Client API library with my program. /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.tex

Limiting to specific field value of type float

price=500 returns the proper results. price is a column of type float. TIA. Alec Solway - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Licensing Question

eed a license? This may seem obvious to some, but I would like to be absolute sure. TIA Alec Solway - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

char -> varchar ?

Hi, In various create table statements char columns are converted to varchar.. I was wondering why this was happening. Here's an example: CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not null, city VARCHAR(255) not null, state CHAR(2) not null, country CHAR(2) not nu

Re: My SQL C_API(urgent)

Try mysql_real_query(). This function takes three parameters, the first two are the same as mysql_query(). The third is the length of the query string. Regards. Alec At 06:51 PM 5/7/01, VVM Ravikumar Sarma Chengalvala wrote: >Hi, >I am having a peculiar problem with C_API.How to >execute a quer

Re: Select query

Switch the column type to double. From the manual: If you are comparing FLOAT or DOUBLE columns with numbers that have decimals, you can't use =! This problem is common in most computer languages because floating-point values are not exact values: mysql> SELECT * FROM table_name WHERE float_co