At 06:15 PM 7/24/2001 -0700, you wrote:
>hie..
> I need you guys help...
> I have developed a search engine page.Can u you guys
>help me in giving the syntax?
>For example...if i want to search a specific name n do
>not know the full name...I wil just type "mel" and the
>list will list down all the name that have "mel" in
>it.
>
>
>This is my syntax:
>
> <CFQUERY NAME ="CustomerIC" datasource ="test" >
>Select *
> from iProfile
> where C_ICNo Like '%"
> Order by C_Name
> </CFQUERY>
Select *
from iProfile
where C_ICNo Like '%#username#%'
Order by C_Name
Now available in a San Francisco Bay Area near you!
http://63.74.114.11/mr_urc/index.cfm
http://63.74.114.11/mr_urc/resume.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
