the search field could be a first name, id date, whatever. i am doing the 0=0 to return all records if nothing is passed. then will check to see if it numeric, if it is they will be looking up an ID. if there is a similar id, return that set..
say our ids have 123456789 charecters. i just want to see any that contain 6789 that would give me say 12 results. or i could just put in ihrig to go staright to my record. i know i have done this befor, but will take hours going through old cd's to find old code.. will look at it agin in the mormnning. am sure it has some thing to do with converting the query clientID to a string of some sore & then just doing a like on it.. man.. -paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
