Re: I have to insert value into table at runtime ? - C / C++ / MFC Discussion Boards

Joe Woodbury14-Sep-09 8:08

14-Sep-09 8:08

Even if you count them yourself, so what? You still can't pass, say, a 1 for a %s parameter and not have it fail.

I have a safe format function which is basically the following (with more error and exception processing, but this gives the gist):

__try
{
	return _vsnprintf(pBuffer, bufferLen, pFormat, args);
}
__except (EXCEPTION_EXECUTE_HANDLER)
{
	Copies raw format string into buffer
}

Re: vsnprintf()

Member 419459314-Sep-09 9:07

Member 4194593

14-Sep-09 9:07

You say that this is YOUR function to post an error message, thus it is assumed that it is YOUR code that is calling this function. I would suggest that you examine all calls to SetErrorInfo in YOUR code to insure that they supply parameters for each '%' in the format string.

There is not a built in way to check the number of arguments pushed on the stack for a call.

There is a messy way to do this, but it involves modifying all code that calls SetErrorInfo, and this amounts to the same effort (only more so) as to examine all the calls to SetErrorInfo. You could drop into ASM and push a flag value (__ASM mov eax,0x012345678 __ASM push eax) just before making the call to SetErrorInfo, make the call, then erase the flag upon return by dropping into ASM again (__ASM add esp,4). Inside SetErrorInfo you could examine the stack by dropping into ASM and check if the flag value immediately followed the format or was found too close to the format argument for the number of '%' characters in the format string. First you have to verify that a format string has actually been passed (and not a NULL argument), then that the string contains % characters, etc, etc, etc. Messy, messy, messy! Just examine all calls to SetErrorInfo.

Dave.

I have to insert value into table at runtime ?

jadhavjitendrar14-Sep-09 0:26

jadhavjitendrar

14-Sep-09 0:26

CSting strid = m_strStringArr.getat(i);
T("INSERT INTO tablename (setid) VALUES('strAnsi')");

This is my query and i get table field and its value at runtime.So how to insert this value.any idea about it..means Setid and stransi i get at runtime..

modified on Monday, September 14, 2009 6:37 AM

Re: I have to insert value into table at runtime ?

«_Superman_»14-Sep-09 0:44

«_Superman_»

14-Sep-09 0:44

Use CString::Format[^] to create the string.

CString cs;
cs.Format(_T("INSERT INTO tablename (%s) VALUES('%s')"), setid, strAnsi);

«_Superman_»
I love work. It gives me something to do between weekends.

Re: I have to insert value into table at runtime ?

jadhavjitendrar14-Sep-09 0:48

jadhavjitendrar

14-Sep-09 0:48

It Works..

Thanks Superman

Re: I have to insert value into table at runtime ?

jadhavjitendrar14-Sep-09 2:24

jadhavjitendrar

14-Sep-09 2:24

But after set this data to fields,every fields ti goes into new line.i dont want this.I want after new line it goes to next line or next record.So how to solve this problem..

Re: I have to insert value into table at runtime ?

norish14-Sep-09 8:30

norish

14-Sep-09 8:30

When strAnsi has _T("aaa\nbbb\nccc") then want to make 3 records?
Do you mean like this?

If then, you must split strAnsi at first and make and execute sql 3 times.

For example;

TCHAR* strData = strAnsi.GetBuffer(-1);
TCHAR* pToken = _tcstok(strAnsi, _T("\n"));
while (pToken) {
  CString sql;
  sql.Format(_T("INSERT INTO tablename (%s) VALUES('%s')"), setid, pToken);
  // execute SQL here
}
strAnsi.ReleaseBuffer();

Well, I dont feel good VALUES('%s') in above sql because of string
escaping issue or SQL-injection problems.
I usually use prepared statements or parameterized query for this purpose.

Re: I have to insert value into table at runtime ?

CPallini14-Sep-09 0:45

CPallini

14-Sep-09 0:45

Do you really OMG | :OMG:

mean this

CString strTable = _T("MyRuntimeValueForTable");
CString strData = _T("MyRuntimeValueForData");

