Ey again crazy

Not working,

If I’m using this one here:

Code:
var %SQL = SELECT * FROM news ORDER BY id DESC LIMIT 1;


Then there come nothing from the database?
It wills se like this:

••• loader script, vent venligst - [a]NotNice •••
••• Her er sidste nyt: •••
••• Dato:-> •••
••• Skrevet af:-> •••
••• Nyheden:-> •••
••• Læs mere på:-> •••

Here is it only the texts I’m writhing in the script there are to see?

The full script look like this:

Code:
on *:text:!news*:#: {

/MySQL.Getnewsdata
} 

alias mysql.getnewsData {

notice $nick   15• 14• 7• 14 loader script, vent venligst - $nick      15• 14• 7• 1

.comopen mysql.Database ADODB.Connection

var %Connection.String = $+( $&
DRIVER={mysql ODBC 3.51 Driver};, $& 
SERVER=SERVERIP;, $& 
PORT=3306;, $& 
DATABASE=mydatabasename;, $& 
USER=MYUSER;, $& 
PASSWORD=MYPASS;, $& 
OPTION=3;, $& 
)

.echo -q $com(mysql.Database, Open, 1, *bstr, %Connection.String)
.comopen RecordsetObject ADODB.Recordset

var %SQL = SELECT * FROM news;

.echo -q $com(RecordsetObject, Open, 1, *bstr, %SQL, dispatch, mysql.Database, int, 2, int, 3, int, 1) 
.echo -q $com(RecordsetObject, Collect, 2, i4, 0)
.echo -q $com(RecordsetObject, Collect, 2, i4, 1)

var %date = %date $com(RecordsetObject).result
.echo -q $com(RecordsetObject, Collect, 2, i4, 2)

var %by = %by $com(RecordsetObject).result
.echo -q $com(RecordsetObject, Collect, 2, i4, 3)

var %news = %news $com(RecordsetObject).result
.echo -q $com(RecordsetObject, Collect, 2, i4, 4)

else echo -gaitc info * 
notice $nick   15• 14• 7• 14    Her er sidste nyt:    15• 14• 7• 14
notice $nick   15• 14• 7• 14  Dato:->  %date    15• 14• 7• 14
notice $nick   15• 14• 7• 14  Skrevet af:->  %by      15• 14• 7• 14
notice $nick   15• 14• 7• 14  Nyheden:->  %news    15• 14• 7• 14
notice $nick   15• 14• 7• 14  Læs mere på:->  %Link     15• 14• 7• 14

.comclose RecordsetObject
.comclose mysql.Database
}


I’m only try the code were:
// var %SQL = SELECT * FROM news ORDER BY id DESC LIMIT 1; \\

Because I’m not sure I’m understand how to do on the other way, were you use:
// $com(RecordsetObject, MoveLast, 1) \\


IS there some where I’m cut read more about “using” script code/sql to IRC or??

Taks /notnice
laugh