[GENERAL] Temp tables as session var containers

2005-05-19 Thread James Croft
Hi, I've seen the session variable question pop up a fair bit on this list. The temporary table solution seems good but I've got a question before using it... - My app creates a temp table for session vars - UPDATE, INSERT and DELETE triggers on tables use this data My question is: If I run a

Re: [GENERAL] Temp tables as session var containers

2005-05-19 Thread Richard Huxton
James Croft wrote: Hi, I've seen the session variable question pop up a fair bit on this list. The temporary table solution seems good but I've got a question before using it... Another option is to use one of the procedural languages that provide global variable storage. The attached examples