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 > [EMAIL PROTECTED] > 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) _______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev
