Some years back I had code in one of my apps to do a specific search.
Seemed no-one was using it, so I deleted it. Now they want it back, and I
can't figure out how I did it in the first place. Seems like a simple
problem.
Need to find a product in the database where more than one color number
matches a product. Each color may exist in many products, but I want to see
the product(s) that have both colors.
ie:
Edit all from colorlist where colornum contains '123' and colornum contains
'456'
Anything I try gives me a syntax error, or a no rows exist error.
I know the rows are there, so its a syntax issue.
Suggestions appreciated.
Dick Fey
Carpet Broker Inc.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
