Search results for query: *

They are.

Rudy, At one point I thought that it was choking on the SSN field because both original tables (AccHistory and AccInjLog) used the same name field, SSN. So I changed the name in AccHistory to iSSN so now each table has field names which do not match. However, as you know, it still throws the...

r937 & bombboy, I changed the query to read: <cfquery name="getAtRisk" datasource="ARENA" dbtype="ODBC"> SELECT AccidentDate, SSN, AccType FROM getAggregateAccComposite; </cfquery> These are the only three fields I need to see. This is a UNION query in Access. The exact error is...

r937, What doesn't work is the result. It throws the error, fieldname does not exist. If I copy the result of the Access query I'm querying from CF into an *table* and use the same syntax it works fine. I just can't figure this out. bombboy, Although my CFQUERY is much simplier than the...

I think I remember doing this before with earlier versions of CF but I'm having trouble querying an Access query with MX. I want to do this because I'm trying to offload some aggregate processing to the database hoping to make the app more efficient. Isn't the syntax the same to query a query...

Hi carl, I'm sorry too, I just returned from my vacation, hope yours was as good as mine. You write: I'm confused. Is the file opening in the Excel control, or are you getting the prompt dialog immediately? If you're getting the prompt dialog (to open or save)... it sounds like you don't have a...

I guess &quot;fairly easy&quot; is relative :-) I could not glean enough from the article and code at the site to make it run error free for me. I kept getting 'COM' errors. Once I got errors on my server that I believe were in response to this code. I'm sure it's something I didn't do...

Okay, Carl, I've given up on opening the file in Excel in lieu of opening an Excel spreadsheet in an I.E browser window as you suggest. I'm attempting to use the example you give as my users use Office 97 or greater (or did you mean *greater than* '97? Hmmm. Does that mean that this code will...

Sorry, Carl, I should have told you I am using mimi2's example code because my users need to open the file in Excel not in the browser. It works fine except it is not practical for the user, as the code will write and append data to an Excel file in the destination of the programmer's choice...

Is is possible to generate the *.xls file and allow the user to save it to the destination of their choice?

Are there any more suggestions?

If I understand what you mean by making sure the session variable is set, i.e., &quot;HRappName&quot;, it is, I think. This error will not happen after the first time logging in. In other words, once the user logs in for the first time EVER, say, today, he can log in tomorrow or the next day and...

I'm using a login page that works fairly efficiently AFTER users have been 'helped' by me to get logged in properly for the first time. Here is application.cfm: <cfapplication name=&quot;HR&quot; sessionmanagement=&quot;Yes&quot; sessiontimeout=&quot;#CreateTimeSpan(0,0,20,0)#&quot...