Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Hierarchical SQL Select
Message
 
 
To
07/09/2009 14:31:34
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01422513
Message ID:
01422976
Views:
32
>
>(((http[s]?|ftp)://)|(www\.))[\w/.()-]+[\w/.(-]
>
>
>if you need two patterns, you can make one
>
>I would not treat aspx as a special case, who says () are not allowed in htm/html ?

The pattern above allows spaces inside the HTML string, which is incorrect. In addition, this www.test would also show as HTML.

BTW, VFP itself also incorrectly recognizes www.something as valid HTML, but it doesn't recognize http://msdn.microsoft.com/en-us/library/aa172799(SQL.80).aspx
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform