CFQuery with cachedWithin="#CreateTimeSpan(0,1,0,0)#"
Posted on 2014-09-09
I have the following code in CFM page.
<CFQUERY NAME="GetCustomers" datasource="DSN" cachedWithin="#CreateTimeSpan(0,1,0,0)#">
ORDER BY CustomerName
What does cachedWithin="#CreateTimeSpan(0,1,0,0)# mean?
The reason for asking is:
I just added a new customer to the CUSTOMER table in ACCESS. But that new customer does not show up in online Order Form when the user selects the customer from the customer drop-down menu.
And I suspect that it has something to do with cashedwithin statement.
How can I make it so that when I add a new customer or new part into the tables, they would show up in drop down menu on the webpage?