Login
Latest postings for ASP/ VbScript.
Daily Code Email
|
|
| | |
| | |
Terms of Agreement:
By using this article, you agree to the following terms...
1) You may use
this article in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this article (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this article from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the article or article's description.
| dim codigo,cenario,transacao,nome
dim sql1,valor1,valor2,valor3,valor4, final
codigo=request.form("codigo")
modulo=request.form("modulo")
transacao=request.form("transacao")
nome=request.form("nome")
sql1="Select * from BPP"
if codigo<>"" or modulo<>"" or transacao<>"" or nome<>"" then
if codigo<>"" then
valor1="and codigo like '%"& codigo &"%' "
end if
if modulo<>"" then
valor2="and modulo like '%"& modulo &"%' "
end if
if transacao<>"" then
valor3="and transacao like '%"& transacao &"%' "
end if
if nome<>"" then
valor4="and nome like '%"& nome &"%' "
end if
final= valor1 & valor2 & valor3 & valor4
tamanho=len(final)
tamanho=tamanho-4
final=right(final,tamanho)
sql1=sql1 & " where " & final & " order by codigo"
else
sql1=sql1+ " where codigo='000ooo'"
end if
set rs=db.execute(sql1)
| | |
|
Other 1 submission(s) by this author
| | | |
Report Bad Submission | | | | | Your Vote! | |
See Voting Log | | | | Other User Comments | 
7/5/2002 9:07:12 AM: Howard Edidin
Your better off using, if len(modulo) <>0 then, since asp.dll uses len for validation.
(If this comment was disrespectful, please report it.)
| | |
Add Your Feedback! | Note:Not only will your feedback be posted, but an email will be sent to the code's author from the email account you registered on the site, so you can correspond directly.
NOTICE: The author of this article has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular article, please click here.
|
To post feedback, first please login.
| |
|
By 2 Users