Figer's Technology Consulting |

search engine optimization

8. December 2014 Lucas Comments (0)

Rather than re-write the topic I wanted to pass on this link which is a great beginners guide to SEO.


http://guides.seomoz.org/beginners-guide-to-search-engine-optimization

Emailing from PHP

8. December 2014 Lucas Comments (0)
about 98% of the time your web host will already have the php.ini file set up correctly so literally all it takes to email is this (if that's not the case look here:  http://www.php.net/manual/en/ref.mail.php#77499)

 
//Send Emails
$emailmessage = "Body of your message goes here, I put it in a variable because it's usually very long.";
mail($_POST[email], "Email Subject", $emailmessage , "From: no@no.com" . "\r\n" ."bcc: lucas.baran@figers.com");

SQL findtext - create a stored proc to find text in other stored procs

8. December 2014 Lucas Comments (0)
This stored proc has come in handy many times, great to use it to find text in other stored procedures
Once you've created this stored procedure in your environment of SQL it's as simple as running findText "findtextenteredhere"
-----------------------------------------------------------------
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE   PROCEDURE [dbo].[findText] (@text VARCHAR(50)) AS
--Declare @text varchar(50)
--set @text  = 'SmIepHeader'
-- Adjust search text to find all contains.
SET @text = '%' + @text + '%'
-- Declare general purpose variables.
DECLARE @line VARCHAR(300)
DECLARE @char CHAR
DECLARE @lineNo INTEGER
DECLARE @counter INTEGER
-- Declare cursor structure.
DECLARE @proc VARCHAR(50),
@usage VARCHAR(4000)
-- Declare cursor of stored procedures.
DECLARE codeCursor CURSOR
FOR
SELECT SUBSTRING(OBJECT_NAME(id),1,50) AS sproc,
text
FROM syscomments
WHERE text LIKE @text
-- Open cursor and fetch first row.
OPEN codeCursor
FETCH NEXT FROM codeCursor
INTO @proc,@usage
-- Check if any stored procedures were found.
IF @@FETCH_STATUS <> 0 BEGIN
PRINT 'Text ''' + SUBSTRING(@text,2,LEN(@text)-2) + ''' not found in stored procedures on database ' + @@SERVERNAME + '.' + DB_NAME()
-- Close and release code cursor.
CLOSE codeCursor
DEALLOCATE codeCursor
RETURN
END
-- Display column titles.
PRINT 'Procedure' + CHAR(39) + 'Line' + CHAR(9) + 'Reference ' + CHAR(13) + CHAR(13)
-- Search each stored procedure within code cursor.
WHILE @@FETCH_STATUS = 0 BEGIN
SET @lineNo = 0
SET @counter = 1
-- Process each line.
WHILE (@counter <> LEN(@usage)) BEGIN
SET @char = SUBSTRING(@usage,@counter,1)
-- Check for line breaks.
IF (@char = CHAR(13)) BEGIN
SET @lineNo = @lineNo + 1
-- Check if we found the specified text.
IF (PATINDEX(@text,@line) <> 0)
PRINT @proc + CHAR(39) + STR(@lineNo) + CHAR(9) + LTRIM(@line)
SET @line = ''
END ELSE
IF (@char <> CHAR(10))
SET @line = @line + @char
SET @counter = @counter + 1
END
FETCH NEXT FROM codeCursor
INTO @proc,@usage
END
-- Close and release cursor.
CLOSE codeCursor
DEALLOCATE codeCursor
RETURN

Dynamically adding controls to a placeholder control in ASP.NET

8. December 2014 Lucas Comments (0)
Loop through your collection of controls (count of i) you would like to add to the ASP.NET placeholder control on your aspx page.

Dim lnkButtonSelfInitiate As LinkButton = New LinkButton()
lnkButtonSelfInitiate.Text = vCellLocalLink.InnerText
AddHandler lnkButtonSelfInitiate.Click, AddressOf btn_Click
Me.plhSelfInitiate.Controls.Add(lnkButtonSelfInitiate)

Protected Sub btn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Me.lblTest.Text = "test"
End Sub

Launch a new window in ASP.NET on a button click using Javascript

8. December 2014 Lucas Comments (0)
The code is pretty simple, but it's nice to have this snippet around when you need it. 

 Dim ReportURL as string = "http://www.figers.com" 
 Dim js As String = "<script language=""javascript"" type=""text/javascript""> 

window.open('" & ReportURL & "');</script>" Page.ClientScript.RegisterClientScriptBlock(Me.GetType, "NewWindow", js)