Query after submit

Hello eveybody
i'm trying to set up a simple query but unfortunately i'm coming across a few problems. Could you please help me?
The main problem, for now, is how do i pass data from a simple submit form (Text Box plus Submit Button) to a DB Multi Record loader ?
I've looked up in the forum but i can't find similar problems.
Any idea would be very helpful.

Hi maxtemp,

In CFv4 you can either use the DB Field and Request Param boxes (the Request Param takes the name of your Text input); or you can add a MySQL WHERE Statement on the Advanced tab.

Bob

Hi Bob
i've tried to take advantage of your tips, but up to now i'm still stuck.
What i did was ,as you can tell by the uloaded image,
In the preview area
create a Text box area and a submit button
In the Events area
add a show Html box
add a DB record loader specifying
[list=] the Db field i wanted to search
the Table i wanted to load
the Request Param named as my Text input box[/list]

Marco

Everybody on holiday?🤣

Hi maxtemp,

Sometimes we may not notice few posts!🙂

Actually the "db multi record loader" and the debugger should be in the "on submit" area.

Regards,
Max