mysqlcppapi-main

[Mysqlcppapi-main] make examples

[Hyper 4. <hy...@ho...>]

Hey,

after a day hard working, we managed to get mysqlcppapi compiled+installed!

while trying to compile simple1.cc in the examples dir, we encountered the 
following problem though:

/* start code sample */
bash-2.03$ make simple1
/bin/sh ../libtool --mode=link g++  -g -O2  -o simple1  simple1.o  
../mysqlcppapi/libmysqlcppapi.la  -L/usr/local/mysql/lib -lmysqlclient
g++ -g -O2 -o .libs/simple1 simple1.o ../mysqlcppapi/.libs/libmysqlcppapi.so 
-L/usr/local/mysql/lib -lmysqlclient -L/usr/local/mysql/lib -lmysqlclient 
-Wl,--rpath -Wl,/export/home/p01/johan/sql/lib
/usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function `connect2':
libmysql.o(.text+0x1c): undefined reference to `connect'
libmysql.o(.text+0x58): undefined reference to `connect'
libmysql.o(.text+0x160): undefined reference to `getsockopt'
/usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function 
`mysql_once_init':
libmysql.o(.text+0xd44): undefined reference to `getservbyname'
/usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function 
`mysql_real_connect':
libmysql.o(.text+0xf7c): undefined reference to `socket'
libmysql.o(.text+0x1064): undefined reference to `socket'
libmysql.o(.text+0x10cc): undefined reference to `inet_addr'
libmysql.o(.text+0x10e8): undefined reference to `gethostbyname'
/usr/local/mysql/lib/libmysqlclient.a(violite.o): In function 
`vio_fastsend':
violite.o(.text+0x188): undefined reference to `setsockopt'
violite.o(.text+0x1b4): undefined reference to `setsockopt'
/usr/local/mysql/lib/libmysqlclient.a(violite.o): In function 
`vio_keepalive':
violite.o(.text+0x210): undefined reference to `setsockopt'
/usr/local/mysql/lib/libmysqlclient.a(violite.o): In function `vio_close':
violite.o(.text+0x264): undefined reference to `shutdown'
/usr/local/mysql/lib/libmysqlclient.a(violite.o): In function 
`vio_peer_addr':
violite.o(.text+0x31c): undefined reference to `getpeername'
/usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function 
`my_uncompress':
my_compress.o(.text+0x9c): undefined reference to `uncompress'
/usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function 
`my_compress_alloc':
my_compress.o(.text+0x12c): undefined reference to `compress'
/usr/local/mysql/lib/libmysqlclient.a(my_net.o): In function `my_inet_ntoa':
my_net.o(.text+0xc): undefined reference to `inet_ntoa'
collect2: ld returned 1 exit status
*** Error code 1
make: Fatal error: Command failed for target `simple1'
/* end code sample */

Help would be greatly appreciated!

grtz,

Kristof

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx

[Mysqlcppapi-main] Examples compile errors

[Mikael B. <tm...@gr...>]

After compiling and installing the mysqlcppapi with "./configure
--with-mysql=/usr/local" which went just fine i turned to the examples
version 1.7.4 and did the same i.e configured with the same options and
ran make which resulted in the following output:

[root@babylon5 mysqlcppapi_example-1.7.4]# make
make  all-recursive
make[1]: Entering directory `/home/tmb/mysqlcppapi_example-1.7.4'
Making all in src
make[2]: Entering directory `/home/tmb/mysqlcppapi_example-1.7.4/src'
/bin/sh ../libtool --mode=link c++  -g -O2   -o example  simple1.o
-L/usr/local/mysql/lib/mysql -lmysqlclient  -L/usr/local/mysql/lib/mysql
-lmysqlclient
c++ -g -O2 -o example simple1.o -L/usr/local/mysql/lib/mysql
-lmysqlclient -L/usr/local/mysql/lib/mysql -lmysqlclient
simple1.o: In function `__default_alloc_template<true,
0>::_S_chunk_alloc(unsigned int, int &)':
/usr/include/g++-3/stl_alloc.h:466: undefined reference to
`mysqlcppapi::Connection::Connection(void)'
/usr/include/g++-3/stl_alloc.h:467: undefined reference to
`mysqlcppapi::Connection::connect(void)'
/usr/include/g++-3/stl_alloc.h:490: undefined reference to
`mysqlcppapi::Connection::select_database(basic_string<char,
string_char_traits<char>, __default_alloc_template<true, 0> > const &)'
/usr/include/g++-3/stl_alloc.h:518: undefined reference to
`mysqlcppapi::Connection::create_Query(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Query::store(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Query::preview(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Result_Store::size(void) const'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Row virtual table'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Row virtual table'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Row::operator[](basic_string<char,
string_char_traits<char>, __default_alloc_template<true, 0> > const &)
const'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Row::~Row(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Result_Store::~Result_Store(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Query::~Query(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Connection::~Connection(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Row::~Row(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Result_Store::~Result_Store(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Query::~Query(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Connection::~Connection(void)'
/usr/include/g++-3/stl_alloc.h:157: undefined reference to
`mysqlcppapi::ex_BadQuery type_info function'
/usr/include/g++-3/stl_alloc.h:158: undefined reference to
`mysqlcppapi::ex_BadConversion type_info function'
collect2: ld returned 1 exit status
make[2]: *** [example] Error 1
make[2]: Leaving directory `/home/tmb/mysqlcppapi_example-1.7.4/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/tmb/mysqlcppapi_example-1.7.4'
make: *** [all-recursive-am] Error 2

System specs:

Linux Mandrake release 8.0 (Traktopel) for i586
Kernel 2.4.8-34.1mdk on an i686
gcc 2.96
mysql 3.23.45 in /usr/local
mysqlcppapi 1.7.5 with libs in /usr/local/lib

Any help would be appreciated.

Regards Mikael Berglund

[Mysqlcppapi-main] Unable to Make

[kweed <kw...@mi...>]

Hello-

	I am having some trouble getting mysqlcppapi to compile.  The
"configure" script went smoothly without problems, but when I try to "make",
I get the following errors:

admin-srv58[62]/home/kweed/mysqlcppapi-1.7.5 $ make
make   all-recursive
make[1]: Entering directory `/home/kweed/mysqlcppapi-1.7.5'
Making all in mysqlcppapi
make[2]: Entering directory `/home/kweed/mysqlcppapi-1.7.5/mysqlcppapi'
Making all in datetime
make[3]: Entering directory
`/home/kweed/mysqlcppapi-1.7.5/mysqlcppapi/datetime'
'.  Stop.*** No rule to make target `libdatetime.la
make[3]: Leaving directory
`/home/kweed/mysqlcppapi-1.7.5/mysqlcppapi/datetime'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/home/kweed/mysqlcppapi-1.7.5/mysqlcppapi'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/kweed/mysqlcppapi-1.7.5'
make: *** [all-recursive-am] Error 2
admin-srv58[63]/home/kweed/mysqlcppapi-1.7.5 $

	Is anybody familiar with what would be causing this, and perhaps a
possible solution?  I would appreciate any insight.  Thank you.

Kris

[Mysqlcppapi-main] make error

[kweed <kw...@mi...>]

Hello-

	I am unable to make the mysqlcppapi on solaris.  The "configure"
went flawlessly, but when I type "make" I get the following error:

admin-srv58[26]/home/kweed/mysqlcppapi-1.7.5 $ make
make   all-recursive
make[1]: Entering directory `/home/kweed/mysqlcppapi-1.7.5'
Making all in mysqlcppapi
make[2]: Entering directory `/home/kweed/mysqlcppapi-1.7.5/mysqlcppapi'
Making all in datetime
make[3]: Entering directory
`/home/kweed/mysqlcppapi-1.7.5/mysqlcppapi/datetime'
'.  Stop.*** No rule to make target `libdatetime.la
make[3]: Leaving directory
`/home/kweed/mysqlcppapi-1.7.5/mysqlcppapi/datetime'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/home/kweed/mysqlcppapi-1.7.5/mysqlcppapi'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/kweed/mysqlcppapi-1.7.5'
make: *** [all-recursive-am] Error 2
admin-srv58[27]/home/kweed/mysqlcppapi-1.7.5 

	Can anybody help explain what a solution to this problem might be?
Thank you.

Kris

[Mysqlcppapi-main] Making the cppapi example work - need some help here

[Cipher9 <ci...@su...>]

Hi, 
 
I downloaden the mysqlcppapi, and installed it. That went all jst fine.
Now I'm trying to make the example, but I'm getting the following
errors.
 
make  all-recursive
make[1]: Entering directory
`/home/schepkew/Tools/mysqlcppapi_example-1.7.4'
Making all in src
make[2]: Entering directory
`/home/schepkew/Tools/mysqlcppapi_example-1.7.4/src'
/bin/sh ../libtool --mode=link c++  -g -O2   -o example  simple1.o
-L/usr/include/mysql -lmysqlclient  -L/usr/include/mysql -lmysqlclient
c++ -g -O2 -o example simple1.o -L/usr/include/mysql -lmysqlclient
-L/usr/include/mysql -lmysqlclient
simple1.o: In function `__default_alloc_template<true,
0>::_S_chunk_alloc(unsigned int, int &)':
/usr/include/g++-3/stl_alloc.h:466: undefined reference to
`mysqlcppapi::Connection::Connection(void)'
/usr/include/g++-3/stl_alloc.h:467: undefined reference to
`mysqlcppapi::Connection::connect(void)'
/usr/include/g++-3/stl_alloc.h:490: undefined reference to
`mysqlcppapi::Connection::select_database(basic_string<char,
string_char_traits<char>, __default_alloc_template<true, 0> > const &)'
/usr/include/g++-3/stl_alloc.h:518: undefined reference to
`mysqlcppapi::Connection::create_Query(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Query::store(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Query::preview(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Result_Store::size(void) const'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Row virtual table'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Row virtual table'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Row::operator[](basic_string<char,
string_char_traits<char>, __default_alloc_template<true, 0> > const &)
const'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Row::~Row(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Result_Store::~Result_Store(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Query::~Query(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Connection::~Connection(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Row::~Row(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Result_Store::~Result_Store(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Query::~Query(void)'
/usr/include/g++-3/stl_alloc.h:505: undefined reference to
`mysqlcppapi::Connection::~Connection(void)'
/usr/include/g++-3/stl_alloc.h:157: undefined reference to
`mysqlcppapi::ex_BadQuery type_info function'
/usr/include/g++-3/stl_alloc.h:158: undefined reference to
`mysqlcppapi::ex_BadConversion type_info function'
collect2: ld returned 1 exit status
make[2]: *** [example] Error 1
make[2]: Leaving directory
`/home/schepkew/Tools/mysqlcppapi_example-1.7.4/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory
`/home/schepkew/Tools/mysqlcppapi_example-1.7.4'
make: *** [all-recursive-am] Error 2
 
I followed the installation instructions in the README and INSTALL
files, but I can't seem
To find the prob.
 
Got any suggestions?
 
Thanx a lot
Wim
 

[Mysqlcppapi-main] SSQLS

[Heather A. <hea...@pa...>]

Hi
 
I'm trying to use the SSQLS part of the C++ API for MySQL and I am getting
the following errors while compiling the sample code:  custom1.cc.  (See
Ch4.5 of the manual)

pasting "," and "stock" does not give a valid preprocessor token.
pasting "," and "stock" does not give a valid preprocessor token.
pasting "," and "stock" does not give a valid preprocessor token.
pasting "," and "stock" does not give a valid preprocessor token.
pasting "," and "stock" does not give a valid preprocessor token.
pasting "," and "stock" does not give a valid preprocessor token.
pasting "," and "stock" does not give a valid preprocessor token.
pasting "(" and "stock" does not give a valid preprocessor token.
pasting "~" and "stock" does not give a valid preprocessor token.

and other similar messages.

We do not allow warnings in our build system.  Is there a way to fix the
macros/code so that no warnings are generated?  Otherwise we will not be
able to use this part of the C++ API. 

How do I get around this?

Thanks,
Heather Armitage

[Mysqlcppapi-main] Documentation for mysqlcppapi?

[Dyer L. <dy...@lp...>]

Hi,

I have the mysqlcppapi working on my linux box.
The distribution I have doesn't seem to have any
documentation except the examples.  Is there 
a user manual on the web somewhere?

Thanks,

 -Dyer

[Mysqlcppapi-main] C++ API Library for Windows AND Linux

[David A. <me...@ay...>]

Is their a C++ API library which is able to work on BOTH Windows (2K)
and Linux.
I need the SAME library to work on both platforms. I take it neither of
the top two will work (list below): Borland or MS libraries.  What are
the other two.  

I need to write a program which is portable to both windows and Linux.
C++ is preferred.  Any other advice is appreciated.


<-- from site -->

MySQL++ 1.7.1 for Borland C++ 5.* for Windows (contributed by Arturs
Aboltins <aab...@ex...>) 
MySQL++ 1.7.1 for Microsoft Visual C++ 6.0 (contributed by LazyFox
<la...@fo...>) 

A Patch for MySQL++ for use with the STLport-4.0 library (contributed by
Bert Hubert <ah...@ds...>) 
MySQL++ 1.7.6a Source tarball for Tru64 Compiler (version 6.*)
(contributed by Steffen Neumann <sne...@te...>) 

<-- end from site -->


Sorry for two posts in one day!!

Thanks lots
David Ayliffe (ma...@ay...)

[Mysqlcppapi-main] What's the easiest way to export MySQL table structure and data AUTOMATICALLY using MySQL++?

[David A. <me...@ay...>]

As subject; I'm using the MySQL C++ API's and compiling under MS VC++ 6?

I want to accept a table name at runtime, and then export both the data
and data structure to a file which is compatible with MS Access; which
the table will eventually be imported into.

Are their any API's to do this?

Any ideas


Thanks lots
David Ayliffe (ma...@ay...)

[Mysqlcppapi-main] MYSQL++: List of databases, then tables in each database

[David A. <me...@ay...>]

Using the MySQL++ library is their any call to
1) Get a list of the databases on the Server
2) List tables in a database given a database name.

The best I could find was

show databases 
show tables;
or
show tables from <database name>;

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!! Does anyone have any examples of how to implement these calls in
Visual C++ using the MySQL++ API's !!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


ANY INPUT APPRECIATED

I am using the Visual C++ library for development under MS VC++ 6 on
Windows 2000 Advanced Server.


***********
Just another quick question; I have a line of code (below) but it does
not output the query to the screen.  In this case the query is "Select *
from Employees limit 20" but (below) causes just "Query: " to be
displayed.

Query query = con.query();
query << "select * from Employees limit 20";
cout << "Query: " << query.preview() << endl;


Sorry if you get this for a second time - I didn't get much of a
response from the plusplus mailing list.  I assure you I have checked
the web site and manual

Thanks lots
David Ayliffe (mailto:ma...@ay...)

[Mysqlcppapi-main] Error: mysql_real_connect() failed

[Le R. B. <le...@en...>]

Hi. I have a problem running the examples that came with mysqlcppapi.
 
I have Red Hat 7.0. I removed the MySQL rpm packages I installed earlier. I
now have MySQL 3.23.29a installed from source. I compiled mysqlcppapi
version 1.7.2a like this:
 
./configure --with-mysql=/usr/local       (this is the default directory
where MySQL is installed when you compile it from source code - I think)
make
make install
 
I then changed to the examples directory and typed ./simple1
I got this error message:
 
Error: mysql_real_connect() failed
 
What could be the problem?
 
Le Roux Bodenstein
 

[Mysqlcppapi-main] Errors when compiling and running MySQL examples

[Le R. B. <le...@en...>]

Hi
 
I compiled MySQLcppapi and when it reached the examples, I got these errors:
 
/usr/local/lib/libmysqlcppapi.so: undefined reference to 'uncompress'
/usr/local/lib/libmysqlcppapi.so: undefined reference to 'compress'
 
Someone suggested that I link with libz. I manually added that to the
Makefile found in the examples directory and ran make again. This time
everything compiled, but I get the following error when I try and to run the
examples:
 
Error: mysql_real_connect() failed
 
I also compiled the example found in the second archive. When I run it, it
complains that it cannot find libmysqlcppapi-1.7.so.2. Trust me - this file
exists. I have checked. It is in /usr/local/lib
 
 
Any help will be appreciated.
 
Thanx 
Le Roux Bodenstein

[Mysqlcppapi-main] RedHat 7.0 (gcc 2.96)

[Eugene! S. <eu...@en...>]

Hi there!

I got  troubles with Query objects I posted before.
Now I think I found the solution that fixes problem and allowed single 
Query object processes more than one query (with clearing stream buffer 
after each):

file sql_query.h:

typedef enum {
   DONT_RESET = 0,
   RESET_QUERY
   } query_reset;

class SQLQuery
{
...
protected:
   void reset();
   string str(query_reset r=DONT_RESET);
...
}

file sql_query.cc:

void SQLQuery::reset()
{
seekg(0L, ios::beg);
seekp(0L, ios::beg);
clear();
}

string SQLQuery::str(query_reset r)
{
  SQLQuery *ptr = const_cast<SQLQuery *>(this);
  *ptr << std::ends;
  string str;
  switch(r)
  {
   case RESET_QUERY : {
     uint length = (ptr->rdbuf())->pcount() + 1;
     char *s = new char[length];
     get(s, length, '\0');
     str = s;
     delete s;
     reset();
     }
   default:
     str = ptr->rdbuf()->str();
  }
  return str;
}

file Query.cc:

Result_NoData Query::execute()
{
  query_reset r = RESET_QUERY;
  return m_pConnection->execute(str(r));
}

inline Result_Use Query::use()
{
  query_reset r = RESET_QUERY;
  return m_pConnection->use(str(r));
}

Result_Store Query::store()
{
  query_reset r = RESET_QUERY;
  return m_pConnection->store(str(r));
}

[Mysqlcppapi-main] what's with Query?

[Eugene! S. <eu...@en...>]

Hi there!

Why can't I use Query object twice?
(I mean something like this:
   Query query = con.create_Query();
   query << " SOME BIG QUERY ";
   Result_Store = query.store();
   ...
   query << "insert into stat(name) valuse('" << new_name << "') where 
id=" << ID << std::ends;
// makes exception 'couse query.preview() shows "NEW QUERY+LAST OF SOME 
BIG QUERY"

!!!   I want Query object to clear after making query to mySQL  !!!

[Mysqlcppapi-main] problems with mysqlcppapi running queries

[Lance W. <la...@se...>]

Is anyone out there?  I'm hoping mysqlcppapi is an ongoing an used project!

I'm still having problems - even the example programs don't run correctly.
The first query runs well upon invocation of the store method, but subsequent
queries are still prefixed by the previous query and suffixed by garbage text.

For instance, in simple1.cc (modified only for my database, tables, and fields):

                ...
                con.select_database("tmp");
                mysqlcppapi::Query query = con.create_Query();
                ...
                query << "select * from info ";
                cout << "Query: " << query.preview() << endl;
                mysqlcppapi::Result_Store res = query.store();
                ...
                query << "select * from media " ;
                cout << "Query: " << query.preview() << endl;
                mysqlcppapi::Result_Store res = query.store();
                ...

correctly displays the first preview and query, but then gives the following output:

Query: select * from info select * from media ^H^H| ß^H^H°ß^H^HÀ
Error: You have an error in your SQL syntax near ' select * from media^H^H| ß^H^

Should there be a semicolon ':', use of newline endl or flush?  Help!

Thanks,  -Lance.

-=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=-
Lance Welsh              la...@se...
Seascape Communications  (650) 327-6890
-=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=-

[Mysqlcppapi-main] example programs in mysqlcppapi-1.7.2a

[Lance W. <la...@se...>]

I have a problem getting the example programs to run correctly.  In particular,

      ---
      [lance@ll examples]$ ./sinisa_ex
      3.23.24-beta
      Error: You have an error in your SQL syntax near ';/charsets/Index' at line 1 1064
      ---

It correctly shows the output of con.get_client_info(), but then the
query << "show databases" fails.  Does it need a terminating semicolon
or a newline or a flush?

Also, simple1.cc runs fine (after the simple modification of changing
the select_database call to my database and the query to my table):

      ---
      ...
                      con.select_database("mysql_cpp_data");
                      mysqlcppapi::Query query = con.create_Query();
                      query << "select * from stock";
      ...
      [lance@ll examples]$ ./simple2
      Query: select * from media
      Records Found: 767
      ...
      ---

but when the query object is loaded again:

      ---
       ...
                      con.select_database("mysql_cpp_data");
                      mysqlcppapi::Query query = con.create_Query();
                      query << "select * from stock";
      ...    for loop, cout ...
      #ifdef REPEAT_QUERY
                      // n simple1.cc after the first query, for loop, and cout
                      // putting the same string to the same query causes failure
                      query << "select * from stock";
                      /*mysqlcppapi::Result_Store*/ res = query.store();
                      cout << "Query: " << query.preview() << endl;
                      cout << "Records Found: " << res.size() << endl << endl;
      #endif
      ...
      [lance@ll examples]$ ./simple2
      Query: select * from media
      Records Found: 767
      ...
      Error: You have an error in your SQL syntax near '* from medi
      ---

Again I wonder if the query needs semicolon termination, a newline,
or a flush.  If a new query object is created instead of reusing the
query object used previously, the store succeeds.

I'm using Caldera 2.3 and have the following mysql rpms isntalled:

      MySQL-3.22.32-1
      MySQL-client-3.22.32-1
      MySQL-devel-3.22.32-1
      xmysql-1.10-1

And have built, installed, and attempting to run mysqlcppapi-1.7.2a.tar.gz

Help appreciated.  Thanks,  -Lance.


--
-=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=-
Lance Welsh              la...@se...
Seascape Communications  (650) 327-6890
-=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=--=+=-

[Mysqlcppapi-main] ANNOUNCE: MySQL C++ API (mysqlcppapi) branch 1.7.1 released

[Murray C. <mu...@us...>]

MySQL C++ API (mysqlcppapi):

The first version of the 'MySQL C++ API' branch of the MySql++ project has
been released. You can download it from mysqlcppapi.sourceforge.net. This
branch was created in order to continue development of the library.

Changes:
So far the only changes are a major overhaul of the project files, including a
fix of an installation bug. Code improvements should follow. I have a version
in CVS which puts everything in a namespace but that can wait until the next
version.

* Changes at start of branch from MySql++ 1.7
  - Changed name to 'MySQL C++ API' (mysqlcppapi)
  - Changed to v1.7.1
  - Changed sqlplus directory to mysqlcppapi
  - Change sqlplus.hh to mysqlcppapi.hh
  - Made --with-mysql configure argument mandatory and
    improved explanatory text.
  - Removed "mysql++" header
  - All headers are now in mysqlcppapi directory.
    e.g. #include "mysqlcppapi/mysqlcppapi.hh".
  - Moved doc generation scripts from sqlplus directory
    to docgen directory - How do these work
  - Added mysqlcppapi-config script and AM_PATH_MYSQLCPPAPI macro
  - Added bad_query.hh to list of headers so that it installs.
  - Examples now need to be built by cd to examples and
    typing make. This allows for simpler project files.
  - Used GENERIC_* variables in configure.in instead of .version
    file. Now has release version indicating level of changes
    in interface.
  - Added explanatory comments to project files.
  - Changed licence to definitely be LGPL instead of grudgingly
    LGPL.
  - Removed some files from sqlplus directory, because they do not
    seem to be used: down.gif icon1.gif, icon2.gif, logo.gif
  - Moved some other files from sqlplus directory to a docgen
    directory in docs directory, because they look like they might
    be something to do with documentation, but I don't know.
    Hopefully somebody knows how the document generation works.
  - Added Makefile.am files to all folders to make sure that
    'make dist' works and includes everything.
  - Removed config.cygwin and makefile.win because they are
    obviously incorrect now. If anybody needs them then they
    can tell us what they are for and how to re-generate them.

Murray Cumming
mu...@us...
www.murrayc.com
+44 7971 226563

____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1