Multi-Relational Database
I have a table (Software Table) in a database that is linked with a many to one relation to another table (Computer Table). I wrote a simple ASP page to return the records for the software table which shares a one to many realtion with the Computer Table.
One (Software Table) to Many (Computer Table)
At persent the only records that are returned are the ones from the software table. Is there some way to return or display the many computers (one to many) for each record.I cant think how to start to do this. Can I link to computer table and have a drop down that lists the many computers?a better way to display this information?
View Replies
ADVERTISEMENT
Is their a way to check with asp-code if a database field is relational with another field (from another table)?
For example:
If fieldname = relational Then...
End If
View Replies
View Related
i have been thru a couple of books on ASP working with IIS 5.0 but still havent figured out how to connect to a MS Access database. the problem is with the SQL which i dont know well. My database has 6 related tables.
It's for inventory control. The 1st table has the catagort the 2nd has the machines per category, the 3rd has machine parts per machine and so on. what I have been trying to do is to view the database for the latest updates per machine (which for now i am updating manually for the time being ) but the code dosent work and i get some errors one of which is " use an updateable qurrey" and others are related to SQl with every modification i make.
View Replies
View Related
I have written a asp application whihc uses a number of pages and each page connects to a sql database.
Currently I have the connection script coded on each page however if i need to change the database I have to change every page.
I have been told there is a way to have the connection on one page and each page to referance this one so I only need to change the one page
View Replies
View Related
What i need to do is build 2 tables below with the following fields:
tblUsers
id
name
address
postcode
tblShop
id
product
Now i need to build a relation between the two id fields but what i relaly need to know is how to retreve the data in the tblUsers from the id in the tblShop through asp. This is like for a shop
View Replies
View Related
I have an interview for job which requires following:
1.Modeling and Designing Relational Databases
2.Database applications for the web
3.Server side Programming using PHP
4.Macromedia Flash and Dynamic Data
5.Internet and Web Protocols
6.Installing Apache Web Server, PHP and MySQL
7.Authentication and Security
8.Integrating Streaming media into web development
9.Understanding Mobile Communications
can anyone pls suggest me what Dynamic Data in point 4 means?Also what is Integrating Streaming Media of point 8?and when it says mobile communication.
View Replies
View Related
I have a database which contains 2 tables. One which contains standard information (which every record has) and then the other, which is a relational table and is just a long list of records with different attributes that apply to various id numbers found in the first table. Both tables are contain records with the same ID number.
Now, I have an ASP file that accesses the MDB file and displays it in XML format. I have it working for only the first table. However, I was wondering how I would go about getting entries from the second table entered.
So it would display the items from the first table on 1 line - and then add on anything from the 2nd table that applies to that ID - all on one line. Code:
View Replies
View Related
Is it possible to retrieve data with ASP sorted on 2 fields? I've tried :
SELECT * FROM [TableName] ORDER By Field1 AND Field 2
But it gives an error. I've searched the internet on this topic to no avail.
Is it possible?
View Replies
View Related
I released to open source a while back but forgot to post in here a DLL that was used in some of our older developments. It's not really a live project, but may be of use to peeps in here given some of the recent queries:Quote:
DBSite: Written in Visual Basic this DLL helps solve issues for ASP web developers, e.g. handling uploads, safe parameter population for stored procedures (sql injection checks), SQL XML calls, file system browsing, etc.
View Replies
View Related
I was trying:
Code:
<!--#include file="lang/<%= Request.QueryString("lang") %>.asp"-->
But it doesn’t work.
View Replies
View Related
How can i create a multi tab page in asp.net 2.0?
create a frame and a number of page with hyperlink?
Would i have some directives?
View Replies
View Related
How can I update/delete a record which is linked to another table with a
unique field. I know the select inner join, but no update/delete.
View Replies
View Related
Trying to join three tables and find the records which DON'T match OR have less than x number of matches.Not sure how to go about it.keep getting matching fields only.
View Replies
View Related
I need to create in asp/access/javascript a questionnaire that shows a single question on each page of which there are five then after the last question create a new record in the access db and write the answers.
View Replies
View Related
lets say we have a ms db with two cols
id value
1 4
2 7
3 9
4 1
is there a simple way of updating all the value fields with one form? so i can have the page lay the four value's out in a list, the user could then edit them and hit update and this would update all the value fields. i can update single records no problem but have no idea where to start with this one.
View Replies
View Related
As part of the development of a shopping basket function, I've a two dimensional aray which I'm storing in the session variable.
I want the array to be dynamic to store any amount of products which may added.
I am getting a problem when trying to write to the second row to the array, saying that the subscript is out of range...
You can see an example of this at:
http://www.foulkestudios.com/session.asp
I am getting what should be the first empty row by getting rows=UBound(myArray,2)
I'm then trying to add into the next row by using rows + 1
View Replies
View Related
I am b-testing a community site, with currently 1,000 or so membership,
and low concurrency, say no more than 5 on-line at once.
The site is hosted on a shared server, which is sufferening from
intermittent accute slowness, affecting all other hosted sites as well as
mine.
The finger of suspicion is pointing at me and possible sloppy code. As
this is the first site I have done of this nature, could someone recommend
reading matter (knowledge bases etc), especially coding samples, in
connection with data connections (opening and closing connections and
objects) and record locking issues, which if improperly coded, could
contribute to throughput bottlenecks due to inefficient use of resources so
that I can check out my pages and correct any nasties..
View Replies
View Related
I am think to write a code that will need more then 2 servers.
Can anyone give me some information to do code like that?
Like yahoo, google, msn.
View Replies
View Related
I need to develop an application that will span 12 or so pages, and on the
last page, it lets the user review the data and then insert it all. This is
kind of like selling something on eBay, you give it information, click next,
enter more info and then at the end you review and submit the item. I was
thinking about sessions, but some of the fields are pretty big, like
varchar(5000) so I didn't know if there was a way to handle these big
fields.
View Replies
View Related
I am in the process of developing several web sites that will accommodate up to 3 or 4 languages. The sites are not that complex, but will use an Access database for some data presentation/storage. Each page will have a series of flags for respective languages. Ideally, if someone enters on a "gateway" page for say Gallery, and they choose another language, I would like the same page to display but in a different language (there might be a page for each language, but if I can avoid that I'd rather).
So here are my thoughts on how to approach this. Have a session var for language preference and set it in a Global.asa file. I would think it could be set dependant on the origin of the request, .de, .co.uk, .it, etc. Then, if the code is not too verbose, use Case statements in the code to display content based on language preference. One thing of a bit challenging for me is that if the "flags" are in an include file, how can I get them to when clicked go to a script, change the session variable and return to the page from which it was clicked. Am I on the right track with this approach.
View Replies
View Related
I have a database full of info and I have display.asp which I want to display 10 items at a time so I have display.asp?page=1, display.asp?page=2, etc.
How do I go about actually filtering the database to only produce 10 results per page? I was trying to use:
results.Move 10
and things like that, but I'm not sure of the best way around this.
View Replies
View Related
I have a table in the db and one field in the db is an email field various records can have the same email address in. When an email address changes from x to y I want to be able to change an email address x in every record in the table to y, how would I do this?
View Replies
View Related
I was wondering if anyone had any links to some resources / tutorials or could offer up some help with regards to my current project.
The concept is pretty simple. Multiple user login - which are then presented with a page where they need to answer some questions (drop-down responses). These responses are then checked against the answers and the points are then added and the results list the different users in descending order.
Help and suggestions with any part of this would be greatly appreciated!
I know this will be linked to a database (open to suggestions about which to use) and then how to structure my tables.
View Replies
View Related
Will the Request.form show the correct order that they were displyed in or
will it do something different. I have been testing and it always shows the
order they were displayed.Is this just coincidental?
View Replies
View Related
Simple question no doubt -
I am trying to send an email to a form variable as well as a list of addresses, but I can't seem to get it to work. Please help.
I want to combine these two lines - what is the syntax?
Code:
MyCDONTSMail.To= "xxxxxxx@nzl.xerox.com"
Code:
MyCDONTSMail.To= creat_email
They work individually (I have declared creat_email).
View Replies
View Related
I have two multi-select boxes...selLeft and selRight. The user moves choices from selLeft to selRight with arrow buttons. selLeft is populated using XML.
My question is, when clearing everything on the screen, how do I repopulate selLeft, without losing items in selRight or repeating items left in selLeft.
I'm a newbie and not familiar with the code used to build the multi select box in the first place. Code:
View Replies
View Related
How would you go about inserting data from two forms into one record? using access/javascript
View Replies
View Related
Iam working on a search that needs to fetch words from other languages for any given word entered in english. I use an access database to store the english words and its equalent words in other languages. For example:
When i search for chinese equalent of Invoice (or any other word), the retrieved result is?.
View Replies
View Related
I am currently creating a multi-language site using ASP .NET and was wondering what people think the best way to do this. Keeping a session variable of the users's choice? Cookies?
View Replies
View Related
how I can make a dhtml menu into a dynamic menu that pulls its links from an access database instead of the hardcoded html.
I would like to know because I'm working on a site that needs such a menu and most of my administrators using my site don't understand html and won't be able to update the menu unless I can give them a simple form that allows them to add links.
View Replies
View Related
How do I create an array inside an array? This certainly doesnt work...
Dim TmpArray(0 to 10)(0 to 50)
View Replies
View Related
I have a form that is passing a number to check box values with the same name (productID) but different values (numerical values). It is also passing a warehouseID as a hidden field.
I need to dump these values into an access table called wtbProductWarehouses with fields titled ProductID and WarehouseID. What is the code that I need to write to have it loop through all of the productID values and individually add each one to the db while also adding the warehouseID with it.
View Replies
View Related
i have 5 checkboxes in one asp page, I am trying to get the values of all checkbox that are checked using for each loop but I dnt get any result,just a blank page. Herez my code where I am trying to get the values of all check boxes
Code:
for each cid in request.Form("chk")
response.Write cid & "<br>"
next
View Replies
View Related
