ODBiC Discussion Board


Nesting SQL queries

by Ben Blundell, May 30, 2006 08:10

Hello,

I have written a script that includes an SQL statement, and it recursively calls itself with the results of the query until the query returns no result (well, in theory).

I have found that it will allow me to nest up to 7 levels with a SELECT query and only up to 5 levels with an UPDATE query. After this, the web server tends to crash.

Can these limits be easily changed? I am using the script to generate a tree-like message structure for a forum, and using recursion is the simplest and neatest way of making the tree structure.

Cheers


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.