Re: Simpe SQL query : WHERE field LIKE........ I'm lost !!! - C / C++ / MFC Discussion Boards

Antony M Kancidrowski6-Aug-04 0:21

6-Aug-04 0:21

Since the edit box will only live for the lifetime of the dialog then it is perfectly acceptable to do what you have done.

Ant.

I'm hard, yet soft.
I'm coloured, yet clear.
I'm fruity and sweet.
I'm jelly, what am I? Muse on it further, I shall return! - David Williams (Little Britain)

Re: Set font for window

rrrado6-Aug-04 0:27

rrrado

6-Aug-04 0:27

Thank you ! Rose | [Rose]

rrrado

Simpe SQL query : WHERE field LIKE........ I'm lost !!!

Danoo5-Aug-04 23:26

Danoo

5-Aug-04 23:26

Hi y'all
I really hope there an SQL guru out there, because I'm trying to do one of the simplest SQL queries but no luck

In my MFC-DAO application, I want to lauch this query:

SELECT * FROM Songs WHERE Title LIKE '%D'

And I cannot make it work at all... any other WHERE query works ok, but the LIKE queries just make me crazy...

Any ideas?

Regards
Daniel

Re: Simpe SQL query : WHERE field LIKE........ I'm lost !!!

Duncan Edwards Jones6-Aug-04 2:08

Duncan Edwards Jones

6-Aug-04 2:08

What wildcard does the databasae you are targetting use? I seem to recall that ms-access uses "*" whereas ansi-SQL uses "%"...

'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd

Re: Simpe SQL query : WHERE field LIKE........ I'm lost !!!

RChin6-Aug-04 2:08

RChin

6-Aug-04 2:08

Danoo wrote:
SELECT * FROM Songs WHERE Title LIKE '%D'

What do you want the statement to return ? This is a valid SQL statement, but I suspect your search string is formatted incorrectly.

If you want to search for all names beginning with "PAL", then you would use:

select * from [mytable] where [field] like 'PAL%'

It might be worth mentioning as well that I'm using ADO to format my queries. I think that DAO, and ACCESS uses '*' instead of '%'. (don't quote me on that though)

I Dream of Absolute Zero

Re: Simpe SQL query : WHERE field LIKE........ I'm lost !!!

David Crow6-Aug-04 2:18

David Crow

6-Aug-04 2:18

