Search question

[Ruslan Zasukhin]

on 2/11/04 7:27 PM, Gregory Kowalski at gregkowalski at earthlink.net wrote:

Hi Gregory,

> When  I make a search with the following expression:
> 
> whichSearch = "select * from Table where catalognumber = "&keyword&"
> order by catalog"

Important mistake, -- you have forget single quotes around string

 "select * from Table where catalognumber = '"&keyword& "' order by catalog"

> The catalog numbers are in a string field.
> 
> 
> 0014-01 gives me a result but 0014-01X does not. Neither does A0759-05.
> It seems that whenever I the catalog number contains a letter it
> cannot be found.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------