I am having some issues with security on an application.  I want to make 
the user log into the database.  I have separate accounts for each user.  I 
am trying to run the below code, but naturally it wants a datasource.  Well 
I don't have one.  Does anyone know how I can do something like below? 
.....where the preceding page is a login form.

<cfquery
      name="getUserInfo"
      dbtype="Oracle80"
      username="#form.username#"
      password="#form.password#"
      dbserver="qtengdev"
      dbname="knowledge">

select * from employees

</cfquery>


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to