At 12:35 9/28/00 -0400, you wrote:
>is this correct or am i missing something?
>
>select *
>from tbl
>where <cfif isdefined(")>
>       id = #id#
>       </cfif>
>       or
>       <cfif isdefined(")>
>       name = #name#
>       </cfif>

I think that would error out if they are not both defined, you
would end up with 

select *
from tbl
where or name = #name#'

Plus I have no idea what isdefined(<double quote>) means...

RPS


------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to