Re: ADO MySQL query problem - C / C++ / MFC Discussion Boards

Tyrus18210-Sep-04 18:51

10-Sep-04 18:51

hello i have a list control and i want it to be multi select but currently the only way to multi select is to hold down shift how does one make it function more like a list box
thanks
Tyrus

Re: list control selection

Branislav11-Sep-04 4:05

Branislav

11-Sep-04 4:05

http://www.codeproject.com/combobox/listbox_tut.asp?df=100&forumid=1373&exp=0&select=655474

Re: list control selection

Tyrus18211-Sep-04 4:20

Tyrus182

11-Sep-04 4:20

im not looking for list boxs im looking for list controls
thanks tho

Re: list control selection

Branislav11-Sep-04 5:04

Branislav

11-Sep-04 5:04

In function OnItemchangedListCtrl put:
NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
m_cListCtrl.SetItemState(pNMListView->iItem, LVIS_SELECTED | LVIS_FOCUSED, LVIS_SELECTED | LVIS_FOCUSED);

Re: list control selection

Ravi Bhavnani11-Sep-04 5:07

Ravi Bhavnani

11-Sep-04 5:07

You'll need to subclass the list control and reflect the L-click message so you can handle (see the list control classes at CP for examples). In the L-click handler, add the item to the list of selected ones by doing:

SetItemState (nItem,
              LVIS_SELECTED | LVIS_FOCUSED,
              LVIS_SELECTED | LVIS_FOCUSED);

/ravi

My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com

ADO MySQL query problem

Graham Holdaway10-Sep-04 16:34

Graham Holdaway

10-Sep-04 16:34

Hi guys,

Just encountered a small problem with ADO when trying to read data from two tables in a database that have the same variable names. In my example I have table_1 with a variable called "id" and a table_2 which also has a variable called "id". The id's in each table are not related. I then want to execute a mysql query something like this:

select table_1.id, table_1.country, table_2.id, table_2.country \
from table_1,table_2 where table_1.country=table_2.country

In this case I am matching table_1 to table_2 by country. So far so good. The problem comes when I want read back the values using this method:

var_1 = (long *) (_bstr_t)pRecordSet->GetCollect("id");

In this line above, how does ADO know which id value I am referring too?? I tried this:

var_1 = (long *) (_bstr_t)pRecordSet->GetCollect("tablel_1.id");
var_2 = (long *) (_bstr_t)pRecordSet->GetCollect("tablel_2.id");

.. but it didn't like "tablel_1.id" How can I distinguish between the two if tables contain the same variable names? In this case "country" is the same in both tables, so that one doesn't matter, but id dcoes. I can't find any example anywhere in books or the web. All the examples seem to have tables with completely different variables names and hence do not have this problem.

Help anyone?, I would be very grateful.

Graham.

Re: ADO MySQL query problem

Arsalan Malik10-Sep-04 20:23

Arsalan Malik

10-Sep-04 20:23

Try using column aliases. For example your query can be written as:

<code>SELECT</code> table_1.id <code>AS</code> id1, table_1.country, table_2.id <code>AS</code> id2, table_2.country
<code>FROM</code> table_1,table_2
<code>WHERE</code> table_1.country=table_2.country;

and then, try using "id1" and "id2" to retrieve values. Cool | :cool:

Arsalan Malik

Re: ADO MySQL query problem

Anonymous11-Sep-04 18:51

Anonymous

11-Sep-04 18:51

That's great, thanks!

Graham.

Change mainframe menu on startup

Ravi Bhavnani10-Sep-04 13:38

Ravi Bhavnani

10-Sep-04 13:38

My MDI app runs in one of 2 modes (detected in the app's InitInstance()). In "regular" mode, I'd like the mainframe window to use the standard IDR_MAINFRM menu. When the app is in "special" mode, I want it to use an alternate menu (eg: IDR_MAINFRM_SPECIAL).

It's easy enough to provide conditional menus for my views, since I can just specify the appropriate menu id when I create the MultiDocTemplates. But how do I switch the mainframe window's menu?

A gentle nudge would greatly help this sleep deprived developer. Smile | :)

PS: Btw, I'm using Bruno's NewMenu[^]

/ravi

My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com.

Re: Change mainframe menu on startup

Neville Franks11-Sep-04 12:35

Neville Franks

11-Sep-04 12:35

I've just emailed a bit of code which may be of some help.

Neville Franks, Author of ED for Windows www.getsoft.com and coming soon: Surfulater www.surfulater.com

Re: Change mainframe menu on startup

Ravi Bhavnani11-Sep-04 12:57

Ravi Bhavnani

11-Sep-04 12:57

Many thanks, Neville!

/ravi

My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com

Calling VC COM DLL from C++

Peter Weyzen10-Sep-04 11:36

Peter Weyzen

10-Sep-04 11:36

Someone gave me this COM DLL to use in my project (co-worker).
The DLL is written in VB.

After doing the #import, I cannot compile. There are references to a "_ErrObjecPtr" (ErrObject smart ptr).

But the ErrObject doesn't resolve in C++...

Any clues out there?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />
Peter Weyzen<br />
Staff Engineer<br />
<A HREF="http://www.santacruznetworks.com">Santa Cruz Networks</A>

Highlight Selected Item in ListCtrl

Grahamfff10-Sep-04 10:59

