Ok, cannot seem to get this to work. I get a stack overflow due to the IN
clause in the query. Microsoft says this is an issue with SQL2K and I need
to do the following...
<!---MS STUFF--->
CREATE TABLE #IN_values (au_id char(4))
INSERT INTO #IN_values select au_id FROM Table_with_values_123456789...
SELECT max(au_id)
FROM authors as A
JOIN #IN_values as I ON (A.au_id = I.au_id)
<!---MS STUFF--->
Here is the portion of my query that is breaking, but I am unsure of how to
write this out what MS is saying
SELECT #APPLICATION.DBPRE#Advertisements.AdID,
#APPLICATION.DBPRE#Advertisements.quantity_option,
#APPLICATION.DBPRE#Advertisements.MemberID,
#APPLICATION.DBPRE#MemberProfile.RscreenName,
#APPLICATION.DBPRE#Advertisements.CategoryID,
#APPLICATION.DBPRE#Advertisements.SCategoryID,
#APPLICATION.DBPRE#Advertisements.ItemPhoto,
#APPLICATION.DBPRE#Advertisements.title,
#APPLICATION.DBPRE#Advertisements.Price,
#APPLICATION.DBPRE#Advertisements.AQuantity,
#APPLICATION.DBPRE#Advertisements.State,
#APPLICATION.DBPRE#Advertisements.zipcode,
#APPLICATION.DBPRE#Advertisements.County,
#APPLICATION.DBPRE#Advertisements.City
FROM #APPLICATION.DBPRE#Advertisements
LEFT OUTER JOIN #APPLICATION.DBPRE#MemberProfile
ON #APPLICATION.DBPRE#Advertisements.MemberID =
#APPLICATION.DBPRE#MemberProfile.MemberID
WHERE BLAH BLAH BLAH
<CFIF IsDefined("form.zip") and form.zip neq 0 and
IsDefined("form.radius") and form.radius neq 0 and len(trim(form.zip)) eq 5>
AND ( #APPLICATION.DBPRE#Advertisements.zipcode IN
(#ListQualify(ValueList(results.zip),"'")#)
OR (#APPLICATION.DBPRE#Advertisements.city IN
(#listQualify(ValueList(results.city),"'")#)
AND #APPLICATION.DBPRE#Advertisements.State IN
(#listqualify(valuelist(results.State), "'")#)))
</CFIF>
Doug B.
----- Original Message -----
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[email protected]>
Sent: Tuesday, February 06, 2007 12:44 PM
Subject: Query error
> I get the following during a radius check on zipcodes when I choose say
500 miles from point x
>
> Internal Query Processor Error: The query processor ran out of stack space
during query optimization
>
> Any Ideas?
>
> Doug B.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268914
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
