i have a field in my form which auto adds the date to my database, its inputs as 1/09/2007 and what im after is when i retrieve that data to be displayed i would like the date to be displayed as 9th September 2007,
View RepliesI was talking to someone back at Uni. He showed me his web site. He had - and + to increase the size of his web page or to decrease it so the user can always see everything on screen.
He did it in asp. I'm interested to know how it was done.Does anybody know how to do this?
i have an insert record and edit record page. When inserting to the db, it uses now(). When I go to edit an existing record the date stays as the original date. How do I make the date change to the amended edit date?
View Replies View RelatedI have one auto number problem in one table in sql server 2000. I'm inserting new record using insert statement and am not giving any value for that field as its auto number.
On the very next statement , I need to know which number it inserted in auto number field for that record??What should be the logic?
I am trying to retrieve the last value in my table in the ID column and auto input it in a field in my form when I open the form page (form.asp). This is what I have but it is obviously not working. ?
<%
dim Rs, SQL, conn, ID
Set rs=Server.CreateObject("adodb.recordset")
SQL = "SELECT TOP 1 ID FROM Table1 ORDER BY ID DESC"
Rs.Open strSQL, conn
ID = Rs.fields("ID")
end if
%>
<input type="text" name="ID" value="<% =ID %>" size="13">
It is switching between American and European date formats - this is causing problems on the page which use the Date function. Most of the time the page works ok but sometimes it seems to switch formats and this messes up the code on the page.
I have spoke with the people who look after the servers on which the site runs but do not know what is causing this. They have not made any changes to the date format of these machines. The website and the database are kept on different servers. Has anyone came across this problem.
I am developing small asp application.There is a database called db.mdb and there are three tables(tblUser,tbsImport,tblcitylist) In tblcitylist there are two fiedls
1.Town
2.LReg
According to the relevent town there is a LReg (Lreg is a name already assign to the town)
this part is ok.
In my tblUser there is a field called Town and LReg (Same as above table)
But here LReg is empty.I mean there is a default value called "N/A"
I need to create a asp page for following purpose
* i need to read tblcitylist table and according to that I need to fill the LReg fields of TblUser Code:
sqlstr ="INSERT INTO BorrowerTab VALUES('" & strName & "','" & strEmail & "','" & strPhone & "')"
These are the 3 fields i wish to insert value.
I cannot do it because there is an auto-number field in my table.
How do i tackle this ?
The error tht i get is query or destination are not the same
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
i have a field with a list of wrong ID (random) and i wish to replac
them with a sequential (auto-increment) value. how to remove the valu
and to add in the sequential ID?
i can use this to change the time on my site by +2 hours:
offsetminutes=120
thetime=dateadd("n", offsetminutes, time())
but, say it's 11pm.. the script above will make it 1am, but will the date in " date() " go ahead one day too?
the other thing i could do is this:
offsetminutes=120
thetime=dateadd("n", offsetminutes, now())
using now() instead of time(). but then when i want to print " thetime " onto a page, ill get something like "7/11/2005, 5:10:13 PM". how could i then separate the new date from the new time and print them to a page separately?
I have an asp page that I'm trying to make, that will allow users to start a new time sheet. when doing this, the users will select a pay period start and end date. I have a table with the days of the week for two weeks (i.e. mon1-sun2). When users select the start and end dates I want to populate these fields with auto increment... Soo my question is, does anyone know how you auto increment the date using ASP?
View Replies View Relatedi'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
View Replies View RelatedI just recently created a html form and one of the fields required a date. I want to make it so it will insert the date when the form is being filled out. For example, if I fill out the form today I want today's date on it.
I am going to connect this form to a MS access database, the database also has a field "date". How would I like all these together? Also, I want to send a notice to a specific email whenever someone submits the form.
In a connection string, I have the following:
sql3 = "SELECT DISTINCT State FROM Property Where TypeID = '" & srch_cat & "'"
In the database, is a field called expiredDate I am trying to show only records whose expiredDates are greater than todays date, but I am messing up somewhere. The values in the fields are as this: 3/7/03 (or something like that...no time is added to it)
"SELECT id, title FROM Businesses WHERE Date_Added >= " &
Request.Form("Since_Date")
This SQL string returns all records from the table Businesses and does
not seem to be able to recognise Request.Form("Since_Date") as a valid
date. The Since_Date value is entered into a form field as
"01-Jan-2005" and appears to be treated as a date; when viewing the
SQL statement(with a response.write) it shows the date as 1/1/2005
even if it is entered into the form as 2005/1/1
I've also tried CDate(Request.Form("Since_Date")) with no luck,
although this was the treatment that worked when the SQL statement was
running in an .idc file.
Date_Added is a regular DateTime field in an Access 2000 database
Any suggestions please ?????
I tried to Display data from field DB (mysql) into a Textarea to edit the text. The code I used is : Code:
<textarea name="warranty" cols="90" rows="6" class="style55" value="<%=WARRANTY%>" type="text"></textarea>
And it does not displays the data.?
I need to display only a portion (like the first 100 characters) of a field in a database. I don't recall how to do this.
View Replies View RelatedI am using access Memo field to store text of large size. If I use <%=memofield%> in simple display, it does not look like a formatted field and all text comes in a single line without any break.
Even If the text is same like what I am posting in this thread, out come will not have break in browser's display.
From my system, it allow product has multi-category, so I need to save
all category names which one product belong to into one field on a
database,
and record saved like " nameA|nameB|nameC " - seperate by "|".
question 1:
the second time when i update the record for same product name, how to
have a record
like "nameA|nameB"
After multi-category name saved, then, i would like to generate a
navigate name with the link like
home > nameB > name of product
question2:
so how can i retrieved only one name from category field.
I so thought I had this down and I was getting excited, but when I ran it, it didn't work. I've tried a few different things and I can't get it to work (not smart enough I guess). Code:
View Replies View RelatedI have a timesheet application I'm working on. The user fills in a form which sends data to an Access db. On the results page I need to display the values from 2 fields; i.e if the user selects "Report Writing" from a drop down list, I need the data contained in another column called 'Codes' to display as well.
View Replies View RelatedI 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.
I have a VBScript function:
<script language="VBScript" type="text/vbscript">
Function Main()
set wshshell = createobject("wscript.shell")
struser = wshShell.ExpandEnvironmentStrings("%USERNAME%")
strdomain = wshShell.ExpandEnvironmentStrings("%USERDOMAIN%")
msgbox struser & strdomain
End Function
</script>
That works great as a Active X script but I want this to display as a value in a text field and I can't find how o do that.
How would I get the max record + 1 to auto-populate in the GMVINC form field? I have a feeling that my query is not correct. Code:
View Replies View RelatedI need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a
webpage (ASP)
I can retrieve the recordset from the database and display the field data
results in rows of a table but have the entire 60 character string in one
cell. I need to break that string apart and put each semi-colon delimited
value in it's own cell. Then move to the next record and do the same thing
in the next row of the table. - and so on
I'm using ASP, VB Script with DMSII Database and OLEDB
Does anyone have some code examples on how to break this field apart and
then arrange the data into an html table on a webpage?
I get a date diplayed from the database
in the format month/day/year eg 10/25/2007
but I want it displayed as day/month/year 25/20/2007
I have a slight problem with the way the date is displayed when it is retrieved from the database.When I write the ASP-code like this:Code:
<%=rs(“date”)%>
The date is displayed like this for July 10:
7/10/2005
That’s probably fine for many people but not for me. I want to display the same date like this:
2005-07-10
I have a variable that is set to:
vD1 = 2004/1/1
vD2 = 2004/1/15
I am doing an if/then that looks to see if date() is > vD2. If so then response.write vD1 & " to " & vD2. When I write out the variables, it is giving me the numeric value of these dates:
334 to 105.473684210526
How can I convert these values to either yyyy/mm/dd or dd/mm/yy?
Currently working on a ASP for a friend, which requires the date and
time on it. It pulls in entries from an Access Database with dates and
times in the format of:
"Fri Oct 17 18:02:46 2003"
However my date and time on the ASP page is displayed as:
"Friday, October 17, 2003 18:02:46"
using the script:
"<%Session.LCID = 1033%>
<%=FormatDateTime(Date(), vbLongDate)%>
<%Session.LCID = 2057%>
<%=time()%>"
Anyone know how to change this script, fully or partly to produce the
date and time on the format that's in the access database i.e. "Fri Oct 17
18:02:46 2003" Code:
I have one field char type data length 1.. It has data either 1 or 2 in all the field tht I have checked through enterprise manager.
I'm running query:
"select * from table" and fetching all the records and displaying...
It display all the data except data from this field..Doesnt display anything..
I had put Response.write rs("fieldname")
What could be the problem?
I am creating an access DB that has job listings and displays the DB online.
I am creating tables rows for 'BeginListing' and 'Endlisitng' etc that are stored as a Date
How do I get the asp/vbscript to check the date 'EndListing' of the entry and to stop displaying it when the date is later than today (so it takes them offline when the date is expired)?
My script is like this and loops through each record set displaying the contents: ...
Just wanted to know how to change my display of the date at the moment it is displayed as:
04/26/2005
Which is bizarre if your from the UK(), so does anyone know how to change the month and day around to display:
26/04/2005
The code on the page is:
strSQL = "INSERT INTO tblCastnews (heading,content,postedby,status,[Timestamp])VALUES('" & strHeading & "','" & strContent & "','" & strUserName & "','" & numStatus & "', '" & date() & "')"