I have a database with 3 tables in it.(Imagine as there are 3 levels, one level for each table)
on level 1, there are 3 entries:A,B,C
on level 2, the entries are tied to one of the entries in level 1, ie those in level 2 will be A.1, A.2, A.3, B.1,B.2,C.1,C.2.....
on level 3, the entries are tied to one of the entries in level 2, ie those in level 3 will be A.1.1, A.1.2, A.1.3, A.2.1,A.2.2,B.1.2,C.2.1.....
I have 3 combo boxes on my webpage. I want it to be able to do the following:
when i make my choice on combobox 1 which holds the information of level 1, only those entries corresponding to the choice made in combobox1. ie if in combobox 1, i chose A, then i only wan those of A.1,A.2,A.3 to be shown in combobox 2.... after which, say I choose A.1 in combobox 2, I only wan those of A.1.1, A.1.2,A.1.3 to be shown in combobox 3.
Is this achievable in asp and sql since it sort of requires dynamic programming?
I have a service which provides video clips with a subscription service, and I have a few big corporations using it. These big corporations all use the same login and password for their company, but the users requesting the passwords will all have different emails, but the part after the @ will be the same. I.E mruser@microsoft.com.I need a script that will only check that part of their email, and based on which one it matches it will send them the correct password for their company.
I want to create a record set for all the products in my database, i then want to randomly select some of them each time the page loads and display them, these have to change upon each refresh.
any ideas
my final problem i will post seperatly however, heres the score if any has any ideas.
ive created a product database of bikes, they have diferent sizes and colours. at the moment i am having to display each individual record. rather than having a single record and then on the detail page being able to have a dropdown menu or a choice of sizes there?
I'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
Dreamweaver created code to update to data base. But when testing on website i get the following message. I have no clue what it might be. Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /admin/update.asp, line 111 line 11 is strName.execute I read it might be forbiden characters in the data base field names or spaces... but i don't have that. the names are userName, userLevel, ID, Password.
This seems a very complicated task, so I welcome any input. My boss wants a data grid or matrix of the top 6 orders with ordered items, and products, for a particular customer and he wants to see it like this:
products down the left side orders across the top number of items under the respective order number column across from the corresponding product.
I hope that makes sense. I have three tables. Products, Orders, Orderitems. I don't even know where to start. Many thanks in advance for any input offered.
how do i get data from a user on one page and display the result on the other page actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
How can I display data from an XML file in ASP?I want to use an XML file instead of an Access or SQL database and would like to display this information the same as I would if I were using Access or SQL as the datasource.
how to add new data. i need to add new data after display the record from database. i click new button and the textbox will be empty. Wat is the code for add new data?
I had write an asp file to get data from an xml named "data.xml" and below is the coding:
Dim xml Set xml = Server.CreateObject("Microsoft.XMLDOM") xml.async = False xml.load (Server.MapPath("data.xml")) Dim fText1, fText2 fText1 = xml.documentElement.childNodes(0).text fText2 = xml.documentElement.childNodes(1).text Set xml = Nothing
It's all Ok and can run. But my problem here is I want to call an xml file that I don't know its name (not "data.xml"). The xml file pass by the user who call my asp file. The user can pass the xml via anything for example asp or VB component. So I will not know exactly what the name of the xml file.
i have setup a DSN called "pro" now i have tables in this database i m running oracle if i were using MS Access i know how to insert new fields by using the
RS.Mode = adModeReadWrite
how do i do it for oracle? not just inserting data into tables but also what r the commands that i have to give in the asp code page so that i can even update( edit ) and delete records.
some way to access to the content of the HTTP POST? Perhaps throw the request object or something similar to the $HTTP_RAW_POST_DATA gobal variable available in PHP.
i am trying to use AJAX to get XML data from 3rd party site and display on my site. it works in IE, but does not work in Mozilla. i want to find a method where i can do that.
I got a database with user and email in it. Now I want when a user logs into my page that it automaticly fills in the email into a email form. How can I do that in Asp.
anyone know any homepage that might help me to list the data out in a page. i wanna do it like in 2pages that one is going to be the one who maintain data. another one is to list all the data out from server...
I have two tables having similiar columns ( i had to do this to compare the values given to me, because both the table data came from different sources)
The tables named are OFFICERS token full_name division EMPLOYEE token full_name division
Now the table EMPLOYEE contains more than 5000 records and the table OFFICERS contains around 2400 records which are already present in the EMPLOYEE table.
Now I want to build a query that will return me all the records in the EMPLOYEE table that are not present in the OFFICERS table. The criteria for comparing 'full_name'. so the query should return me 2600 records that are not present in the OFFICERS TABLE.
I tried doing this " SELECT DISTINCT EMPLOYEE.full_name,EMPLOYEE.token,FROM EMPLOYEE,OFFICERS WHERE EMPLOYEE.full_name<> OFFICERS.full_name"
But this query returns me records that is not present in the OFFICERS table as well as some more 1000 records which are present in both tables. thanks a lot
I'm trying to use Activer Server Pages (ASP) to get Data from SQL database to Excel. Do you need to have any ActiveX installed to achieve this and has anyone has experience in doing this?
there is a JavaScript/ASP function that that will check for new Private Message (PM) Inbox. New PM will be referred as "NEW" in the status field in the database and "READ" for all the old PM.hen there is a new PM, a popup will appear in my page. But I have to press the REFRESH BUTTON before I get the popup ALERT! Can this be done in AJAX? (Alert me without refreshing the page?)
I've been choosing to insert data ni my db using a recordset with methods AddNew and Update. I would like some advices to make my coding opractice better. For example: am I doing it right? Is there a better to do what I'm doing and so on...:
I am trying to access the following site with an asp page. I am just starting out with XML URL
This is my stats page for battlefield Vietnam. I have managed to get a local verison to work if I save the source code of the page above as an xml file on my server, and I use the following code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Option Explicit %> <% Dim xmlDoc, root Dim success, player, strData, online ,rank, rp, score, kills, deaths, fttk, kdr Dim dpm, ftpm, mppr, medals, gold, silver, bronze, rounds Set xmlDoc = server.CreateObject("msxml2.DOMDocument") '
What I can't figure out is how to access the data from the external site.
In ASP, when we pass data between pages, we usually pass by query string. If we pass data by query string, that means we need to use submit button, not by regular button, and the form will pass to the server since it's GET or POST request. But if just form-to-form communication, why we need to send the form to the server?
