Re: Database Query containing single or Double Quotes - C / C++ / MFC Discussion Boards

Re: Getting the data from a CString into an LPVOID data type

Nish Nishant3-May-02 5:43

3-May-02 5:43

Tom Archer wrote:
Answered in your other query for same

Thanks. I saw it.
In the confuision I forgot my original reason.
You told him to use GetBuffer, but I think you didnt tell him about RelkeaseBuffer Smile | :)

Nish

Check out last week's Code Project posting stats presentation from :-
http://www.busterboy.org/codeproject/
Feel free to make your comments.

Re: Getting the data from a CString into an LPVOID data type

Tom Archer3-May-02 5:53

Tom Archer

3-May-02 5:53

Call ReleaseBuffer is not necessary in this context.

Cheers,
Tom Archer
Author, Inside C#

A total abstainer is one who abstains from everything but abstention, and especially from inactivity in the affairs of others.

Re: Getting the data from a CString into an LPVOID data type

kyledunn3-May-02 4:47

kyledunn

3-May-02 4:47

I emailed Tom directly. He responded shortly before I posted his help here.

Kyle

Re: Getting the data from a CString into an LPVOID data type

mystro_AKA_kokie3-May-02 4:01

mystro_AKA_kokie

3-May-02 4:01

Convert first to LPCTSTR then maybe LPSTR then to LPVOID. These are all pointers, CString isn't so you need to convert to a pointer first. The internal data structure of a cstring object is an LPCTSTR pointer; you acess it directly by calling GetBuffer(int nmax),but you also have to call ReleaseBuffer() after .

Database Query containing single or Double Quotes

Samir Sood3-May-02 3:19

Samir Sood

3-May-02 3:19

When i construct a query containng the query which conatins either the single quotes or double quotes then the query crashes . Can anyone suggest the solution

Samir

Re: Database Query containing single or Double Quotes

Nish Nishant3-May-02 4:04

Nish Nishant

3-May-02 4:04

Samir Sood wrote:
When i construct a query containng the query which conatins either the single quotes or double quotes then the query crashes . Can anyone suggest the solution

For each quote you have in a string, add an extra quote.
Thus if you want to insert a string such as "John's Bakers" into a table, insert it as "John''s Bakers" and all will be well Smile | :)

Nish

Check out last week's Code Project posting stats presentation from :-
http://www.busterboy.org/codeproject/
Feel free to make your comments.

Re: Database Query containing single or Double Quotes

3-May-02 6:44

But what if string contains the double quotes as part of it

Re: Database Query containing single or Double Quotes

Tom Archer3-May-02 6:47

Tom Archer

3-May-02 6:47

As Nish said, you need to double up on the quotes. For example, Access chokes on quotes in a string value because it uses quotes as the string delimiter. Therefore, here's a function I wrote a few years ago to do what you need. It only handles single quotes, but obviously you can easily modify it for your needs.

CString FormatValidAccessString(CString const & sStringToBeFormatted)
{
 CString sFormattedString;

 int iStringLength = sStringToBeFormatted.GetLength();
 char cChar;

 for (int i = 0; i < iStringLength; i++)
 {                               
  cChar = sStringToBeFormatted.GetAt(i);
  sFormattedString += cChar;
  if ('\'' == cChar)
  {
   sFormattedString += cChar;
  }
 }	

 return sFormattedString;		
}

Cheers,
Tom Archer
Author, Inside C#

A total abstainer is one who abstains from everything but abstention, and especially from inactivity in the affairs of others.

Re: Database Query containing single or Double Quotes

Stefan Pedersen3-May-02 8:54

Stefan Pedersen

3-May-02 8:54

Or to keep it really simple...

CString cMyString = "string possibly containing chars that need to be escaped...";
cMyString.Replace("'", "''");

If I remember correctly you can even get the string quotation character from ADO (the connection object probably)
so that your code is a little bit more provider independent. It's usually " for "real" databases Smile | :)

ComboBox - selchange?

jimNLX3-May-02 3:11

jimNLX

3-May-02 3:11

I created a combobox and put a list of data within it. Then I instantiated it and then added a selchange message.

I was trying to add a popup and some other code to the selchange but nothing I put under it ever gets executed.

I do get the new index for the item selected.

Any help would be much appriciated.

Thanks! Confused | :confused:

Re: ComboBox - selchange?

Michael P Butler3-May-02 4:20

Michael P Butler

3-May-02 4:20

Is the OnSelChange function being executed or does it not get called. If the function is being called, can you post what code you are expecting to execute.

Is the OnSelChange function in the dialog class?

Michael Smile | :)

Communication is the first step towards enlightenment.

Re: ComboBox - selchange?

jimNLX3-May-02 7:24

jimNLX

3-May-02 7:24

Well I went and deleted the combobox sechange and started over.

Now it seems like it is executing but the index isn't getting set. HMMM

How to set EditBox as readonly and steel have a white backgroud ?

adara3-May-02 2:37

adara

3-May-02 2:37

How to set EditBox as readonly and steel have a white backgroud ?
any ideas ? Rose | [Rose]

Re: How to set EditBox as readonly and steel have a white backgroud ?

