DB lookup vs Query ?

Hello

We use PAP visitor cookie in which we have the affiliate id

We would like to use DB lookup or Query field in order to have the real name of the affiliate displayed in the registration form and check its validity before submitting the registration form

I cannot figure how. Is there any ajax possibility to use the DB lookup field so that it gives the result at the same time of displaying the registration form ?

The DB is shared by joomla and PAP

Do you have any idea of how to do this ?

I don't think you can use DB lookup field for this unless the field has the cookies value passed to it. It then takes that value and compares it to the database. It should do what you're wanting assuming it has the affiliate id as its value of course.

Well I have the value passed with a code to the DB field
However, the field only shows the value and the query is not done

I have taken care of the autoaction being fired before the registration form, the value is correct in the cb DB lookup field, but the Query does not occur for the user to see the result on the registration form

Could you help me on this ?
Screenshots attached

The lookup is done I think onkeyup, so you'll need to trigger that in your CB Auto Action with jQuery (you'll need a new auto action that's jQuery instead of HTML or trigger it using normal JS). Example as follows.

$( '#cb_field' ).trigger( 'keyup' );

It could be keydown, keypress, change, I don't know specifically but you'll need to trigger the appropriate event after the value is changed.

Well I tried with
jQuery( '#cb_parrainnom' ).trigger( 'keyup' );

But it keeps giving [jquery.form] terminating; zero elements found by selector

I have also noticed that even if I try to manually input a value in the DB lookup field and press keudown there is no feed back nor queries performed.

Can I use this on a registration form to perform a DB check with a value ???

Whoops, thought it had an ajax response. It does the check at registration post so when you click register it'll perform the check.