Messenger Plus! Live - the Windows Live Messenger Extension

IP Address: Logged

IP Address: Logged

quote:

---

Originally posted by Nathan
I think he means he wants to call a database for data, and a password field(maybe) to login to it.
If you see what i mean

---

IP Address: Logged

IP Address: Logged

IP Address: Logged

IP Address: Logged

code:

---

var Shell = new ActiveXObject("WScript.Shell");
var MyActiveXObject = new ActiveXObject('RSP2MusicDLL.clsRSP2Music');
Shell.RegRead(MsgPlus.ScriptRegPath + "RSPpath");
var path = Shell.RegRead(MsgPlus.ScriptRegPath + "RSPpath");
var start = Shell.RegRead(MsgPlus.ScriptRegPath + "RSPenable");

if(start == -1)
{
MyActiveXObject.SetPath(path);
MsgPlus.AddTimer("RefreshTimer", 2000);
}

---

code:

---

Dim DB As Database
Dim RS As Recordset

---

code:

---

Public Sub SetPath(strPath As String)
'Setup database settings
Set DB = OpenDatabase(strPath)
Set RS = DB.OpenRecordset("SELECT * FROM OnAir ORDER BY FullName ", dbOpenDynaset)
End Sub

---

code:

---

var RSPArtist = MyActiveXObject.GetRSPArtist();

---

IP Address: Logged

code:

---

var db = new ActiveXObject('ADODB.Connection');
var dbPath = "C:\\Program Files\\Messenger Plus! Live\\Scripts\\test\\db1.mdb";
db.open("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" + dbPath +";DefaultDir=;UID=;PWD=;");

var results = db.Execute("SELECT * FROM xxx");

var xxx = resultsToArray(results);

for(var i=0;i<xxx.length;i++){
Debug.Trace("Row: " + i);
for(x in xxx[i]){
Debug.Trace(x + " : " + xxx[i][x]);
}
}

db.close();


function resultsToArray(result){
var res = new Array();
while(!result.EOF){
var row = {};
for(var enume = new Enumerator(result.Fields);!enume.atEnd();enume.moveNext()){
row[enume.item().name] = enume.item().value;
}
res.push(row);
result.MoveNext();
}
return res;
}

---

IP Address: Logged

quote:

---

Originally posted by RaceProUK

quote:

---

Originally posted by -dt-
so why not use COM to open it in jscript

---

The other possibility is ADO, which can be used directly in JScript, and is compatible with more database types than just Access.

---

IP Address: Logged

quote:

---

Originally posted by RaceProUK

quote:

---

Originally posted by -dt-
so why not use COM to open it in jscript

---

The other possibility is ADO, which can be used directly in JScript, and is compatible with more database types than just Access.

---

[Jatonian Life]

IP Address: Logged

quote:

---

Originally posted by -dt-
i used ADO

---

quote:

---

Originally posted by -dt-
ADODB.Connection'

---

IP Address: Logged

code:

---

function OnEvent_Initialize(MessengerStart)
{
var db = new ActiveXObject('ADODB.Connection');
var dbPath = "C:\\DB\\DB.mdb";
db.Open("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" + dbPath +";DefaultDir=;UID=;PWD=;");

var results = db.Execute("SELECT * FROM OnAir ORDER BY FullName");
Debug.Trace(results);
}

---

IP Address: Logged

code:

---

while (!results.EOF) {
    Debug.Trace(results.GetString());
    results.MoveNext();
}

---

IP Address: Logged

IP Address: Logged

IP Address: Logged

IP Address: Logged

IP Address: Logged

quote:

---

Originally posted by cloudhunter
Perhaps the small square could be a line break? Or an "end of field"? To find out what the little square is, output it to the debug console using debug.trace. Then you can use regexp to strip it out.

Cloudy

---

code:

---

Debug.Trace(Artist + "-" + Title);

---

code:

---

Function called: OnEvent_Timer
BBE -
-Flash

---

IP Address: Logged