ASP / SQL /电子邮件问题 [英] ASP/SQL/Email Question

问题描述

和我们一起裸露。我会尽力做到这一点。我有一个网站，允许学生通过提交他们的电子邮件地址来检查他们的录取状态，然后将他们和我们的招生办公室发送一封关于他们在我们的SQL数据库中的状态的电子邮件。运行的ASP脚本从一个表中提取所有信息。


有三种可能的状态类型; ''AC（App Complete），AI（App Incomplete）和UR（Under Review）''。如果学生碰巧被标记为AC或UR，则会发送电子邮件，让他或她知道自己的状态。


现在，如果学生被列为AI，则生成的电子邮件应列出字段尚未完成的（在下面的代码中描述）。截至目前，电子邮件已生成并发送，但字段从未列出。 你当前正在丢失：下面只是一个空白区域。


我投入了一些response.write语句，以确保从数据库中提取数据，这似乎是做。


设置：网站（FrontPage），SQL 2005，MS Access 2003


任何建议都会很棒。谢谢！

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

解决方案

我会使用类似下面的内容..

展开 | 选择 | Wrap | 行号

标记，我很感谢回复。我对使用下面代码的关注是我只根据哪种情况有效来寻找特定的空字段，即''AC''，'AI''和''UR''。


实际上添加一些奇怪的东西：我注意到，当我为每个字段（Citizen，GRE等）放置了response.write语句时，电子邮件开始按照应有的方式填充。现在唯一的事情是，如果你留下写作陈述，学生会在网页顶部看到一长串信息，这也让他们知道已经发送了关于他们状态的电子邮件。


有什么想法吗？ :)谢谢。

我会使用类似下面的东西..

展开 | 选择 | Wrap | 行号

实际添加的奇怪之处：我注意到我放置了response.write语句每个字段（Citizen，GRE等）的电子邮件都按照应有的方式开始填充。现在唯一的事情是，如果你留下写作陈述，学生会在网页顶部看到一长串信息，这也让他们知道已经发送了关于他们状态的电子邮件。


有什么想法吗？ ：） 谢谢。

解决这个问题的简单方法是将你的response.write语句放在html注释标记中：

展开 | 选择 | Wrap | 行号

Bare with me guys. I will try and make this short and to the point. I have a website that allows students to check their admission status by submitting their email address which in turn sends them and our admissions office an email regarding their status in our SQL database. The ASP script that runs pulls all information from one table.

There are three possible status types; ''AC (App Complete), AI (App Incomplete), and UR (Under Review)''. If a student happens to be tagged as AC or UR an email is sent letting him or her know their status.

Now if the student is listed as AI, the email generated should list fields that have not been completed (described below in the code). As of right now the email is generated and sent, although fields are never listed. Just a blank space beneath "You are currently missing:".

I threw in some response.write statements to ensure data was being pulled from the database, which it appears to be doing.

Setup: Website (FrontPage), SQL 2005, MS Access 2003

Any suggestions would be great. Thanks!

Expand|Select|Wrap|Line Numbers

解决方案

I would use something like the following..

Expand|Select|Wrap|Line Numbers

Mark, I appreciate the reply. My concern using the code below is I am only looking for particular null fields depending on which case is valid, ie ''AC'', ''AI'', and ''UR''.

Something weird to add actually: I noticed as I placed response.write statements for each field (Citizen, GRE, etc) the emails started populating as they should. The only thing now is if you leave the write statements, students see a nice long string of information across the top of the webpage that also lets them know an email has been sent regarding their status.

Any ideas? :) Thanks.

I would use something like the following..

Expand|Select|Wrap|Line Numbers

Something weird to add actually: I noticed as I placed response.write statements for each field (Citizen, GRE, etc) the emails started populating as they should. The only thing now is if you leave the write statements, students see a nice long string of information across the top of the webpage that also lets them know an email has been sent regarding their status.

Any ideas? :) Thanks.

The simple way to solve that problem is to put your response.write statements in html comment tags:

Expand|Select|Wrap|Line Numbers

这篇关于ASP / SQL /电子邮件问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！