text: PL/SQL Chapter 8 Outline Procedures Cursors Triggers Procedural SQL SQL does not support the conditional execution of procedures as well as looping operations. To overcome the lack of procedural functionality in SQL and to provide standardization, SQL-99 standard defines the use of persistent stored modules (PSM). What is PSM? A PSM is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server. The PSM represents business logic that can be encapsulated, stored and shared among multiple database users. Oracle implements PSMs through its procedural SQL language. What is PL/SQL and where can PL/SQL be used? Procedural SQL (PL/SQL) is a language that makes it possible to use and store procedural code and SQL statements within the database and merge SQL and traditional programming constructs. The procedural code is executed as a unit by the DBMS when it is invoked b the end user. PL/SQL is used to create Anonymous PL/SQL blocks (without name) Stored Procedures PL/SQL functions Triggers PL/SQL block The PL/SQL block starts with the DECLARE section in which the variables, the data types or the initial values are declared. The PL/SQL block ends with the word END The PL/SQL block can be executed by typing / and press enter key. Each statement inside the PL/SQL code must end with a semicolon ";". To display the output use the command dbms_output.put_line('any string');. Conditional statement or Looping statements can be used after declare statements; The SELECT statement uses the INTO keyword inside the PL/SQL block of code to assign the output of the query to a PL/SQL variable. If the SELECT statement returns more than one value, you will get an error. PL/SQL Program Blocks 7 Commands included in PL/SQL Comments: PL/SQL program includes commands such as Comments statements that are lines of text that explain or document a program step or series of steps. Not executed by interpreter To create a block of comments enclosed between /* and */ To create one line comment type two hyphens -- at the beginning of the line. PL/SQL programs have Commands to perform arithmetic operations Assignment statements that assign values to variables Conditional structures to perform decisions Looping structures to repeat instructions multiple times SQL commands that retrieve data. 8 Procedural Statements Sequences Statement 1; Statement 2;… Control Statements IF <condition> THEN statement1; ELSE statement2; ENDID; Looping Structures DO WHILE LOOP…. Statement 1; Statement 2;… ENDLOOP Assignment Statements Assigns a value to a variable An assignment statement has the following syntax variable_name := value; Value can be a literal: current_s_first_name := 'John'; Value can be another variable: current_s_first_name := s_first_name; 10 Displaying PL/SQL Program Output in SQL*Plus PL/SQL output buffer Memory area on database server Stores program's output values before they are displayed to user Should increase the size of the buffer as SET SERVEROUTPUT ON SIZE buffer_size Default buffer size 2000 bytes To display more than just a few lines of output, it is better to make the output buffer larger than the default size. Maximum is 1000000 bytes 11 Displaying PL/SQL Program Output in SQL*Plus (continued) Display program output DBMS_OUTPUT.PUT_LINE('display_text'); The display_text value can contain literal character strings such as ' My name is Roohi' or variable names such as current_s_first. Display maximum of 255 characters of text data 12 Executing a PL/SQL Program in SQL*Plus 13 Create program in text editor Copy and paste program commands into SQL*Plus window Press Enter after last program command Type front slash ( / ) Then press Enter again Executing a PL/SQL Program in SQL*Plus Write a PL/SQL program to display the current date as shown below Today's date is 27-Feb-2012 DECLARE todays_date DATE; X number; BEGIN todays_date := SYSDATE; X:= 1; DBMS_OUTPUT.PUT_LINE('Today''s date is '); DBMS_OUTPUT.PUT_LINE(todays_date); DBMS_OUTPUT.PUT_LINE(x); END; 14 PL/SQL Data Conversion Functions Sometimes the PL/SQL interpreter is unable to implicitly convert value and an error occurs. Other times, PL/SQL interpreter performs an implicit conversion and produce unexpected/invalid data Explicit data conversions Convert variables to different data types using data conversion functions that are built into PL/SQL. 15 A Guide to Oracle10g Display today's date using concatenated character string To concatenate two strings in PL/SQL, you use the double bar (||) operator: new_string := string1 || string2; SQL> 2 3 4 5 is 6 7 DECLARE todays_date DATE; BEGIN todays_date :=SYSDATE; DBMS_OUTPUT.PUT_LINE('Today''s date ' || TO_CHAR(todays_date)); END; / PL/SQL procedure successfully completed. 16 PL/SQL Decision Control Structures Use IF/THEN/ELSE to execute code if condition is true or FALSE IF condition THEN commands that execute if condition is TRUE; ELSE commands that execute if condition is FALSE; END IF; Evaluates ELSE commands if condition is FALSE 17 PL/SQL Decision Control Structures Use IF/ELSIF decision control structure to test for many different conditions.: IF condition1 THEN commands that execute ELSIF condition2 THEN commands that execute ELSIF condition3 THEN commands that execute ... ELSE commands that execute conditions are TRUE; END IF; 18 if condition1 is TRUE; if condition2 is TRUE; if condition3 is TRUE; if none of the Loops PL/SQL has 5 loop structures LOOP…EXIT WHEN WHILE …..LOOP Numeric FOR loops 19 The LOOP...EXIT WHEN Loop The LOOP…EXITWHEN loop can also be either a pretest or a post test loop. LOOP program statements EXIT WHEN condition; END LOOP; 20 The WHILE...LOOP The WHILE….LOOP is a pretest loop that evaluates the exit condition before it executes any program statement. WHILE condition LOOP program statements END LOOP; 21 The Numeric FOR Loop Does not require explicit counter increment The loop counter variable and it start and end values are declared in the loop's FOR statement. Automatically increments counter variable until it reaches the end value. FOR counter_variable IN start_value .. end_value LOOP program statements END LOOP; 22 Using SQL Queries in PL/SQL Programs Action queries can be used as in SQL*Plus May use variables in action queries DDL commands may not be used in PL/SQL 23 Using SQL Commands in PL/SQL Programs 24 PL/SQL block to insert a new row in the VENDOR table SET SERVEROUTPUT ON BEGIN INSERT INTO VENDOR VALUES (25772,'Clue Store', 'Issac Hayes', '456', '323-2009', 'VA', 'N'); DBMS.OUTPUT.PUT_LINE('New Vendor Added'); END; / -- to execute An anonymous PL/SQL Program PL/SQL block to count the number of products having different price ranges DECLARE W_P1 NUMBER(3) := 0; W_p2 number(3) := 10; W_P1 NUMBER(2) := 0; BEGIN WHILE W_P2 <300 LOOP SELECT COUNT(P_CODE) INTO W_NUM FROM PRODUCT WHERE P_PRICE BETWEEN W_P1 AND W_P2; DBMS_OUTPUT.PUT_LINE ('The number of products between' ||W_P1||'and' || W_P2 || 'is ' || W_NUM); W_P1 := W_P2+1; W_P2 := W_P2+ 50 ; END LOOP; END; / STORED PROCEDURES A stored procedures is a named collection of procedural and SQL statements. Stored procedures are stored in the database. They can be used to encapsulate and represent business transactions. Syntax: CREATE OR REPLACE PROCEDURE procedure_name [(argument [IN/OUT] data-type,….. )] [IS/AS] [variable_name data_type[:=initial_value] ] BEGIN PL/SQL or SQL statements …. Refer to the handouts for END; more explanation on IN/OUT arguments STORED PROCEDURES Advantages: Stored procedures substantially reduce traffic as there is no transmission of individual SQL statements over the network. Stored procedures increase performance because all the transactions are executed locally on the RDBMS. Create a procedure to assign an additional 5percent discount for all products when the quantity on Hand is more than or equal to twice the minimum quantity. CREATE OR REPLACE PROCEDURE PRC_PROD_DISCOUNT AS BEGIN UPDATE PRODUCT SET P_DISCOUNT = P_DISCOUNT + .05 WHERE P_QOH >= P_MIN*2; DBMS_OUTPUT.PUT_LINE ('* * Update finished * *'); END; STORED PROCEDURES To execute the stored procedure, use the followijg syntax: EXEC procedure_name[(paramenter_list)] Create a procedure to assign an additional percent discount (an input variable) for all products when the quantity on Hand is more than or equal to twice the minimum quantity. CREATE OR REPLACE PROCEDURE PRC_PROD_DISCOUNT(WPI IN NUMBER) AS BEGIN IF ((WPI <= 0) OR (WPI >= 1)) THEN -- validate WPI parameter DBMS_OUTPUT.PUT_LINE('Error: Value must be greater than 0 and less than 1'); ELSE -- if value is greater than 0 and less than 1 UPDATE PRODUCT SET P_DISCOUNT = P_DISCOUNT + WPI WHERE P_QOH >= P_MIN*2; DBMS_OUTPUT.PUT_LINE ('* * Update finished * *'); END IF; END; Run the Procedure EXEC PRC_PROD_DISCOUNT (1.5); What is the outcome? EXEC PRC_PROD_DISCOUNT (.05); What is the outcome? Oracle Sequences MS Access AutoNumber data type fills a column with unique numeric values Oracle sequences Independent object in the database Named, used anywhere a value expected Not tied to a table or column Generate numeric values that can be assigned to any column in any table Created and deleted at any time 33 34 Create a procedure which adds a new invoice. CREATE OR REPLACE PROCEDURE PRC_INV_ADD (W_CUS_CODE IN VARCHAR2, W_DATE IN DATE) AS BEGIN INSERT INTO INVOICE VALUES(INV_NUMBER_SEQ.NEXTVAL, W_CUS_CODE, W_DATE); DBMS_OUTPUT.PUT_LINE('Invoice added'); END; Create a procedure to add a new customer CREATE OR REPLACE PROCEDURE PRC_CUS_ADD (W_LN IN VARCHAR, W_FN IN VARCHAR, W_INIT IN VARCHAR, W_AC IN VARCHAR, W_PH IN VARCHAR) AS BEGIN -- note that the procedure uses the CUS_CODE_SEQ sequence created earlier. Attribute names are required when not giving values for all table attributes INSERT INTO CUSTOMER(CUS_CODE,CUS_LNAME, CUS_FNAME, CUS_INITIAL, CUS_AREACODE, CUS_PHONE) VALUES (CUS_CODE_SEQ.NEXTVAL, W_LN, W_FN, W_INIT, W_AC, W_PH); DBMS_OUTPUT.PUT_LINE ('Customer ' || W_LN || ', ' || W_FN || ' added.'); END; EXEC PRC_CUS_ADD('Walker', 'James',NULL, '615', '84-HORSE'); The result is Customer Walker, James added. PL/SQL procedure successfully completed. Create a procedure which adds a new product line row for a given invoice. CREATE OR REPLACE PROCEDURE PRC_LINE_ADD (W_LN IN NUMBER, W_P_CODE IN VARCHAR2, W_LU NUMBER) AS W_LP NUMBER := 0.00; BEGIN In order to insert a new record in the -- GET THE PRODUCT PRICE LINE table, we need to know the SELECT P_PRICE INTO W_LP Invoice Number, Product Code, Line Units (the values are obtained from the FROM PRODUCT input parameters), Line Price ( the value WHERE P_CODE = W_P_CODE; is obtained from the Product Price i.e. p_price) in a PRODUCTTable -- ADDS THE NEW LINE ROW INSERT INTO LINE VALUES(INV_NUMBER_SEQ.CURRVAL, W_LN, W_P_CODE, W_LU, W_LP,null); DBMS_OUTPUT.PUT_LINE('Invoice line ' || W_LN || ' added'); END; Cursor A cursor is a special construct in procedural SQL to hold the data rows returned by an SQL query. A cursor is a reserved area of memory in which the output of the query is stored like an array holding columns and rows. Cursors are held in a reserved memory area in the DBMS server, not in the client computer. Cursors A cursor is a pointer to a memory location on database server that the DBMS uses to process a SQL query Cursors are used to retrieve and manipulate database data in PL/SQL programs Types: Implicit Explicit Implicit Cursor Implicit Cursors Context area A memory location on the database server Contains information about query e.g. no. of rows that the query processes, and a machine language representation of the query etc. Created by INSERT, UPDATE, DELETE, or SELECT Active set For SELECT queries, the context area also stores the active set, which is the set of data rows that query retrieves Implicit cursor is a pointer to the context area For Implicit cursor, there is no need to write commands explicitly to create it or retrieve its value. Implicit Cursors Executing a SELECT query creates an implicit cursor i.e. Implicit cursor can be used to assign the output of a SELECT query to PL/SQL program variables when we are sure that the query will return one and only one record. If the query returns more than one record, or does not return any record, an error occurs. Using an Implicit Cursor To retrieve data values from a query's implicit cursor into PL/SQL program variables add INTO clause : SELECT field1, field2, ... INTO variable1, variable2, ... FROM table1, table2, ... WHERE join_ conditions AND search_condition_to_retrieve_1_record; The variables must have been declared in the program's declaration section The variables must have the same data types as the associated database fields. Reference Variables Reference variables directly reference specific database field or record and assume data type of the associated field or record %TYPE: is a reference data type which assumes the data type of a database field data declaration syntax: variable_name tablename.fieldname%TYPE; e.g. current_c_last Customer.Cus_Lname%TYPE; The current_c_last variable would assume a data type of VARCHAR2(15), because this is the data type of Cus_Lname field in the CUSTOMER table Implicit Cursors (continued) Useful to use %TYPE reference data type to declare variables used with implicit cursors variable_name tablename.fieldname%TYPE e.g. current_c_last customer.cus_lname%TYPE Variable name Table name Field name in the table Reference Variables %ROWTYPE: is a reference data type which assumes the data type of a database record data declaration syntax: row_variable_name tablename%ROWTYPE; e.g. customer_row Customer%ROWTYPE; The CUSTOMER_ROW references all of the fields in the CUSTOMER TABLE, and each field has the same data type as its associated database fields. Reference Variables How do you refer to individual data field within a %ROWTYPE variable? Use the syntax row_variable_name.fieldname If u have to refer to f_first name, you can write customer_row.cus_fname or the balance, you can write customer_row.cus_balance Reference Data Type used with Cursors %TYPE: is a reference data type which assumes the data type of a database field data declaration syntax: variable_name Cursor_Name.fieldname%TYPE; e.g. current_c_last cus_cursor.cus_fname%TYPE; %ROWTYPE: is a reference data type which assumes the data type of a database record data declaration syntax: variable_name Cursor_Name%ROWTYPE; e.g. customer_row cus_cursor%ROWTYPE; PL/SQL program that displays last name and first name from the CUSTROMER table where cus_code =10010 using an implicit cursor SQL> DECLARE 2 current_c_last customer.cus_lname%TYPE; 3 current_c_first customer.cus_fname%TYPE; 4 BEGIN 5 SELECT cus_lname, cus_fname 6 INTO current_C_last, current_C_first 7 FROM customer 8 WHERE cus_code = 10010; 9 DBMS_OUTPUT.PUT_LINE(' The customer ''s name is ' || current_f_first || ' ' || current_f_last); 10 END; 11 / The customer's name is Ramas Alfred PL/SQL procedure successfully completed. Implicit cursor query tried to retrieve multiple records Error "ORA-01422: exact fetch returns more than requested number of rows" SQL> DECLARE 2 current_c_last customer.cus_lname%TYPE; 3 current_c_first customer.cus_fname%TYPE; 4 BEGIN 5 SELECT cus_lname, cus_fname 6 INTO current_f_last, current_f_first 7 FROM customer 8 WHERE cus_lname LIKE 'S%'; 9 DBMS_OUTPUT.PUT_LINE(' The customer ''s name is ' || current_f_first || ' ' || current_f_last); 10 END; 11 / DECLARE * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 8 When implicit cursor query returns no records SQL> DECLARE 2 current_c_last customer.cus_lname%TYPE; 3 current_c_first customer.cus_fname%TYPE; 4 BEGIN 5 SELECT cus_lname, cus_fname 6 INTO current_f_last, current_f_first 7 FROM customer 8 WHERE cus_code= 12345; 9 DBMS_OUTPUT.PUT_LINE(' The customer ''s name is ' || current_f_first || ' ' || current_f_last); 10 END; 11 / DECLARE * ERROR at line 1: ORA-01403: no data found ORA-06512: at line 5 Explicit Cursors Explicit cursors are created to retrieve and display data in PL/SQL programs for query that might Retrieve multiple records Return no records at all Explicit cursors must be explicitly declared in the program's declaration section Explicit commands are written to process the cursor. Steps for creating and using explicit cursor Declare cursor Open cursor Fetch data rows Close cursor Using an Explicit Cursor Declaring an Explicit Cursor By declaring an EC, a memory location is created on the database server that processes query and stores the records that the query retrieves CURSOR cursor_name IS select_query; Cursor_name can be any valid PL/SQL variable name. Select_query is the query that retrieves the desired data value ( simple, complex , nested query etc.) The query's search condition can contain PL/SQL variables as long as the variables are declared before the cursor is declared and are assigned values before the program opens and processes the cursor. Using an Explicit Cursor Open the cursor OPEN cursor_name; When the open command is executed, the PL/SQL interpreter examines or parses the cursor's SQL query, confirms that the query contains no syntax errors and translates the query into a machine language format. The system stores the parsed query in the cursor's context area and creates the memory structure that will store the active set. The cursor does not retrieve the data values at this stage. Using an Explicit Cursor Fetching the data rows LOOP FETCH cursor_name INTO variable_name(s); EXIT WHEN cursor_name%NOTFOUND; It retrieves the query data from the database into the active set, one row at a time. The FETCH command associates each field value with a program variable. The FETCH command is executed within a loop in order for the query to return several records. The cursor variable or variables are declared using either the %TYPE or %ROWTYPE reference data type. Using an Explicit Cursor Active set pointer It is a pointer that indicates the memory location of next record that is retrieved from database When the FETCH command executes past the last record of the query, the active set pointer points an empty record. The exit condition cursor_name%NOTFOUND determines whether the last cursor record has been fetched by checking if the active pointer is pointing to the last record and then the loop exits. Closing the cursor Close the cursor after it processes all of the records in the active set so that its memory area and resources are available to the system for other tasks. CLOSE cursor_name; The system automatically closes the cursor when the program that processes the cursor ends. Explicit Cursor with %TYPE It is used when a cursor retrieves one data field. Using cursors create a procedure that lists all products that have a quantity on hand greater than the average quantity on hand for all products. CREATE OR REPLACE PROCEDURE PRC_CURSOR_EXAMPLE IS W_P_CODE PRODUCT.P_CODE%TYPE; W_P_DESCRIPT PRODUCT.P_DESCRIPT%TYPE; --W_TOT NUMBER(3); CURSOR PROD_CURSOR IS SELECT P_CODE, P_DESCRIPT FROM PRODUCT WHERE P_QOH > (SELECT AVG(P_QOH) FROM PRODUCT); BEGIN DBMS_OUTPUT.PUT_LINE('PRODUCTS WITH P_QOH > AVG(P_QOH)'); DBMS_OUTPUT.PUT_LINE('============================ =========='); OPEN PROD_CURSOR; LOOP FETCH PROD_CURSOR INTO W_P_CODE, W_P_DESCRIPT; EXIT WHEN PROD_CURSOR%NOTFOUND; DBMS_OUTPUT.PUT_LINE(W_P_CODE ||' -> ' || W_P_DESCRIPT ); END LOOP; DBMS_OUTPUT.PUT_LINE('============================ =========='); DBMS_OUTPUT.PUT_LINE('TOTAL PRODUCT PROCESSED ' || PROD_CURSOR%ROWCOUNT); DBMS_OUTPUT.PUT_LINE('--- END OF REPORT ----'); CLOSE PROD_CURSOR; END; / Write a program that uses an Explicit Cursor to retrieve and display the invoice number value (using %TYPE variable) for every record in the INVOICE table for the customer code 10014. DECLARE current_cus_code NUMBER(4); CURSOR invoice_cursor IS SELECT inv_number FROM invoice WHERE inv_number = current_cus_code; current_inv invoice.inv_number%TYPE; BEGIN OPEN invoice_cursor; current_inv_num := '1001'; DBMS_OUTPUT.PUT_LINE('The current invoice number for ' || current_cus_code || are as follows'); LOOP FETCH invoice_cursor INTO current_inv; EXIT WHEN invoice_cursor%NOTFOUND; DBMS_OUTPUT.PUT_LINE(current_ínv); END LOOP; CLOSE invoice_cursor; END; / Explicit Cursor with %ROWTYPE It is used when a cursor retrieves multiple data fields. Use a single variable that has %ROWTYPE reference data type Assume the same data type as the row that the cursor retrieves. How to declare a cursor %ROWTYPE variable row_variable_name cursor_name%ROWTYPE e.g. customer_row location_cursor%ROWTYPE To reference individual data fields within a %ROWTYPE variable, use row_variable_name.fieldname e.g. customer_row.room to reference the ROOM field in the location_row variable. Write a program that uses an Explicit Cursor to retrieve and display the invoice number value (using %TYPE variable) for every record in the INVOICE table in which the customer code is 10014. DECLARE current_inv_num NUMBER(4); CURSOR invoice_cursor IS SELECT p_code FROM invoice WHERE inv_number = current_inv_num; current_p_code invoice_cursor%ROWTYPE; BEGIN OPEN invoice_cursor; current_inv_num := '1001'; LOOP FETCH invoice_cursor INTO invoice_cursor; EXIT WHEN invoice_cursor%NOTFOUND; DBMS_OUTPUT.PUT_LINE('The current product code in ' || current_inv_num || ' ' || invoice_p_code.p_code); END LOOP; CLOSE invoice_cursor; END; / Triggers A Trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event. A trigger is invoked before or after a data row is actually inserted, updated or deleted. A trigger is associated within a database table. Each database table may have one or more triggers. A trigger is executed as part of the transaction that triggered it. Uses of Triggers Triggers can be used to enforce constraints that cannot be enforced at the DBMS design and implementation levels. Triggers add functionality by automating critical actions and providing appropriate warnings and suggestions for remedial action. Triggers can be used to update table values, insert records in tables and call other stored procedures. Syntax to create a Trigger in Oracle CREATE OR REPLACE TRIGGER trigger_name [BEFORE/AFTER] [DELETE/ INSERT/ UPDATE OF column_name] ON table_name [FOR EACH ROW] [DECLARE] [varaible_namedata type[:=initial_value] ] BEGIN PL/SQL instructions; …………. END; Syntax to create a Trigger in Oracle The Triggering timing: BEFORE or AFTER. This timing indicates when the trigger's PL/SQL code executes; in this case, before or after the triggering statement is completed. (BEFORE means before the changes are permanently saved to disk but after the changes are made in memory.) The triggering event: the statement that causes the trigger to execute (INSERT, UPDATE or DELETE). The triggering level: A statement-level trigger is assumed if we omit the FOR EACH ROW keywords. This executes only once before or after the triggering statement is completed. A row-level trigger requires use of the FOR EACH ROW keywords. This is executed once for reach row affected by the triggering statement. The Triggering action: The PL/SQL code enclosed between the BEGIN and END keywords. Each statement inside the PL/SQL code must end with a semicolon. Example Create a trigger which should be activated when a product's quantity on hand is updated when the product is sold, the system should automatically check whether the quantity on hand falls below its minimum allowable quantity. CREATE OR REPLACE TRIGGER TRG_PRODUCT_REORDER AFTER INSERT OR UPDATE OF P_QOH ON PRODUCT BEGIN UPDATE PRODUCT SET P_REORDER = 1 WHER P_QOH <= P_MIN; END; / Verifying The Trigger SELECT * FROM PRODUCT WHERE P_CODE ='11QER/31'; -------UPDATE PRODUCT SET P_QOH = 4 WHERE P_CODE =' 11QER/31'; -------- SELECT * FROM PRODUCT WHERE P_CODE ='11QER/31'; SECOND version of the TRG_PRODUCT_REORDER TRIGGER What happens if we reduce the minimum quantity of product '2232/QWE'? When we update the P_MIN column, the trigger is never executed. TRG_PRODUCT_REORDER executes only after an update of the P_QOH column. To avoid that inconsistency we need to modify the trigger event. CREATE OR REPLACE TRIGGER TRG_PRODUCT_REORDER AFTER INSERT OR UPDATE OF P_QOH, P_MIN ON PRODUCT BEGIN UPDATE PRODUCT SET P_REORDER = 1 WHER P_QOH <= P_MIN; END; / What happens if we change the P_QOH value for product '11QER/31 from 4 to 29 when the P_MIN is set to 5 and P_REORDER is 1' The P_REORDER flag is still set to 1 because the trigger sets the P_REORDER value only to1;it does not reset the value to 0, even if such an action is clearly required when the inventory level is back to a value greater than the minimum value. Why did not the trigger change the reorder flag to 0? Third version of the TRG_PRODUCT_REORDER TRIGGER To avoid that inconsistency we need to modify the trigger event. CREATE OR REPLACE TRIGGER TRG_PRODUCT_REORDER BEFORE INSERT OR UPDATE OF P_QOH, P_MIN ON PRODUCT FOR EACH ROW BEGIN IF :NEW.P_QOH <=:NEW.P_MIN THEN :NEW.P_REORDER :=1; ELSE :NEW.P_REORDER :=0; ENDIF; END; / Third version of the TRG_PRODUCT_REORDER TRIGGER The computer cannot change anything directly in permanent storage (disk).It must read the data from permanent storage to primary memory; then it makes the change in primary memory and finally, it writes the changed data back to permanent memory (disk). All changes are done first in primary memory, then are transferred to permanent memory. Third version of the TRG_PRODUCT_REORDER TRIGGER To ensure data integrity, DBMS makes two copies of every row being changed by a DML statement. The first copy contains the original(old) value of the attributes before the changes. The second copy contains the changed(new) values of the attributes that will be permanently saved to the database. Create a Trigger to update an attribute in a table other than the one being modified Example: Create a trigger that automatically reduces the quantity on hand of a product with every sale. CREATE OR REPLACE TRIGGER TRG_LINE_PROD AFTER INSERT ON LINE FOR EACH ROW BEGIN UPDATE PRODUCT SET P_QOH =P_QOH :NEW.LINE_UNITS WHERE PRODUCT.P_CODE = :NEW.P_CODE; END; / Use of variables within a trigger Example: Create a trigger to update the customer balance(CUS_BALANCE) in the CUSTOMER table after inserting every new LINE row. The trigger code is CREATE OR REPLACE TRIGGER TRG_LINE_CUS AFTER INSERT ON LINE FOR EACH ROW DECLARE W_CUS CHAR(5); W_TOT NUMBER:= 0; -- to compute total cost BEGIN -- this trigger fires up after an INSERT of a LINE -- it will update the CUS_BALANCE in CUSTOMER Use of variables within a trigger -- 1) get the CUS_CODE SELECT CUS_CODE INTO W_CUS FROM INVOICE WHERE INVOICE.INV_NUMBER = :NEW.INV_NUMBER; -- 2) compute the total of the current line W_TOT := :NEW.LINE_PRICE * :NEW.LINE_UNITS; -- 3) Update the CUS_BALANCE in CUSTOMER UPDATE CUSTOMER SET CUS_BALANCE = CUS_BALANCE + W_TOT WHERE CUS_CODE = W_CUS; END; Deleting a Trigger Although triggers are independent objects, they are associated with database tables. When you delete a table, all its trigger objects are deleted with it. To delete a trigger DROP TRIGGER trigger_name; Trigger Action Based On Conditional DML Predicates Triggers are created depending on the type of DML statements such as INSERT or UPDATE or DELETE that fires the trigger. But how would we know which one of the three statements caused the trigger to execute? In those cases, we could use the following syntax: IF UPDATTING THEN ….ENDIF; IF INSERTING THEN… ENDIF; IF DELETING THEN … ENDIF; PL/SQL Stored Functions We can create our own stored functions. Stored procedures and functions are very similar. A stored function is basically a named group of procedural and SQL statements that returns a value indicated by a RETURN in its program code. We can use function in the right side of the assignment statement. PL/SQL Stored Functions Syntax: CREATE FUNCTION function_name(argument IN data-type,….) RETURN data-type [IS] BEGIN PL/SQL statements; …… RETURN (value or expression); END;