CString strQuery;
strQuery.Format(_T("INSERT INTO %s VALUES ('%s')"), strTable, strData);

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

need help for programming PTZ camera

rajapp13-Sep-09 23:09

rajapp

13-Sep-09 23:09

hi,
please anyone help me in programming ptz camera query and response commands. pan tilt zoom functionalities are all done but I dont know how to get the angles from ptz camera.I tryed to give the query command and response but have some problem and I dont know how to use this commands of protoocol in c++.. I am using pelco D protocol. please help Confused | :confused:

Cut Rectangles in images

Game-point13-Sep-09 22:14

Game-point

13-Sep-09 22:14

Hi
How to cut rectangles in images ..in dialog based application

thanks and regards

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

Re: Cut Rectangles in images

CPallini13-Sep-09 22:55

CPallini

13-Sep-09 22:55

See here.
Smile | :)

Re: Cut Rectangles in images

Game-point13-Sep-09 23:26

Game-point

13-Sep-09 23:26

thanks 4 ...your replay

CImage _cImage;
	_cImage.Load(_T("D:/2009ga.jpg"));
	/*
	x1 = 9175
	y1 = 631
	x2 = 10563
	y2 = 65
	*/
	CRect rect(9175,631,10563,65);
	_cImage.Draw(NULL,rect);
	_cImage.Save(_T("D:/tct.jpg"));

but the result showing the same image of 2009ga.jpg

~~~~~~~~~~~~~Raju~~~~~~~~~~~~~

HOw can run vlc code

anishkannan13-Sep-09 21:23

anishkannan

13-Sep-09 21:23

Hi..

New in c++ application... Now i need play video.. i got Vlc code from corresponding VLC Site.. which have c and c++ code ... I want run that code ... How can i run that project... Which Software we use...

Thanks

Re: HOw can run vlc code

CPallini13-Sep-09 21:48

CPallini

13-Sep-09 21:48

Have a look at [^].
Smile | :)

Re: HOw can run vlc code

Michael Schubert13-Sep-09 21:52

Michael Schubert

13-Sep-09 21:52

anishkannan wrote:
Hi..

New in c++ application... Now i need play video.. i got Vlc code from corresponding VLC Site.. which have c and c++ code ... I want run that code ... How can i run that project... Which Software we use...

Thanks

The only response I could think of:
Liquid-Nitrogen[^]

Re: HOw can run vlc code

enhzflep14-Sep-09 4:18

enhzflep

14-Sep-09 4:18

Outstanding!
Just to let you know where the 5 is from....

Reg XML reading

hellogany13-Sep-09 21:07

hellogany

13-Sep-09 21:07

HI all

I am using vs2005, I need to develope application in vc++ for retrivin data from and xml.

can anyone suggesst some ideas.

Re: Reg XML reading

Nuri Ismail13-Sep-09 21:20

Nuri Ismail

13-Sep-09 21:20

Here on CP there are a lots of articles about XML parsers -> here[^]

Regards
Nuri Ismail

Re: Reg XML reading

kilt14-Sep-09 2:14

kilt

14-Sep-09 2:14

No, useless.
Simply use built-in Win32 XML apis (COM, SAX, and others)
Tons of samples in MSDN in C and C++

Re: Reg XML reading

Nuri Ismail14-Sep-09 3:32

Nuri Ismail

14-Sep-09 3:32

kilt wrote:
No, useless.

I don't think so! These articles, from the link I gave, were (and still are) very useful for me! Smile | :)

The next time think again before determining the hardworking people's great contributions (in this case - over 30 articles about XML, here on CP) as useless!!!

You might be a very "constructive" person! I can see your "huge contribution" in your posts[^].

Regards

Re: Reg XML reading

David Crow14-Sep-09 4:08

David Crow

14-Sep-09 4:08

Nuri Ismail wrote:
You might be a very "constructive" person!

That's the last adjective I'd use to describe him.

"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

Re: Reg XML reading

Nuri Ismail14-Sep-09 4:19

Nuri Ismail

14-Sep-09 4:19

Absolutely! Thumbs Up | :thumbsup: