MXimize by Carlos Gallupa, thoughts about and experiments with coldfusion, css, sql, components and javascript

I use:
<cffunction name="convert" access="remote" returntype="array" hint="converts queryobject into array">
<cfargument name="theQuery" required="true" type="query">
<cfset var theArray = arraynew(1)>
<cfset var cols = ListtoArray(theQuery.columnlist)>
<cfset var row = 1>
<cfset var thisRow = "">
<cfset var col = 1>
<cfscript>
for(row = 1; row LTE theQuery.recordcount; row = row + 1){
thisRow = structnew();
for(col = 1; col LTE arraylen(cols); col = col + 1){
thisRow[cols[col]] = theQuery[cols[col]][row];
}
arrayAppend(theArray,duplicate(thisRow));
}
</cfscript>
<cfreturn theArray>
</cffunction>

04 September 2005 23:29 cet  

I discovered that an empty recordset doesn't give me any values so that's why I use the ELSE statement.. to have empty values that I can overwrite with default values if I want.

12 September 2005 9:38 cet  

I am fairly new to CF and programming however I am trying to get some assistance in querying an array. For instance, I have set the array in the application file as such

<code><CFSET URL.contactKeyword[1] [1]="South Florida Search Engine Optimzation" >
<CFSET URL.contactKeyword[1] [2]="south-florida-search-engine-optimization" ></code>

Next, I haveadded the following to my contact page as an anchor ...

<code><a href="http://www.edwardbeckett.com/Contact/"; name="<cfoutput>#URL.contactKeyword#</cfoutput>">Contact <cfoutput>#URL.contactKeyword#</cfoutput> </a></code>

The question is - How can I Loop through the array that is in the application file to output the second level in the array based on the URL variable that is defined in the first row?

28 October 2007 8:13 cet  

Hi Edward, If you are new to CF I would strongly recommend not using 2 dimensional arrays. They are quite hard to read and you are probably better off using a structure for this.

Also.. keep your application file as small as possible because this file will be executed each and every time a page is requested. And further more.. don't ever CFSET URL variables... those are variables that come from the URL scope and only from that scope.. it should not be used to put variables in :-) Use the Variables, Application or Session scope for this.

Back to your problem... I would use something like this in your case

<cfset stSEO = structNew()>
<cfset stSEO["s-e-o"] = "Search Engine Opt.">

If you have a link like this <a href="/contact/?name=s-e-o">link</a>

On the receiving page you can get the value of this by putting the URL variable URL.name straight into your structure as the key of that particular structure

<cfoutput>#stSEO[URL.name]#</cfoutput>

I'm pretty sure what you are trying to do, and I think this is not the way to do it. Did you read my search engine friendly articles??

http://www.mximize.com/how-to-get-search-engine-friendly-url-s

28 October 2007 11:37 cet  

Tjarko ... Thanks for your advice ... This will really helpme from "bleeding out" my keywords at the contact page ... I will definitely check out your articles for more insight.

This idea was a brainstorm that I adopted to try and support keyword - link path consistency. Currently all my keyword strength is pointed to /Contact/ ...

This is an attempt to create a "keywordname" contact page psuedo dynamically ... How well it will perform with the SERPS? That's another thing entirely... Thanks again.

31 October 2007 9:38 cet  

Very useful function. Thanks for sharing!

14 January 2008 18:06 cet  

Great work all of you.

I testet both function with a query of 250000 datasets. The table has 8 columns all int values. Test Server is CFusion 8, Apache 2.2 and mysql5.

MdiX function take around 1500ms the first function takes around 5500ms. I think the CFTAGS are slower than the cfscript.

Thanks for the function.

17 September 2008 21:50 cet