hi, I have just installed the module; already falling in love with it simply playing with all different options and seeing the potential.

but when it comes to the SQL portion, I feel a little confused. I know some basic sql query command and all that; but, I am not sure what am I expecting here, I mean; should I load one table? can I load multiple table? for the columns, should I be matching those ID with table that I am loading? I see that it provides me some basic variables like user_id or such; is there any more? do you have some samples?

sorry, I know it's a full load of questions

Ringo
Innovational Design

Hello,

If you want to combine data from a different tables, JOIN can be used.

Predefined variables are used to filter results. It can be used in "WHERE" clause in a SELECT SQL query.

Regards,
ARI Soft

cool, I guess I am still feeling lost ....

1st of all, sounds like that little text box full support all SQL command, right?
2nd of all, can I put multiple command lines (with ; to end them and seperate them)
3rd of all, should I run it as I would have in a PHP environment? like running "for" statement, declare variables, etc.

last, but not least, after loading the SQL table, what can i do to match the table with all the columns that's set above? or, is that the point of declaring the column ID? (i.e., the ID field has to match the database table column ID? does it matter if they the module columns order are different from the one in database?)

tho, I am pretty sure I am good to go after you answer all of these questions for me; I am still highly suggesting including some practical sample in your help document (the help file that's included with the module)

Ringo
Innovational Design

Enter a "SELECT" SQL query in "SQL query" parameter. It doesn't accept PHP code or multiple command, but it is possible to use some predefined variables in "WHERE" clause. A sample query:



Regards,
ARI Soft