WebForumz.com

ASP Programming Tips and Technique

Posted October 26th, 2007 at 03:37 AM by Monie
Updated November 1st, 2007 at 06:05 AM 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 October 17th, 2007 at 01:17 AM by Monie
Updated November 1st, 2007 at 05:52 AM 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
< > November 2009
Su	Mo	Tu	We	Th	Fr	Sa
25	26	27	28	29	30	31
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	1	2	3	4	5