[ic] scratch variable into SQL

[apom]

To Joachim,

I've tested again your code and i've added 'arg='
It's OK now

[seti scanparam]scan sp=results/m=3/st=sql/sq=SELECT sku FROM [scratch
table] WHERE category='Categorie01'[/seti]
<a href="[area href=scan arg="[scratch scanparam]"]">

thanks for your contribution
Sorry for my english

----- Original Message -----
From: Joachim Leidinger <jojo@blackpoint.de>
To: <interchange-users@developer.akopia.com>
Sent: Wednesday, May 23, 2001 12:40 PM
Subject: Re: [ic] (no subject)


> apom wrote:
> >
> > Hi all,
> >
> > Do you know how replace a scratch variable into  :
> >
> > <a href="[area scan sp=results/ml=3/st=sql/sq=SELECT sku FROM [scratch
> > table] WHERE category='Categorie01']">
> >
> > the result is :
> >
> > /scan/sp=results/ml=3/st=sql/sq=SELECT sku FROM [scratch table.html
WHERE
> > category='Categorie01']
> >
> > For information :
> > [if scratch mv_locale eq "fr_FR"][seti table]fr_products[/seti][/if]
> > [if scratch mv_locale eq "uk_UK"][seti table]uk_products[/seti][/if]
> > [if scratch mv_locale eq "es_ES"][seti table]es_products[/seti][/if]
> > [if scratch mv_locale eq "de_DE"][seti table]de_products[/seti][/if]
> >
> > Thanks
>
> Hmmm...maybe this
>
> [seti scanparam]scan sp=results/m=3/st=sql/sq=SELECT sku FROM [scratch
> table] WHERE category='Categorie01'[/seti]
>
> and
> <a href="[area href="[scratch scanparam]"]">
>
> is working for you?
>
> ciao
>
> Joachim
>
>
> --
> -------------<BPA FreeBsd>----------------------------------------------
> Hans-Joachim Leidinger          black point arts Internet Solutions GmbH
> email: jojo@blackpoint.de       FAX  : +49 0209-398265
> http://www.bpaserver.net
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>

 
______________________________________________________________________________
ifrance.com, l'email gratuit le plus complet de l'Internet !
vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
http://www.ifrance.com/_reloc/email.emailif