I'm trying to take a date from a form and insert it into an Access 2000 database with ASP
Here's the code:
frmClubId = Request.Form("Names")
frmDate = Request.Form("Date")
sqlStatement = "INSERT INTO testDates(ClubId,Date) VALUES(" & frmClubId & ", #" & frmDate & "#)"
Set rs = conn.Execute(sqlStatement)
I've already Response.Write the sql, so I know that frmClubId is and integer and frmDate is mm/dd/yyyy.
I have a form that I submit to an oracle database. Along with the info from the form I want to insert the date it was submitted. How should I go about doing this? I am having problems because it is the wrong format?
I am using a 'date' data type for the field. How can I convert the date into the correct format that will allow me to submit it, I have tried using to_char or to_date, but they give me an error?I tried using this to convert it, but it doesn't work, I am getting a syntax error?submit_date=to_date(date,'YYYY-MM-DD')
i m reading data from a excel file and inserting its fields into access database, everything is fine but i m getting problem when i m insertin the data string into the date/time field of the aceess database,i have use the CDate function but it is not working.what should i do?
View Replies View RelatedI am trying to insert a date into a date field through my website. The date
is pre-populated with todays date. I am getting a type mismatch error. The
Access DB is setup as a Date/Time Short Date field. Code:
i need to insert the date only into date/time field in sql server 2000. i tried this
Code:
newsdate=date()
insql= "insert into news(news_date) values( "&newsdate&" )"
ADO.execute(insql)
but it always insert the date 01/01/1900. i searched the net and found this.
Code:
newsdate=date()
theloc = SetLocale(ado.Properties("locale identifier" ))
insql= "insert into news(news_date) values( "&newsdate&" )"
ADO.execute(insql)
SetLocale(theloc)
i found a different way to insert the date or rather not insert the date at all if a certain condition is true. But anyway i have come accross the same problem when i try to update the date field with a blank value. Code:
View Replies View Relatedi have a field which accepts the date as dd/mm/yyyy but when i insert the value it becomes mm/dd/yyyy for some date values like 9 april become 4 august.... the database date format is mm/dd/yyyy and i just take the value out and display it as dd/mm/yyyy.. however ...
my update and inserts can't use the same function, cos the function is just display out the server's date as dd/mm/yyyy... how should i add i in correctly?
here's my insert and update function[img]images/smilies/bawling.gif[/img]
PHP Code:
Dim ddate, ydate, mdateFunction FormatDateDM2MD(sdate) if sdate="" or sdate=" " thenFormatDateDM2MD = "NULL"elseddate=day(sdate)mdate=month(sdate)ydate=year(sdate)sdate= ydate & "/" & mdate & "/" & ddateFormatDateDM2MD = "'"&sdate&"'"end ifEnd Function
i have another problem my date values when its 10 of Nov it comes out as 11/10/2003 instead of 10/11/2003 why? how do i solve it? Code:
i have a field which accepts the date as dd/mm/yyyy but when i insert the value it becomes mm/dd/yyyy for some date values like 9 april become 4 august.... the database date format is mm/dd/yyyy and i just take the value out and display it as dd/mm/yyyy..
however ... my update and inserts can't use the same function, cos the function is just display out the server's date as dd/mm/yyyy... how should i add i in correctly? Code:
I am trying to insert the date into a *.csv file using the following line
csvBody = csvBody & "" & fix(FormatDateTime(now(), vblongdate) & ""
The fix function is as follows
function fix(strInput)
strInput = replace(strInput, """", "")
strInput = replace(strInput, vbNewLine, " ")
fix = strInput
end function
I would like the Date to appear as Wednesday 16th June 2005 within a single cell (without commas).
this is the code im trying to use to insert a date to mysql db:
dim myquery
dim datew
datew = formatdatetime(date())
myquery = "INSERT INTO article (date) VALUES ('" & datew & "')"
this inserts a date but its always "0000-00-00", i want to get the actual date and add it to the table.
I'm trying to insert a date value into MSSQL, the type of the sql filed
is: "smalldatetime" and i'm trying to insert a text Variable that looks like this:
"19/02/2006".
.... SET update_date='" & Update_Date & "' ...
i get the message:
The conversion of char data type to smalldatetime data type resulted in
an out-of-range smalldatetime value
This seems like it should be easy but I am stumped. I am trying take a variable, add to it, and insert the result as a new record into Access.
The ending result is: ....
I have a page setup where a user can login and add news to a site.
I had to write a small function to eliminate any apostrophies or dashes in the SQL insert statemnet to prevent any errors or confusion.
My question is, is there an easier way to do this? ....
i have an access db with a "date/time" data type with a format of "Long format";
i want to add the date/time automatically in DB when a user submit a form.
i tried using the
xdate = formatdatetime("var",1)
and putting that var in the DB, but i get an error
can someone show me how to do it right?
I am trying to get a form to insert info into a access database. I am using dreamweaver 2004, i created the form with 4 text fields and a submit button. Ive added a ODBC connection and dreamweaver can qurery my table.
I added an insert record server behaviour, and i figured dreamweaver does all the work for you but when i saved and uploaded the page to my test server it would not submit and redirect to my chosen page, it only refresh the form.Has anyone out there done this before and can notice a step that im missing. Do i need to setup a recordset? because ive tried that as well and no success.
I have two tables Property & Landlord. I have a form and when it is filled in and submitted the information should be sent to the two tables, but i cant seem to get my head around this problem.
View Replies View RelatedI am trying to save arabic data from asp and it's not being saved with right encoding. i tried with both code pages 1252 and 1256. each time i am getting different set of characters in db, but not as i am entering in asp page.
when i retrieve arabic data from database and display in web pages it's showing correct text.
i am using following code in asp side: ....
how to do a dnsless connection to an access database and then insert records. The database name is members and table name is member_info.
View Replies View RelatedI'm using DWMX and Access DB.
i have setup a form on a normal http page which collects name address etc and is then passed to a https page to collect credit card details, on clicking submit on the https page the credit card details are inserted in db on secure server along with one field that was passed from the http page (the user id).
this all works ok, however i then need to pass the remaining orignal form values back to another http page that then inserts these values to another DB. ok you may be asking why.... the first forms allows the user to correct information already held on file before upgrading their listing, i then need them to pay for the upgrade before inserting the amended data in the orignal database... How..
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
View Replies View RelatedI have built an online booking system for a hotel and all is working fine except for the fact that the ‘From’ and ‘To’ dates are saved in the MS Access database in US format. The user selects from a date picker pop, which places the in the textfield as English format e.g. 02/12/2007.
However when I try and save this value into the date column in my DB I obviously receive an error because the formats are different. Please could someone advise me on the best way to convert an English date to a US in order to insert this into the DB using ASP & MS Access.
At the moment I am using plain text as the column type, but this is not ideal as I want to start to run queries against the 2 dates.
When I try to select records based on a date I get nothing back from the db. For example when I run the query:
SELECT * FROM trainingCalendar2 WHERE startDate > #04/03/2005# AND courseType = '1' AND numOfPlaces > 0 AND inuse = 1;
using the SQL editor in access and then view it in design view, the date is changed to 03/04/2005.
I have an access database which has a date field. I've entered all of the dates in valid UK format (dd/mm/yyyy). An example of the table looks like this:
Id| SeminarName | SeminarDate
1 | Introduction | 18/02/2006
2 | Other stuff | 19/02/2006
When I do:
SELECT * FROM tblSeminar WHERE SeminarDate=#18/02/2006#;
It doesn't return any records. If I remove the WHERE SeminarDate... it works fine, so something is causing the date not to match.
I'm using <%Session.lcid = 2057%> at the top of all of my pages.
Before everyone says go to this page read this page, I am new to the asp side of development and so still in the learning stage.
The Problem.
I have a website using asp and a ms access database. I have a couple of forms that get entered into the database and then update. but with this the date is added automatically into the database.
So when someone does a search it comes up what date it was posted. The trouble is it comes out in american format, where as i want it in british format. I have done what it says in some of the suggestions on the site but I either get:
nothing,
and error
or a date saying 30/12/1899.
i am trying to do a search on a database within a date range but the query pulls in details from before the time submitted.
For example :
records : 01/05/2006 Test
06/06/2006 Test 2
06/06/2006 Test 2
If i do a search between 06/06/2006 and 06/06/2006 i will get the 01/05/2006 record as well as the 06/06/2006 records, my code is as follows. Code:
I have a list of events (MAXDOB)I have a persons date of birth (DOB)Some events are only open to people under a certain age.How do i say:
if DOB > MAXDOB Then
response.write("You are too old for this event")
end if
Also what format does the date need to be in for this to work? I have been using dd/mm/yyyy.
I have created a DB in access that has the 2005 NFL season in it. I would like to display the current weeks games. I have been trying things along these lines.
<% if now() = SELECT * FROM NFLsched WHERE (scheddte BETWEEN #01-Jun-2005# AND #12-aug-2005#) then response.write(SELECT NFLSched.Game, NFLSched.EST, NFLSched.scheddte, NFLSched.Week FROM NFLSched WHERE (((NFLSched.Week)="week 1"))
Not having much luck. Can anyone steer me in the right direction?
I have an Access database with a date field The format that we store values is dd/mm/yyyy (greek)The problem is that i can't retreive the correct dates because the queries
return only the english format dates. How to format the query to english date format (mm/dd/yyyy)?
I have a db that has a field 'enddate' and I want to UPDATE all the records there 'enddate' has passed... i.e. the record has expired.
The trouble I get is that no matter what the date, it marks all the records as expired, even though some have not... It's nothing to do with the 'impressions' or 'maximps' fields as I have taken those out and the problem still happens. I have a good testing database set up, and it should be showing some results...
This is my code:.....
I am storing dates in a database. WHen i come to do sql queries on the dates access is interpreting them as US format (mm/dd/yyyy). When the date is stored in the db it is in the correct uk format (dd/mm/yyyy) but when asp passes the queries to access the date format changes if the day is above 13.
For example if the date being searched is 10/2/2006 (10th feb 2006) it is searching the database for 2nd October 2006. If the i pass is 13/02/2006 (13th feb 2006) it searches it correctly.
I have tried setting the session.lcid to 2057 but this makes no difference. I read somewhere that access automatically treates dates as US format and only tries another format if the us format doesnt make sense. Is there any way around this?
I have more than one date field on my ASP forms (and in the sister MS Access table) I can not write (created the record in Access table) to the table UNLESS there is date data in ALL the date fields on the ASP form.
I need to be able to have the user enter only one date, then do back at a later time and enter the other date.I am using the short date format in Access table (MM/DD/YYYY) When there is only one date field (on ASP form and in Access table) the date is written and the record is created.
the date format in my database(ms access) used to be mm/dd/yyyy and i've changed to dd/mm/yyyy. Now the date appears fine in the db. however wen i retrieve the data and displays in on a form, it is back to it's default format(mm/dd/yyyy). is there anyway whereby i can change it?maybe something like FormatNumber(rs("FromDate")) or whatsoever?
View Replies View RelatedI have a date field which I use var1 = new Date() to save under MS-Access field with "text" to be the data type (date/time is NOT accepting). I have tried using
var2 = new Date(oRS("field1"))
var2.getMonth() does not get the right saved month
how to retrieve the date and time using Javascript? Or I should use var2 = new String(oRS("field1")) The result of var2 would be "Thu Mar 31 11:11:11 EST 2005". Is checking the location of spaces the only way to get date and time?