Hi,
I have got the following error while trying to add a user in the LDAP Directory.
javax.naming.Na meNotFoundExcep tion: [LDAP: error code 32 - No Such Object]; remaining name 'uid=vassila,ou =People,dc=cs,d c=uno,dc=edu'
I have given all the attributes which are needed, for the user, in the code and also the proper path where the user has to be added. Please have a look at my code
[CODE]...
rbukkara
Last Activity: Dec 18 '07, 03:21 AM
Joined: Oct 26 '07
Location:
-
Error while trying to add a user in LDAP Directory
-
Please let me know the query for this!
Hi guys,
I have some trouble with the following query.
Please look into this and lemme know the solution ASAP.
It certainly involves aggregations and the 'having clause'
BROKER(
ID integer primary key
, NAME string)
ACCOUNT(
ACCOUNT_NUM integer primay key,
BROKER_ID references BROKER.ID,
GAIN real)
The value of the attribute GAIN in the relation... -
[Code=sql]select broker_id from account group by broker_id having 0.4*count(*) < (select count(ac1.broke r_id) from account ac1 where ac1.broker_id=b roker_id and ac1.gain<0);[/Code]
even this is not working!... -
It did not work when I used the 'AS' keyword. May be it is different in ORACLE.
and what do you mean by the 'needs to account for the BrokerID of the outer query'?...Leave a comment:
-
I was trying different ways of getting it done. I know it needs only one sub-query
this is the one I first framed and I guess it will make sense.
[Code=sql]select broker_id from account group by broker_id having (0.4*count(*) < (select count(ac1.broke r_id) from account ac1 where ac1.gain<0 ));[/Code]
Instead of the division operator I have used it this way!...Leave a comment:
-
i have first grouped by the broker id and in the having clause i want to count all the rows for a particular rating, which is easy and want to compare that with all the rows which have a negative gain -- which i am not able to do!
jus see this!
[Code=sql]
select broker_id from account group by broker_id having (0.4*count(ac.b roker_id) in (select ac.broker_id, count(ac.broker _id) from account ac group by ac.broker_id)< count(ac1.broke r_id)...Leave a comment:
-
Query using the Having clause
Hi guys,
I have some trouble with the following query.
Please look into this and lemme know the solution ASAP.
It certainly involves aggregations and the 'having clause'
BROKER(
ID integer primary key
, NAME string)
ACCOUNT(
ACCOUNT_NUM integer primay key,
BROKER_ID references BROKER.ID,
GAIN real)
The value of the attribute GAIN in the relation...
No activity results to display
Leave a comment: