[thelist] CF / SQL problem

scott,

:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: <Scott_Brady@themoneystore.com>
:
: <cfset qryString = "SELECT * FROM mailcodeTB, divisionTB, stateTB,
sacramentoTB
: WHERE mailcodeTB.divisionID = divisionTB.divisionID AND mailcodeTB.stateID
=
: stateTB.stateID AND mailcodeTB.sacID = sacramentoTB.sacID">
: <cfswitch expression="#department#">
:      <cfcase value=" ">
:      </cfcase>
:      <cfdefaultcase>
:           <cfset qryString = Insert(" AND mailcodeTB.department LIKE
: '#department#%'", qryString, Len(qryString))>
:      </cfdefaultcase>
: </cfswitch>
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

is that a stray % in there?  other than that i can't see anything
particularly wrong with the query you're trying to generate.

hope this helps somehow,

: jeff.howden
: web.development.professional
: evolt.org.member
:
: the.best.looking.developers.on.the.net
:
: http://evolt.org/
: jeff@members.evolt.org