vPath, =size ?????
what are you trying to do here???????
>From Scope() ?? what is that???
Please specify a straight forward query!!!
SELECT FileName, DocTitle, DocSubject, DocCreatedTM, DocAuthor, vPath, =
Size, Characterization FROM SCOPE() WHERE Characterization LIKE =
('""strText""') AND Path NOT LIKE '%vti%' ORDER BY FileName DESC"
----- Original Message -----
From: "MichaelFox" <[EMAIL PROTECTED]>
To: "CFTALK" <[EMAIL PROTECTED]>
Sent: Tuesday, May 23, 2000 6:24 PM
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.
