C / C++ / MFC

antonaras wrote:

Hey Nibu thanks for the reply can you give me a code sample of how to use it
thanks appreciate the help

antonaras wrote:

1.'strcat' : cannot convert parameter 1 from 'class std::basic_string,class std::allocator >' to 'char *

antonaras wrote:

2.error C2664: 'PutCommandText' : cannot convert parameter 1 from 'class std::basic_string,class std::allocator >' to
'class _bstr_t'

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

<br />
#include <windows.h><br />
#include <tchar.h><br />
#include <ole2.h><br />
#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \<br />
    no_namespace rename("EOF", "EndOfFile") raw_interfaces_only<br />
#include <stdio.h><br />
#include <conio.h><br />
<br />
<br />
void printRows(_Recordset* pRstTemp)<br />
{<br />
	VARIANT_BOOL bEOF;<br />
    // Ensure at top of recordset.<br />
    pRstTemp->MoveFirst();<br />
<br />
    // If EOF is true, then no data and skip print loop.<br />
	pRstTemp->get_EndOfFile(&bEOF);<br />
	if (bEOF)<br />
    {<br />
        _tprintf(_T("\tRecordset empty\n"));<br />
    }<br />
    else<br />
    {<br />
        // Define temporary strings for output conversions.<br />
        // Initialize to first record's values.<br />
        _bstr_t bstrTitle;<br />
        _bstr_t bstrType;<br />
<br />
        // Enumerate Recordset and print from each.<br />
        while(!bEOF)<br />
        {<br />
			// Convert variant string to convertable string type.<br />
			FieldsPtr spFields;<br />
			FieldPtr spField;<br />
			long nFields;<br />
			pRstTemp->get_Fields(&spFields);<br />
			spFields->get_Count(&nFields);<br />
			for(long f = 0; f < nFields; f++)<br />
			{<br />
				BSTR t = NULL;<br />
<br />
				spFields->get_Item(_variant_t(f), &spField);<br />
				_variant_t v;<br />
				spField->get_Value(&v);<br />
				spField->get_Name(&t);<br />
				if (v.vt != VT_NULL)<br />
				{<br />
					v.ChangeType(VT_BSTR);<br />
#ifdef	_UNICODE<br />
					_tprintf(_T("%20.20s: %s\n"), (LPCWSTR)t, (LPCWSTR)v.bstrVal);<br />
#else<br />
					_tprintf(_T("%20.20S: %S\n"), (LPCWSTR)t, (LPCWSTR)v.bstrVal);<br />
#endif<br />
				}<br />
				else<br />
				{<br />
#ifdef	_UNICODE<br />
					_tprintf(_T("%20.20s: (null)\n"), (LPCWSTR)t);<br />
#else<br />
					_tprintf(_T("%20.20S: (null)\n"), (LPCWSTR)t);<br />
#endif<br />
				}<br />
				SysFreeString(t);<br />
				spField = NULL;<br />
			}<br />
			_tprintf(_T("\n"));<br />
			pRstTemp->MoveNext();<br />
			pRstTemp->get_EndOfFile(&bEOF);<br />
        }<br />
    }<br />
}<br />
<br />
void doQuery(_CommandPtr& pCmd, _RecordsetPtr& pRS, _ParameterPtr& pParam, LPCTSTR custid)<br />
{<br />
	HRESULT hr;<br />
	pParam->put_Value(_variant_t(custid));<br />
	if (pRS==NULL)<br />
	{<br />
		hr = pCmd->Execute(NULL,NULL,0,&pRS);<br />
	}<br />
	else<br />
	{<br />
		hr = pRS->Requery(0);<br />
	}<br />
	if (SUCCEEDED(hr))<br />
	{<br />
		printRows(pRS);<br />
	}<br />
}<br />
<br />
void doSample()<br />
{<br />
	HRESULT hr;<br />
	_ConnectionPtr spConn;<br />
	_CommandPtr spCommand;<br />
	_RecordsetPtr spRS;<br />
	_ParameterPtr spParam;<br />
	ParametersPtr spParamSet;<br />
	_variant_t custid;<br />
<br />
	hr = spConn.CreateInstance(__uuidof(Connection));<br />
	if (SUCCEEDED(hr))<br />
	{<br />
		_bstr_t empty(_T(""));<br />
		_bstr_t sample(_T("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nwind.mdb"));<br />
		hr = spConn->Open( sample, empty, empty, adModeUnknown);<br />
		if (SUCCEEDED(hr))<br />
		{<br />
			hr = spCommand.CreateInstance(__uuidof(Command));<br />
			if (SUCCEEDED(hr))<br />
			{<br />
				spCommand->put_CommandText(_bstr_t("SELECT * FROM customers WHERE CustomerID = ?"));<br />
				spCommand->put_Prepared(VARIANT_TRUE);<br />
				spCommand->putref_ActiveConnection(spConn);<br />
				hr = spCommand->Execute(NULL,NULL,adCmdText, &spRS);<br />
				hr = spCommand->get_Parameters(&spParamSet);<br />
				spParamSet->Refresh();<br />
				hr = spCommand->CreateParameter(NULL,adBSTR,adParamInput,NULL,custid,&spParam);<br />
				spParamSet->Append(spParam);<br />
<br />
				// Here you can call doQuery any number of times...<br />
				doQuery(spCommand, spRS, spParam, _T("ALFKI"));<br />
			}<br />
			else<br />
			{<br />
				_tprintf(_T("Unable to create command [HR=0x%8lX]\n"),hr);<br />
			}<br />
			spConn->Close();<br />
		}<br />
		else<br />
		{<br />
			_tprintf(_T("Unable to open connection [HR=0x%8lX]\n"),hr);<br />
		}<br />
	}<br />
	else<br />
	{<br />
		_tprintf(_T("Unable to create connection object [HR=0x%8lX]\n"), hr);<br />
	}<br />
}<br />
<br />
<br />
int main(int argc, char**argv)<br />
{<br />
	if (SUCCEEDED(CoInitialize(NULL)))<br />
	{<br />
		doSample();<br />
		CoUninitialize();<br />
	}<br />
	return 0;<br />
}

string token;
token = "SomeName";

string query;
query = "SELECT * FROM Table1 WHERE Name=" + token;

pCommand->CommandText = query.data()

P Gibson wrote:

...my application fails with an Invalid Handle from the FindNextPrinterChangeNotification api call.

"The largest fire starts but with the smallest spark." - David Crow

"The largest fire starts but with the smallest spark." - David Crow