|
I have the following bit of code split up into two part.... each part works
by themselves but when put together the formmail function does not work... I
don't receive any errors... I just never receive the e-mail.... Does anybody
have any ideas? Thanks!!
Janea
<%@ Language=VBScript %>
<%
'***************************************************************************
*****************
'The db will open and query the TBL_USERS table where username equals what
the user entered.
'***************************************************************************
*****************
set conn = server.CreateObject("ADODB.CONNECTION")
conn.Open "DSN=qual;"
USRx = Request.Form ("username")
USRx = Replace(USRx,"'","")
PASx = Request.Form ("ssap")
PASx = Replace(PASx,"'","")
set RSUsers = server.CreateObject ("ADODB.RECORDSET")
SQLxi = "select UID, username, password from TBL_USERS where " _
& "username = '" & USRx & "' and " _
& "password = '" & PASx & "'"
RSUsers.ActiveConnection = conn
RSUsers.open SQLxi
'***************************************************************************
*
'if record already exists, then the oops page is opened to the user.
'***************************************************************************
*
if Not RSUsers.EOF then
Response.Redirect "oops.asp"
'***************************************************************************
*******
'if record is not found then the users info. is inserted into the TBL_USERS
table.
'***************************************************************************
*******
else
FINx = Request.Form ("firstname")
FINx = Replace(FINx,"'","")
LASx = Request.Form ("lastname")
LASx = Replace(LASx,"'","")
JBx = Request.Form ("title")
JBx = Replace(JBx,"'","")
USRx = Request.Form ("username")
USRx = Replace(USRx,"'","")
PASx = Request.Form ("ssap")
PASx = Replace(PASx,"'","")
CONx = Request.Form ("confirm")
CONx= Replace(CONx,"'","")
PHNx = Request.Form ("phone")
PHNx = Replace(PHNx,"'","")
EMLx = Request.Form ("email")
EMLx = Replace(EMLx,"'","")
UNAVx = Request.Form ("usernav")
UNAVx = Replace(UNAVx,"'","")
DATEx = now()
conn.Execute "INSERT into TBL_USERS (firstname, lastname, title, username,
password, " _
& "confirm, phone, email, usernav, createdate) values (" _
& "'" & Request.Form("firstname") & "', " _
& "'" & Request.Form("lastname") & "', " _
& "'" & Request.Form("title") & "', " _
& "'" & Request.Form("username") & "', " _
& "'" & Request.Form("ssap") & "', " _
& "'" & Request.Form("confirm") & "', " _
& "'" & Request.Form("phone") & "', " _
& "'" & Request.Form("email") & "', " _
& "'" & Request.Form("usernav") & "', " _
& "'" & DATEx & "')"
set RSNx = server.CreateObject ("ADODB.RECORDSET")
SQLNx = "SELECT firstname, lastname, username, password, title, phone,
email, createdate from TBL_USERS"
RSNx.Open SQLNx, conn, 2, 2
RSNx.MoveLast
VarFirstName = Request.form("firstname")
VarLastName = Request.form("lastname")
VarUserName = Request.Form("username")
Varssap = Request.Form("ssap")
VarJobtitle = Request.Form("title")
VarPhone = Request.Form("phone")
VarEmail = Request.form("email")
VarDate = now()
'Top Half
----------------------------------------------------------------------------
----------------------------------------------------
'Bottom Half
Set mail = Server.CreateObject("Persits.MailSender")
mail.Host = "mail.studiord.com"
mail.Port = 25
Mail.From = "webmaster@studiord.com"
Mail.FromName = "webmaster@studiord.com"
' Mail.AddAddress "jtaylor@studiord.com"
Mail.AddAddress "{$GM-WEBIMPORT$}","agent@studiord.com"
mail.Subject = "New Contact To Be Added"
mail.Body = "[Instructions]" + chr(13) + _
"[Data]" + chr(13) + _
"Contact=" + request.form("name") + chr(13) + _
"Title=" + request.form("title") + chr(13) + _
"Company=" + request.form("company") + chr(13) + _
"Address1=" + request.form("address1") + chr(13) + _
"Address2=" + request.form("address2") + chr(13) + _
"City=" + request.form("city") + chr(13) + _
"State=" + request.form("state") + chr(13) + _
"zip=" + request.form("zip") + chr(13) + _
"Country=" + request.form("country") + chr(13) + _
"Phone1=" + request.form("phone") + chr(13) + _
"Source=" + request.form("source") + chr(13) + _
"Notes=" + request.form("comment") + chr(13) + _
"USRDUSER=" + request.form("username") + chr(13) + _
"USRDPASS=" + request.form("ssap") + chr(13) + _
"USRDCONF=" + request.form("confirm") + chr(13) + _
"USRDHINT=" + request.form("hint") + chr(13) + _
"USRDCURL=" + request.form("usernav") + chr(13) + _
"[ContSupp]" + chr(13) + _
"ContSupp_rectype=P" + chr(13) + _
"ContSupp_contact=E-mail Address" + chr(13) + _
"ContSupp_contsupref=" + request.form("email")
On Error Resume Next
Mail.Send
If Err <> 0 Then
Response.Write "An error occurred: " & Err.Description
End If
set mail = nothing
%>
<HTML>
<HEAD>
<TITLE>Confirm menu</TITLE>
</HEAD>
<BODY BGCOLOR="#000000">
<CENTER>
<form action="../html/FRAMES.htm" method="get" target=_top>
<TABLE BORDER=0 CELLPADDING="2" CELLSPACING="2" width="100%" height="100%">
<TR>
<TD align="center" valign="middle" width="100%" class="head"
height="100%">
<TABLE cellpadding="2" cellspacing="2" border="0" width="380"
class="head">
<TR>
<TD align="left" width="380" class="head">
<P></P>
<font face="arial, helvetica" size="2" color="#ffffff"><b>Thank you
for submitting your request to Studio RD.</b>
<BR><BR>
You will be contacted when your application has been
approved.</font><br>
<br>
<input type="submit" value="continue" name="submit"id=button>
<br>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</form>
</CENTER>
</BODY>
</HTML>
|
|
|
|
|
Hi All,
I am using a datagrid on a page to show some data from my sql database.
I just need to know if you can use a regular expression to change a 1 into 'Male'?
If not how would I change something like that.
My SQL database is returning integers and I want to display them nicely.
Thanks,
Gavin
|
|
|
|
|
Use a template column such as:
<br />
public string MyFormat()<br />
{<br />
return MyFormatedString;<br />
}<br />
<br />
<asp:DataGrid ....<br />
<ItemTemplate><br />
<% =MyFormat() %><br />
Should be enough for you to fill in the blanks. Search MSDN for ItemTemplate or look at Dino Esposito's recent three part MSDN Mag series on build a Data Navigator control.
|
|
|
|
|
You can do that with an SQL statement
assume gender is the name of your column:
Select decode(gender, '0', 'Female', '1', 'Male') as gender from sometable
search for "sql decode" on google
Todd Smith
|
|
|
|
|
I need to be able to create an image where I can specify a point (this one being the center) and a second point that is X° from the first point. I then need to be able to draw a straight line from point 1 to point 2. It would also be nice if I am able to label both points. The two points represent the direction or bearing from the first point (From) to the second point (To). This is for the web, so I thought that Office Web Components would be best. I will know the X° that the 2nd point is from the first. Does anyone have any ideas for this? Thanks in advance.
Nick Parker
|
|
|
|
|
I believe that Microsoft licence the use Office Web Components only on a LAN. Because they believe that not all clients accessing the web server have valid offce licences. Check their web side for details. So if you are planning to use it on a public web server consider something else.
Best regards,
Alexandru Savescu
|
|
|
|
|
Is there any reason (security?) why the Service Controller.GetServices method returns nothing in an ASP .NET application on WIN 2000 running as Administrator? The same code running in a console app returns all the services on the machine.
John
|
|
|
|
|
Hello everyone I recently had to reformat my harddrive (lost everything ) Now when i create a web service and try to view it in Internet Explorer it prompts me to download the service and wont display it... If i just double click the file it opens into VS.NET code view . I do not know what is wrong, it used to work before I had to reformat my HD.
Can anyone here help me?
|
|
|
|
|
It may be obvious but you have reinstalled the .NET Framework? This of course sets up IIS so it can recognize ASP.NET files.
|
|
|
|
|
Well, I installed VS.NET (Visual C# .NET standard and Visual C++ .NET standard to be percise). The only thing I can think of is that I installed IIS after VS.NET, is that my problem?
|
|
|
|
|
Yes, that is the problem. Reinstall the framework.
|
|
|
|
|
Just a though, but your 'Open' commend for *.asmx files may be set to VS.NET. You can change to see whether VS.NET or IE is your default viewer by cheking...
1) open Windows Explore
2) Tools->Folder Options->File Types (tab)
3) Scroll down to (and select) ASMX
4) Click 'Change...' button (bellow on dailogbox)
5) Select your program
Hopefully that my solve your problem
Mike M
WinInsider.com
|
|
|
|
|
Thanks mike but I just reinstalled the framework and it works now, thanks for the sugestion though.
|
|
|
|
|
I am using HTMLDialogs and they are great apart from one problem. IE always seems to use a cached version of the page and I have to clear the cache to make it update! Anyway around this?
Thanks!!
Davy
http://www.LateDecember.com
|
|
|
|
|
Try putting
Response.AddHeader "Pragma", "no-cache" in your code
"Isn't that the "write once, debug everywhere" language?" Tom Archer on Java... 
|
|
|
|
|
Thanks Brian. I added the line but it still used the cached page. However I changed my IE settings to check for a newer page on every visit and this seems to work. It could be related to the way I am calling the dialog (via script).
Davy
http://www.LateDecember.com
|
|
|
|
|
I need to have a timer displayed on an aspx page that reads the time from the server and automatically updates it on the client browser. I was thinking some sort of web service but I'm open to other suggestions or possiblities.
|
|
|
|
|
You would need client-side code to do that (JavaScript, VBScript). Server side code couldn't accomplish that. Unless of course you created a Windows Form and then included that in your page, but that requires the end user to have the .Net Framework.
David Stone
dstone@newcenturytitle.com
MEEKNESS, n. Uncommon patience in planning a revenge that is worth while.
The Devil's Dictionary, Ambrose Bierce
|
|
|
|
|
This is for an internal application so requiring the user to have .NET is not a problem.
I was thinking of have a JavaScript function use setInterval to call the webservice. I'm thinking of investigating how I might use web service behaviors to help with this.
|
|
|
|
|
Could you tell me your good idea?, How to create Chat Java applet (diagram Server and Client)
thanks
|
|
|
|
|
My webhost sadly doesn't support ASP only PHP. I'd like to be able to test my site locally before uploading it.
What do I need to run PHP apps on my Windows 2000 Server?
Michael
|
|
|
|
|
Download PHP for windows from PHP.net.
If your host uses an older version of PHP, you should try to match it with another version.
James
Simplicity Rules!
|
|
|
|
|
Any good book recommendations for PHP?
Michael
|
|
|
|
|
I just use the documentation online
James
Simplicity Rules!
|
|
|
|
|
Its okay, but not something you can take on the bus. I still love learning from a book 
Michael
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
