<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1503077579332_20972" dir="ltr">before i go an do some operations. i need to know if the following will work?<br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_24458"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_24459">so I have this column:</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_21041"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22688">col1</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22825">23.33</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22689">23.46</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22824">12.33</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22701">10.33</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22690">23.546</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22700">23.1</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22691">1.33</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22692">100.33<br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22693"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22694">I want to run two queries</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22695"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22696">1. select all rows with 23 before decimal (not *23.*, just 23.*).</div><div id="yui_3_16_0_ym19_1_1503077579332_27847"><br></div><div id="yui_3_16_0_ym19_1_1503077579332_27846">my @foo = $schema</div> ->resultset('Test')<br id="yui_3_16_0_ym19_1_1503077579332_27815"> ->search<br id="yui_3_16_0_ym19_1_1503077579332_27816"> ({<br id="yui_3_16_0_ym19_1_1503077579332_27817"> col1 => { like => 23'.%'}<br id="yui_3_16_0_ym19_1_1503077579332_27818"> });<br id="yui_3_16_0_ym19_1_1503077579332_27819"> <br id="yui_3_16_0_ym19_1_1503077579332_27820"><div id="yui_3_16_0_ym19_1_1503077579332_27828">print "values @foo\n";</div><div id="yui_3_16_0_ym19_1_1503077579332_27831"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22823"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22865">I expect:</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22774">23.33</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22775">23.46</div>23.546<div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22779">23.1</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_24455"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22698">2. second i want to run query to select for given value after decimal.</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22811">my $foo_rs = $schema->resultset('Table')->search({<br id="yui_3_16_0_ym19_1_1503077579332_22812"> col1 => { like => 23.'%' }</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22813">});</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22814"><br id="yui_3_16_0_ym19_1_1503077579332_22815"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22816">I expect:</div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22842">23.33</div>12.33<div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_22845">10.33</div><div id="yui_3_16_0_ym19_1_1503077579332_31063">1.33</div><div id="yui_3_16_0_ym19_1_1503077579332_31071">100.33</div><div id="yui_3_16_0_ym19_1_1503077579332_31072"><br></div><div><br></div><div id="yui_3_16_0_ym19_1_1503077579332_31137"><br></div><div id="yui_3_16_0_ym19_1_1503077579332_31138">I get this error when i test:</div><div id="yui_3_16_0_ym19_1_1503077579332_31139"><br></div><div id="yui_3_16_0_ym19_1_1503077579332_31073" dir="ltr">$ ./test.pl<br id="yui_3_16_0_ym19_1_1503077579332_31088">String found where operator expected at ./test.pl line 26, near "23'.%'"<br id="yui_3_16_0_ym19_1_1503077579332_31089"> (Missing operator before '.%'?)<br id="yui_3_16_0_ym19_1_1503077579332_31090">Possible unintended interpolation of @foo in string at ./test.pl line 29.<br id="yui_3_16_0_ym19_1_1503077579332_31091">syntax error at ./test.pl line 26, near "23'.%'"<br id="yui_3_16_0_ym19_1_1503077579332_31092">Global symbol "@foo" requires explicit package name (did you forget to declare "my @foo"?) at ./test.pl line 29.<br id="yui_3_16_0_ym19_1_1503077579332_31093">Execution of ./test.pl aborted due to compilation errors.<br id="yui_3_16_0_ym19_1_1503077579332_31094"></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_31095"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_31141"><br></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_31142"><br></div></div></body></html>