Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Argus
-
CFCONTENT Excel error
When I use CFCONTENT it displays excel files as "ÐÏࡱá>þÿ ....etc". I tested a gif and it came up fine. The code I am using is:- <cfcontent deletefile="no" file="d:/data/mysheet.xls" type="application/msexcel"> Pretty straightforward I think. Any... -
Dynamic Query - Incorrect Syntax
Thank you once again. I really should have known that - it's been a long day.... -
Dynamically building select box
Brilliant! Thanks for that. Exactly what I needed. -
Dynamic Query - Incorrect Syntax
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 = "Surname = 'Smith'"> <CFQUERY name = etc etc> SELECT * From MyTable WHERE #WhereClause# </cfquery>... -
Dynamically building select box
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... -
Dynamically building select box
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... -
Sorting in a CFGRID
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... -
CFSET/COM Error
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...
