[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