RChin wrote:
...ACCESS uses '*' instead of '%'. (don't quote me on that though)

You are correct. Quote away!

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

Re: Simpe SQL query : WHERE field LIKE........ I'm lost !!!

Danoo8-Aug-04 21:39

Danoo

8-Aug-04 21:39

Thanks guys, I didn't knew about the wildcard difference between * and %
Regards
Daniel

Re: Simpe SQL query : WHERE field LIKE........ I'm lost !!!

Looney Tunezez6-Aug-04 4:21

Looney Tunezez

6-Aug-04 4:21

Danoo wrote:
SELECT * FROM Songs WHERE Title LIKE '%D'

I am assuming that you want to retrieve all songs information whose titles END with the letter D.
Are you able to run this query through the query analyzer and what is the output?
Because the Query seems correct as far as syntax is concerned, or maybe i just need more caffeine

"Creating tomorrow's _legacy systems today.....
.... One ^CRISIS at a time!" -- Unknown

"If you build it....
.....BUGS will come!" -JB

this.Dispose();

"A _Bug is a piece of <sup> code </sup> that knows whatz its purpose"

How to use CSplitterWnd in non-matrix splitting?

Neeranjan5-Aug-04 23:17

Neeranjan

5-Aug-04 23:17

Hi All,

Using CSplitterWnd class I can split the window in row X column statically.
But I want to split the window as shown below:

|---------------------------|
|      |                    |
|------|                    |
|      |                    |
|      |--------------------|
|      |         |          |
|      |         |          |
|------|--------------------|

How can I do this?
Please, any one has the code for it? any clues?

Thanks & Regards,
Neeranjan

Re: How to use CSplitterWnd in non-matrix splitting?

David Crow6-Aug-04 2:25

David Crow

6-Aug-04 2:25

Neeranjan wrote:
Please, any one has the code for it?

Search MSDN for the GENSPLIT example. It has four panes.

Here is a CP article that has three panes.

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

How to debug this ???

rrrado5-Aug-04 23:06

rrrado

5-Aug-04 23:06

My dialog application is running more instances of itself
by calling CreateProcess() to run some tasks (no, i can't use threads).
Is there some way how to debug not only main process, but also child processes, to check memory leaks, see TRACE output, etc ?
Attaching another visual studio instances to all child processes is
lot of work and it can't catch events before before debugger attaching.
Any idea how to do this ?

Thanks !

rrrado

Re: How to debug this ???

jmkhael5-Aug-04 23:52

jmkhael

5-Aug-04 23:52

add the line

__asm int 3

to any intialization function in your process, it will attach the JIT debugger automatically.

Papa

while (TRUE)
Papa.WillLove ( Bebe ) ;

Re: How to debug this ???

rrrado6-Aug-04 0:32

rrrado

6-Aug-04 0:32

Thank you ! Rose | [Rose]

rrrado

SAFEARRAY in VC/VB/Scripting-Interface

peterchen5-Aug-04 22:32

peterchen

5-Aug-04 22:32

A question how typical Dispatch-Interfaces are designed:

Imagine you provide a Script client with a method returning a safearray, like this:
HRESULT GetData([out, retval] SAFEARRAY ** data)

Do you return a "complete copy", or can/should you return a reference to internal data held by the component?

we are here to help each other get through this thing, whatever it is Vonnegut jr.

sighist || Agile Programming | doxygen

Re: SAFEARRAY in VC/VB/Scripting-Interface

Antony M Kancidrowski6-Aug-04 0:25

Antony M Kancidrowski

6-Aug-04 0:25

I would have thought that you would need to return a copy.

I don't think you can access data across processes just by reference, some sort of accessor functions would be required.

Ant.

I'm hard, yet soft.
I'm coloured, yet clear.
I'm fruity and sweet.
I'm jelly, what am I? Muse on it further, I shall return! - David Williams (Little Britain)

Re: SAFEARRAY in VC/VB/Scripting-Interface

Milton Karimbekallil6-Aug-04 0:41

Milton Karimbekallil

6-Aug-04 0:41

Ofcourse it will be a reference to the actual memory location allocated from the com server.

A SAFEARRAY we create using by SafeArrayCreate or a BSTR we create by using SysAllocString are independent of the component which creates them. The client can manipulate the server allocated memory location. Remember in the case of a BSTR, the server calls SysAllocString and the client has the responsibility to call release by calling SysFreeString. Its like the server calls new and the client calls delete.

Or it is just like a com object we create inside a com server ( using CComObject ) and a cleint manipulates the properties of that server created object.

hope this helps..

rgds..mil10

Max limit in resource.h file of VC++

PrashantJ5-Aug-04 22:27

PrashantJ

5-Aug-04 22:27

Hi,

We specify the next step number for the resources, commands and control by the following.
_APS_NEXT_RESOURCE_VALUE
_APS_NEXT_COMMAND_VALUE
_APS_NEXT_CONTROL_VALUE

Do we have any way to restrict the numbers or specify the max limit.

eg. I want my resource to have command values from 1 to 100. So
#define _APS_NEXT_COMMAND_VALUE 1 // Next command number

Can I specify somewhere in the resource.h file saying 100 is the max if it goes beyond 100, throw an error?

Thanks,
Prashant.

Re: Max limit in resource.h file of VC++

David Crow6-Aug-04 2:29

David Crow

6-Aug-04 2:29

PrashantJ wrote:
Can I specify somewhere in the resource.h file saying 100 is the max if it goes beyond 100, throw an error?

No, just don't add more than 100 of that type of resource.

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

How to remove context menu created from taskbar ?

vgrigor15-Aug-04 21:38

vgrigor1

5-Aug-04 21:38

I create context menu, receiving OnRButtonDown
from taskbar.

But how to detect that user clicked on someone else
place of desktop ?
- To destroy menu.

Or is it possible to create menu that auto-destroying,
when loosed focus ?

thanks.
______________
I found solution in MSDN
search file sample: CQA0211.exe

With installing hooks, and subclassing system windows...

Does it the right way to implement hiding menu ?
(seems not adequate)

Re: How to remove context menu created from taskbar ?

Sivaji5-Aug-04 23:38

Sivaji

5-Aug-04 23:38

Ru using TrackpopUpMenu() function call or u r using u r
own customised function?

If u r using TrackPopupMenu() call once u chech hwnd
parameter.

Re: How to remove context menu created from taskbar ?

vgrigor16-Aug-04 7:10

vgrigor1

6-Aug-04 7:10

I USED TrackPopupMenu,
but menu does not disappear, if focus is loosed.

I asked - why it can happen?

Add a ICON to my file

Larsson5-Aug-04 21:07

Larsson

5-Aug-04 21:07

I need to ceate a new file *.net and I want that file to have a own icon is there anyone that now how do to this?

Fast help please.

Re: Add a ICON to my file

Archer2828-Aug-04 19:22

Archer282

8-Aug-04 19:22

you will have to edit the registery,
create a key HKEY_CLASSES_ROOT\.net
with a default value of "NETFILE"
then create the key HKEY_CLASSES_ROOT\NETFILE
to give it an icon
create a sub key named "DefaultIcon" and set its default value to the path of the icon you want to use
then to add menu items to it create another sub key under NETFILE named "shell" then create a sub key under it, with the menu item name then under that key create yet another sub key named "command" and set its default value to the command line you want to use for that menu item, for example

"HKEY_CLASSES_ROOT\txtfile\shell\open\command"=
"C:\WINDOWS\NOTEPAD.EXE %1"

if you arent familiar with editing the registery this will sound very confusing, but its really not, you might check out the articals on shell extensions, i dont know if they cover this or not

Re: Add a ICON to my file

Larsson8-Aug-04 20:11

Larsson

8-Aug-04 20:11

Thanks.

How to get Windows2000 OS Username and Password list ?

Anonymous5-Aug-04 20:52

Anonymous

5-Aug-04 20:52

Hi,

I am working on Project where i need to know the list of Windows2000 operating system's Users along with their Passwords. Also I want to know the rights or perticular user and want to use it to check for authorization purpose in my software. Any help plz..

My Function is like

void XYZ(int x, char b, char *UserName, char *Password, int UserId)
{
...
...
}
Now in this function I want to check if whether the passed UserName and Password exist on computer or not and if yes then what are the rights of that user...

Any one if able to do ...plz

MacCluny

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