Re: really strange mysql result

From: Walter Roberson (roberson_at_ibd.nrc-cnrc.gc.ca)
Date: 03/14/05 

Date: 14 Mar 2005 13:21:23 GMT

In article <d142l3$3o8$1@news.hispeed.ch>,
Alexandre Jaquet <alexj@floor.ch> wrote:
:I can't understand why I got different result
:with the same sql query.
:(@members) = sqlSelect("clientlevel","user","userID=userID AND
:clientlevel <> ''");

Do you really want to be passing in the literal string userID as the userID ?
Has the variable userID previously been set by the code ? 

-- 
'ignorandus (Latin): "deserving not to be known"'
   -- Journal of Self-Referentialism

Relevant Pages

  • RE: Password
    ... but I have no experience in passing values from a ... Simpley create a WHERE statement that looks at UserID and Password ... "Dave Hawks" wrote: ... Dim Response As String ...
    (microsoft.public.access.formscoding)
  • Re: Best way to limit results to the first 10 recieved from database
    ... are recieved from the database. ... This is not a Perl solution, but why not use LIMIT 10 in your SQL query? ... (try just my userid to email me) ...
    (comp.lang.perl.misc)
  • Re: really strange mysql result
    ... Walter Roberson a écrit: ... >:with the same sql query. ... > Do you really want to be passing in the literal string userID as the userID? ...
    (comp.lang.perl.misc)
  • Re: Passing values between forms
    ... form, passing the UserID in, so I can do a table lookup in the second form. ... InitializeComponents //leave this as is. ...
    (microsoft.public.dotnet.framework.windowsforms)