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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
CFQUERY an MS Access Query
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... -
CFQUERY an MS Access Query
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... -
CFQUERY an MS Access Query
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... -
CFQUERY an MS Access Query
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... -
convert to ms excel
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... -
convert to ms excel
I guess "fairly easy" 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... -
convert to ms excel
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... -
convert to ms excel
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... -
convert to ms excel
Is is possible to generate the *.xls file and allow the user to save it to the destination of their choice? -
Unexpected Login Errors-Especially 1st Time Logins
Are there any more suggestions? -
Unexpected Login Errors-Especially 1st Time Logins
If I understand what you mean by making sure the session variable is set, i.e., "HRappName", 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... -
Unexpected Login Errors-Especially 1st Time Logins
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="HR" sessionmanagement="Yes" sessiontimeout="#CreateTimeSpan(0,0,20,0)#"...
