--
You received this message because you are subscribed to the Google Groups "Railo" group.
To post to this group, send email to ra...@googlegroups.com.
To unsubscribe from this group, send email to railo+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/railo?hl=en.
Viele Grüße,
Martin Sauer
maybe the CRLF is not copied correctly via clipboard, so please try this:
<cfsavecontent variable="pg">
query('test':['<cfoutput>#chr(10)#</cfoutput>abc<cfoutput>#chr(10)#</cfoutput>'])
</cfsavecontent>
<cfset t=evaluate(pg)>
<cfquery name="t1" dbtype="query">
select * from t where test like '%abc%'
</cfquery>
<cfdump var="#t1#">
Viele Grüße,
Martin Sauer
Todd Rafferty schrieb:
> Your test query in this email works fine for me.
>
> ~Todd Rafferty ** Volunteer Railo Open Source Community Manager **
> http://getrailo.org/
>
> On Mon, Nov 30, 2009 at 2:39 AM, Martin Sauer <cf...@pro-int-pro.de
> <mailto:cf...@pro-int-pro.de>> wrote:
>
> Hallo,
>
> if having CRLF in a text-column, like it usually is when getting mails
> per CFPOP, querying this column with LIKE '%abc%' fails (no records
> found).
>
> <cfsavecontent variable="pg">
> query('test':['abc'])
> </cfsavecontent>
>
> <cfset t=evaluate(pg)>
>
> <cfquery name="t1" dbtype="query">
> select * from t where test like '%abc%'
> </cfquery>
> <cfdump var="#t1#">
>
> with Railo 3.1.2.001 on WinXPPro
>
> Viele Grüße,
> Martin Sauer
--
You received this message because you are subscribed to the Google Groups "Railo" group.
To post to this group, send email to ra...@googlegroups.com.
To unsubscribe from this group, send email to railo+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/railo?hl=en.
-- Michael Offner-Streit CTO Railo Technologies GmbH michael...@railo.ch www.getrailo.com Mailing List (english): http://groups.yahoo.com/group/railo_talk/ Mailing List (german): http://de.groups.yahoo.com/group/railo/ Linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 Issue Tracker: http://jira.jboss.org/jira/browse/RAILO Blog: http://www.railo-technologies.com/blog