Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Tweaks to the FTS4 documentation. Add Bentley to the sponsor list on the front page. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
39b1d192560963b2d1d746589e08d89c |
| User & Date: | drh 2012-03-06 13:11:18 |
Context
|
2012-03-06
| ||
| 13:24 | Reduce the size of the Bentley logo from 600KB to about 8KB. check-in: 36e8f98b78 user: drh tags: trunk | |
| 13:11 | Tweaks to the FTS4 documentation. Add Bentley to the sponsor list on the front page. check-in: 39b1d19256 user: drh tags: trunk | |
|
2012-03-05
| ||
| 19:40 | Fix typos in the FTS4 languageid option documentation. Add entries to the 3.7.11 change log. check-in: eb26f05574 user: drh tags: trunk | |
Changes
Added images/foreignlogos/bentley.jpg.
cannot compute difference between binary files
Changes to pages/fts3.in.
1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 |
<codeblock>
SELECT * FROM t1 WHERE t1 MATCH 'abc' AND lid=5;
</codeblock>
<p>
It is not possible for a single FTS query to return rows with
different languageid values. The results of adding WHERE clauses
that use other operators (e.g. lid!=5, or lid<=5) are undefined.
<p>
If the content option is used along with the languageid option,
then the named languageid column must exist in the content= table
(subject to the usual rules - if a query never needs to read the
content table then this restriction does not apply).
|
| |
1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 |
<codeblock>
SELECT * FROM t1 WHERE t1 MATCH 'abc' AND lid=5;
</codeblock>
<p>
It is not possible for a single FTS query to return rows with
different languageid values. The results of adding WHERE clauses
that use other operators (e.g. lid!=5, or lid<=5) are undefined.
<p>
If the content option is used along with the languageid option,
then the named languageid column must exist in the content= table
(subject to the usual rules - if a query never needs to read the
content table then this restriction does not apply).
|
Changes to pages/index.in.
61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 |
<a href="http://www.nokia.com/">\
<img src="images/foreignlogos/nokia.gif" alt="nokia.com" border="0">\
</a></td><td>\
<a href="http://www.nokia.com/">Nokia</a> is the world leader in mobility,\
driving the transformation and growth of the converging internet and\
communications industries.</td></tr>'
count = 5
while( count>0 ){
i = Math.floor(Math.random()*5)
if( sponsor[i]!=null ){
document.write(sponsor[i])
sponsor[i] = null
count--
}
}
</script>
|
> > > > > > > | | |
61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 |
<a href="http://www.nokia.com/">\
<img src="images/foreignlogos/nokia.gif" alt="nokia.com" border="0">\
</a></td><td>\
<a href="http://www.nokia.com/">Nokia</a> is the world leader in mobility,\
driving the transformation and growth of the converging internet and\
communications industries.</td></tr>'
sponsor[5] = '<tr><td align="center">\
<a href="http://www.bentley.com/">\
<img src="images/foreignlogos/bentley.jpg" alt="bentley.com" border="0">\
</a></td><td>\
<a href="http://www.bentley.com/">Bentley</a> - Comprehensive software \
solutions for Sustaining Infrastructure.</td></tr>'
count = 6
while( count>0 ){
i = Math.floor(Math.random()*6)
if( sponsor[i]!=null ){
document.write(sponsor[i])
sponsor[i] = null
count--
}
}
</script>
|