首页 \ 问答 \ 返回部分匹配值的记录(Returning records that partially match a value)

返回部分匹配值的记录(Returning records that partially match a value)

 我正在尝试获取一个查询工作，它从表单控件获取值（有时只是字符串的第一部分）。 我遇到的问题是它只在输入完整字符串时才会返回记录。  
 即在姓氏框中，我应该能够输入gr，然后它就会显示出来  
 绿灰色的格雷厄姆  
 但是目前它并没有提供任何无用的完整搜索字符串。  
 有问题的表单上有4个搜索控件，只有在填写框时才会在查询中使用它们。  
 该查询是：  
SELECT TabCustomers.*,
       TabCustomers.CustomerForname AS NameSearch,
       TabCustomers.CustomerSurname AS SurnameSearch,
       TabCustomers.CustomerDOB AS DOBSearch,
       TabCustomers.CustomerID AS MemberSearch
FROM TabCustomers
WHERE IIf([Forms]![FrmSearchCustomer]![SearchMember] Is Null
          ,True
          ,[Forms]![FrmSearchCustomer]![SearchMember]=[customerid])=True
      AND IIf([Forms]![FrmSearchCustomer].[SearchFore] Is Null
              ,True
              ,[Forms]![FrmSearchCustomer]![SearchFore] Like [customerforname] & "*")=True
      AND IIf([Forms]![FrmSearchCustomer]![SearchLast] Is Null
              ,True
              ,[Forms]![FrmSearchCustomer]![SearchLast] Like [customersurname] & "*")=True
      AND IIf([Forms]![FrmSearchCustomer]![Searchdate] Is Null
              ,True
              ,[Forms]![FrmSearchCustomer]![Searchdate] Like [customerDOB] & "*")=True;

I'm trying to get a query working that takes the values (sometimes just the first part of a string) from a form control. The problem I have is that it only returns records when the full string is typed in. 
i.e. in the surname box, I should be able to type gr, and it brings up  
green grey graham 
but at present it's not bringing up anything uless the full search string is used. 
There are 4 search controls on the form in question, and they are only used in the query if the box is filled in. 
The query is : 
SELECT TabCustomers.*,
       TabCustomers.CustomerForname AS NameSearch,
       TabCustomers.CustomerSurname AS SurnameSearch,
       TabCustomers.CustomerDOB AS DOBSearch,
       TabCustomers.CustomerID AS MemberSearch
FROM TabCustomers
WHERE IIf([Forms]![FrmSearchCustomer]![SearchMember] Is Null
          ,True
          ,[Forms]![FrmSearchCustomer]![SearchMember]=[customerid])=True
      AND IIf([Forms]![FrmSearchCustomer].[SearchFore] Is Null
              ,True
              ,[Forms]![FrmSearchCustomer]![SearchFore] Like [customerforname] & "*")=True
      AND IIf([Forms]![FrmSearchCustomer]![SearchLast] Is Null
              ,True
              ,[Forms]![FrmSearchCustomer]![SearchLast] Like [customersurname] & "*")=True
      AND IIf([Forms]![FrmSearchCustomer]![Searchdate] Is Null
              ,True
              ,[Forms]![FrmSearchCustomer]![Searchdate] Like [customerDOB] & "*")=True;

原文：https://stackoverflow.com/questions/223627

更新时间：2023-06-25 11:06

最满意答案

 你无法使用这样的对象，你必须做这样的事情;  
 var width = height = 280; // store values
 var option = jQuery.extend({
        parent: this,
        width:  width,
        height: height

        circle: {
            x:          (width / 2) + 5,   // option doesn't exist
            y:          (height / 2) + 22, // option doesn't exist
            radius:     70,
            speed:      5,
            rotation:   0,
            angleStart: 270,
            angleEnd:   90,
            hue:        220,
            thickness:  15,
            blur:       20
        }
    }, options);
 // option is now created and exists here
 
 你可以这样做  
var tempOption = {
    parent: this,
    width:  280,
    height: 280
};


tempOption.circle = {
    x:          (tempOption.width / 2) + 5,   // option doesn't exist
    y:          (tempOption.height / 2) + 22, // option doesn't exist
    speed:      5,
    rotation:   0,
    angleStart: 270,
    angleEnd:   90,
    hue:        220,
    thickness:  15,
    blur:       20
};


var option = jQuery.extend(tempOption, options);

You cannot work with object like that, you'll have to do something like this; 
 var width = height = 280; // store values
 var option = jQuery.extend({
        parent: this,
        width:  width,
        height: height

        circle: {
            x:          (width / 2) + 5,   // option doesn't exist
            y:          (height / 2) + 22, // option doesn't exist
            radius:     70,
            speed:      5,
            rotation:   0,
            angleStart: 270,
            angleEnd:   90,
            hue:        220,
            thickness:  15,
            blur:       20
        }
    }, options);
 // option is now created and exists here
 
You could do something like this  
var tempOption = {
    parent: this,
    width:  280,
    height: 280
};


tempOption.circle = {
    x:          (tempOption.width / 2) + 5,   // option doesn't exist
    y:          (tempOption.height / 2) + 22, // option doesn't exist
    speed:      5,
    rotation:   0,
    angleStart: 270,
    angleEnd:   90,
    hue:        220,
    thickness:  15,
    blur:       20
};


var option = jQuery.extend(tempOption, options);

返回部分匹配值的记录(Returning records that partially match a value)

最满意答案

相关问答

在python中读取JSON文件(How to read this JSON file?)[2023-12-17]

从JSON文件中读取数据？(Read data from JSON file?)[2022-04-20]

如何从PHP读取JSON结果(How to read JSON results from PHP)[2022-11-17]

Label Text proprety不会改变(Label Text proprety would not change)[2023-11-22]

使用json lib从文本文件中读取多个json对象(read multiple json objects from a text file using json lib)[2023-11-14]

无法读取所有JSON对象(Cannot read all JSON object)[2022-05-02]

无法在JSON中读取父级的属性(Cannot read parent's proprety in JSON)[2022-03-18]

在UWP中使用Pivot的SelectedIndex属性(Using the SelectedIndex proprety of Pivot in UWP)[2024-01-26]

如何从json读取属性(how to read attribute from json)[2023-11-24]

在Python中读取格式错误的JSON(Read malformed JSON in Python)[2023-01-14]

相关文章

最新问答