Problem with joins and where.

Igor Gomon giv at tlc.kherson.ua
Thu Nov 20 10:37:31 CST 2003


Hi Deane,
> > I'm getting a 1019 error on a query in the latest VServer. I was not 
> > getting this before I upgraded to the latest (I forget which I was 
> > last using I think a42)
> >
> > SELECT userDetails.firstName, userDetails.lastName FROM user, 
> > userDetails WHERE user.userID = userDetails.userID AND user.username = 
> > 'admin'  --> This works perfectly.
> > SELECT userDetails.firstName, userDetails.lastName FROM user, 
> > userDetails WHERE user.userID = userDetails.userID AND user.username = 
> > 'admi'  --> This throws back an error and kills my connection to the DB
> >
> > As you can see the only difference is in the WHERE clause. The first 
> > query has a match, the second doesn't because there is no user with 
> > the username 'admi'.
> >
> > Anyone have any ideas about this?
> This seems to be a very big problem. It seems VServer crashes each time 
> it returns no results from a join. Even if I don't stipulate things in 
> the WHERE.
I will check this now.

-- 
Best regards,
Igor Gomon
-------------------------------------------------------------
e-mail: giv_ua at inbox.ru
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina




More information about the Valentina mailing list