Coders Corner at Lerudi Consulting

Classic ASP, webshops and chicken pox

2009-09-07T14:09:00.000+02:00

I learnt the basics of classic ASP while having a nasty dash of chicken pox which had me tied to the bed. ;)
I undertook the task of building my own little webshop, and I have to say that this task was a most excellent
one. I personally prefer setting up tasks for myself when it comes to learning a new language to code instead
of chewing through books and excercises. You have sessionhandling, you use the request, response, adodb libraries and objects, you learn to work with strings and math operations etc etc.

If I where you and you want to learn some classic ASP, then I would do this. However, first of, I must recommend that you look at a more trendy language like C# or ASP.NET with a vb dialect if you prefer this.

If you decide to try this out, then there are a couple of sites that have been sort of a lifeline for me when coding classic ASP (which now is getting to be very...well...CLASSIC). I thought I would list some of these below;

http://www.asp101.com/
http://www.4guysfromrolla.com/
http://www.w3schools.com/asp/
Plus of course ye olde MSDN: http://msdn.microsoft.com/en-us/library/t0aew7h6(VS.85).aspx

Connection strings

2009-09-01T07:54:00.000+02:00

Ever forget how to write those connection strings for the different solutions out there? Here is a great site which will list most variations and keeps on updating with new ones as they pop up.

http://www.connectionstrings.com/

Simple Stored Procedure

2009-08-28T15:46:00.001+02:00

Hello,

Here comes a little dash of SQL at ya;

---
Brief explanation: This procedure returns all fields from the table "Users" based on
the parameter @userid, which is an integer type parameter
Input: @userid integer
Output: Resultset with user data
---

CREATE PROCEDURE dbo.sp_getUsers

@userid int

AS

BEGIN

SELECT * FROM Users WHERE id = @userid

END

---

Welcome to Coders corner!

2009-08-28T15:43:00.000+02:00

This is an area where I have decided to jot down a bunch of useful tidbits for you fellow geeks or wannabe geeks out there. I do not claim for any of my tidbits to be the optimal solutions (there is always a better solution), but I will provide some thoughts and ideas that you can choose to use or abuse in any way you see fit!

Enjoy!