Possibly you are opening another connection, using the same handle, when you re-enter your script. If that is the case, you'll lose track of your previous connection (the one that has the temporary table). You might also be accumulating a lot of connections, if this recursion happens multiple levels.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Amer Neely [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 15, 2007 11:21 PM > To: Daniel Kasak; mysql@lists.mysql.com > Subject: Re: Temporary table lifespan - SOLVED > > Amer Neely wrote: > > Daniel Kasak wrote: > >> Amer Neely wrote: > >> > >>>> OK, that makes sense. As far as I know, my connection is > still live > >>>> - I don't do a disconnect anywhere. So I'm still not sure why I > >>>> can't pull the data back out. I do get an error telling > me about a > >>>> problem with my statement near .... which is where it tries to > >>>> execute the FROM command. > >>>> My apologies, I'm not on the computer that I am developing this > >>>> script on, so can't give you the exact error. > >>>> > >>>> I'm naming the table from a purchase order number, and > as far as I > >>>> can tell, the table I try to read from is the same as the one I > >>>> created - but I get nothing out of it. > >> > >> It's hard to say without more details. You can send the > script if you > >> want. Also keep in mind that since you're using tmp tables > which are > >> invisible to all other connections, you don't need to much > around with > >> creating a unique table name - you can just use a generic one ( eg > >> tmp_purchase_order or something ). > >> > > > > I'll try something like that tomorrow. Thanks for the > responses. I'll > > post my results. > > > > After failing to get the temporary table method working, I > ended up just > creating a table, then dropping it when I was done. > > It seems that a temporary table will get deleted when a script calls > itself and jumps to a function inside. That must constitute a > disconnection. > > -- > Amer Neely > w: www.softouch.on.ca/ > b: www.softouch.on.ca/blog/ > Perl | MySQL programming for all data entry forms. > "We make web sites work!" > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
