Project:
- On submit of form data is inserted to oracle.
- if successful continue to step 2.
- else display error.
Question:
How do I verify that the OraDynaset.AddNew was successful ?
IF (OraDynaset.AddNew) = TRUE then
'continue with step 2
ELSE
'display error or whatever
ENDIF
???
There is one field in my database But there are 40, sometimes 100 text fields in my form page. So, can you explain me that how can I use addnew method.
View Replies View RelatedI have problem with the recordset method addnew. I donīt have the permission to do this Why?
I can add a new post with an inset questtion. I want to use addnew because I want to continue the work with the recorset.
I have give script permissions to the wwwroot maph and included the IUSER in the database. The error message is like this. The row it`s complaining to is the rs.update row.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00
I want to know the opinion of you all great guys out there whether AddNew method of recordset is better to use & secure than simply a insert statement.
View Replies View RelatedI got this login script and I edited it all and it seems to
run fine...IE it listens to the script as far as permissions go when I
place a restriction on a page and when you login it redirects. But
first it doesn't tell you that you're logged in and doesn't provide a
logout feature.
And most importantly if I type in a random username and password not
listed in the database it doesn't seem to matter it still "lets me
login"
I think it may have something to do with my database connection. I
am using an SQL database/server ADO connection. But I don't know if
I entered it right in the code. Code:
I've modified this form to my liking but would like to validate the fields as the user continues from page to page. Does anyone know what I need to do to the code in order for this work? Code:
View Replies View Relatedive gota a input box where i can enter in numbers- which load info from a db, but i want to validate the data entered so that the code will be able to show an error message when letters are entered. Is there any way of doing this??
View Replies View Relatedwhats the best way for me to validate the data that has been put into a form on my page?
View Replies View Relatedhow to compare the date entered in a textfield and the present date.i tried a sample program but it doesnt work and returned "not".its my first time to encounter date processing
code:
textfield value=1/8/2005 //what i've entered
if date_entered=date() then
Response.Write("present")
else
Reponse.Write("not")
end if
I'm trying to get my page in order using the HTML validator at www.w3.org.It reports problems in my using the ampersand '&' in the following statement. Should I be using someting other than the '&'..?
<a href="search.asp?title=Hot%20Stuff&artist=Bob&OrderBy=desc&status=av">
-------------------------------------^----------^------------^
Line 220, column 67: cannot generate system identifier for general entity
"artist"
Line 220, column 80: cannot generate system identifier for general entity
"OrderBy"
Line 220, column 93: cannot generate system identifier for general entity
"status"
I would have asked the HTML group, but I figured they may not know ASP.
It's good practice to validate input, not only where it should be coming from, but from anywhere it's possible to change or add input for a "client". If all user input is transfered using "post" you can be pretty tough on querystrings, if you use them at all.
But user input could have a name like Mc'Donald, and we would not like quotes (wether single or double) in input to a database or an asp script. Though I beleive more dangerous in SQL server there should be (?) a danger with access as well. (The infamous SQL injection) Anyone with some "input" in this matter? Escape caracters? Haven't found any. Changing the caracter "scriptwise"? Maybe
how can i validate a string so that it have only the characters of ASCII 32 to 91 and 93 to 122 ? Also if the string contains the comma (,) the whole string should be converted inside the quotes ("")
i.e.
if the string is: example string, Ok,it should be: "example string, Ok".
if I could get some guidance as to the best way to validate a date entered by a user on an asp form format dd/mm/yy. The date is then stored in a Access table. I would like to validate it to prevent the unfriendly error message if date has been entered incorrectly.
View Replies View RelatedHow can i validate that an input to a field is a number?
View Replies View Relatedsome vbscript coding on on the server side which states sumthing on the lines of if chkbox is checked then textfield should be not null.
View Replies View RelatedI need an Asp code that validates that the user has entered a number not letters.
View Replies View RelatedI have a form that has 16 comboboxes and they all drop down the same info. what i need to do is get a javascript validation to check that non of the 16 comboboxes have the same value or un-selected.
View Replies View RelatedJust wondering if you knew anyting about validating dates and when entering data into a database that already exists, how to bring up message boxes. I am currently using dreamweaver mx and its validation rules in behaviours is limited.
I need a message box to tell a user that what they are entering is not a date when a date is required, instead of dreamweavers microsoft access error, criteria mismatch or whatever.
Also a message box to tell a user that when they enter a record in a database that it already exists, instead of dreamweavers automatic error.
I am trying to take an xml file as an input from the user, providing the user a User interface where he/she selects the file they want to enter into sql database. Before updating the data in the database with this new data from the xml file, i want to validate it first to see if its in correct format, if it matches my schema. I have a schema file.
I searched for some examples online, but got examples only for asp.net. Can u give me an example how to validate an xml file in asp.
I have this JavaScript code in my html file(search page) to check and see if any data is entered in the text field. If there is no data entered, there will be this box that 'pops up' to say ask the user to enter some data.
The problem is that when I enter some data into the textfield, it is suppossed to lead to the database which i have created. But in this case, when I enter some data into the textfield, instead of opening the .asp file, it just reloads the search page(html file).
How am I supposed to solve this problem?
I am tryin to create a login page for my database,the user enters their username and password,their username and password is stored in a table how do i check that a user has entered the correct username and password before allowing them to access the next page
View Replies View RelatedI have an asp page that has a form and only 1 field which is know as the ID field.
I only want users to enter an Integer value in the field. If they enter anything else it should come up with a pop up box error and not allow them to process the page.
I am trying to sort out validation for a form to display the error message in sequence.
ie; when you click continue with blank form fields the first message should read: "Please enter your previous address (Line 1)" but instead it starts with PostCode then time at the address then town? Code:
I have two date fields on a form each made up of 3 drop down boxes:
Day e.g 08, Month e.g February, Year e.g 2008
Each date makes up a start date and an end date.
What I want to do is check if the end date exists and if it does make sure it is not less than the start date. If it is less than the start date flag a message to the user.
I am aware of the vb function IsDate()... However, I want to check that the value from the form is ONLY a time in the following format hh:mm...
Any way of doing this? (Other then using two dropdowns with predefined hours and minutes?
I am having a serious doubt in the following issue. I have written an asp page to enter the user info like the userid, passwd, address, phone no. This page first checks for the existence of userid and gives an alert message in java script saying that the userid already exists. but when the page is refreshed, once the alert box appears, all the other fields entered previously gets lost.
the page is directed to the original screen and the user ends up typing all the fields again. how do i direct the page to store all the data that was previously typed and still give an alert message? can i get some examples on how to do this?
I have a form field which asks for a date to be entered in the format of dd/mm/yyyy. Now, I've successfully programmed it so that you can only enter a date in the present or future but not in the past. However, as it stands, it also means the user could enter an unrealistic date such as 12/12/2070...I don't want this.
What I'm after is some ASP code which only allows the user to enter a date that occurs between the present day and say, the next month. So if the user was to enter 05/03/06 then the valid dates that would be acceptable would be any date before 05/04/06 i.e. One month.
I have two date fields and i have in each one a calendar. I want these dates to be validated. They both should not be prior to the todays date and date 2 not to be prior to the date1. How can i do this people?
View Replies View Relatedi am currently writing a web page where a user has to register by admitting several details via a simple form. In this form, i have 2 text boxes one for entering their email address, and another for confirming the email address. I know how to validate that the 2 email addresses entered are identical, but i would like to be able to validate that the email address entered is in fact in a valid email address format.
i.e. right now, a user could enter "hello" in box 1 and "hello" in box 2 and this would be valid. There are obviously many different valid email formats, so how can i check that the data entered is in a patricular valid format?
I have written a function to validate user input, so that it properly returns a valid time if the user inputs 1600 or 16:00 or 4:00 pm the time is properly formatted (it may need a little more tweaking, but you get the idea) This is the function : Code:
View Replies View RelatedI have two input fields on an ASP Page.
User enters 2 dates.
I want to check that the difference in months does not
exceed 360 months.
Is this possible in Javascript to get the difference in
months?
i have a software capable of building a Search engine with no programming skills needed well, the app works great, but i want it to validate when the search box is empty (no user entry).
Tha app generates 3 files : search.asp which calls the other two files, webdata.asp and searchfunc.asp, the webdata file gathers all the keywords of the site adn the searchfunc file is the one that does the remaining job. I wannna tell the user when he left empty the search box, so i go to the searchfunc.asp file and write thie:
if request("searWords") = ""
msgbox ("you left empty that entry, please try again")
end if
But when i try it on my server it gives me the error 500. I don't know what to do i just want to validate that simple thing. I attacha the 3 files mentioned above.
I am developing a system for a certain use and now all the major programming is done. The next step is to include error checking for all the forms (there are 9 pages with forms to add data and 7 for editing, so total 16 forms)
I just started with the most simplest and I was wondering if anyone had a good suggestion on how to validate Dates?
I was also wondering if its possible for example to write a data validation script which I can use for all pages, because like one page has 90% date fields.
If so, how can I accomplish that? Won't I need to pass the name of the text fields in some way too?
Is it possible to do that for other similar fields too, like first name, last name, phone number?
Oh yeah, the way the entering of dates works is that there are three separate text boxes, for Month, Day and Year. So a case date is divided into, case_mm, case_dd and case_yyyy.