text:
Baseball in South Bend
€ 18,99
Besorgung - Lieferbarkeit unbestimmt
September 2004
BeschreibungThe national pastime began to take root in South Bend in the 1860s when teams like the Hoosiers, Excelsiors, and Rough-and-Readys took the field to the delight of local fans. By 1878, the legendary South Bend Greenstocking had arrived on the scene, winning the mythical Indiana State Baseball Championship and establishing the nickname of choice for South Bend baseball for years to come. The following decades saw the rising popularity of not only minor league baseball but also barnstorming teams, indoor baseball, factory leagues, and men's and women's amateur leagues. This rich baseball heritage is carried on today by the South Bend SilverHawks of the Class-A Midwest League.
Untertitel: Sprache: Englisch.
Verlag: ARCADIA PUB (SC)
Erscheinungsdatum: September 2004
Seitenanzahl: 128 Seiten
Format: kartoniert

subset: commoncrawl


text:
Kingdom of Sicily (11th – 13th c.)
The Normans captured Sicily from the Arabs who ruled the island from 902 in the 11th century. The Kingdom of Sicily encompassing the island of Sicily, the whole Mezzogiorno region of southern Italy, and the islands of Malta and Gozo was established by Roger II, Count of Sicily who crowned himself King of Sicily in 1130.
Roger II (1130-1154) spent his early reign struggling for confirmation of his title, defending his kingdom against the foreign invasions and quelling rebellions of his premier vassals Grimoald of Bari, Robert II of Capua, Ranulf II of Alife, Sergius of Naples and others. Roger II managed to consolidate his power by 1140 and later conquered the coast of Africa from Tunis to Tripoli.
Roger II was succeeded by his son William I the Bad (1154-1166) who suppressed the rebellions of the barons. His heir and successor William II (1166-1189) died childless and the Sicilian crown was assumed by his cousin Tancred of Lecce (1189-1194) on his death in 1166. The Sicilian throne was also claimed by Constance of Sicily, Tancred's aunt and wife of Holy Roman Emperor, Henry VI. The latter launched a campaign and deposed Tancred's infant son and successor William III (1194). Thus the Sicilian crown passed to the Hohenstaufen Dynasty.


