Mailing List Archive: Problem with query tag

Problem with query tag

Jan 5, 2001, 6:10 AM

Post #1 of 3 (735 views)

Hello,
i use the query tag like that:

[query table=pricing query="select * from pricing where sku='[item-code]'"
arrayref=pmap]

Although pricing is a SQL database and NoImportExternal is set,
IC tries to open the corresponding text file pricing.asc,
but fails if the file doesn't exist.

Can anyone explain that ?

Ciao
Racke

--
LinuXia Systems && Cobolt NetServices, eCommerce and more
Shop- und Datenbanklösungen mit MiniVend, Firewalls auf Debian-Basis
http://www.linuxia.de - http://www.cobolt.net
--> Junior Officer of the MiniVend/Interchange Bug Patrol <---

Problem with query tag [ In reply to ]

Murray at scotweb

Jan 5, 2001, 6:23 AM

Post #2 of 3 (727 views)

Permalink

Stefan Hornburg wrote:
>
> Hello,
> i use the query tag like that:
>
> [query table=pricing query="select * from pricing where sku='[item-code]'"
> arrayref=pmap]
>
> Although pricing is a SQL database and NoImportExternal is set,
> IC tries to open the corresponding text file ,
> but fails if the file doesn't exist.
>
> Can anyone explain that ?
>
> Ciao

try touching a pricing.sql file

--
____
\__/ Murray Gibbins murray@scotweb.ltd.uk
/ \ Programmer
_ \__/ _ ================================================
\\ || // Scotweb Limited, info@scotweb.ltd.uk
\\||// 13a Albert Terrace, http://www.scotweb.ltd.uk
\||/ Edinburgh EH10 5EA Tel: +44 (0) 131 270 82 33
|| Scotland. Europe. Fax: +44 (0) 7020 93 49 04

Problem with query tag [ In reply to ]

racke at linuxia

Jan 5, 2001, 6:48 AM

Post #3 of 3 (725 views)

Permalink

Stefan Hornburg <racke@linuxia.de> writes:

> Hello,
> i use the query tag like that:
>
> [query table=pricing query="select * from pricing where sku='[item-code]'"
> arrayref=pmap]
>
> Although pricing is a SQL database and NoImportExternal is set,
> IC tries to open the corresponding text file pricing.asc,
> but fails if the file doesn't exist.
>
> Can anyone explain that ?

Yes, I :-((((
Argh, admin error, variables SQLUSER etc. were empty
(running to get a fresh brown paperbag).

Ciao
Racke

--
LinuXia Systems && Cobolt NetServices, eCommerce and more
Shop- und Datenbanklösungen mit MiniVend, Firewalls auf Debian-Basis
http://www.linuxia.de - http://www.cobolt.net
--> Junior Officer of the MiniVend/Interchange Bug Patrol <---