On Thu, 23 Sep 2004 01:12:06 -0400, dave <[EMAIL PROTECTED]> wrote:
> anyone tell me why this chokes when i add cfqueryparam to it?
>
> <!--- set form variables --->
> <cfset Ausername = #trim(form.username)#>
> <cfset Apassword = #trim(form.password)#>
>
> <!--- check the username & passord for correct login --->
> <cfquery name="qLogin" datasource="#dsn#" username="#un#" password="#pw#">
> SELECT username, password, roles
> FROM admin
> WHERE username = <cfqueryparam value="#Ausername#" cfsqltype="cf_sql_varchar">
> AND password = <cfqueryparam value="#Apassword#" cfsqltype="cf_sql_varchar">
> </cfquery>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