text:
The Team Takeover Thursday contest winner is
0 Comments
Thrashley Rosemeyer!
You had us at "monogrammed Lands End turtleneck." Thanks for the comments, everyone! We're stoked for Session 4 with Surface Skis. Thrashley, send us an e-mail to firstname.lastname@example.com and we'll get you your swag bag.
We'll be back next week for another Team Takeover Thursday with one of our pro teams for Summer 2012! Meanwhile, check out the snowboard and ski Team Takeover Schedules and get registered for your session at Windells!


text: Viktor Pobedinsky / AP PhotoPrypiat: Russia's Secret Radioactive WonderlandFrom Outside's visit to the site of the Chernobyl meltdown to Vanity Fair's inquiry into Mel Gibson's troubled private life, The Daily Beast picks our favorite longform journalism from around the Web this week.02.24.11 7:18 PM ETViktor Pobedinsky / AP PhotoViktor Pobedinsky / AP PhotoThe area around the Chernobyl nuclear power plant in eastern Ukraine—the site of the biggest nuclear disaster in history—has been forbidden to humans for 25 years. The ruins are now overgrown and teeming with wildlife—deer, elk, wolves, foxes, birds—thriving at unprecedented levels. Gleb Garanich / ReutersA room containing Soviet placards in the abandoned city of Prypiat, near the Chernobyl nuclear power plant, on February 22, 2011.Gleb Garanich / ReutersA room containing appliances in the abandoned city of Prypiat, near the Chernobyl nuclear power plant, on February 22, 2011.Elena FilatovaA Geiger counter reading of the radioactive level at the Chernobyl power plant, in 2003.Viktor Pobedinsky / AP PhotoA deserted hotel in PrypiatViktor Pobedinsky / AP PhotoWriting on a deserted apartment building quotes the Soviet Union's national anthem: "Lenin's Party, people's power/ Leads us to triumph of Communism."Keith Adams


text:
Need a TPO Test in Mchenry, IL? Simply order online 24/7 and get a fast, affordable TPO Test at a lab near you (Find More Locations):
What is a TPO Test?
A TPO Test is a lab test that checks the TPO level. People in Mchenry, IL order the TPO Test to assess how Thyroid Peroxidase Antibodies may be affecting their thyroid function.
How much does a TPO Test cost?
Our TPO Test prices include the doctor's order that you need to get tested in Mchenry, IL, all lab fees and taxes, and a pdf copy of your results. For current prices, please CLICK HERE.
What does a TPO Test lab report look like?
For a popular sample report, please CLICK HERE.
We are delighted to offer the TPO Test in Mchenry, IL.
TPO Test in other cities near Mchenry, IL:Alden | Algonquin | Cary | Crystal Lake | Fox Lake | Fox River Grove | Ingleside | Island Lake | Lake In The Hills | Richmond | Ringwood | Solon Mills | Spring Grove | Wonder Lake | Woodstock


text:
Thank you for visiting the Western Elementary Schools online application. On this page you will find a few instructions to get you started with the application.
Before beginning the application, we ask that you read our Requirements & Policies.
School Year Enrolling In:
Select 2016-2017 if you are enrolling a student for the CURRENT school yearSelect 2017-2018 if you are enrolling a student for the NEXT school year (beginning 8/23/2017)
Please note that building assignments are based upon class size. You will be notified after your application has been processed of your child's building assignment.
If you have already created an account for a Jackson County School
please login to your account to continue:
If you do NOT have a Jackson County School account please create an account using the form below:
The Office would like to assure all applicants that the information gathered on this application is kept confidential, and will not be shared with anyone outside our office.
If I'm interested but want more information, where can I go? Call or visit the District Office at (517) 841-8100 . Western School District, 1400 South Dearing Rd., Parma, MI 49269, Contact Us


text:
It only takes a minute to get started. Fill out our uncomplicated sign up form and login to the website.
This step is optional but will greatly multiply your chances of getting interest from other over 40s members on the site. Write about yourself, your pasttimes and upload some good photos of yourself.
Use our website's state-of-the-art search to uncover over 40s members who match your needs. Or just flip through listings and uncover members that interest you.
Identified someone who ticks all the boxes? Send an email to them or just a wink and see what they say. With a little luck you'll be on your way to an amazing adventure.
And start dating


text:
Better known as the Strip Pits. The Mined Land Wildlife Area takes in over 1500 acres with over 200 lakes to fish. The pits are stocked with large mouth bass, walleye, channel catfish, crappie, bluegil, redear sunfish, spotted bass, wipers and bullhead. There is even a trout pit at unit 30. Pits are stocked on a rotation about every two years. Some of the best fishing in Kansas.
Public hunting is available, in season, for white-tailed deer, wild turkey, rabbits, squirrels, dove and more.
Great opportunity to obsersve or take photos.
- Pets Allowed:
- Primitive Campsites:
Hunting Lodge/Outfitter
- Fishing:
- Hunting:
- Deer:
- Turkey:
- Camping:
- Primitive Camping:
- Lodging Nearby:
- Trails:
- Horsepower Restrictions:
- Fishing:
- Hunting:
- Camping Cabins:
- Boat Ramp Lanes:
State Parks
- Primitive Camping:
- Lodging Nearby:
- Fishing:
- Hunting:
- Boat Ramp Lanes:


text:
New England is an area which comprises six states of the northeastern United States, including Vermont, which is known as home to America's best wooden furniture. If you are an admirer of simple designs, attention to detail and proportion, sustainable production, and integrity of construction, New England furniture makers will not disappoint you.
NFL Quilted Wristlet Bag
This charming super-jumbo stage is perfect decoration for your interior. Beautifully made is very effective and works well in any decor, also in the child's room. Interesting colors.
NFL Novelty Utility Mat
This interesting publication is the perfect solution for everyone who loves stre furniture. Beautifully photos and interesting descriptions allow the reader a style of English furniture.
This beautiful publication is a real treat for lovers of French style furniture. Beautiful images and detailed descriptions delight giving the interior a unique character. The whole beautifully framed.
Old Pewter: Its Makers and Marks in England, Scotland and Ireland an Account of the Old Pewterer & His Craft
Asian style handmade bedroom furniture|New England furniture makers
Charles Guillam (Maker) Place of Origin:Saybrook, Connecticut, New England, United States, North America Date:1710-1727
Pawtuck Furniture Maker NEW Department Dept. 56 New England Village NEV
Asian style handmade bedroom furniture|New England furniture makers
Work table
Doucette Wolfe Fine Furniture Makers Custom Fine Furniture Maker New England Made
Blanket Chest | Furniture | Attributed to Hawks, John, 1643-1721 (Maker) | 1991.1474 -- Historic New England
Andersen & Stauffer Furniture Makers : Tables : New England Oval Top Stand
Asian style handmade bedroom furniture|New England furniture makers
; Chest of Drawers | Furniture | Symonds shop (Maker) | 1944.22 -- Historic New England
JOHN III GAINES (Furniture Maker) Place of Origin:Portsmouth, New Hampshire, New England, United States, North America Date:1735-1740 Materials:Maple, soft; Paint
Wall bracket, unknown maker, 1695-1710. The exuberant Baroque style originated in Italy and influenced all of Europe. English designers found new ideas in printed books of Continental ornament. Dutch and French Huguenot craftspeople who settled in England
A beautiful example of true nautical art that will compliment any coastal decor. This sperm whale wood carving is the choice to make, when you want your home to both look and feel original and have a complete decor.
Thomas Sherburne (possibly maker) Place of Origin:Boston, Suffolk, Massachusetts, New England, United States, North America Date:1780-1795 Materials:Mahogany; Pine, white ; Pine, yellow
A charming accent for any household - this piece features the New England village and sports the colorful and beautiful finish with the amazing attention to details and the premium quality craftsmanship.
Kalon Studios follows a philosophy of local manufacturing. Each piece is handcrafted to order from non-toxic and responsibly harvested materials by traditional furniture makers in New England
Job Coit Sr. (Maker), Job Coit Jr. (Maker) Place of Origin:Boston, Suffolk, Massachusetts, New England, United States, North America Date:1738-1738 Materials:Walnut, black; Pine, white; Glass; Brass
New England original blue painted blanket chest over drawers. Signed and dated by the maker John Booth 1820.
These shutters were salvaged in New England, trucked out here by a friend of mine. Beautiful colors and appearance, they have had a hard life with those hardcore New England winters! Repurposed as doors in this cabinet, lots of color here! Bryan Appleton
Perfectly green New England tea room. Photography: Yaritza Colón Photography -
Date Made: 1825-1845 Maker: Attributed to New York or New England. Description: Simple washstands like this provided a place to hold a wash basin and pitcher of water so people could wash up in their bedrooms. These were common in most 19th century househ
Serving Table. Date / Circa: c. 1820-1835 Maker / Origin: New England, porb. Worchester, MA Medium: Pine with the original painted and stencil-decorated finish.
Dimensions: Ht. 14', W. 19", D. 16" Date / Circa: c. 1831 (dated newspaper lining) Maker / Origin: Native American, Woodlands, New England Medium: Woven splint with swabbed decoration.
Sheep hooked rug Dimensions: Mounted, 25" x 36" Date / Circa: late 19th c. Maker / Origin: New England Medium: Hooked wool and cotton rags on burlap
Houston Texans Sandwich Press & Waffle Maker
19th Century Original Blue Painted Candle or Wall Box This early 19th century signed original blue painted wall box was found in New England and is in great condition. Signed by the maker on the reverse by Tom Smith.12" x 5" x 3"
Minton Majolica Centerbowl, England, date cipher for 1867, Estimate $2,500-3,500, to be sold on July 14, 2012 at Skinner European Furniture & Decorative Arts auction.
Apothecary Chest with Folding Table Dimensions: H 67 1/2", W 35", D 12 1/2" Date / Circa: c. 1820-40 Maker / Origin: New England Medium: Pine with the original grain-painted finish and brass pulls.
New England adjustable candle holder, c. 1800
Dimensions: Ht 28", Diam. 40" Date / Circa: 1820-1840 Maker / Origin: New England Medium: Pine with a painted finish Miscellaneous: A great small size for a tight space in a contemporary color tone.
Box chairs or 'joyned cheyres', as they were called, furnished the houses of rich merchants as well as nobles. Their seats were supported by panelling rather than legs
VT six board chest, ChestDimensions: Ht. 21 ¾", W. 40", D. 16" Date / Circa: c. 1820 Maker / Origin: New England, prob. VT Medium: Pine with the original paint-decorated finish. Miscellaneous: Excellent condition – surface cleaned
Dimensions: L 44", D 15 3/4", Ht. 22 1/2" Date / Circa: circa 1820 Maker / Origin: New England Medium: Pine Retaining the original green painted finish, lock and till.
KOFOD LARSEN LARGE TEAK CREDENZA $ 2,350.00 Design by Ib Kofod Larsen Teak C. 1960s Made in England by E Gomme Ltd Dimensions: 82" L | 18" D | 31" H G-Plan, a brand of modern furniture produced by E Gomme Ltd of High Wycombe, England, was one of the large
*1775-1790 American (Massachusetts) Masonic armchair at the Metropolitan Museum of Art, New York
Chest of drawers; Four graduated drawers with brass escutcheons, brass bail handles; Craved bracket feet. Maker: unknown Date: 1770-1800 Material: cherry mahogany maple pine Historic New England
made by Staples Cabinet Makers - New England Artisan Gallery! Love it!
The Golden Bed: Place of origin: London, England (made) Date: 1879 (made) Artist/Maker: Burges, William (A.R.A.), born 1827 - died 1881 (designer) Walden, John (maker) Nicholls, Thomas (carver) Weekes, Fred (artist) *Materials and Tec
Pair of 18th Century Royal Crown Derby Porcelain Vases - Lovely pair of vases with exquisite hand painting by a fabulous maker. Circa 1790. LENGTH: 3.5 in. (9 cm) HEIGHT: 7 in. (18 cm) - Full House Antiques, New York
A double-tiered wallbox retaining the original gray painted and varnish finish. Dimensions: H 17", W 10 1/2", D 6" Date / Circa: Late 18th century Maker / Origin: New England Medium: Constructed of pine with rose head nails.
John Pimm (Maker) Place of Origin:Boston, Suffolk, Massachusetts, New England, United States, North America Date:1740-1750 Materials:Maple, soft; Walnut, black; Pine, white; Mahogany; Brass
New England painted dome top storage box, ca. 1815, decorated with flowers and birds on a blue background, 12" h., 33" w., 15" d. A box by the same maker is pictured in Expressions of Innocence and Eloquence. Provenance: Olde Hope Antiques
Bureau table, attributed to John Townsend, ca. 1765, Newport, Rhode Island.
Kalon studios is a young design studio focused on contemporary form and innovative design. Kalon Studios design focus is a much on quality of design as on method and process. Follows a philosophy of local manufacturing. each piece is hand crafted to order


text:
The sounds of irritable beeping and dripping water woke me up.
I frowned and I went when to lift my arm to scratch my face pain shot through my torso; I winced and held my breath; waiting for the pain to wear off.
I wriggled my toes, testing to see if it would hurt. When no pain came I moved my legs around the foot of the bed that I lay on.
A single bed? I asked myself in confusion. Wolf doesn't have a single bed…
I gasped and forced my eyes open. Images of fire, sharp knives, a tied and restrained Melissa and a merciless Zane cutting into my skin with the weird looking knife, flittered through my head. Then I remembered the faint sounds of Wolf's, Alec's and Melissa's voice, then silence.
I looked around the blindingly white room and fought to keep my eyes open. On the left of me was a roll up table that was covered with flowers and teddy bears.
I scowled and looked to the right and saw my arm was hooked up to an I.V, with a heart monitor. I went to reach over to pull them off me when the pain shot through me again. I cried out and squeezed my eyes shut.
I heard footsteps come rushing into the room as I took deep breaths, trying to breathe through the stinging pain.
"Miss Akira you shouldn't move too much." A nurse scolded me as she started to check over my injuries. I clenched my teeth together and looked at her.
"Where is Wolf?" I croaked. She paused and looked at me strangely. A bad feeling started to bloom on the inside of my stomach.
"I'm sorry, who?" She asked with a small frown.
"Wolf, Wolf Darke, where is he?" I asked her. Panic started to grip at me. Where was he? I asked myself.
"How did I get in here?" I asked her. She straightened and looked down at me.
"You were cut up pretty badly from some maniac that kidnapped you." She said to me seriously.
I shook my head. "No, I meant how did I get here? Who brought me here?" I asked her. Her frown deepened.
"I don't know… Would you like me to find out?" She asked me. I bit my lip. What if Wolf didn't want everyone to know that he was the one that brought me in? Or was he even the one that brought me in here?
"No, it's fine." I said quietly. She nodded and went back to examining my injuries. She paused again and looked at me.
"I'm going to have to change the dressings for the knife wounds around your collarbone." She said to me softly with a reassuring pat on my hand.
I took another deep breath and nodded. She pulled more gauze out of the cupboards next to the hospital bed. She stopped next to me again and slowly started to peel back the gauze. I winced as the gauze stuck to the raw wound. She gently tugged it away, ripping off skin and dried blood.
I cried out and dug my nails into the bed. She shot me an apologetic glance and
peeled the rest of the gauze away.
I looked down at the wound. My eyes widened in shock at the sight of it.
"Are those stitches?" I squeaked. She threw the dressings in the sanitary bin and turned back to me.
"Yes, the wounds were starting to get infected, so they cleaned the wounds and stitched you up." She said to me. I looked back down at the wound and fought back tears.
The knife wound was about an inch and a half wide. It was a raw pink colour with a bit of blood seeping through and dried up pus and blood. I knew that the wound were going to leave scars, the reminder of what Zane had done to me was going to stay with me for the rest of my life. I felt tears dribbling down my face. What if Wolf didn't like the sight of my scars? Would he be disgusted that I looked so…tainted?
Then another thought swam through me…
"Prom…" I whispered. My dress wouldn't hide the wounds around my collarbone.
The nurse looked down at me with sympathy in her eyes.
"I have to change the one at the back of your neck." She told me quietly.
She helped me sit forward, stopping now and then so I can get used to the pain that stabbed at me.
"I'm scarred for life…" I whispered miserably.


