Find PhotosCollectionsInformationIPY 2007Mission-Roll-Frame SearchTechnical SearchClickable Map SearchUncataloged ESC Nadir Data SearchAbout the PhotosOrder PhotosConditions for Use of ImagesFrequently Asked QuestionsImage QuizEarth ObservatoryMission Highlights CollectionEarth From Space CollectionCities CollectionIPY ImagesWeekly Top 10 ImagesEarths Systems from SpaceHow to Find Mt. Everest from SpaceCanyons, Craters & Drifting DunesScreensaversAbout UsFactsheetContact UsSubscribeVerify SubscriptionPassword RemindUnsubscribeWebsite AwardsUser CommentsServer StatisticsImage Transformation TutorialColor Enhancement TechniquesTime to Position CalculatorPosition to Time CalculatorSaving, Adjusting & PrintingSpace Station WindowISS Orbit TutorialCameras UsedReal-Time Orbital PositionsRelated Earth Science SitesRelated NASA SitesRelated NOAA SitesRelated Other Government SitesPublication ListSubmit a PublicationNews ArchiveDatabase ContentDatabase FieldsDatabase Change LogSubmit an Image RequestIPY Site

Home >>	Advanced Search >>

Database Usage Hints

Selecting multiple items:

Some of the list boxes allow you to select more than one item in the list. The table below explains how:

Platform	To select multiple non-contigous items	To select multiple contiguous items
PC/Windows	CTRL-click each item to toggle its selection status.	Click the first item in the range. Then Shift-click the last item in the range. Or drag across the items to be selected.
Macintosh	Command-click each item to toggle its selection status.	Click the first item in the range. Then Shift-click the last item in the range.

Custom Queries:

You can do custom queries by selecting the output option "Show or edit the SQL statement" and then clicking the "Edit SQL" button. This allows you to write your own SQL SELECT statements. Detailed information about the database tables is included along with SQL syntax information, notes, and examples.

One nice feature of this option is that it allows you to query database tables independant of the FRAMES table that is used by the main form. For example, the statement

SELECT * FROM captions WHERE caption CONTAINING 'Houston'

will list the text of all the captions from the CAPTIONS table that contain the string "Houston" (case insensitive) along with their photo IDs.

See the list of database fields for SQL syntax and database structure information needed to compose custom queries.

Problem accessing digital images:

If you are prompted for a password when trying to access an image file from the database, this is because the file permissions on the file are not correct. None of the images linked from pages on this web site are suppose to be password protected. Please email the curator and report the filename of the image that could not be read so that it can be fixed. Thank you.

Specifying strings to search for:

Here's the meaning of the logic options when specifying search strings:

AND Only records that contain all the words you specify will be returned. The order of the words does not matter.

OR Any records that contain any of the words you specify will be returned. The order of the words does not matter.

LITERAL Only records that contain all the words you specify in the same order that you specify them and with no other words or characters inbetween will be returned.

Server: 2

This service is provided by the International Space Station program.