I have login-page where i set the column LoggedIn = 'Y' when a user logs
in, i was wondering if you guys could help me set up my global.asa so
correctly so it sets LoggedIn='N' when Session("UserID") times out.
what is needed besides:
set conn=server.createobject("adodb.connection")
conn.open connstr
sql="update users set loggedin='N' where userid="&session("userid")
conn.execute(sql)
set conn=nothing
I have been asked to create a contact form for a website in ASP that will mail off the form data to a e-mail address but also log the e-mail data in a database.
They then want a web page on-line that they can view all the e-mails in (not a e-mail client, just a html view of each one).Now i have two issues with this, 1. i have never coded in ASP in my life, (php yes, lots) and 2. i dont see the point in being able to view them online when they will have the e-mail in their desktop mail client.Does anyone know of a script that will do what i'm after that is free and uses MSAccess not SQL Server?It's a big ask, but if there was something a bit like it i could have a go at modifying it.
I am writing a little search page for a site and all i want is a simple bit of code that finds out if there is more than one word sent from the text box when the form is submitted.
View Replies View RelatedI have used thecode which is below to get x characters on to display
<%= LEFT(rsName.Fields.Item("columnname").Value,50)%>
It works fine but when I use this same code to get x characters plus display it using VBCRLF, with the <br> with writing the code :
<%=Replace LEFT
(Recordset1.Fields.Item("Detail").Value,VbCrLf,"<br><br>",50)%>
it gives me error so please can you tell me how can i trim the characaters and at the same time use VBCRLF. why does this above code with LEFT + vbCrLF doesn't work.
this is dependant on whether or not I can get my sessionID. This is assigned
by the server yes?
so...when I log in, I query what my session ID is, and then store that in a
DB along with a flag that says I'm logged in.
now, along comes someone else who has me in their buddy list, I think I can
query the sessionIDs and remove any records from the DB where the sessionID
no longer exisits. (not sure how yet but I'll work on it).
Then the second user will query the DB to see if I have logged in (and a
sessionID still exists). if so, his buddylist will show me as logged
on...although it could be 20 mins out of date, it's getting closer to the
real thing. Code:
I have one application folder containing all ASP code files. I want host multiple sites pointing to same code. Can I do this ? If YES then how I can assign diffrent global.asa to each application...
View Replies View RelatedI have added a db driven marquee to my site and need to combine the global asa's to 1 global asa file. Code: ......
View Replies View RelatedI've read hundreds of posts regarding this, but haven't got a working solution yet. Does anyone have a working snippet of code from an ASP page that can be used to upload a file to an FTP server? I read all about INET, but due to some licensing issues it won't work....
View Replies View RelatedASP.net is that what is used to create web pages on a server such as IIS?
ASP.net is part of visual studio, what software package contains IIS?
I have an XML file which I access from a remote server like
Set http = CreateObject("MSXML2.ServerXMLHTTP")
http.open "GET","http://www.andrewlouis.co.uk/viewcountries.xml",false
http.send
strXML = http.responseText
The real server is password protected with, I think, with basic
authentication. How do I pass it the username and password.
This is ALL the code that i have..
<%
response.write("This is a test")
%>
the file is saved as test.asp
I have uploaded it, and when i run it, I get the code being displayed ie.
<%
response.write("This is a test")
%>
I am having one asp page in which a table is displayed. The table displays the values in textboxes.when the client uses search functionality it searches in the whole page but doesnt search in the table. Can any one tell me about how to search the values contained in textboxes in the table.if possible give me some code
View Replies View RelatedHowever I have a complicated update page so I am going to hand code it. I started by breaking down to the basics of Updating but I keep getting a 'Syntax error in UPDATE statement' error. Can anybody see where I am going wrong?:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/Publishing.asp" -->
<% If Request("Submit") <> "" Then %>
<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_Publishing_STRING
Command1.CommandText = "UPDATE Test SET Value = Paul WHERE ID = 2 "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()
%>
<% End If %>
Is there one? I need to hash a sensative string before inserting it into the sql server database. It HAS to be done in the ASP code, because it is also stored in a cookie. Any ideas? Server asp code is vbscript.
View Replies View RelatedI need source code for a simple MSN API example, something that interacts between MSN's controls. I want to break it down test it and use it for my own applications.
Or can people even suggest free source code sites for VB. I can search for them there. Planet-source-code had an AMAZING app, but it wanted an ocx file which I obviously didn't have.
I have two simple problems which I think are related(?) I have a form with the folowing code:
<form method="post" action="sendemail.asp">
and
<input name="submit" type="button" value="SUBMIT">
when I click the submit button it does not go to sendemail,asp I have tried adding the full/parstial path infront of the sendemail.asp but no luck
Similarly I have the following code which I have taken an asp file from another project and changed the name accordingly but the image does not show Code:
I'm using MSXML2.ServerXMLHTTP to get a web page using an url with basic authentication (e.g. http://user:password@www.mysite.it).
Microsoft denied basic authentication within Internet Explorer URL (see KB 834489) so I'm unable to get the page contents.The client-side workaround is to change some registry settings (see http://support.microsoft.com/kb/834489), anybody can help me with a different solution ?
How to create a basic chat?
View Replies View RelatedI've got a field in my database called notes, where they of course are leaving notes for certain orders. I'd like to create a page that lists all orders that have notes left in them but I'm having trouble figuring out what sql statement to use. In my words it needs to say "select everything from the table where notes does not equal null"
I guess I just don't really know what to put for the null part. I'm thinking it'll be somehting like..
SELECT * FROM requests WHERE notes <> ...??? this is what I dont know.
i am trying to pull records using a partial name, here's what i have
PlayerName = "'" & "%" & txtFindPlayer.Text & "%" & "'"
this part works fine, for example text is 'ric'
Set rs = db.OpenRecordset("SELECT * FROM EVENT_SCORING_TBL WHERE PLAYER_NAME LIKE " & PlayerName & "")
no record containing 'ric' is found, but the syntax seems to be ok. Am i using the right wildcards? there is definatly an Eric in the database, but it doesnt pull. any suggestions?
I'm having some problems to perform select on sql statements just cause I'm really confuse on how to refer some variable I got by request.querystring or request.form or even inside form variables...sometimes just using "var" others using "&var&" others '%"&var&"%'...
Does anyone have an article link or some tips regarding this kind of issue?
I have setup basic authentication on one of my web sites. For some reason, I get challenged when I navigate to some of the ASP's within the website. I have checked all the pages and made sure they all have authorisation set to a specific group.
What can be causing this?
Could somebody please outline the steps needed to create a (very)basic forum from scratch?
ie. the pages that are definetely required...eg. the sign-up and log-in pages... and a very basic admin page.. also, the structure of the database?
I have a ASP site. Very basic, few pages, 2 includes. There is no user input from the site, no fields they can insert SQL statements.
I also have a login where the Admin can add/edit/remove news items, which are stored in a DB. What are the security issues linked with these?
My login isn't querying the database, but should I use the sha() function to encrypt the pass? Although it's just 1 user adding to the system, should I "clean" up the input(add news/edit news) before it's stored in the Access DB?
Should I restrict IPs solely to those within the building they use?
ASP And Visual Basic Interview questions and answers
I have listed over 100 ASP and Visual Basic interview questions and
answers in my website
I would like to know the Pros and cons for using ASP VS Visual Basic for intranet, in terms of time development and customization. The project that we will use it is a basic Information Management System.That could be used for offline and online using IIS and MYSQL.
View Replies View RelatedI have a secure site and created an asp page to create a word doc header and footer, when a user goes to the page they get prompted to login then when they click on open they get prompted to login again.
Im guessing its something with the basic authentication and the header footer files being in different locations.
I know we can write ASP with VB Script. Some people told me the big ASP
projects usually use Visual Basic for the business logic. Is that the case?
What I mean is an ASP project is the combination of server-side ASP code and
Visual Basic components (.cls)
objNewMail = Server.CreateObject("CDONTS.NewMail")
How do I know whether the "Send" command from a CDONTS object actually was
sent?
Is there a status variable that can be checked? Or a log file that can be
written to?
I need some simple component (COM+ or just DLL) source to perform Basic
Authentification for ASP solution.
Short explanation what I mean:
In non secure area I've a form with fields Login name and password. After
pressing submit button that component has to redirect to page in secure area
(https://) and perform NT Basic authentification [ or redirect to another
page saying about failing).
That has to be replacement of that standard 'green pop-up' asking to enter
loginname and password.
i have a basic contact form on a website and im trying get an asp script to send an email off to the sites sales people.
I am trying to add a basic user control to a web site; coming from visual studio 2003 this was extremely easy. I would just add the user control and then add the controls that I want on that user control, but I am not able to get a basic link button to click.This seems so ridiculously basic, but I am not able to get this to work.What am I missing?
View Replies View RelatedI have a static website. I put up for a friend using a few dynamic classic ASP scripts.
How do i incorporate a search engine on the static website ?Are there any ways of doing so, without using google ?