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

[Kyle Cook]

At 05:23 PM 7/19/01, you wrote:
>Kyle,
>
>I sure would like to know what was wrong with the loop code, however, that
>did the trick. Thank you very much.
>
>Jason

Jason,

Your welcome.


Maybe the table was not defined in your catalog?
(Check error logs.....?)

Kyle



>-----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
>
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users