FN-FORUM: sql question

date posted 10th August 2003 17:13

Hi,

I am getting the following error
You have an error in your SQL syntax near 'SELECT Employee_Id FROM
greensplash_employees_per_project where Project_Id = '18' at line 1.

I have set the sql string as follows

$sqlstring = "SELECT Employee_Id, Employee_Forename, Employee_Surname FROM
greensplash_employees_details where Employee_Status = 'Active' AND
Employee_Id NOT IN (SELECT Employee_Id FROM
greensplash_employees_per_project where Project_Id = '" .
$row_Project_Id['Project_Id'] . "') Order By Employee_Forename";

and echo prints out

SELECT Employee_Id, Employee_Forename, Employee_Surname FROM
greensplash_employees_details where Employee_Status = 'Active' AND
Employee_Id NOT IN (SELECT Employee_Id FROM
greensplash_employees_per_project where Project_Id = '18') Order By
Employee_Forename

Can someone tell me what is wrong please as I can't spot it.

Thanks
Pam


'

NTMail K12 - the Mail Server for Education