text:
SQL Workbench/J implements a set of additional SQL commands that are executed directly by SQL Workbench/J (i.e. not by database server).
These commands can be used like any other SQL command (such as
UPDATE or
inside SQL Workbench/J, i.e. inside the editor or as part of a SQL script that is run through SQL Workbench/J
in batch mode.
As those commands are implemented by SQL Workbench/J you will not be able to
use them when running your SQL scripts using a different client program e.g.
SQuirrel or SQL*Plus.
Creates an XML report of selected tables. This report could be used to generate an HTML documentation of the database (e.g. using the XSLT command). This report can also be generated from within the Database Object Explorer
The resulting XML file can be transformed into a HTML documentation of your database schema.
Sample stylesheets can be downloaded from http://www.sql-workbench.net/xstl.html.
If you have XSLT stylsheets that you would like to share, please send them to
To see table and column comments with an Oracle database, you need to enable remarks reporting for the JDBC driver, otherwise the driver will not return comments. To see the "comment" values from SQL Server's extended properties, please setup the property retrieval as described here
The command supports the following parameters:
|The filename of the output file.
A (comma separated) list of objects to report. Default is all objects that are "tables" or views. The list of possible objects corresponds to the objects shown in the "Objects" tab of the DbExplorer.
If you want to generate the report on tables from different schemas you have
to use fully qualified names in the list (e.g.
This parameter supports auto-completion.
A (comma separated) list of schemas to generate the report from.
For each user/schema all tables are included in the report. e.g.
If you combine
The possible values for this parameter correspond to the "Schema" dropdown in the DbExplorer. The parameter supports auto-completion and will show a list of available schemas.
A (comma separated) list of "table like" object types to include. By default
The default for this parameter is
The values for this parameter correspond to the values shown in the "types" dropdown in the "Objects" tab of the DbExplorer. The parameter supports auto-completion and will show a list of the available object types for the current DBMS.
You can include any type shown in the DbExplorer's Objects tab. To e.g. include
This parameter supports auto-completion.
A (comma separated) list of tables to exclude from reporting. This is only used if
-tables is also specified. To create a report on all tables, but exclude those that start
with 'DEV', use
-tables=* -excludeTableNames=DEV*
This parameter can be repeated several times to define the object names per object type to be retrieved.
The format of the argument is
The following will select the tables
-objectTypeNames='table:person,address' -objectTypeNames=sequence:t* -objectTypeNames=view:v_person
The type names are the same ones that can be used with the
-objectTypeNames='table:cust.person,accounting.address' -objectTypeNames=view:public.*
This can also be used to restrict the retrieval of stored procedures:
If this parameter is used at least once, all of the following parameters
are ignored:
The exclusion pattern defined through
|Controls the output of table information for the report. The default is
true. Valid values are
Control the output of sequence information for the report. The default is
|If tables are included in the output, the grants for each table can also be included with
this parameter. The default value is
|Control the output of stored procedure information for the report. The default is
false. Valid values are
This parameter controls if table triggers are added to the output.
The default value is
Defines the title for the generated XML file. The specified title is written
into the tag
<report-title> and can be used when
transforming the XML e.g. into a HTML file.
By default the sourcce code for views is written as retrieved from the DBMS into the XML file.
This might not be a complete
The default is
|Apply a XSLT transformation to the generated XML file.
|The name of the generated output file when applying the XSLT transformation.
A list of parameters (key/value pairs) that should be passed to the XSLT processor. When using e.g. the
stylesheet, the value of the
author attribute can be set using
-xsltParameter="authorName=42". This parameter
can be provided multiple times for multiple parameters, e.g. when using
-xsltParameter="makeLowerCase=42" -xsltParameter="useJdbcTypes=true"
The command
WbGrepSource can be used to search
in the source code of the specified database objects.
The command basically retrieves the source code for all selected objects and does a simple search on that source code. The source code that is searched is identical to the source code that is displayed in the "Source" tab in the various DbExplorer panels.
The search values can be regular expressions. When searching the source code the specified expression must be found somewhere in the source. The regex is not used to match the entire source.
The command supports the following parameters:
A comma separated list of values to be searched for.
Valid values are
If this parameter is set to true, the values specified with
The default for this parameter is
Valid values are
This specifies if all values specified with
The default for this parameter is
Valid values are
When set to true, the comparison is be done case-insesitive ("ARTHUR" will match "Arthur" or "arthur").
The default for this parameter is
Specifies if the object types to be searched. The values for this
parameter are the same as in the "Type" drop down of DbExplorer's
table list. Additionally the types
When specifying a type that contains a space, the type name neeeds to be
enclosed in quotes, e.g.
The default for this parameter is
This parameter supports auto-completion.
A list of object names to be searched. These names may contain SQL wildcards, e.g.
This parameter supports auto-completion.
Specifies a list of schemas to be searched (for DBMS that support schemas). If this parameter is not specified the current schema is searched.
This parameter supports auto-completion.
The functionality of the
WbGrepSource command is also
available through a GUI at
The command
WbGrepData can be used to search
for occurrences of a certain value in all columns of multiple tables.
It is the command line version of the (client side) Search Table Data tab
in the DbExplorer. A more detailed description on how the searching is performed is available that chapter.
To search the data of a table a
SELECT * FROM the_table is executed and
processed on a row-by-row basis. Although SQL Workbench/J only keeps one row at a time in memory
it is possible that the JDBC drivers caches the full result set in memory. Please see the chapter
Common problems for your DBMS to check if the JDBC driver you are using
caches result sets.
The command supports the following parameters:
The value to be searched for
This parameter is ignored when using
Valid values are
When set to true, the comparison is be done case-insensitive ("ARTHUR" will match "Arthur" or "arthur").
The default for this parameter is
Valid values are
When specifying
The default for this parameter is
A list of table names to be searched. These names may contain
SQL wildcards, e.g.
This parameter supports auto-completion.
By default
This parameter supports auto-completion.
A list of table names to be excluded from the search. If e.g. the wildcard for -tables would select too many tables, you can exclude individual tables with this parameter. The parameter values may include SQL wildcards.
By default
If the search value is not expected in columns of that type, excluding them from the search will speed up data retrieval (and thus the searching).
Only columns reported as
By default
If this parameter specifies a valid encoding, binary (aka "BLOB") columns will be retrieved and converted to a character value using the specified encoding. That character value is then searched.
The following statement will search for the text
Arthur in all columns
and all rows of the table
person. It will find values
somefoo or
WbGrepData -searchValue=foo -tables=person -ignoreCase=true
-ignoreCase=true is the default behavior and can be omitted.
The following statement will search for the text
foobar in all columns
and all tables.
WbGrepData -searchValue=foobar -tables=*
The following statement will search for the text
foo in all columns
and all tables. It will match the value
foobar, but not
WbGrepData -searchValue=foo -compareType=startsWith -tables=*
The following statement will search for the text
foo in all columns
and all tables. It will only match the value
foo or
FOO but not
WbGrepData -searchValue=foo -compareType=equals -tables=*
The following statement will search for any value where three characters are followed by two numbers.
It will match
WbGrepData -searchValue="[a-z]{2}[0-9]{2}" -compareType=contains -tables=person
As the column values are only tested if the regular expression is contained, not if
it is an exact match. The above search will also return
To get an exact match using the
contains type, the regular expression needs to be anchored at the start and
the end. The following will only find only values that start with (exactly) two characters and are
followed by (exactly) two digits.
WbGrepData -searchValue="^[a-z]{2}[0-9]{2}$" -compareType=contains -tables=person
The following statement will return rows where any column either contains the value
foo or
the value
WbGrepData -searchValue="foo|bar" -compareType=contains -tables=person
As the column values are only tested if the regular expression is contained, not if
it is an exact match. The above search will also return
For more information about regular expressions please visit: Regular-Expressions.info
This defines an internal variable which is used for variable substitution during SQL execution.
There are two possibilities to define a variable. The short syntax is:
WbVarDef variable=value
The long syntax allows to variables in a different way:
|The name of the variable to be defined.
|The value of the variable.
|Read the variable definitions from the specified file.
|Read the contents of the variable from a the specified file.
|Define a comma separated list of values that are used in the dialog that is shown when prompting for variable values.
More details and examples can be found in the chapter: Variable substitution
This removes an internal variable from the variable list. Details can be found in the chapter Variable substitution.
This list all defined variables from the variable list. Details can be found in the chapter Variable substitution.
WbConfirm command pauses the execution of the
current script and displays a message. You can then choose to stop
the script or continue.
WbConfirm can be called in three different ways:
Without any parameter, then a default message will be displayed
With just a message text, e.g.
WbConfirm Do you really want to drop everything?
Supplying parameters for the message, the text for the "Yes" choice and the text for the "No" choice using standard SQL Workbench/J parameters:
WbConfirm -message="Do you really want to drop everything?" -yesText="OK, go ahead" -noText="No, please stop"
When using
WbConfirm in console (or interactive batch) mode, the check if the "Yes" choice was
typed by the user is done by testing if the "Yes" value starts with the text the user enters (ignoring upper/lowercase
differences). So if the "Yes text" is set to
"Continue", the user can enter
cont and so on. Because of that, the "No" text should not start with
the same letters as the "Yes" text. When using
-yesText=Continue and -noText=Cancel and the user
C, this would be regarded as a "Yes".
This command can be used to prevent accidental execution of a script even if confirm updates is not enabled.
This command has no effect in batch mode unless the
-interactive parameter was specified.
WbMessages command pauses the execution of the
current script and displays a message and waits until the dialog is closed.
WbConfirm the script will always continue once the message dialog is closed.
WbMessage can be called in two different ways:
With just a message text, e.g.
WbMessage Done!
Supplying parameters for the message and the dialog title:
WbConfirm -message="Script finished" -title="SQL Script"
This command has no effect in batch or console mode.
If you want to run a stored procedure that has
OUT parameters, you have to use the
command to correctly see the returned value of the parameters.
Consider the following (Oracle) procedure:
CREATE OR REPLACE procedure return_answer(answer OUT integer) IS BEGIN answer := 42; END; /
To call this procedure you need to supply a placeholder indicating that a parameter is needed.
SQL> WbCall return_answer(?); PARAMETER | VALUE ----------+------ ANSWER | 42 (1 Row) Converted procedure call to JDBC syntax: {call return_answer(?)} Execution time: 0.453s SQL>
If the stored procedure has a REF CURSOR (as an output parameter),
will detect this, and retrieve the result of the ref cursors.
Consider the following (Oracle) stored procedure:
CREATE PROCEDURE ref_cursor_example(pid number, person_result out sys_refcursor, addr_result out sys_refcursor) is BEGIN OPEN person_result FOR SELECT * FROM person WHERE person_id = pid; OPEN addr_result FOR SELECT a.* FROM address a JOIN person p ON a.address_id = p.address_id WHERE p.person_id = pid; END; /
To call this procedure you use the same syntax as with a regular OUT parameter:
WbCall ref_cursor_example(42, ?, ?);
SQL Workbench/J will display two result tabs, one for each cursor returned by the procedure. If you use
WbCall ref_cursor_example(?, ?, ?) you will be prompted to enter a
value for the first parameter (because that is an IN parameter).
When using ref cursors in PostgreSQL, normally such a function can simply be used inside a SELECT
statement, e.g.
SELECT * FROM refcursorfunc();. Unfortunately the PostgreSQL JDBC driver
does not handle this correctly and you will not see the result set returned by the function.
To display the result set returned by such a function, you have to use
WbCall as well
CREATE OR REPLACE FUNCTION refcursorfunc() RETURNS refcursor AS $$ DECLARE mycurs refcursor; BEGIN OPEN mycurs FOR SELECT * FROM PERSON; RETURN mycurs; END; $$ LANGUAGE plpgsql; /
You can call this function using
WbCall refcursorfunc();
This will then display the result from the SELECT inside the function.
With the
WbInclude command you run SQL scripts without
actually loading them into the editor, or call other scripts from within
a script. The format of the command is
WbInclude -file=filename;.
For DBMS other then MS SQL, the command can be abbreviated using the @ sign:
is equivalent to
WbInclude -file=filename;.
The called script way may also include other scripts. Relative filenames (e.g. as parameters
for SQL Workbench/J commands) in the script are always resolved to the directory
where the script is located, not the current directory of the application.
The reason for excluding MS SQL is, that when creating stored procedures in MS SQL, the procedure
parameters are identified using the @ sign, thus SQL Workbench/J would interpret the lines
with the variable definition as the WbInclude command. If you want to use the @ command
with MS SQL, you can configure this in your
workbench.settings configuration file.
If the included SQL script contains
The long version of the command accepts additional parameters. When using the long version, the filename needs to be passed as a parameter as well.
Only files up to a certain size will be read into memory. Files exceeding
that size will be processed statement by statement. In this case the automatic
detection of the alternate delimiter will
not work. If your scripts exceed the maximum size and you do use the alternate delimiter
you will have to use the long version of the command using the
-file and
The command supports the following parameters:
|The filename of the file to be included.
Defines the behavior if an error occurs in one of the statements.
If this is set to
true then script execution will continue
even if one statement fails. If set to
false script execution
will be halted on the first error. The default value is
Specify a delimiter to be used that is different from the standard
A non-standard delimiter will be required to be on a line of its own.
If you specify
select * from person /
but putting the delimiter at the end of a line will not work:
select * from person/
If this parameter is not specified, the SQL standard
|Specify the encoding of the input file. If no encoding is specified, the default encoding for the current platform (operating system) is used.
Controls the logging level of the executed commands.
-verbose=true has the same effect as adding a
WbFeedback on inside the called script.
-verbose=false has the same effect as adding
the statement
WbFeedback off to the called script.
By default any result set that is returned e.g. by a
If true, every SQL statement will be printed before execution. This is mainly intended for console usage, but works in the GUI as well.
If true, display the execution time of every SQL statement and the overall execution time of the script.
Control if each statement from the file should be guarded with a savepoint
when executing the script. Setting this to
true will make
execution of the script more robust, but also slows down the processing
of the SQL statements.
|Controls if errors resulting from DROP statements should be treated as an error or as a warning.
Defines search and replace parameters to change the SQL statements before they are sent to the database. This can e.g. be used to replace the schema name in DDL script that uses fully qualified table names.
The replacement is done without checking the syntax of the statements. If the search value is contained in a string literal or a SQL comment, it is also replaced.
WbInclude also supports conditional execution
my_script.sql but abort on the first error
WbInclude -file="my_script.sql" -continueOnError=false;
Execute the script
create_tables.sql and change all occurances of
WbInclude -file=create_tables.sql -searchFor="oldschema." -replaceWith="new_schema."
Execute a large script that uses a non-standard statement delimiter:
WbInclude -file=insert_10million_rows.sql -delimiter='/';
If you manage your stored procedures in Liquibase ChangeLogs, you can use this command to run the necessary SQL directly from the XML file, without the need to copy and paste it into SQL Workbench/J. This is useful when testing and developing stored procedures that are managed by a Liquibase changeLog.
This is NOT a replacement for Liquibase.
It will not convert any of the Liquibase tags to "real" SQL.
It is merely a convenient way to extract and run SQL statements stored in a Liquibase XML file!
The attribute
splitStatements for the
tag is evaluated. The delimiter used to split the statements follows the usual SQL Workbench/J rules (including the use
of the alternate delimiter).
WbRunLB supports the following parameters:
The filename of the Liquibase changeLog (XML) file. The
<include> tag is NOT supported! SQL statements stored in files
that are referenced using Liquibase's
include tag will not be processed.
A list of changeSet ids to be run. If this is omitted, then the SQL from all changesets (containing supported tags) are executed. The value
specified can include the value for the author and the id,
You can specify wildcards before or after the double colon:
If the parameter value does not contain the double colon it is assumed to be an ID only:
If this parameter is omitted, all changesets are executed.
This parameter supports auto-completion if the
Defines the behaviour if an error occurs in one of the statements.
If this is set to
true then script execution will continue
even if one statement fails. If set to
false script execution
will be halted on the first error. The default value is
|Specify the encoding of the input file. If no encoding is specified, UTF-8 is used.
To be able to directly edit data in the result set (grid) SQL Workbench/J needs
a primary key on the underlying table. In some cases these primary keys are not present or
cannot be retrieved from the database (e.g. when using updateable views).
To still be able to automatically update a result based on those tables (without always
manually defining the primary key) you can manually define a primary
key using the
WbDefinePk command.
Assuming you have an updateable view called
v_person where
the primary key is the column
person_id. When you simply do a
SELECT * FROM v_person, SQL Workbench/J will prompt you for the
primary key when you try to save changes to the data. If you run
WbDefinePk v_person=person_id
before retrieving the result, SQL Workbench/J will automatically
use the
person_id as the primary key (just as if this
information had been retrieved from the database).
To delete a definition simply call the command with an empty column list:
WbDefinePk v_person=
If you want to define certain mappings permanently, this can be done using a mapping file that is specified in the configuration file. The file specified has to be a text file with each line containing one primary key definition in the same format as passed to this command. The global mapping will automatically be saved when you exit the application if a filename has been defined. If no file is defined, then all PK mappings that you define are lost when exiting the application (unless you explicitely save them using WbSavePkMap
v_person=person_id v_data=id1,id2
will define a primary key for the view
v_person and one for
the view
v_data. The definitions stored in that file can
be overwritten using the
WbDefinePk command, but those changes
won't be saved to the file. This file will be read for all database connections and
is not profile specific. If you have conflicting primary key definitions for
different databases, you'll need to execute the
WbDefinePk command
each time, rather then specifying the keys in the mapping file.
When you define the key columns for a table through the GUI, you have the option
to remember the defined mapping. If this option is checked, then that mapping
will be added to the global map (just as if you had executed
The mappings will be stored with lowercase table names internally, regardless how you specify them.
To view the currently defined primary keys, execute the command
To load the additional primary key definitions from a file, you can
use the the
WbLoadPKMap command. If a filename is defined
in the configuration file then that
file is loaded. Alternatively if no file is configured, or if you want to
load a different file, you can specify the filename using the
To save the current primary key definitions to a file, you can
use the the
WbSavePKMap command. If a filename is defined
in the configuration file then the
definition is stored in that file. Alternatively if no file is configured, or if you want to
store the current mapping into a different file, you can specify the filename
using the
-file parameter.
The default fetch size for a connection can be defined in the connection profile. Using the
WbFetchSize you can change the fetch size without changing the connection profile.
The following script changes the default fetch size to 2500 rows and then runs a
WbExport command.
WbFetchSize 2500; WbExport -sourceTable=person -type=text -file=/temp/person.txt;
WbFetchSize will not change the current connection profile.
To send several SQL Statements as a single "batch" to the database server, the two commands WbStartBatch and WbEndBatch can be used.
All statements between these two will be sent as a single statement (using
executeBatch()) to the server.
Note that not all JDBC drivers support batched statements, and the flexibility what kind of statements can be batched varies between the drivers as well. Most drivers will not accept different types of statements e.g. mixing DELETE and INSERT in the same batch.
To send a group of statements as a single batch, simply use the command
WbStartBatch to mark the beginning and
WbEndBatch to mark the end. You have to run all statements together either by using "Execute all" or by selecting all
statements (including WbStartBatch and WbEndBatch) and then using "Execute selected". The following example sends all INSERT statements
as a single batch to the database server:
WbStartBatch; INSERT INTO person (id, firstname, lastname) VALUES (1, 'Arthur', 'Dent'); INSERT INTO person (id, firstname, lastname) VALUES (2, 'Ford', 'Prefect'); INSERT INTO person (id, firstname, lastname) VALUES (3, 'Zaphod', 'Beeblebrox'); INSERT INTO person (id, firstname, lastname) VALUES (4, 'Tricia', 'McMillian'); WbEndBatch; COMMIT;
To save the contents of a
BLOB or
CLOB column
into an external file the
WbSelectBlob command can be used. Most DBMS
support reading of
CLOB (character data) columns directly, so depending
on your DBMS (and JDBC driver) this command might only be needed for binary data.
The syntax is very similar to the regular
SELECT statement, an additional
INTO keyword specifies the name of the external file into which the
data should be written:
WbSelectBlob blob_column INTO c:/temp/image.bmp FROM theTable WHERE id=42;
Even if you specify more then one column in the column list, SQL Workbench/J will only use the first column. If the SELECT returns more then one row, then one output file will be created for each row. Additional files will be created with a counter indicating the row number from the result. In the above example, image.bmp, image_1.bmp, image_3.bmp and so on, would be created.
WbSelectBlob is intended for an ad-hoc retrieval of a single LOB column.
If you need to extract the contents of several LOB rows and columns it is recommended to
use the WbExport command.
You can also manipulate (save, view, upload) the contents of BLOB columns in a result set. Please refer to BLOB support for details.
Normally SQL Workbench/J prints the results for each statement
into the message panel. As this feedback can slow down the execution
of large scripts, you can disable the feedback using the
command. When
WbFeedback OFF is executed, only a summary of the
number of executed statements will be displayed, once the script execution has
finished. This is the same behaviour as selecting "Consolidate script log" in the
options window. The only difference is, that the setting through
is temporary and does not affect the global setting.
WbFeedback traceOn can be used to enable printing of every executed statement
to the screen. The SQL statement printed will be the one after variable substitution and macro expansion.
WbFeedback traceOff will turn tracing of statements off.
SET command is passed on directly to the driver,
except for the parameters described in this chapter because they
have an equivalent JDBC call which will be executed instead.
Oracle does not have a SQL set command. The SET command that is available in SQL*Plus is a specific SQL*Plus command and will not work with other client software. Most of the SQL*Plus SET commands only make sense within SQL*Plus (e.g. formatting of the results). To be able to run SQL scripts that are intended for Oracle SQL*PLus, any error reported from the SET command when running against an Oracle database will silently be ignored and only logged as a warning.
SET feedback ON/OFF is equivalent to the WbFeedback
command, but mimics the syntax of Oracle's SQL*Plus utility.
With the command
SET autocommit ON/OFF autocommit can be turned on or
off for the current connection. This is equivalent to setting the autocommit property
in the connection profile or toggling
the state of the
menu item.
Limits the number of rows returned by the next statement. The behaviour of this command
is a bit different between the console mode and the GUI mode. In console mode, the maxrows
stay in effect until you explicitely change it back using
SET maxrows again.
In GUI mode, the maxrows setting is only in effect for the script currently being executed and will only temporarily overwrite any value entered in the "Max. Rows" field.
The following options for the SET command are only available when being connected to an Oracle database.
SET serveroutput on is equivalent to the ENABLEOUT
command and
SET serveroutput off is equivalent to DISABLEOUT command.
This enables or disables the "autotrace" feature similar to the one in SQL*Plus. The syntax is equivalent to the SQL*Plus command and supports the following options:
Turns on autotrace mode. After running a statement, the statement result (if it is a query), the statistics and the execution plan for that statement are displayed as separate result tabs.
Turns off the autotrace mode.
This is an extension to the SQL*Plus
The information shown in autotrace mode can be controlled with two options after the
ON or
STATISTICS will fetch the statistics about the execution and
which will display the execution plan for the statement. If not additional parameter is specified,
EXPLAIN STATISTICS is used.
If statistics are requested, query results will be fetched from the database server but they will not be displayed.
Unlike SQL*Plus, the keywords (
AUTOTRACE, STATISTICS, EXPLAIN) cannot be abbreviated!
For more information about the prerequisites for the autotrace mode, see the description of DBMS specific features.
In the connection profile two options can be specified to define the behavior when running commands that might change or update the database: a "read only" mode that ignores such commands and a "confirm all" mode, where you need to confirm any statement that might change the database.
These states can temporarily be changed without changing the profile using the
WbMode command.
This changes the mode for all editor tabs, not only for the one where you run the command.
Parameters for the
WbMode command are:
Resets the flags to the profile's definition
Makes all changes possible (turns off read only and confirmations)
Enables confirmation for all updating commands
Turns on the read only mode
The following example will turn on read only mode for the current connection, so that any subsequent statement that updates the database will be ignored
WbMode readonly;
To change the current connection back to the settings from the profile use:
WbMode reset;
The command
WbGenerateDrop can be used to generate a SQL script for a table that
will drop all foreign keys referencing that table, then a
DROP statement for that table
and the statements to re-created the foreign keys referencing that table.
This is useful if you need to re-create a table but don't want to manually delete all referencing foreign keys, especially if the DBMS does not support a cascading DROP.
This is also available in the DbExplorer's context menu as "Generate DROP script".
The command supports the following parameters.
A comma separated list of tables, e.g.
Valid values:
By default
Valid values:
When using
Valid values:
Usually the generated SQL script will be ordered by the type of statements. So first all statements
to drop constraints will be listed, then the drop table statements, then the statements to re-create all foreign keys.
When specifying
Defines the file into which all statements are written. If multiple tables are selected
using the
Specifies an output directory into which one script per selected table will be written.
The script files are named
If neither
-outputFile nor
-outputDir is specified, the output
is written to the message panel.
The command
WbGenerateDelete can be used to generate a SQL script for one or more rows
that should be deleted including all rows from referencing tables (if foreign key constraints are defined)
This is also available through the menu item→ which will generate the delete for the selected row(s) in the current result.
The command supports the following parameters.
Specifies the root table of the hierarchy from which to delete the rows.
Defines the expression for each PK column to select the rows to be deleted. The value for this parameter is the column name followed by a colon, followed by the value for this column or an expression.
You can also specify expressions instead:
For a multi-column primary key, specify the parameter multiple times:
The file into which the generated statements should be written. If this is omitted, the statements are displayed in the message area.
Valid values:
Valid values:
To generate a script that deletes the person with ID=42 and all rows referencing that person, use the following statement:
WbGenerateDelete -table=person -columnValue="id:42";
To generate a script that deletes any person with an ID greater than 10 and all rows referencing those rows, use the following statement:
WbGenerateDelete -table=person -columnValue="id: > 10";
To generate a script that deletes rows from the
film_category where the primary key consists of
the columns
film_id and
WbGenerateDelete -table=person -columnValue="film_id: in (1,2,5)" -columnValue="category_id: in (7,3,5);
WbGenerateScript re-creates the SQL for objects in the database.
It is the command line version of the Generate Script option in the
The command supports the following parameters.
A comma separated list of table (views or other objects), e.g.
A comma separated list of object names to be excluded from the generated script.
The parameter supports wildcards
A comma separated list of schemas. If this is not specified then the current (default) schema is used.
If this parameter is provided together with the
The parameter supports auto-completion and will show a list of the available schemas.
A comma separated list of object types e.g.
The parameter supports auto-completion and will show a list of the available object types for the current DBMS.
Defines the outputfile into which all statements are written. If this is not specified, the generated SQL statements are shown in the message area. file.
If this parameter is is present (or set to true), then all triggers (for the selected schemas) will be retrieved as well.
The default is
If this parameter is present (or set to true), then all procedures and functions (for the selected schemas) will be retrieved as well.
The default is
If this parameter is present (or set to true) a
This parameter controls the generation of table grants. The default value is
If this parameter is present (or set to true), comments will be added that identify the start and end
of each object. The default is
WbGenerateImpTable analyzes an import file and generates a suitable
statement to create a table with a structure that matches the import file, so that the file can be
imported into that table.
By default this command will only check the first 1000 lines of the input file, assuming that the values are distributed evenly. If the data types for the columns do not reflect the real data, the sample size needs to be increased.
The generated table definition is intended for a quick way to import the data and thus the column definitions are likely to be not completely correct or optimal.
The command supports the following parameters.
Specifies the input file to be analyzed. The filename may contain wildcards. When specifying
Defines the number of lines to analyze. The default is 1000 if this parameter is not specified
A value of 0 (zero) or less, results in parsing the entire file.
Possible values:
The type of the import file. The valid types are the same as for WbImport.
To import spreadsheet files, the necessary additional libraries must be installed.
Possible values:
If enabled, all columns will be created as
By default
The delimiter for text files.
The quote character for text files.
The encoding for text files.
Specifies if the input file contains column headers.
The format for date columns.
The format for timestamp columns in the input file.
The character used as the decimal separator.
By default the generated SQL statement is shown in the message area. If
If the input file is a spreadsheet, this parameter defines the sheet number to be analyzed.
The first sheet has the number
When specifying
The table name to use (or create)
Possible values:
By default, the
By default, this will display a dialog to confirm the execution the
Describe shows the definition of the given table. It can be abbreviated with DESC. The command expects the table name as a parameter. The output of the command will be several result tabs to show the table structure, indexes and triggers (if present). If the "described" object is a view, the message tab will additionally contain the view source (if available).
DESC person;
If you want to show the structure of a table from a different user, you need
to prefix the table name with the desired user
DESCRIBE otheruser.person;
This command lists all available tables (including views and synonyms). This output is equivalent to the left part of the Database Object Explorer's Table tab.
You can limit the displayed objects by either specifying a wildcard for the
names to be retrieved:
WbList P% will list all tables or
views starting with the letter "P"
The command supports two parameters to specify the tables and objects to be listed. If you want to limit the result by specifying a wildcard for the name and the object type, you have to use the parameter switches:
Select the objects to be returned using a wildcard name, e.g.
Limit the result to specific object types, e.g.
This command will list all indexes defined on tables available to the current user.
The command supports two parameters to specify the tables and objects to be listed. If you want to limit the result by specifying a wildcard for the name and the object type, you have to use the parameter switches:
Show only indexes for the specified schema, e.g.
Show only indexes for the specified catalog e.g.
Show only indexes for the tables specified by the parameter. The parameter value
can contain a wildcard, e.g.
Show only indexes with the specified name. The parameter value
can contain a wildcard, e.g.
This command will list all stored procedures available to the current user. The output of this command is equivalent to the Database Explorer's Procedure tab.
You can limit the list by supplying a wildcard search for the name, e.g.:
WbListProcs public.p%
This command will list all stored triggers available to the current user. The output of this command is equivalent to the Database Explorer's Triggers tab (if enabled)
Lists the available catalogs (or databases). It is the same information that is shown in the DbExplorer's "Database" drop down.
The output of this command depends on the underlying JDBC driver and DBMS.
For MS SQL Server this lists the available databases (which then could be changed
with the command
USE <dbname>)
For Oracle this command returns nothing as Oracle does not implement the concept of catalogs.
This command calls the JDBC driver's
getCatalogs() method and will
return its result. If on your database system this command does not display
a list, it is most likely that your DBMS does not support catalogs (e.g. Oracle)
or the driver does not implement this feature.
This command ignores the filter defined for catalogs in the connection profile and always returns all databases.
Lists the available schemas from the current connection. The output of this command depends on the underlying JDBC driver and DBMS. It is the same information that is shown in the DbExplorer's "Schema" drop down.
This command ignores the filter defined for schemas in the connection profile and always returns all schemas.
This command will show the source for a single table. The name of the table is given as an argument to the command:
WbTableSource person
This command will show the source for a single view. The name of the view is given as an argument to the command:
WbViewSource v_current_orders
This command will show the source for a single stored procedure (if the current DBMS is supported by SQL Workbench/J). The name of the procedure is given as an argument to the command:
WbProcSource theAnswer
This command retrieves the row counts for several tables at once. If called without parameters the row counts for all tables accessible to the current user are counted.
The command supports the following parameters to specify the tables (or views) to be counted.
Count the rows for tables from the given schemas, e.g.
The parameter supports auto-completion and will show a list of available schemas.
Show only indexes for the specified catalog e.g.
Show only the row counts for the tables (or views) specified by the parameter. The parameter value
can contain wildcards, e.g.
The parameter supports auto-completion and will show a list of available tables.
Define the types of objects which should be selected. By default only tables are considered.
If you also want to count the rows for views, use
The parameter supports auto-completion and will show a list of available object types.
Defines how the resulting table should be sorted. By default it will be sorted
alphabetically by table name. The
So sort by multiple columns separate the column names with a comma:
Possible values:
By default
You can specify a comma separated list of columns to be excluded, e.g.
The name
If none of the above parameters are used,
WbRowCount assumes that a list ot table names was specified.
WbRowCount person,address,ordersis equivalent to
WbRowCount -objects=person,address,orders. When
called without any parameters the row counts for all tables accessible to the current user will be displayed.
Unlike the Count rows item in the DbExplorer,
displays the result for all tables once it is finished. It does not incrementally update the output.
With the
WbConnect command, the connection for the currently running script can be changed.
When this command is run in GUI mode, the connection is only
changed for the remainder of the script execution. Therefor at least one other statement should be
executed together with the
WbConnect command. Either by running
the complete script of the editor or selecting the
WbConnect command
together with other statements. Once the script has finished, the connection is closed
and the "global" connection (selected in the connect dialog) is active again. This also applies
to scripts that are run in batch mode or
scripts that are started from within the console using
When this command is entered directly in the command line of the
console mode, the current connection is closed and the
new connection is kept open until the application ends, or a new connection is established
WbConnect on the command line again.
There are three different ways to specify a connection:
Specifies the profile name to connect to.
This parameter is ignored if either
|Specifies the group in which the profile is stored. This is only required if the profile name is not unique
Allows to specify a full connection definition as a single parameter (and thus does not require a pre-defined connection profile).
The connection is specified with a comma separated list of key value pairs:
If an appropriate driver is already configured the driver's classname or the JAR file don't have to be specified.
If an appropriate driver is not configured, the driver's jar file must be specified:
SQL Workbench/J will try to detect the driver's classname automatically (based on the JDBC URL).
If this parameter is specified,
The individual parameters controlling the connection behavior
can be used together with
|The JDBC connection URL
|Specify the username for the DBMS
Specify the password for the user
If this parameter is not specified (but
|Specify the full class name of the JDBC driver
|Specify the full pathname to the .jar file containing the JDBC driver
|Set the autocommit property for this connection. You can also
control the autocommit mode from within your script by using the
|If this parameter is set to true, a
ROLLBACK will
be sent to the DBMS before the connection is closed. This setting is
also available in the connection profile.
|If this parameter is set to true, SQL Workbench/J will try to detect uncommitted changes in the current transaction when the main window (or an editor panel) is closed. If the DBMS does not support this, this argument is ignored. It also has no effect when running in batch or console mode.
Turns on right-trimming of values retrieved from
columns. See the
description of the
profile properties for details.
|This parameter corresponds to the Remove comments setting of the connection profile.
|This parameter corresponds to the Fetch size setting of the connection profile.
|This parameter corresponds to the Ignore DROP errors setting of the connection profile.
|This parameter corresponds to the Alternate delimiter setting of the connection profile.
If none of the parameters is supplied when running the command, it is assumed that any value
WbConnect is the name of a connection profile, e.g.:
WbConnect production
will connect using the profile name
production, and is equivalent to
WbConnect -profile=production
This command is primarily intended for console mode to show the statements that have been executed. In console mode the number of any of the listed statements can be entered to re-execute that statement from the history directly.
Transforms an XML file via a XSLT stylesheet. This can be used to format XML input files into the correct format for SQL Workbench/J or to transform the output files that are generated by the various SQL Workbench/J commands.
Parameters for the XSLT command:
|The name of the XML source file.
|The name of the generated output file.
|The name of the XSLT stylesheet to be used.
A list of parameters (key/value pairs) that should be passed to the XSLT processor. When using e.g. the
stylesheet, the value of the
author attribute can be set using
-xsltParameter="authorName=42". This parameter
can be provided multiple times for multiple parameters, e.g. when using
-xsltParameter="makeLowerCase=42" -xsltParameter="useJdbcTypes=true"
To run an operating system command use
WbSysExec followed by a valid command for your operating system.
To run the program
ls the following call can be used:
WbSysExec ls
To run Windows commands that are internal to
cmd.exe such as
DIR, you
must call
cmd.exe with the
/c switch to make sure cmd.exe is terminated:
WbSysExec cmd /c dir /n
If you need to specify a working directory for the program, or want to specify the command line arguments individually, a second format is available using the standard SQL Workbench/J parameter handling:
|The name of the executable program
|One commandline argument for the program. This parameter can be repeated multiple times.
|The working directory to be used when calling the external program
WbSysExec also supports conditional execution
To run an internal Windows command using the second format, use the following syntax:
WbSysExec -program='cmd.exe' -argument='/c' -argument='dir /n' -dir='c:\temp\'
WbSyOpen can be used to open a file with the default application of the operating system.
WbExport -file=c:/temp/person.txt -sourceTable=person -type=text -header=true; WbSysOpen c:/temp/person.txt;
Due to limitations of the Java console mode, neither
To turn on support for Oracle's
DBMS_OUTPUT package you have to use the
(SQL Workbench/J specific) command
ENABLEOUT. As an alternative you can
also use the SQL*Plus command
set serveroutput on. In contrast to
set serveroutput on must be terminated with a semicolon (or the alternate
After running
ENABLEOUT the
DBMS_OUTPUT package is enabled,
and any message written with
dbms_output.put_line() is displayed in the message
panel after executing a SQL statement. It is equivalent to calling the dbms_output.enable() procedure.
You can control the buffer size of the
DBMS_OUTPUT package by passing the
desired buffer size as a parameter to the
ENABLEOUT command:
Due to a bug in Oracle's JDBC driver, you cannot retrieve columns with
To disable the
DBMS_OUTPUT package again, use the (SQL Workbench/J specific)
DISABLEOUT. This is equivalent to calling
dbms_output.disable() procedure.
ENABLEOUT and
DISABLEOUT support an additional parameter
to supress the feedback message that the support for
DBMS_OUTPUT has been enabled or disabled.
Defines a new macro (or overwrites an existing one). This command is primarily intended for the console mode
|The name of the new macro
|The name of the macro group in which the new macro should be stored
|The text of the macro
|A file from which to read the macro text. If this parameter is supplied,
-text is ignored
|The encoding of the input file specified with the
-file parameter.
true then the new macro is a macro that is expanded while typing
Display the defined macros. This command is primarily intended for the console mode.
The command
WbEcho can be used to print messages. The following statement:
WbEcho The answer is: 42
will print the text "The answer is: 42" to the message pane in GUI mode, or to the console in batch or console mode.
The following SQL Workbench/J commands support conditional execution based on variables:
Conditional execution is controlled using the following parameters:
The command is only executed if the variable with the specified name is defined.
The command is only executed if the variable with the specified name is defined.
The command is only executed if the specified variable has a specific value
The command is only executed if the specified variable has a specific value
The command is only executed if the specified variable is defined but has an empty value
The command is only executed if the specified variable is defined and has a a non empty value
Not all configuration parameters are available through the Options Dialog and have to be changed manually in the file workbench.settings. Editing the file requires to close the application.
When using
WbSetConfig configuration properties can be changed permanently without restarting SQL Workbench/J.
Any value that is changed through this command will be saved automatically in
when the application is closed.
If you want to e.g. disable the use of Savepoints in the SQL statements entered interactively, the following command will turn this off for PostgreSQL:
WbSetConfig workbench.db.postgresql.sql.usesavepoint=false
For a list of configuration properties that can be changed, please refer to Advanced configuration options
If you supply only the property key, the current value will be displayed. If no argument is supplied for
WbSetConfig all
properties are displayed. You can also supply a partial property key.
WbSetConfig workbench.db.postgresql will list
all PostgreSQL related properties. You can directly edit the properties in the result set.
The value
[dbid] inside the property name will get replaced with the current
The following command changes the property named
if the current connection is against a PostgreSQL database:
WbSetConfig workbench.db.[dbid].ddlneedscommit=true


text:
Indian Workers Get Huge Raise — But Can The Government Afford It?
It's a balance of risk, reward and economic growth.
Mysterious And Giant Snake On The Loose In Maine Seen Eating A Beaver
A mysterious and giant snake is on the loose in Westbrook, Maine, and many area residents couldn't be more excited.
Supervillain Origins: Gorilla Grodd
He may not be the 8th wonder of the world but this is still one ape you don't want to mess with. Join http://www.WatchMojo.com as we explore the comic book origin of Gorilla Grodd.
Actress Judi Dench Gets a Tattoo for 81st Birthday
Dame Judi Dench maybe 81 years old, but that is not too old to get a tattoo. Her daughter Finty gave her the tattoo as a gift for her birthday. Keri Lumm (@thekerilumm) reports.
The Best Part Of 'The Daily Show' Is Leaving 'The Daily Show'
Jessica Williams is leaving this week to concentrate on a brand-new scripted series on Comedy Central.
Royals place OF Lorenzo Cain on disabled list with strained hamstring
The Royals have placed outfielder Lorenzo Cain on the disabled list with a hamstring injury.
Independence Day: Here Are 10 of the Best Fictional Presidents
The President of the United States is one of the most influential people in the world. Let's take a look back at some of the most memorable fictional presidents in film and television.
Source: Christie being vetted for Trump VP pick
New Jersey Gov. Chris Christie, a former Donald Trump rival turned top defender, is being vetted as a potential VP candidate, a source confirmed to CNN.
YouTube Star Accused of Lying About Attack Near Gay Club
A YouTube star who said he was brutally assaulted by three men because he is gay was charged Wednesday with filing a false police report.
Ant-Man Director Talks Sequel
We still have over two years before another Ant-Man movie arrives in theaters, but the film's director is giving us a hint at what we can expect.
A tour of The Void's Ghostbusters VR experience
Follow us on a tour of the Ghostbusters Dimension exhibit at Times Square's Madame Tussauds that includes a paranormal research room, wax figures of the cast of the film and the best VR experience we've ever had.
Gweneth Paltrow Responds to Being Voted Most Hated Celebrity
Gweneth Paltrow has been voted the most hated celebrity of all time - even beating out Justin Bieber, Kristen Stewart and most surprisingly Chris Brown!
Baseball team Sonoma Stompers sign two female players
The Sonoma Stompers have signed Kelsie Whitmore and Stacy Piagno, who become the first two women in professional baseball since the 1950's.
PlayStation Plus Free Games for July
Sony reveals their PlayStation Plus free games lineup for next month and Nintendo shed light on the projected sales for Zelda: Breath of the Wild and more.
Iran news agency: U.S. sailors being interrogated
Ten American sailors are being held by Iran. They were captured after their two small U.S. naval craft entered Iranian waters, according to U.S. defense officials.
Joint Base Andrews Was On Lockdown After Report Of Active Shooter
Personnel at the U.S. military base in Maryland were asked to shelter in place.
The Colors You Should Wear in Summer - According to Astrology
Celeb color astrologer Rose Theodora spills on what shades are best for the season ahead. Watch now!
NYPD Looking For Man Who Stuffed Bag Of Feces Down A Woman's Pants
At about 6 p.m. on Monday, a woman was strolling along East 74th Street when a man grabbed her from behind and stuffed a bag filled with feces into her pants.
Top 10 Game Of Thrones Quotes
These are the lines that define the world of Westeros and beyond. Welcome to WatchMojo.com and today we're counting down our picks for the quotes from Game of Thrones.
Princess Diana's Gravesite Is Getting A Multimillion-Dollar Makeover
This is the first renovation the Althorp Estate has seen in 350 years.
Blast from the past, remembering 'The Baseball Bunch'
In the 80's, MLB treated kids to an instructional baseball TV show complete with skill drills, major league stars and some goofy guests.
Turkish Prime Minister: Attackers Fired After Being Stopped at Security
Turkish Prime Minister Binali Yildirim says one of the attackers at Istanbul's Ataturk Airport blew himself up outside, while two others blew themselves up inside the building.
UK labor leader under fire for anti-semitic remark
UK Labor Leader Jeremy Corbyn's controversial remarks cause tension between Israel and the UK. CNN's Isa Soares reports.
Suspect Leads Police on Slow-Speed Chase in Stolen Budweiser Truck
Police in California say a man in a stolen Budweiser truck was arrested after leading officers on a slow-speed chase Wednesday.
Don't let Facebook use your location to find friends
Make sure the Facebook app is not tracking your location with these easy steps.
Scarlett Johansson Named the Highest Grossing Actress of All Time
Scarlett Johansson has been named the highest grossing actress of all time. She helped rake in 3.3 billion dollars in box office revenue! Not only that, but she is the youngest person on the list which also includes, Harrison Ford, Samuel L. Jackson, Morgan Freeman, Tom Cruise, Johnny Depp and more!
Lightning reach eight-year extension with Steven Stamkos
The Lightning and Steven Stamkos have agreed to terms on an eight-year contract extension worth an average of $8.5 million per season.

subset: commoncrawl


text:
Check out the latest equestrian shows and spectacles in our event diary, get the low-down on the latest gear news, keep abreast of topical matters that could affect you and your horse and even add your own news, too!
and found 18 items
Matches found in News
Justine Thompson, 14 September 2009 14:14
Around 1000 horses will be at The Royal County of Berkshire Show at the weekend, for what is the last big outdoor show of the season.They will be taking part in events from show jumping to driving and showing classes.On Sunday, the show is to provide the climax for the new International Stairway show jumping series. The series was created ...
Justine Thompson,
14 September 2009 14:14
Justine Thompson,
14 September 2009 14:00
Lucy Wiegersma and Granntevka Prince won the Blenheim International three star at the weekend, following a nail-biting finale. "It is very gratifying to win an event of this stature, especially on a fantastic young horse like Prince," said Lucy, whose next stop will be the European Championships in Fontainebleau, France next week with Woodfalls Inigo Jones."Emily and Drivetime wouldn't be ...
Justine Thompson,
08 September 2009 15:29
Endurance Riding was launched as an official Pony Club discipline earlier this year, and now members are gearing up for their inaugural championships.The PC Endurance Championships are to be held at The College EC, Bedfordshire, on September 20 with over 50 competitors due to take part.Competitors, who have qualified at venues around the country, will be split across Junior (eight ...
Justine Thompson,
08 September 2009 14:09
After the Blenheim International Horse Trials was forced to cancel last year due to torrential rain, organisers are delighted to have been watering the course this year!Having done so the Oxfordshire course will now be in tip-top condition ready for the four-day event to start on Thursday – and the weather forecast looks set fair too.Spectators can look forward to two ...
Justine Thompson,
01 September 2009 11:43
A host of top riders will descend on the Blenheim Palace International Horse Trials in early September.Big names in eventing will include Pippa Funnell, William Fox-Pitt, Mary King and Oliver Townend - plus watch out for international stars such as those from the USA, Canada, New Zealand, Australia, France, Germany and even China and Japan.Horse fans will also be able ...
Justine Thompson,
22 June 2009 16:46
The Royal County of Berkshire Show is to provide the climax for a new national show jumping series for identifying and assessing both potential and existing British team competitors.The competition will be one of the highlights of the event on September 19-20, where top class show jumping has been a popular attraction for both spectators and competitors for a number ...
Justine Thompson,
09 February 2009 14:01
Book your Valentine a special ticket to Blenheim Horse Trials and you'll get a free cross-country buggy tour on selected days.The trials take place at Blenheim Palace, Oxfordshire, September 10-13. Tickets are available from £8, and anyone who books a ticket before Feb 14 is eligible for the free buggy tours on Thursday and Friday admission tickets.• To buy one visit ...
Justine Thompson,
03 February 2009 12:06
If you enjoy a great day out with your horse in beautiful countryside then be sure to sign up for this year's Burghley Sponsored Ride.Sadly last year's event was cancelled due to extreme weather conditions, but the organisers expect the 2009 event to be bigger and better than ever.The ride consists of a hack round Burghley Park on the last ...
Amanda Stevenson,
19 September 2008 11:50
The final South Essex Insurance Brokers' Racehorse to Riding Horse qualifier was held at Burghley Horse Trials, Lincs, on September 7. Twenty ex-racehorses took part, despite the difficult going on the final day of a very wet Burghley Horse Trials. The horses coped amazingly well with the deep, muddy ground. South Essex Insurance Brokers, a leading specialist equestrian insurer, instigated this competition to support the ...
Amanda Stevenson,
29 August 2008 16:28
Wellington Riding in Hampshire will be host to the Petplan Equine Area Festivals from September 1-4. As well as the qualifying classes being held throughout the four days, on Wednesday September 3rd, Wellington Riding will be holding their Gala Evening, showcasing the Wellington Riding Advanced Medium Freestyle to Music Championship. The Wellington Riding Advanced Medium Freestyle to Music Championship has attracted ...
Home | News | Horse Answers | Gear | Advice | Subscribe | Forum | Win | Mag | Classifieds | Your Horse Live | Outdoor Subscription | Complaints Policy
© Copyright 2016 Bauer - All rights reserved.
Terms of Use |
Privacy and Cookie Policy |
Advertise with us |
Site map |


text:
In his Angelus message on Sunday afternoon in St. Peter's Square, Pope Francis invited both pilgrims and diocesan locals to join him on Thursday for the annual diocesan Corpus Christi procession, on the feast which celebrates the Eucharist, the Body of Christ. "Next Thursday, according to Roman tradition, we will celebrate holy Mass at St. John Lateran and then we will make a procession with the Blessed Sacrament. I invite Romans and pilgrims to participate in order to express our desire to be a people drawn together in the unity of the Father and of the Son and of the Holy Spirit," Pope Francis said. "We look forward to seeing you all next Thursday at 7 p.m., for the Mass and the procession on Corpus Christi," he declared, referring to the feast day, which traditionally falls on Thursday, but which has been moved to Sunday in much of the rest of the Catholic world.
The Holy Father tied the forthcoming feat of Corpus Christi with the feast just celebrated Sunday, the Most Holy Trinity. "Every Sunday we go to Mass, we celebrate the Eucharist together and the Eucharist is like the 'burning bush' in which the Trinity humbly dwells and communicates itself: this is why the Church has placed the feast of the Body of the Lord after that of the Trinity," taught the Pope, saying that the Divine Love of the Holy Trinity is the "origin and goal of the universe and of every creature."
The Pope asked the crowds to pray for the increasingly volatile situation in Iraq, especially for the Christians there. "I invite all of you to unite yourselves to my prayer for the dear nation of Iraq, above all for the victims and for those who suffer the major part of the consequences of the expanding violence, in particular for the many people, among which there are many Christians, who have had to leave their own homes," explained the Pontiff.


text:
Jan 28, 2014 9:45 AM
It's an ache-beating blast from the past: J. R. Watkins Pain Relieving Liniment ($13), based on the brand's original formula from 1868. This blend of camphor, red pepper and spruce oil still helps relieve sore, stiff muscles - and don't you just love the vintage-style bottle? Rub it on your joints to feel like a proper old prospector.
If you've got a product or service that you'd like to promote on Outblush, click here to find out about our advertising opportunities.
Outblush is a blog for girls who love to shop. Our staff digs up the best clothes, home stuff, beauty items, and more. New items are posted every day — bookmark us and check out:


text:
- Welcome
- Istanbul Awaits The 2020 Olympics
- In The Weka Of a Great Artist
- The Bosphorus Through The Eyes Of European Travelers
- About Sertab Erener
- An Eastern Fairy Tale: Shiraz
- In 10 Steps "New" Houston
- Gokturk-2 Turkey's Signature In Space
- Colors Of The World
- Neighbors And Friends
- Rising Star Of The Arabian Peninsula: Muskat
- Hero Of Every Kitchen: Squash
- Winter In Turkey Campaign
- Saudi Arabia Cultural Days
- Looking For The Abstract In Istanbul
- Don't Wait Three Years
- Perceptions Of A City
- Contemporary Art In The Middle East
- Art Week
- Photo Stops
- Holidays And Architecture
- Peace, Love And Unity
- Local Media On The European Union Path
- March Reserved For Women At Pera
- Scent Of The Orange Blossom
- Shopping's Fun Side
- A Victory Legend
- Sinan's Masterpiece
- The Father Of Antiquarians In Turkey
- Master Of Medicine: Ibn Sina
- Western Music's Most Turkish Instrument
- Visiting The Eternal City
- Rising Star In The Arts: Kinshasa
- Boutique Of The Balkans
- Cool Life
- Yılmaz Karakoyunlu's Thessaloniki
- Panorama Turkey
Rising Star In The Arts: Kinshasa
The Capital Of The Democratic Republic Of Congo, Kinshasa Is Worth Seeing For Its Way Of Life And Recent Progress As Well As The Amazing Natural Beauty That Surrounds It.
For children who love animals
Discover Congo's orphaned Bonobo monkeys, which are given away as pets for children. There are several Bonobo sanctuaries and zoos in the city.
Visit the Academy of Fine Arts for a close acquaintance with the art of the Congo and some special gifts for yourself.
Check out the galleries at Kinsuka for art typical of Kinshasa, which is slowly making a name for itself on the African art scene.
Lose yourself among the colorful traditional costumes, souvenirs, and fruits and vegetables in Kinshasa's sprawling outdoor markets.
Water sports enthusiasts may visit Lac de Ma Vallé, not far from Kinshasa in the middle of the rain forest.
To discover the authentic riches of Africa, you absolutely must see the Pygmy villages and Okapi Wildlife Reserve.
Turkish Airlines has Istanbul-Kinshasa-Istanbul flights 5 days a week, except Tuesdays and Saturdays.
For more information:


text:
Standing and removing your hat are both prerequisites, but so is placing your hand on your heart.
This page and other exclusive local content require a subscription.
Terms of Service | Privacy Policy | The Manhattan Mercury, 318 North 5th Street, Manhattan, Kansas, 66502 | Copyright 2012
Reproduction of any kind is prohibited without written consent.


text:
Lupe Fiasco
Available September 25th, reserve your deluxe digital copy of Food & Liquor II: The Great American Rap Album Pt. 1 now and receive immediate MP3 downloads of "Around My Way
(Freedom Ain't Free)" & "B*tch Bad". Deluxe edition includes bonus content!
Available September 25th, reserve your digital copy of Food & Liquor II: The Great American Rap Album Pt. 1 now and receive immediate MP3 downloads of "Around My Way
(Freedom Ain't Free)" & "B*tch Bad"!
every year we do better, steady on the rise, the tears for lost ones weigh heavy on the eyes, dita sunny's, gold prezzy, twin turbo chevy fo' a ride of course, from the backseats of phantoms i thought of leaving thru suicide doors, love got me thru it, best fans ever made the whole world care, had 51st & 6th looking like Tahrir Square!
Official Steppin Laser Tour Audience Member Uniform:
1. Black T-Shirt 2. Black Shoes Or Boots 3. Black Shades 4. Camoflauge Pants
Didn't get tickets yet? Click HERE to buy now! See ya @ the shows...
A big "CHOICE" shout out to all the fans in New Zealand & Australia for coming out in a MASSIVE way and supporting the first leg of the STEPPIN' LASER WORLD TOUR!!!
We had the most fun we had on tour in a long time. We really appreciate the hospitality, the love and the utter craziness that took place at the shows.
The reviews have been off the charts and we are so humbled by the kind words and appreciation of the effort & energy we try to put into our shows to make it a great and worthy experience for all the fans.
It was really a motivating and inspiring kick-off of which we hope will
Download to Donate for Haiti, featuring a song I did with Kenna called "Resurrection" is now available on iTunes! You can still download the compilation at www.musicforrelief.org and donate at http://musicforrelief.ning.com/page/donate-1. Please continue supporting the Haiti relief effort and pass along the widget to your friends!
Jubilation!!!...Oh Yes! Attention Lupe Fiasco Fans The World Over...Its About That Time...


text:
This item cannot be purchased online at this time, please call us or email us for further information.
Phone: (601) 362-7257
Fax: (888)623-5670
E-mail: email@example.com
The Fun Rugs Supreme Collection Strawberry Patch Rug is a great rug for any room. This rug is full of a strawberry surprise! This rug is a two toned pink with a pink on the border along with a vine or strawberrys circling the rug with a lighter pink in the center of the rug. Not machine washable
Review / Comments Write a review
Follow us for savings
Please Visit Our Store
When in Mississippi
©2015 Cullen's PlayPen Inc.


text:
"Vacation" and "entrepreneur" aren't words usually heard together - but they should be. The long hours and stress of running your own business can really take its toll, not just mentally but physically. It may seem counterintuitive to step away from the business, even for a week, but that time away can help recharge your batteries and gear you up for a productive fall. Here are a few tips to help entrepreneurs and small business owners make the most of their vacations.
Don't unplug completely. Most entrepreneurs get anxious if they can't check their email a few times a day. Instead of leaving the smartphone and tablet at home, bring them along. But do leave the laptop at home. There's no need to do any work on vacation, and it will only leave you feeling stressed if it sits there neglected.
Use the technology for good. Because you're bringing your tablet, use it to help you relax. Download games, or visit BookBub to find low-cost or free e-books to read while you're traveling or relaxing at your destination. (Or use the wifi connection at your destination to catch up on all those shows you're watching on Netflix.) Use your smartphone to explore and find unique places to visit on vacation. And if you're a runner, bring your Garmin to keep track of and create souvenirs of your vacation runs.
Be adventurous. Entrepreneurs are adventurous by nature, and vacation is a great time to try something new: a sushi restaurant, ziplining, or surfing. Check out the reviews on a site like Yelp, and head off for something you wouldn't do back home.
Be lazy. Part of recharging your batteries means laying around, whether it's on the beach, by the pool, or on the balcony of the place you've rented - or even in a cool little coffee shop. Don't feel guilty about reading a trashy novel or napping in the middle of the day. This is vacation.
Treat yourself. Is there a spa or outlet shopping nearby? Or just a really good soft-serve place? No matter what, get yourself a little treat, whether it's a massage, a pedicure, some new shoes, or an ice cream cone with chocolate sprinkles.
If you take the time to relax, you'll come back from vacation feeling refreshed and ready to take on the next challenge, whether it's landing a big client, expanding the business, or solving a conundrum that's been nagging at you. No matter how difficult it may seem to do, enterpreneurs can greatly benefit from taking a real vacation to prevent burning out.


text:
Material Manufacturer
While RoMan Manufacturing is recognized as the world leader in resistance welding power sources, we haven't lost sight of our number one goal - to satisfy you, our customer.We continue to set trends rather than follow the paths of others, remaining flexible to meet the needs of our evolving industry. We welcome the opportunity to develop creative solutions to meet your unique requirements.
AZoM.com provides this information service in accordance
with these terms and conditions.


text: Texas Transportation Institute Executive Associate Agency Director Katie Turnbull has been named a national associate of the National Research Council (NRC). The selection is based on her volunteer service with the TRB. Turnbull joins 28 others in the 2011 Class of National Associates. The program began in 2001 "to recognize extraordinary contributions made by individuals … Read More


text:
Jul 1, 2013 8:10 AM
What, the Notre Dame can have gargoyles, but your shack in the woods is too "unsophisticated" and "has too many racoons living in it"? Turn any abode into the Addams Family mansion with Ranier the Sculptural Dragon Rainspout ($35).
If you've got a product or service that you'd like to promote on Outblush, click here to find out about our advertising opportunities.
Outblush is a blog for girls who love to shop. Our staff digs up the best clothes, home stuff, beauty items, and more. New items are posted every day — bookmark us and check out:


text:
Discover More Ideas You'll Need
Rated 2.5 out of 5 by 2 reviewers.
Rated 4 out of 5 by Susilo Very cute little basket I use this little basket on my nightstand to keep my reading glasses and some small knick knacks I have together. It looks really cute and it doesn't take up a lot of space. May 1, 2016
Rated 1 out of 5 by shill33 Don't waste your money. It is very cheaply made and was falling apart before I even got to use it. It wouldn't be worth even if it was free. September 2, 2013
1-2 of 2
Related Products
Our small gift basket boasts a vibrant pink ...
Use our vintage-inspired basket to store extra magazines, ...
Madras, an exceptionally durable, naturally harvested Abaca fiber ...
Recently Viewed Items


text:
Designer Marco Zanini for the fashion house of Schiaparelli presented his lovely Spring/Summer 2014 collection in the spirit of Performance Art during Paris Couture week on January 20, 2014 in Paris, France.
Models sporting teal coifs donned theatrical yet interesting hats to accessorize Schiaparelli's rather pretty and feminine gowns in a variety of hues and styles to satisfy a variety of tastes and moods.
This is a very playful collection from Zanini not altogether lacking in creativity that incorporates many different themes from pretty florals in chiffon, ruffles, layered tulle, heavy embroidery, metallics and even fluttery shorts in a color palette that mostly embraces pastels and multicolor prints.
Enjoying the Schiaparelli fashion show were Vogue's Anna Wintour, Hamish Bowles, Anna Dello Russo and Franca Sozzani, Diego Della Valle, who is the CEO of fashion line Tod's, designer Jean Paul Gaultier, former French First Lady Carla Bruni-Sarkozy, actress Elle Macpherson and Parisienne fashionistas Ines de La Fressange, Carine Roitfeld.
Take a look at these delightful designs from Marco Zanini for Schiaparelli Spring/Summer 2014 in my slideshow and embedded video…


text:
The Automated ScoreBook
Northern Illinois at Iowa State (Game 1)
Mar 23, 2014 at Ames, Iowa (Cyclone Sports Cmplx)
Score by Innings R H E
Northern Illinois... 643 11 - 15 14 1
Iowa State.......... 231 00 - 6 7 4
Umpires - HP: Mark Oelfke 1B: Mick Cohen 3B: Tom Topping
Start: 12:02 pm Time: 1:46 Attendance: 72
Weather: 24 degrees, clear. NNW 10 MPH
The Automated ScoreBook
Northern Illinois at Iowa State (Game 1)
Mar 23, 2014 at Ames, Iowa (Cyclone Sports Cmplx)
Northern Illinois starters: 23/lf GREMILLION; 21/p RUPARD; 17/1b GRABLE; 8/ss
MILLER; 11/c NAEGELE; 10/3b KOPP; 13/dh STURM; 14/2b KOSSAKOWSKI; 12/rf PHELAN;
6/cf BOWEN;
Iowa State starters: 1/cf Gomez; 21/rf Hawryluk; 6/2b Davison; 23/dh Cappaert;
9/ss Slater; 4/c Hartman; 11/1b Spendlove; 22/3b Rice; 3/lf Reese; 25/p
Northern Illinois 1st - GREMILLION struck out
swinging. RUPARD walked. GRABLE homered to left center, 2 RBI; RUPARD scored.
MILLER doubled to right field. NAEGELE struck out swinging. KOPP reached on an
error by 3b; MILLER advanced to third. STURM singled to center field, RBI; KOPP
advanced to second; MILLER scored, unearned. KOSSAKOWSKI singled through the
right side; STURM advanced to second; KOPP advanced to third. PHELAN doubled
down the lf line, 2 RBI; KOSSAKOWSKI advanced to third; STURM scored, unearned;
KOPP scored, unearned. Imholz to p for Johnson. PHELAN advanced to third on a
wild pitch; KOSSAKOWSKI scored on a wild pitch, unearned. GREMILLION popped up
to ss. 6 runs, 5 hits, 1 error, 1 LOB.
Iowa State 1st - RUPARD to dh. STURM to p. Gomez
singled to center field. Hawryluk struck out swinging. Gomez stole second.
Davison walked. Cappaert walked; Davison advanced to second; Gomez advanced to
third. Slater flied out to cf, SF, RBI; Davison advanced to third; Gomez
scored. Hartman singled, RBI; Cappaert advanced to third; Davison scored.
Spendlove flied out to cf. 2 runs, 2 hits, 0 errors, 2 LOB.
Northern Illinois 2nd - RUPARD singled to right
field. GRABLE walked; RUPARD advanced to second. MILLER out at first 1b to 2b,
SAC; GRABLE advanced to second; RUPARD advanced to third. OSWALD pinch ran for
GRABLE. NAEGELE singled. KOPP singled, advanced to second on the throw, 2 RBI;
NAEGELE advanced to third; OSWALD scored; RUPARD scored. STURM singled to
second base, advanced to second, 2 RBI; KOPP scored; NAEGELE scored.
KOSSAKOWSKI walked. Roggentien to p for Imholz. PHELAN grounded out to ss;
KOSSAKOWSKI advanced to second; STURM advanced to third. GREMILLION flied out
to rf. 4 runs, 4 hits, 0 errors, 2 LOB.
Iowa State 2nd - GRABLE to 1b for OSWALD. Rice
reached on an error by 2b. Reese reached on a fielder's choice; Rice out at
second ss to 2b. Gomez doubled to left field; Reese advanced to third. Hawryluk
fouled out to lf. Davison homered to left field, 3 RBI, unearned; Gomez scored,
unearned; Reese scored, unearned. Cappaert lined out to ss. 3 runs, 2
hits, 1 error, 0 LOB.
Northern Illinois 3rd - RUPARD flied out to cf.
GRABLE walked. MILLER doubled to left center; GRABLE advanced to third. NAEGELE
singled, advanced to third on an error by cf, 2 RBI; MILLER scored; GRABLE
scored. KOPP flied out to cf, SF, RBI; NAEGELE scored, unearned. STURM fouled
out to lf. 3 runs, 2 hits, 1 error, 0 LOB.
Iowa State 3rd - Slater flied out to rf. Hartman
doubled down the lf line. Spendlove singled to left center, RBI; Hartman
scored. Rice struck out swinging. Reese popped up to 2b. 1 run, 2 hits, 0
errors, 1 LOB.
Northern Illinois 4th - KOSSAKOWSKI struck out,
reached first on a passed ball. PHELAN flied out to cf. GREMILLION singled to
center field; KOSSAKOWSKI advanced to second. RUPARD reached on an error by ss;
GREMILLION out at second 2b to ss; KOSSAKOWSKI advanced to third, scored on the
error, unearned. GRABLE walked; RUPARD advanced to second. MILLER lined out to
2b. 1 run, 1 hit, 1 error, 2 LOB.
Iowa State 4th - Gomez grounded out to ss. Hawryluk
singled to third base. Davison popped up to 2b. Cappaert struck out swinging.
0 runs, 1 hit, 0 errors, 1 LOB.
Northern Illinois 5th - NAEGELE singled, advanced to
second on an error by 1b. BARRETT, Kr pinch ran for NAEGELE. KOPP fouled out to
1b. STURM doubled, advanced to third on the throw, RBI; BARRETT, Kr scored.
KOSSAKOWSKI fouled out to 1b. LEONARD pinch hit for PHELAN. LEONARD struck out
swinging. 1 run, 2 hits, 1 error, 1 LOB.
Iowa State 5th - NAEGELE to c for BARRETT, Kr.
PHELAN to rf for LEONARD. Slater grounded out to p. Hartman popped up to 3b.
Spendlove lined out to ss. 0 runs, 0 hits, 0 errors, 0 LOB.


text:
NEW ORLEANS – The Oregon men's and women's track and field teams both received program of the year honors as announced by the United States Track & Field and Cross Country Coaches Association (USTFCCCA) on Monday.
Winning the NCAA Division I Outdoor Track & Field team title in front of the home crowd at Hayward Field not only snapped the Oregon men's 30-year national title drought, but it also clinched the Ducks their first John McDonnell Division I Men's Program of the Year Award since 2010.
A pair of national team titles in track & field, along with a top-five showing during the cross country season, earned the Oregon men their third Program of the Year award.
The honor for the Duck Men breaks a tie with Florida State for the most award wins since it was introduced in 2008-09.
For the sixth consecutive year, the Oregon women have claimed the Terry Crawford Division I Women's Program of the Year Award.
Fresh off a third-place finish in front of the home crowd at the NCAA Division I Outdoor Track & Field Championships, the Ducks will keep the Program of the Year trophy in Eugene for a sixth straight year since its inception during the 2008-09 season.
Oregon's 18 points in the final Program of the Year standings were well clear of the runner-up 29½ points posted by Pac-12 rival Stanford, which just barely edged out third-place Arkansas at 30 points.
The USTFCCCA Program of the Year Award is awarded annually to the most outstanding cross country/track & field programs in each of the NCAA's three divisions for each gender.
In order to be eligible for the award, teams must qualify for each of the NCAA Championships. Scoring is based on the team's finish at each NCAA Championship in cross country and both indoor and outdoor track & field (i.e. 1st = 1 point, 2nd = 2 points, etc.) with the lowest total score for all three championships combined determining the award recipient. Ties among schools split points for positions taken.


text:
Jan. 10, 2000 (Atlanta) -- Herpes simplex virus type 1 (HSV-1) acquired during wrestling is one of the most common infections caused by personal contact during athletic activity, according to a report in the December issue of The Pediatric Infectious Disease Journal. Physicians say the condition, called herpes gladiatorum, causes skin lesions on the head, neck, and shoulders that are often misdiagnosed.
After learning of a possible outbreak in a Washington state high school, the CDC encouraged surrounding counties to report similar incidents. The researchers conducted interviews with student athletes and obtained laboratory cultures from skin lesions.
The data showed that 12 out of 250 wrestlers in four counties had active herpes gladiatorum, and 40 others had a rash illness. Nine of those with herpes had other symptoms including headache, fever, chills, sore throat, swollen glands, and painful eyes. Eleven of the wrestlers with confirmed cases saw a physician, but only two received viral cultures; most were misdiagnosed with impetigo or a staph infection. The chief investigator says the findings have implications for 700,000 wrestlers, a third of whom are high school students.
"Skin contact is the primary mode of HSV-1 transmission," says Mark Dworkin, MD, MPHTM, a medical epidemiologist with the CDC. "In wrestling, the head and neck are major points of contact, and over 90% of the lesions we observed erupted in this area." Dworkin tells WebMD that "herpes can reactivate over the lifespan in times of physical and emotional stress. Herpes can also result in serious systemic illness and vision loss years later, particularly if immunity is compromised." Sports medicine experts say wrestlers with active lesions should be temporarily excluded from participating in wrestling events.
"Even though it's common sense for an infectious athlete to sit out, sometimes there's pressure on high school kids to continue," says Guy Nicolette, MD, the varsity team physician and clinical assistant professor of family medicine at the University of Florida in Gainesville. "Some are afraid of losing a scholarship. Others are afraid of losing the respect of their coach. That's a lot to handle during adolescence."


text:
news & events
First Knee Replacement Shaped to Fit A Woman's Anatomy
Surgery Performed at Bon Secours St. Mary's Hospital
Richmond, Va. (July 26, 2006) When it comes to knee replacement, women can now receive the "perfect fit."
With Gender Solutions™ High-Flex Knee, the first knee replacement designed to fit a woman's anatomy, physicians are not forced to replace female knees with implants designed for men.
Bon Secours St. Mary's Hospital has been performing the procedure under the direction of Fred McGlynn, M.D., an orthopaedic surgeon with Tuckahoe Orthopaedic Associates.
"This is revolutionary in terms of knee replacement in women," said Dr. McGlynn, who has already performed about 20 of the procedures with the newly designed implant.
"We've known for decades that anytime a woman undergoes knee replacement, compromises will have to be made. That is no longer the case and exactly why this is so significant. It is definitely a major step forward in orthopaedic care."
Three basic design characteristics make the Gender Solutions™ knee work for women.
- Narrower shape, proportioned for women. When determining the proper sized implant for the knee, surgeons measure the femur from front to back and side to side. Women's knees are typically more trapezoid-shaped whereas men's knees are more rectangle-shaped. Prior to the High-Flex Knee, implants that fit women from back to front were too wide, posing a risk to surrounding ligaments and tendons.
- Thinner shape. The bone in front of a woman's knee is typically less prominent than in a man's knee. When a traditional implant is used to replace damaged bone, the joint may end up feeling "bulky," which could result in pain and less optimal function. The front of the High-Flex Knee is thinner in shape and matches the female anatomy.
- More natural tracking. The angle between the pelvis and the knee affects how the kneecap tracks over the end of the femur as the knee moves through the range of motion. Women tend to have a different angle than men because their shape and contour. The new knee was designed to accommodate the different tracking angle.
Additional benefits include a less invasive replacement procedure, less disruption of tissue surrounding the knee and because of a proper fit, it's more cosmetically appealing.
Dr. McGlynn, who does about 200 knee replacement procedures a year, says that 60 percent of replacement patients are women, ranging from age 50 and older.
"With the new implant, we expect the number of women opting to have knee replacement will increase," said Dr. McGlynn. "Given that the surgery is now less invasive and as a result, less disruptive, women may be more inclined to consider the surgery."
The Gender Solutions™ High-Flex knee, available for consumer use since last spring, was developed by Zimmer, a world-wide orthopaedic leader in the design, development, manufacturing and marketing of reconstructive implants, trauma, and related orthopaedic surgical products.
Dr. McGlynn will lead a seminar on the gender specific knee implants at 1 p.m. on Aug. 15 at St. Mary's Hospital Auditorium. The seminar is free and open to the public. Register by calling Bon Secours Senior Services at (804) 627-5010.
Bon Secours St. Mary's Hospital is one of four Richmond area hospitals in the not-for-profit Bon Secours Richmond Health System.


text:
The controversial mosque near ground zero has angered many Americans who view it as a direct assault on those who were murdered on September 11. many question the motivation of the Iman who said that our foreign policy was an accessary to 9/11, for building his mosque within close proximity to ground zero. This issue as been taken up by venues such as Fox News and has brought allegations of Islamophobia.
Congressman Ron Paul said that in his opinion oppostion "has come from the neo-conservatives who demand continual war in the Middle East and Central Asia and are compelled to constantly justify it." He said they never miss a chance to use hatred toward Muslims to rally support for the ill conceived preventative wars" and compared it to how"Nero fiddled while Rome burned."
many of the indiviuals who vehemently oppose the mosque have also defended open borders and illegal immigration. Bill Kirstol of the Neoconservative Weekly Standard who launched an add with Liz Cheney opposing the mosque defended illegal immigration stating that he is "a liberal on immigration.... What damage have they done that's so great in 20 years since the 1986 amnesty]?... What's happened that's so terrible in the last 20 years? Is the crime rate up in the United States in the last 20 years? Is unemployment up in the United States in the last 20 years? And they've been contributing to the U.S. economy and not damaging U.S. society. There have been marches with Mexican flags, which conservative talk radio is up in arms about. I mean, are these people serious? Are these people—what, are they going to be traitors to the U.S.? I am pro-immigration, and I am even soft on illegal immigration."
While the opponants of the mosque make legitimate points the about the motivations of the Iman they fail to see the big picture in our conflict with radical Islam. Islamic extremism is a legitimate threat to the west but we are fueling it by our foreign policy and enabling it further through multi-culturalism and a liberal immigration policy. Islamic extremist has become a huge problem in Europe because of demographic changed caused by massive immigration. The Neoconservative movement seeks to capitalize on Islamophobia to gain support for wars in the middle east but fails to adress the roots causes of the conflcit.
The Iman is an outspoken critic of US foreign policy and has said that the United States has more muslim blood on its hands than Al Queda. 9/11 hyjacker Khalid Sheikh Mohammed has stated that his hatred against the United States was primarily motivated by our unconditional support for Israel as well as our backing of undemocratic Arab regimes in the middle east.
At the 12th 9/11 commision hearing on June 16, 2004 in Washington DC Vice Chair of the Commision Lee Hamilton asked "I'm interested in the question of motivation of these hijackers, and my question is really directed to the agents. ... what have you found out about why these men did what they did? What motivated them to do it?" FBI Special Agent Fitzgerald stated "I believe they feel a sense of outrage against the United States. They identify with the Palestinian problem, they identify with people who oppose repressive regimes and I believe they tend to focus their anger on the United States." This testimony was kept out of the 9/11 Comision Report.
At a latter Comition on foreing policy a member of the audience asked Hamilton I had a quick question for you sir. I had spoken with you on C-SPAN about a month ago ..." Immediately Hamilton interrupts him, "I think we'd uh ..." The questioner persisted, "why aren't we addressing the gorilla in the room? The gorilla in the room is US support for Israel." Hamilton didn't respond and dissmissed the quesation stating "Alright sir. Alright, this is a conversation you and I ought to have. Let's not take up the time of our resource people. May we go to the next question please?"
Hamilton latter co-authored a book titled "Without Precedent: The Inside Story of the 9/11 Commission" where he admited some commissioners "listed U.S. support of Israel as a root cause of al Qaeda's opposition to the United States indicated that the United States should reassess that policy."
While I agree with the Iman that our foreign policy is the main motivation for terrorism and hatred agaisnt the United States in the muslim world he speaks from a foreign perspective rather than someone who is looking out for the best interest of the nation and has recieved funding from foreign governments so it is understandable that many Americans are unhappy about the mosque and question the motives of the Iman
Outlets like Fox News and Neoconservative pundits which are outspoken agaisnt the mosque were complacent in stiring up support for the war in the Iraq and are now promoting war with Iran. they are using the controverst to stir up anti-muslim sentiment to gain support for further millitary involvment in the middle east. If they have a problem with growing Islamic influence in the west do something about immigration but don't use it as an excuse for more unessesary wars.


text:
Assume weather is not an issue because weather varies so much by region.
What is the best time of year to have a baby?
Assume weather is not an issue because weather varies so much by region.
Shannon mom to the A team.
Ashlyn (7/05)� Allison (8/07)� Annalise (8/10)
I would think spring, but I only have one and she's a winter baby. I would say Nov.-Dec. is definitely not optimal.
I'd say anything in the first half of the year- it makes it easier for school. No "do I let them start kindergarten or hold them back a year" debate.
The only problem with Jan-Mar (I'm due in Feb) is I've already met my deductible this year and I'll have to pay it again when the baby is born.
Barrett - Aug12
Tucker - Jan15
Baby Boy #3 due 8/29/16!
My kids are Sept, Dec, 2 feb, and 1 May. And May was the best time!
Mom to:Amber (98) Connor (00) Abigail (04) Logan (08) Ava (10)
Me (30 w/PCOS) & DH (36 w/1% morph)
After 3 iuis and 2 rounds of Ivf, our miracle is here!
Baby Boy arrived January 20, 2014!
Gave us all of June to take older kids to zoo, beach, movies etc. Summery stuff. Then we had a few weeks to adjust with new LO before school started back. Super nice not having to get up and make lunches and take older kids to school right away.
Jared + Aubree= Aviree Skye <3 March 28 2012 & Judah Eli May 21 2014


text:
Yucky charcoal
I had no idea charcoal could get moldy until a couple of weeks ago when I found these mold-covered charcoal pieces in this container that we had been keeping in the backyard. Apparently, rainwater had leaked into the container creating an environment ideal for mold growth. In retrospect, it makes sense that mold could grow on charcoal, which is incompletely burned wood or some other substance rich in organic matter.
We had invited a friend over for barbequed chicken this evening. But these moldy charcoal pieces, which were also damp and crumbly, would not heat up. So, we resorted to sausages grilled on an electric grill. At least the wine was good.