Question: I have two URL's which contain the parameter "tour\_date" which I am trying to read out in PHP. Running `$_REQUEST["tour_date"]` for the first URL:

.php?tour\_id=336&tour\_date=11/06/2010

returns the value of: 11/06/2010

While the second URL:

.php?tour\_id=336&tour\_date=11/06/2010

returns nothing. I've run the empty() method to test, and it indeed is not finding it. Any ideas on why this would happen? Thanks for your help!

Answer: 
try clearing all CurrentEmployer's first then deleting the Employee

```
public class Employer 
{
    public virtual Guid Id {get;set;}
    public virtual string Name {get;set}
    public virtual IList<Person> Employees {get;set;}

    public void UnemployAll()
    {
        foreach(var employee in Employees)
        {
            employee.CurrentEmployer = null;
        }
        Employees = new List<Person>(); // clear it
    }
}

```

then try the following (I think the employees (person) should all get updated), I don't know if this will work off the top of my head, but it may get you started in the right direction.

```
oldEmployer.UnemployAll();
_session.Delete(oldEmplorer);

```
Oracle has the cascading delete feature (based on foreign key constraints) built in. Sybase does not. 
Depending on if your database supports before and after triggers you can create the functionality with before triggers. Sybase 12 doesn't have this, it only has after triggers so it's impossible on sybase. Sybase 15 has before triggers but I haven't tried it yet, but it should work, basically you write the before trigger manually to do the cascading delete.

If this before trigger functionality doesn't exist in your database, this is not possible. You would have to programmatically delete the child table rows first before deleting the parents.

That's just how it is.