Hi,
I have now tried this custom tag for multi select related - CF_MultipleRelatedSelects. Downloaded it from Macromedia.
The tag works rally well - if you don't have to many records.
The problem I have is that I have about 17000 records and the page doesn't load properly.
When I cut the db down and only have about 2000 records it works great.
I have tried to cache the query but it didn't help and I also tried to use <cfcache> but due to that the page doesn't load properly it didn't work.
Anyone have an idea how to deal with this?
Can I put an "delay" so that the query can be executed before the custom tag get executed?
Jonas
I have now tried this custom tag for multi select related - CF_MultipleRelatedSelects. Downloaded it from Macromedia.
The tag works rally well - if you don't have to many records.
The problem I have is that I have about 17000 records and the page doesn't load properly.
When I cut the db down and only have about 2000 records it works great.
I have tried to cache the query but it didn't help and I also tried to use <cfcache> but due to that the page doesn't load properly it didn't work.
Anyone have an idea how to deal with this?
Can I put an "delay" so that the query can be executed before the custom tag get executed?
Jonas