Can you rediminson a muti-dementioial array during a nested query loop on multiple tables from the primary DSN in the config.web.nested sub domain multiauthenticated administrative profile?

No, the multiauthenticated admin profile is locked when the array is built. Any changes after that are discarded until the next query loop. Then it will use the first loop results and the second loop results and third loop results and so on until the process ends, hence the term muti-dementioial array. You can get around this by instead of nesting the query, run separate concurrent query's forcing a new instance for each process.

I hope that helps.

---

Thanks,

Ge0ph

Thanks for the response. I was wondering if the multiauthenticated Admin profile would be able to rediminsion the array once the array is built? If not, could we use the a multi-level nested query loop to access the second dimision once its read from the database table? I believe I could run concurrent query's on the database forcing a multi-diminsional processes in a single query also.

 

Thanks again. 

Ken:

I was wondering if the multiauthenticated Admin profile would be able to rediminsion the array once the array is built?

Once the array is built, it is final.

Ken:

 If not, could we use the a multi-level nested query loop to access the second dimision once its read from the database table?

Absolutely, This is how most people get around the problem you are having.

Keep in mind that the concurrent query's may not finish processing at the same time and this could cause out of sync irregularity's. To keep everything in order use the cfsync tag to make the first query's results wait for the other concurrent query's before processing the results. It's not pretty but it will work.

---

Thanks,

Ge0ph

I have just tryed the CFSYNC command with the following parameters : <cfsync query="fbi_passwords" array="toplevel" dim1="2" dim2="56" database="cia_virginia">. It seemed to work for the first array but didn't carry the "synce" to the second diminsion of the first array. Now I'm wondering if a formula like this (array(3,4)/dim1(2)/dim2*56) would work if I placed it right after the cfsnyc command. It might help with concurrent query request looped over 2 or more multi-dimensional arrays.

It all depends on the conceptual continuity of the code. If you have the pre-dominant and the post-dominant setting on the ColdFusion server set correctly it should “just work”. I recommend  10 for the pre and 300 for the post. The CFSYNC command will only affect the processes that occur in between the pre and post.

 

I’m guessing your multi-dimensional arrays are still processing when you hit the post mark and every thing after that is discarded. You may have to play with it a bit to be sure all of your multi-dimensional arrays have completed before the CFSYNC tag is processed. With a setting of 300 for the post the code is halted for 300 milliseconds before continuing to the CFSYNC tag. If that’s not enough time just up the post until it fits.

 

This is a global setting on the server so if you have a multi-dimensional array that only takes 50 and one that takes 800 you will need to set it to 800. The down side is that the multi-dimensional array that only needs 50 will still have to wait the full 800.

 

It’s really pretty easy stuff once you understand how it works.

---

Thanks,

Ge0ph

I was reading your discussion about the CFSYNC command.Thanks  for the great insight on the pre & post CFSYNC settings. Do you think the same CFSYNC settings would apply to parallel arrays in a multidimensional environment? If so, would the pre settings change prior to the creation of the first two parallel arrays? Or would the post settings change to accommodate parallel access to the database during runtime queries for buffer allocation and acquisition?

Bill:

I was reading your discussion about the CFSYNC command.Thanks  for the great insight on the pre & post CFSYNC settings. Do you think the same CFSYNC settings would apply to parallel arrays in a multidimensional environment? If so, would the pre settings change prior to the creation of the first two parallel arrays? Or would the post settings change to accommodate parallel access to the database during runtime queries for buffer allocation and acquisition?

I think for parallel arrays you might want to move that to the database and use a stored procedure.

The settings for pre and post are static server side settings. Nothing you put in the code will change that.

It might help to know what exactly you are trying to accomplish.

---

Thanks,

Ge0ph

Thanks for the quick response. I guess letting you know what I’m trying to do would help. Sorry about that. I have an office in Japan with my manufacturer in Taiwan. I’m here in the States. I have multiple databases that I’m trying to keep current and secure. The “items” we manufacture are high security items and the data we transfer is very sensitive. I’m trying to establish a secure connection with my MS-SQL database using Coldfusion as the main application to keep this information current in all three countries. I thought about using parallel arrays to keep the information in sync. I ran across your post on the CFSYNC tag while doing research at MIT and Berkeley. Keep in mind also that the latency is playing a major role in keeping the information current in all three countries. Hope this helps. Thanks again :)

I'm a little late to the party here but:

Have you thought about a Distributed Server Farm? A DSF works like any other server farm except the servers can be located in different geographic locations. They use caching a lot and updated information is slower but it all stays in sync. 

Just a thought.

Thanks for your input on the DSF. I haven't really given it much thought. I don't think the latency will be a real problem especially with the time zone differences. Which server OS would you recommend and would my Linux firewall be the firewall of choice? Once I get this CFSYNC working I would like to approach the board with this new DSF idea.

 

Thanks again. What an awesome forum.