Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

filtering database with text values

Status
Not open for further replies.

bigbird3156

Programmer
Feb 20, 2001
183
AU
Hi... I have been able to work out how to filter a recordset when you are passing an integer to it from another page (url parameter) ... what really confuses me is how to do it with a text field... I've looked around a bit and cant really find anything... but then I am probably searching in the wrong direction...

can someone give me some pointers or tell me where to go for a good explination or tutorial...

thanks

[wiggle]The Bird from Down Under- Bigbird 3156
Programmer?? - I thought the option was pretender not programmer!![jester]
 
there is no difference

Dbase_field = '12345'
or
Dbase_field = 'abcd'

doesnt really require anything different, I mean each is searching to see if said field is equal to said string. Make sure your dbase fields are the right types but other than that I dont really know what you are asking.

Darryn Cooke
| The New Orange County Graphic designer and Marketing and Advertising Consultant
| Marketing and Advertising blog
 
Darryn is right, but perhaps to emphasise his point about field types the example should have been

Dbase_field = 12345 << without the quotes
or
Dbase_field = 'abcd'



Steve
- I have fun with telemarketers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top