Hi, authors of DTL, I'm new to DTL and just built it on my Ubuntu 6.06 dapper, with GCC 4.0.3. I created a DSN to connect to SQL Server Express 2008, and use...
MENG Xin
zinces@...
May 11, 2009 6:38 pm
2446
Well, it's hard to say what is going wrong without more information here. It is a bit strange to be calling SQL Server Express from Ubuntu. It could be...
Hi, Tried to find out how to do the following: SELECT * FROM table WHERE entry IN (?) Is it as simple as having a std::vector< _type_ > as parameter type? TIA ...
Hello there, First of all , thank you very much for this very useful library. being able to use stl mindset is a boon in a field i am not very competent,so...
Corwin, Limited by my current IT environment, I have to connect SQL Server Express from Ubuntu, because there is no MySQL deployed. I missed some detail in my...
MENG Xin
zinces@...
May 31, 2009 5:43 am
2450
Hello hurcan, Sorry it took me a while to get back to you, been a busy last couple weeks. It has been a long time since I did this and I don't remember if I...
Probably you want to do this via a sql_iterator. I believe your syntax could work under ODBC but remember that the (?) has to hold a single parameter. So here...
Here is what Mike had to say: From: "Michael.Gradman" I do not know if we support bulk inserts for variant_rows. I would think only with the user providing...
Corwin, I have even now gotten a Z-machine called ZaxMidlet to work on my Blackberry! This means I now can play text adventure games anywhere I go! Mike...
I'm trying MySQL "REPLACE INTO" with sql_iterator, but I get an exception: "Fetch without a SELECT" The query looks like: "REPLACE INTO table VALUES...
... Should anyone be curious of how this was resolved, it was a problem with the MySQL ODBC driver (in the Ubuntu 8.04 distro). By using a newer one, it works...
If REPLACE construct involves replacing records that match particular conditions (like using a WHERE clause) you can use a select_update_iterator to achieve...
... REPLACE INTO is equal to an INSERT or UPDATE (INSERT if row doesn't exist, UPDATE otherwise), so I don't thing select_update_iterator will suffice. /Rob...
What you could do is do something like this: Write code using an IndexedDBView() that provides the kind of behavior you are talking about ... of course your...
I have an SQL query which I run on a remote MySQL db. With SQLyog the total time (db+transfer) takes ~500 ms (78000 rows) whereas using DTL (release build)...
I have an XML which I parse and insert data into a MySQL database, the strings are in utf8 format, and although I've setup the columns to be utf8 the strings...
... Hi Corwin, that page states that you can use std::wstring for column data, but I get compilation failures trying that. I really don't want the fullblown...
I solved the wide char issues by changing tcstring<N> to tcstring<N,CharType>, and fixing some stuff in BoundIO (and elsewhere) so that the wide tcstrings can...
Maybe you could let MySQL convert it to utf8: http://dev.mysql.com/doc/refman/5.0/en/charset-convert.html But of course its better, if you don't have to...
Jens Weller
JensWeller@...
Jun 25, 2009 2:34 pm
2465
Robert, It would probably be well-worth it will you supply this patch. And maybe you could supply us with some notes about the changes you had to make,...
I have an MS sql application that is installed to have local access with Windows Authentication. I can CONNECT to this data base from my other utility (php...
Hi All I have successfully compiled DTL in mingw with msys in windows XP 32 bit http://www.mingw.org/wiki/msys To do this, I followed the instructions on how...
I have a specialized ms sql db on WinXP which is configured for Widows Authentication from the local machine. I can connect to this fine with php script from...
... Sure. DTL just uses an ODBC connection. So, when you set up the odbc connection you can simply choose to use Windows Authentication rather than SQL...
Hi I've been using DTL for about a month now. I'm fairly sure i'm not using it the most optimal way but any way... I'm having trouble with my select update...
Hi, I seemed to have got it going. I moved the keys assignment to the select_insert_iterator after it has selected stuff. template<class DataObj> bool ...
Hi All I've spent ages looking through the documentation about this. I am still unsure... If i have an array of 10 objects and i call bulk_fetch, how do i know...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
