View Single Post
  #8  
Old 11-03-2005, 11:44 PM
Guest
 
Posts: n/a
Default Re: Tracker Question

I get an error

"Unterminated string constant"
"line 37"
"char 60"

this is what i copy pasted

///// change settings here /////

var screen_name = '_dave_';

var rakebackdeal = 0.25;

var ptdb = 'ptrack8';

var start_date = '01-Sep-2005';

var end_date = '14-Sep-2005';

var bonuscleared = 100;

////////////////////////////////



///// Globals /////////

var db = new ActiveXObject("ADODB.Recordset");

var cstring = "Driver={Microsoft Access Driver(*.mdb)};DBQ="+ptdb+".mdb";

var totalhands = 0;

var sql = '';

var echoout = '';

//////////////////////



sql = "SELECT Count(game_players.game_id) AS Hands,"

+ " Sum(game.rake/ game.number_of_players)-"+bonuscleared+"

AS MGR,"

+ " MGR*"+rakebackdeal+" AS rakeback"

+ " FROM players INNER JOIN (game INNER JOIN game_players ON game.game_id ="

+ " game_players.game_id) ON players.player_id = game_players.player_id"

+ " WHERE (((game_players.hole_card_1) Is Not Null)"

+ " AND game.date_played >= #"+start_date+"#"

+ " AND game.date_played <= #"+end_date+"#"

+ " AND ((players.screen_name)='"+screen_name+"'));";

db.Open(sql, cstring, 1, 3);

echoout = "Hands:\t\t" + db(0) + "\nMGR:\t\t" + db(1) + "\nRakeback:\t" + db(2);

db.Close();



WScript.Echo(echoout);
Reply With Quote