List:General Discussion« Previous MessageNext Message »
From:David Ayliffe Date:June 4 2001 11:27am
Subject:MySQL++ API Help
View as plain text  
Does anyone have any SIMPLE proggies written in C++ using the MYSQL++
API library? Preferably MS Visual Studio 6 format.  If so can you please
provide me a link for them or contact me over email directly.

I'm having problems compiling a project that just connects to the server
issues a query and then exits.  I'm getting linker errors all over the
shop (attatched)

ANY ADVICE FOR C++ DEVELOPMENT USING MYSQL++ API APPRECIATED

!! Sorry if you get this more than once !!

Thanks lots
David Ayliffe (mail@stripped)

Deleting intermediate files and output files for project 'mysqltest - Win32 Debug'.
--------------------Configuration: mysqltest - Win32 Debug--------------------
Compiling...
mysqltest.cpp
c:\vc\type_info1.hh(39) : warning C4800: 'int' : forcing value to bool 'true' or 'false'
(performance warning)
c:\vc\type_info1.hh(159) : warning C4800: 'unsigned int' : forcing value to bool 'true' or
'false' (performance warning)
c:\vc\type_info1.hh(172) : warning C4800: 'int' : forcing value to bool 'true' or 'false'
(performance warning)
c:\vc\type_info1.hh(176) : warning C4800: 'int' : forcing value to bool 'true' or 'false'
(performance warning)
c:\vc\type_info1.hh(180) : warning C4800: 'int' : forcing value to bool 'true' or 'false'
(performance warning)
c:\vc\type_info1.hh(184) : warning C4800: 'int' : forcing value to bool 'true' or 'false'
(performance warning)
c:\vc\sql_query1.hh(37) : warning C4800: 'class SQLQuery *' : forcing value to bool 'true'
or 'false' (performance warning)
c:\vc\sql_query1.hh(135) : warning C4355: 'this' : used in base member initializer list
c:\vc\compare1.hh(48) : warning C4800: 'int' : forcing value to bool 'true' or 'false'
(performance warning)
c:\vc\result1.hh(33) : warning C4355: 'this' : used in base member initializer list
c:\vc\result1.hh(42) : warning C4800: 'char' : forcing value to bool 'true' or 'false'
(performance warning)
Linking...
mysqltest.obj : error LNK2001: unresolved external symbol "public: __thiscall
MysqlConnection::~MysqlConnection(void)" (??1MysqlConnection@@QAE@XZ)
mysqltest.obj : error LNK2001: unresolved external symbol "public: bool __thiscall
MysqlQuery::exec(class std::basic_string<char,struct
std::char_traits<char>,class std::allocator<char> > const &)"
(?exec@MysqlQuery@@QAE_NABV?$basic_string@DU?$char_
traits@D@std@@V?$allocator@D@2@@std@@@Z)
mysqltest.obj : error LNK2001: unresolved external symbol "public: bool __thiscall
MysqlConnection::real_connect(char const *,char const *,char const *,char const
*,unsigned int,char,unsigned int,char const *)" (?real_connect@MysqlConnection@@QAE_NP
BD000IDI0@Z)
mysqltest.obj : error LNK2001: unresolved external symbol _mysql_init@4
mysqltest.obj : error LNK2001: unresolved external symbol _mysql_errno@4
Debug/mysqltest.exe : fatal error LNK1120: 5 unresolved externals
Error executing link.exe.

mysqltest.exe - 6 error(s), 11 warning(s)


#include "C:\VC\sqlplus.hh"
#include <stdio.h>
#include <windows.h>

#define MY_DATABASE	"telcent"
#define MY_TABLE    "nazivi"
#define MY_HOST     "localhost"
#define MY_USER     "root"
#define MY_PASSWORD ""
#define MY_FIELD    "naziv"
#define MY_PORT     "3306"
#define MY_QUERY    "SELECT URL from my_table as t1, my_table as t2 where t1.field =
t2.field"

int  main (void) 
{
  Connection con(use_exceptions);
	try {
		ostrstream strbuf; unsigned int i=0; 
		con.real_connect (MY_DATABASE,MY_HOST,MY_USER,MY_PASSWORD,3306,(int)0,60,NULL);
		Query query = con.query(); query << MY_QUERY; 
//		ResUse res = query.use(); Row row; 
//		strbuf << "delete from " << MY_TABLE << " where " << MY_FIELD
<< " in (";
//		for UPDATE just replace the above DELETE FROM with UPDATE statement
//		for(0;row=res.fetch_row();i++) strbuf <<	 row[0] << ",";	if (!i) return 0;

		string output(strbuf.str()); output.erase(output.size()-1,1); output += ")";
		query.exec((const string&)output); // cout << output << endl;
		return 0;
	} catch (BadQuery er) { 
    cerr << "Error: " << er.error << " " << con.errnum() <<
endl;
    return -1;
	}
}
Thread
MySQL++ API HelpDavid Ayliffe4 Jun