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.
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?
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:
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:
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 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:
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?
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?
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.
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.
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
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?
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.
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.
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
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.
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 =)
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.
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?
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".........
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?
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.
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.
