[thelist] CF / SQL problem

Scott_Brady@themoneystore.com wrote:

> <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>

Where is department being passed in through? A form?(#form.department#)
or URL?(#url.department#)

I can't see where its passing a value to #department# ?

.djc.