Desperately trying to get someone else's code working on a new server for a charity. Here is the line of broken code:
The session.session_folder and session.sessionID variables still end up pointing to the old server. Any ideas on where to change this?
Code:
if type = "xls" then export_filename = chr(92) + chr(92) + appShareName + chr(92) + word(session.session_folder,4,"\\") + chr(92) + session.SessionID + chr(92) + "CustomerGuardians.csv" ofile = chr(92) + chr(92) + appShareName + chr(92) + word(session.session_folder,4,"\\") + chr(92) + session.SessionID + chr(92) + "temp.csv" columns = chr(92) + chr(92) + appShareName + chr(92) + word(session.session_folder,4,"\\") + chr(92) + session.SessionID + chr(92) + "columns.txt" destination = export_filename if a5_is_path_valid(chr(92) + chr(92) + appShareName + chr(92) + word(session.session_folder,4,"\\") + chr(92) + session.SessionID) sql = "sp_rpt_Export_CustomerGuardians '" + ofile + "', '" + columns + "', '" + destination + "', '" + fltr + "', '" + session.database + "', '" + sort + "'" conn.open() conn.execute(sql) sleep(1) if file.exists(destination) = .f. then conn.execute(sql) end if while file.exists(destination) = .f. end while conn.close() response.redirect(session.session_url + "CustomerGuardians.csv?" + time("hms3")) end else ? "Path is not valid - cannot create file<br>" end end if end if
Comment