|
Hello,
Newbie here. I'm trying create a simple, one-page ASP form that allows users to enter their email address, click submit, and if the email address has a match in the MS SQL database, use JMail to email them their password. below is the code. Please note that the include 'db.inc' is the database connection. Any help would be greatly appreciated. Examples are best as I'm learning. Thanks.
<code>
<%@ LANGUAGE="VBSCRIPT" %>
<!-- #include file="db.inc" -->
<%
'Check if the form has been processed
If Request.Form("process")="true" Then
'Check the recordset for a valid record
"SELECT * FROM Employers WHERE email = '" & email & "'"
End If
%>
<head>
<title>Send Password</title>
</head>
<body>
<%
'checks if email address exists in the database before sending a message.
If objrs.EOF then
%>
<table border="0" cellPadding="0" cellSpacing="1" width="540">
<tr>
<td class="title-err" bgcolor="#FF0000"><font color="#FFFFFF"><b>Invalid Email Address</b></font></td>
</tr>
</table>
<p><span class="text-err">We could not find</span><span class="text3b"> <%=email%></span>
<span class="text-err"> in our database.</span></p>
<% Else %>
<%
'sets variables
email = request.form("email")
'chooses username and password from database that correspond to submitted email address.
pass = objrs.Fields("pw")
Set JMail = Server.CreateObject("JMail.SMTPMail")
JMail.ServerAddress = "REMOVED FOR FORUM POST"
JMail.Sender = "EMAIL REMOVED FOR FORUM POST"
JMail.Subject = "Your Password"
JMail.AddRecipient = email
JMail.Body = "Your user name and password are below as requested:" & vbCrLf
JMail.Body = JMail.Body & "Per your request your account login information is: " & vbCrlf & vbCrlf _
& "Password=" & pw & vbCrlf
JMail.Body = JMail.Body & "You may now use these to log on"
JMail.Priority = 3
JMail.Execute
%>
<p class="text2">We just sent your login information to <%=email%>.<br>
You should receive it shortly.</p>
<%
' Close Data Access Objects and free connection variables
objDC.Close
Set objRS = Nothing
'Set objDC = Nothing
%>
<%end if%>
</body>
</html>
</code>
|
|
|
|
|
|
how do i make a default button in asp (not asp.net) i want when somebody hits enter on my web page it presses my submit button
chad
|
|
|
|
|
chekc link http://www.porjes.com/idocs/forms/index_famsupp_157.html
Divya Rathi
|
|
|
|
|
I have the task of re-writing an HTTP service for a client. The current implementation is a COM object using the WinHTTP API. WinHttp seems the perfect choice for the task but the client has had reliability problems with the current implementation and thinks the problem is WinHTTP. Can anyone comment on their experience with WinHTTP? Is it possible to build a robust, reliable WinHTTP application that uses the asynchronous capability of WinHTTP? I'm surprised at the lack of discussion board activity and examples about this API if it is widely used... Comments, examples? Thanks!
|
|
|
|
|
|
Hi all!
I've created ASP.NET web application, but when i'm in IE6 and try to download a file (.xls and .xml) from the IIS I get this:
Internet Explorer cannot download File.doc from ServerName.
Internet Explorer was not able to open this Internet Site. The requested site is either unavailable or cannot be found. Please try again later."
This works fine in Firefox and in IE6 before the hosts moved the site to a new machine so I don't think this is coused by the programming.
Any ideas of why this is?
Thanks in advance
|
|
|
|
|
Hi all,
Currently I m working as a asp.net programmer
I had a problem with virtual directory,
I m creating asp.net web application with C# language in my Inetpy\wwwroot that is in localhost.. So it is working fine..
Now When I m transferring my application to other folder then I need to create virtual directory for it.. I m creating that but still the application is showing error once I remove my application from where I have created
Nikey Patel
Asp.Net Programmer
|
|
|
|
|
Open the properties for the folder in IIS manager, and create the application for the folder.
---
b { font-weight: normal; }
|
|
|
|
|
Hi All,
I am working on Win CE.Net.
For CGI scripting which "web server" is required?
From where I can get it?
Thanks in advance
- Ramesh
|
|
|
|
|
|
I have some minor questions to ask about "How do I?" or "Can I?" if you have experience with FCK let me know.
Thanks,
Rex
I only read CP for the articles.
Code-frog System Architects, Inc.
|
|
|
|
|
Before purchasing a control suite from telerik I used it a bit. I was always impressed with it, better than most commercial ones. Plus being able to be used with asp, .net, java etc... very cool.
|
|
|
|
|
How to set the headers of a shdocvw.dll webbrowser control ?
For example I would like to load a page "http://localhost/test.php" and send it a cookie with name "cookname" and value "cookval".
I call (in VB6):
Dim obj as Object
Web.navigate URL, obj, obj, obj, Headers
where Headers is a string = "Cookie: cookname=cookval" & vbCrLf
URL = "http://localhost/test.php"
But it doesn't send any cookies.
Please help me.
If possible, post a code example in any language - vb6, vb.net, c#, vc++ etc.
Thank you.
|
|
|
|
|
Hi!
I have 2 questions:
1. I have say 2 DropDownList boxes, when I select Product A from the first DropDownList Product A options appear in the second DropDownList and visa versa?
2. How would I write a SP in SQL to check if the value is already in the DB? For instance, if someone wants to add "jeff" then SQL must first check to see if jeff exists. If he exists then SQL must use that value and not add a second jeff.
Thanks Guys and Gals!
Illegal Operation
Making Computer Software Talk
|
|
|
|
|
hi I m not telling syntax just the approach
1)in first dropdownlist when u select a product , then retrieve the id of selected item & capture this event of item change . then in this event , retreive the options & populate the second combo
2) for sp
create procedure test ( val in , existsval boolean out )
as
select count(*) from [table] where value = val
if @@rowcount = 0 then
/* this value is not there in db */
existsval = false
end if
return look out for exact syntax of sp
Divya Rathi
|
|
|
|
|
Dear all;
I am using the WebBrowser control to access the elements of a web page. This has been done successfully.
Now that i can retrieve elements (paragraphs, headers, links, fonts...) through the IHTMLElement2 interface. I am trying to obtain the size of textual elements (paragraphs, headers ...) and compare them "see which ones are bigger than the others".
As far as i know, the size attribute for html elements can be accessed through the IHTMLCurrentStyle interface.
The problem now is:
IHTMLCurrentStyle::fontSize gets me the size in different formats ----> as it can be absolute size, relative size, length, and percentage.
or please have a look at this link:
---> Font Size
then click on: IHTMLCurrentStyle. The font size get be then obtained through: fontSize
Now guys, do u know anyway to compare those formats!!!
Another way i am thinking of is to get the height of a single line. this should be easier to make a judgment regarding which elements are bigger.But i do not know how to do that, any ideas ????
thank you
llp00na
-- modified at 7:14 Thursday 23rd February, 2006
|
|
|
|
|
Can i write SQL statement inside javascript function in order to matching data string inside my database. Its't possible?? 
|
|
|
|
|
I don't understand your question? If you are talking about client-side javascript (in the browser), I would not do it due to security reasons.
|
|
|
|
|
ok i have a existing asp page that was created by another programmer and i pulled it in visual studio and i put a button and a textbox on the page visualy and the page looks right when i view it in visual studio but all my objects are all over the place when i go the the web site can somebody help me with this
chad
|
|
|
|
|
The ASP server-side code (I assume you are not talking about ASP.NET) generates html that is only visible in the browser. Visual Studio can not determine what the code should look like at design time.
|
|
|
|
|
try adding the "runat=server" string when you insert a textbox or button. You will still see the HTML version of code when you view the source but this information isn't very helpfull for someone trying to steal your code.
When you create textboxes, dropdownlists, buttons even hyperlinks and images, use the asp:"%name%" tag. this will make your life much easier.
Illegal Operation
Making Computer Software Talk
|
|
|
|
|
I am having trouble tring to finish a photo gallery. I currently have a simple on running at the moment with seven pictures that are all located on seperate pages. I want to combine them all to one and am having trouble with the javascript code. I know I need an array to set up the load of each picture with a target point. here is what I have so far on the page itself (no javascript at this time):
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="main.css" />
</head>
<body>
<div id="navigation">
<table>
<tr class="textnavigation">
<td class="previous"><span class="previous"><a href="tour6.html" title="Previous Photograph"><< Previous</a></span></td>
<td class="index" colspan="6"><span/></td>
<td class="next"><span class="next"><a href="tour7.html" title="Next Photograph">Next >></a></span></td>
</tr>
<tr>
<td class="thumbcell"><a href="tour4.html"><img src="tour4_small.jpg" /></a></td>
<td class="thumbcell"><a href="tour5.html"><img src="tour5_small.jpg" /></a></td>
<td class="thumbcell"><a href="tour6.html"><img src="tour6_small.jpg" /></a></td>
<td class="thumbcell selected"><img src="nwview_small.jpg" /></td>
<td class="thumbcell"><a href="tour7.html"><img src="tour7_small.jpg" /></a></td>
<td class="thumbcell"><a href="tour1.html"><img src="tour1_small.jpg" /></a></td>
<td class="thumbcell"><a href="tour2.html"><img src="tour2_small.jpg" /></a></td>
<td class="thumbcell"><a href="tour3.html"><img src="tour3_small.jpg" /></a></td>
</tr>
</table>
</div>
<div id="photograph">
<img src="nwview.jpg" />
</div>
</body>
</html>
I also want to see about making the thumb nails circle around the current picture being viewed. Any advice or links to get me a good start would be a great help.
-- modified at 11:54 Wednesday 22nd February, 2006
|
|
|
|
|
I have written following lines of code in javascript
function a()
{
var instance =new ActiveXObject("testDll.Class1");
document.write(instance.hello())
}
where testDll is a dll which i have registered and Class1 is its function
It gives me error "Automation server can't create object"
I cannot understand that why i m receiving this error Is there any mistake in my code or whats solution??
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
