This is interesting. It would seem contrary to normal browser behavior, that opening the dialog in Excel actually ignores existing sessions. If your app has a login page or session initialization code, you'll need to browse that page first in the new web query dialog first and then browse to the page you'd like to create a web query from.
Kola >> -----Original Message----- >> From: JAIME HOI [mailto:JHOI@;has.hitachi.com.sg] >> Sent: 06 November 2002 10:09 >> To: CF-Talk >> Subject: RE: Dump a SQL table into an Excel spreadsheet >> >> hi >> i was trying out this dumping of data into spreadsheet. >> >> Does it still work when the whole application is tied by session ? >> i tried but it gives me an error stating >> cannot open page. But when i tried it on the web browser, it can display >> the dynamic data. Any other way out? >> >> >> >> -----Original Message----- >> From: Kola Oyedeji [mailto:kola.oyedeji@;iclployalty.com] >> Sent: Wednesday, November 06, 2002 5:12 PM >> To: CF-Talk >> Subject: RE: Dump a SQL table into an Excel spreadsheet >> >> >> Liz >> >> Wow. Thanks for that. Looks like we've been re-inventing the wheel! >> >> >> Kola >> >> >> -----Original Message----- >> >> From: Les Mizzell [mailto:lesmizz@;bellsouth.net] >> >> Sent: 05 November 2002 17:51 >> >> To: CF-Talk >> >> Subject: RE: Dump a SQL table into an Excel spreadsheet >> >> >> >> :> What exactly are Excel web queries? I've heard Its an alternative >> but >> >> :> That's about all I know about it. >> >> >> >> >> >> 1. Open Excel (I'm using Office 2000 here....) >> >> 2. On the "data" menu and select "Get External Data" >> >> 3. Click "New Web Query" >> >> 4. Enter the address of the page that generates the data: >> >> http://www.mySite.com/EXCELGen.cfm >> >> >> >> Excel grabs the data from the page and automatically pops it right >> into a >> >> spreadsheet. Easy as pie. >> >> >> >> >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
