Maximum Number of Query Results 1

[khuismangriffins]

Greetings all!

I'm trying to run a query through Goldmine to pull out data on all records with an e-mail address, and when I run the query, it only returns 10,000 results...no matter how many results it actually should have (should actually be around 100,000). Is there any way to adjust this number so that I can get maybe half the list (50,000 results)?

Any help would be greatly appreciated.

Kevin Huisman
Database Services Manager
Grand Rapids Griffins
AHL Affiliate of the Detroit Red Wings

 

[lisaharris]

In your GM.INI file, add

SQLQueryLimit=50000

Log back in to GoldMine and you'll get a max of 50K records returned. Without this limit, the default is 10,000.

 

[MIChad76]

Check out this post:

http://www.thegmblog.com/2007/07/what_to_do_if_your_sql_query_r.php

---
Chad Smith
michad76@gmail.com

Check out the GoldMine Blog at

http://www.thegmblog.com

MCP - Microsoft SQL Server
Crystal Reports Certified Professional
GoldMine Certified Professional
Microsoft CRM Certified Professional

 

[khuismangriffins]

Thank you for the linked web site. I'd been given the advice before about placing the SQLQuery line in an .ini file, but was originally told that it should be the gm.ini file, not the individual username.ini file.

It worked...I wish I would've had this info at the beginning of yesterday (would've made my life for that day easier), but thank you for your assistance...this'll make things much easier from here on out.