U++ framework: U++ SQL » How to use Like() with SqlArray

Home » U++ Library support » U++ SQL » How to use Like() with SqlArray

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: How to use Like() with SqlArray [message #4131 is a reply to message #4129]

Mon, 24 July 2006 08:59

zsolt
Messages: 702
Registered: December 2005
Location: Budapest, Hungary

Contributor

Thanks, you are right.
I have changed Like() in Sqlexp.cpp from

SqlBool Like(const SqlVal& a, const SqlVal& b) {
	int sqld = GetSqlDialect(a, b);
	return SqlBool(a, sqld == SQLD_MYSQL || sqld == SQLD_SQLITE3 ? " like binary " : " like ", b, SqlS::COMP);
}

SqlBool Like(const SqlVal& a, const SqlVal& b) {
	int sqld = GetSqlDialect(a, b);
	return SqlBool(a, sqld == SQLD_MYSQL ? " like binary " : " like ", b, SqlS::COMP);
}

and now it is working correcly. I have no idea why that "binary" was in sources. I tested "like binary" directly in sqlite and it produces an error. So this was a bug, I think.

Report message to a moderator

[Message index]

		How to use Like() with SqlArray By: zsolt on Mon, 24 July 2006 00:20
		Re: How to use Like() with SqlArray By: mirek on Mon, 24 July 2006 01:52
		Re: How to use Like() with SqlArray By: zsolt on Mon, 24 July 2006 08:59
		Re: How to use Like() with SqlArray By: unodgs on Mon, 24 July 2006 09:49
		Re: How to use Like() with SqlArray By: unodgs on Mon, 24 July 2006 09:55
		Re: How to use Like() with SqlArray By: mirek on Mon, 24 July 2006 11:21
		Re: How to use Like() with SqlArray By: unodgs on Mon, 24 July 2006 12:39

Previous Topic:	sqlite3 compile problems on fresh install
Next Topic:	sqlite3 plugin documentation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed May 06 22:06:13 GMT+2 2026

Total time taken to generate the page: 0.00683 seconds