text:
Catalan donkey
|Catalan donkey
| 250px
Catalan donkey
|Country of origin:
|Catalonia, Northeastern Spain
|Horse (Equus ferus caballus)
The Catalan donkey, ruc català (Equus asinus) is the local donkey of Catalonia (North eastern Spain).
The Catalan donkey is a subspecies of the donkeys from which the donkeys of the middle east and Europe originated. The Catalan donkey is related to the donkey of Mallorca and the zamorà-lleonès donkey. The race is considered to be very old, Pliny the Elder mentioned that there were donkeys on the plain of Vic.
In the past the donkey was very important on farms but due to declining use and numbers the Catalan donkey was in danger of extinction. There once were as many as 50.000, but these days there are only about 500 left, of which more than a 100 outside Catalonia.
After winning several shows and contests, the Catalan donkey is called 'the best donkey in the world', especially for pulling carts and as pack animal.
It is one of the base races of the donkey of Mallorca and the North African donkey. Its properties have contributed to improving donkey races elsewhere in the world.
- Height: ca. 1,65 m from feet to head. It is one of the tallest kind of donkeys.
- Weight: a full grown donkey can weigh up to 500 kg.
- Fur: in summer short and black hair all over the body up to its mouth, white from the eyes and on the belly. In winter longer chestnut colored hair all over the body.
- Ears: straight and pointy.
- Food: grass.
- Habitat: forests.
Recently, advocats of Catalan nationalism have adopted the Catalan donkey as a symbol opposite the Toro de Osborne, typical for Castile and Andalusia.
There are also stickers for cars and scooters. A few people also do not regard the catalan donkey as a symbol of Catalunya, but only as a way to try ridicule the Castillian bull.
External links
- Fuives - world center of the Catalan donkey
|The above article was imported from Wikipedia.org on 08/24/2010 and may be a modified version of the Original Wikipedia article. See this article's history page for a list of revisions which may have occurred after import. This article is displayed here courtesy of the Wikimedia Foundation, Wikipedia, and its authors/contributors in compliance with the Wikimedia Terms of Use Agreement. This article was imported and is licensed under the terms of the Creative Commons Attribution/Share-Alike License 3.0 (CC-BY-SA). Clicking on photos, videos, or drawings in this article will display copyright and license information for that non-text media where available.


text:
Natalie 2Mature
Natalie knew this guy would be a tough nut to crack; he always sat by himself. Well, that just made it easier to sit beside him. Her goal was to get to the bottom of this little mystery she had made for herself, and to do that she needed to become friends with Zack. She wanted something substantial from this encounter, and she needed it before the lecturer came in. But she was at a slight loss as to where to go from here. Even before she had sat down she could see his annoyance. She had pretended not to notice, and the next time she had looked at him, he was pretending to be civil. But throughout her attempts at conversation she could see that he was uncomfortable.
Perhaps she was being far too forward. Yes, she definitely was, but she really wanted to investigate this guy. He really didn't like talking about his gloves; she could tell by the annoyance that crossed his face, and by his snide yet not unfunny remark. She knew she needed to back off a bit; although most guys liked forward girls, she could tell Zack would be the opposite. She remembered a time when she was not too different, not all that long ago. Sometimes she wondered if deep down she was still just a shy little girl. Maybe Zack was someone who would actually respond better to a more egoless person.
She needed something to get to know him; not like asking him for a cup of coffee - that was to sociable. She needed something more rational. And then the perfect excuse hit her.
"Anyway, do you want to do this maths project we have together?" She could see what he was thinking: no, I do not. I am a lone wolf. I role alone. It made her want to work with him more.
"Um, I normally work alone..." he said hesitantly.
"Exactly! You always work alone. Why not try working with someone else? Plus I really need a partner, I can't do this by myself. Pleeeaaase..." She stared deeply and longingly into his eyes. How could he refuse that?
"Don't you have friends." It was more a statement, not a question. And an incredibly harsh one, but Natalie found it funny rather than insulting, coming from Zack. She looked back towards the group of people she normally sat with.
"Nah, they all partnered up together on a lesson I missed," she lied. Actually, she already had a partner, but her best friend would understand. "But if you don't want to then I understand."
"No, okay, let's work together," he finally agreed.
Natalie smiled. She had achieved her goal. Reverse psychology always worked.
"Yay! I'll give you my number. When do you want to meet up and get started?"
"Um, I've already started," Zack said while pulling out his phone and handing it to her, "but is tomorrow after lunch okay for you?" She should have known Zack would be that kind of person.
"Yeah that's okay with me." The lecturer walked in just as she said it.


text:
Save 18%
NEXT WORKING DAY DELIVERY (if ordered by 2pm Mon & Tue and by 3pm Wed- Fri).
The product was delivered promptly and was exactly as described and therefore exactly what we needed and wanted.
Papillon Willow Bunch Weave Hurdles 4ft 6in (1.37m) Fencing Panel
Woven from coppiced willow to a traditional pattern, this beautiful, robust and eco-friendly 6ft willow bunch weave fence panel will make a perfect practical addition to your garden. Bring a part of the countryside to your very own garden with this beautifully woven willow fence panel, which will not only be ideal for the traditional English country garden but also provide gardeners in the 21st century with the opportunity to create a natural look for modern urban spaces.
Willow fencing is coppiced, meaning the branches are cut only from new growth. The purpose is two-fold: to ensure that the branches or 'wands' are flexible and of reasonably uniform thickness, and to allow more growth for next year.
These willow horizontals have been strongly woven and built and depending on the level of exposure to wind and how well they are secured in place, they can be expected to provide a good few years of service and will age gracefully while still maintaining sturdiness.
They can be cut easily to reduce the height by cutting the verticals and removing unrequired horizontals. The width can be reduced by carefully cutting to ensure that the horizontals don't become unwoven. Alternatively, overlap adjacent hurdles to reduce width.
You might also want to consider Willow Screening. Screening is cheaper, and allows you to cover existing walls or fences with natural willow.
All panels are 6ft wide
Please Note: The height refers to the horizontal woven section - the vertical stakes sticking out at the top and bottom add up to an extra 6 inches.
"A few breaks in the wiĺlow"
Reviewed Sunday, 2 April 2017
"just what we wanted"
Reviewed Tuesday, 16 August 2016
"I am very happy with the panels."
Reviewed Monday, 25 April 2016
"very quick."
Reviewed Thursday, 21 April 2016
"It looks great!"
Reviewed Friday, 25 March 2016
"The quality did not match previous orders made and the colour was different"
Reviewed Monday, 22 February 2016
"Product was ok but slight damage after delivery."
Reviewed Wednesday, 17 February 2016
"Ideal for the job"
Reviewed Saturday, 31 October 2015
"Product delivered next day, as it says on the tin."
Reviewed Sunday, 2 August 2015
"They weren't quite the full 6 foot in measurement and they were a little messier than the examples in the pictures but they're ok on the whole."
Reviewed Monday, 25 May 2015


text:
Quin Galavis, Pink Nasty, Monarchs, MaryAnn & the Revival Band, The Sour Notes, Megafauna, Agent Ribbons, Elaine Greer
Thu., June 30, 2011
Spider House Ballroom
2906 Fruth, 512/480-9562
Young guitarist Elaine Greer has been flying under the radar since releasing an EP in 2009, but with the release of debut LP Annotations, she's proven she can take her shimmering folk-pop to the Cactus Cafe or Mohawk. Greer and her band make one last splash before heading out with fellow locals the Sour Notes (of which she's also a member) for a Midwest/East Coast tour. Also on the two-stage bill are two ATX acts dropping new albums. Quin Galavis' first LP, Should Have Known You, offers sweet 1960s pop; Monarchs' Southern soul gets updated with its upcoming Mike McCarthy-produced debut, The Rise and Fall. Prehistoric shredders Megafauna, carnival ladies Agent Ribbons, pop provocateur Pink Nasty, and swing kids MaryAnn & the Revival Band jump on the bandwagon, too. – Audra Schroeder
Quin Galavis
Pink Nasty
The Sour Notes
Agent Ribbons
Elaine Greer


text:
Ash Richards - Breakfast
I took Natalie to a lovely little cafe which in the mornings not only sold ridiculously good coffee but also freshly baked croissants. I watched at Natalie breathed it all in as we stepped into the place. The look of hunger that went over her face at the smell almost made me smile.
I slipped my hand into hers. She flinched at the touch but I didn't care not letting go. "Pick anything you want"
She bit her lip and I gesture towards the menu over the counter. She nodded and we stepped up. "A latte and a croissant with jam please" she said eagerly almost bouncing on her toes.
"I'll have a latte also and some toast with marmalade"
Natalie screwed her nose up at the mention of marmalade. "That stuff tastes vile to me" she mutters.
I laughed and leaned over to her. Closer. I took every chance I could get to do so. "I feel like that should be said at the mention of marmite, missy" I tease her watching the adorable blush that I have grown to love so much cover her cheeks.
She looked down and fiddled with the hems of her shirt with her free hand. She glanced quickly at the one I held. I couldn't let it go. Even if she was distancing herself a little didn't mean I couldn't pull her slowly back in. It didn't mean I couldn't teach her to trust again.
Our orders arrived and I was forced to release her hand to pay. I watch her tug it straight back into her and keep it there as I carried the tray over to a table by the window.
She took the seat up to the wall and I watched her as she drank her latte slowly. Couldn't she see how beautiful she was? Couldn't she see how much I cared?


text:
Arts, Literature & Culture
The Prince and the Zombie
Tibetan Tales of KarmaIn this series of tales, a prince must capture and bring back to his country a zombie who is endowed with magical powers—but in order to succeed he must keep himself from speaking even one word to the zombie. The zombie is wily, and during the long journey he recounts fascinating tales to the prince, who is carrying him in a sack on his back. Spellbound by the stories, the… Read More
Paperback$12.95+ Add to Bag
Love Haiku
Japanese Poems of Yearning, Passion, and RemembranceHaiku is celebrated as a concise form of poetry capable of conveying a singular moment with great clarity. Such poems most often depict the natural world, but they can also be a powerful vehicle for evoking the universal experience of love. In this anthology, romantic love is explored through beautiful images that evoke a range of feelings—from solitary yearning to mutual passion to the bittersweet recollection of love lost. Written… Read More
Paperback$16.00+ Add to Bag
Mama Gone Geek
Calling On My Inner Science Nerd to Help Navigate the Ups and Downs of ParenthoodScience is the ultimate parenting tool. After all, it's really all about observing, asking questions, solving problems, making mistakes, and trying again and again and again—just like being a mom or dad! Come along with Lynn Brunelle as she initiates you into the joys of geek-style parenting. A proud geek mom herself—and an Emmy-winning writer for the show Bill Nye, the Science Guy—Lynn has had a love of science from… Read More
Paperback$16.95+ Add to Bag
Cold Antler Farm
A Memoir of Growing Food and Celebrating Life on a Scrappy Six-Acre HomesteadJenna Woginrich is well loved for her essays on all that accompanies the life of a true homesteader: the mud and mess, the beautiful and tragic, the grime and passion. In Cold Antler Farm, she draws our attention to the timekeeper of such a lifestyle: the ancient agricultural year, filled with celebrations and seasonal touchstones that mark turning points in the cycles of life. Amidst these new-old holidays, we… Read More
Paperback$16.95+ Add to Bag
The Life of Longchenpa
The Omniscient Dharma King of the Vast ExpanseRenowned as a peerless teacher, practitioner, and scholar, Longchenpa thoroughly studied and mastered every one of the many Buddhist vehicles and lineages of teachings existing in Tibet at his time. Through his radiant intellect and meditative accomplishment, in both his teachings and written works, he was able to reconcile the seeming discrepancies and contradictions between the various presentations of the view and the path within the many lineages of transmission.… Read More
Paperback$24.95+ Add to Bag
Twenty Poems to Bless Your Marriage
And One to Save ItMarriage is a journey that passes through different shades and stages as it deepens and matures. This book honors that journey through twenty-one poems that speak to various aspects of the marital relationship—love, compassion, commitment, struggle, tenderness, bliss—selected and with commentary by Roger Housden, the author of Ten Poems to Change Your Life. Taken as a whole, the collection beckons couples to treasure not just the joy and the passion… Read More
Paperback$12.95+ Add to Bag
The Way of Judo
A Portrait of Jigoro Kano and His StudentsKodokan judo, one of the most well-known martial arts in the world today, was originated by Jigoro Kano (1860–1938), a martial artist and career educator who developed the art after studying several types of jujutsu, sumo, and Western wrestling. Openness and refinement were hallmarks of his personal and professional style, and he relentlessly searched for the best way to practice, teach, and perform techniques. This biography shows how Kano… Read More
Paperback$22.95+ Add to Bag
Close to the Ground
Reflections on the Seven Factors of EnlightenmentAfter the bliss and emptiness we might be lucky enough to experience along our spiritual path, what's left are the karmic knots of conditioning that still need to be undone if we are going to be of any genuine help to anybody. Untying them is the work of spiritual warriors: that is, all of us. The seven factors of enlightenment are a means to loosen these knots, all the while… Read More
Paperback$14.95+ Add to Bag
Daddy Long Legs
The Natural Education of a FatherJohn Price appears to have thrown in the towel. He has spent the last year struggling to support his family, neglecting to spend time with his wife and children, and becoming increasingly cynical about the degraded state of the natural world around him. After a heart-attack scare, however, his wife demands that he start appreciating all the "good things" in his life: their mouse-infested old house, their hopelessly overgrown yard,… Read More
Paperback$14.95+ Add to Bag
The Spirit of Noh
A New Translation of the Classic Noh Treatise the FushikadenThe Japanese dramatic art of Noh has long held a fascination for people both in the East and the West. For six hundred years it has had a huge influence on Japanese culture—and has inspired such Western artists as Ezra Pound and William Butler Yeats. Here is a translation of the Fushikaden, a seminal treatise on Noh by the fifteenth-century actor and playwright Zeami (1363–1443), the most celebrated figure in… Read More
Paperback$17.95+ Add to Bag


text:
What does 100% guaranteed mean?
Rukkus utilizes a secure, fully encrypted checkout.
Tickets are delivered in time for your event or your full money back.
If your event is cancelled and not rescheduled, you'll receive a full refund.
Best Price GuaranteedFind a lower price, we'll refund you 100% of the difference.
The Google of finding tix. Really impressed with Rukkus and that I was able to buy close up mets tix at an affordable price. Highly recommend.- Jorah123
The absolute best service of any site. Allowed me to purchase last minute tickets to experience the unbelievably talented Ariana Grande... 5/5 would recommend to a friend.- Thommybahamaa
Great App!
My favorite way to get event tickets. I love having the app for easy access to events.- JBaker939
Inexpensive Tickets, Awesome Customer Service
Found super cheap tickets to a saturday Kings game and the customer service was really helpful. Kings won and Tofolli scored!!!- OG12
Privacy Protected, Fully Secure
Rukkus found 69 Straight No Chaser Concerts
Thu, 7:30 PM
Fri, 7:30 PM
Sat, 7:30 PM
Sun, 7:30 PM
Wed, 7:30 PM
Sun, 7:30 PM
Thu, 7:30 PM
Fri, 7:30 PM
Sat, 7:30 PM
Sat, 7:30 PM
Sun, 7:30 PM
Tue, 7:30 PM
Fri, 7:30 PM
Wed, 7:30 PM
Fri, 7:30 PM
Sat, 6:00 PM
Sun, 7:30 PM
Wed, 7:30 PM
Sat, 7:00 PM
Sat, 8:22 PM
Straight No Chaser Details
Straight No Chaser Ticket InformationNo Bio Available Yet!
More about Straight No Chaser on the web
- Straight No Chaser on Wikipedia
- View all Rock event tickets
Top 3 Straight No Chaser Tracks:
|Carol Of The Bells
|O Holy Night
|Jingle Bell Rock
Straight No Chaser MembersNo Lineup Available Yet!
Todays Straight No Chaser TicketsYou will always find cheap Straight No Chaser tickets everyday, up until the last minute before the Straight No Chaser concert.
Straight No Chaser Ticket Prices
Low: $28.00
High: $267.00
Cheap Straight No Chaser TicketsThe events below have been the cheapest of the season. We've listed the starting (lowest) price for any ticket to the event.
|Straight No Chaser — 11/04/2015
Kiva Auditorium at the Albuquerque Convention Center; Albuquerque, NM
|Straight No Chaser — 04/08/2015
Topeka Performing Arts Center; Topeka, KS
|Straight No Chaser — 11/11/2015
Cannon Center For The Performing Arts; Memphis, TN
|Straight No Chaser — 11/15/2014
Alabama Theatre; Birmingham, AL
|Straight No Chaser — 12/05/2014
Beacon Theatre; New York, NY
|Straight No Chaser — 04/03/2016
Kirby Center; Wilkes Barre, PA
|Straight No Chaser — 07/21/2016
Humphreys Concerts By the Bay; San Diego, CA
|Straight No Chaser — 04/12/2015
Long Center; Lafayette, IN
|Straight No Chaser — 08/04/2016
Wolf Trap; Vienna, VA
|Straight No Chaser — 12/13/2015
Murat Theatre at Old National Centre; Indianapolis, IN
Best and Most Expensive Straight No Chaser TicketsThe events below have been the most expensive of the season. Their starting prices are listed to the left.
|Straight No Chaser — 12/11/2016
State Theatre - The Playhouse Square Center; Cleveland, OH
|Straight No Chaser — 10/23/2014
McCain Auditorium; Manhattan, KS
|Straight No Chaser — 04/06/2016
Lyell B Clay Concert Theatre; Morgantown, WV
|Straight No Chaser — 11/20/2015
Kravis Center - Dreyfoos Concert Hall; West Palm Beach, FL
|Straight No Chaser — 12/17/2015
Indiana University Auditorium; Bloomington, IN
|Straight No Chaser — 12/21/2014
Murat Theatre at Old National Centre; Indianapolis, IN
|Straight No Chaser — 12/27/2015
Ikeda Theatre at The Mesa Arts Center; Mesa, AZ
|Straight No Chaser — 10/27/2016
Civic Center Music Hall; Oklahoma City, OK
|Straight No Chaser — 10/18/2015
Fox Tucson Theater; Tucson, AZ
|Straight No Chaser — 12/09/2015
Embassy Theatre; Fort Wayne, IN


text:
"I think of myself as kind of a hippy. Everyone around me says that's not the impression they get. They think I'm sassy. Apparently, I think I'm nicer than I really am."
Cecily Strong (born February 8, 1984 in Springfield, Illinois) is an American actress, voice actress, and comedian.
Best Known For:
Cecily is best known for being a cast member of Saturday Night Live. She joined the show in 2012. Cecily also made headlines as the featured entertainer at the 2015 White House Correspondents' Association dinner.
Personal Life:
Cecily dated former SNL cast member Mike O'Brien in 2014, but the two have not been seen together much in 2015, leading many to believe they may have split.
Copyright © 2017 Hollywoodlife.com, LLC. All rights reserved.
Powered by WordPress.com VIP


text:
The World's End (15)
(Edgar Wright, 2013 UK) Simon Pegg, Nick Frost, Paddy Considine, Martin Freeman, Eddie Marsan, Rosamund Pike. 109 mins
Wright brings another Hollywood scenario down to earth by virtue of an utterly British setting, and the clash is still hilarious. Especially for the 1990s generation, since this sees Pegg and co attempting to relive their youth with an indie-dance-backed pub crawl down memory lane. Has their hometown changed because of high-street homogenisation, robotic infiltration, or the effects of 12 pints? All three, it turns out.
Breathe In (15)
(Drake Doremus, 2013, US) Felicity Jones, Guy Pearce, Amy Ryan. 97 mins
As he did with Like Crazy, Doremus tells an age-old story with uncanny intimacy and powerful acting, particularly from Jones. Playing an exchange student in New England, she's drawn to Pearce's musician dad, with inevitable consequences.
Wadjda (PG)
(Haifaa al-Mansour, 2012, Sau/Ger) Waad Mohammed, Reem Abdulla, Abdullrahman Al Gohani. 97 mins
A spirited young girl's mission to obtain a bicycle opens a window into the hemmed-in world of Saudi Arabian femininity in this small-scale drama. It's as charming as it is pioneering.
The Frozen Ground (15)
(Scott Walker, 2013, US) Nicolas Cage, John Cusack, Vanessa Hudgens, Dean Norris, Radha Mitchell. 105 mins
The Alaskan setting and Cusack as a serial killer are just about all that stand out about this true-life cop thriller, in which a weary Cage knows whodunnit, but just can't nail him for it.
Easy Money (15)
(Daniel Espinosa, 2010, Swe) Joel Kinnaman, Matias Varela, Dragomir Mrsic. 122 mins
Aiming for that Stieg Larsson crossover, this dense, multicultural saga links Stockholm's high society with its criminal underworld, the police and the Serbian mafia, via a web of conflicted characters. The US remake is already in the works.
Eden (15)
(Megan Griffiths, 2012, US) Jaime Chung, Matt O'Leary, Beau Bridges. 111 mins
Chung excels as a teen sex slave who ends up co-operating with her New Mexican abductors, in a responsible thriller based on a horrific real-life incident.
Suspension Of Disbelief (15)
(Mike Figgis, 2012, UK) Sebastian Koch, Lotte Verbeek, Emilia Fox, Lachlan Nieboer. 112 mins
Figgis enjoys messing with fiction and reality in this cerebral, almost Lynchian experiment, centred on Koch's screenwriter, who could be responsible for a woman's disappearance, even as he romances her twin sister.
Roman Holiday (U)
(William Wyler, 1953, US) Audrey Hepburn, Gregory Peck, Eddie Albert, Hartley Power. 135 mins
60th-anniversary reissue for the reverse-Cinderella fairytale that launched Hepburn and a million European vacations.
D-Day (NC)
(Nikhil Advani, 2013, Ind) Arjun Rampal, Rishi Kapoor, Irrfan Khan. 153 mins
Tough thriller following four agents on a mission to bring back India's most wanted man from Pakistan.
Out from Friday
Springsteen & I
Fans recount how the Boss has touched their lives in this crowdsourced documentary.
Out from Mon
The Wolverine
Probable claws as Hugh Jackman's superhero gets yet another outing – this time he journeys to Japan.
Out from Thu
The Kings Of Summer
Three teen runaways attempt to live parent-free in the woods by building a house.
Dial M For Murder
Hitchcock's killer thriller rereleased in its 3D glory.
Frances Ha
A post-college Greta Gerwig struggles and stumbles into adulthood.
Documentary exposing the dark side of placing killer whales in captivity.
Days Of Grace
Hard-hitting Mexican crime drama set against the backdrop of three World Cups.
Bajatey Raho
Delhi-set heist comedy starring Tusshar Kapoor.
Best Of Luck
Panjabi gangster comedy with bhangra star Jazzy B.
Coming soon
In two weeks ... Ryan Gosling seeks redemption in Only God Forgives … Sandra Bullock and Melissa McCarthy turn on The Heat …
In three weeks ... Liquid Coogan in Alan Partridge: Alpha Papa … Johnny Depp saddles up to ride with The Lone Ranger …
In a month ... Costumed justice is served up in Kick-Ass 2 … Denzel and Wahlberg buddy up in 2 Guns …


text:
It only takes a minute to get started. Fill out our uncomplicated sign up form and login to the website.
This step is elective but will greatly raise your chances of your profile being viewed by others. Introduce yourself, your interests and upload any nice photos of yourself.
Utilise our website's advanced search to spot members who fulfill your criteria. Or just browse through listings and spot folks that seem interesting.
Discovered someone who could be interesting? Drop them a line or just a wink and see what develops from there. With a little luck you'll be on your way to finding your soulmate.
It only takes a few minutes


