At the moment I'm entering a new record in my database for every pageview (the record holds several things like IP, useragent..etc). I think this is asking too much of my database, and I get a lot of errors all the time.
Perhaps I should switch to entering each 'record' into a XML-file, and use that for my statistics? Any disadvantages, performance issues?
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
Any suggestions on where to start?
if there any asp or vb functions that can convert any audio format files to vox format.
View Replies View Relatedhow to format date in MM/DD/YYYY format in ASP?
View Replies View RelatedI was wondering what would be the best function to format a name.
Say I have a function FormatName that takes in a string that is FRED SMITH and needs to return Fred Smith. The function basically needs to make sure the first character of each word is capitalized. What is the best way to do this?
how do you format an email in asp. For example: i want my email to read, The following customer has requested two tables then on the next line, it should provide customer's name then next line address and on and on.
Quote: Originally Posted by nschafer Or if you want a button instead of a link:
<input type="button" value="Close" onclick="opener.location='yourhomepage.htm';window.close(); ">
This will redirect the page that opens the popup as well as closing the popup.
I must have the format of the below line wrong for IE:
click <a href="cal.asp?sdate=<% =strDate1 %>&location=<% =strLocation
%>&eTime=<% =strDate2 %>">here</a> to add this information to your
Calendar<br>
When I hover my mouse over the link, the status bar at the bottom of the
page for IE says: shortcut to 2006 11:00 AM
With Firefox I get: http://sd-school/forms/cal.asp?sdate=10/18/2006 10:00
AM&location=Library&eTime=10/18/2006 11:00 AM
The form works in Firefox, which is what I use for testing. So either the
format is wrong, or IE doesn't like the spaces or something. It doesn't
matter which dates I use, I get the same results.
i am encountering some problems in converting some data into CSV format..i have alreadi retrieve the data however i do not knoe of ani methods of converting to CSV...is there ani method to save the directory to .csv
View Replies View RelatedCan someone help me with this request?
1. Data in my access database have the format "9/10 2005"
2. When I show all dates within an asp page I get the following format
"9/10/2005"
The format I want to show in my asp page is the following format "9/10-05"
My database (access) has a date field.
When I display the date through a recordset, it comes back in US format (mm,dd,yyyy)
How do you make it appear in UK format (dd,mm,yyyy)?
I have a problem don't know how to write the attachment file frm mail....
<html>
<head>
<title>Thank you for reply with us.</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<%@ Language=VBScript %>
<%
Dim strBody
Dim myElement
For Each myElement in Request.Form
Select Case Left(myElement ,3)
Case "txt","sel","rad":
strBody = strBody & Replace(Mid(myElement,4,len(myElement)),"."," ") & _
": "
if Len(Request.Form(myElement)) = 0 then
strBody = strBody & "UNANSWERED"
else
strBody = strBody & Request.Form(myElement)
end if
strBody = strBody & vbCrLf
Case "chk":
strBody = strBody & Replace(Mid(myElement,4,len(myElement)),"."," ") & _
": " & Request.Form(myElement) & vbCrLf
Case "are":
strBody = strBody & Replace(Mid(myElement,4,len(myElement)),"."," ") & _
": " & Request.Form(myElement) & vbCrLf
End Select
Next
strBody = strBody & vbCrLf & strFooter
'Time to send the email
'Dim smtp
Set smtp = server.CreateObject("CDONTS.NewMail")
'******************************************
' set the mail properties
'******************************************
smtp.Subject = "ApplicationForm"
smtp.From = "ApplicationForm"
smtp.To = "connie@auroraxsis.com"
smtp.Body = strBody
'******************************************
' fire off the email message
'******************************************
smtp.Send
'Response.Redirect "thankyou.asp"
'******************************************
' check return value error code
'******************************************
'if objMail.errorCode = mmeNone then
' Response.Redirect "thankyou.htm"
'else
' Response.Write ("Mail message was not delevered to the SMTP server." & "<br><br>")
' Response.Write ("Please try again later" & "<br><br>" )
' Response.Write ("The error code was :" & Cstr(objMail.ErrorCode) & "<br><br>" )
' Response.Redirect ""
'end if
'******************************************
' always destroy the object
'******************************************
' set smtp = Nothing
' Response.Write ("Thank you for advertising with us. We will revert to you soonest possible.")
' Response.Redirect strRedirectURL
%>
</HTML>
<script language="JavaScript">
<!--
//set message:
msg = "Welcome To International Education Counsultancy";
timeID = 10;
stcnt = 16;
wmsg = new Array(33);
wmsg[0]=msg;
blnk = " ";
for (i=1; i<32; i++)
{
b = blnk.substring(0,i);
wmsg[i]="";
for (j=0; j<msg.length; j++) wmsg[i]=wmsg[i]+msg.charAt(j)+b;
}
function wiper()
{
if (stcnt > -1) str = wmsg[stcnt]; else str = wmsg[0];
if (stcnt-- < -40) stcnt=31;
status = str;
clearTimeout(timeID);
timeID = setTimeout("wiper()",100);
}
wiper()
// -->
//-->
</script>
<style>
BODY { margin-top: 0.00in; margin-left: 0.0in;}
BODY{
scrollbar-face-color:#f5f5f5;
scrollbar-arrow-color:#000000;
scrollbar-track-color:#ffffff;
scrollbar-darkshadow-Color:'#FFFFFF';
</style>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="75%" cellpadding="0" cellspacing="0" height="40%" align="center">
<tr>
<td valign="middle" width="25%" height="288">
<div align="center"><img src="http://www.iec.com.my/images/tk.jpg" width="576" height="198"></div>
</td>
</tr>
</table>
</body>
</html>
I use an ASP mail object to send orders filled online to a recipient via an e-mail. I would like to know if it's possible to format the way the order looks in an e-mail? I tried the following, but see no change in the format:
H1 = "<b><font size=2 color=#ED171F face=Verdana, Arial, Helvetica,
sans-serif>Order Type:</font></b>"
StrBody = H1 + Request(OrderNum) + vbCrLf
Then I get Order Type: just as plain as it would come if it didn't have any formatting.
If I do the following:
StrBody = "<b>Order Type:</b> + Request(OrderNum) + vbCrLf
Then I get <b>OrderType:</b> as the heading.
Does anyone know if it's possible to format the way the text look in an e-mail that is sent using the ASP Mail Object? Is there a different way of controlling the format/appearance of the text that appears in an e-mail?
I've looked over the last 2000 posts for info on incorportating an RSS feed on a web page using ASP to control the display - especially which elements are shown and how many items are shown. I found a free ASP script that I hoped would do the job >>>
View Replies View Related<%Response.ContentType = "application/vnd.ms-excel"%>
which save my asp query to excel, but the TYPE of excel it saves as is WEB PAGE. is there a way to save as a excel workbook?
I've had some excellent help before on this forum and hoping for some more.
This is probably very basicbut I'm kind of muddling along a bit and it's a miracle I got so far.I have a memo text field in a table form and I'm wanting to enter text into it but all a small amount of formatting. Just basic paragraph breaks would be a start. This is kind of following on from a previous post of mine where I was trying to include line breaks. This was the solution.
Code:
<textarea name=whatever WRAP="HARD">
got anyone know wat is the code for
date format?i need to display the next 3 days's date as default value
I have some pictures in database.now i am printing it using response.write in one page.It is working properly.I want to print it in such away(it should follows google page)like every page it should print 2 and then another page.
View Replies View RelatedIs there an easy way to format a number into a currency display style eg:
$100,000.
I have this set in my Access database on the field but my asp produces:
100000
Is there perhaps a formatCurrency command or something like that in ASP?
can anybody help me out?what i need to do is -- upload a .doc file to an
html format so that the formatted text is not changed.
I am trying to create a form and I have looked on the forums and couldn't find anything like this.
Situation.
I want to convert example S.S. number from this
123-45-6789
to this
XXX-XX-6789
How can I do this in ASP?I tried a replace function but doens't work or I have it completely wrong format
In one of my asp webpage,i am fetching the data from a XML file and which indeed is fetching data from mySql database.
Now the date time format i am getting in from XML is "Wednesday, October 24, 2007, 2:03:42 PM" and when i display that time in my asp webpage then it shows like
"Wed, 24 Oct 2007 19:03:42 +0000"
I'm currently building a form and I'm attempting to take the date and convert it into the same format as an unformatted date in Excel. I believe it's called SAS.
Is there any way to format a date into this format using excel?
How would I format this dropdown box to uppercase and where would I place the UCase syntax?
<SELECT name="txtSearchCity" class="form">
<%
Do while not Rs.EOF
%>
<option value="<%=Rs("Addr City")%>"><%=Rs("Addr City")%> </option><%=Rs("Addr City")%>
<%
Rs.MoveNext
loop
%>
</SELECT>
i want my query be displayed in printable form.is it possible to resize the window(page)?
View Replies View RelatedI have a column "ctime" and for some reason when I pull the data it brings up date and time.I only want the time.how can I format it to not show the date?
View Replies View RelatedI have and XSL page that transforms my XML data from MSSQL. The way I display datetime variable from XML within XSLT is:
<xsl:value-of select="ms:format-time(Modified, 'h:mm tt')" />
Which is fine, except it gives me time in UCT, when I need it in Eastern (-5 GMT) time.
XML actually has the correct data and it shows -5, but XSLT will only display UCT. How can I fix that?
Working in VBScript ASP page with MSAccess Db. Well I'm darn embarrased for this to be my first post on here - you know when you've solved all the big stuff and then some tiny stupid little thing sends you flat opn your face ?
I want to put a time into my sql statement, like this :
INSERT INTO hoursTbl (opening,closing) VALUES ('09:15','17:35')
or
#09:15#,#17:35#
or
#9:15:00#,#17:35:00#
etc etc....
nearly all of them work if I run them in Access itself, but none are working in my ASP page. I get the standard 'syntax error in INSERT statement' error message
Is it a special syntax I need?
This seems to be a pretty basic question, but I can't find the answer. In
VB I format a number by: format("1234", "#.00") (result: 1234.00)
This doesn't work in asp, I get an error. How do I format numbers?
I want to be able to format a phone number to add the spaces.
Input 0234787655
Change to : 02 3478 7655
how possible is this ..
How do I split 12345678 into 12 34 56 78?
View Replies View Relatedon one of my web page, i have a number field for percentage. the value for this field is decimal. i want the value to be in ##,## format no matter what the regional settings are.
the value will be saved to database whose format depends on regional settings. i use sql server 2000. how can i do that?
I use <textarea> input more than one paragraph to the database, whose field
type is set to "text". Then I retrieve it to display in <textarea>, which is
OK, paragraph by paragraph, but not in the other tabs because of no <P> or
<br> between each paragraph.
Is there any solution to display in other tabs
than <textarea> paragraph by paragraph. Or do I have to change the database
field type other than text? And which type is good in this case. Thanks for
any idea.
How do i check the format of the field I am reading from a Excel table. I'm using a adodb connection to query an EXCEL/ACCESS table and display it on browser. Is there any way to check the format of a particular field that is bieng read.
For example how do i check whether a field that is read is in date format...?