from the client side is possible to create a XMLHTTPREQUEST object to retrieve data ( in async way ) from web services, or simple from a asp page like this :
I've created asp reports getting datas from Oracle. The server im using is 8i while client is 9i. Does Asp support oracle 9i. I mean while retrieving numeric datas from oracle it displays only 0. But if the same query is run in oracle to test it, it displays properly.
Do I have to download any patch or driver where IIS is compatible with oracle 9i. Any ideas whats wrong. Did u guyz understand what im trying to say. For ur better understanding Im sending a doc attachment.
There will be only one user maintaining the Table 1 then another user maintaining address only in table 2. So the second user need to retrieve the data from table 1 on the IC No. how should i do it? is it using session?
I am submitting data to a database field, and the data is being submitted in the following manner to a table in the database:
5,3,4,4,3,3,4,5,4,5,5
It's all comma delimeted. Now, what I would like to do is have an update page in which a user can update these values. I am trying to place the values in a repeated text box that corresponds with a repeated question.
The questions that I am displaying are in a repeated field and each question has a text box that will hold the value that corresponds to. I would like to be able to bring in each value into a repeated text box. Right now, each repeated text box contains the above information. (5,3,4,4,3,3,4,5,4,5,5). Is this possible?
I have a search set up on my site to compare between two <select> values and the value in the data base, but not sure if I have the sql statment correct, my search returns all rows from the table, I want specific row that is between one form select and another... ie. below
for this particular example I want to know if the database AD_PRICE field is between <select name=price> and <select name=price1> and if so, return the only those rows, currently all rows are being returned... Code:
I have this page with photo thumbnails that are clickable. Each photo has corresponding info saved on a database. When the thumbnail is click, im trying to show the data in an asp page called info.asp.
sample: Photo #1 when clicked goes to: info.asp?no=1 Photo #2 when clicked goes to: info.asp?no=2 so on so forth..
the database fields are: no picname date details
I only know how to display ALL info from a database.
But i cant figure out how to display SPECIFIC info triggered by a query string. Example. Photo #1 is clicked. I only want the data that corresponds to Photo 1 to be displayed. How can i do this?
I have a database with many tables. I have many objects on my form, textboxes, checkboxes etc... I need to populate a second drop down box after selecting the first drop down box with out the user clicking a button, Yes Master I know how to do the JavaScript onchange but every thin I have looked at uses hard coded data in their example. Can you give me a form example using you tutorial DB of multiple DD Boxes.
I want to know if there is a way to retrieve the tag from the URL, I don't know if thats its name, so I'll just explain what it is:
showmsg.asp?FID=mn&ID=2467#2529
the tag, as I call it is what follows the # sign, the number 2529, in this case. so, is there a way I can retrieve the tag with ASP, by the request object, or any other way, any Ideas? Another thing I wanted to know, not related to this subject, is how do I change value of a textarea that is placed in another window with VBscript or JAVA. is it possible?
I have three different tables I will be pulling stuff from: user_info, img_inv, activitylog:
user_info I will be using their ID and state img_inv I will be using part number activitylog I will be using part number and date
I'm trying to select the part number from the activities list and match it with the img_inv to make sure it still exist. If it exist I want it to do a total count of how many times it has been looked at by 7 states within a given quarter. Code:
I want to retrieve the value of a cookie to make a form a little more user friendly (our intranet is configured to set a cookie for User First Name, Last Name and Email when they log in)
Unfortunately I can't figure out how to retrieve the value of the cookie. I've been trying:
<% Response.write Request.Cookies(UserLName) %>
But it gives me an error - I used Checky to make sure the cookies are there and they do exist:
i want some help in how to retrieve values from multiple selection listbox. i want the values retrived to be used in the search which i perform from the database. i m doing a search feature which u all often see in job search sites. so someone selects multiple cities to search in i want that to include that in my search query.
I have a form that send values to a second page. i m trying to compare the values received from the form with other values retrieved from a database. so if a value already exists then an error message is displayed. in order to compare the values i need to print them on the second page but I m bit stuck with this. i used request.form("category") in order to retrieve the values from the form but it doesn t work.
I am trying to get a field populated in an oracle database with a time stamp of when a form is submitted.
I have found out that there is a table in Oracle called DUAL which holds the current date and time. At present i can populate the date when the form is submitted using objrs('sub_date')=date() but when i query the database the time element of the field sub_date, the time displayed is 00:00 which is the default time.
So can anyone give me any help in how i can capture the time. I know about select to_char(sub_date,'DD-MON-YYYY HH24:MI') which will bring up the time but i can seem to populate the field sub_date with the time.
I am trying to retrieve the page name. I know this is possible using Server Variable PATH_INFO. The problem I am having though is that when I get to a page in one of my subdirectories the subdirectory name is displayed.
Example: my page index.asp is in the the admin directory so the PATH_INFO displays as /admin/index.asp. How can I strip the page name out so I get index.asp. I cannot use the function Right() since the page name could be any length.
How to retrieve "Last modified" & "FileName" from all files in a specific folder (called MyDocs) and display on the ASP page?
eg. (in MyDocs folder) - MikesWork.doc - MyResume.xls - HouseExpenses.xls
Situation Let's assume that i just modified MyResume.xls file and save it today(10/30/2003) on my computer, then i upload it into the internet. On my asp page, i want to show all files Filename (Last Modified) in MyDocs folder. eg. Your Documents 1. MikesWork.doc (last modified 10/24/2003) 2. MyResume.xls (last modified 10/30/2003) 3. HouseExpenses.xls (last modified 9/15/2003)
I know it has to do with fso or something close to it... but totally have no idea (zero) of its logic or how it works. Please help me by giving me with full example.
I'm writing a vbscript application that reads UTF-8 XML containing Chinese characters and stores the data in MySql 4.0.x. Does anybody have any experience in this area with regarding codepage and character sets? Ideally I want the scripts to be able to handle Standard European characters and Chinese characters as well. Are there any special considerations for using MySql/ODBC and ADO to get and put the data.
Right I have my files going into the database, and once successfully uploaded, a user is shown a few bits of information in a table such as the primary key, name of file, its size and the content type.Now i want to create <a href> links on the homepage etc so that browsers/users can download these files one at a time. So when they click the link, the Save.Open or Cancel dialog box appears. Have been trying different things for few days now but finally thought I better ask for some help as Im gettin nowhere.
I have a zipfile that is created dynamically for me on a webserver. I have the url of the zip sent as a post value to an asp script on my website.
In my asp script I need to be able to retrieve the zip file so that i may extract content from it using an asp zip component. Any idea how to retrieve the file?
I have a SQL statement to retreive results based on keywords entered I only want to show the first 200 characters of the field though, how would I modify this code to do just that?
i have a checkout page which lists the user and what they have puchased. however, theres a problem with this page as I cant retrieve the user from both tables in my db, Customer & Corporate. The error message that I received is:
Microsoft VBScript compilation (0x800A03F4) Expected 'If' /shop/check_out.asp, line 412, column 3 End --^
which refers to the red line in the code below: Code:
I have an .ASP page that comes up, and I am trying retrieve a variable from the previous .ASP page. However none of the variables from the previous .ASP page are available to the current .ASP page. There are three pages in this chain.
1. NewUser.html Information is input in this page, and posted to the next page using this tag <form method="post" action="newUser_response.asp">.
2. NewUser_response.asp Information is retrieved from the previous page using the <%=request.form("strADLocation") %tag, and then posted to the next page using the <form method="post" action="newUser.asp" This page is basically just a confirmation page, and just displays the information from the previous page, and sends it to the next page.
3. NewUser.asp This page is supposed to retrieve all of the variables from the previous ..asp page using this syntax strADLocation = request.form("strADLocation"), and create a user account, but none of the variables are available to the script portion of this page from the previous .asp page
I had a similar problem when I was trying to make variables available to a ..asp page from a .html page, and later found out that I had to re-declare the variables in the second page which was an .asp page using this syntax strADLocation = request.form("strADLocation"). Everything worked great at this point(HTML to .ASP). The problem I am having is that I added an additional .ASP page(NewUser_response.asp) in the middle, and I can't seem to retrieve the variables from the previous .asp page. Now the chain is HTML to .ASP to .ASP. If Code:
how I can select categories from a database table, Categories for checkbox choices? I want the checkbox value to be the Category ID and then the name beside the check box to be the category name (Category).
I want the check boxes to be dynamic just like you can have a dropdown box for the categories you can choose from. In this case, the user needs to be able to choose mulitple categories so that's why I need check boxes.
I've created bookmarks in a MS Word document and stored some value in those bookmarks. Now I would like to retrieve the value of this bookmarks using ASP code and display it in my ASP, how can I do it?
i'm trying to retrieve the @@Identity ID in sql so i can insert it into my other tables. the following code works in access, but not sure how it would retrieve it in sql. Code: