ASP :: ASP-Based Webmail: Include Original Reply Formatting

Include Different Asp File, Browser Based
I have different asp files to "include" in asp page, depends if the browser is IE or not. The browser detection is not the problem of course. I would like to know how can I include the right file, based on the browser detection.

In partly free language I need:

IF (IE) ->

else


I have tried to test something simple in an asp page, but not working (not too surpriseingly)

<body...>
<script language="javascript>

</script>

Formatting A HtmlBody Email String To Include Variables
I have this:

1 emailBody = "<html>" & vbCrLf _
2 & "<head>" & vbCrLf _
3 & "<title>Interpreter Request details</title> " &
vbCrLf _
4 & "</head> " & vbCrLf _
5 & "<body> " & vbCrLf _
6 & "<font face=Verdana><b>Interpreter Request
details: " & vbCrLf _
7 & "Requestor: </b><u> <% strFName strLName %></u>"
& vbCrLf _
...
& "</body> " & vbCrLf _
& "</html> " & vbCrLf

In line 7, I need to display the results of the variables strFName and
strLName (and have a space in between the two) but I don't know the proper
formatting. If I just use the & then I get the literal strFname instead of
the value. Could someone please show me the correct syntax for this?

ASP Webmail
Is there any 'plug n play' code out there to create a webmail site? I have a domain which supports pop email and i allow people their own email address from me, and some have asked if I can create a basic webmail setup.

