Recent content by Argus

When I use CFCONTENT it displays excel files as &quot;ÐÏࡱá>þÿ ....etc&quot;. I tested a gif and it came up fine. The code I am using is:- <cfcontent deletefile=&quot;no&quot; file=&quot;d:/data/mysheet.xls&quot; type=&quot;application/msexcel&quot;> Pretty straightforward I think. Any...

Thank you once again. I really should have known that - it's been a long day....

Brilliant! Thanks for that. Exactly what I needed.

If I have a query such as:- <CFQUERY name = etc etc> SELECT * From MyTable WHERE Surname = 'Smith' </cfquery> it works fine. However, if I do the following:- <CFSET WhereClause = &quot;Surname = 'Smith'&quot;> <CFQUERY name = etc etc> SELECT * From MyTable WHERE #WhereClause# </cfquery>...

I've tried that already and it just returns the actual fieldname, not the values stored in that field. I've just tried another approach, which is to write a custom tag that accepts the qSelect query as an object and recursively loops through it extracting each column value. Seems to have worked...

I want to build an application where users can select a datasource/table and query it. They will be able to select what fields they want to be displayed, and also what criteria they are looking for (ie. dynamically build a query). So, for each table I have a list of fields, and whether users...

Can't you construct your own buttons and have them refresh the page and send URL variables (eg onclick=window.location.href=page.cfm?sortval=asc), and then dynamically construct the 'order by' clause of the cfquery used to populate the cfgrid, based on the URL query string values? When you...

Hi guys I've got a COM object which takes a SQL statement, creates an excel spreadsheet, saves it, then throws back the path. I've got it working on a dev server fine but when I copy it to a live server I get the following message:- Disk or network error The error occured while processing an...