Shoutbox

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.

---

I think it was a rhetorical question

quote:

---

Originally posted by -dt-
i used ADO

---

quote:

---

Originally posted by -dt-
ADODB.Connection'

---

Hmm... so you did...
* RaceProUK is blind

Thanks guys!

Any ideas why the Debug line gives me Type Mismatch?

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);
}

---

'results' is a Recordset, which isn't easily convertable to a string.

code:

---

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

---

should print off all records.

Thanks, works great!

Hey guys,

DB stuff workign great now. However, I notice on one of the strings I am pulling, it sticks like a small square at the end of it which then appears on my MSN PSM. Any idea what the little square represents and how I can remove or trim it?

Thanks

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

Can you print out the small square as an integer? Then it can be cross-referenced with an ASCII or Unicode chart to see what it's meant to be.

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

---

Yea I think you are right there, here is the debug below. How would I remove the break?

Thanks

CODE:

code:

---

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

---

DEBUG::

code:

---

Function called: OnEvent_Timer
BBE -
-Flash

---

Is there a solution to connect to a MySQL server through Jscript? Thank you...