Forum Post: RE: Using SQL LIKE with D2C

  • Thread starter Thread starter Jeff Leinbach
  • Start date Start date
Status
Not open for further replies.
J

Jeff Leinbach

Guest
It's more than just database dependent. Each database has different data types and the capabilities of the different data types may vary. If you look at the DatabaseMetadata.getTypeInfo(), this result set contains a column called searchable that returns the following values: SEARCHABLE short = can you use "WHERE" based on this type: typePredNone - No support typePredChar - Only supported with WHERE .. LIKE typePredBasic - Supported except for WHERE .. LIKE typeSearchable - Supported for all WHERE .. You will have to cross reference the information returned from getTypeInfo with the information returned from ResultSetMetadata or DatabaseMetadata.getColumns to determine what the usage for that particular column is in a WHERE clause.

Continue reading...
 
Status
Not open for further replies.
Back
Top