I would like to debug the following queryto see what values are coming inside the select statement:
$table_key = $multi_lang->TableKey(COUNTRY_SPR_TABLE);
$strSQL = "select distinct a.id, b.".$field_name." as name from ".COUNTRY_SPR_TABLE." a left join ".REFERENCE_LANG_TABLE." b on b.table_key='".$table_key."' and b.id_reference=a.id order by name ";
$rs = $dbconn->Execute($strSQL);
In asp i do the following:
response.write(strSQL)
response.end
Please let me know. Thank you very much for the information.