Cannot insert null error

[rbragg]

<?php
$queryInsertParent4Student = "
INSERT into schema.STUDENT (parent_num)
SELECT parent_num
FROM schema.PARENT
WHERE email = '" . $_SESSION['pMail'] . "'";
?>

 

Why does the above give me this error:

 

ORA-01400: cannot insert NULL

 

... when the session is tested and set AND there IS a parent_num for this email in the db?  ??? I think I'm just being dumb here. Thanks.

[fenway]

ORA? As in Oracle?

[rbragg]

LOL! Yes. This type of query works in other places in the environment so I thought it could be asked as a general question. 

[gizmola]

What might help you is to echo out the value of the query string you've created.

 

echo "\n";

 

View the source for the page and see if the query is what you expect, and that it's something you can run in sqlplus.  I'm thinking it isn't.

[gluck]

You seem to have a constraint on the field like not null and your query is trying to insert a null in tha field.