great.... i like this script...
but i cant connect to my mysql server (at datacenter).
** but i can connect by using MySQLControlCenter...
here the script :-
alias MySQL.get.login {
.comopen MySQL.Database ADODB.Connection
;==========================
;if i'm use this... i cant connect...
var %Connection.String = $+( $&
DRIVER={MySQL ODBC 3.51 Driver};, $&
SERVER=localhost;, $&
PORT=3306;, $&
DATABASE=mydb;, $&
USER=root;, $&
PASSWORD=pass;, $&
OPTION=3;, $&
)
;==================end========
;===================
;but if i change it to :-
var %Connection.String = Provider=MySQLProv;Data Source=mydb;Server=localhost;User ID=root;Password=pass
;=================end=======
.echo -q aa $com(MySQL.Database, Open, 1, *bstr, %Connection.String)
.comopen RecordsetObject ADODB.Recordset
var %SQL = SELECT account_id FROM login WHERE userid = ' $+ $1 $+ ';
.echo -q $com(RecordsetObject, Open, 1, *bstr, %SQL, dispatch, MySQL.Database)
.echo -q $com(RecordsetObject, Collect, 2, i4, 0)
var %Name = $com(RecordsetObject).result
.echo -q $com(RecordsetObject, Collect, 2, i4, 1)
var %Name = %Name $com(RecordsetObject).result
if ($isid) return %Name %Gender
else {
echo -gaitc info * $1 is %Name
.comclose RecordsetObject
.comclose MySQL.Database
.hadd -m tmp $1 %Name
}
}
any idea?
