Having trouble with a dynamic query - I think I have been staring at it too
long... and have outstretched what little knowledge I have in these matters.
Essentially I do this:
<!--- Get the Search 1 --->
<cfquery name="qryGetSearchType1" datasource="#datasource#"
username="#username#" password="#password#">
SELECT
#ColID1#
FROM
#TableSearch1#
WHERE
#ColDesc1# = "#FORM.SearchValue1#"
</cfquery>
This Query Works just fine - the variable are sent from a dynamic Combo Box.
(Found on this site http://www.mattkruse.com/javascript/dynamicoptionlist/)
And THEN - I need the result of the Query - which should only be ONE record. A
Number!
And I am attempting to set it like:
<cfset S1 = "qryGetSearchType1.#ColID1#">
But that returns qryGetSearchType1.NationalID
Which as you know is NOT a Number.
Help me Obe Wan Kenobes - your my only hope!
-Nick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1353
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
