literate-perfunctory
Poker Software
Page 29 of 29 FirstFirst ... 19272829
Results 281 to 288 of 288
  1. #281
    Junior Member
    Join Date
    Apr 2018
    Posts
    5

    Default

    I can successfully execute a query if I include a where clause with GameNumber. If I remove the where clause I get a response "No Query Processor Found".

    In the HM2 API doc it also indicates:
    8. Querying for Hand Histories
    It it is possible you may need to retrieve the raw hand history for a specific hand to perform custom computation. HMQL provides a very basic mechanism for the retrieval of the original hand history:

    select * from handhistories where GameNumberString="5563124333"


    It doesn't seem to include any example where multiple hand histories are fetched. Can you successfully retrieve multiple hand histories using a query with limit? Thanks again for any help!

  2. #282
    HM2! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    18,396

    Default

    What is the exact query you are using so we can test it.
    Regards udbrky (Chris)

  3. #283
    Junior Member
    Join Date
    Apr 2018
    Posts
    5

    Default

    Quote Originally Posted by udbrky View Post
    What is the exact query you are using so we can test it.
    select * from handhistories order by GameNumber desc limit 5

  4. #284
    HM2! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    18,396

    Default

    What if you do

    Select * from handhistories limit 5
    Regards udbrky (Chris)

  5. #285
    Junior Member
    Join Date
    Apr 2018
    Posts
    5

    Default

    Quote Originally Posted by udbrky View Post
    What if you do

    Select * from handhistories limit 5
    no it's not working... and I was hoping to get the 5 most recent hands, so sorting by either GameNumber desc or some recent TimeStamp would be helpful

  6. #286
    HM2! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    18,396

    Default

    I will take a look at it and ask our API staff.
    Regards udbrky (Chris)

  7. #287
    Junior Member
    Join Date
    Jul 2018
    Posts
    7

    Default

    Hello, can I install and leave the HM2 folders in the partition where the system is not? Because my / C: it only has 120gb and I do not want to leave neither the program nor the hands there. How do I do that?

  8. #288
    HM2! udbrky's Avatar
    Join Date
    Jul 2008
    Posts
    18,396

    Default

    You can. You want the database files in the fastest drive though.

    The parent folder and postgres/data folders are the important files. The program files are pretty small.

    Move all media, documents, backups, and c:\hm2archive to the second drives as well.
    Regards udbrky (Chris)

Page 29 of 29 FirstFirst ... 19272829

Similar Threads

  1. Replies: 1
    Last Post: 12-21-2011, 09:00 AM
  2. How Do I Import hands from holdem manager 1 to holdem manager 2?
    By rockstarhobbo in forum General Support
    Replies: 5
    Last Post: 11-11-2011, 08:20 AM
  3. Replies: 1
    Last Post: 11-08-2011, 07:06 PM
  4. Replies: 1
    Last Post: 08-30-2011, 09:58 PM
  5. Latest version of Holdem Manager killed Holdem Manager
    By TLXLM in forum Manager General
    Replies: 2
    Last Post: 09-06-2008, 11:09 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •