|
Welcome to the Web site for USF MBA 683 E-Business Technology .
Classes meet on Thursday evenings at 6:30 in CO 325.
Labs in CO 226 on Saturdays 9:30 am to 12:00 pm from 9/16 to 11/11.
For info on usability testing look at the class materials for October 5. For
examples, you can look at material from previous classes:
|
Notes from 11/02:
Notes from 10/26:
 |
Please e-mail all you vendor evaluation presentations and paper to me. |
|
Missing Assignments as
of 11/05 The following personal Web site and/or DB assignments are missing: andaju2,
bhelra00, browka4,
davili2 kongga3,
soehen2, tiefa00.
Please complete these immediately so they can be graded. |
Notes from 10/19:
|
You can use your team name within an Oracle statement to
prefix table names but you have to quote the team name and use
upper case like this:
 |
In SQL Plus: select count(*) as cnt from "A683-7".users; |
|
Within TCL: db_foreach u_row "select count(*) as cnt from
\"A683-7\".users" |
|
|
Class presentations should be about 5 minutes in length and
focus on the information your classmates need to understand and evaluate
these products. Look beyond the vendor's Web site; research
reviews and analyst reports to get a perspective. |
Notes from 10/12:
| There was a problem with SQL Plus and team accounts.
Typing sqlplus / now works. Please let me know if you have
problems. |
| Many students seem to be struggling, please e-mail
me your suggestions for making this process easier. Note that you can still
use the textbook (Philip and Alex), even though some of the TCL code has
changed as explained on page Ref: TCL old API. |
|
Examples page now has expanded
explanations and new examples. |
| Please make sure that assignments and other material on
your Web sites is properly labeled. These materials may be accessible via
search engines. |
|
If a helper page does not generate a message that the user
needs to see, you can send the user back to the main page by calling ad_returnredirect
like this:
ad_returnredirect "main-page.adp"
|
Note: TCL code that follows the ad_returnredirect will
still be executed. |
|
| if_no_rows does work as part of a db_foreach
statement, see
s4-add-del-2.adp in the examples.
You must have a space before and after the if_no_rows and no spaces
after the {. The pattern for db_foreach is:
db_foreach statement-id "SQL-select-statement"
{
code-for-each-row-goes-here
} if_no_rows {
code-for-no-rows-goes-here
} |
Notes from 9/28:
| Teams are posted on Students
and I
have e-mailed team account info. Team directory is the account. For
example, team 1 Web site is:
http://usf-acs.rho.net/student/a683-1/ |
|
Team 9 (Heather Madison and Kraithep Mongkol), please join
other teams for purposes of the company evaluation assignments (10/12 to
11/02). |
|
Here are the Code Examples from
class. |
| See ref-web-tools.htm for
information on using Front Page and other authoring tools. Page Mill
will not work for .adp pages. |
|
Dates for SQL are in year-month-day format. For example,
2000-10-01. |
|
Use this SQL Plus query to check if you have done a Grant to
AD:
select distinct grantee, table_name from user_tab_privs made;
The following query shows more detail:
select * from user_tab_privs made;
Note that Grant ALL implies alter, delete, index, insert, select, update,
and references. |
Notes from 9/21:
Notes from 9/14:
| Be sure you have an index.htm page in your Web site. |
|
When using SQL Plus, the Backspace key may not delete
characters. From the menu of the terminal emulator (WinQVT), select Setup,
Current Settings, the Keyboard Tab and the Backspace sends BS option. |
Notes from 9/07:
|
Instructions for FTP are in the References section, see http://www.ehrlichorg.com/00f-tech/ref-ftp.htm |
|
In data modeling, a transaction is an action or step in the
process. For example:
|
Creating the records for a new professor |
|
Enrolling a student in a course |
|
Dropping a course. |
|
|
Legal transactions are allowed or proper transactions; not
legal in the sense of courts or lawyers. For example, in order for a student
to drop a course, the student must have enrolled in the course. |
Notes from 8/31:
Notes from 8/25:
|
Evocative Writing Assignment due 8/31:
|
The first part of the assignment is to define the type
of response you want from each audience (Dot Com Ventures or Ye
Olde Company) in terms of what do you want them to think, how do
you want them to feel, or what do you want them to do. |
|
Please bring a paper copy to class. |
|
|
Check out the Spring
00 class projects. |
|
Philip and Alex's Guide to Web Publishing is available
online at http://www.arsdigita.com/books/panda/
or from Amazon. |
|
Please register yourself in two ACS systems:
|
Note: Contents of this Web site are in the process of being
updated for Fall. We have a number of technical changes effecting all TCL
code examples in Greenspun's book and on this site.
Chuck Ehrlich
E-mail: chuck@ehrlichorg.com
The Ehrlich Organization: 1-415-441-7140
Cell phone: 1-415-828-9001 (use when I'm at USF)
USF office: McLaren 210, Office hours by appointment.
|
