Lost In Space: May 2008



jQuery Modal Dialog

Friday, May 23, 2008
SimpleModal: 10.6kb(Full), 3.6 kb (minified), 2.8 kb(Packed)
impromptu: 6kb, 4 star / 10 reviews,
nyroModal: 36 kb(Full), 24 kb (minified), 13 kb(Packed), 4 star / 6 reviews
jQuery UI:
version: 1.5 beta 4,
ui.base.js(I cannot find it, found ui.dialog.js and ui.core.js)
test ui.dialog.html, error
jDialog: 5 kb, 3 kb (min), 4 star / 4 reviews
PopupWindow: 5 kb, 4 star / 4 reviews
jqModal: 4 kb
jBox:

reviews:
Best plugin for modal dialogs
The best Web 2 jQuery javascript plugins: jqModal +
scroco's Best jQuery Plugins:
jQuery plugins for the SEO: jqModal +
jQuery: Floating Dialog Windows:
Form Plugin
Interface Plugin
jqModal example for site exit surveys:
Creating Modal "Please Wait..." Dialog Boxes with jqModal jQuery Plugin:
Popup Master-Detail using GridView, DetailsView and jQuery with jqModal:
A Simple Modal:


Misc:
MODALPREVIEW: textarea only

IDENTITY Column in SQL Server

Monday, May 12, 2008

How to sort string as number?

Saturday, May 10, 2008

How To Convert String to Numeric for Sorting?


Dealing with embedded sort orders in SQL
from the comments, come a good one:
SELECT*
FROM TestSort
ORDER BY CONVERT(int,
SUBSTRING(CodeToSort,2,
PATINDEX('%[^0-9]%',
SUBSTRING(CodeToSort,2,200)+'|')-1))

PATINDEX: returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.
RIGHT
|

not sort a10z after a10x

so
SELECT *
FROM TestSort
ORDER BY CONVERT(int,
SUBSTRING(CodeToSort,2,
PATINDEX('%[^0-9]%',
SUBSTRING(CodeToSort,2,200)+'|')-1)),
RIGHT(CodeToSort,
PATINDEX('%[0-9]%',
REVERSE(CodeToSort))-1)

jQuery

Easiest Tooltip and Image Preview using jQuery
Example 1: the simplest jQuery Tooltip Ever
good for help,
Easy DOM creation for jQuery and Prototype (read comments later)
jQuery-dom.js
how about create a big table, how about the performance
jQuery Ajax call and result XML parsing