Forum OpenACS Q&A: Response to GetRow Called outside fetch Loop?

Collapse
Posted by Chris Hardy on
Well, Since I've been working out bugs, I've got Crazy Debug logging going on, So here's The SQL it executes as well..
[29/Aug/2000:22:57:40][15121.11268][-sched:93-] Notice: spam user class query: select email_type,  users.approved_date, users.approving_note, users.approving_user, users.banned_date, users.banning_note, users.banning_user, users.bio, users.converted_p, users.crm_state, users.crm_state_entered_date, users.deleted_date, users.deleting_note, users.deleting_user, users.email, users.email_bouncing_p, users.email_verified_date, users.first_names, users.last_name, users.last_visit, users.lob, users.n_sessions, users.on_vacation_until, users.password, users.portrait_client_file_name, users.portrait_comment, users.portrait_file_extension, users.portrait_file_type, users.portrait_original_height, users.portrait_original_width, users.portrait_thumbnail_height, users.portrait_thumbnail_width, users.portrait_upload_date, users.priv_email, users.priv_name, users.registration_date, users.registration_ip, users.rejected_date, users.rejecting_note, users.rejecting_user, users.screen_name, users.second_to_last_visit, users.url, users.user_id, users.user_state from users_spammable users
where ad_group_member_p(users.user_id, 8) = 't'
                
        order by users.user_id
I've also added a ns_log Debug That grabs the $db and $selection variables for that query.. Though I'm scratching my head about it.. Here's the output.
29/Aug/2000:22:57:40][15121.11268][-sched:93-] Debug: db = nsdb0 selection = t28