what does the sql look like?
Optimizer hints are used by sqlserver if you are trying to force a query to
use a particular index instead of allowing the optimizer to pick the ones it
likes best.
Mathew Raftree
Senior Consultant
Breakaway Solutions, Inc.
50 Rowes Wharf, Boston, MA 02110
617.960.3400 - Office
617.834.0647 - Cell
617.960.3434 - Fax
www.breakaway.com
Get there first.
I will find a way...if there is no way, I will make one - Hannibal
-----Original Message-----
From: Jim Taylor [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 12, 2000 2:24 PM
To: Cf-Talk@Houseoffusion. Com
Subject: never seen this error before
Weird to me
I have never seen this error before has any of you guys?
Microsoft][ODBC SQL Server Driver][SQL Server]'FirstName' is not a
recognized OPTIMIZER LOCK HINTS option.
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:52).
Jim Taylor Web Development
Web Sites of the Future Today
480-496-0712
http://24.1.254.231
ICQ 47640391
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
