SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
SI - Site Forums : Silicon Investor - Welcome New SI Members! -- Ignore unavailable to you. Want to Upgrade?

To: SI Dave who wrote (21537)10/8/2004 9:29:49 PM
From: Jeffrey S. Mitchell  Respond to of 32873
 
all of good Irish folks visiting their my_account with an alias of O'Sullivan or O'Connor or O'Leary and so on may suddenly find themsleves to be just plain old O.

Same problem if you do a search on, say, O'Sullivan. You will just get finds of plain old O as well. That's one step better than Ihub where doing a similar search will cause an error message. The joys of SQL.

- Jeff



To: SI Dave who wrote (21537)10/8/2004 11:54:30 PM
From: Jeffrey S. Mitchell  Read Replies (1) | Respond to of 32873
 
Dave, I should have mentioned that to fix the alias apostrophe problem you probably just have to replace any apostrophes with a set of them (the first one tells SQL to *not* treat the second one as an end of string marker) when saving to the database. For example:

strMy_Account = replace(strMy_Account," ' "," ' ' ")

- Jeff


HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News