I want to display the results from 2 seprate mdb's in this manner on an asp page.
If fieldName from dbtable in A.mdb is the same as fieldName in dbtable B.mdb then display all fields. I assum this is sql, so any help woud be great..
I have a project where all the links go to an intermediary page
before being redirected to the destination page. For example,
there is a link, say to final.asp. But final.asp only redirects the user
to final_last.asp which is the actual destination.
Is there any reason for this indirection? It would seem one could save
space and make things more efficient by going directly to the actual
destination page. Did the author have a reason for doing things this
way?
i made a little page called billing.asp. I seen on some websites where they can do somin like ie: billing.asp?id=34 and it brings up a record. How can I do that id=34 part?
View Replies View Relatedis there any way i can get a link to access a database cause am trying to make a profile page but with just 1 page for the profile to be on.
< a href="link-to-page=id-of-member"></a>
I have created a form using HTML and Javascript. When I click on the submit button I need the Selected Answers to be sent to an Excel or MS-access or any database. I need to know whether this is possible using CGI/ASP. I guess ASP would be better. If not which one do you think is the best way to carry out.
View Replies View RelatedMy background is Crystal Reporting. In one of my Reports i had to create a Hyperlink which opens up a .asp FORM in which the user types in data and clicks SUBMIT, as soon as he does that it should get updated in the Oracle 9 database, i have the code for the .asp form and also for the .asp page which inserts data into the Oracle Database, My question is how to link these two .asp pages.
View Replies View RelatedI am in the process of making an online examination system. The exam will have a total of 100 questions and each question has a time limit. I have done with coding of a question and setting time limit. Each question will get its question from a database table and also the 4 options.
Now my problem is that how i create 100 asp files for 100 questions??.. how can i link them so that when a user clicks submit button, he is taken to next asp file(question).. files are numbered as 1.asp,2.asp...etc. Is there any way i can create a template or something and files and links be automatically generated.
Now when somebody goes to the site www.mysite/allphotos.asp , it ask for the id/password and if the password is correct (as checked by another file ' password.asp' ) the user is redirected to a new page www.mysite/viewall.asp else it is redirected back to www.mysite/allphotos.asp with an error message. Now till this point all is working fine. But if somebody types in www.mysite/viewall.asp directly to their browser they would bypass the password page i have created and hence the security fails.
how can I redirect back to www.mysite/allphotos.asp if a user types in www.mysite/viewall.asp in the browser.I have tried assigning a variable (say goAhead = 0) in the password.asp file when the login is true. In the head of www.mysite/viewall.asp it checks if goAhead is not 0 it redirect back to www.mysite/viewall.asp . Now what is happening is that I can't open www.mysite/viewall.asp rightaway but even when password is correct it stll won't open and is redirecting back to allphotos.asp
Is there a way to make an image link to a field I already have in a database? Can I just simply put an html command to a link in a database in Access to an image? Or do I have to do an OLE object? I have no idea how to make an OLE object link to something.
View Replies View RelatedOur company has a website in place that allows users to get information. I've been asked to call a custom made dll that returns a registration number to the user. I don't know much about dlls or coding concepts for that matter (I've built pretty basic client/server asp websites only), but I would like to be able to at least ask the right questions so that I can understand just what I need to look into to do this.
Does it depend what "kind" of dll it is and what language it's written in? Do I then just need to know the arguments it takes? How do you register a dll?
I need to link to a javascript function from a REsponse.write line
I can do this but when I try to use a record (ie. rs("Product Name"))
it doesnt work. I tried something like this:
Response.Write "<a href="""" onClick=""rePopulate(''rs(""Product Name"")'');"">Product</a>"
It's this bit thats the problem I think .. I know its probably to do with quotes r smth but rePopulate(''rs(""Product Name"")'').
... linking to a pop-up window but sending an ID to the asp page
<A HREF='javascript popUp("confirm.asp?ID=' & rs("Doc_Num") & '")'>Edit</A>
Something like that but with confirm.asp accepting an ID associated with Doc_Num
This works fine for a fixed ID but not when associated with a recordset.
I'm sure its a quotation mark here or there but im hitting a brick wall!!
Would anyone be able to help me with this. I have a number of textboxes and checkboxes.
When a textbox contains text I want the checkbox to be unchecked. When the textbox is empty I want the checkbox to be checked.
Also, is it possible to do the reverse as well i.e. when the checkbox is unchecked the textbox cannot be empty etc.
I have got rs6 to display the Usernames but when i try and link the username with the userID it shows this error:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/viewpub.asp, line 121
set rs6 = objconn.execute ("SELECT * FROM favepub INNER JOIN members ON favepub.UserID = members.UserID WHERE PubID=" & PubID)
Pubbers: <% WHILE NOT rs6.EOF%>
<a href="viewmember.asp?UserID=<%=rs6("UserID")%>"><%=rs6("rsUser")%></a>,
<%rs6.MoveNext
WEND
%>
Basically, I want to be able to print labels and invoices (via MS Word) for net orders, using our ASP site admin system. Code:
View Replies View RelatedI am trying to build a simple webpage for a college project I am required to use ASP in this project. I simply need to link my webpage to an access database to display the information on the page. I have managed to do this with all text information using the following code:
View Replies View RelatedI have a dynamic table that displays names of companies. Some companies have URLs and some don't. I would like for those companies with URLs to open a new browser and show their website, for those with no URL just to open nothing. So far I have this, however doesn't work.
View Replies View RelatedI'm working on getting a list of links to other forms on my database to show up in an order determined by an additional field in a database. This line right here works for this (note the bold part is what I'm editing):
Set rs = cnnSimple.Execute("SELECT * FROM [resource domain] where RESID= """ & rstSimple.Fields("RESID").value & """ ORDER BY [Links].Precedence ASC;")
But I actually don't want to sort by Precedence (that's being used for sorting another field). Instead I want to sort by another colum in the same form called BelongOrder. I try this simply by doing:
Set rs = cnnSimple.Execute("SELECT * FROM [resource domain] where RESID= """ & rstSimple.Fields("RESID").value & """ ORDER BY [Links].BelongOrder ASC;")
But I get the following error:
Microsoft JET Database Engineerror '80040e10' ....
i'm having some difficulty coding my dropdown menu's on a page, i want the contents of one to be dependent upon the value of the selected option of another.
View Replies View Relatedit so that you could click a link which would open a new window with an map with imagemaps on it and when you click one of the links I want it to load in the original page ie where my home page and my menu is.
is there a way to do this without using javascript if so please could you let me know.
i need to know how to show and link files from a database .
View Replies View Relatedi was trying to find a way to link my pull-down menu with a column in a table in Microsoft Access using ASP. As I add new records to the database, I would like the pull-down menu to update also.
Once the submit button has been clicked, a table is inserted into the page with the information from the row in the database.
Assume that there are 100 flash files in a directory and i want to load 4 flash. files for every page and list of links in a row previousPage.page1.page1.page3.........page10.Nex tPage) How can i divide
100 files into pages and 4 filash files on every page. is it possible to use files systemobject to createpages or sholud i record content of directory of files to a database and then use recordset to create pages.
I'm using PerlScript in my ASP page and I have the following problem: Each time the page is refreshed a CSV file is created. I want this file to be available for download. The problem is I can't create the file in the "wwwrootsite" dir, so I can't link to it. I can however create anywhere else on the server.
View Replies View RelatedI was just wondering if there is anyway to link tables from another Access database using ASP. Just like the function in Access where we can go File->Get External Data->Link Tables.
I have implemented some e-modules and they all have individual database as a backend. But, my boss would like to allow all these e-modules to share data. Therefore I am thinking of linking all the tables in those databases through a 'gateway' database (gateway.mdb). This 'gateway' database would have link tables from all other databases.
I have a situation which i am sure has arisen previously. But for the life of me i cant figure out how to get this to work.
I have a directory setup like this:
Site1 - www.site1.com
Asp -
Images -
Site2 - www.site2.com
Asp -
Images -
The problem that i am having is i cant get site 2 to display images from site 1 using the virtual path '../' as this only takes you to the root of site 2 and wont let me out of it.
I have tried to use the full path of http://www.site1.com/Images but this seems to take an a really long time to load the images.
Is it possible to go outside of this root directory using some kind of trick? I dont want to copy the images accross to site 2 either as there are actually hundreds of sites that will be referencing site1's image folder and it is updated regularly.
I was thinking of putting a virtual directory in site1 thatpointed to the image folder in site2 but i couldnt get that to work.
When i try to link to a video file, a.mpeg, i always get an error from the ms media player. This is very annoying as qt player can open the file just fine.
Tried the script on two different servers, same problem.
Tried it on several clients, same problem there as well.
Anyone out there know how to fix this problem?
If I am attempting to add multiple products to an existing Customer-Products
linking table do I do this via an Insert or Update?
The first time I enter a customer in the database I would obviously do an
INSERT into the Customer-products linking table.
But, the second time I wish to ADD new products as well as possibly
overwrite existing ones......
I am getting twisted what the correct approach is?
We have a master page set up and it is tied to its css file through the standard method in the <head> tag. What I would like to do though is from another page inheriting the master page to add another link to a css file.
That way i can have the sites global file used to make the general apperance consistent, then make the internal content more flexible without destroying the current css file.
Is this a possible task? When i went into the main master page and tried to add a <asp:contentplaceholder id="additionCSS" runat="server" /> tag to the head. When this is done visual studio alerts me saying it doesn't recognize the tag 'asp'. Is there a way around this? We are only just rewriting the site to use master pages now so I'm still figuring it out.
I have an ASP page that lists a recordeset that can have dozens of records, at the end of each line is a details link that links to a page giving more detailed information about the record where a user can add and update information to that record.
At the top of the update record page I have a Back to Record List page. The problem is that when a user hits the Back to Record List page they are taken back to the Top of the list, I'd like to create a link that will take the user back to the record they just updated. I am carrying the data record number through the querystring.
anyone knows how to do this using ASP? any coding needed?
View Replies View RelatedBasically, I have 2 separate drop-down lists, we'll call them List1 and List2.
Say List1 contains:
Fruits
Months
Sex
Now, I would like all 2 lists to be on the same page. A user would proceed to select something from List1, say "Fruits". Upon clicking on the drop down list for List2, the list items should automatically be updated to predefined items, say "Apples", "Oranges" and "Pears".
if the user changes his mind and goes back to select "Months" from List1, List2 should immediately display stuff pertaining to List1 items, say "January", "February", "March" etc etc....
My client has various Access databases that they want to be able to access (using MS Access, not through ASP pages). I thought I'd be able to create the link from an HTML page but when I do that and click the link, the file is downloaded to the local temp folder. I want the database to open directly from the web server, and then changes must be saved.
View Replies View Related