Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan SQL : Discussion :

Re: Finding more than "own" records on searches

Feb 6, 2001, 2:27 PM
Alex
Administrator (9387 posts)
Feb 6, 2001, 2:27 PM
Views: 3765
Shortcut
Quote Reply
Re: Finding more than "own" records on searches In reply to
Hi,

Ack, I think the bracketing changed in mysql as this used to work. However, a proper solution fix is to edit line 540 in db.cgi and change

$where .= qq! AND
$auth_user_field = $userid_q!;

to:

$where = qq! ($where) AND
$auth_user_field = $userid_q!;

Let me know if you have any problems with this.

Cheers,

Alex

--
Gossamer Threads Inc.
Subject Author Views Date
Thread Finding more than "own" records on searches msmoore 3904 Feb 4, 2001, 2:44 PM
Thread Re: Finding more than "own" records on searches 		msmoore 3793 Feb 5, 2001, 9:18 PM
Post Re: Finding more than "own" records on searches 		Katana Man 3766 Feb 5, 2001, 10:22 PM
Thread Re: Finding more than "own" records on searches 		Alex 3765 Feb 6, 2001, 2:27 PM
Post Re: Finding more than "own" records on searches 		msmoore 3759 Feb 6, 2001, 3:11 PM
Post Re: Finding more than "own" records on searches 		Katana Man 3784 Feb 6, 2001, 3:55 PM
Post Re: Finding more than "own" records on searches 		Katana Man 3725 Feb 15, 2001, 8:44 AM