Two Plus Two Older Archives  

Go Back   Two Plus Two Older Archives > Tournament Poker > One-table Tournaments
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #26  
Old 09-02-2005, 02:46 PM
maddog2030 maddog2030 is offline
Senior Member
 
Join Date: Feb 2005
Location: Virginia Tech, $33s
Posts: 200
Default Re: NEW Spreadsheet: 2.4b w/ Daily Summary

I'm going to bring this back from the dead because I switched to PT PostgreSQL and noticed the start times were an hour off in the spreadsheet. Here is a quick fix if anyone wants it:

Change
<font class="small">Code:</font><hr /><pre>stSQLStatement.CommandText = "Select MIN(date_played), MAX(date_played)" &amp; _</pre><hr />

to
<font class="small">Code:</font><hr /><pre>
stSQLStatement.CommandText = "Select MIN(date_played) - INTERVAL '1 hours', MAX(date_played) - INTERVAL '1 hours'" &amp; _</pre><hr />
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.