p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: R: RE: Search feature that matches anywhere in a field


Message #1 by "Giovanni Salucci" <g.salucci@n...> on Wed, 19 Dec 2001 08:22:09 +0100

try with this,



"where jeprodno.deptno = '" & session("strdeptno") & "' AND " & session

("product") & " LIKE '%jeprodno.prodno%' " & _





in which i assume you have two fields named

jeprodno.deptno and session ("product").



But i think that the query you need is





"where jeprodno.deptno = '" & session("strdeptno") & "' AND jeprodno.deptno

LIKE '%" & session

("product") & %'"



bye







-----Messaggio originale-----

Da: jamesbkim@h... [mailto:jamesbkim@h...]

Inviato: mercoledý 19 dicembre 2001 0.42

A: ASP Databases

Oggetto: [asp_databases] RE: Search feature that matches anywhere in a

field





Hi Owen,



I used that method but it returned no record matches.

Here is the code that I used.



"where jeprodno.deptno = '" & session("strdeptno") & "' AND '" & session

("product") & "' LIKE '%jeprodno.prodno%' " & _



What's wrong with my coding?



James






$subst('Email.Unsub').






  Return to Index