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
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.
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
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:
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?
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.
I'm learning ASP with a database in Access (new to Access also). I have created my tables and all but I'm stuck on how to query the table. I'm familiar with sql statements, so I was wondering if you can access the database the same way as with php and mysql. I.E.
Code:
Select * From Table Where id = 5.
Something like that, or will I need to use
Code:
objRS.Filter "ID = 5"
I guess the main question is does Access accept SQL statements and if so can you give me some examples as to querying the database.
I am working on ASP and SQL Databases. I have written the code . the program is very simple . its just an application form and u will be having upload and submit button . So after the data is being entered , the submit button code should be invoked and the data entered should be stored in the database.
View Replies View RelatedI'm having Difficulty understanding the concept of retreiving information from a database upon user request. E.g i have an ASp page that has a form with 3 drop down boxes and a submit button.
I want the next page to bring results from the database that meet the criteria set upon by the 3 drop down boxes. The DB is Access and its already got the information in it, i just want the correct information to come up in tables once the user has selected the choices in the drop down boxes.
If i upload an ASP page that is connected to an MDB (Access) database to my FTP server, is there any way that I can ensure that no one can download the database and that it remains "untouchable".
View Replies View RelatedThe problem I have is that I need to save the content of a form in a database, and I donw know how to save the content of a checkbox, can you give me an example of the code?
View Replies View RelatedI need script or a link to a tutorial that will allow me to do the following.
User enters username and password site checks the username and password against database1
if the user entered the correct username and password the page shows records from database2 if the user enterend incorrect username or password then nothing happens.
I am new to this forum and really looking forward to being involved in the community.
I'm trying to design a simple website with 2 dynamic searching functions. The first is the user enters text into a search box, clicks on the search button and then connects to a sql or access database and brings back those records that are LIKE the search phrase. It's my intention to then have a detailsview link on the searches so the user can drill through.I'm designing an online version of my catalog so that the user can browse by page. I also want the user to enter a page number and then click go and that would then take the user to the corresponding page in the catalog. I'm guessing I'll need to declare If 1 then open page1.html, if 2 then open page2.html.
I know I'm close but not close enough and my knowledge has been well and truly stretched and I must have read and read my Dummies book about 20 times over the last week.
For my ICT (computers) project at college I'm using an Access database, and I now have a problem with that. Basically the way it works is that the user enters their details in a form page (here). This then does the usual thing; runs a script which inputs the data into a database and then displays a thank you message.
the problem I'm having is that whenever I input punctuation into the form, it refuses to work; it comes back with a 500 server error. This is understandably quite irritating, as I'm setting up a mailing list that needs to incorporate a list of email addresses
My hosting account gives me a lot of MySQL databases but I usually just stick with MS SQL Server because it gives me fewer troubles.Now I want to challenge MySQL again. I use connString "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=myserver; DATABASE=mybase; UID=myID;PASSWORD=myPwd; OPTION=3"
And the conn and recordset objects connects smoothly with the database. I can even get the things i want out of it. But every time I try to update the database such as:
rs("Content")="Cool"
rs.update
'or
names=array("Content")
values=("Cool")
rs.update names, values
It just wouldn't work...why? Content field is a text field.
I'm trying to pull information from two different databases, use it, and then put it back into a database. The program I am writing is one which will keep track of exempt employees' absences. At the end of the year, employees get to rollover the sick days that they do not use. Herein lies the problem. The information on how many sick days an employee is in an AD download on one server. The information on how many days that employee has taken this year is on another. I need to take that information do a little math, and then add those days into a different table on the same server that the absences came off of to keep track of their "sick bank".
I would like to just Loop the information, but I cannot put recordsets inside recordsets and I cannot create a view from two separate servers, so I am at a stop sign. Can I just take all of the users and the amout of sick days they have and put them in a text file and then pull off of the text file? I'm not quit sure how to do this.
How do you go about searching three tables at the same time? I'm using Dreamweaver MX, but I can also hand code it in if know one knows the dreamweaver method
View Replies View RelatedGiven if tables A and B are in the same database, writing a query for them is relatively easy. But what if tables A and B are in different databases? Is it possible to query them together? If so, can anyone provide a generic example?
View Replies View RelatedI have a search page with an access database in the background.
When you type in a keyword, it brings the related article up.
Is it possible for this to display a hyperlink??? When i choose hyperlink in the access field it displays thefollowing on the screen: Code:
Inserting into an Access database using the above script generates this
error :
Microsoft JET Database Engine error '80040e07'
Syntax error in date in query expression '#20031021 20:36#'.
Using SQL : UsersTable SET UpdateTime=#"& dbDate(Now())&"# .....
If YYYYMMDD hh:mm:ss is a universal date, why is it rejecting it?
If I change it to YYYY/MM/DD hh:mm:ss it then becomes valid. Is this valid
in all situations, or am I doing something wrong in the first step?
I need script or a link to a tutorial that will allow me to do the following.
User enters username and password
site checks the username and password against database1
if the user entered the correct username and password the page shows records from database2 if the user enterend incorrect username or password then nothing happens.
I am new to this forum and really looking forward to being involved in the community.
I'd like to create a class file for a shopping cart that I'm working on but I'm not sure about how to use the database with it.
Do I connect and open to the database inside the class or outside of the class and set the properties?
I'm thinking that if I open and close the database with say a getItem() method and I have 15 items to get, I'll be opening and closing a connection 15 times. Isn't that bad?
Can ASP Apps read from a mySQL database?
View Replies View RelatedI have an apostrophe in an access database in a name. e.g. O'Brien. When I read this value back into some script the apostrophe seems to be terminating my script.Unless of course I have mis-understood what's going on
Are there any rulesguidelines for this sort of data handling
I have a website, of which i have a website of which i update now and again, however, i want to be able to insert data into a database and not the page it self, so when a visitor navigates my site, it will generate the page from the database. And also i want to use an Access Database Is this possible, if so, how.I can use ASP (of course) and Php
however have little knowledge of either, little bit of HTML, and some VB programming.
Can I made more than one connection to SQL databases in a single ASP page or it may create problems or what are the drawbacks?
Code:.....
I want to collect user input. I have a collection of 30 checkboxes that I would like the user to pickout from. The information then will be recorded to a database somehow. Finally the user will be allowed to change the selection if required.Which is the best way to do this. Do I need to create 30 different fields in the database ?
View Replies View Relatedi have started a project. It is a multiplayer text based online game. so far what i have got is a log in page that fully works and a logout page that fully works.
what i am stuck on is once you have logged in i want the user to see their own individual stats. but no matter how i try i have only been able to show the entire tabel's data not just certain fields out of that 1 record.
Can Chili handle Microsoft databases? I inherited a site with ASP, but my host uses Chili and the site is generating errors.
View Replies View RelatedI don't know anything about the ASP language. One of my client's would like me to host their website, already created with ASP. Down the road, I need to re-design the site and convert the back-end to PHP. However, suggest the best method of moving the entire site to my Windows 2000 server?
View Replies View Relatedi get this error when posting info in a form
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/register.asp, line 141
Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
Page:
POST 295 bytes to /register.asp
I want to store the login and logout time of user. HOw can it is possible if some one closes the window without clicking the logout.
View Replies View RelatedIn a search form how does one stop the form from running when a certain character is entered.
Such as "%" also even if i add 5 of the characters. I have been to a few sites and this goes and gets all the records.