Variables for SQL SELECT ERROR

Hi all,

According with the documentation, the macro sc_lookup() set variable dataset_erro when some SQL error happened, but when i try to use {dataset_erro} to get this error message, appear “Undefined variable: dataset_erro”.

The example that appear in the documentation is:
if ({my_data} === false)
{
echo “Access error. Message=”. {my_data_erro} ;
}

I try to use {my_data_erro} but happened same, “Undefined variable: …”

Thanks for clarify if is and bug or bad documentation.

Regards.

AYMG

Actually I don’t know. I never used this variable. As the docs are not always right I think you need to look into the generated code to see what’s wrong. At first sight there’s a typo in the documentation, (error) but there are more typo’s that work well (i.e. itens in stead of items). Either way, if the docs are wrong or it doesn’t work as expected I would report this as a bug.

Hi Aducom,

Thanks for your answer and help in order to report.

Regards!

AYMG