|
Can someone please give me the code for my database on this project? This is very urgent, need to submit it later this afternoon. Please reply asap.
Thank you.
Your client wants you to incorporate these e-mail conversion techniques into a Web site which uses an existing database to store employee numbers, first and last names, departments, e-mail addresses and telephone extension numbers of all employees in the company.
The e-mail address of each existing employee is in the format of ‘lastname@bigguy.ca’. Since the company has grown this format is no longer efficient, as duplicate addresses can exist. Therefore you must convert the e-mail address to place the first name initial in front of the last name, as follows:
Example:
First name: John
Last Name: Smith
Current e-mail: smith@bigguy.ca
Required address: jsmith@bigguy.ca
The database, which you will create, will consist of a single table which will be constructed as follows:
Database name: INT213db.mdb
Table name: Employee
Fields:
Name Data Type Size
EmployeeID string 10 Primary
Firstname string 15
Lastname string 15
Email string 25
Department string 10
Extension integer n/a
The following data must be entered in the database and unaltered when your assignment is handed in.
EmployeeID Firstname Lastname Email Department Extension
12345 John Smith smith@bigguy.ca Accounting 2489
44567 Mary Green green@bigguy.ca Sales 2466
34345 Fred Fishy fishy@bigguy.ca Shipping 2445
12432 Gary Moore moore@bigguy.ca Sales 2486
13243 Helen LaMoore lamoore@bigguy.ca Accounting 2412
***NOTES***
1)Use the DSN database server connection type. Please make sure you test this connection prior to handing it in.
2)The adovbs.inc file can be downloaded from the course web page and should be available from your instructor’s web sites.
Page Requirements:
Default.html
This introductory page will provide links to all other pages. Since this is a pure HTML page, no code will be required. All other pages must provide a link back to this page.
Addacc.asp
This page will provide users the ability to add new employee records to the database. This page will be scripted to perform the following:
1)Provide sufficient text boxes to allow users to enter employee number, first name, last name, department and extension number. A text box for the e-mail address is not to be included on this page.
2)Verify that the first and last names, when entered, do not have numbers contained in the names.
3)Verify that all text boxes have data entered prior to saving to disk. Do not allow empty text boxes. A warning message must be displayed if a box is left empty when the information is submitted.
4)The e-mail address will be constructed by script. You must use the first letter of the first name and the entire last name. To this add the @bigguy.ca. An example was provided above. This will be written to the database along with the other required information.
5)A message that the employee information has been saved to disk should be displayed when the operation is complete.
6)Provide a button labeled ‘ADD’ that will activate the script
7)A link to the default.html page must be provided.
Modify.asp
This page will allow users to change employee records that already exist in the database. This page will be scripted to perform the following:
1)Provide sufficient text boxes to allow users to modify employee number, first name, last name, department and extension number. A text box for the e-mail address is not to be included on this page. The e-mail address currently in the data table must be displayed.
2)In order to modify an employee record, the record must first be found. Therefore a search script will be utilized to recall the information based on the employee account ID. Add a button to the form, labeled SEARCH. When clicked it will allow your script to search the database for the number entered into the Employee ID test box. Verify that a number has been entered. Do not allow the script to crash because of an empty text box. The text boxes and e-mail address will be populated with this information. If a record is not found an appropriate error message will be displayed indicating that there is no such employee in the database.
3)If a record is found and displayed, provide a MODIFY button which will save the information back to the database. This assumes that some or all of the information has been changed. Do not allow the Employee ID number to be changed.
4)Before the information is saved, verify that the proper e-mail address format is used. The e-mail address must conform to the company policy as described above.
5)Provide a link to the default.html page
Display.asp
This page will display information from the database. HTML tables will allow you to correctly format the output. The information from the data table will be formatted and output as follows:
1)A textbox and button will be provided The button will be labeled ‘DISPLAY’
2)Two types of input will cause the display of table data.
a)If the word ALL is entered into the textbox, all of the records will be output, sorted by department.
b)If text is entered then you can assume that the user has entered a department name and wishes to have information regarding all employees within a specific department. Sort this information by last name.
3)The output should be formatted as shown above in the assignment overview, one record per line.
4)Provide a link to the default.html page.
|
|
|
|
|
Which bits do you need help with?
I knew it would end badly when I first met Chris in a Canberra alleyway and he said 'try some - it won't hurt you'..... - Christian Graus on Code Project outages
A moment of silence please. A programmer's best friend has passed beyond that great exception in the sky.... - Mark Conger on "The coffee machine has died"
|
|
|
|
|
database stuff... db code - programming?
|
|
|
|
|
database stuff... db code - programming?
|
|
|
|
|
You would like the entire project, by this evening?
I knew it would end badly when I first met Chris in a Canberra alleyway and he said 'try some - it won't hurt you'..... - Christian Graus on Code Project outages
A moment of silence please. A programmer's best friend has passed beyond that great exception in the sky.... - Mark Conger on "The coffee machine has died"
|
|
|
|
|
I think this falls under the Thou shalt do your own homework commandment
|
|
|
|
|
Mark Nischalke wrote:
I think this falls under the Thou shalt do your own homework commandment
Or is it the "Thou shalt not take a paid contracting job and then ask CPians to complete the entire project for you" commandment?
I knew it would end badly when I first met Chris in a Canberra alleyway and he said 'try some - it won't hurt you'..... - Christian Graus on Code Project outages
A moment of silence please. A programmer's best friend has passed beyond that great exception in the sky.... - Mark Conger on "The coffee machine has died"
|
|
|
|
|
thanks but I need help getting started... Just can't figure out the db connection and programming part. I can do the asp pages but the db code/programming i don't know
|
|
|
|
|
Sorry, but this is just like knowing how to start the car, but not knowing how to drive
Google is your friend if you have some very specific questions.
|
|
|
|
|
I have a webpage set up, and I want to be able to click a button and run a program located on my computer. I have seen some code that lets the user click a button and run programs on their own computers, but is there any way that they could run programs on my computer? I am using ASP with VBScript, but if there is another way to do this with a different language I would happily change. I don't need the program to be displayed to the user. Thanks in advance.
Shane
|
|
|
|
|
I can think of two methods i'd try,
1. If you have a static IP you could try the various VNC apps. They allow you to control your desktop remotely. Search for WinVNC on google.
2. ISAPI extensions, i've never used them myself, but I assume you can get them to run processes on the host server.
other than that, you'll have to look on the web for other software made for this
We brought out this, new and very similar version of our expensive software because the old version was......old....It's a good enough excuse for Microsoft so its fine for us. Oh and by the way, your old version will expire in three days unless you purchase the new version.
|
|
|
|
|
Thanks for the reply Jonny... I have tried programs like VNC, but they are more for just connecting two computers. I want the user to just be able to execute one program, not have full control of my computer. As for ISAPI, I have not looked at this option, I will check it out. Thanks again for your reply, if anyone else has any ideas, let me know.
Thanks,
Shane
|
|
|
|
|
|
Hi,
Would you be kind enough to help me to create Next and previous in asp page or point me in the right direction Please!
my code is:
<%
Dim oConn, rstData
listData
function listData
set oConn = Server.CreateObject("ADODB.Connection")
set rstData= server.CreateObject("ADODB.RECORDSET")
if not oConn.State then
oConn.open Session("CC")
end if
with rstData
.CursorType= adOpenForwardOnly
.LockType = adLockReadOnly
.ActiveConnection = oConn
.Source = "sp_e_data"
.CursorLocation = adUseClient
.Open
end with
end function
%>
Much appricated.
Bravo Two Zero
A pen is mighter then a sword.
|
|
|
|
|
Hi everyone,
I am trying to display a xml document in a separate file as a part of a html document. the xml document contains some data needed to be rendered in the html file and i don't want to use the server-side dynamic page scripts to coalesce them. can i achieve it just adding some html tags or css or xsl?
thanks
Kerry Chou from STU
|
|
|
|
|
|
I posted this somewhere in here, so if you see this somewhere else, please forgive--new to this site.
I am trying to read a text file in ASP and assign each line to a variable. THE CODE FOLLOWS:
<%
dim fso
fname = "admixture"
filename = server.mappath("data/" & fname & ".txt")
set fso = createobject("scripting.filesystemobject")
' read the text file
set fso = createobject("scripting.filesystemobject")
filename = server.mappath("data/" & fname & ".txt")
set readfile=fso.opentextfile(filename,1,false)
do until readfile.atendofstream
h = h + 1
text=readfile.readline
line&h = text
loop
readfile.close
%>
The challenge is when I try to assign the variable "line", place a number after it then make it equal to "text".
Can or would someone help?
God Bless,
mark
If the toothbrush were invented somewhere other than West Virginia, would it be known as the teethbrush?
|
|
|
|
|
Hi,
I need to customize a File Upload object in a HTML form. I want to change "browse..." text and button colors... Can anybody help me ??
Another possibility will be made it with Flash...is it possible ??
Regards,
|
|
|
|
|
if it's html then you can just edit the source to change the caption of the button, and use CSS tags to change the colour (a google search will show you how to do either of these)
--
Help me! I'm turning into a grapefruit!
|
|
|
|
|
I am populating a datagrid in page load event. On itemCommand event, i make some changes in data grid, however, these changes are not reflected in grid, unless i repopulate grid, as item command event is fired after page load. So, whenever item command event is fired, i have to populate grid twice.
Can any body suggest me some better way,so that i do not have to populate grid twice...
Your help will be greatly appreciated...
|
|
|
|
|
Hello everyone,
I am trying to get the higher level document object from the inner inested child object. There is the demonstration code.
<title>Demo
I want to get the objTable object reference using the inner img object "ojb", how can I do it?
I have tried this "obj.parentElement", but it returns null.
thanks!
Kerry Chou from STU
|
|
|
|
|
Hi,
Here is the way to access your table element:
document.all.obj.parentElement.parentElement.parentElement.parentElement
| | | |
| | | |
That's a lot of parentElements...
Pyt.
|
|
|
|
|
The formatting was not to good in my previous message.
Basically here is the hierarchy:
IMG -> TD -> TR -> TBODY -> TABLE
Pyt.
|
|
|
|
|
thanks Pyt.
Kerry Chou from STU
|
|
|
|
|
How would I accomplish this...?
In exact code please, cuz i've tried window.parent.location.href and that didnt' work...
I've used window.open() JScript...and I need the spawned child window to refresh the parent who created it...??
Any ideas...?
"An expert is someone who has made all the mistakes in his or her field" - Niels Bohr
|
|
|
|