[lsc-changes] [Ldap Synchronization...] page changed: documentation:2.1:configuration:database:persistence

[webmaster]

A page in your DokuWiki was added or changed. Here are the details:

Date : 2013/01/10 17:04
Browser : Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:18.0) Gecko/20100101 Firefox/18.0
IP-Address : 88.173.78.196
Hostname : mne69-10-88-173-78-196.fbx.proxad.net
Old Revision: http://lsc-project.org/wiki/documentation/2.1/configuration/database/persistence?rev=1312445840
New Revision: http://lsc-project.org/wiki/documentation/2.1/configuration/database/persistence
Edit Summary: [Retrieving data with SQL queries]
User : coudot

@@ -62,11 +62,11 @@
WHERE id = #id#
</select>
</code>

- Note that the #id# is the SQL field returned by the first SQL query. So, if the first SQL query selects two field (//SELECT name, email//), then you can use these two field to retrieve a user (#name# and #email#).
-
+ <note tip>Note that the #id# is the SQL field returned by the first SQL query. So, if the first SQL query selects two field (//SELECT name, email//), then you can use these two field to retrieve a user (#name# and #email#).</note>

+ <note important>The #xxx# field must be in lowercase.</note>
==== Attributes mapping ====

This step is optional. If you don't want to use the syntax //SELECT field AS attribute ...//, use this. Otherwise, skip this section.