text:
Auburn Harley-Davidson Dealership Closes
There are 30 comments on the TheKCRAchannel.com story from May 15, 2009, titled Auburn Harley-Davidson Dealership Closes. In it, TheKCRAchannel.com reports that:
Harley-Davidson/Buell of Auburn has closed down because of economic problems and may be sold to another owner, the business said.
Join the discussion below, or Read more at TheKCRAchannel.com.
#21 Jan 4, 2010
Screw Harley. I own two Buells, a 2006 Lightning Long XB12Ss and a 2009 1125CR. And Harley completely f****d over Erik Buell, the 180 Buell Motorcycle Company employees (Americans, for you chest-pounding Harley types), and all of the Buell riders when they suddenly shut down Buell. It wasn't for economic reasons -- Harley doesn't even have numbers showing how Buell affected the bottom line. It was for petty, vindictive s**t involving Erik Buell and some top Harley management.
@Colt 911: You sure talk a lot about the size of other men's penises and getting their respect. You and I ride for different reasons. If you're not man enough to handle a 146hp Rotax-engined V-twin Buell, then stick with your Harley. If you think that dressing up like one of the Village People and riding an overweight, underpowered bike makes people respect you or think that you have a big penis, you have fun with that, sport.
Regarding the current dominance of flat track, you picked a sport where the Japanese and Italians choose not to compete. When Yamaha fielded the TZ700/750, they kicked Harley's ass so bad that the AMA banned the bike. In the mid 80s, Honda came out with the RS750 flat track bike, and proceeded to get the championship in '84,'85,'86, and '87 before dropping out (having proved they could enter a sport Harley was in for decades and snatch the crown away).
Drag racing? Maybe you better look at the records:
See all of the Suzukis and Kawasakis? Where are all of your Harleys that you claim are better at the drag strip?
#22 Jan 4, 2010
Fred I like to play the devils advocate it provokes peoples thoughts. Its easy to just say this sucks You took some time and effort to dispute what I said. Good job
#23 Jan 4, 2010
MotorMike you are a intelligent and a articulate person. HD is going to have a real hard time recovering.When people cant find jobs to live on their not going to buy a bike to play with. Also a lot of the dealers got cocky with the old waiting list mentality they chased people out the door thinking they'd be back because they were the only game.That left a bitter taste. As far as getting people back they need a real entry level bike like the Shortster or Rapido made in the U.S. of course
#24 Jan 4, 2010
Colt 911, That was one hell of a decent response and I want to thank you for it.
I also agree with you about Harley's need to get a lightweight, inexpensive entry level bike out there. They need to get back to selling motorcycles and quit trying to sell a "lifestyle" to a bunch of white collar workers who dress up like pirates on the weekends. Something is very wrong when logo-covered clothing and fashion accessories take up 30% or more of the floor space at a "motorcycle dealer."
As you can tell, I am still bitter about the way that they handled Buell. The never allowed Buell to be sold side-by-side with the competition from Ducati, Triumph, Aprilia, and the Big 4 Japanese manufacturers. Instead, they put them in HD dealers where the sport bike riders didn't find them and where cruiser riders didn't like them. Then, instead of offering to sell all or part of Buell, they just shut it down. Why couldn't they let some manufacturer like Bombardier buy Buell and keep 180 proud, hard-working, talented Americans employed?
Now I'll talk about what's right with HD: They generally treat their customers very well. The support you can get on the phone from them exceeds anything I've seen from other manufacturers, and I've owned well over a dozen motorcycles. The quality of their controls and switches is really good compared to other brands. Their chrome holds up much better than any Suzuki I ever owned. The pricing for repair parts is very reasonable. The sales people are usually respectful and not high-pressure. The quality of construction is generally very good (even if I don't think a lot of their designs). They could do well, but they need to plot out a cradle-to-grave strategy that doesn't rely on peeling customers away from the Japanese bikes as the customers age.
#26 Jan 5, 2010
Say what you will but Harley is GROWING market share, In this Financial recession Harley is Gaining even a bigger lead over its Imitators. The cruiser market is off by 63% while HD sales are off 40%, Do the math. Harley owners are the most loyal group of Riders in America. With Good reason.
#27 Aug 27, 2010
A company that has managed to stay in business for over 100 years,,,must be doing something right. As for the Victory bagger,,,dont want a bike that looks like a spaceship,,,and depreciation is a BITCH! I like a few of the victory models, before my last purchase, went in to the local Victory dealer,,stood by one for 45 minutes, nobody ever came around,,,s i walked out,,never looked back.
My last bike was a japanese litre bike, it was enjoyable at triple digit speeds, terrible for 2-up riding, and after 3 years, it goes from a $12k purchase price, to a blue book value of $5k...wont make that mistake again....Oh,,,and everytime i walked in, there was somebody different behind the customer service counter.
Yeah, I think some harleys are overpriced. But when you buy a HD, you are getting more than just a motorcycle.
I ride with all different makes and models, i dont care what the guy or gal next to me is riding, i know we are both riding for the same reasons. To BE RIDING and putting all your stresses behind.
To all you riders...keep the rubber side down..to all you HD haters that dont even own a bike..Go rent one, bet it changes your life. to all the riders that have never ridden a harley, go test drive one of each model and keep an open mind.
#29 Aug 29, 2010
This only proves that you cannot fool reasonable people forever. Sooner or later, people see through the lies and marketing BS.
#30 Jan 7, 2013
Colt is correct the main reason the jap bike buyers cry Harley they can't afford one so its easy to cry and cut down these jap bike buyers are not honest most have never owned one or rode one much less maintain lone
#31 Jan 11, 2013
oh please.....The used market is so flooded with five year old harleys right now that anyone could pick one up.I don't hate harleys but anyone who picks a bike for performance is going to buy something other than a harley and you know it.
Since: Dec 12
Location hidden
#32 Jan 13, 2013
Harley-Davidson is cool motorcycle,there are many bikers love Harley-Davidson.
Bikerunity(.)net is a very good and serious biker dating site for bikers to share experience and find the relationship.Worth trying.
Tell me when this thread is updated:Subscribe Now Add to my Tracker
Add your comments below
Motorcycles Discussions
|Last By
|Motorcycle rider dies after losing control in O... (Sep '09)
|Biker angered at huge repair bill after Harley ... (Sep '09)
|May 15
|Rt 1 stpete FL
|Wisconsin DOT warns drivers during Motorcycle S...
|May 12
|resident Up North
|Furion Motorcycle's Awesome Hybrid Rotary Concept
|May 9
|A Review of the Yamaha Royal Star Venture Motor... (Jun '08)
|May 7
|Art Bike Scrapey Hawkins says his customized 19... (Mar '14)
|May 5
|Halsey Chapman
|Bayerische Motoren Werke AG (BMW) Given a 85.00...
|May 4
Find what you want!
Search Motorcycles Forum Now
Copyright © 2017 Topix LLC


text:
MrKruntz had een nieuw logo ontwerp nodig en lanceerde daarom een wedstrijd op 99designs.
Een winnaar werd gekozen uit88 ontwerpen ingezonden door28 freelance designers.
Mr Kruntz
Mr Kruntz (website + iPhone app):
Mr Kruntz is the name of a website and cross platform application that knows what you like in relation to restaurants, hotels, attractions, etc (in lifestyle sector) and provides you suggestion.
Mr Kruntz (the individual) - he is the brains / secret formula behind deciding what you like. Think of him as The Stig (Top Gear) of lifestyle decisions.
The Target Audience is broad – 18 – 80 years old, but most aligned to those who go out for food and entertainment and want to try new things and also tell their peers about it.
Logo should be clean and simple.
Must include a full logo for website and where applicable, a Square logo for mobile device branding.


text:
West Ham United manager Sam Allardyce's future at Upton Park is looking increasingly uncertain after the Hammers co-owner David Gold was forced to apologise after 'favouriting' a derogatory tweet about his manager.
The former Bolton Wanderers boss is under considerable scrutiny at the East London club after the Hammers hierarchy publicly criticised him for his transfer policy in recent weeks.
With David Sullivan labelling the £15m signing of Andy Carroll a 'mistake' while openly disagreeing with him on Ravel Morrison's future at the club, the parties appear to be on a collision course.
Gold, who has over 90,000 followers on Twitter, appears to have been caught out after a supporter made contact with the message: "Is today the day we get rid of BFS ?? @davidgold fingers crossed."
The message has since been removed from the 77-year-old's profile.
'BFS' is in reference to a banner displayed by West Ham supporters during the tail end of last season as the club comfortably avoided relegation despite being in the bottom three at Christmas.
Upon noticing his error, Gold addressed the issue this afternoon while notably not revealing his position on Allardyce's future.
"After a 33 hour flight from New Zealand, I was in my car scanning through my tweets and it seems I accidently (sic) favourited one," he wrote on the social media site.
"It has made some of the papers today so I should clarify that I did not and would never deliberately or intentionally endorse a tweet that questions our manager's position. Lesson: don't use twitter when you're jet lagged!"
While Allardyce continues to get results at Upton Park, it is the team's style of play which causes most friction with the fanbase, while Gold's fellow co-owner Sullivan has admitted he harbours regrets about 'putting all his eggs in one basket' by signing Andy Carroll for £15m last summer.
The England striker has since been plagued by injuries and looks set to be out until December at the earliest.
The signing of Enner Valencia, one of the star performers of the World Cup in Brazil, had started a process which Allardyce hopes will eventually appease his critics.
Sullivan, however, also raised eyebrows last week by using an interview with talkSPORT to openly criticise his manager's intention to sell Morrison - stating that the board had other ideas.
"Sam has said Ravel is not part of his plans but we do - as a board - see him as part of our plans," he said.
"I think he said in a press conference, if I read it correctly, he's not part of his plans for this season. I think he said that in New Zealand but we don't agree with that. We would like to sit down and give him a longer contract.
"We do like him. We do see him as part of the long-term future of the club but we have to agree it with the manager because there's no point signing a player he's not going to play."
- More about:
- West Ham United


text:
NAPA, Calif. (AP) — Raiders kicker Sebastian Janikowski has done a lot of changing during his 15-year NFL career.
He's gone from being the brash, hard-living, party-chasing kid out of Florida State who made headlines for all the wrong reasons to a much calmer father of two who prefers quiet times with his children over the social scene.
"It doesn't seem like it's been that long," Janikowski said. "It feels like I just got drafted, for real. Fifteen years and still going strong."
What hasn't changed is Janikowski's powerful left leg.
The 36-year-old remains one of the strongest kickers in the league and is closing in on the NFL record for the most made field goals of 50 yards or longer in a career.
To get it, Janikowski will have to bounce back from a rough 2013 and foster a better relationship with second-year holder Marquette King.
The duo struggled to find any sort of rhythm together after Janikowski's holder the previous 14 seasons, Shane Lechler, signed with Houston as a free agent.
Kickers being creatures of habit, the change in holders was akin to asking Janikowski to kick with his right leg. It was an uncomfortable feeling Janikowski battled all season.
"You stay with the same guy for 14 years, the trust is there," he said. "You don't have to think about it going on the field."
Janikowski converted only 21 of 30 field-goal attempts last season, a 70 percent success rate that was his lowest since 2006 and the third-worst mark of his career.
More telling, Janikowski made just three of his seven attempts from beyond 50 yards — his fewest since 2005 when he went 0 for 3 from that distance.
"Our timing was off," Janikowski said. "Just timing, the confidence … the trust."
In an effort to improve their relationship on and off the field, Janikowski flew to California two months before training camp in order to get in extra work with King.
The two, along with long snapper Jon Condo, worked out together privately and have looked much smoother since training camp began.
"For him to go out and have success, he's gotta be comfortable and feel good that the operation is going to be the same on every single play," Raiders coach Dennis Allen said of Janikowski. "That operation with Jon and Marquette and Seabass (Janikowski) has improved tremendously, and I do think that Seabass has a lot more confidence in Marquette as a holder."
Allen also credited special teams assistant coach Chris Boniol, a former kicker who spent six seasons in the NFL.
"Chris has a way of being able to relate to those guys and talk to them on a level where they can understand what he's trying to get accomplished," Allen said. "To (Janikowski's) credit, he's taken to all of that and done everything that we've asked him to do.
Janikowski reported to camp looking leaner, but more stout than in the previous years.
Part of that was so that he could keep up with his two young daughters, both of whom came out to practice Saturday as part of the Raiders' annual Family Day.
The 17th overall pick in 2000, Janikowski also has his sights set on Jason Hanson's NFL record of 52 field goals of at least 50 yards. The Oakland kicker has 45.
Breaking that record and getting back to the Super Bowl are high on Janikowski's agenda. He and the Raiders played in the Super Bowl in the 2002 season, but haven't returned to the postseason since.
"Super Bowl, that's the ultimate goal," Janikowski said.
Janikowski also believes he can break the NFL's record for longest field goal. Denver's Matt Prater kicked a 64-yarder last year to establish the mark.
"I know Matt's got the record for now," Janikowski said. "It doesn't matter if it's the 70-yarder from (former Raiders coach Lane) Kiffin. It's a challenge."
Around the NFL
49ers' Dorsey tears left biceps muscle: At San Francisco, 49ers nose tackle Glenn Dorsey has a torn left biceps muscle and will undergo surgery, a person with knowledge of the injury said Saturday.
It's unclear how long he might be sidelined. Dorsey left Friday's practice with the injury. The source said Saturday that Dorsey had torn his biceps and would need an operation, speaking on condition of anonymity because the team had not announced anything about Dorsey's injury or the severity.
More tests and details are expected post-surgery, the source said. Another source, also speaking on condition of anonymity, said it would be premature to speculate that Dorsey will miss the entire 2014 season as more evaluations still must be done.
Packers' Abbrederis has torn ACL: At Green Bay, Wis., unlike last year, the Green Bay Packers appeared to have made it through their Family Night event Saturday without a major loss to their roster.
But the Packers still had a significant setback early in training camp.
Rookie receiver Jared Abbrederis confirmed after the 90-minute practice held before a big crowd of 67,336 that he suffered a torn anterior cruciate ligament in his right knee earlier in the week. The injury is expected to keep Abbrederis out the entire season.


text:
Train Schedule of SAMPOORN K EXP 12394
SAMPOORN K EXP (12394) runs from New Delhi (NDLS) to Rajendra Nagar Bihar (RJPB). It has classes first ac (1A), second ac (2A), third ac (3A) and sleeper (SL). 12394 seat availability and train info is available on Trainman. It is a superfast train and covers a distance of 1001 kms in 14 hours 10 minutes. This train runs daily. It has 3 halts. It usually runs on time and reaches Rajendra Nagar Bihar with an average delay of 1 hours 8 minutes. This train runs with an LHB Rake and also has a pantry car. Final chart for 12394 is prepared usually 3-4 hours before train departure time or a day before if train departs early morning. You can check the live train status of train SAMPOORN K EXP (12394) by clicking on the link below.
Runs daily
Check Train Running Status of 12394
Check 12394 seat availability and find more New Delhi to Patna Jn trains
*Note: Average delay is average of delays calculated over previous 7 days.


text:
Addleshaw Goddard, CMS Cameron McKenna and Macfarlanes have won key roles in the estimated £340m secondary buyout of rail logistics company Freightliner Group.
Buyer ;Arcapita, ;the Bahrain-based investment bank, turned to longstanding adviser CMS Cameron McKenna, led by corporate partner Charles Currier.
Currier said: "Despite some challenging economic conditions, deals for quality assets such as Freight- liner are still being done."
Corporate partner Jason Zemmel and finance partner Nancy Eller also worked on the transaction.
The sellers, private equity houses 3i and Electra, were represented by Macfarlanes M&A partner Ian Martin.
Addleshaws acted for the Freightliner management through corporate partner William James.
The deal represents Camerons' second instruction from Arcapita in as many months, after helping the bank buy Eastern European warehouse operator Pinnacle Real Estate in May.


text:
Guerlain Spa
The Guerlain Spa at the Waldorf Astoria Berlin specialises in personalised, soothing treatments that restore calm amidst the energy of the city. Recharge body and soul at the only Guerlain Spa in Germany.
- Waldorf Astoria Berlin Hotel, Germany - Guerlain Spa Waldorf Astoria - Pool
- Waldorf Astoria Berlin Hotel, Germany - Guerlain Spa Waldorf Astoria Hydrotherapy
- Waldorf Astoria Berlin Hotel, Germany - Guerlain Spa Waldorf Astoria Treatment Room
- Waldorf Astoria Berlin Hotel, Germany - Guerlain Spa Pool
- Waldorf Astoria Berlin Hotel, Germany - Guerlain Spa Footbath Lounges
Using cutting-edge innovation and customized techniques that evoke emotion and sensuality, Guerlain's Beauty Coaches provide transformative treatments for the whole person. Select from an invigorating 60-minute facial to full-day immersion with the trendsetting French beauty specialist. A relaxing footbath is the start of each treatment.
Each space within the spa calms, relaxes and soothes you, guiding you from one stress-releasing experience to the next until you reach your personalised private treatment room. Eight therapy rooms in the 1,000 square meter Guerlain Spa are located on the fifth floor of the hotel. They complement the experiences on offer including hydrotherapy, Vichy showers, and massages for one or two. Ensuite showers and baths ensure complete privacy.
Signature Treatments
Indulge in a signature treatment. Guerlain has developed 'Beauty Revelation' exclusively for Waldorf Astoria Berlin. With a full facial and body diagnosis, guests enjoy a hydrating footbath, facial mask and an enveloping massage, all of which leaves the skin glowing and radiant and the features rested. The rhythmic, expert hands of the Beauty Coaches restore youth and vibrancy and alleviate all body tensions.
'Orchidée Impériale Prestige' is a two-hour anti-ageing treatment combining the exclusive firming massage with the high-technology and efficiency of the products of the Orchidée Impériale range. With this treatment, the skin recovers a perfect finish: supple and velvety, with a natural glowing effect. Spa packages and gift certificates available.
Enquire about the exclusive 'Berlin Chic Massage', treatments for men, manicures, pedicures and makeup application.
Spa packages and gift certificates available.
Additional Spa Facilities
The Waldorf Astoria invites you to take a dip in the shaped indoor pool. Rejuvenate in the steam room, sauna or whirlpool and linger on the roof-top sun terrace. The Guerlain boutique features signature products for purchase.
Fitness Centre
Engage in yoga, personal training and Pilates at the fitness centre at Guerlain Spa at the Waldorf Astoria Berlin. The centre also features treadmills, elliptical trainers and free weights.
Contact Details
The Guerlain Spa is open daily from 10.00am until 9.00pm
Guerlain Spa Waldorf Astoria
Hardenbergstraße 28
10623 Berlin, Germany
Tel: +49 (0)30 814000-2950
E-Mail: email@example.com


text:
Filter by:
Content type:
Stage 1&2
Stage 2&3
Stage 3&4
Stage 4&5
Challenge level:
Use Excel to explore multiplication of fractions.
A collection of resources to support work on Factors and Multiples at Secondary level.
Help the bee to build a stack of blocks far enough to save his
friend trapped in the tower.
Discover a handy way to describe reorderings and solve our anagram
in the process.
This resource contains interactive problems to support work on
number sequences at Key Stage 4.
A group of interactive resources to support work on percentages Key
Stage 4.
This resource contains a range of problems and interactivities on
the theme of coordinates in two and three dimensions.
A simple file for the Interactive whiteboard or PC screen,
demonstrating equivalent fractions.
Use an interactive Excel spreadsheet to explore number in this
exciting game!
Use Excel to investigate the effect of translations around a number
Can you beat the computer in the challenging strategy game?
Show that for any triangle it is always possible to construct 3
touching circles with centres at the vertices. Is it possible to
construct touching circles centred at the vertices of any polygon?
Practise your skills of proportional reasoning with this interactive haemocytometer.
The interactive diagram has two labelled points, A and B. It is
designed to be used with the problem "Cushion Ball"
Match pairs of cards so that they have equivalent ratios.
This set of resources for teachers offers interactive environments
to support work on loci at Key Stage 4.
A metal puzzle which led to some mathematical questions.
There are 27 small cubes in a 3 x 3 x 3 cube, 54 faces being
visible at any one time. Is it possible to reorganise these cubes
so that by dipping the large cube into a pot of paint three times
you. . . .
Here is a chance to play a fractions version of the classic
Countdown Game.
Prove Pythagoras' Theorem using enlargements and scale factors.
An environment that enables you to investigate tessellations of
regular polygons
To avoid losing think of another very well known game where the
patterns of play are similar.
A collection of our favourite pictorial problems, one for each day
of Advent.
Use an Excel spreadsheet to explore long multiplication.
A simple spinner that is equally likely to land on Red or Black. Useful if tossing a coin, dropping it, and rummaging about on the floor have lost their appeal. Needs a modern browser; if IE then at. . . .
Use an interactive Excel spreadsheet to investigate factors and
An environment that simulates a protractor carrying a right- angled
triangle of unit hypotenuse.
How good are you at estimating angles?
Can you put the 25 coloured tiles into the 5 x 5 square so that no column, no row and no diagonal line have tiles of the same colour in them?
Use an Excel to investigate division. Explore the relationships
between the process elements using an interactive spreadsheet.
Players take it in turns to choose a dot on the grid. The winner is the first to have four dots that can be joined to form a square.
Can you give the coordinates of the vertices of the fifth point in
the patterm on this 3D grid?
Match the cards of the same value.
The classic vector racing game brought to a screen near you.
Use Excel to practise adding and subtracting fractions.
An Excel spreadsheet with an investigation.
This game challenges you to locate hidden triangles in The White
Box by firing rays and observing where the rays exit the Box.
A java applet that takes you through the steps needed to solve a
Diophantine equation of the form Px+Qy=1 using Euclid's algorithm.
A right-angled isosceles triangle is rotated about the centre point
of a square. What can you say about the area of the part of the
square covered by the triangle as it rotates?
A tool for generating random integers.
in how many ways can you place the numbers 1, 2, 3 … 9 in the
nine regions of the Olympic Emblem (5 overlapping circles) so that
the amount in each ring is the same?
Can you find a reliable strategy for choosing coordinates that will locate the robber in the minimum number of guesses?
Given the nets of 4 cubes with the faces coloured in 4 colours, build a tower so that on each vertical wall no colour is repeated, that is all 4 colours appear.
On the 3D grid a strange (and deadly) animal is lurking. Using the tracking system can you locate this creature as quickly as possible?
How good are you at finding the formula for a number pattern ?
Start with any number of counters in any number of piles. 2 players
take it in turns to remove any number of counters from a single
pile. The winner is the player to take the last counter.
Can you set the logic gates so that the number of bulbs which are on is the same as the number of switches which are on?
Can you make a right-angled triangle on this peg-board by joining up three points round the edge?
Can you beat Piggy in this simple dice game? Can you figure out
Piggy's strategy, and is there a better one?
This is an interactive net of a Rubik's cube. Twists of the 3D cube become mixes of the squares on the 2D net. Have a play and see how many scrambles you can undo!


text: 20 Years Later, What Matters at MURTEC 5/8/2015 Through its 20 year history, MURTEC has endured as the event for peer-to-peer interaction that fosters insightful conversations between operators and technology suppliers. From humble beginnings with only a couple hundred attendees to today's attendance that numbers 500+, MURTEC's growth mirrors the explosive changes and opportunities happening in restaurant technology. READ FULL STORY >>