- Wed Jun 28, 2017 7:44 pm
#793525
HI,
Sorry for the dull question.
But since I migrated to the new version of PM 2.5 from 1.6, some of the stuff that was working smooth before now there not working properly.
So in this case I have a dynaform where a populate a textbox from a trigger(before load dynaform) that works fine, however I have a text box that have a SQL query that doesnt work, and depends on the first text box. For example:
field one @@text1, (populate by a php trigger).Works
field two @@text2, that is populate buy a sql like this one:
SELECT NAME FROM database1 WHERE LASTNAME = @@text1.
My question why is not working if it was working fine before?
if I put a string in there the query will work but with the variable @@text1 doesn't.
Thanks for the help
Regards
Sorry for the dull question.
But since I migrated to the new version of PM 2.5 from 1.6, some of the stuff that was working smooth before now there not working properly.
So in this case I have a dynaform where a populate a textbox from a trigger(before load dynaform) that works fine, however I have a text box that have a SQL query that doesnt work, and depends on the first text box. For example:
field one @@text1, (populate by a php trigger).Works
field two @@text2, that is populate buy a sql like this one:
SELECT NAME FROM database1 WHERE LASTNAME = @@text1.
My question why is not working if it was working fine before?
if I put a string in there the query will work but with the variable @@text1 doesn't.
Thanks for the help
Regards
Attachments
SQL_dynaform.PNG (12.73 KiB) Viewed 3686 times