Forums

I have a DB Multi Loader form and can't seem to get a simple return of my database rows using a straightforward select statement. I can get all of my data to return, but i have a simple Yes/No field (Shido_Directory) in the database table to indicate whether a user wants to be in the directory, so I need to show only those records where the user has indicated 'Yes'.

On the Basic Tab:
DB Field - Empty
Table - The Table value is a drop-down and that is set to my table in the the default Joomla database.
Request Param - Empty
Model ID - Empty

On the Advanced Tab:
Load Data=Yes
Data Load Type = All
Enable Associations=No

On the Data Displayer Tab:
Enable Data Displayer = Yes
Display Field has four field listed and they show up correctly

I then inserted a Custom Code Action into the On Load Action section to select only the correct records. I set the Mode to View and have tried numerous queries to get this to work, but fundamentally I am looking for the right code to perform this basic SELECT statement:
SELECT First_Name, Last_Name, Email, User_Dojo
FROM us46v_User
WHERE User_Directory="Yes";

I have looked at the DB Multi Loader tutorial and all of the database FAQs but I'm just not getting it. I thank you for any guidance you can provide.

Hello cruss575,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How can I link two DB Multi Record Loaders?
P.S: I'm just an automated service😉

Hi cruss575,

If you scroll down the Advanced tab in the CFv4 DM Multi-Record Loader there is a WHERE statement box. You can add your WHERE statement there (without the WHERE word).

Bob