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] <javascript:>> > 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] <javascript:>. >> 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]. For more options, visit https://groups.google.com/d/optout.
