error 8114 + all fields are empty in the where clause
-
Hi,
SQL Server 2000 (sp3a) Windows 2000 and IIS
With PROFILER I can notice error 8114 where all fields are empty in the where clause
Does IIS can be the problem ??.
Any idea ?
Thank you
Danny
SELECT * FROM Fiches, usagers
WHERE (
Unite LIKE '%%'
AND Cote1 LIKE '%%'
AND Cote2 LIKE '%%'
AND Cote3 LIKE '%%'
AND ((Du_an >= '' OR Au_an >= '') and ( Du_an <= '' OR Au_an <= '') )
AND Local LIKE '%%'
AND Boite LIKE '%%'
AND Etat LIKE '%%'
AND (libelle like '%%' or libelle2 like '%%' or titre like '%%' or notes like '%%')
and usagers.nom = '' and fiches.niveau_acces >= usagers.niveau_accesU
)
ORDER BY Titre ASC
Error: 8114, Severity: 16, State: 5
-
Could you please explain your problem a little more clearly ?!
You seem to have 2 tables - are they not linked by any key at all ?!
also - what is the DDL of these 2 tables and what exactly are you trying to select - all the fields listed if they have values in them ?!
do you get the right resultset when you use this select in the query analyzer ?!
**ASCII stupid question, get a stupid ANSI !!!** -
Well 8114 is an error converting data type. My guess is that one of the fields that you're comparing with '' is of a type that empty string doesn't convert to. (int, float, date)
Just a guess, since there's no table definitions or example data, but it looks like it's a syntax problem, nothing to do with IIS.
Example data and table definitions will help us a lot in solving this.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Well, I would guess the Application is missing some info or the session variables are lost! Definitely not a SQL problem
Cheers!
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply