Monie

ASP Programming Tips and Technique

Posted Oct 26th, 2007 at 06:37 by Monie
Updated Nov 1st, 2007 at 08:05 by Monie

[ Option Explicit ]

<% Option Explicit %>
It is usually placed at the top of your asp page.
Option Explicit requires that all variable names be declared (with the Dim statement). Using Option Explicit to force variable declaration is good for a number of reasons.
Using Option Explicit forces you to declare all your variables before you use them. If you use a variable you haven't declared then an error

...

Monie

Most Reputable Member

Posted in ASP Programming Tips

Comments 0 Monie is offline

Usefull Programming Code

Posted Oct 17th, 2007 at 04:17 by Monie
Updated Nov 1st, 2007 at 07:52 by Monie

[MySQL Database Connection and Recordset (DNS-LESS Connection)]

<%
Dim connectionString, conn, rs
connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=mydatabase; OPTION=4; UID=root;PASSWORD=mypassword;"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open(connectionString)
Set rs = conn.Execute("SELECT * FROM userlist")
%>

Another way to...

Monie

Most Reputable Member

Posted in Useful Programming Code

Comments 0 Monie is offline

Archive
< > July 2008
Su	Mo	Tu	We	Th	Fr	Sa
22	23	24	25	26	27	28
29	30	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31	1	2

		Webforumz.com > Blogs
Monie