[MarkLogic Dev General] mlsql : sql:execute and sql:params (string length problem)

2010-08-26 Thread Arnaud Roch
Hi, I want to insert to an SQL server database a large amount of data. My query is like INSERT INTO [dbo].[Table] ([Field1],[Field2],...,[FieldN]) VALUES (Value1,Value2,...,ValueN). I'd near 1750 character. My Xquery look like this : for $p in //Product return sql:execute( ?,

[MarkLogic Dev General] trigger issue

2010-08-26 Thread Arnaud Roch
Hi (again), I've another problem with a trigger. The trigger look like this : import module namespace trgr=http://marklogic.com/xdmp/triggers; at /MarkLogic/triggers.xqy; trgr:create-trigger(InsertSQL, Insert trigger for MLSQL to SQL Server, trgr:trigger-data-event(

[MarkLogic Dev General] question about calculating data from cts:element-values

2010-08-26 Thread helen chen
Hi there, I need to do a thing: In each article, there is a unique element called volume, it is a number value. I need to return a range list that divide the volume number into 100 and then make the list like: 1000-1099, 1100-1199, 1200-1299 This is to group the volume list into shorter

Re: [MarkLogic Dev General] Windows 7 Marklogic

2010-08-26 Thread spig
Are you trying to install as administrator? Is there a previous version already installed? -- Steve On Wed, Aug 25, 2010 at 9:22 PM, Pradeep Maddireddy pradeep.marklo...@gmail.com wrote: Hi..! When I try to install marklogic trial version on Windows 7. I get the following error

Re: [MarkLogic Dev General] trigger issue

2010-08-26 Thread Geert Josten
Hi Arnaud, In general the exception often is an indication that the xqy file could not be found or is inaccessible to the user that tries to execute it. Use the database explore function of CQ to check whether the xqy is really where you think it is, whether it has the right permissions and is

[MarkLogic Dev General] question about search

2010-08-26 Thread helen chen
Hello there, we have different kind of papers so our data are in 3 different DTDs. When I do search I need to do a search across all the 3 DTD data. For example I need to search an author's name smith in an area that keyword=aaa, I think maybe the option node will be like the following, but

Re: [MarkLogic Dev General] question about search

2010-08-26 Thread Micah Dubinko
Helen, You are exactly on the right track. (though the default joiner is OR in uppercase, not or) Search API doesn't (yet!) have an out-of-the-box way to combine these, and thus avoid the OR in your query. -m On Aug 26, 2010, at 6:49 AM, helen chen wrote: Hello there, we have different

Re: [MarkLogic Dev General] question about search

2010-08-26 Thread helen chen
Hi Micah, Thanks for your info. I'll continue with this way. Helen On Aug 26, 2010, at 1:01 PM, Micah Dubinko wrote: Helen, You are exactly on the right track. (though the default joiner is OR in uppercase, not or) Search API doesn't (yet!) have an out-of-the-box way to combine

Re: [MarkLogic Dev General] question about calculating data from cts:element-values

2010-08-26 Thread Michael Blakeley
You might try http://developer.marklogic.com/pubs/4.1/apidocs/Lexicons.html#cts:element-value-ranges -- Mike On 2010-08-26 06:13, helen chen wrote: Hi there, I need to do a thing: In each article, there is a unique element called volume, it is a number value. I need to return a range

Re: [MarkLogic Dev General] mlsql : sql:execute and sql:params (string length problem)

2010-08-26 Thread Jason Hunter
It looks like SQL Server just doesn't like the string you've constructed. You should print out the string you're sending and see if it works when directly typed to SQL Server. I bet it won't, and you might be able to see the problem there. I notice you're not escaping special characters so

[MarkLogic Dev General] Eclipse Errors

2010-08-26 Thread Neil
Hi, I am trying out the Eclipse plugin for MarkjLogic. The one problem I am getting is that errors are being reported for each of the library modules in my project. Specifically, that they cannot be evaluated. I get this error for all library modules, including existing ones that I know work

Re: [MarkLogic Dev General] Eclipse Errors

2010-08-26 Thread Sam Neth
This is unfortunately normal; the plugin tries to perform semantic validation on the module by mock executing it, but library modules can't be evaluated in that way. There is hope that a future version of the plugin will fix this, at least by skipping the evaluation, but I can't say when that

Re: [MarkLogic Dev General] Eclipse Errors

2010-08-26 Thread Mark Helmstetter
If you don't create the project as an XQuery Project but instead create it as some other type, such as a General Project or a Java Project, you can still get the XQuery syntax highlighting and checking, and outline view without those error messages. But then I don't think you will be able to

Re: [MarkLogic Dev General] ID/IDREF support in MLS

2010-08-26 Thread cOre dUmPeR
Excellent. Thank you Mary. /mario --- On Thu, 8/26/10, Mary Holstege mary.holst...@marklogic.com wrote: From: Mary Holstege mary.holst...@marklogic.com Subject: Re: [MarkLogic Dev General] ID/IDREF support in MLS To: General Mark Logic Developer Discussion general@developer.marklogic.com

Re: [MarkLogic Dev General] Windows 7 Marklogic

2010-08-26 Thread Pradeep Maddireddy
I was having a older version I uninstalled it and even deleted the marklogic folders. Thanks Pradeep Maddireddy On Thu, Aug 26, 2010 at 9:25 AM, spig s...@spig.net wrote: Are you trying to install as administrator? Is there a previous version already installed? -- Steve On Wed, Aug 25,

[MarkLogic Dev General] For cts:word-query() gurus: matching words with internal punctuation?

2010-08-26 Thread David Sewell
Problem: we need to create a full-text search on a text that may include various spellings of Hawaiian names. Properly spelled, many Hawaiian place names include the okina or glottal stop. Technically it is Unicode U+02BB but is often represented by a single curly quote, U+2018, or just ASCII

Re: [MarkLogic Dev General] For cts:word-query() gurus: matching words with internal punctuation?

2010-08-26 Thread Jason Hunter
Hi David, Unfortunately there's not yet an okina-insensitive query option. :) If you run a punctuation-insensitive search for the phrase O ahu it will match your three spellings (as well as O-ahu or O.ahu). It'll be good to have the fast phrases index enabled. To eliminate the (probably