Improve company productivity with a Business Account.Sign Up

x
?
Solved

How do I build SQL "Insert into" basic_stringstream using variables in C++

Posted on 2004-09-17
7
Medium Priority
?
370 Views
Last Modified: 2012-06-22
I'm trying to build a function that will take string inputs and build an SQL statement for input into a database.  Here's my existing code:

void Connector::InsertData(string _table, string _column, string _value)
{
        // string I/O stream
    basic_stringstream<wchar_t> strSQLStatement;
    variant_t vntRecordAffected;

      strSQLStatement <<L"INSERT INTO " << _table.c_str() << "(" << _column.c_str() << ") VALUES('" << _value.c_str()<< "' ) ";

    cout << "strSQLStatement =" << strSQLStatement.str().c_str() <<endl;
    _bstr_t strSQLstmt = strSQLStatement.str().c_str();

    try
    {
        _connect->Execute(strSQLstmt, &vntRecordAffected, adCmdText );
    }
    catch( _com_error &e)
    {
        // get info from _com_error
        _bstr_t bstrSource(e.Source());
        _bstr_t bstrDescription(e.Description());

        printf("%s", e.ErrorMessage());
        cout << endl << "No Data Entered." << endl << endl;
    }  // end catch

      cout << "Data Inserted." << endl;

}  //End InsertData

Does anybody have an input?
0
Comment
Question by:RedHedToo
  • 4
  • 2
6 Comments
 
LVL 17

Expert Comment

by:rstaveley
ID: 12091216
Use wcout to see the wide string:

i.e.

wcout << "strSQLStatement =" << strSQLStatement.str().c_str() <<endl;
0
 

Author Comment

by:RedHedToo
ID: 12101904
Sorry, I should've looked closer for editing purposes prior to putting it up.  The problem is that the string always sends back an error.  I've tried several ways to build a string to create the statement, but the only thing that works so far is creating an entire string at one time without actually using any data in variables.  The line I have in there now:

     strSQLStatement <<L"INSERT INTO " << _table.c_str() << "(" << _column.c_str() << ") VALUES('" << _value.c_str()<< "' ) ";

doesn't actually work properly.

Anybody have a solution?

Red.
0
 
LVL 17

Expert Comment

by:rstaveley
ID: 12102092
If I hack your code thus, I get what looks like good SQL:
--------8<--------
#include <iostream>
#include <sstream>
using namespace std;

void /*Connector::*/InsertData(string _table, string _column, string _value)
{
        // string I/O stream
    basic_stringstream<wchar_t> strSQLStatement;
//    variant_t vntRecordAffected;

     strSQLStatement <<L"INSERT INTO " << _table.c_str() << "(" << _column.c_str() << ") VALUES('" << _value.c_str()<< "' ) ";

    wcout << "strSQLStatement =" << strSQLStatement.str().c_str() <<endl;
}

int main()
{
      InsertData("mytable","mycolumn","myvalue");
}
--------8<--------

Output is:

strSQLStatement =INSERT INTO mytable(mycolumn) VALUES('myvalue' )

My SQL experience isn't strong enough to vouch whether you can get away with the lack of space between mytable and '('.

Is this not what you are getting?

Clearly this is only good for a table which has one field in it only. You have put quotes around myvalue, which means you couldn't conveniently pass a comma separated strings. You'd need to have something like

      InsertData("mytable"
            ,"my1stcolumn,my2ndcolumn"
            ,"my1stvalue','my2ndValue"      /* <- Weird quotes! */
      );
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 

Author Comment

by:RedHedToo
ID: 12102383
I'm getting an error, actually.  "IDispatch error #3092"  When I googled it , the Microsoft site said I needed single quotes, which I already have.  It also said it may be a problem with MDAC 2.5 (I'm running 2.7), so right now I don't know the exact problem.  

Red.
0
 
LVL 17

Expert Comment

by:rstaveley
ID: 12103665
I recommend you close this question (ask for a refund) and start a new question with an appropriate title (e.g. "MS MSL - IDispatch error #3092"). Some folks who are knowledgeable about MS SQL may not be looking at this, thinking this is an STL problem, which it isn't.
0
 
LVL 17

Accepted Solution

by:
rstaveley earned 405 total points
ID: 12305971
Delete question. The title was misleading. The problem wasn't handled by my answers, because it was unrelated.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Often, when implementing a feature, you won't know how certain events should be handled at the point where they occur and you'd rather defer to the user of your function or class. For example, a XML parser will extract a tag from the source code, wh…
IntroductionThis article is the second in a three part article series on the Visual Studio 2008 Debugger.  It provides tips in setting and using breakpoints. If not familiar with this debugger, you can find a basic introduction in the EE article loc…
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question