RE: [mv] SQL query error

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

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

fusion /cgi-bin/fusion/test Hammered session lock LOCK_ZFkW87zD
fusion /cgi-bin/fusion/test Runtime error: [OpenLink][ODBC][SQL Server]Line
1: Incorrect syntax near '\'. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1)

Above is the error.log of Minivend.  I tried your suggestion and no luck
there either, but thanks for the idea.

I can display the "No." column later in my page by using [sql-param 1].  Is
there anyway to incorporate this into my where statement?  Thanks again for
any ideas!

Andy Tripp
-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Hans-Joachim
Leidinger
Sent: Thursday, November 30, 2000 3:28 PM
To: minivend-users@minivend.com
Subject: Re: [mv] SQL query error


******    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

-
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