HighDots Forums  

search between two table fields

Macromedia Dreamweaver Macromedia Dreamweaver Discussions (macromedia.dreamweaver)


Discuss search between two table fields in the Macromedia Dreamweaver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Esther Lutz
 
Posts: n/a

Default search between two table fields - 08-17-2004 , 11:30 PM






I like the visitor to search for events for his age.
I have a text field where he enter his age. In the table I have a MinAge
field and a MaxAge field. I can filter the record with:
WHERE EMinAge <= varAge AND MaxAge >= varAge

This function, but how do I get all the records listed while there is no
etry in the search text field? Right now I get zero records back when this
field is empty.
I think it is something with the Default Value but I can't use the % sign.

Many thanks for your help

Esther



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.