我的第一个ASP代码 [英] My first ASP code
本文介绍了我的第一个ASP代码的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
地狱家伙,
我正在尝试通过asp修改网站,该网站的功能正在帮助我们的员工预订(日程培训室),但2010年的日程安排不可用.但是我只想为我们一位管理员预订的2010年打开此日历一种伪代码以峰会形式实现此目的,如果您更改为我完成ASP代码,我将不胜感激,这里是伪代码
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,
推荐答案
嗨
创建用于连接的DNS,然后按
进行操作
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
这篇关于我的第一个ASP代码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文