Posting Date To Oracle
I'm trying to post a date value into an oracle 9i database, using classic asp, as that's the language existing app was written in, using the following code:
to_date('"&date()&"','DD-MMM-YYYY')
that's included in the insert statement, i keep getting the following error on the page:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Oracle][ODBC][Ora]ORA-01821: date format not recognized
any ideas? i checked the database type in the table, it's set to Date.
View Replies
ADVERTISEMENT
how to do Posting Date to different Server Using asp when User submit the form.
View Replies
View Related
I'm calling an update procedure from Oracle using ASP..
<pre>
With objCommand
.CommandText = "{call cust_Update(?, ?, ?)}"
.CommandType = adCmdText
.Parameters(0).Value = varCus_id
.Parameters(1).Value = varf_Name
.Parameters(2).Value = varbirthdate
.Execute() ............
</pre>
the problem I'm having is when entering the birthdate. This is the error I get...
Microsoft OLE DB Provider for Oracle error '80040e14' I believe it has something to do with the delimiter in the date string("/"), but not sure? The Oracle procedure birth_date column is in "mm/dd/yy" format:
birth_date=to_char(i_birth_date,'mm/dd/yy')....
When I pass this in the textbox from the asp in this format I get the error? How can I resolve the ASP to take in the right characters for the birthdate?
View Replies
View Related
I'm returning a date (5th Jan 2004) from Oracle using the
following query:
select TO_CHAR(invoice_date,'DD/MM/YYYY') from...
This should return my date in the UK format, and it
certainly appears to be doing just that in Toad. And it
also looks correct in my form as it shows as:
05/01/2004
However when I submit my form I am having to convert the
date to an Oracle format using this function: Code:
View Replies
View Related
I'm having hard time retrieving oracle date with the follwing sql statement:
Select * From Document Where Mydate= #" & RS("Mydate") & "#"
I get ORA-0091 invalid character error. Then I used the TO_Date function as follow:
Select * From Document Where Mydate= To_Date(RS("MyDate"),'mm/dd/yyyy')"
I get the error expected end of statement: Now When I inser an explicite date it works
Select * From Document Where Mydate= To_Date('03/28/2005'mm/dd/yyyy')"
How do I bind Mydate into a variale and use it in the TO_Date Function .
View Replies
View Related
I am trying to enter date into oracle databalse & using oraoledb since im taking system date but the value inserted is this "20-JUL-18".
I used date()
How to format the date as to include the year in date.
View Replies
View Related
I'm having hard time retrieving oracle date with the follwing sql statement using VBScript. MayDate Column is Date Type Code:
View Replies
View Related
I get the following error message when I search for some fields stored in oracle database.
Microsoft OLE DB Provider for ODBC Drivers (0x80020009)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-01861: literal does not match format string
/documenttracking_v3/ReportMain.asp
The script functions correctly using MSAccess and MS sql, when I moved to Oracle I keep getting Date format error messages eventhough The script includes a function that forces the date format I need. Code:
View Replies
View Related
I need to update an oracle database however, i must have the format
22 FEB 2004
Unfortunately i use a date picker(javascript) which returns 22/02/2004.
(this happens in client side)
How do i change the format to "22 feb 2004" in the server before inserting into the database ?
I already have
strdate1 = Request.Form("date1")
how do i change this date format ?
View Replies
View Related
In oracle, I have a column which store date (with DAT type). The content will be like 11/08/2005 12:00:00. How can I get the exact date format in ASP?
View Replies
View Related
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:
View Replies
View Related
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
View Replies
View Related
I have a service request form in asp, which takes a bunch of data (name, id, etc). it then has 2 checkboxes, either or both of which can be checked to request a certain service. depending on which box is checked, the other data collected is inserted into a corresponding database. what is the best way to do this?
can i just use 2 IF statements (not nested) to open the connections to the databases?
View Replies
View Related
I'm building a wizard-type site and I have a form that has a fair amount of
information being posted page to page until it reaches the end where it has
all of the data from Page 1 - Page 5.
For future reference more than anything...is there a way to post all of the
data coming from a previous page to the next page? Basically I just wrote
out all of the values I received on each page into hidden variables and then
posted that to the next page every time. Is there a simpler way?
View Replies
View Related
If you have an SQL error, response.write your SQL including all variables to the browser.
If I had a dollar for every error that could be fixed in about 15 seconds after doing this, I'd have like at least 15 bucks.
View Replies
View Related
I have been left a set of instructions. One of them is to post an XML string to an address. I have my XML string, but how do I 'Post' it? I'm using ASP.
View Replies
View Related
Is it possible to post the value of a cookie through a hyperlink?
View Replies
View Related
i am trying to do Multiple Posting to different Server when
User post the Order form.
one to windows server
second to linux server
third to its own server
View Replies
View Related
I'm working on a shopping cart that uses PayPal when the user submits their information 3 things need to happen on the same page:
1. User information gets saved in a database
2. An e-mail is sent out
3. Variables are transferred via a "POST" method to the PayPal API
I've successfully made it through the first 2 but the 3rd one is killing me. How do I do this? The only way I can think to do this is with the response.redirect but it can't be a GET it needs be a POST. Any thoughts?
View Replies
View Related
My employer uses an onjline application for new hires. Currently they fill out a form which goes to ../cgi-bin/formail.pl
Of course this then email the application to them.
Once they recieve it it looks fine but when the go to print they say it prints 4 or 5 pages of garbly gook.
I havent seen this yet but i was thinking that if i could post the form to two seperat files, the fromail.pl and an asp page to insert it into an access table to later view with another asp page they could view the apps online and just print form explorer if i designed the page right
i have never done anythig with pearl before. Can I post it to an asp page then to the formail.pl. instead of posting it to two pages.
View Replies
View Related
I have a discussion forum that is working great, except that I just found out that if a person adds a reply to a thread, the thread just stays in place, weather or not if it's the first post or 7893th post. What I would like it to do is display the earliest thread, or the earliest thread with a reply at the top and work to the oldest thread. Right now it works only from earliest post to oldest post, not including the replies.
View Replies
View Related
I was using Microsoft Posting Acceptor to upload file on
web server(IIS 5) but after reinstalling my web server.
when i try to upload file it give me error
Http 405 - Resource not allowed.
I checked permission on all the directories and tried
after giving full permission but result is same
Also i checked mime extentions and found entry for .dll
View Replies
View Related
I have a login form on a page that should post the data to a non Windows
server and upon successful authentication, the browser needs to show the
secodn url.
I did the form post, got the successful results back but the browser is
still showing at the same url. Which method needs to be used so that the
browser shows the target url. In this case it's sURL in my code. sHTML is
the result from the successful result from posting the form to the non
Windows server.
As an example, imagine you want to put a Hotmail login form in your own
site, post the form using your asp.net code and the browser ends up inside
Hotmail showing a hotmail.com url.
Code Snippet:
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "text/html";
Response.Write(sHtml);
Response.RedirectLocation = sURL;
Response.Flush();
Response.Close();
View Replies
View Related
welll I'm using ASP 2.0 =)
I'm trying to do the automated form posting and submition.
What I got is Excel file with the data that I need to manually enter to
the form...
What should I use to maximumally automate it =)
View Replies
View Related
I have a table showing a list of records.On each row is a check box and a details button'.In the table header is a button to post back the checked items for deletion.
The 'detailsbutton' posts to another page to show THAT row's details and needs to post THAT row's uniqueID.
How do i go about this?I have tried jS functions that change values in hidden fields, nested forms etc and all I can get is one button working and not the other.The main problem is the looped recordID which I can't seem to refer to in JS.
View Replies
View Related
I have a problem and not quite how to go about solving it. I have a form written in asp. I wish to submit the form and have the server return back to the same page without actually refreshing the page.
I know I could write a form, submit it and go to another page. I've searched the web and I see something about HTTP Status code of 204 would return no content to the client browser. How would I incorporate this into my asp page? How do I detect a HTTP status codes in asp?
View Replies
View Related
How can I prevent posting of a form from any other site but the site the form lives on?
View Replies
View Related
I have the following script that posts a message to the guestbook database just fine. Now what I need it to do is send an email to my email address that would contain a link to my edit page where I can click to go edit it. The link should have the message_id included in it because that is how I want to choose the record through the edit page, now how do I change the below script to do this?
<%@ Language=VBScript %>
<%
On Error Resume Next
Dim oCat, strADOXTableName
call GetADOXConnection
message=""
mypage=Request.Form("targetpagenumber")
if mypage="" then _
mypage=1
myaction=Request.Form("todo")
if myaction="" then myaction="add"
if myaction="add" then _
myaction="added".........
View Replies
View Related
Dreamweaver, Access, IIS
Okay. Here is my goal: I have a database that contains a volume, a chapter, and file names in that chapter. I have a drop-down list that selects the volume (this works!) I have a drop-down list that is dynamically populated by the volume to select the chapter (this works!).
Now I want to have images corresponding to the filenames that correspond to the previous selections:
volume --> chapter --> file1, file2, file3, file4... (I have images named file1,file2,file3,file4)
My question is what is the best way to get the text name of the file stored in the database to become an image that will be posted on the screen. An array? Take it right from a recordset? Any ideas?
View Replies
View Related
I am trying to post data using xmlhttp object.
The data Iam trying to send has "&" in it, like - xx.asp?part=tm7&t6
Somehow the data doe not reach to the page correectly.
I also tried -
xx.asp?part=tm7&t6
But still it does not reach.
In my final page when I retrieve request.form("part") -
Iam getting only tm7.
View Replies
View Related
I have created a form, which has hidden fields, which are to be passed to a payment gateway using the POST method.
My problem is that the variables in the hidden fields do not get passed on to the payment page when the form gets posted. The payment page comes up empty.
Does anyone know why this is happening? Code:
View Replies
View Related
how to install posting acceptor on window2000 server.
View Replies
View Related
How can I stop some one from trying to post my form from a remote site.
I am getting some one cycling through usernames trying fpr passwords on a
web site.
View Replies
View Related
