I am trying to find info about access result from SQL command. I would like to access field name/value from a command like
<SQL "select * from mytable>
<iterate through fields and process values >
</SQL>
If that is not possible, I want to know if I can access fields that I have names in my variable. Like:
<$myfields =F1 F2 F3>
<construct $mysql as "select F1,F2,F3 from mytable">
<SQL $mysql>
<LOOP $myfields>
<??? display value of field with name $myfields>
</LOOP>
</SQL>
All these are not possible, I assume that I had to use a user function to do this. Can someone tell me something(insight,suggestion,etc) about this approach?
Thanks in advance.
Yes, I am new to this and we have full texis license.
<SQL "select * from mytable>
<iterate through fields and process values >
</SQL>
If that is not possible, I want to know if I can access fields that I have names in my variable. Like:
<$myfields =F1 F2 F3>
<construct $mysql as "select F1,F2,F3 from mytable">
<SQL $mysql>
<LOOP $myfields>
<??? display value of field with name $myfields>
</LOOP>
</SQL>
All these are not possible, I assume that I had to use a user function to do this. Can someone tell me something(insight,suggestion,etc) about this approach?
Thanks in advance.
Yes, I am new to this and we have full texis license.