Webmail In ASP
Can it be done without using third party components to handle the POP mailbox access side of things, or am I going to have to think about getting my own server (cos my hosts don't allow installation of custom dlls/ocxs)? I have a script example that does it in .NET but there are no plans for my hosts to upgrade to that either.....

Webmail
Im in desperate need of in creating my own webmail application. My server is ASP and .net enabled, but i do not have access to install further components so registerring dll files is a big no no.

I need help in creating code that can access a specified pop3 server using given credentials, preferably in asp but i can also use basic .net.

Does anyone know of good source code or what standard components in the ASP or .net environment have the ability to access such data? Or if you just know a few basic lines that i can use.

My website is just a small group of friends and we cannot pay for anything so its up to me to get this setup for us. I can send mail but not receive from POP3.

Webmail
Is there any way I could upload a certain file whether it is contained as an executable such that when I do a form submit, it can perform the same task that CDO, CDONTS, or JMail could do but without requiring the web hoster to register the dll files to their servers

Reply Not More 40 Hrs
Here is the answer...not letting overlap scheduling per person for the same day.Code:

rs8.CursorLocation = 3
rs8.open "SELECT ID,sch_route,sch_time_start,sch_time_end,sch_date FROM realschedule " &_
"WHERE sch_date = #"&rsDate&"# " &_
"And driver_id = "&rs("Driver_ID")&" " &_

"AND ( ((#"&st&"# between sch_time_start AND sch_time_end) " &_
"or (#"&et&"# between sch_time_start AND sch_time_end) )" &_

"OR ( (sch_time_start between #"&st&"# AND #"&et&"#) " &_
"or (sch_time_end between #"&st&"# AND #"&et&"#) ) )",conn

Reply To Newsgroup
how can I reply to newsgroup for quicker response

Get Original URL In Redirection
I have ASP page redirect from a HTML page which is password protected by IIS auth.I would like to check whether the redirection is REALLY taken from the HTML page. Since the ASP page is located at second server, would there is a chance that ASP programming such as server object can check the original URL. Or any other method.

Preserving The Original URL
I was browsing the web the other day and a website I had a look at redirected you to a different webpage but still preserved the original URL that was typed in the address bar on the browser (it didn't move or change at all) How is that possible? I would like to do something similar.

The reason I am asking is because I want visitors to view a profile of a user like this

myweb.com/fred

this would have to be translated and redirected to mysite.com/profiles.asp?user=fred.but I want the original URL address to stay showing in the address bar

Return To Original Form
I have several different ASP forms (call them Form A,B, and C). "Button X" is on each of them (Forms A,B, and C). "Button X" calls ASP Form D and does some processing. After I am finished with the processing I want to go back to the original Form, either A, B, or C, which ever one "Button X" was clicked on.

I think I am looking for something like

Response.Redirect ("Parent.Form")

ASP WebMail For Users On My Site
I am about to start developing a site that will allow users to create profiles. I would really like to be able to allow them to send and recieve e-mails to their profiles. Kind of like Yahoo (mail.yahoo.com) I would set up mail.mysite.com.

Of course I would want to have Virus and Spam protection on it, they would access it via the web, and it would be really awesome if they could sync mobile devices to it - like Web Enables PDAs with mobile outlook.

If it could be like outlook web access where the user can have contacts, a calendar, etc. That would be fantastic.

Anyway, does anyone know which corner of the web I should start my search? I don't know the technologies involved, would I need a SQL back end or anything? I'm really a first day guy on this subject.

What I am planning on having is ASP.Net, MySQL and use as many open source projects as possible to pull this site together to keep costs down. Usually I work with PHP/Apache, but a follow phase to this will be an application that will run locally, so that's why I'm working with ASP.

Sent Messages/reply To User Error
I have a problem when a user login to the site and when they tried to write or reply a message to other user I got this error message:

Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/write.asp, line 122

800401f3

I am running windows 2003 server with IIS6 installed with all the access component install. I am not sure what causing it. The weird part it sent or reply messages to the user but it just give that error messages. I had include the error code below write.asp I only copy and paste half the text in here. Code:

Parent - Child - Submit - Reply
I am trying to redirect back to a child form after a submit with a file upload and verification of file data. I would like to go back to the form and display a message returning the status of the data. Is that possible? Any suggestions on an alternate? I am using classic ASP, javascript and vbscript.

Get Original Querystring Values After Decryption
Anyone have a VB function or know how to retrieve original querystring values after they have been decryted and lie within a string? Code:

ASP Formmail W/ Courtesy Reply Back?
Can anyone help me with asp code for my form that enables sending a confirmation/courtesy e-mail back to the form submitter?

Populate A Popup Window With Clickable Records From An Access DB And Upon Clicking, Populate A Selectbox On The Original Webpage With The Clicked Record
We have an ASP site that hits up an Access database of categories of
products and products. (e.g. Categories = Napkins, Tablecloths;
Products = 20x20 Napkins, 21x21 Napkins, 54x54 Tablecloths, 60x60
Tablecloths)

We currently have select boxes that when you select a category, it
populates the next select box with the proper list of products (i.e. I
select Napkins as a category, I get a listing of the Napkins)

We would like to put a clickable link before each of these select
boxes that would pull up a pop up with links from the records from the
proper table.

(e.g. I click the categories link and a popup with html
anchor tags of Napkins and Tablecloths appear) I click on the Napkins
anchor and it populates the Categories Select box with Categories and
Napkins being selected.

Include More Than 1 Include File
I want to be to call my menu from another file onto my page so that i dont have to add it to every page of my website. The problem is when i try to add it using the include method it says that only one include file is allowed on an ASP. The other include file is my connection string so i cant really take that out of the page because then nothing else will work!

How can i get the menu page included as well as the connecting string?

Have added the code below, i have highlighted the 2 include files that i want to use in blue, i have also left the div tag in for where i currently have the menu which is what i want to take out and have ther include file there instead, if that makes sense. Basically the bit in red i want to be able to remove from all of my pages and add the blue file above the red code in instead, but i dont know how!!!!! Code:

Formatting
I have a report that I render out as PDF.
I have two sections in my Details section of the report.
I want to format the background of each section. so one
half will be one colour and the other half will be a
different colour.
Anyone know how I can do this?My Details section simply consists of labels and database
fields.

Formatting
I have an excel sheet that has been converted to cvs using a PHP script (wasn't possible in ASP). During the conversion, all the »'s on the original excel sheet were converted to ?'s.

But when I search within the cvs using the instr function, it fails to recognise the question marks.

For example, I output the cvs and I see the following in the main cvs code:

,'', '','','? Hardware Information

But when I search for this chunk of cvs using the instr function it returns a value of 0, yet searching for it in IE the using the find tool after I response.write all the cvs will find it no problem.

The only explanation I can think of is that the question marks must be in a strange format. I have tried using the replace function to remove all the question marks, but they still appear. So the "?" I type and the "?" generated by the PHP script must be a different format somehow.

With numbers, you can format them with cint for example, is there something similar that I should format the cvs with to fix this format problem?

XML Formatting
I’m having an issue saving/reading an xml file.The source of this file is a the parameter of an object. Through the UI the user can change the value (xml string) of this parameter.

The problem is that the parameter needs the xml with > , < , and " instead of the > , < , " chars. However when I save it, the xml dom and even the fso save it with the actual xml chars. Other than a literal search, is there an easy way to convert the file to have the special chars?

Formatting
Is there a way to format a textbox such that when the user types in the number 4000 it will be automatically formatted to $4,000?

Formatting Variables
I am requesting a variable for the users' network username:

<%=Request.ServerVariables("LOGON_USER")%>

This returns the following:

NETWORKJ.Bloggs

Instead I would like it to return J.Bloggs on it's own with out the "NETWORK" bit so basically I am saying how do I cut out the first 8 characters of a variable.

Report Formatting
I have users typing in information into a text box. Sometimes this information can be lengthy and contain simple formatting such as spacess between lines and line numbering. For example:

1. List item number one

2. List item number two

I then have a report page that prints out this information. Unfortunately, the line spacing doesn't show up in the report. It's just all jumbled together. I'm just using <%= Notes %> to show the db field. Is there a way that I can show the formatting that was originally entered or do I need to use some kind of word processor like I am using to type this post?

Form Formatting In Asp
I would like to know how to format phone numbers and ssn numbers in textbox. That is when I enter the phone number, it is going to the database as 000,000,0000. I want to have it as either 0000000000 or 000-000-0000. Likewise, for ssn also. I am really fed up with javascript, somehow, it doesn't work well for me. Always, get page errors and it is not that easy to find out the errors in javascript.....

Date Formatting
i have a date in the following format: 12/1/2003

how do i reference just the 'day' portion of this date - in other words '1'

if the date was 12/10/2003, then i would just want the '10'

Time Formatting In ASP
I'm developing in ASP/VBScript using DreamweaberMX, w/ an Access 2000 DB as the
data source. The source of the data is coming from a third party, which I get as
a CSV and import into the database, updating it weekly.

Since I have no control over how the data is collected, I'm not sure how to fix
this problem, but here it is.

This is a database of movies and among the many fields I import is one for the
movie's length, expressed in HH:MM:SS. This comes into the Access DB as a
Date/Time format, which means all the dates, displayed raw in the DB, look like
"12:09:52 AM". Through data formatting, however, displaying it to the client as
HH:MM:SS is no problem. (Display "12:36:00 AM" as military time (00:36:00) tells
me the movie is 0 hrs, 36 minutes, 0 seconds long. Follow?)

But in an update form, which we'll use to correct errors (and there always seem
to be errors in the running times of movies), I can't figure out how to display
it in the HH:MM:SS format in an INPUT field and have it submit without throwing
a data type mismatch error. It seems to want to display as "12:36:00 AM"

Converting the field to a text type is out of the question at this point, so I
know I need to do some type of string manipulation prior to update. However, I'm
lost ...

Any ideas?

E-mail Formatting?
When e-mailing invoices and estimates, is there any way to customize the
presentation of the e-mail beyond changing the message? Specifically,
I'd like to add some html so the receiver can click on a link to pay
online. As it is, I can type the URL in the message, but it appears only
as text to the reader, not a hotlink, which, unfortunately, is quite
vexing to some of my clients.

It would also be nice to add a company logo, etc. to the email body.

On this same subject, is it possible to send the entire invoice/estimate
as HTML rather than an attached PDF? I haven't seen these options
anywhere.

XML DOM And Saving Formatting?
I'm currently doing some work with ASP and XML DOM.

Is there any way when saving XML to get ASP to save it in a formatted way? Similar to PHP's formatOutput setting? At the moment my xml is being appended on line e.g

<test>1</test><test>2</test>
Is there a setting to get ASP to save XML like:

<test>1</test>
<test>2</test>

The XML document I'm working on is fairly large and its proving very difficult to read through the xml at the moment.

Formatting String
I have one string variable and value stores something
like this:

st = "From: ""John Thomas"" <john@test.com.au>"

when i test it display some thing like
From: "John Thomas" <john@test.com.au>

How can I pick up only display name and without double
quotes. i.e. it should display only

John Thomas

Correct Formatting
I am trying to parse this response.write string but its coming up with a formatting error - can someone please tell me where I'm going wrong?Code:

Response.write ("<input name=""URL"" type=""text"" value=""http://www.evolvewebsitedesign.com/news-indiv.asp?news=" & rssite("News") & ""/>")

Correct Formatting
I am needing to response.write a variable within a snippet of Javascript.
My Javascript code that I need to response.write with the variable is below:-Code:

response.write ("imageArray[ImageNum++] = new imageItem(image_dir + ""variable here"");")

I can response.write the static Javascript string fine. The problem arises when I try and state a variable into where it says, 'variable here'
The variable I need to include is
Code:
rs.Fields("ImgURL")
Would someone please be able to show me the correct formatting for this Javascript string which includes the variable.

Save Formatting
Is it possible to have line feeds/breaks automatically entered when the text wraps to a new line? I am using a <textarea> input on a form and using the <pre> tag when displaying the text to a html page (embedded in a .asp page). The text is being saved to a sql database. Returns seem to be displayed. But the wrapped text just displays as one long line.

Formatting Columns
I have a SQL 2000 table with data I display in three columns. The code
I am using sorts the data horizontally but I need it sorted vertically.
Here's the code I am using. Perhaps somebody can help me find a way to
modify it.CODE

response.write "<table width='100%' cellpadding=1 cellspacing=0>"
if not oMain.eof then
count = 0
do while not oMain.eof
if count mod 3 = 0 then
'there are 3 in the current row, so end the row and start a new
one...

Formatting Date
I'm currently entering the date into my date field using the now()
function, which delivers this result: 2/2/2004 9:08:09 AM which is
fine for some cases.

However, when retreiving this result, sometimes I'd just like to pull
up the first part, such as the 2/2/2004 and cut out the rest. How do
I take this date output, and format it to show only what I want? I'm
writing all this in ASP.

Date Formatting
I am trying to display dates in a spreadsheet, but the dates need to be in a
format that will allow them to be sorted in Excel. The datatype in the SQL
Server database is datetime. In this case, I need to display the date only,
not the time. But I don't want to change the datatype in the database
because the time is used in other places.

So what I am doing is pulling it out of the database, then modifying it in
ASP/VBScript by using the datevalue function. This results in values such as
3/31/2006, 4/3/2006, and 4/14/2006. The problem is, the ones with the
single digit date (4/3/2006 in the sample data I just listed) messes up
Excel's sorting capabilities. How can I force the dates to display in a
2-digit date format? It would probably be good to do the same for the month.

Formatting Percentages
OK, I know about FormatPercent and it changes a decimal into a percentage, but is there an analagous function to change a percentage into a decimal value?

Date Formatting
does anybody know if you can change the format of
a date from the us version 10/20/04 to the european way
20/10/04?

Text Box Formatting
I have an ASP site pulling from a SQL Server. When I pull a text field from the database into a text area, it keeps the formatting. If I pull the data from the database on a response.write, all of the formatting is lost. how can I prevent this from occuring?

Formatting EXCEL
I am using the response.ContentType = "application/vnd.ms-excel"----Works GREAT! I send all my SQL querie info from my asp page to an excel spreadsheet. Now what I need to know is there some fuctions I can use to set all the format parameters of the spreadsheet i.e. font style and size, columns to autofit!!

Formatting String?
I'm having a problem with the following:

I'm passing a query string from one script to the other via a hidden input.
Right now I'm just response.writing the query string out to make sure the
query is getting there.

The query string will display no problem if the query has no single quotes
( ' ) i.e. returns:
SELECT * from table WHERE int_field = 123 ORDER BY id

But when the query contains quotation marks to handle text it chokes, i.e.
returns:
SELECT * from table WHERE text_field =

when this should be:

SELECT * from table WHERE text_field = 'textvalue' ORDER BY id

I've tried various arguments with the REPLACE function, but can't get it to
work...

Running SQL2000.

Formatting Textareas
I made a simple update page for people post quick messages. However, I'm having problems on formatting. Before I insert into the MySql database, I replace all the ' with ', but how do I keep it looking the way they typed it?I need to know how to enter
where they pressed enter, etc. Once it gets inserted, it mashes the whole string together.

Memo Formatting
i have an access database which i am displaying on a .asp page-the field i am using is a memo filed full of formatted text.

The code i have been used to using to keep the memo text formatting is: -
[<%=Replace(Recordset1.Fields.Item("Description").Value,chr(13),"<br>")%>]

But the site was created by someone else and the way they place this content is: -
[<%=productdescription%>]

Which obviously does not keep the memo text formatting

Textarea Formatting
I'm looking for some basic end user textarea formatting, similar to the formatting available when messages are created in this forum, bt even more basic.

I really would like let the user add hyperlinks and to add bolded text without knowing the html tags for these. Any suggestions on where to look for this. Ideally something that would work with all browsers (i.e. including Opera).

Formatting HTML With ASP
In PHP I can write something like this:

echo "<option>whatever</option>"

The "" would format my HTML code. How can I get the same result with ASP?

Number Formatting
I'm having a problem getting a number to display correctly. The number is the result of a calculation and I am then using formatnumber to remove any decimals.The number displays as '1,345' is there any way to get rid of the comma.

Formatting Date
I have two dynamic listboxes.One is a date and needs formatting.I am using DWMX and therefore used the format function within the dynamic listbox wizard.When I run the page the listbox without formatting is ok, but the date listbox returns the following:

Microsoft VBScript runtime error '800a000d'. Type Mismatch 'DoDateTime' /admincontacts.asp, line 189

Line 189 is the following:

<option value="<%=(rsAdmin.Fields.Item("Date_Added").Value)%>" <%If (Not isNull(DoDateTime((rsAdmin.Fields.Item("Date_Added").Value), 1, 4105))) Then If (CStr(rsAdmin.Fields.Item("Date_Added").Value) = CStr(DoDateTime((rsAdmin.Fields.Item("Date_Added").Value), 1, 4105))) Then Response.Write("SELECTED") : Response.Write("")%> ><%=(rsAdmin.Fields.Item("Date_Added").Value)%></option>

Text Formatting
I have been having problems with an ASP page that extracts a newsletter from an Access DB. The record in the database has the proper format, meaning that after a paragraph, you can see that the enter key was pressed twice.

Problem is that when the newsletter is shown on the internet, all of the paragraphs have been run together. I don't know why this is happening.

Conditional Formatting
i have an simple invoice sheet and in "total" coloumn i need to put a formula like IF < 8.50 THEN VALUE =8.50.it is something like we dont do delivery less then 8.50 so if the TOTAL is less than 8.50 then it should turn in to 8.50 automatically.