SQL/Perl/ODBC/Weirdness

Question

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

oldgoat SSCrazy Points: 2344 More actions · Answer 1

SELECT * FROM tblUserAccessLevel l INNER JOIN tblUserContentArea c ON ((l.UserID = @user-id) AND (c.UserID = @user-id))

SELECT @testaccess = Userid FROM tbluseraccesslevel where Userid = @user-id

this I'm curious about. What is the top select for? It won't return anything to the PERL, as only the last one will.

Ed Ahlsen-Girard SSC Enthusiast Points: 114 More actions · Answer 2

SSC Enthusiast

Points: 114

January 14, 2005 at 8:46 am

Stupidity. 🙂

oldgoat SSCrazy Points: 2344 More actions · Answer 3

SSCrazy

Points: 2344

January 15, 2005 at 1:39 am

so, tell me. those error codes...

Ed Ahlsen-Girard SSC Enthusiast Points: 114 More actions · Answer 4

I decided to just call the offending sp with osql (which works in all respects). Thanks!