Percy,

Two additional notes.

1. The reported error is a result of an error in CONSTRUCT's error
diagnostics, will fix that.

2. Note that the query selects everything from all graphs (and thus
makes inserts), whereas you probably intended to select from
<http://test.com/> only. To limit the selection, use

MODIFY <http://test.com/>
delete {...}
insert {...}
FROM <http://test.com/>
WHERE {...}

Best Regards,

Ivan Mikhailov
OpenLink Software
http://virtuoso.openlinksw.com

On Thu, 2012-01-12 at 10:55 -0200, Percy Enrique Rivera Salas wrote:
> Hi Hugh,
> 
> I provided a wrong example =(
> the right one is the following
> Virtuoso 22023 Error SR007: Function sprintf needs a string or UNAME or NULL 
> as argument 2, not an arg of type INTEGER (189)
> MODIFY <http://test.com/>
> delete
> {?s ?p ?o}
> insert
> {?s_new ?p ?o}
> where
> {
> {
>   SELECT
> 
> bif:replace(str(?s),"http://test.com/link","http://test.com/extra/link";) AS 
> ?s_new ?s ?p ?o
>   WHERE 
>   {?s ?p ?o
>   filter (regex (str(?s), "http://test.com/link";))
> }
> }
> }
> 
> Best Regards,
> 
> Percy
> 
> 2012/1/11 Hugh Williams <[email protected]>
>         Hi Percy,
>         
>         
>         In what way does it now work as the query itself runs on my
>         machine but doesn’t modify anything as I don’t have such data,
>         so are you getting and error or unexpected results are
>         occurring ? Please provide some output of what you are seeing
>         as not working ?
>         
>         Best Regards
>         Hugh Williams
>         Professional Services
>         OpenLink Software, Inc.      //
>          http://www.openlinksw.com/
>         10 Burlington Mall Road, Suite 265, Burlington MA 01803
>         Weblog   -- http://www.openlinksw.com/blogs/
>         LinkedIn -- http://www.linkedin.com/company/openlink-software/
>         Twitter  -- http://twitter.com/OpenLink
>         Google+  -- http://plus.google.com/100570109519069333827/
>         Facebook -- http://www.facebook.com/OpenLinkSoftware
>         Universal Data Access, Integration, and Management Technology
>         Providers
>         
>         On 11 Jan 2012, at 19:03, Percy Enrique Rivera Salas wrote:
>         
>         
>         > Dear All,
>         > 
>         > The following MODIFY Statement doesn't work properly, I
>         > think is because
>         > the variable ?url and ?new_url is an IRI (not a Literal)
>         > 
>         > MODIFY <http://test.com/>
>         > delete
>         > {?s ?p ?url}
>         > insert
>         > {?s ?p ?new_url}
>         > where
>         > {
>         > {
>         >   SELECT
>         >   ?s ?p
>         > 
> bif:replace(str(?url),"http://test.com/link","http://test.com/extra/link";) AS 
> ?new_url ?url
>         >   WHERE 
>         >   {?s ?p ?url
>         >   filter (regex (str(?url), "http://test.com/link";))
>         > }
>         > }
>         > }
>         > 
>         > Any idea to workaround?
>         > 
>         > Best Regards, 
>         > 
>         > Percy
>         > 
>         > 
> ------------------------------------------------------------------------------
>         > Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't
>         > need a complex
>         > infrastructure or vast IT resources to deliver seamless,
>         > secure access to
>         > virtual desktops. With this all-in-one solution, easily
>         > deploy virtual 
>         > desktops for less than the cost of PCs and save 60% on VDI
>         > infrastructure 
>         > costs. Try it free!
>         > 
> http://p.sf.net/sfu/Citrix-VDIinabox_______________________________________________
>         > Virtuoso-users mailing list
>         > [email protected]
>         > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>         
>         
> 
> ------------------------------------------------------------------------------
> RSA(R) Conference 2012
> Mar 27 - Feb 2
> Save $400 by Jan. 27
> Register now!
> http://p.sf.net/sfu/rsa-sfdev2dev2
> _______________________________________________ Virtuoso-users mailing list 
> [email protected] 
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users



Reply via email to