I have a list of comma seperated numbers in a field in my database. I would
like to retrieve this list of numbers, which are primary keys to other
tables) and loop through them, running a query for each number(key). Here's
what I have:
----- snip -----
<CFQUERY name="qryGetKidsFromParentsID" datasource="Gymtime">
SELECT emer_ref FROM contact WHERE contact_id = #URL.sel#
</cfquery>
----- snip -----
<CFLOOP index="varLoopKidIDFromParentRelationships"
list="qryGetKidsFromParentsID.emer_ref" delimiters=",">
----- snip -----
The error I am getting is this:
----- -----
ODBC Error Code = S0002 (Base table not found)
[Sybase][ODBC Driver][Adaptive Server Anywhere] Table or view not found:
Correlation name 'qryGetKidsFromParentsID' not found
----- -----
The list="Query.Value" sounds good in theory, but I'm sure I'm doing it way
wrong. Any suggestions?
Thanks,
Todd Ashworth
---------------------------------
Saber Corporation
Web Application Development
www.sabersite.com
(803) 327-0137 [111]
(803) 328-2868 (fax)
------------------------------------------------------------------------------
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.
