Posted by Sheldon Glickler on 03/01/06 13:52

"Steve" <google.spam@nastysoft.com> wrote in message
news:1141211513.214654.269950@z34g2000cwc.googlegroups.com...
>
>> $query = "DELETE FROM CatalogNames WHERE sCatalogID='" . $catalog .
>> "'";
>> mssql_select_db($database_Login, $_SESSION['Login']);
>> $result = mssql_query($query, $_SESSION['Login']);
>>
>>
>> $query = "INSERT INTO CatalogNames (sCatalogID, sCatalogName) " .
>> "VALUES ('" . $cat_id . "', '" . $cat_name . "')";
>> mssql_select_db($database_Login, $_SESSION['Login']);
>> $result = mssql_query($query, $_SESSION['Login']);
>
> I think it unlikely that you can reliably cache and reuse a database
> resource between sessions. You should create a new session with each
> invocation of the script.

This is one session where it works on one and fails on the other. I use a
mssql_pconnect, but I will try making a new connection.

[Back to original message]