sql_language thread: I donno how to use 'WHERE CONTAINS'...
Replace the CONTAINS word with "LIKE" and place * around the keyword as well - so
your WHERE looks like this:
SQL = "SELECT * FROM fusk WHERE spelnamn LIKE = '*" & strKeyword & "*'
ORDER BY spelnamn ASC"
--- SD-Studios <info@s...> wrote:
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0007_01C0BBB9.0E2036F0
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: 7bit
>
> I try using this sting...but i get an error message. Its the first time I
> use it and i dont know where to put everything..=)
>
> SQL = "SELECT * FROM fusk WHERE spelnamn CONTAINS = '" & strKeyword & "'
> ORDER BY spelnamn ASC"
>
> Can someone please help me out?
> --
> Martin Johansson,
> CEO & Project Supervisor
> Sola Data
> http://www.sd-studios.com
> http://www.sd-gaming.com
>
>
> ------=_NextPart_000_0007_01C0BBB9.0E2036F0
> Content-Type: text/html;
> charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD><TITLE></TITLE>
> <META content=3D"text/html; charset=3Dus-ascii"
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR></HEAD>
> <BODY>
> <P><FONT size=3D2><FONT face=3DVerdana><FONT face=3DArial>I try using
> this sting...but
> i get an error message. Its the first time I use it and i dont know
> where to put
> everything..=3D)<BR><BR>SQL =3D "SELECT * FROM fusk <FONT
> color=3D#ff0000>WHERE
> spelnamn CONTAINS</FONT> =3D '" & strKeyword & "' ORDER BY
> spelnamn
> ASC"</FONT></FONT></FONT></P>
> <P><FONT size=3D2><FONT face=3DVerdana><FONT face=3DArial>Can someone
> please
> help me out?</FONT><BR>--<BR>Martin Johansson,<BR>CEO & Project
>
> Supervisor<BR>Sola Data<BR></FONT><A href=3D"http://www.sd-studios.com"
> target=3D_blank><FONT
> face=3DVerdana>http://www.sd-studios.com</FONT></A><BR><A
> href=3D"http://www.sd-gaming.com" target=3D_blank><FONT
> face=3DVerdana>http://www.sd-gaming.com</FONT></A></FONT><FONT
> face=3DVerdana>
> </FONT></P>
> ---<BR>
> You are currently subscribed to sql_language as: mailjohnny101@y...<BR>
> To unsubscribe send a blank email to $subst('Email.Unsub')<BR>
>
> </BODY></HTML>
>
> ------=_NextPart_000_0007_01C0BBB9.0E2036F0--
>
>
=====
----------------------------
John Pirkey
MCSD
John@S...
http://www.stlvbug.org
View Cart
