Wednesday, December 19, 2007

HTML tutorial - Image maps

HTML tutorial - Image maps



alt="Beech hut" title="Beech hut - where you get changed">

alt="Life ring" title="Life ring - to help you swim">
alt="Flag" title="Flag - says if it safe to swim">






www.svdeals.com

Monday, November 26, 2007

Page 2 - Configuring a Linked Microsoft Access Server on SQL 2005 Server

Page 2 - Configuring a Linked Microsoft Access Server on SQL 2005 Server: "Configuring a Linked Microsoft Access Server on SQL 2005 Server - Linked Servers on SQL 2005 Server "



exec sp_addlinkedserver @server='AccessDb',
@srvproduct='Access',
@provider='Microsoft.Jet.OLEDB.4.0',
@datasrc='C:\data\Categories.mdb'

www.svdeals.com super value deals

Saturday, November 24, 2007

Using Queries to Convert Text Fields to Numerics

Using Queries to Convert Text Fields to Numerics: "Using Queries to Convert Text Fields to Numerics"


CDbl("3.2") =3.2

CDbl([MyField]) -->>>If MyField contains "3.2", 3.2If MyField contains "ABCD", a Type Mismatch error occurs

Friday, September 7, 2007

Thursday, September 6, 2007

Auto save download Archive website, Save web pages programmatically as .HTML asp.net

Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
SavePage("http://localhost/tstProj/scrapage.aspx", "c:\scrapage.html")
End Sub
Private Sub SavePage(ByVal Url As String, ByVal FilePath As String)
Dim iMessage As CDO.Message = New CDO.Message
iMessage.CreateMHTMLBody(Url, _
CDO.CdoMHTMLFlags.cdoSuppressNone, "", "")
Dim adodbstream As ADODB.Stream = New ADODB.Stream
adodbstream.Type = ADODB.StreamTypeEnum.adTypeText
adodbstream.Charset = "US-ASCII"
adodbstream.Open()
iMessage.DataSource.SaveToObject(adodbstream, "_Stream")
adodbstream.SaveToFile(FilePath, _
ADODB.SaveOptionsEnum.adSaveCreateOverWrite)
End Sub
End Class


For the above to compile you will need to add a reference to CDO, which is usually found sneaking deep in your C:\WINNT\System32 as C:\WINNT\System32\cdosys.dll


www.visli.com hot cake deals