On Mon, Jun 15, 2009 at 9:28 PM, Brian Maso<http://x-query.com/mailman/listinfo/talk> wrote: > Wouldn’t it be great to use XQuery to access or modify relational data AND > XML data instead of SQL/XML? I’m sure there are a few SQL/XML enthusiasts > out there, but XQuery just makes so much more sense in my brain that > equivalent SQL. Having no influence other than my persuasive voice, I really > wish someone would boil the SQL ocean and magically switch the world to a > more XQuery-like language..

Read this article:
XQuery and databases – XQuery 2.0

Learning to use keyboard shortcuts is a double-edged sword.  On one hand, you get fed up with how hard it is to pull off a task and you feel a certain sense of triumph when you find a shorter way of doing a repetitive task.  On the other blade, becoming more efficient in what you do is part of the service to your employment contract.  You’re getting paid to perform a quality service as quickly as you can. So what then is “the most useful keyboard shortcut you never used”… Ctrl+A This is the shortcut for “select all”, which selects all the text in the current control or document.  It’s supported by most text editors, including fields on a web page, email editors, text editors, Office documents.  So let’s look at some sample uses… You’ve just written a nice comment on someone’s blog and you have that nagging doubt that the browser will get stuck and when you press Back your comment text will have disappeared.  Just before you hit the Post button, hit Ctrl+A and then Ctrl+C.  Now your text is sitting in memory in case everything goes wonky.

View original post here:
The most useful keyboard shortcut you never used

Our client required a modification to an existing web solution that displayed confidential results in html format, which could be printed from the results page.  The data was sensitive and was being forged, so we looked at adding a watermark.  This required moving across to using reporting rather than html, so we started building up a report structure. I was very pleased to find that Active Reports provided a WebViewer control, especially since it gave you the option of either displaying reports with an ActiveX option or with a Adobe Reader option.  My assumption was the latter required extra processing to convert a document to PDF first.  However, the ActiveX option requires the client user to have internet access to download the plugin, whereas the Adobe browser plugin can be installed from a downloadable installer that can be run on any PC

See the article here:
Active Reports: Displaying reports in a browser

I think you’ll be extraordinarily lucky to find a product that does this for you automatically, and efficiently. However it’s easy enough to check the condition by hand, with reasonable efficiency so long as you can access everything in the collection efficiently: let $ranges := for $doc in collection(…) return <range start="{$doc/doc/@start}" end="{$doc/doc/@end}"/> let $sortedRanges := <ranges>{ for $range in $ranges order by xs:integer($range/@start) return $range }</ranges> let $valid := empty($sortedRanges/range[xs:integer(@start) le xs:integer(preceding-sibling::range/@end)]) return $valid If scanning the collection is too expensive, then you can maintain a document "by hand" that contains the ranges redundantly. Regards, Michael Kay http://www

See the original post:
Define no-overlaps constraint based on two
integers(range index?)

This is our last public announcement regarding these separately-subscribed upcoming on classes … the early-bird period for lower registration prices ends next week for these in-depth and comprehensive hands-on training classes in the Los Angeles area, full-price registration available until June 3: Monday, June 8, 2009 to Friday, June 12, 2009 Practical Transformation Using XSLT , XQuery and XPath (5 days): http://www.CraneSoftwrights.com/training/ptuxq/ptuxqsyl.htm Monday, June 15, 2009 to Wednesday, June 17, 2009 Practical Formatting Using XSL-FO (3 days): http://www.CraneSoftwrights.com/training/pfux/pfuxsyl.htm Venue – Embassy Suites, Santa Ana Airport (1325 East Dyer Road) http://tinyurl.com/3b5rz7 Instructor/author: http://www.CraneSoftwrights.com/bio/gkholman.htm Registration: http://www.CraneSoftwrights.com/forms/register.php#form We recognize these are difficult economic times for many companies, but thankfully air fares are low

Read the rest here:
[Announce] XSLT/XQuery/XSL-FO hands-on courses June 2009 -
early-bird date approaching [XQuery-talk]

Hello All, Just released xprocxq, which is an experimental bootstrap implementation of W3C XProc Draft Specification, written in xquery of all things. xprocxq project information and download http://code.google.com/p/xprocxq/ xprocxq runs within eXist XML Database but the original prototype was developed using SAXON -SA. I am planning to support more XQuery processors in the future but will focus on making xprocxq as compliant as possible for eXist XML Database.

View post:
[ANN] xprocxq v0.6.74 BETA an XProc processor written
in XQuery

I’m happy to announce the 10.1.3.4.1 release of BI Publisher. This release rolls up bug fixes and enhancements since 10.1.3.4.0 to include the following: Support for Oracle WebLogic Server 10.3 Extended Support for Single Sign-On Providers Automatic Refresh of LDAP Cache Support for Siebel CRM Security Support for Secure File Transfer Protocol (SFTP) for Burst Reports Data Model Enhancements Web Service Data Set Type Enhancement: Specify Path to Data in SOAP Response SQL Query Data Set New Property: Use Default Schema Only Support for JNDI for Scheduler Connections Support for Expressions to Calculate Date Parameters RTF Template Enhancements Get List of BI Publisher Configuration Settings Enable Debug Mode for an RTF Template Number to Word Conversion in Report Output Remove Logos and Links from the BI Publisher Header Disable Access to Guest Page Updates to the BI Publisher Web Services For more details on this release please see: BI Publisher New Features Guide Release Notes Certification Information Note: something is wrong with the doc pages at the time of posting.

Originally posted here:
BI Publisher 10.1.3.4.1 Enhancements

I’m currently using Excel XP (2003) and having been learning some tricks to get data out of HTML tables into an Excel document.  I stumbled onto a cool feature last night… Go to the Data menu > Import External Data > New Web Query.  What you get is effectively a web browser that lets you enter a web page or even login and navigate to a page of your choice.  The browser places little icons next to the tables in the web page, allowing you to copy that data across to your Excel spreadsheet.  This option also comes up when you have justed tried to paste table data and get the little popup to do with formatting. Also, if you’re interested, I see that in Firefox you can CTRL-Click on individual table cells and copy out the data from just those cells.  I’m sure you’ve found like me that it can be tricky copying just the column or row of data you need from a web page, and this might help you one day

Original post:
Copying HTML Table Data into Excel

This week, request-log-analyzer obtained its 100th watcher on GitHub ! Bart and I have worked hard to make r-l-a a useful product for many people in various situations. The fact that more than 100 people are following the project’s progress and that at this moment, the gem has been download almost 200 times , shows that we are somewhat successful in this regard. Numbers like these, in combination with the e-mail messages we have received, motivate us to keep spending time on the project and keep improving it, even if these improvements are not directly useful for our own projects.

Read the original post:
Counter feedback

I want the XQuery to determine if the @maxOccurs attribute exists in an < xs:element > tag somewhere in the schema , and its value isn’t 1. If this is true, then, for all elements that have a @ref attribute in the schema (because we now know there’s at least one), the XQuery should get the string value of the element’s @ref attribute (what I wanted $name to be), along with the value of element’s @maxOccurs attribute (what i wanted $max to be), and lastly the string value of $max (what I wanted $index_max to be). Then finally, I just wanted to use these three values within an <xf:bind> tag that was to be returned.

Originally posted here:
returning elements without duplicates,
based on an XML schema and using an attribute as context node