Hi!
I have successfully established connection to external database of our site. It is Joomla component - form.
I want to add a proccess to the query that will create BO using the data from this extDB table.
But it is not possible for any operation buttons to appear in this query. I tried different KeyIDs. I think the right KeyID is SubmissionId.
I dont know much MySQL.
The table itself looks like this in PHPMyAdmin:
https://docs.google.com/spreadsheet/pub?key=0Ar4WCDuWyPLedG5NTUJqTDBnUWMyWHFDXzlhb3VydlE&output=html
SubmissionValueId FormId SubmissionId FieldName FieldValue time
1 1 11289 type TypeA 0
2 1 11289 PR от 590 0
3 1 11289 predmet fsdf 0
4 1 11289 worktitle dfs 0
5 1 11289 name test 0
6 1 11289 email 1@ua.fm 0
7 1 11289 Submit Отправить 0
8 1 11289 formId 1 0
9 1 11290 type TypeC 0
10 1 11290 PR от 1090 0
11 1 11290 predmet hgg 0
12 1 11290 worktitle bhk 0
13 1 11290 name khjk 0
14 1 11290 email 1@mail.ru 0
15 1 11290 Submit Отправить 0
16 1 11290 formId 1 0
17 1 11291 type TypeB 0
18 1 11291 PR от 1990 0
19 1 11291 predmet cx 0
20 1 11291 worktitle czxc 0
21 1 11291 name xc 0
22 1 11291 email 1@mail.ru 0
23 1 11291 Submit Отправить 0
24 1 11291 formId 1 0
25 1 11292 type TypeA 0
26 1 11292 PR от 590 0
27 1 11292 predmet czxc 0
28 1 11292 worktitle zxczx 0
29 1 11292 name czx 0
30 1 11292 email 1@mail.ru 0
