One is that is there anyway I could use cookies or anyother method so that when my visitor visits my site,it will display "Hello ComputerA" where ComputerA is the name of the computer the visitor is using.
I have frontpage2000 and access 97, i tried to create a webdatabase wizard using fp2000, then i go to the folder where the database was created by fp and tried to open the database(.mdb) file in access97 and it prompted "Unrecognized database format c:foldernamefile.mdb".Could this be because i have fp200 and access97?
Is it possible to store html tags in a database field so that when data is retrieved from this field the formating is retained? For example I have an address field in my database, which I return using:
<p><%=(rsType.Fields.Item("DAT_Address").Value)%>
However they are times where I may want to have my city, state etc on seperate lines by using <br>, but right now if I store a <br> in my database it does not affect the formating of my displayed address.
I set up a menu program for a client a few days ago using ASP and an Access database. I have a field in a form with a popup calendar. The form field is such that a date will be entered as 09/05/2005 (short date).
I specifed as much in the Access database when setting it up. Ok, so it was working great for a few days but then today I went to open the program on my father in laws computer (in Hungarian) and when I open the Access database, the date field is entered like this - 2005.05.09 I am clueless as to what is going on. Anyone shed some light?
I have an access db from which I would like to display records in a formatted manner. I can display all the records one after the other on one page no problem, but I would like to display maybe 6 records on one page (3 across, 2 down). I would then need a page break for printing purposes.
Displaying all the records on one page would be fine if I can put a page break in so that they print correctly. I currently have it fomatted correctly, but my loop is not working correctly. Instead of different records displaying, I have 6 of the same record displaying, then the next record displaying 6 times, etc.
Even if it's better to do this over multiple pages, that would be fine as long as I can print the report with all records by clicking Print only once. Maybe even display the records on multiple pages with next and previous buttons, but when the user clicks print, then it would print a report from access.
I hope this all makes sense. Does anyone have any ideas or suggestions or pointers on the best way to do this both for viewing and printing purposes? Code:
my database, sqlplus oracle, has a column ccexpiry, whch is set to date. In my form in asp, there will always be an error whenever i pass in a date that is not in the DD MMM YYYY which is the standard for oracle. My qn is how can i pass in a date that is in DD/MM/YYYY format? Code:
I am using the code below to add a date input into an access database.
Quote: rs.Addnew rs("Date")= Request.Form("Date")
Instead of inserting a date with the format dd/mm/yy, a date format of yy/mm/dd will be inserted into the database.
I entered the following code before the insertion Quote: response.write request.form("Date") and it displayed the correct date format as dd/mm/yy.
Pls how do I insert the date into the database for it to store the date as dd/mm/yy instead of as yy/mm/dd. The date format in the date field of the database is dd/mm/yy.
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.
I 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:
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.
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 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
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); }
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:
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 >>>
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.
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.
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?
I 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?
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?
