My first ASP code

Question

0.00/5 (No votes)

See more:

Hell Guys,

I am tring to modify website done by asp the website functionality is helping our employee to book (schedule training room) but the schedule not available for 2010. But I want to open this calander only for one of our admin to book for 2010 I wrote one pseudo code to implement this in summit form any one I appreciate if you change to me to complete ASP code here is the pseudo code

if month = 12 and year = getyear + 1 and 
   request.servervariables "logon user" = 'DII\yobest1' then
insert into database
else
    response.write 
       "the 2010 booking is currently open only to the administrators"

I apreciate for your help
Thanks,

Posted 30-Nov-09 14:30pm

yared getachew

Updated 1-Dec-09 7:21am

Sean Ewington

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aman Bhullar · Accepted Answer · 2009-11-30T18:13:00

Hi
Create the DNS for the connection and proceed as

if month = 12 and year = getyear + 1 and request.servervariables "logon user" = 'DII\yobest1' then
Set conn=Server.CreateObject("ADODB.Connection")
connStr="dsn=CRMWEB;uid=sa;pwd=S;" 'CRMWEB is DSN Name
conn.open connStr
set rs=server.createobject("ADODB.recordset")
sql="Insert into Query" ''Write down your Query here
rs.open sql, conn2, adOpenStatic
rs.close
set rs=nothing
conn.close
else
response.write "the 2010 booking is currently open only to the administrators"

Think this will help you