i have written a small asp code with backend as oracle.i have created a small database which is accessed by asp. now suppose if i have to move the database to another system along with code what should i do.
View RepliesI 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.
I am trying to make it where when the highlighted item from the pull down menu is selected then a small descripion will appear in the text box next to the pull down menu. Any ideas, I am sure it is simple, but I keep banging my head off the walls trying to get it. Code:
View Replies View Relatedi searched the web for a code to connect an 8i oracle database with the ASP and i didn't find anything useful untill now . So if any one can help me in this i will be so greatful , also i wanna know if it is possible for the PWS or is it only working with the IIS
View Replies View RelatedHow do you connect to your database(oracle9i) upon clicking a button? Let's say I have a text box which ask for a specific date, then upon clicking the button, the script will connect to the database and extract records based on the input date.
View Replies View RelatedI'm new to ASP so please forgive my ignorance. Our IT department says that there is no way that what I suggest can be done. I disagree because it should be possible (if not there is a massive hole in the market), but don't have the technical knowledge to back myself.
We have an Windows/IIS web server for our public website. Internally for our intranet we have a Unix box with and Oracle database. What I want to know is: Is it possible to query that database from the windows server using ASP? Are there any clients/COM/APIs etc that this would require? Can anyone direct me to a webpage that has more info?
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 RelatedHow do i connect to Oracle Database through ASP? I have Used the Following Syntax But it gives me ADODB .Connection error no as '800a0e7a' saying Provider Cannot be Found.
set objcn1=server.createobject("Adodb.connection")
objcn1.Open "Provider=OraOLEDB.Oracle;Data Source=servername;User Id=abc;Password=cbs"
OR
objcn1.Open "Provider=msdaora;Data Source=servername;User Id=abc;Password=cbs"
I don't know how to upload word doc, images and other files into Oracle Blob fields with binary format.
I tried with the following code, normally it's inserting, suppose if i try to convery binary. Code:
Does anyone know of a database system available in which users could establish a user name and password to register products, buy merchandise and access a message board? I have moderate asp skills, but have no idea how to write or where to purchase software to create this database.
View Replies View RelatedI have a news page on a web site that now needs to be seperated in to a number of 'views' (eg. so that each user sees a different set of articles). I would like to stay away from using 20 include files!
I know how to do this with php but this time I don't have the luxury of being in an environment I'm familiar with. I also need to do this without a database, and in the most economical way possible.
I am working on a CMS website which uses a access database.
When a user adds a page a record is added to a table in the database. The user choses the page style from a selection of 7 or 8 layouts.
I have been asked to find out if I can password protect one of those pages??
I have tried a few sites but not found much. The it has been done before is to add a password protected layout and build a login area into the site.
The effect i want is for the user to click the page and a username and password box will apear?
I am currently developing a final year project which is a web based
tracking system tracking exam questions. I am using IIS as the
server, MS access for the database, and ASP with VBScript for the
scripting side of things.
One of the things I want to do would be to e-mail a user/moderator
whenever a exam question is edited/completed/updated. does anyone have
any previous expierence in this? i don't even know where to start.
What is the asp code variable for System Date and System Time? Are they built-in system variables, or is there some code involved to return the values?
View Replies View RelatedI've been writting small simple webpage for years using FrontPage and ASP.
I'm thinking it might be time to take a look at ASP.net but am not sure
where to start. Is there a suggested site that would help someone move from
just ASP to ASP.net? Things like in ASP you'd write the code like X and in
ASP.net you'd write like Y.
Is there a (Free is possible) application that I should use to develop
ASP.net code in? I assume that FrontPage isn't going to cut it.
I'm building a small CMS, and i've run into a "small" problem. I need a simple way to sort menu-items, have up/down arrows, to move menu-items. my table
id, item_name, item_order, stamp
1, Main, 1, 20060822
2, Contact, 2, 20060822
3, News, 3, 20060822
any clues?
I have been running asp for several years and want to know if I could, what would I need to do to run asp and dot net on the same server. In other words, what more would I need to install on my server.
View Replies View Relatedwhat do you think about moving to asp.net? All the code must be rewritten! asp.net a lot more faster than asp ? is it only advantage?
View Replies View Relatedi have a page that calls images from a database, that is 3 images a page but in my database i have more pictures for one record, so i want to have something like a link that will call the next field that has an image and i want it to replace the ones that i already have.
View Replies View RelatedI have asp pages running on IIS of XP prof.
I want to move to the apache web server
Can anyone explain how to do that?
i have a page that retrieve images from a database, but know the thing is i can only retrieve 3 images per page and i have a link that must call more images from the same record but replacing the ones that i already have!
View Replies View Relatedi was wondering if there was a way to move a set of records from one database into another database??
Basically i want to archive a whole heap of records that i already have in on database.
Im using an access database as well
Even moving them into a nother table would probably do as well.
i have a text area for user to enter remarks. and their remarks can be very very long
my output page is a table which i underline the lower boundry of the table.
when i wan to output the remarks on this line,it will over shoot the line and page.how do i make it such tat it will move onto the next line?
I have a SSN Field which include 3 text boxes. How do I move the focus from one box to another as soon as user enter the max characters in the text box.
For example:when users enter 123 in the first text box of ssn control should move to next text box.
I have about 10 records within my database and would like each one to be on a featured page - I would like my SQL query to scroll through and display the next record with the database every 1 month.
As I only have 10 records, I would like the query to infinitely repeat this process. What should I add to my SQL query to allow me to do this?
I'm trying to figure out how I could move the first value in an array to the end of the array so that the second value would then be the new first. I can't really wrap my mind around how I would do this.
View Replies View RelatedI'm trying to use either one of these methods to position the cursor in a specific position inside a recordset, but neither one seems to work. For example, I have 10 records in my rsData recordset, and I issue this command
rsData.Move 5, 1 'move to #5 from beginning
I then retrieve rsData("field_name"), expecting that it'd return field_name of record #5, but it doesn't seem to work like that. What am I missing? Is there a restriction on what type of cursor a recordset must be opened in?
I'm using W2K/IIS5/ASP.
I want to move to next data in the data set, however i am not sure what is the syntax.
Can anyone who know please advise me?Code:
strsql = "select main_cat_id, cat_name from main_categories where main_cat_id in (26,27,28,29)"
set rs = connectdb(strsql,strconn)
for i=0 to rs.recordcount
response.write rs("main_cat_id")&"<BR>"
rs next
next
Is there a function in ASP/VBScript that allows you to move/copy files from one folder to another. I have an application that run a script on some files and once this is done they need to be moved to a backup store.
View Replies View Relatedhow can i do an swapping of images by dragging an image into another image to swap their position.
View Replies View RelatedI have a database with a table containing user names and I want to be able to move to the last record and display the user name.....so the end result is that I can display on my main page:
"Welcome to our newest member: XXXXX"
For some reason I cant seem to do this, it says to me that objRst.MoveFrist is ok but objRst.MoveLast cannot be accepted. Here is my code:
I'm curious as I am in need of advice on how I can move a site from an old Win 2K server, to it's new home on a Win 2003 server, without having to mess around with downloading/uploading the file's (there's over 30,000 file's/folders, so it would take forever to do it manually).
I've heard of an ASP script thats capable of this, but can't seem to locate it.
I am trying to put a buuton into my page which will take the user back to the previous page. The reason i am doing this is that the user may come to this page from more than one other page.
I am using this code for the button, which i have seen on many code examples, but when i click on the button, it results in an error as if the existing page is trying to load itself up again.
<form>
<td width = "325" align="left">
<input type="submit" name="back" value="Back" onClick="javascript: history.go(-1)">
</td>
</form>
have also tried using the javascript: history.go(-1) code in the form declaration as the onSubmit attribute, but this just makes the same page load up again.