Forums

Populate form data from database CF6

rpgowned 08 Jan, 2018
I apologize if this information is out there already. This is probably easy but, I am having a hard time figuring out how to do this in CF6.

What I want to do is read all records from a database table OGE_MembershipData that pertain to current logged in users id (there will only be one row/user). and then populate fields in the form with that data. I am brand new to CF and just installed it yesterday.

Some information that may be helpful, Model name: Data5 / Field names in database match names in the form if that matters.

I don't know what to put in any of the fields on the Read_Data5 page or on the form fields themselves.

DB field names:
user_id
created
modified
primary_member_address
primary_member_name
primary_member_mobile_phone
primary_email
Member_status
MemberStatus_Date
Membership_Number
Membership_Expiration

Thank you for any help🙂
GreyHead 09 Jan, 2018
Hi rpgowned,

If you just want a listing of selected records from a database table then I'd suggest that you use ChronoConnectivity which is designed to do just that.

Bob
This topic is locked and no more replies can be posted.