Never mind. They've got three similar fields and I compared the wrong ones. &[EMAIL PROTECTED]@#$% I cant bill them for my blond time now can I? DRE
On 6/28/05, DRE <[EMAIL PROTECTED]> wrote: > Well, the ids are always 8 chars long so the commas arent really > neccessary. I switched the fieldnames for easier readability and the > data structure is fixed. > > However it just doesnt seem to work. > > I wonder if the var char fieldlength has anything to do with it. . . > > Any other thoughts? > DRE > > On 6/28/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > > SELECT > > > id, > > > listofids > > > FROM > > > gv_locations > > > WHERE > > > ',' + listofids + ',' LIKE '%' + id + '%' > > > > > But neither returns any records. > > > > > Any ideas? > > > > This would be the one I would use except, you need commas in your like > > statement... > > > > where ',' + listofids + ',' LIKE '%,' + id + ',%' > > > > the column names are horrid... assuming they're real column names... > > and the data structure is undesirable... But with or without the > > commas, I don't know why this query would produce zero records if the > > id is found in the listofids column -- I can't see any reason why it > > wouldn't return the appropriate records. > > > > s. isaac dealey 954.522.6080 > > new epoch : isn't it time for a change? > > > > add features without fixtures with > > the onTap open source framework > > > > http://www.fusiontap.com > > http://coldfusion.sys-con.com/author/4806Dealey.htm > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210838 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54