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

[Rage-DCA]

Kyle,

I sure would like to know what was wrong with the loop code, however, that
did the trick. Thank you very much.

Jason

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


At 03:22 PM 7/19/01, you wrote:
>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>
>
>Thanks,
>
>Jason Osborne
>Data and Telecom Network Solutions
>3847 Timberglen Rd., STE 4013
>Dallas, Texas 75287
>phone: 972-307-0676
>fax:   972-662-7956
>e-mail: sales@sohonetworks.cc
>web: http://www.sohonetworks.cc

Jason,

I've haven't had to mess with IC search setting for a long time now, but
maybe you could use an sql query to get what you want:

<SELECT NAME=mv_salesrep>
[query list=1 sql="SELECT code,full_name FROM rep ORDER BY full_name"]
<OPTION VALUE="[sql-param code]"> [sql-param full_name]
[/query]
</SELECT>

Might want to add a timed-build tag around this if this data changes
infrequently,
to save on QPP (Queries Per Page)

Kyle




_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users