Please replace the ??? with your data!

• Your URL: http://???
• The browser used: Firefox
• cforms version: 8.4.2
• Your Wordpress version: 2.5.1

[desc]:

Hello,

I have a form with (including 'page' and 'fieldset') 15 field_names. When I try to query the db to display the data in a table, I recently started getting this error:

"Can\\'t use players: The SELECT would examine more than MAX_JOIN_SIZE
rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET
SQL_MAX_JOIN_SIZE=# if the SELECT is okay"

My query string (simplified to save space):

$querystr = "
SELECT FN.sub_id, SEL.`sel`, FN.`First Name` , LN.`Last Name` , DOB.`dob`
FROM ( SELECT sub_id, field_val AS 'First Name'
FROM $wpdb->cformsdata
WHERE `field_name` = 'First Name'
)FN, ( SELECT sub_id, field_val AS 'Last Name'
FROM $wpdb->cformsdata
WHERE `field_name` = 'Last Name'
)LN, ( SELECT sub_id, field_val AS `Team`
FROM $wpdb->cformsdata
WHERE `field_name` = 'Team'
)TEAM, ( SELECT sub_id, field_val AS `dob`
FROM $wpdb->cformsdata
WHERE `field_name` = 'DOB'
)DOB
WHERE FN.sub_id = LN.sub_id
AND LN.sub_id = TEAM.sub_id
AND TEAM.sub_id = DOB.sub_id
AND TEAM.Team = 'Boys'
ORDER BY LN.`Last Name`
";

Can someone suggest a simpler approach to extracting the information for presentation on page?

Thanks for any ideas.

Basically, it makes a table of sub_id, and first name, a table of sub_id and last name, a table if sub_id and xxx…. then selects the values for all the sub_ids where field_name = "Team" and field_val = "Boys". Since I am not proficient at SQL, I'm sure there is a less expensive, more elegant way to do this.

Thanks for the pointers to the cforms source, that's where I was going to look next.

cb

• Your URL: local only
  
• The browser used: Firefox
• cforms version: 11.3
• Your Wordpress version: 2.9.1

i too have a similar problem, the cform tracking is and will only allow me to export so many records ie: only allow 60 days worth & not the entire ammount, ie: all year

so ive been trying to run this code localy on my 18mb wordpress database

using phpmyadmin, this piece of code was created from cb's snippet above.

There has to be an easier way in SQL to get the matchin records for each submission onto 1 recordset row,

??

any help guys would be great..

ps: Ive read through the source code for cforms many times and cant come to the conclusion on the query used to get the entire results which would then export as csv file…