This is the query that I have. <cfquery name="qryname" datasource="dsn"> UPDATE ticketlist SET status = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="Expired"> WHERE expdatetime < <cfqueryparam value = "#yourDate#" cfsqltype = "CF_SQL_DATE" maxLength = "19"> </cfquery> It is able to give me all the results who's expdatetime is l...
How do you NOT use a query of queries inside a loop to solve the problem of having to build a select list for each row? In this example, every customer has a list of actions unique to that customer: <cfquery name="qryAction" datasource="myDataSource"> SELECT ActionID,CustID,ActionName FROM AvailableActions </cfquery> <cfquery name="qry...
I'm using this code to display a list of platforms. If a platformID was specified upon entering the page, I would like to create a list of genres underneath the specified platform. browse.cfm was accessed via a link that specified a platformID of 1 browse.cfm will list all available platforms browse.cfm will now list all available gen...
Simply, I seem to be able to write code that either creates a clickable marker for a pop-up infoWindow OR gets the bounds of the returned markers and resets the map extent and zoom levels. I can't seem to combine the two. My example below will nicely set the extent of the map to the results of the query. But I don't quite know how to ...