Search the web
Sign In
New User? Sign Up
DatabaseTemplateLibrary · The Database Template Library
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
Messages 2047 - 2076 of 2479   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
2047
It seems that I can't call a stored procedure that doesn't have a ref- cursor. The DTL code has a 'if (this->boundIOs.NumColumns() < 1)' check in method...
ronen_yuval
Offline Send Email
Jul 17, 2006
5:38 pm
2048
You can call a sql_iterator that doesn't return a cursor. Just assign to the iterator or increment it to force an execution. (The skipped statment there is...
Corwin Joy
corwinjoy
Offline Send Email
Jul 18, 2006
2:55 am
2049
What exactly do you mean by "assign to the iterator or increment it"? I tried doing typedef DBView<variant_row, variant_row> View; View view("{CALL...
ronen_yuval
Offline Send Email
Jul 19, 2006
3:53 pm
2050
Since this is a C++ crowd list, I thought people might be interested to learn about a great C++ general purpose library that just went free (under Boost...
aleskx
Offline Send Email
Jul 22, 2006
8:27 am
2051
Close. Try variant_row params = iter.Params(); ... *iter = params; ... From: ronen_yuval To: DatabaseTemplateLibrary@yahoogroups.com Sent: Wednesday, July 19,...
Corwin Joy
corwinjoy
Offline Send Email
Jul 22, 2006
11:16 pm
2052
Hello, I hope this is a trivial question to answer - but it's driving me nuts! I have the small example program quoted below. It does what it is supposed to do...
buschnick
Offline Send Email
Jul 25, 2006
10:07 am
2053
Hello, I'm runing sql procedure in prepared procedure mode. The sql procedure defined something like: PROCEDURE x(param1 VARCHAR2, param2 VARCHAR2 DEFAULT...
sjulia_st
Offline Send Email
Jul 25, 2006
12:04 pm
2054
Doesn't work :-( It managed to get the DTL into an endless loop... ... it"? ... execution. ... a ... 1)' ... the...
ronen_yuval
Offline Send Email
Jul 25, 2006
5:30 pm
2055
Hi, I can think of a few things to try here. 1. Add a Commit() call after your inserts. By default DTL does not force a commit to let you control exceptions....
Corwin Joy
corwinjoy
Offline Send Email
Jul 26, 2006
2:31 am
2056
Hmm. Maybe I wasn't clear enough. You would need to have something like typedef DBView<variant_row, variant_row> View; View view("{CALL my_package.my_proc(?,...
Corwin Joy
corwinjoy
Offline Send Email
Jul 26, 2006
3:28 am
2057
ODBC has some issues with variable length strings in that they have to be the last arguments passed as parameters. Two ways to fix this: 1. Use fixed length...
Corwin Joy
corwinjoy
Offline Send Email
Jul 26, 2006
4:32 am
2058
Hi, First of all thanks for the answer. I think I didn't explained my self clearly enough, The problem is not with strings, but with numbers. For example,...
sjulia_st
Offline Send Email
Jul 26, 2006
7:49 am
2059
Hi Corwin, thanks for the quick reply. 1.) I've added a dtl::DBConnection::GetDefaultConnection().CommitAll(); after the loop. No luck. I also tried ...
buschnick
Offline Send Email
Jul 26, 2006
8:32 am
2060
Hi Soren, I think the problem here is that you are just dereferencing the iterator which is what gets done for a fetch and not assigning to it which may not...
Corwin Joy
corwinjoy
Offline Send Email
Jul 27, 2006
12:19 am
2061
Hi, In addition to previos description I've also tried to not give anything to the first parameter: i.e. just set the second not default null parameter. ...
sjulia_st
Offline Send Email
Jul 30, 2006
6:21 am
2062
Yes, it works. It was my mistake to think there's am endless loop. Thanks. ... like ... cursor ... increment ... have ... procedure...
ronen_yuval
Offline Send Email
Jul 31, 2006
8:36 am
2063
Hey Corwin, Your explanation sounds reasonable - I'll try it out as soon as I get access to the second machine again. If that was the problem though I wonder...
buschnick
Offline Send Email
Jul 31, 2006
3:03 pm
2064
Hi, I'm steel waiting for answer to previous questions. Meanwhile I've also tried to send a timestamp as parameter for procedure like: PROCEDURE...
sjulia_st
Offline Send Email
Aug 5, 2006
9:17 am
2065
Hi Julia, Looking at your question more carefully, I need a more complete code example of what you are doing. First of all, take a look at our docs on how to...
Corwin Joy
corwinjoy
Offline Send Email
Aug 5, 2006
3:46 pm
2066
Hi I want to support databases with a ODBC Driver. Users who use my programm can only give my application his own dsn string. My problem is: How can I create...
Frederick Schuler
slivercp
Offline Send Email
Aug 7, 2006
3:25 pm
2067
The only way to create tables in DTL right now is to issue the ODBC SQL yourself. So, e.g. DBStmt("create table employees(Name TEXT, Salary...
cjoy@...
corwinjoy
Offline Send Email
Aug 7, 2006
10:22 pm
2068
Hi Corwin, Thanks for your answer. But I don't work with DynamicDBView<>. I'll try to descibe the code in more details: C++ code ... static const string...
sjulia_st
Offline Send Email
Aug 8, 2006
7:56 am
2069
Hmm. It should be just the case that you can say iter.Params()[0] = NullField(); // or params[0] = NullField(); One simple check to see if this might be...
Corwin Joy
corwinjoy
Offline Send Email
Aug 8, 2006
5:56 pm
2070
hi I've the same problem and I would like to solve it with this solution. But the attachment DBQUery.cpp is not stored. Does someone still have this file? cu...
slivercp
Offline Send Email
Aug 9, 2006
12:25 pm
2071
Hi I have the following code which doesn't work. If I create a database "db_example", then the first time the loop will go ok, the second time it enters it...
dtl_spam
Offline Send Email
Aug 10, 2006
1:57 pm
2072
please join my group : http://groups.yahoo.com/group/myspacelayout __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo!...
Maro Mohamed
sweetfashions4
Offline Send Email
Aug 12, 2006
11:11 am
2073
DTL already supports unicode. http://dtemplatelib.sourceforge.net/Unicode.htm ... From: sachin deshmukh To: cjoy@... ; michael.gradman@... ...
Corwin Joy
corwinjoy
Offline Send Email
Aug 13, 2006
8:26 am
2074
Hi, Tried it and as expected the problem is not in the store procedure Julia ... stored procedure ... type ... copied ... NULL, ... to ... parameter ... know ...
sjulia_st
Offline Send Email
Aug 15, 2006
7:55 am
2075
Hello, I have been using the dtl for about a month now and i have been trying to use a DynamicDbView to run a stored procedure (sql server 2000) I am getting...
mwoods80ca
Offline Send Email
Aug 21, 2006
3:30 pm
2076
Hi, Since you are doing this under sql server there are a few of possibilities that spring to mind. 1. Try using MoreResults(). If you are returning a...
Corwin Joy
corwinjoy
Offline Send Email
Aug 26, 2006
2:50 pm
Messages 2047 - 2076 of 2479   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help