I am using datatables ajax request and i cannot figure out how to parse the form variables coming back like this 1. order[0][column]: 1 2. order[0][dir]: desc 3. order[0][name]: 4. start: 0 5. length: 10 6. search[value]: Fishe 7. search[regex]: false These arent real arrays so not sure how to parse them. Any suggestions?

Have a look at https://github.com/jmohler1970/FormUtils

OK i have that setup but now the cfc seems to have a bug for the 2023 release The value NAME cannot be converted to a number. The error occurred in C/CFNextAlpha/cfusion/wwwroot/fastrack hipco/cfc/formutils.cfc line 101

99 :                         }
100 :                         else {
101 :                             local.currentElement[local.tempElement][local.tempIndex] = trim(canonicalize(arguments.formScope[local.thisField], true, true));
102 :                         }
103 :                     }

ignore what you normally think of form fields from coldfusion when receiving datatables requests. this is your form field name 'order[0][column]' use array notation to refer to it, then switch the 0 to a variable. technically, they will send one of those per 0 based column in the table, thats what you would loop from 0 to the column count-1. to reference your list item 1, form['order[#yourLoopIndex#][column]'] . You don't have to use all the stuff it sends, it's just that datatables is trying to give your endpoint the info it has configured. If it is stuff only in your own app, like you are frontend, and the ajax. then you can likely ignore any that start with columns, as you wouldn't use the datatables configuration to drive how you configure stuff. for order, if you select multiple columns, you will get numbers above 0, but never to exceed the count of columns.

Ah, well i got everything working except the pagination on the second page doesnt return any results when using the search the first page is fine, what a headache 🙂

If the names are consistent then you should be able to just grab them, but I don't use datatables so assume they are dynamic?

no i know them and i am now using that so that part is working

This doesn't look right

the util writes back to the form scope, but that isnt the part that is failing, and i will be removing that dependancy soon

Oh, it mutates the form scope 😕

yeah

are you echoing back out the draw

yes

it doesn't seem like qryContactSearch has any records, otherwise your data would have objects in it

the query being executed

select DISTINCT vwAllAccounts_Contacts.ContactID, vwAllAccounts_Contacts.ContactCombinedName, vwAllAccounts_Contacts.ContactWorkPhone, vwAllAccounts_Contacts.ContactCellPhone, vwAllAccounts_Contacts.ContactEmail, vwAllAccounts_Contacts.CompanyName, vwAllAccounts_Contacts.AccountID, vwAllAccounts_Contacts.MailingCity, vwAllAccounts_Contacts.MailingState, vwAllAccounts_Contacts.ContactTitleDescr, 'A' as ContactType, vwAllAccounts_Contacts.TerritoryID as HTerritory, vwAllAccounts_Contacts.AssignedName AS HSalesperson, ' ' as Action from vwAllAccounts_Contacts WHERE vwAllAccounts_Contacts.Active=1 AND vwAllAccounts_Contacts.ContactActive=1 AND vwAllAccounts_Contacts.ContactCombinedName LIKE ? AND (vwAllAccounts_Contacts.UserID = ? OR vwAllAccounts_Contacts.InUserID = ? OR vwAllAccounts_Contacts.BranchMgrID = ? OR vwAllAccounts_Contacts.RegionMgrID = ? OR vwAllAccounts_Contacts.FiltrationUserID = ? OR vwAllAccounts_Contacts.FiltrationINUserID = ? OR vwAllAccounts_Contacts.FiltrationBranchMgrID = ? OR vwAllAccounts_Contacts.FiltrationOfficeMgrID = ? ) --ORDER BY CompanyName, ContactCombinedName ORDER BY HSalesperson asc OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY

Hi cfengineers - we are using DataTables in our app. In our app we convert all URL/form variables into a private structure called request.publicVars, and then reference all of the dataTables variables like: request.publicVars["search[value]"]