FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> I am wondering if it might be related to multiple connections 
> being open/persistent connections/multiple result sets. The 
> code is doing something like this:
> 
> 1. Return various rows
> 2. Iterate over them
> 3. If a certain field is not null, call a function which runs 
> another select to get a value based on that field
> 4. Add the value to that particular row
> 
> (I'm aware that I could do this with a left join)
> 
> How can I enable TDSDUMP? I've read 
> http://www.freetds.org/userguide/logging.htm
> 
> And done
> export TDSDUMP="/tmp/freetds.log"
> export TDSDUMPCONFIG=""
> 
> However, I'm seeing nothing in the /tmp/freetds.log file, 
> whether I run queries through isql or PHP.
> 
> Ben
> 

You have to launch isql/php from same session where you issue the commands.
Or using php you could include environment setting using php like

<?php
putenv("TDSDUMP=/tmp/freetds.log");
?> 

(remember to remove it in production environments :) )

freddy77