Tom Archer3-May-02 3:15

Tom Archer

3-May-02 3:15

While I disagree with your UI decision (it definitely goes against what users are accustomed to), you can do this by handling the OnCtlColor message. There's a few threads here about how to do that. Just search on that function name and you should find what you need.

Cheers,
Tom Archer
Author, Inside C#

A total abstainer is one who abstains from everything but abstention, and especially from inactivity in the affairs of others.

Re: How to set EditBox as readonly and steel have a white backgroud ?

john john mackey3-May-02 5:58

john john mackey

3-May-02 5:58

I believe the reference you will find helpful is by Chris Losinger, Colorizing Edit Control at CodeProject.com

This may or may not be exactly the one, but I have a ZIP that I downloaded named "ColorEdit_ColorStatic".

It tells how to change colors of foreground text and background for both edit controls and static controls (e.g. labels.)

Good luck. These helped me bring my dialogs to life!

Johnny

reading sectors from CD

hobnob3-May-02 2:33

hobnob

3-May-02 2:33

anybody have any sample c/c++/asm code to read sectors from a cd, or know where i can find an example ?

Re: reading sectors from CD

3-May-02 5:50

Try loading wnaspi32.dll and use that to send commands to the cd-rom. Or just look up documentation on the ASPI layer.

No School
No Job
No Problem

Q: how to obtain message box font display property setting

Gil Clark3-May-02 2:16

Gil Clark

3-May-02 2:16

Hey everybody.
You know how in Windows Display Properties Appearance you can change the colors and fonts for many system items like menus, 3DObjects, etc. You can obtain the color settings using GetSysColor(), but I was just wondering if anybody out there knew how to obtain the font settings for the items? Particularly the Message Box.

I've searched through Code Project and MS Knowledge Base but didn't find anything (probably not using the right keywords or something).

Anyone?

Thanks

Re: Q: how to obtain message box font display property setting

Roger Allen3-May-02 2:58

Roger Allen

3-May-02 2:58

In MFC you shoul dbe able to get a handle to some fonts by using the AUX_DATA structure afxData. It has some fonts in it as HFONT objects. Nit sure if they are the ones you need.

Roger Allen
Sonork 100.10016

If I had a quote, it would be a very good one.

Re: Q: how to obtain message box font display property setting

Gil Clark3-May-02 3:47

Gil Clark

3-May-02 3:47

I'd prefer a non-mfc approach (sdk). The only 2 fonts I find in that AUX_DATA structure are StatusFont and ToolTipsFont (at least in the version I have).

Re: Q: how to obtain message box font display property setting

Maxwell Chen3-May-02 3:05

Maxwell Chen

3-May-02 3:05

Try

SystemParametersInfo( )

Maxwell Chen
No code is good code.

Re: Q: how to obtain message box font display property setting

Gil Clark3-May-02 3:39

Gil Clark

3-May-02 3:39

I've looked at that already, but didn't find anything. Which action value?

Re: Q: how to obtain message box font display property setting

Maxwell Chen3-May-02 3:47

Maxwell Chen

3-May-02 3:47

Try this, I tried, and changed some values, and my Windows2K got strange...

void CTestMsgFontDlg::OnButton1() 
{
	NONCLIENTMETRICS ncmOld, ncmTest;
	
	AfxMessageBox(_T("Test change of font for message boxes."), MB_OK);
	ncmOld.cbSize = sizeof(NONCLIENTMETRICS);
	if(SystemParametersInfo(SPI_GETNONCLIENTMETRICS, sizeof(NONCLIENTMETRICS), &ncmOld, 0))
	{
		memcpy(&ncmTest, &ncmOld, sizeof(NONCLIENTMETRICS));
		ncmTest.lfMessageFont.lfUnderline = 1;
		
		AfxMessageBox(_T("Before change of font for message boxes."), MB_OK);
		if(SystemParametersInfo(SPI_SETNONCLIENTMETRICS, sizeof(NONCLIENTMETRICS), &ncmTest, 0))
		{
			AfxMessageBox(_T("Message box font changed."), MB_OK);
			ncmOld.lfMessageFont.lfUnderline = 0;
			SystemParametersInfo(SPI_SETNONCLIENTMETRICS, sizeof(NONCLIENTMETRICS), &ncmOld, 0);
			AfxMessageBox(_T("Message box font restored."), MB_OK);
		}
	}
}

Maxwell Chen
No code is good code.

Re: Q: how to obtain message box font display property setting

Gil Clark3-May-02 4:14

Gil Clark

3-May-02 4:14

Too cool. Thanks. The name of that item is mis-leading. NONCLIENT. I thought it would be the font used for the maximize, minimize, close buttons.

i could not update my context menu item...

Atilla Selem3-May-02 1:40

Atilla Selem

3-May-02 1:40

hi,
i have a dialog based app. i use a context menu when i right click and choose an item for my special purpose. i could not put a check when i choose that item on my context menu even though i have got the ON_UPDATE_COMMAND_UI message handler to update my item state.
What should i do?
isn't it possible to update the state of a context menu item without using a SDI of MDI application(a menu is a must?)
Thanks for ur help,

Atilla Selem

just listening to you...

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.