Android – google-play-services_lib.jar missing from SDK google_play_services lib folder

One solution would be to create a "SOCKS5 adapter" that would accepts regular SOCKS5 connections on one side, then forwards them onto an authenticated SOCKS5 proxy on the other.

You could run the "adapter" locally and configure it with the allowed incoming connection (localhost) and outgoing authenticated SOCKS5 proxy and username/password.

Because the first proxy is running locally, you would not incur much of a performance hit. This would work in any agent which supports any proxy format you want to expose to your browser.

Otherwise, this sounds more like a superuser question.

To reference dynamic column names, you can use array notation. But as I mentioned, you must supply a row number.

 #queryName["columnName"][rowNumber]#

If you know the query contains one (1) record, only, you could use the query object's "recordCount" property as the row number. Alternatively, you could hard code the row number "1". (Personally, I dislike hard-coding). But any one of these should work.

<!--- pick ONE option ---> 
<cfloop from="1" to="#form.days#" index="i">
   <!--- syntax option 1 ---> 
   <cfinput type="datefield" name="ses#i#Date" value="#DateFormat(qGetUWHeader['ses#i#Date'][qGetUWHeader.recordCount], 'yyyy-mm-dd')#" />
   <!--- syntax option 2 ---> 
   <cfinput type="datefield" name="ses#i#Date" value="#DateFormat(qGetUWHeader['ses'& i &'Date'][qGetUWHeader.recordCount],'yyyy-mm-dd')#" />
   <!--- syntax option 3 ---> 
   <cfinput type="datefield" name="ses#i#Date" value="#DateFormat(qGetUWHeader['ses#i#Date'][1], 'yyyy-mm-dd')#" />
</cfloop>

If however, you are looping through multiple records in the qGetUWHeader query, you can use the query object's "currentRow" property as the row number. But based on the field naming convention, I am guessing the query only contains one (1) record.

EDIT: I forgot about the initial nulls. You could apply a simple if condition, and only call DateFormat() if the query value is a valid date.

<cfloop from="1" to="#form.days#" index="i">
    <cfset dateValue = qGetUWHeader["ses#i#Date"][qGetUWHeader.recordCount]>
    <!--- if this is a valid date, format the value --->
    <cfif IsDate(dateValue)>
      <cfset dateValue = dateFormat(dateValue, "yyyy-mm-dd")>
    </cfif> 
    <cfinput type="datefield" name="ses#i#Date" value="#dateValue#" /><hr>
</cfloop>

Another option is to format the dates in your SQL. Then you would not need to use CF's DateFormat() function. Just be aware that the new result would be a string, not a datetime object.

SELECT DATE_FORMAT(ses1Date, '%Y-%m-%d') AS ses1Date, ....