|
Grimes wrote: Does these messages also contain the ip of the computer they were sent from?
Not that I am aware of. They do contain the machine's name, however. Can you not just cross-reference that back to the IP address?
"The largest fire starts but with the smallest spark." - David Crow
|
|
|
|
|
these guys use a program to change that name displayed in the message
KOM UIT DAAAAA!!!
|
|
|
|
|
Oh, I just assumed that NET SEND was being used. The only recourse that I know of is to disable the Messenger service on your machine.
"The largest fire starts but with the smallest spark." - David Crow
|
|
|
|
|
Hi friends,
I want to know how the C++ compiler implements Inheritance,Polymorphysm concepts. Can any one of u suggest some good links .
Thanks in advance.
Appu..
"If you judge people, you have no time to love them."
|
|
|
|
|
|
See this[^] thread
Cheers
Steen.
"To claim that computer games influence children is ridiculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music"
|
|
|
|
|
Thanks it really helped me a lot.
Appu..
"If you judge people, you have no time to love them."
|
|
|
|
|
You're welcome.
Cheers
Steen.
"To claim that computer games influence children is ridiculous. If Pacman had influenced children born in the 80'ies we would see a lot of youngsters running around in dark rooms eating pills while listening to monotonous music"
|
|
|
|
|
Hi buddies i have a relativly simple question
i whant to execute a select statment in c++
but for the WHERE part of the statment i want to read it from a variable of type string
Let me be more precise.
string token;
token="SomeName"
pCommand->CommandText = "SELECT * FROM Table1 WHERE Name=?";//WHERE Name=token
Any ideas pls help
Thanks again
|
|
|
|
|
|
Hey Nibu thanks for the reply can you give me a code sample of how to use it
thanks appreciate the help
|
|
|
|
|
antonaras wrote: Hey Nibu thanks for the reply can you give me a code sample of how to use it
thanks appreciate the help
Look at what steve said. That is the right way to do it.
Nibu thomas
A Developer
Programming tips[^] My site[^]
|
|
|
|
|
Hey Rakesh_Thakur thanks for the reply i tried what you said
i wrote you code but i get 2 errors
1.'strcat' : cannot convert parameter 1 from 'class std::basic_string<char,struct std::char_traits<char="">,class std::allocator<char> >' to 'char *
2.error C2664: 'PutCommandText' : cannot convert parameter 1 from 'class std::basic_string<char,struct std::char_traits<char="">,class std::allocator<char> >' to
'class _bstr_t'
any ideas thanks again
|
|
|
|
|
antonaras wrote: 1.'strcat' : cannot convert parameter 1 from 'class std::basic_string,class std::allocator >' to 'char *
use Obj.C_str();
antonaras wrote: 2.error C2664: 'PutCommandText' : cannot convert parameter 1 from 'class std::basic_string,class std::allocator >' to
'class _bstr_t'
use wrapper _bstr_t
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
Support CRY- Child Relief and You
|
|
|
|
|
What you really need is a parameterised query. The idea is that you create a parameter, and associate it with the command object.
You can then fill in the value, and run the command. Check out the documentation for CreateParameter.
This is preferred to concatenating the text because it avoids problems with strings containing quotes, and the so-called SQL injection attacks.
Steve S
Developer for hire
|
|
|
|
|
Hey Steve allways appreciate the help (again )
I hope i'm not asking much but can you give me an example
|
|
|
|
|
  and I do things a little differently, by using raw interfaces when importing.
Where there is a call to doQuery, you can put so UI in there to ask for & validate a query field. This is a bit rough in places, normally I use OLE DB rather than ADO, but it works. You'll need to change the name of the data source (obviously).
The trick is to create the parameter and associate it with the command object. You can then use Execute to get a recordset, and having done that, you can ask the recordset to requery without needing the command object (once you've changed the parameter value. Add a different call to doQuery with a different string below the first one, and you'll see what I mean.
The advantage over straight SQL text building is that in many cases, the SQL needs to be parsed only once, which is handy for complex queries, and in addition, it protects you from some nasty so-and-so from performing a SQL injection attack.
(Yes, it was asking a bit much, but I had a spare 10 minutes at lunchtime[local time])
<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 />
pRstTemp->MoveFirst();<br />
<br />
pRstTemp->get_EndOfFile(&bEOF);<br />
if (bEOF)<br />
{<br />
_tprintf(_T("\tRecordset empty\n"));<br />
}<br />
else<br />
{<br />
_bstr_t bstrTitle;<br />
_bstr_t bstrType;<br />
<br />
while(!bEOF)<br />
{<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 />
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 />
}
Steve S
Developer for hire
|
|
|
|
|
Try to use a temp string for the query
string token;
token = "SomeName";
string query;
query = "SELECT * FROM Table1 WHERE Name=" + token;
pCommand->CommandText = query.data()
codito ergo sum
|
|
|
|
|
Hey BadKarma thanks for the reply looks like is getting there i used your code and it compiles with no prob
but i get an error at runtime
Error:ΘÆ
Press any key to continue
|
|
|
|
|
strcpy(string,"SELECT * FROM Table1 WHERE Name=?");
strcat( string, token );
-------------
wsprintf(string,"SELECT * FROM Table1 WHERE Name=%s",token);
whitesky
|
|
|
|
|
I've written a VC++ 6.0 app (based on Microsoft's Printmon example) that uses printer notification api's. These work fine for local printers but whenever I try a network printer (\\server\printer name) my application fails with an Invalid Handle from the FindNextPrinterChangeNotification api call. The Printmon example also does this. My client is XP with SP2 and the servers holding the queues are Windows 2000 and Windows 2003, anyone any ideas ?
|
|
|
|
|
If u r using \\server\printer name as a string forget not to include '\' before each '\' , means "\\\\Server\\printer name" should be used.
Appu..
"If you judge people, you have no time to love them."
|
|
|
|
|
|
Printername for network printer is in the correct format, my call to OpenPrinter is successful.
Its the call to FindNextPrinterChangeNotification that is actually failing with an invalid handle.
|
|
|
|
|
Use the Handle returned by OpenPrinter , as the input Handle for FindNextPrinterChangeNotification
Appu..
"If you judge people, you have no time to love them."
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
