SQL Query question

[fredericoagent]

Hi All,

I have a question regarding SQL queries I hope somebody can help me with.

I am trying to create a query in a software called HP quality center in order to extract requirements but need some help.

Under the requirements section we created folders with the name (Name test1 , Type FOLDER)

Under each folder we created set of requirements. Is there an easy way to extract all requirements where folder name = foldername1


---
Select REQ.RQ_USER_03,REQ.RQ_USER_03
FROM
REQ



No how to I say only select the requirements if they are in located in a folder named test1 ?

thanks

 

[carp]

This is just a guess:

Select REQ.RQ_USER_03,REQ.RQ_USER_03
FROM req
WHERE folder = 'test1';

This assumes a column called "folder"; you may need to change this to fit your actual situation (or give us more information about your table structure).

 

[fredericoagent]

what am doing wrong

http://tinypic.com/view.php?pic=2j0z512&s=6

 

[carp]

The error message is fairly clear - RQ_FATHER_ID is an integer datatype; you are trying to compare it to a character string that cannot be converted to an integer.