[mv] SQL query error

["Andy T. Tripp" <airtripp@fusionmicro.com>]

******    message to minivend-users from "Andy T. Tripp" <airtripp@fusionmicro.com>     ******

Does anybody know how to make this work?

[sql type=list
      query="select * from FUSION$Item where No.='VI-PS-DV500'"]

I can't get the where statement to work because the company I am working for
has the "code" column called "No.".  Unfortunatley I can not change this.
If I one of the few columns with a standard name like Description, it works
fine.  Does anyone know any characters I can put around the No. in order to
get it recognized by minivend.  I can run a select statement outside of
Minivend and use double quotes and it works fine, but in Minivend I get an
internal server error with character I have tried.  Any ideas or suggestions
would be greatly appreciated.  Thank you!

Andy Tripp

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list