Hello Lvc, Are you sure this is fixed? I'm using OrientDB 2.1.5 and I'm still running into the issue that named parameters for skip and limit are not working.
Thanks, Erik On Thursday, August 21, 2014 at 7:51:02 PM UTC+2, Lvc@ wrote: > > Hi, > This will be fixed in 2.1 (Snapshot on the end of October 2014) with the > new parser. > > Lvc@ > > ᐧ > > > On 21 August 2014 19:48, EZ <[email protected] <javascript:>> wrote: > >> Sorry to wake up an old old thread, but is there an estimate on when this >> will be added? >> >> >> On Monday, February 4, 2013 10:39:07 AM UTC-8, Lvc@ wrote: >> >>> Hi Thorsten, >>> parameter replacement doesn't work on SKIP and LIMIT yet. >>> >>> Lvc@ >>> >>> >>> >>> On 4 February 2013 19:28, Thorsten Marx <[email protected]> wrote: >>> >>>> Hello, >>>> >>>> I'm using Orientdb version 1.3.0 as embedded document store and facing >>>> some problems when using prepared statemens with paging: >>>> >>>> here is some simple statement i'm using: select * from locations SKIP >>>> :offset LIMIT :limit ORDER BY created >>>> >>>> I'm using it this way >>>> Map<String, Object> parameters = new HashMap<String, Object>(); >>>> parameters.put("offset", 10); >>>> parameters.put("limit", 10); >>>> OSQLSynchQuery<ODocument> synchQuery = new OSQLSynchQuery<ODocument>( >>>> query); >>>> List<ODocument> documents = db.command(synchQuery).execute(parameters); >>>> >>>> seems to be ok, when comparing with the documentation. >>>> but it throws the following exception: >>>> >>>> de.marx.web.base.api.exception.ServiceException: >>>> com.orientechnologies.orient.core.sql.OCommandSQLParsingException: >>>> Error on parsing command at position #32: Invalid SKIP value setted to >>>> ':OFFSET' but it should be a valid positive integer. Example: SKIP 10 >>>> Command: select * from location SKIP :offset LIMIT :limit ORDER BY >>>> created >>>> >>>> the some exception is throws when using ? syntax for prepared statemens. >>>> >>>> ?? >>>> >>>> kind regards >>>> Thorsten >>>> >>>> -- >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "OrientDB" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>>> >>>> >>> >>> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
