Hole card lookup values

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Re: Hole card lookup values

Postby js2002 » Wed Apr 16, 2014 7:47 am

This expression doesn't validate in stats:

"tourney_hand_player_statistics.id_holecard in (41,42)"

The comma is the problem. How do I escape it? I'vo got whole ranges, so I cant do this:
tourney_hand_player_statistics.id_holecard in (41) OR tourney_hand_player_statistics.id_holecard in (42)

In the logfiles an exp like this works: tourney_hand_player_statistics.id_holecard in (41,43,62,64,81,83,98,100,113,115,126,128,137,139,146,148,155), but not in stat column :-(
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Hole card lookup values

Postby kraada » Wed Apr 16, 2014 10:05 am

There is a known issue with commas in column definitions at this time and, sadly, there is no known workaround.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Hole card lookup values

Postby js2002 » Wed Apr 16, 2014 10:28 am

So is there a problem when I put 169 terms into a column?
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Hole card lookup values

Postby kraada » Wed Apr 16, 2014 11:01 am

The problem is, as you pointed out, the comma. As I said, there is no known workaround. I don't know off the top of my head if there is a maximum column size.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Hole card lookup values

Postby js2002 » Wed Apr 16, 2014 12:35 pm

If I use 169 term, I dont need any comma.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Hole card lookup values

Postby kraada » Wed Apr 16, 2014 2:28 pm

kraada wrote:I don't know off the top of my head if there is a maximum column size.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 10 guests

cron