thanx Mark >> because the ODBC connection will use the JET OLE-DB Provider
that's the MS OLE-DB driver, yes? but hang on... % and _ are ANSI SQL-92 and -99 standards, yes? from http://archive.devx.com/upload/free/features/tgvp/1999/fa99/rjfa99/rjfa99.as p "Jet SQL-formerly called Access SQL-isn't famous for ANSI SQL-92 compliance. For example, Jet SQL departs from the ANSI standards by using # instead of ' as a date delimiter, substituting * and ? wildcards for ANSI % and _, respectively, and commits other minor syntax heresies." so CFQUERY uses OLE-DB and is ANSI SQL compliant for % and _ wildcards no matter whether it's JET or SQLServer and CFSTOREDPROC uses ODBC drivers and uses whatever the database uses (* for JET and % for SQLServer) is this right? BTW: I thought they were all JDBC drivers? any thoughts? cheers barry.b -----Original Message----- From: Mark Woods [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 June 2003 5:59 PM To: CFAussie Mailing List Subject: [cfaussie] Re: wildcards in SPROCS >I'm confused with wildcards in why I'm getting results in SP's with * and >not % when it's the other way around in CFQUERY - esp dealing with JET >databases * is the wildcard operator for the Jet database engine You can use % in CFQUERY if you are using an ODBC connection to the database because the ODBC connection will use the Jet OLE-DB Provider, which allows % to be used in place of * Mark --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
