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