Re: [mv] SQL query error

[Hans-Joachim Leidinger <hans-joachim.leidinger@home.gelsen-net.de>]

******    message to minivend-users from Hans-Joachim Leidinger <hans-joachim.leidinger@home.gelsen-net.de>     ******

"Andy T. Tripp" wrote:
> 
> ******    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

What is your error.log of Minivend saying?
What did your logfile of your SQL Server saying?
Maybe this 

       query="select * from FUSION$Item where No\.='VI-PS-DV500'"]

can helps you?

Joachim

-- 
-------------Hans-Joachim Leidinger---------------------

-
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