table, db load and joomla user id

I have a CF table that I created. I'm trying to use that table when pulling data into another form (via db load). The data is not populating in the new form.

When I looked at the data in both the joomla user table as well as the CF table, the id in joomla user table shows a user as 863. In the CF table, CF_ID is 1. I thought these should match?

Is this why I'm unable to pull the data? If so, can you tell me how to fix?

Thanks again for all you do! I am really enjoying learning CF!

Hi mduda ,

The cf_id column is usually the auto-incremented record ID. If the table was created in ChronoForms then the cf_user_id column will usually have the user id in it.

Bob

Okay, so that must be the problem. I'm not able to pull from the table because all of the cf_user_id numbers are showing as 0.

When I'm saving a chronoform, is there another custom code that I have to setup so that the cf_user_id in the form and the id in Joomla sync?

Hi mduda,

The cf_user_id will be set to 0 if the current user is a guest - that is they haven't logged in.

Bob