|
Hi,
I am trying to use bellow SQL in VC++ but when the I run it does not read the % which will not gave me the correct results:
SELECT * FROM ABC WHERE (CC LIKE N'%'"+ txt +"'%')
I looked on the net for similar situation but all use the text it self not variable (txt is CString), any suggestions to solve this.
Thanks and Best Regards,
Rasha
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
