An error occurred processing your request

Merging data into macro form: c:\inetpub\wwwroot\gmvehiclewholesale\searchmodel.html

Variable error in: {case RMake}

**Variable 'RMake' does not exist. Remember, variable names, database field names and operators are CASE SENSITIVE. (EwGf01.103@Windows NT 5.2)**

In file: c:\inetpub\wwwroot\gmvehiclewholesale\searchmodel.html


;; following starts near line number 107 in your source form...
...


{if 1 sqlStart <}
  {set sqlStart 1}
{/if}

{sql to results source 'dbno1'}
 {case RMake}
      {match 'Toyota'}
  SELECT mdName, (SELECT Count(*) FROM Stock WHERE stStatus<>2 AND stImageProcess=true AND stModel = Model.mdName) AS MyCount FROM Model WHERE WebDisplay=True AND mdMakeName='Toyota' ORDER BY mdName
      {match 'Nissan'}
  SELECT mdName, (SELECT Count(*) FROM Stock WHERE stStatus<>2 AND stImageProcess=true AND stModel = Model.mdName) AS MyCount FROM Model WHERE WebDisplay=True AND mdMakeName='Nissan' ORDER by mdName
...
  SELECT mdName, (SELECT Count(*) FROM Stock WHERE stStatus<>2 AND stImageProcess=true AND stModel = Model.mdName) AS MyCount FROM Model WHERE WebDisplay=True AND mdMakeName='Suzuki' ORDER by mdName

 {otherwise}
  SELECT mdName, (SELECT Count(*) FROM Stock WHERE stStatus<>2 AND stImageProcess=true AND stModel = Model.mdName) AS MyCount FROM Model ORDER by mdName DESC
 {/case}
{/sql}



</head>

<body>
...

expression arguments(1):
 RMake