|
 |
asp_web_howto thread: SQL script to return all records
Message #1 by =?iso-8859-1?q?Fl=E1vio=20de=20Souza?= <flaviostz@y...> on Thu, 2 May 2002 13:05:21 -0300 (ART)
|
|
Generally I use:
Select * FROM tbs_X
Or Maybe you need to use:
LIKE ´%*%´
Cheers
Flavio
---------------------------------------------
Subject: SQL script to return all records
From: Joseph Coppola <joco@e...>
Date: Thu, 25 Apr 2002 23:06:02 -0400
X-Message-Number: 2
Help! I am using a form to perform a db search, but I
want to return
all records, so I am using a LIKE statement. Well the
query runs
correctly in Access but doesn't from an ASP page (no
records are
returned)... SO whats the problem with my statement?
TIA,
Joe
=====
Flavio de Souza
flaviostz@y...
Sertãozinho - SP - Brasil
Yahoo! ID: flaviostz
_______________________________________________________________________
Yahoo! Encontros
O lugar certo para você encontrar aquela pessoa que falta na sua vida. Cadastre-se hoje mesmo!
http://br.encontros.yahoo.com/
Message #2 by "Drew, Ron" <RDrew@B...> on Thu, 2 May 2002 12:27:51 -0400
|
|
LIKE statement
Select abc from tablename where abc
LIKE 'DOE%' abc starts with DOE
LIKE '%DOE%' abc has DOE somewhere in it
LIKE '%DOE' abc ends with DOE
-----Original Message-----
From: Fl=E1vio de Souza [mailto:flaviostz@y...]
Sent: Thursday, May 02, 2002 12:05 PM
To: ASP Web HowTo
Subject: [asp_web_howto] SQL script to return all records
Generally I use:
Select * FROM tbs_X
Or Maybe you need to use:
LIKE =B4%*%=B4
Cheers
Flavio
---------------------------------------------
Subject: SQL script to return all records
From: Joseph Coppola <joco@e...>
Date: Thu, 25 Apr 2002 23:06:02 -0400
X-Message-Number: 2
Help! I am using a form to perform a db search, but I
want to return
all records, so I am using a LIKE statement. Well the
query runs
correctly in Access but doesn't from an ASP page (no
records are
returned)... SO whats the problem with my statement?
TIA,
Joe
=3D=3D=3D=3D=3D
Flavio de Souza
flaviostz@y...
Sert=E3ozinho - SP - Brasil
Yahoo! ID: flaviostz
_______________________________________________________________________
Yahoo! Encontros
O lugar certo para voc=EA encontrar aquela pessoa que falta na sua vida.
Cadastre-se hoje mesmo! http://br.encontros.yahoo.com/
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20
Message #3 by "Gavin Landon" <glandon@g...> on Thu, 2 May 2002 17:44:32 -0500
|
|
In SQL
sql = "Select abc from tablename where abc LIKE '%DOE%'"
will work for all of them.. No need for anything else.
In Access I have seen where LIKE statement doesn't always work correctly.
Depending on version I guess.
"Drew, Ron" <RDrew@B...> wrote in message news:171138@a..._web_howto...
LIKE statement
Select abc from tablename where abc
LIKE 'DOE%' abc starts with DOE
LIKE '%DOE%' abc has DOE somewhere in it
LIKE '%DOE' abc ends with DOE
-----Original Message-----
From: Flávio de Souza [mailto:flaviostz@y...]
Sent: Thursday, May 02, 2002 12:05 PM
To: ASP Web HowTo
Subject: [asp_web_howto] SQL script to return all records
Generally I use:
Select * FROM tbs_X
Or Maybe you need to use:
LIKE ´%*%´
Cheers
Flavio
---------------------------------------------
Subject: SQL script to return all records
From: Joseph Coppola <joco@e...>
Date: Thu, 25 Apr 2002 23:06:02 -0400
X-Message-Number: 2
Help! I am using a form to perform a db search, but I
want to return
all records, so I am using a LIKE statement. Well the
query runs
correctly in Access but doesn't from an ASP page (no
records are
returned)... SO whats the problem with my statement?
TIA,
Joe
=====
Flavio de Souza
flaviostz@y...
Sertãozinho - SP - Brasil
Yahoo! ID: flaviostz
_______________________________________________________________________
Yahoo! Encontros
O lugar certo para você encontrar aquela pessoa que falta na sua vida.
Cadastre-se hoje mesmo! http://br.encontros.yahoo.com/
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
|
|
|
View Cart
