Viewing 6 posts - 1 through 6 (of 6 total)
chadmat, I actually came up with a workaround last night. It's a little more code, but it seems to give me the results I'm looking for. As for...
April 29, 2003 at 6:54 am
A follow-up: the CASE statement does not cause any errors when there is only 1 when clause:
<cfif parameterexists(form.ziplist)>
CASE len(OrganizationPostalCode)
WHEN 6 THEN left(OrganizationPostalCode,3)
ELSE left(OrganizationPostalCode,5)
END IN (#preservesinglequotes(form.ziplist)#) AND
</cfif>
When I add in the...
April 28, 2003 at 8:09 am
Allen_Cui, the live server has all the latest service packs running. I have narrowed the problem down to using a CASE statement. Below is the part of my...
April 28, 2003 at 7:15 am
Hello chadmat. Thank you for the reply. I think you are correct that it is a bug in SQL Server. I recreated the final search table in...
April 27, 2003 at 2:12 pm
5409045121009, thank you for the suggestion, unfortunately, I am running off of two different databases. The zip codes are under a MS Access datasource, and the member data is...
April 27, 2003 at 1:14 pm
I have narrowed it down to 2185 items in the list being the magic number that the system dumps. Any search that uses a zip code list that contains...
April 26, 2003 at 1:45 pm
Viewing 6 posts - 1 through 6 (of 6 total)