|
I don't think that the SQL syntax is correct. Have you tested it before? Are you trying to select records where the CC field starts with N and in has the provided text inside it?
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
is it mr Marcdev?
<marquee scrollamount="1" scrolldelay="1" direction="up" height="10" step="1">--[![Jig | [Dance]](https://codeproject.freetls.fastly.net/script/Forums/Images/jig.gif) ]--
[My Current Status]
|
|
|
|
|
Touché!! 
... she said you are the perfect stranger she said baby let's keep it like this... Dire Straits
|
|
|
|
|
Your Sig said that! 
<marquee scrollamount="1" scrolldelay="1" direction="up" height="10" step="1">--[ ]--
[My Current Status]
Link2006 wrote:Let's take it outside of CP
Jeremy : Please don't.I would love to see this.I'm making the popcorn already.
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
