|
I think your statement has problem if you run this line in Query Analyzer whats happen it work or no
|
|
|
|
|
it will work fine in query analyzer but in VC code it does not recognize the % singe so the result will look like this:
SELECT * FROM ABC WHERE (CC IKE N'miss')
NOT
SELECT * FROM ABC WHERE (CC IKE N'%miss%')
where miss is the value of the variable txt
tahnx
|
|
|
|
|
Can you provide the piece of VC++ code where there's the SQL statement and not just the SQL itself.
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
kindly find the function:
CString CGamesDlg::SetFlagCorrect(CString sms,CString level,CString Lang)
{
CString strConnect,sqlS,mDate,mQuestion,mContest,mTime,mLDate;
CDatabase db_mssqlx;
CTime T=CTime::GetCurrentTime();
mTime.Format("%02ld%02ld%02ld",T.GetHour(),T.GetMinute(),T.GetSecond());
mDate.Format("%ld%02ld%02ld",T.GetYear(),T.GetMonth(),T.GetDay());
mLDate.Format("%ld%02ld%02ld",T.GetYear(),T.GetMonth(),T.GetDay()-1);
CString xDT = mDate+mTime;
CRecordset *m_rec = new CRecordset ( &db_mssqlx ) ;
strConnect = _T(SQLConn);
sqlS="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'%"+ sms +"%')" ;
AddToLog("sqlS:"+sqlS);
BOOL F1=db_mssqlx.OpenEx(strConnect,CDatabase::openReadOnly | CDatabase::noOdbcDialog);
m_rec -> Open( CRecordset::snapshot, sqlS, CRecordset::none ) ;
int count = m_rec ->GetRecordCount() ;
if (count==0)
{
m_rec -> Close( ) ;
db_mssqlx.Close( ) ;
return "1";
}
else
{
m_rec -> Close( ) ;
db_mssqlx.Close( ) ;
return "0" ;
}
}
|
|
|
|
|
rasha2003 wrote: AddToLog("sqlS:"+sqlS);
Using the debugger, what does sqlS look like at this point?
"Talent without discipline is like an octopus on roller skates. There's plenty of movement, but you never know if it's going to be forward, backwards, or sideways." - H. Jackson Brown, Jr.
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
it will look like
SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'أ')
|
|
|
|
|
rasha2003 wrote: sqlS="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'%"+ sms +"%')" ;
If you are trying to search the records that starts with N and that contains the sms text inside, it would have to be the N inside the quotes:
="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE 'N%"+ sms +"%')"
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
Hi Marc ...
i try that it generat the sql as bellow
SELECT * FROM Games_Qst WHERE (AnsTxt LIKE 'Nأ')
mean still not reading the %
|
|
|
|
|
I've also tried to debug it and the % appears ...
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
try this one
sqlS="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'%باب%')" ;
or make sms value anything else than English
|
|
|
|
|
I can't Does it work to you if you use English text?
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
even with English its not reading the value, send me the sql u used and worked with u pleas
|
|
|
|
|
It's yours !!! I haven't changed a word. I've ddebuged and stopped it at
sqlS="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'%"+ sms +"%')" ;<br />
AddToLog("sqlS:"+sqlS);<br /> and it has the %s
Marc Soleda
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
rasha2003 wrote: mean still not reading the %
What exactly does "not reading the %" mean? Are you trying to select rows where the AnsTxt column begins with N? Is this with Access, Microsoft SQL, or MySQL?
"Talent without discipline is like an octopus on roller skates. There's plenty of movement, but you never know if it's going to be forward, backwards, or sideways." - H. Jackson Brown, Jr.
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
Hi David
I am using MS SQL Server 2000, and the N for Unicode since I am comparing Arabic alphabet (not English), I am trying to select records that matched any of the characters in the CString variable sms as bellow
sqlS="SELECT * FROM Games_Qst WHERE (AnsTxt LIKE N'%باب%')" ;
where that value od sms will be "باب"
|
|
|
|
|
|
Hi SkyWalker,
Can you please check the new thread and give your opinion what could be the problem.
Thanks,
Gajendra
|
|
|
|
|
|
This is an answer to upper posting, I do not know what happened to that message displaying
SkyWalker
|
|
|
|
|
Hi SkyWalker,
I reposted the question with more details. Check the new thread. (you are right the upper one is same)
Thanks for your help.
Gaj
|
|
|
|
|
Hello Everybody
I have a Dialog base project in that we have removed the minimize and maximize button that comes by default in the dialog box
Instead we added a button of min and max and loaded a bitmap
When we minimize it it goes in the system tray
This is fine
But when we press the Show Desktop(or Windows Logo+ D) symbol in the quick lauch bar then it is not working properly
I am not able to find out which message is send to the dialogbox when the Show Desktop or Keyboard shortcut i.e. (Windows Logo+ D).
Could u please find out the message so that i could remove the flaw.
Thankin you in advance
Payal
|
|
|
|
|
It's a "Windows Explorer Command".
Search for "Quick Launch" folder on your computer, and you'll find it in there (among others).
SkyWalker
|
|
|
|
|
The problem as such is not that i know the exe i want to know which windows message is recieved by MY MY Dialog based application that forces it to minmize
as such Show desktop or Windows Logo +D would minimize all the window to the taskbar , But the thing is that i want to handle it differently
So if i could find out which message it sends to me
i.e. in terms of WM_.....
SO THAT I COULD OVERIDE IT
One more thing is that i am able to get the control of the first (indows Logo +D ) i.e. int the handler of
WM_SIZE IN THAT wparam= SIZE_MINIMZED
IT WORKS TOO but as such when i m pressing it the second time without doing any operation than i am not able to handle it
in WM_SIZE with Wparam= SIZE_MAXIMIZE
i don't know how but my application gets popup and is displayed in an unwanted manner.
Payal
|
|
|
|
|
SendMessage(GetDesktopWindow(), WM_ACTIVATE, 0x1, 0);
SetForegroundWindow(GetDesktopWindow());
SkyWalker
|
|
|
|
|
Mircea Puiu wrote: SendMessage(GetDesktopWindow(), WM_ACTIVATE, 0x1, 0);
SetForegroundWindow(GetDesktopWindow());
It's not Working, Mr. Puiu
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
Support CRY- Child Relief and You
|
|
|
|