can't have "like ="
use like for strings and = for numeric comparisons (i.e. like "rabbit" or
= 2333
can't have =Size in your select statement. I'm not sure what you're trying
to do with that part.
-----Original Message-----
From: MichaelFox [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 23, 2000 3:24 PM
To: CFTALK
Subject: SQL Problem
This is a multi-part message in MIME format.
------=_NextPart_000_001B_01BFC4CA.F0E5E7A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
This isn't really cold fusion related, but its close enough.
I am coding a text search engine in ASP using MS Index Server.
This SQL statement:
SELECT FileName, DocTitle, DocSubject, DocCreatedTM, DocAuthor, vPath, =
Size, Characterization FROM SCOPE() WHERE Characterization LIKE =
('""strText""') AND Path NOT LIKE '%vti%' ORDER BY FileName DESC"
Gives me this error:
Microsoft OLE DB Provider for Microsoft Index Server error '80040e14'=20
Incorrect syntax near (. Expected _STRING. SQLSTATE=3D42000=20
/support/search_new2.asp, line 88=20
Anyone got any ideas what to do?
Thanks,
-Mike
------=_NextPart_000_001B_01BFC4CA.F0E5E7A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2722.2800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>This isn't really cold fusion related, =
but its=20
close enough.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I am coding a text search engine in ASP =
using MS=20
Index Server.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>This SQL statement:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>SELECT FileName, DocTitle, DocSubject,=20
DocCreatedTM, DocAuthor, vPath, Size, Characterization FROM SCOPE() =
WHERE=20
Characterization LIKE (‘""strText""') AND Path NOT LIKE =
'%vti%' ORDER BY=20
FileName DESC"</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Gives me this error:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>
<P>Microsoft OLE DB Provider for Microsoft Index Server <FONT =
face=3DArial=20
size=3D2>error '80040e14'</FONT>=20
<P><FONT face=3DArial size=3D2>Incorrect syntax near (. Expected =
_STRING.=20
SQLSTATE=3D42000</FONT>=20
<P><FONT face=3DArial size=3D2>/support/search_new2.asp</FONT><FONT =
face=3DArial=20
size=3D2>, line 88</FONT> </P>
<P> </P>
<P>Anyone got any ideas what to do?</P>
<P> </P>
<P>Thanks,</P>
<P>-Mike</P></FONT></DIV></BODY></HTML>
------=_NextPart_000_001B_01BFC4CA.F0E5E7A0--
----------------------------------------------------------------------------
--
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.