Hi Teddy, > 2) > > You are missing a # symbol by the word application: > > <cfquery name="ckCreds" datasource="Application.dsn#"> > > should be > > <cfquery name="ckCreds" datasource="#application.dsn#">
Makes no difference, I still get an application.dsn doesn't exist message > 3) > > For: > WHERE LocationID = <Cfqueryparam > cfsqltype="cf_sql_varchar"value="#form.user#"> > > Is the locationID column an integer in your database or a varchar? > If it is > an integer: > > WHERE LocationID = <Cfqueryparam > cfsqltype="cf_sql_integer"value="#form.user#"> Varchar Anymore thoughts? -jason ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260503 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
