Pages

Sunday, December 23, 2012

ASCII Characters and Symbols

Posted by Unknown at 7:48 AM 0 comments
Every so often I find that I need to place a special character and I just don't remember the coding.  I've usually had to Google around and look at multiple sites before finding the character I want. So I decided to compile a comprehensive list and put it here for easy reference.

CHR(#)HTML EntitySymbol
chr(160) 
chr(161)¡¡
chr(162)¢¢
chr(163)££
chr(164)¤¤
chr(165)¥¥
chr(166)¦¦
chr(167)§§
chr(168)¨¨
chr(169)©©
chr(170)ªª
chr(171)««
chr(172)¬¬
chr(173)­­
chr(174)®®
chr(175)¯¯
chr(176)°°
chr(177)±±
chr(178)²²
chr(179)³³
chr(180)´´
chr(181)µµ
chr(182)¶
chr(183)··
chr(184)¸¸
chr(185)¹¹
chr(186)ºº
chr(187)»»
chr(188)¼¼
chr(189)½½
chr(190)¾¾
chr(191)¿¿
chr(192)ÀÀ
chr(193)ÁÁ
chr(194)ÂÂ
chr(195)ÃÃ
chr(196)ÄÄ
chr(197)ÅÅ
chr(198)ÆÆ
chr(199)ÇÇ
chr(200)ÈÈ
chr(201)ÉÉ
chr(202)ÊÊ
chr(203)ËË
chr(204)ÌÌ
chr(205)ÍÍ
chr(206)ÎÎ
chr(207)ÏÏ
chr(208)ÐÐ
chr(209)ÑÑ
chr(210)ÒÒ
chr(211)ÓÓ
chr(212)ÔÔ
chr(213)ÕÕ
chr(214)ÖÖ
chr(215)××
chr(216)ØØ
chr(217)ÙÙ
chr(218)ÚÚ
chr(219)ÛÛ
chr(220)ÜÜ
chr(221)ÝÝ
chr(222)ÞÞ
chr(223)ßß
chr(224)àà
chr(225)áá
chr(226)ââ
chr(227)ãã
chr(228)ää
chr(229)åå
chr(230)ææ
chr(231)çç
chr(232)èè
chr(233)éé
chr(234)êê
chr(235)ëë
chr(236)ìì
chr(237)íí
chr(238)îî
chr(239)ïï
chr(240)ðð
chr(241)ññ
chr(242)òò
chr(243)óó
chr(244)ôô
chr(245)õõ
chr(246)öö
chr(247)÷÷
chr(248)øø
chr(249)ùù
chr(250)úú
chr(251)ûû
chr(252)üü
chr(253)ýý
chr(254)þþ
chr(255)ÿÿ
chr(34)""
chr(38)&&
chr(60)&lt;<
chr(62)&gt;>
chr(39)&apos;'
chr(338)&OElig;Œ
chr(339)&oelig;œ
chr(352)&Scaron;Š
chr(353)&scaron;š
chr(376)&Yuml;Ÿ
chr(710)&circ;ˆ
chr(732)&tilde;˜
chr(8194)&ensp; 
chr(8195)&emsp; 
chr(8201)&thinsp; 
chr(8204)&zwnj;‌
chr(8205)&zwj;‍
chr(8206)&lrm;‎
chr(8207)&rlm;‏
chr(8211)&ndash;–
chr(8212)&mdash;—
chr(8216)&lsquo;‘
chr(8217)&rsquo;’
chr(8218)&sbquo;‚
chr(8220)&ldquo;“
chr(8221)&rdquo;”
chr(8222)&bdquo;„
chr(8224)&dagger;†
chr(8225)&Dagger;‡
chr(8240)&permil;‰
chr(8249)&lsaquo;‹
chr(8250)&rsaquo;›
chr(8364)&euro;€
chr(402)&fnof;ƒ
chr(913)&Alpha;Α
chr(914)&Beta;Β
chr(915)&Gamma;Γ
chr(916)&Delta;Δ
chr(917)&Epsilon;Ε
chr(918)&Zeta;Ζ
chr(919)&Eta;Η
chr(920)&Theta;Θ
chr(921)&Iota;Ι
chr(922)&Kappa;Κ
chr(923)&Lambda;Λ
chr(924)&Mu;Μ
chr(925)&Nu;Ν
chr(926)&Xi;Ξ
chr(927)&Omicron;Ο
chr(928)&Pi;Π
chr(929)&Rho;Ρ
chr(931)&Sigma;Σ
chr(932)&Tau;Τ
chr(933)&Upsilon;Υ
chr(934)&Phi;Φ
chr(935)&Chi;Χ
chr(936)&Psi;Ψ
chr(937)&Omega;Ω
chr(945)&alpha;α
chr(946)&beta;β
chr(947)&gamma;γ
chr(948)&delta;δ
chr(949)&epsilon;ε
chr(950)&zeta;ζ
chr(951)&eta;η
chr(952)&theta;θ
chr(953)&iota;ι
chr(954)&kappa;κ
chr(955)&lambda;λ
chr(956)&mu;μ
chr(957)&nu;ν
chr(958)&xi;ξ
chr(959)&omicron;ο
chr(960)&pi;π
chr(961)&rho;ρ
chr(962)&sigmaf;ς
chr(963)&sigma;σ
chr(964)&tau;τ
chr(965)&upsilon;υ
chr(966)&phi;φ
chr(967)&chi;χ
chr(968)&psi;ψ
chr(969)&omega;ω
chr(977)&thetasym;ϑ
chr(978)&upsih;ϒ
chr(982)&piv;ϖ
chr(8226)&bull;•
chr(8230)&hellip;…
chr(8242)&prime;′
chr(8243)&Prime;″
chr(8254)&oline;‾
chr(8260)&frasl;⁄
chr(8472)&weierp;℘
chr(8465)&image;ℑ
chr(8476)&real;ℜ
chr(8482)&trade;™
chr(8501)&alefsym;ℵ
chr(8592)&larr;←
chr(8593)&uarr;↑
chr(8594)&rarr;→
chr(8595)&darr;↓
chr(8596)&harr;↔
chr(8629)&crarr;↵
chr(8656)&lArr;⇐
chr(8657)&uArr;⇑
chr(8658)&rArr;⇒
chr(8659)&dArr;⇓
chr(8660)&hArr;⇔
chr(8704)&forall;∀
chr(8706)&part;∂
chr(8707)&exist;∃
chr(8709)&empty;∅
chr(8711)&nabla;∇
chr(8712)&isin;∈
chr(8713)&notin;∉
chr(8715)&ni;∋
chr(8719)&prod;∏
chr(8721)&sum;∑
chr(8722)&minus;−
chr(8727)&lowast;∗
chr(8730)&radic;√
chr(8733)&prop;∝
chr(8734)&infin;∞
chr(8736)&ang;∠
chr(8743)&and;∧
chr(8744)&or;∨
chr(8745)&cap;∩
chr(8746)&cup;∪
chr(8747)&int;∫
chr(8756)&there4;∴
chr(8764)&sim;∼
chr(8773)&cong;≅
chr(8776)&asymp;≈
chr(8800)&ne;≠
chr(8801)&equiv;≡
chr(8804)&le;≤
chr(8805)&ge;≥
chr(8834)&sub;⊂
chr(8835)&sup;⊃
chr(8836)&nsub;⊄
chr(8838)&sube;⊆
chr(8839)&supe;⊇
chr(8853)&oplus;⊕
chr(8855)&otimes;⊗
chr(8869)&perp;⊥
chr(8901)&sdot;⋅
chr(8968)&lceil;⌈
chr(8969)&rceil;⌉
chr(8970)&lfloor;⌊
chr(8971)&rfloor;⌋
chr(9001)&lang;⟨
chr(9002)&rang;⟩
chr(9674)&loz;◊
chr(9824)&spades;♠
chr(9827)&clubs;♣
chr(9829)&hearts;♥
chr(9830)&diams;♦
Continue reading →
Tuesday, December 11, 2012

Finding Occurrences of a Word in MSSQL Stored Procedures

Posted by Unknown at 10:06 PM 0 comments

Here's a little trick that slipped my mind until I needed to search through about 2400 SPs looking for a specific word.
The query is very simple, and it returns a listing of all of the SPs with the word you're looking for.
It's just another one of those 'you don't know what you've forgotten until you need it' things.
SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE '%foobar%' 
    AND ROUTINE_TYPE='PROCEDURE'
Continue reading →

RSS in Coldfusion

Posted by Unknown at 9:53 PM 0 comments
ColdFusion Logo
Faster isn't always better, but sometimes it is.

Using the CFFEED tag, I set up an RSS feed on a site in less than 5 minutes. The coding is dead simple and about as straight forward as you can get.

I have a CMS set up so that my content editors can add news items to the site. When they save the new item, the code below fires off and updates the RSS feed

<!--- pull the 20 latest items --->
<cfquery name="getFeedDetails" datasource="#application.db#">
SELECT     TOP (20) ID, Title, NewsText, NewsDate, linkData
FROM         myNewsTable
ORDER BY NewsDate DESC 
</cfquery>

<!--- Set up the structure with the feed meta data --->
<cfscript>
myStruct = StructNew();
mystruct.link = "http://foobar.com";
myStruct.title = "FooBar News";
mystruct.description = "The authoritative online resource on how much wood a 
woodchuck would chuck if a woodchuck would chuck wood.";
mystruct.pubDate = Now();
mystruct.version = "rss_2.0";

// Map the orders column names to the feed query column names.
columnMapStruct = StructNew();
columnMapStruct.publisheddate = "NEWSDATE"; 
columnMapStruct.content = "NEWSTEXT"; 
columnMapStruct.title = "TITLE"; 
columnMapStruct.rsslink = "LINKDATA";
</cfscript>

<!--- Create the feed --->
<cffeed action = "create"
query= "#getFeedDetails#"
properties="#mystruct#"
columnMap="#columnMapStruct#"
outputFile = "myRSS.xml" 
overwrite = "yes"
xmlVar = "myXML">
That's all there is to it. myRSS.xml is a properly formatted feed file.
Continue reading →
Wednesday, January 4, 2012

NTEXT and Truncation Errors on Delete

Posted by Unknown at 12:49 AM 0 comments
A quick note to the MS SQL users here with a reminder to help you avoid a little gotcha. The NTEXT data type was deprecated in MSSQL 2005. So, if you've migrated a db up to SQL 2005 or 2008 and, if you try to delete records in a table with an NTEXT field from the data grid view, you'll get an error telling you that the data will be truncated, and the delete won't work. You gotta delete through a query.

Funny what you don't recall if you don't use it often.
Continue reading →
Subscribe to: Posts (Atom)

Labels

 

Technologified © 2011 deWolfe