[JDEV] Changing database structure in xdb_sql
Bruce Heller
bheller at terravirtual.net
Fri Sep 20 10:06:09 CDT 2002
Hello. I wanted to use a slighty different database architecture with
xdb_sql, I modified the xdb_sql.xml according to the new layout of the
tables. But it doesn't work as it should.
For example the password changing was :
<!-- Authentication set query -->
<querydef name="auth-set">
<text>UPDATE users SET password = '$$p$$' WHERE username =
'$$username$$'</text>
<bindvar name="user">$$username$$</bindvar>
<bindvar name="password">$$p$$</bindvar>
</querydef>
And is now :
<!-- Authentication set query -->
<querydef name="auth-set">
<text>UPDATE users SET password = '$$p$$' WHERE jid =
'$$username$$'</text>
<bindvar name="user">$$username$$</bindvar>
<bindvar name="password">$$p$$</bindvar>
</querydef>
The only change here is that the username is now called "jid" in the
database... But it won't change the password right, it onyl returns "NULL"
into the database...
Also, I would like to know if it's possible to excecute 2 SQL query for a
single querydef ?
Thanks in advance !
--------------------------------
Bruce Heller
Ligne Directe: 01.47.66.55.64
Fax: 01.47.66.55.54
Standard: 01.47.66.55.50
--------------------------------
TERRA VIRTUAL
73, rue de Saussure
75017 PARIS
-------------------------------
More information about the JDev
mailing list