C / C++ / MFC Discussion Boards

I have to insert value into table at runtime ?

jadhavjitendrar14-Sep-09 0:26

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: