Please Help: How to use minivend variable like [item-code] in a SQL search string?

["Tim Murphy" <goombah@netcom.ca>]

******    message to minivend-users from "Tim Murphy" <goombah@netcom.ca>     ******

Hi,

I've been stumped by this since Day 1. Is there any way to get a Minivend
variable to
be interpolated inside a SQL string? To wit:

<IMG SRC=[[sql param]select image from db where code = '[item-code]'[/sql]]>

What I'm trying to do is pull the image filename out of a mySQL database for
its
associated item to use in a flypage. The above returns nada, and it seems
that
[item-code] never gets interpolated. If I remove the single quotes it causes
the
page to generate an Internal Server Error. Am I missing something, is there
a
better way to do it, or is this just not possible under Minivend 3.10?

I'm really desperately stumped!

Thanks in advance,

Tim Murphy


-
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