Here is what I am trying to achieve...
var SearchItem = SelectClientNum.selectedItem.data
<cfquery name="GetTheDarnName" datasource="PaceCareData">
SELECT BasicInfo.IDID, IDNo, Identity.ID,
(Trim(Identity.LastName)+", "+Trim(Identity.FirstName)+"
"+Trim(Identity.MI)) AS FullName
FROM (BasicInfo
INNER JOIN Identity ON BasicInfo.IDID = Identity.ID)
WHERE IDNo = '#SearchItem#'
</cfquery>
I can't seem to get #SearchItem# to equal the value of
SelectClientNum.selectedItem.data
Further in my code I can reference SelectClientNum.selectedItem.data and
it is correct.
How do I refer to an ActionScript variable within a <CFQUERY>???
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete it from
your system.
This footnote also confirms that this email message has been swept for
the presence of computer viruses.
Thank You,
Viahealth
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211634
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
