I have a query that pulls all customers from the table. I have more than 10k records. I want to limit my query to output just entered values from the table. My current code pulls out all records. Can anyone help me with that. Thanks in advance.
Here is my code:
<?xml version="1.0" encoding="utf-8"?><cfsilent> <cfquery name="myQuery" datasource="Customers"> SELECT CustomerId,FirstName,LastName FROM Customer </cfquery> <!--- These are standard elements which can be inserted back into a request ---> </cfsilent> <livelookup version="1.0" columns="first_name,last_name"><cfoutput query="myQuery"> <customer> <customer_id>#XMLFormat(CustomerId)#</customer_id> <first_name>#XMLFormat(FirstName)#</first_name> <last_name>#XMLFormat(LastName)#</last_name> </customer></cfoutput> </livelookup>