On 9/5/00, Miriam Hirschman penned:
><cfquery name="qryGetProgram" datasource="#Application.settings.dsn#"
>dbtype="ODBC">
Where are you setting application.settings.dsn? What are you using
for the datasource name on the second page? If you are using
application.settings.dsn as the datasource name for both queries, and
if that is supposed to change dynamically, depending on which page
you are accessing (which by the way, would probably be a bad use of
application variables) and it's not changing until AFTER you access
the second query, then that would explain why it doesn't access the
correct datasource until you click the 2nd time, AFTER the
application variable is updated.
Try entering the datasource names manually in both queries and see
what happens.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
