DB Field Format
I am using MS access and for a field in my table I have a column of type date/time and I specified a medium time format. In Access it shows as 1:00 PM but when I display on the page it shows as 1:00:00 PM Why is this?
View Replies
ADVERTISEMENT
Format Date Field
i need help formating todays date minus one.
i can get this 1212006 but i need 12012006
ASP Field Number Format
It shows the data but not like in the data table (Access). I would like that the numbers have a 2 digit decimal behind the comma i.e.123.456,30 and negative numbers should be in red and in brackets i.e. (123.456,30) So, the format should be:
$#.##0,00;($#.##0,00)[Red] as I have done it in the table - but not in ASP
Where do I have to enter the format in the ASP code? - or - Where do I have to enter the format in the Html code? Is someone able to write me the coding line?
Format Number Field L
i need my field that is 10.00 and turn it into this 00001000 any ideas.
View Replies View RelatedFormat Time Field
I have this field time field in my database which has records in the military format
example:
203454
83452
113434
211413
Can anyone tell me how to come up with a slick function to show results in the normal time format
Text Field Format
I need a user to follow a format. For example entering a date. I need the user to enter a date in this format MM/DD/YY. How do I check to see if they followed that format?
I need the user to enter a currency amount without the "$" sign. How do I check to see if the Request.Form("price") value has a "$" sign in it? I guess I need to know how to parse a string in ASP.
Cannot Get To Format The Date Field Correctly
I cannot get the date format correctly in dynamic sql statement, after trying various ways of handling it. I need some help with the date format in the following dynamic sql statement. Any help is appreciated in advance. While running the asp page, I still get an error as Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'Format'
DYNAMIC SQL STATEMENT:
sql = " INSERT INTO tblExpense (ENO, EntryDate, ContractedServiceExpense, "
sql = sql & "TravelExpense, PersonnelExpense)"
sql = sql & " VALUES('" & l_ENO & "', " & Format(l_Date,
"#mm/dd/yyyy#") & ", " & l_contractedserviceexpense & ", "
&l_travelexpense & ", " &l_personnelexpense & ")"
Change A Date Field Format
In my db, I have a date field wich as the format yyyy-mm-dd but when I receive the value from the DB, I'd like to change it to dd-mm-yyyy... How can I do this?
View Replies View RelatedDisplay DateTime Field From Access In UK Format
I have a DateTime stamp in one of my Access database columns. Using now() as the default value, it enters records in the following format:
17/06/2005 14:28:40
This is perfect. UK format, just as I want.
However, when I pull this record into an ASP page it appears in a different format:
6/17/2005 14:28:40 AM
How can I stop it from re-writing the data into American format? I just need to display it exactly as it is in the database.
Script To Format Existing Access Table Into Wall Calendar Format?
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?
Convert Any Audio Format Files To Vox Format
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
how to format date in MM/DD/YYYY format in ASP?
View Replies View RelatedLEFT JOIN On A Date Field And A Numerical Field - Using WHERE Clause
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
Comparing Field Data From Previous Field
Im comparing values in a field while doing a loop if sAct<>myData(5,i) then At the end of the loop I make the value of sAct equal the current myData
This will work when comparing other fields withing my recordset (so I know the statement works) but it will not work for the field I want to compare. The only difference with this field is that it has null values. Could this be the problem? if so, how do I deal with nulls?
Fill Field Based On Another Field
I have a input form with 5 fields. One of the fields is MajorNo and the other is named Description.
I have a reference table in my MS Access database (tblMajor)that lists the major numbers and their descriptions.
I would like to have the description field in my ASP automatically filled based on the major number entered on the form, so the user will only need to input the major number when submitting to the Access table (tblSalesTotal).
Pass Hidden Form Field Value To Another Form Field To Insert In Db
I am trying to pass a hidden field value on a form into another field on the
form so that it can then be inserted in the database, to enable me then to
reference that number at a later date.
(The hidden value (1 for example) would then automatically get passed to the
other input field.)
The code for the text field that allows users to type an number into it for
submission to the db is below, but what code do i need within the hidden
field to populate this text field below so that users do not have to type the
number in? Code:
How Can I Change One Line Input Field Into Larger Input Field
I have being working with making an edit field over the past few days. The edit function is now working fine. The edit fields that i have are for id, subject, notes, timedate.
All of the edit screens are one line text screens. What I want to do now is increase the size of the notes box to a larger textarea type box to make it easier to edit notes. The notes field in the db is a textarea field. Code:
Format A Name
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?
CDO Format
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.
Format Of URL
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.
XML-format
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?
Automated "state" Field From "Country" Field
When you select the "Country" field in a Hotmail "get new account" link, the field "State" changes automatically, giving you the correct States that belongs to the chosen Country.
View Replies View RelatedSaving CSV Format In Asp
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 RelatedFormat Date In Asp
Can 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"
UK & US Date Format
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)?
Email Format
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>
Format E-mail
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?
Format Display Rss.xml With Asp
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 RelatedAsp To Excel Format
<%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?
Format Paragraph
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">
Date Format..
got anyone know wat is the code for
date format?i need to display the next 3 days's date as default value
Format Of Google
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 RelatedFormat Currency In ASP?
Is 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?