Hi there!
sorry to bother you, but I figure I would get a quicker response this way
than through the list:
I have a form which receives a URL variable EmplID.
I then select a record from two tables PeoplesoftEmpView and
AbscenceEmpView.(qryPeoplesoftEmpView and another query called
qryAbscenceEmpView)
If the Effective date (effdt) on Peoplesoft is Greater Than the Effective
Date on EmpView, then I want to use the information returned from
qryPeoplesoftEmpView to display for user to edit.
Otherwise I want to display the data in qryAbscenceEmpview to the user.
I am using a simple CFFORM with CFINPUT tags and one CFSELECT statement.
I have no idea how to specify which query the CFFORM gets its data from :-\
I tried enclosing the CFFORM tags with a <CFOUTPUT
query="qryPeoplesoftview"> but that didn't work.
Can you help?
-Gel
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.
