If I am using a table from DB other than a table I created using Chronoform, and it doesn't have a primary key...what do I do?
(the table I am trying to access is the billing info of a membership component - I guess it is "the second portion" linked to another table with a primary key).
I really don't know what I'm talking about. I checked what seemed to be your only tutorial, tried to set up HTML in body section of "connection views" as I would like to see info on front end' also added pagination in header and footer; and now basically stuck because not sure what to do about primary key.
I can look up the SQL command to add a row to the billing info table and make it the primary key, and then I bet I would mess up my whole membership component by doing so...
Also, what does this mean from your tip, tricks, and hacks forum section:
EDIT 2 (01.08.2010): Added the capability of a frontend edit ID other than the primary key
_Cindy
(the table I am trying to access is the billing info of a membership component - I guess it is "the second portion" linked to another table with a primary key).
I really don't know what I'm talking about. I checked what seemed to be your only tutorial, tried to set up HTML in body section of "connection views" as I would like to see info on front end' also added pagination in header and footer; and now basically stuck because not sure what to do about primary key.
I can look up the SQL command to add a row to the billing info table and make it the primary key, and then I bet I would mess up my whole membership component by doing so...
Also, what does this mean from your tip, tricks, and hacks forum section:
EDIT 2 (01.08.2010): Added the capability of a frontend edit ID other than the primary key
_Cindy
Hi Cindy,
I think that you should be able to display info from a table without a primary key. Updating it might be tricker.
The bigger problem will be getting ChronoConeectivity to work with a secondary table "I guess it is "the second portion" linked to another table with a primary key". At the moment CC can only query a single table - though there is a hacked version in the forums that is more flexible.
There are a series (still incomplete) of ChronoConnectivity tutorials here
Bob
I think that you should be able to display info from a table without a primary key. Updating it might be tricker.
The bigger problem will be getting ChronoConeectivity to work with a secondary table "I guess it is "the second portion" linked to another table with a primary key". At the moment CC can only query a single table - though there is a hacked version in the forums that is more flexible.
There are a series (still incomplete) of ChronoConnectivity tutorials here
Bob
This topic is locked and no more replies can be posted.