To Serve all the pages over https add this to the Application_BeginRequest method in your Global.asax file.
[vb]
Sub Application_BeginRequest(ByVal sender As Object, ByVal e As EventArgs)
If Request.IsSecureConnection = False Then
Dim ub As New UriBuilder(Request.Url)
ub.Scheme = Uri.UriSchemeHttps
ub.Port = 443
Response.Redirect(ub.Uri.ToString, True)
End If
End Sub
[/vb]
get a substring in SQL SERVER using space as separator
[sql]
SELECT CASE CHARINDEX(‘ ‘, news.description, 40)
WHEN 0 THEN news.description
ELSE SUBSTRING(news.description, 0, CHARINDEX(‘ ‘, news.description, 40) – 0)
END
AS FirstWord
FROM news
[/sql]
source:
http://www.dreamincode.net/forums/topic/239440-how-can-i-get-a-substring-in-sql-server-using-space-as-separator/
CHARINDEX (Transact-SQL) http://msdn.microsoft.com/pt-pt/library/ms186323.aspx
SUBSTRING (Transact-SQL)http://msdn.microsoft.com/en-us/library/ms187748.aspx
HTML5 Infographic by Ignite UI Infragistics Jquery Controls
source:
http://www.infragistics.com/community/blogs/marketing/archive/2012/11/27/infographic-html5-and-why-developers-need-it.aspx
How to do something like:
Proper(“GALHANO.COM”) = “Galhano.com”
there’s no builtin function to do this but we combine CONCAT and SUBSTRING:
[sql]CONCAT(UCASE(SUBSTRING(`fieldName`, 1, 1)),LOWER(SUBSTRING(`fieldName`, 2)))[/sql]
The Microsoft Enterprise Library is a collection of reusable software components (application blocks) designed to assist software developers with common enterprise development cross-cutting concerns (such as logging, validation, data access, exception handling, and many others). Application blocks are a type of guidance; they are provided as source code, test cases, and documentation that can be used “as is,” extended, or modified by developers to use on complex, enterprise-level line-of-business development projects.
Yahoo Condition Code
Condition codes are used in to describe the current conditions.
If you want to personalize conditions image icon, you must provide this set of icons:
Code Description
0 tornado
1 tropical storm
2 hurricane
3 severe thunderstorms
4 thunderstorms
5 mixed rain and snow
6 mixed rain and sleet
7 mixed snow and sleet
8 freezing drizzle
9 drizzle
10 freezing rain
11 showers
12 showers
13 snow flurries
14 light snow showers
15 blowing snow
16 snow
17 hail
18 sleet
19 dust
20 foggy
21 haze
22 smoky
23 blustery
24 windy
25 cold
26 cloudy
27 mostly cloudy (night)
28 mostly cloudy (day)
29 partly cloudy (night)
30 partly cloudy (day)
31 clear (night)
32 sunny
33 fair (night)
34 fair (day)
35 mixed rain and hail
36 hot
37 isolated thunderstorms
38 scattered thunderstorms
39 scattered thunderstorms
40 scattered showers
41 heavy snow
42 scattered snow showers
43 heavy snow
44 partly cloudy
45 thundershowers
46 snow showers
47 isolated thundershowers
3200 not available
This allows you to create your own custom icons.
<img src=”/img/{current_condition_code}.png”>
One of the most interesting that we have at Outlook.com is the ability to create email addresses associated with your personal account. Watch as they can.
What is YQL?The Yahoo! Query Language is an expressive SQL-like language that lets you query, filter, and join data across Web services. With YQL, apps run faster with fewer lines of code and a smaller network footprint.
Yahoo! and other websites across the Internet make much of their structured data available to developers, primarily through Web services. To access and query these services, developers traditionally endure the pain of locating the right URLs and documentation to access and query each Web service.
With YQL, developers can access and shape data across the Internet through one simple language, eliminating the need to learn how to call different APIs.
GUID – Globally Unique IDentifier
In Delphi, GUID values are represented with the TGuid record defined in the System unit. A Guid value is a 128-bit integer (16 bytes) that can be used in database applications when a unique identifier is required.
When developing database applications, the TGuidField is used to represents a guid field in a dataset.
[delphi]
procedure TForm1.btnGetGUIDClick(Sender: TObject);
var
Guid: TGUID;
begin
CreateGUID(Guid);
form1.label1.Caption := GUIDToString(Guid);
end;
[/delphi]
Home