[JDEV] Changing database structure in xdb_sql

[Justin Georgeson]

You created your database with jid instead of username, right? Did you 
create it manually or edit one of the sample configs and create off that?

Bruce Heller wrote:
> 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
> -------------------------------
> 
> _______________________________________________
> jdev mailing list
> jdev at jabber.org
> http://mailman.jabber.org/listinfo/jdev

-- 
Justin Georgeson
UnBound Technologies, Inc.
http://www.unboundtech.com
Main   713.329.9330
Fax    713.460.4051
Mobile 512.789.1962

5295 Hollister Road
Houston, TX 77040
Real Applications using Real Wireless Intelligence(tm)