-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dave Sinclair wrote:
Hi,
Their isnt' a backup.....
So I'm having problems with:
postauth_query = "INSERT INTO ${authcheck_table} VALUES (NULL,'%{User-Name}','Password', '==', '%{User-Password:-Chap-Password}');" postauth_query = "INSERT INTO ${usergroup_table} values ('%{User-Name}','Dynamic','');"
I want BOTH SQL statements to insert data. At present the first INSERT runs, but the second one doesn't. I cant seem to sort out how to do in unlang.
help ?? thanks It's possible in the current GIT stable branch, i.e. you can use rlm_sql xlat to do insert queries and it'll expand to the number of rows inserted, or a null string ('') on error. You could also theoretically wrap the two statements together as a transaction (depending on what DB you were using).
Arran -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAknFHTsACgkQcaklux5oVKJvvQCcDmVMvdQsFX1uPg95ZsjEjiKH IasAn1wEDiAPHTi79MNkMTuzGS7hN2pA =usyd -----END PGP SIGNATURE-----