cfqueryparam works just fine.
Something like this:
<cfquery datasource="#request.dsn#" name="qUsers">
SELECT username, dep_code
FROM username
WHERE ',' + dep_code + ',' LIKE <cfqueryparam cfsqltype="cf_sql_varchar"
value="%,#searchvariable#,%">
</cfquery>
<cfquery datasource="#request.dsn#" name="qDpt">
SELECT dpet_id, name
FROM department
</cfquery>
<cfset stDpt = StructNew()>
<cfloop query="qDpt">
<cfset stDpt[qDpt.dpet_id] = qDpt.name>
</cfloop>
<cfoutput query="qUsers">
#qUsers.username#<br>
<ul>
<cfloop list="#qUsers.dep_code#" index="i">
<cfif StructKeyExists(stDpt,i)>
<li>#stDpt[i]#</li>
<cfelse>
<li>#i#</li>
</cfif>
</cfloop>
</ul>
</cfoutput>
Pascal
> -----Original Message-----
> From: vishnu prasad [mailto:[EMAIL PROTECTED]
> Sent: 08 October 2004 13:49
> To: CF-Talk
> Subject: Re: Urgent:coldfusion report
>
> Hi
>
> i cannot change the DB design ,i have to do with the current DB
Structure
> noproblem if the query take time ,without using cfqueryparam i am
using
> 4.5 so i cannot use cfqueryparam
>
> regards
> Vishnu Prasad
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