Grahamfff

10-Sep-04 10:59

I have set the item in a ListCtrl via the statement:-

m_cListCtrl.SetItemState(m_nSelectItem, LVIS_SELECTED, LVIS_SELECTED | LVIS_FOCUSED);

But how do you arrange for the item to be shown as selected as if it was selected by a mouse click?

grahamfff

Re: Highlight Selected Item in ListCtrl

Ravi Bhavnani10-Sep-04 13:40

Ravi Bhavnani

10-Sep-04 13:40

m_cListCtrl.SetItemState
  (m_nSelectItem,
   LVIS_SELECTED | LVIS_FOCUSED,
   LVIS_SELECTED | LVIS_FOCUSED);

/ravi

My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com

Re: Highlight Selected Item in ListCtrl

Grahamfff11-Sep-04 8:33

Grahamfff

11-Sep-04 8:33

Did try your suggestion but nothing highlighted.

Are they any additional properties I need to set?

grahamfff

Re: Highlight Selected Item in ListCtrl

Grahamfff11-Sep-04 8:43

Grahamfff

11-Sep-04 8:43

I did also try and modify the CodeProject sample ListCtrlDemo as floows but no luck:-

void CListCtrlDemoDlg::OnItemSelect() <br />
{<br />
	// TODO: Add your control notification handler code here<br />
	UpdateData(TRUE);<br />
<br />
	// Select this item in the list control<br />
	int nCount = m_cListCtrl.GetItemCount();<br />
	if (m_nSelectItem >= nCount)<br />
	{<br />
		AfxMessageBox(_T("You entered an out of range index."));<br />
		m_nSelectItem = 0;<br />
	}<br />
	else<br />
	{<br />
		m_cListCtrl.EnsureVisible(m_nSelectItem, FALSE);<br />
		m_cListCtrl.SetItemState(m_nSelectItem, LVIS_SELECTED | LVIS_FOCUSED,   LVIS_SELECTED | LVIS_FOCUSED);<br />
	}<br />
	UpdateData(FALSE);<br />
<br />
}

grahamfff

Re: Highlight Selected Item in ListCtrl

Tyrus18211-Sep-04 8:50

Tyrus182

11-Sep-04 8:50

i am also having the same problem as this guy :P
thanks
Tyrus

Re: Highlight Selected Item in ListCtrl

Grahamfff11-Sep-04 9:18

Grahamfff

11-Sep-04 9:18

Just got it working:-

m_cDisplayList.SetItemState(m_nSelectedList, LVIS_DROPHILITED | LVIS_SELECTED, LVIS_DROPHILITED | LVIS_SELECTED);

grahamfff

Re: Highlight Selected Item in ListCtrl

Tyrus18211-Sep-04 12:47

Tyrus182

11-Sep-04 12:47

how do you make it multi select like a list box? instead of needing to hold ctrl

Re: Highlight Selected Item in ListCtrl

Grahamfff12-Sep-04 9:50

Grahamfff

12-Sep-04 9:50

Try

	<br />
// Initial extended style for the list control on this dialog<br />
DWORD dwStyle = m_cListCtrl.GetExtendedStyle();<br />
dwStyle |= LVS_EX_FULLROWSELECT;m_cListCtrl.SetExtendedStyle(dwStyle);

grahamfff

Highlight Selected Item in ListCtrl

Grahamfff10-Sep-04 10:59

Grahamfff

10-Sep-04 10:59

Re: Highlight Selected Item in ListCtrl

Ravi Bhavnani10-Sep-04 13:40

Ravi Bhavnani

10-Sep-04 13:40

See above.

/ravi

My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com

VC++ 6.0 compiler error with adding function with struct variable???

Vaclav10-Sep-04 9:55

Vaclav

10-Sep-04 9:55

Sorry for this post, but I cannot find anything about this in WWW.
I am adding a function with struct variable (using wizard function add) typing
Function(struct*) and I am getting this:
Function ($S1) in cpp and Function(struct *) in the h file.
Of course, the compiler complains about missing definition.
Is this a known bug?
Thanks Vaclav

Re: VC++ 6.0 compiler error with adding function with struct variable???

David Crow10-Sep-04 10:24

David Crow

10-Sep-04 10:24

Odd. What steps do I need to do in order to reproduce it?

"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen

Override Daylight Saving in DT Props

john john mackey10-Sep-04 9:55

john john mackey

10-Sep-04 9:55

hi, is there a programmatic way to override the setting you see in Date/Time Properties (Time Zone) for "Automatically adjust clock for daylight saving changes"?

What i notice, even with using GMT+0 Universal Coordinate Time time-zone, is that this setting still effects the representation of local time.

I am familiar with the TZ environment variable and also using this with the _tzset() function. Here is a summary of my findings:

TZ = GMT+0GMT<br />
Time Zone set to (GMT) Greenwich Mean Time: Dublin, Edinburgh, London<br />
CHECKED - Automatically adjust clock for daylight saving change<br />

calling _tzset() then calling the fns (yielded)

GetTimeZoneInformation(&tzInfo) ==> TIME_ZONE_STANDARD  and<br />
GetTimeZoneInformation(&tzInfo) ==> TIME_ZONE_DAYLIGHT<br />

for local date/times in respective daylight saving range. WHY????

Confused | :confused:

johnny

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