Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
LB #1
CFHTTP Query & Order By
I'm using CFHTTP in order to query a remote CSV file, which works a
charm. However, I would like to be able to sort the results by the
value in one of the columns if possible. This is the code I'm using at
the moment;
<cfhttp
url="http://www.somesite.com/file.csv"
method="get"
delimiter="|"
textqualifier=""""
columns="name,url1,url2,blankl,price,currency,blan k2,blank3,blank4,blank5"
Name="BuildQuery">
<cfoutput query="BuildQuery">
<tr>
<td>#name#</td>
<td>#price#</td>
</tr>
</cfoutput>
I've spent a fair while searching google, but can't see for sure whether
this is possible or not?
Thanks in advance for any pointers
LB
LB Guest
-
Problem using SELECT TOP and ORDER BY together in a query
SQL is based on set theory. You are ordering the resultset by the StoryDate. So you have 6 articles at the top of the list. How is the database... -
cfhttp query text file
I use cfhttp to create a query from an ascii text file. The text file is comma delimited, with quotes around text. This works fine in CF5 and... -
text file to query using cfhttp
Did you ever find out what causes this issue? It's happening to me now... String index out of range: -1 Same situation, only I'm using a single... -
ORDER BY in UNION query
Hi, I need to use ORDER BY clause in a UNION query and the Order BY columns are not included in the SELECT statement. I tried like this (select... -
MYSQL query using GROUP BY and ORDER BY?
I'm probably going about this in the wrong way. Using PHP 4.2 and MYSQL 3.52 I have a "images" table that contains load of images and a related...



Reply With Quote

