access_asp thread: Reducing SQL command
Message #1 by "Daniel Groh" <daniel.groh@s...> on Thu, 5 Sep 2002 09:30:21 -0300
|
|
I've been using this follow command:
------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------
sql = "SELECT * FROM SQ_AvProd WHERE nota_fiscal = '"&cod_keyA&"' or fornecedor = '"&cod_KeyB&"' or laudo =
'"&cod_keyC&"' or (data_analise between '"&cod_KeyD&"' and '"&cod_KeyE&"')"
------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------
I need to uce this command because I'll still usem re OR
Hugs
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 6 Sep 2002 10:17:10 +1000
|
|
What are you talking about?!?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Daniel Groh" <daniel.groh@s...>
Subject: [access_asp] Reducing SQL command
: I've been using this follow command:
:
: --------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
------------------
: sql = "SELECT * FROM SQ_AvProd WHERE nota_fiscal = '"&cod_keyA&"' or
fornecedor = '"&cod_KeyB&"' or laudo = '"&cod_keyC&"' or (data_analise
between '"&cod_KeyD&"' and '"&cod_KeyE&"')"
: --------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
------------------
:
: I need to uce this command because I'll still usem re OR
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
View Cart
