[ic] What the heck is wrong with my loop code?

Rage-DCA interchange-users@lists.akopia.com
Fri Jul 20 02:32:00 2001


Where would you specify it as an interchange database?

-----Original Message-----
From: interchange-users-admin@developer.akopia.com
[mailto:interchange-users-admin@developer.akopia.com]On Behalf Of Mike
Heins
Sent: Thursday, July 19, 2001 8:25 PM
To: interchange-users@developer.akopia.com
Subject: Re: [ic] What the heck is wrong with my loop code?


Quoting Jason Osborne (jason@sohonetworks.cc):
> I've been messing with this for the past five hours and i can't get it to
> work at all. I'm trying to add a sales rep drop down box on the checkout
> page. I created a sql table called rep that contains a code and selector
> which is the first, middle, and last initial of a persons name, a
> first_name, middle_name, last_name, and full_name field. For some reason
it
> won't pull any of this data out of the sql table but also reports no
error.
> What am I doing wrong here. According to
> http://developer.akopia.com/cgi-bin/ic/dev/icdatabase_28.html, I have all
> the right tags setup.
>
> <SELECT NAME=mv_salesrep>
> [loop search="
>  ra=yes
>  fi=rep
>  st=sql
>  rf=code,full_name
>  ml=1000
>  tf=full_name
> "]
>   <OPTION VALUE="[loop-code]"> [loop-data rep full_name]
> [/loop]
> </SELECT>

That would work as long as the "rep" table is defined as an
Interchange database. If it is just an SQL table in the same
DB as products, you should see an error log entry showing that
it is not an interchange table. [query ...] would work in that
case.

--
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

Being against torture ought to be sort of a bipartisan thing.
-- Karl Lehenbauer
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users