[ic] Remove Me from the mailing list
CapsuleCore Designs
capsule at capsulecore.com
Tue Oct 28 11:33:20 EST 2003
Remove me from the mailing list.
----- Original Message -----
From: <interchange-users-request at icdevgroup.org>
To: <interchange-users at icdevgroup.org>
Sent: Tuesday, October 28, 2003 11:04 AM
Subject: interchange-users Digest, Vol 4, Issue 28
> Send interchange-users mailing list submissions to
> interchange-users at icdevgroup.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
> or, via email, send a message with subject or body 'help' to
> interchange-users-request at icdevgroup.org
>
> You can reach the person managing the list at
> interchange-users-owner at icdevgroup.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of interchange-users digest..."
>
>
> Today's Topics:
>
> 1. Re: "==" and "!=" as DB field values (Marc Brevoort)
> 2. RE: OK to remove columns in products.xls? (John Rennie)
> 3. RE: "==" and "!=" as DB field values (Grant)
> 4. Re: Quickbooks Module Help (Joshua Lavin)
> 5. RE: Re: [ic] Sales Tax Excempt (Matthew Villa)
> 6. RE: OK to remove columns in products.xls? (Grant)
> 7. Re: "==" and "!=" as DB field values (Peter)
> 8. Re: Quickbooks Module Help (Dan Browning)
> 9. RE: Keeping the "selected" tag up (Grant)
> 10. Database Connection Concurrency/Exclusivity (Todd L. Cawthron)
> 11. Re: OK to remove columns in products.xls? (Hostmaster)
> 12. Receipt.html and URL Parameters (Gary Norton)
> 13. [ic]Free Shipping (Craig Halverson)
> 14. High traffic mode means no CSS (Joshua Lavin)
> 15. RE: Disabling CreditCardAuto (Eon Productions)
> 16. EXCEL formating problems (Hostmaster)
> 17. Re: "==" and "!=" as DB field values (Stefan Hornburg)
> 18. RE: EXCEL formating problems (Jack Gates)
> 19. Re: Disabling CreditCardAuto (Joshua Lavin)
> 20. Re: "==" and "!=" as DB field values (Doug Alcorn)
> 21. Forcing Login (Barry Newman)
> 22. Re: Forcing Login (Aaron Hazelton)
> 23. Re: Forcing Login (Alexander Schmitz)
> 24. Re: Forcing Login (Barry Treahy, Jr.)
> 25. RE: Forcing Login (Rene Hertell)
> 26. Re: "==" and "!=" as DB field values (Mike Heins)
> 27. Re: "==" and "!=" as DB field values (Stefan Hornburg)
> 28. Strange font error (Anthony Minero)
> 29. Re: Database Connection Concurrency/Exclusivity (Mike Heins)
> 30. Re: Receipt.html and URL Parameters (Ed LaFrance)
> 31. Diff between Catagory and Product Group? (Barry Newman)
> 32. Re: EXCEL formating problems (Hostmaster)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 27 Oct 2003 18:19:44 +0000
> From: Marc Brevoort <marc.brevoort at armazemdedados.com>
> Subject: Re: [ic] "==" and "!=" as DB field values
> To: interchange-users at icdevgroup.org
> Message-ID: <3F9D61C0.90901 at armazemdedados.com>
> Content-Type: text/plain; charset=us-ascii; format=flowed
>
> Grant wrote:
>
> > I'm using the default DB, and I want to have a field in a table with
either
> > "==" or "!=" (without the quotes) written to it. It would be involved
in
> >
> > I remember reading to be careful about what you write to a database
field,
> > so I'm making sure.
>
> Ah, i see. Make sure the database field is a varchar (text type) field,
> and things should be OK.
>
> Most problems with content of the field would mostly occur with control
> characters (ascii less than 32) and characters that need escaping in SQL
> strings.
>
> Behaviour for control characters within a string is undefined (what does
> SQL do if there is a carriage return or newline in a string before the
> string is terminated?).
>
> In SQL statements, strings are enclosed between apostrophes ('), so if
> your strings contain apostrophes and you want to send them to an SQL
> field, you need escape them by doubling them, otherwise the first
> apostrophe in your string will be considered to be string terminator. In
> the best case this would cause incorrect SQL syntax; in the worst case,
> an improperly escaped apostrophe can compromise the security of your
> application.
>
> Regards,
> Marc Brevoort
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 27 Oct 2003 18:32:40 -0000
> From: "John Rennie" <john.rennie at thechampagneshop.co.uk>
> Subject: RE: [ic] OK to remove columns in products.xls?
> To: <interchange-users at icdevgroup.org>
> Message-ID: <015b01c39cb8$b51ce0b0$0d0219ac at oemcomputer>
> Content-Type: text/plain; charset="us-ascii"
>
> > -----Original Message-----
> > From: interchange-users-bounces at icdevgroup.org
> > [mailto:interchange-users-bounces at icdevgroup.org] On Behalf Of Grant
> > Sent: 27 October 2003 17:42
> > To: interchange-users at icdevgroup.org
> > Subject: RE: [ic] OK to remove columns in products.xls?
> >
> >
> >
> > > Hello list members,
> > > I've used the products.xls example supplied with IC to
> > build a product
> > > database for my client which contains 1891 records. There are some
> > > fields on the spreadsheet that I can't place on the catalog. Can
> > > someone tell me what the following fields are for, and where on the
> > > catalog they are found?
> > > 1) title (we are using description and comments, but this field
> > > eludes us - where would we see it on the demo?)
> > > 2) related
> > > 3) dl_type
> > > 4) dl_location
> > > 5) inactive
> > > 6) image_large (I see where thumb and image are used, but not
> > > image_large)
> > >
> > > If we don't need certain fields in our catalog, is it safe
> > to remove
> > > them, or does Interchange require the fields be included,
> > whether they
> > > are used or not?
> > >
> > > Thank you,
> > > Michael G.
> >
> > I'm not sure where most those fields are used in the demo,
> > but it's possible that they aren't used and they're just
> > there in case you want to use them. I do know that if you
> > mark a 1 in the inactive field for a product, it shouldn't
> > show up in searches.
> >
> > You don't want to remove any headers without also cleaning up
> > each record's data to correspond to the new header sequence.
> > But, you're using Excel so maybe you can figure something out
> > with that.
> >
> > - Grant
> >
> I'd strongly recommend leaving them. The dl_ are for soft download goods.
> I believe that 'related' is used in some of the components that you may
> not be using today, but may well use in the future. For the sake of
leaving
> them there, you do risk breaking something. It's not worth the effort.
>
> Regards,
>
> John.
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 27 Oct 2003 10:55:38 -0800
> From: "Grant" <listbox at email.com>
> Subject: RE: [ic] "==" and "!=" as DB field values
> To: <interchange-users at icdevgroup.org>
> Message-ID: <MDBBLAHPINLAMCOFBHNLEEMIDFAA.listbox at email.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
>
> > Grant wrote:
> >
> > > I'm using the default DB, and I want to have a field in a table
> > with either
> > > "==" or "!=" (without the quotes) written to it. It would be
> > involved in
> > >
> > > I remember reading to be careful about what you write to a
> > database field,
> > > so I'm making sure.
> >
> > Ah, i see. Make sure the database field is a varchar (text type) field,
> > and things should be OK.
> >
> > Most problems with content of the field would mostly occur with control
> > characters (ascii less than 32) and characters that need escaping in SQL
> > strings.
> >
> > Behaviour for control characters within a string is undefined (what does
> > SQL do if there is a carriage return or newline in a string before the
> > string is terminated?).
> >
> > In SQL statements, strings are enclosed between apostrophes ('), so if
> > your strings contain apostrophes and you want to send them to an SQL
> > field, you need escape them by doubling them, otherwise the first
> > apostrophe in your string will be considered to be string terminator. In
> > the best case this would cause incorrect SQL syntax; in the worst case,
> > an improperly escaped apostrophe can compromise the security of your
> > application.
> >
> > Regards,
> > Marc Brevoort
>
> That's good info. Thanks Marc.
>
> - Grant
>
> ------------------------------
>
> Message: 4
> Date: Mon, 27 Oct 2003 13:18:31 -0600
> From: Joshua Lavin <joshua at kingdomdesign.com>
> Subject: Re: [ic] Quickbooks Module Help
> To: interchange-users at icdevgroup.org
> Message-ID: <5A1448AE-08B2-11D8-8A63-0030654BBC4C at kingdomdesign.com>
> Content-Type: text/plain; charset=US-ASCII; format=flowed
>
>
> On Saturday, October 25, 2003, at 10:20 AM, Terral Artis wrote:
>
> > I am having a problem with the Quickbooks module.
> >
> > Interchange 4.8.6
> >
> > After accessing the Quickbooks interface, I go to "Generate New
> > Orders". I give it a range of dates and it appears to generate an
> > iif. When I go and look in the "Orders" directory, I have a new file
> > called 0_qb_results.iif that is empty. Any ideas?
> >
> > TIA
> >
> > Terral
>
> I used to have this problem, too. Upgrading to 4.9.8 fixed it, as I
> recall.
>
> Josh
>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 27 Oct 2003 11:47:19 -0800
> From: "Matthew Villa" <mvilla213 at sbcglobal.net>
> Subject: RE: Re: [ic] Sales Tax Excempt
> To: <interchange-users at icdevgroup.org>
> Message-ID: <001001c39cc3$21d9bf20$9a7ba8c0 at MVILLA>
> Content-Type: text/plain; charset="us-ascii"
>
> > From: Ed LaFrance <edl at newmediaems.com>
> > There is a non-taxable field in the products table; setting this field
> to
> > true (non-blank) for all items is one way. You could also set TAXAREA,
>
> > TAXFIELD and friends to fictional values to disable tax calcs
> altogether.
>
> This is what I have set in my variable.txt file
> TAXAREA NC Tax
> TAXFIELD state Tax
> TAXRATE NC=0 Tax
>
> Even though TAXTRATE NC is set to 0, it still adds tax. Any suggestions?
> Thanks.
>
>
> ------------------------------
>
> Message: 6
> Date: Mon, 27 Oct 2003 12:02:29 -0800
> From: "Grant" <listbox at email.com>
> Subject: RE: [ic] OK to remove columns in products.xls?
> To: <interchange-users at icdevgroup.org>
> Message-ID: <MDBBLAHPINLAMCOFBHNLGENBDFAA.listbox at email.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
>
> > > > Hello list members,
> > > > I've used the products.xls example supplied with IC to
> > > build a product
> > > > database for my client which contains 1891 records. There are some
> > > > fields on the spreadsheet that I can't place on the catalog. Can
> > > > someone tell me what the following fields are for, and where on the
> > > > catalog they are found?
> > > > 1) title (we are using description and comments, but this field
> > > > eludes us - where would we see it on the demo?)
> > > > 2) related
> > > > 3) dl_type
> > > > 4) dl_location
> > > > 5) inactive
> > > > 6) image_large (I see where thumb and image are used, but not
> > > > image_large)
> > > >
> > > > If we don't need certain fields in our catalog, is it safe
> > > to remove
> > > > them, or does Interchange require the fields be included,
> > > whether they
> > > > are used or not?
> > > >
> > > > Thank you,
> > > > Michael G.
> > >
> > > I'm not sure where most those fields are used in the demo,
> > > but it's possible that they aren't used and they're just
> > > there in case you want to use them. I do know that if you
> > > mark a 1 in the inactive field for a product, it shouldn't
> > > show up in searches.
> > >
> > > You don't want to remove any headers without also cleaning up
> > > each record's data to correspond to the new header sequence.
> > > But, you're using Excel so maybe you can figure something out
> > > with that.
> > >
> > > - Grant
> > >
> > I'd strongly recommend leaving them. The dl_ are for soft download
goods.
> > I believe that 'related' is used in some of the components that you may
> > not be using today, but may well use in the future. For the sake
> > of leaving
> > them there, you do risk breaking something. It's not worth the effort.
> >
> > Regards,
> >
> > John.
>
> I agree with John. Put off customizing things of that nature until you
> build your own catalog from scratch.
>
> - Grant
>
>
> ------------------------------
>
> Message: 7
> Date: Mon, 27 Oct 2003 12:16:27 -0800
> From: Peter <peter at pajamian.dhs.org>
> Subject: Re: [ic] "==" and "!=" as DB field values
> To: interchange-users at icdevgroup.org
> Message-ID: <3F9D7D1B.8030505 at pajamian.dhs.org>
> Content-Type: text/plain; charset=us-ascii; format=flowed
>
> Grant wrote:
> >>Most problems with content of the field would mostly occur with control
> >>characters (ascii less than 32) and characters that need escaping in SQL
> >>strings.
> >>
> >>Behaviour for control characters within a string is undefined (what does
> >>SQL do if there is a carriage return or newline in a string before the
> >>string is terminated?).
> >>
> >>In SQL statements, strings are enclosed between apostrophes ('), so if
> >>your strings contain apostrophes and you want to send them to an SQL
> >>field, you need escape them by doubling them, otherwise the first
> >>apostrophe in your string will be considered to be string terminator. In
> >>the best case this would cause incorrect SQL syntax; in the worst case,
> >>an improperly escaped apostrophe can compromise the security of your
> >>application.
>
> Doesn't IC escape these automatically via the DBI quote function or via
> '?'-type parameters?
>
> Peter
>
>
> ------------------------------
>
> Message: 8
> Date: Mon, 27 Oct 2003 12:56:15 -0800
> From: Dan Browning <db at kavod.com>
> Subject: Re: [ic] Quickbooks Module Help
> To: interchange-users at icdevgroup.org
> Message-ID: <20031027205615.GA15194 at kavod.com>
> Content-Type: text/plain; charset=us-ascii
>
> * Terral Artis <tartis at cellularmountain.com> [2003-10-25 10:03]:
> > I am having a problem with the Quickbooks module.
> >
> > Interchange 4.8.6
> >
> > After accessing the Quickbooks interface, I go to "Generate New Orders".
I
> > give it a range of dates and it appears to generate an iif. When I go
and
> > look in the "Orders" directory, I have a new file called
> > 0_qb_results.iif that is empty. Any ideas?
>
> Thanks for the bug report. Like someone else said, 4.9 probably works.
I'll
> add it to the todo list.
>
> --
> Dan Browning, Kavod Technologies, <db at kavod.com> 360.843.4074x217
> 6700 NE 162nd Ave, Ste 611-210, Vancouver, WA. Random Fortune:
> Conscience is the inner voice that warns us somebody may be looking.
> -- H.L. Mencken, "A Mencken Chrestomathy"
>
> ------------------------------
>
> Message: 9
> Date: Mon, 27 Oct 2003 14:11:22 -0800
> From: "Grant" <listbox at email.com>
> Subject: RE: [ic] Keeping the "selected" tag up
> To: <interchange-users at icdevgroup.org>
> Message-ID: <MDBBLAHPINLAMCOFBHNLOENIDFAA.listbox at email.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
>
> > > Quoting Grant (listbox at email.com):
> > > > The selected tag seems to be designed to be used to output HTML
> > > like this:
> > > >
> > > > <option SELECTED value="1">1
> > > >
> > > > but the proper method is specified here:
> > > > http://www.w3schools.com/tags/tag_option.asp as:
> > > >
> > > > <option selected="selected" value="1">1
> > >
> > > They can say it is the proper way, but the HTML spec differs. It is an
> > > attribute that has an implicit value, and you need not add
="selected".
> >
> > I'm going to go straight to the HTML spec from now on.
> >
> > >
> > > HTML 4.0 spec 17.6:
> > >
> > > In this example, we create a menu that allows the user to select
which
> > > of seven software components to install. The first and second
> > > components are pre-selected but may be deselected by the user. The
> > > remaining components are not pre-selected. The size attribute
states
> > > that the menu should only have 4 rows even though the user may
select
> > > from among 7 options. The other options should be made available
> > > through a scrolling mechanism.
> > >
> > > The SELECT is followed by submit and reset buttons.
> > > <FORM action="http://somesite.com/prog/component-select"
method="post">
> > > <P>
> > > <SELECT multiple size="4" name="component-select">
> > > <OPTION selected value="Component_1_a">Component_1</OPTION>
> > > <OPTION selected value="Component_1_b">Component_2</OPTION>
> > > <OPTION>Component_3</OPTION>
> > > <OPTION>Component_4</OPTION>
> > > <OPTION>Component_5</OPTION>
> > > <OPTION>Component_6</OPTION>
> > > <OPTION>Component_7</OPTION>
> > > </SELECT>
> > > <INPUT type="submit" value="Send"><INPUT type="reset">
> > > </P>
> > > </FORM>
> > >
> > > Note they, in their authoritative example, do not use it in the
> > > way you say is proper. In fact, they recommend you don't do it
> > > that way.
> > >
> > > B.3.4 Boolean attributes
> > >
> > > Authors should be aware that many user agents only recognize the
> > > minimized form of boolean attributes and not the full form.
> > >
> > > For instance, authors may want to specify:
> > > <OPTION selected>
> > >
> > > instead of
> > > <OPTION selected="selected">
> > >
> >
> > That's very interesting, I didn't realize that at all. I'm going to
look
> > into other HTML tag attributes that might need to be specified in a
> > minimized form.
> >
> > - Grant
> >
> > >
> > > --
> > > Mike Heins
>
> After some poking around it looks like selected="selected" is required for
> XHTML which is supposed to replace the HTML spec right?
>
> - Grant
>
>
> ------------------------------
>
> Message: 10
> Date: Mon, 27 Oct 2003 14:26:28 -0800
> From: "Todd L. Cawthron" <todd at lunsfordgroup.com>
> Subject: [ic] Database Connection Concurrency/Exclusivity
> To: <interchange-users at icdevgroup.org>
> Message-ID: <002e01c39cd9$5d7b64f0$f801a8c0 at TLGPC02>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I'm running Interchange using a SQL database (Sybase to be exact).
Recently,
> I ran into a situation where I wanted to use a transaction when deleting
and
> then inserting rows into a table.
>
> I could stitch together a batch of SQL statements and send the batch as a
> single query, or I could use multiple queries. The batch would probably be
> the safest route, although it could be a problem if the batch was really
> large.
>
> If I went the multiple query route, I would begin a transaction, run a
> delete query, then a number of insert queries, and finally commit the
> transaction. If I do this with a number of calls to the query tag (or by
> using the underlying database handle directly), will I have any problems
> running in pre-fork mode? In other words, will the interchange process
that
> is running this subroutine always use the same database handle for each
call
> and will it have exclusive use of this handle? Or, will other interchange
> processes potentially issue database commands using the same database
> connection, which might result in queries being unintentionally included
in
> my transaction?
>
> Any pointers on how interchange manages database connections would be
> greatly appreciated.
>
> Thanks,
> Todd
>
>
>
> ------------------------------
>
> Message: 11
> Date: Mon, 27 Oct 2003 18:13:25 -0600
> From: "Hostmaster" <hostmaster at zipp.net>
> Subject: Re: [ic] OK to remove columns in products.xls?
> To: <interchange-users at icdevgroup.org>
> Message-ID: <00a501c39ce8$4ed910a0$65958f42 at sbcglobal.net>
> Content-Type: text/plain; charset="iso-8859-1"
>
> > > > > Hello list members,
> > > > > I've used the products.xls example supplied with IC to
> > > > build a product
> > > > > database for my client which contains 1891 records. There are
some
> > > > > fields on the spreadsheet that I can't place on the catalog. Can
> > > > > someone tell me what the following fields are for, and where on
the
> > > > > catalog they are found?
> > > > > 1) title (we are using description and comments, but this field
> > > > > eludes us - where would we see it on the demo?)
> > > > > 2) related
> > > > > 3) dl_type
> > > > > 4) dl_location
> > > > > 5) inactive
> > > > > 6) image_large (I see where thumb and image are used, but not
> > > > > image_large)
> > > > >
> > > > > If we don't need certain fields in our catalog, is it safe
> > > > to remove
> > > > > them, or does Interchange require the fields be included,
> > > > whether they
> > > > > are used or not?
> > > > >
> > > > > Thank you,
> > > > > Michael G.
> > > >
> > > > I'm not sure where most those fields are used in the demo,
> > > > but it's possible that they aren't used and they're just
> > > > there in case you want to use them. I do know that if you
> > > > mark a 1 in the inactive field for a product, it shouldn't
> > > > show up in searches.
> > > >
> > > > You don't want to remove any headers without also cleaning up
> > > > each record's data to correspond to the new header sequence.
> > > > But, you're using Excel so maybe you can figure something out
> > > > with that.
> > > >
> > > > - Grant
> > > >
> > > I'd strongly recommend leaving them. The dl_ are for soft download
> goods.
> > > I believe that 'related' is used in some of the components that you
may
> > > not be using today, but may well use in the future. For the sake
> > > of leaving
> > > them there, you do risk breaking something. It's not worth the effort.
> > >
> > > Regards,
> > >
> > > John.
> >
> > I agree with John. Put off customizing things of that nature until you
> > build your own catalog from scratch.
> >
> > - Grant
>
> Thank you Grant, Paul and John for the excellent advice. The Spreadsheet
> will remain as is until I learn more about customization.
> Gratefully,
> Michael G.
>
>
> ------------------------------
>
> Message: 12
> Date: Mon, 27 Oct 2003 17:17:38 -0700
> From: "Gary Norton" <gnorton at broadgap.com>
> Subject: [ic] Receipt.html and URL Parameters
> To: <interchange-users at icdevgroup.org>
> Message-ID: <002401c39ce8$e77472a0$0d00a8c0 at CORP.BROADGAP.COM>
> Content-Type: text/plain; charset="us-ascii"
>
> A client of ours has enrolled in a real-time statistics engine that
supports
> ecommerce transactions. So far we have been able to implement many of
their
> coding requests for this tracking system.
>
> Part of the system tracking uses the URL. Specifically they want a URL for
> the Interchange Receipt page. This page is served up under the
Process.html
> name after the credit card transaction.
>
> Because the Process.html URL is not unique to the Receipt page, it is
> messing up their stats.
>
> I was thinking passing a URL parameter so that the URL parse would be
unique
> (something like ...../process.html?finished=1). However, I can't figure
out
> how to do it.
>
> Does anyone have any ideas how I might pass a URL parameter to/through the
> process.html?
>
> Or perhaps I am looking at this the wrong way. Is there another way I
could
> approach this so that they can get a unique URL instead of Process.html?
>
> --------------------------------------------------------------------
> Gary Norton
> broadGap Technologies
>
>
>
>
> ------------------------------
>
> Message: 13
> Date: Mon, 27 Oct 2003 22:44:28 -0300
> From: Craig Halverson <n0va at nbnet.nb.ca>
> Subject: [ic]Free Shipping
> To: interchange-users at icdevgroup.org
> Message-ID: <200310272144.28041.n0va at nbnet.nb.ca>
> Content-Type: text/plain; charset="iso-8859-1"
>
>
> I've been setting up IC 4.9.8 for a while now and I seem to have hit a
> block. I have modified the original Foundation catalog to my needs. I
have
> encorporated Canada Post Shipping lookups as per the only docs I could
find
> on IC's mailing list archive. I can't seem to add a "Free local pickup"
> shipping option to my setup. and I can't get my checkout.html to only
show
> shipping method when there's something to ship. I am using radio buttons
> instead of pullup/pulldown selections. If anyone has a few minutes to
look
> over what I've done, it'd be much appreciated.
>
> Craig
>
>
>
> ------------------------------
>
> Message: 14
> Date: Mon, 27 Oct 2003 19:44:41 -0600
> From: Joshua Lavin <joshua at kingdomdesign.com>
> Subject: [ic] High traffic mode means no CSS
> To: interchange-users <interchange-users at icdevgroup.org>
> Message-ID: <4C6251B4-08E8-11D8-8A63-0030654BBC4C at kingdomdesign.com>
> Content-Type: text/plain; charset=US-ASCII; format=flowed
>
> I ran into a funny thing when I switched to high traffic mode on a
> 4.9.8-20030915 catalog. Suddenly, my CSS settings weren't being loaded.
>
> If I go back to low, they are loaded just fine.
>
> My templates call the style sheet with the variable: __THEME_CSS__
>
> Any thoughts?
>
> Josh
>
>
> ------------------------------
>
> Message: 15
> Date: Mon, 27 Oct 2003 23:40:22 -0600
> From: "Eon Productions" <eonprod at eonprod.com>
> Subject: RE: [ic] Disabling CreditCardAuto
> To: <interchange-users at icdevgroup.org>
> Message-ID: <LOBBIOJBCBBGLKLNOLMEEEGIDFAA.eonprod at eonprod.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> > I read somewhere on that I could disable encryption by inserting the
line
> > "CreditCardAuto No" into the catalog.cfg file. Well I did it and
> > corrupted pretty much the whole shopping cart. Is there some
> > other way (an
> > idiot proof way) to accomplish disabling credit card encryption
> > where I can
> > view the card info in my e-mail when I get orders?
>
> ___________________________________________
>
> I don't think you're going to have any luck making that happen. This
> subject comes up every once in a while and the conclusion is always "just
> don't do it". It's been hinted that there is a way to make it happen, but
I
> get the feeling it's a lot more involved than changing a directive.
>
> - Grant
>
> __________________________________________
>
> OK. So I decided to just try it the way it's set up. I've downloaded and
> installed the PGP FW program and now when I send a test order to see if
the
> credit card info will decrypt, I get the same thing as before when I
didn't
> have the program at all. The order I get in my e-mail says, "Credit Card
> Info: NEED ENCRYPTION KEY POINTER." The plug ins for Outlook seem to be
> working. When I try to decrypt the credit card info when I'm logged into
> the admin section of Interchange I get "No PGP info was found".
> Anybody got any answers I can use on this?
> Please help...I thought this was going to be an easy set up, but now I'm
15
> days behind schedule.
> -Brett
>
>
>
> ------------------------------
>
> Message: 16
> Date: Tue, 28 Oct 2003 01:26:14 -0600
> From: "Hostmaster" <hostmaster at zipp.net>
> Subject: [ic] EXCEL formating problems
> To: <interchange-users at icdevgroup.org>
> Message-ID: <012301c39d24$c5c659c0$65958f42 at sbcglobal.net>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello List Members,
> While researching the list to see if it could retain the formatting of
> certain cells (with bold font) of the Excel Spreadsheet (converted to
> tab-delimited products.txt) when importing into IC using the Import
Feature
> in the Admin UI, I found this post from Fri, 26 Jan 2001 11:05:12 -0800:
>
(http://www.icdevgroup.org/pipermail/interchange-users/2001-January/004216.h
> tml):
> [BEGIN POST]
> If you're using EXCEL make sure you add;
>
> Database products EXCEL 1
>
> this will get rid of any EXCEL formating problems such as quotes and
> CR/LF and other problems associated with EXCEL during importing or file
> transfering
>
> Then do a re-import or better yet file transfer all the data and wa-la
> the data appears as intended.
> --
> J. Scott Andreas :)
> Programmer/Webintegrator
> e-mail: scotta at homer.learnserv.com
> phone: 1-800-877-9378 ext. 146
> fax: (541) 744-2056
> --- __o
> --- _-\<,_
> --- (_)/ (_)
>
> [END POST]
>
> I thought this was a very useful post, so I attempted to apply it to a
> catalog I've built.
> But I wasn't clear on the following line from the suggested procedure:
> Database products EXCEL 1
>
> Using IC 4.9.3, from within the Admin UI I navigated to
> Tables>preferences>Database.
> I found the resulting page:
>
> [BEGIN RESULTS]
>
> Entries matching "pref_group=Database"
>
> code Variable
> pref_group
> MV_DEFAULT_SEARCH_DB 1 Database
> MYSQL
> Database
> ORACLE
> Database
> PGSQL
> Database
> SQLDSN
> Database
> SQLPASS
> Database
> SQLUSER
> Database
>
> [END RESULTS]
>
> QUESTION: I saw the option to "add an entry" at this page. Would this be
> where I would add EXCEL with the variable 1, to create a new line in the
> above results that would look like:
> code Variable pref_group
> EXCEL 1 Database
>
> If so, where is the "products" from the suggested "Database products
> EXCEL 1" found in the above preferences Editor?
>
> Finally, with regards to my original search, it appears that EXCEL will
not
> retain any text formatting (such as "bold", or "italics") when imported
into
> Interchange. I have to use EXCEL because the client won't learn SQL or
> MYSQL, or anything new. : - )
>
> This Email is all nicely laid out in rows (for the table examples above).
I
> hope it stays that way in transit. If not, apologies in advance for what
> may seem to be a scrambled mess.
>
> Best regards,
> Michael G.
>
>
> ------------------------------
>
> Message: 17
> Date: Tue, 28 Oct 2003 09:50:12 +0100
> From: Stefan Hornburg <racke at linuxia.de>
> Subject: Re: [ic] "==" and "!=" as DB field values
> To: interchange-users at icdevgroup.org
> Message-ID: <20031028095012.6d5664fa.racke at linuxia.de>
> Content-Type: text/plain; charset=US-ASCII
>
> On Mon, 27 Oct 2003 12:16:27 -0800
> Peter <peter at pajamian.dhs.org> wrote:
>
> > Grant wrote:
> > >>Most problems with content of the field would mostly occur with
control
> > >>characters (ascii less than 32) and characters that need escaping in
SQL
> > >>strings.
> > >>
> > >>Behaviour for control characters within a string is undefined (what
does
> > >>SQL do if there is a carriage return or newline in a string before the
> > >>string is terminated?).
> > >>
> > >>In SQL statements, strings are enclosed between apostrophes ('), so if
> > >>your strings contain apostrophes and you want to send them to an SQL
> > >>field, you need escape them by doubling them, otherwise the first
> > >>apostrophe in your string will be considered to be string terminator.
In
> > >>the best case this would cause incorrect SQL syntax; in the worst
case,
> > >>an improperly escaped apostrophe can compromise the security of your
> > >>application.
> >
> > Doesn't IC escape these automatically via the DBI quote function or via
> > '?'-type parameters?
>
> Yes, in the most cases. You need to take care of that if you are calling
> the query method from embedded Perl like:
>
> $Db{products}->query("select * from products where name = '$CGI->{foo}'");
>
> => that's unsafe IMHO
>
> Ciao
> Racke
>
> --
> LinuXia Systems => http://www.linuxia.de/
> Expert Interchange Consulting and System Administration
> ICDEVGROUP => http://www.icdevgroup.org/
> Interchange Development Team
>
>
> ------------------------------
>
> Message: 18
> Date: Tue, 28 Oct 2003 06:44:40 -0500
> From: "Jack Gates" <jlgates at morningstarwebservices.net>
> Subject: RE: [ic] EXCEL formating problems
> To: <interchange-users at icdevgroup.org>
> Message-ID:
> <GBEJLOJOLDCGAAJJBAIHCEFMCDAA.jlgates at morningstarwebservices.net>
> Content-Type: text/plain; charset="iso-8859-1"
>
> > Finally, with regards to my original search, it appears that
> > EXCEL will not
> > retain any text formatting (such as "bold", or "italics") when
> > imported into
> > Interchange.
>
> HTML tags around the data that is suppossed to be bold or italic work.
>
> ------------------------------
>
> Message: 19
> Date: Tue, 28 Oct 2003 06:46:53 -0600
> From: Joshua Lavin <joshua at kingdomdesign.com>
> Subject: Re: [ic] Disabling CreditCardAuto
> To: interchange-users at icdevgroup.org, eonprod at eonprod.com
> Message-ID: <CECF9504-0944-11D8-8A63-0030654BBC4C at kingdomdesign.com>
> Content-Type: text/plain; charset=US-ASCII; format=flowed
>
>
> On Monday, October 27, 2003, at 11:40 PM, Eon Productions wrote:
>
> >> I read somewhere on that I could disable encryption by inserting the
> >> line
> >> "CreditCardAuto No" into the catalog.cfg file. Well I did it
> >> and
> >> corrupted pretty much the whole shopping cart. Is there some
> >> other way (an
> >> idiot proof way) to accomplish disabling credit card encryption
> >> where I can
> >> view the card info in my e-mail when I get orders?
> >
> > ___________________________________________
> >
> > I don't think you're going to have any luck making that happen. This
> > subject comes up every once in a while and the conclusion is always
> > "just
> > don't do it". It's been hinted that there is a way to make it happen,
> > but I
> > get the feeling it's a lot more involved than changing a directive.
> >
> > - Grant
> >
> > __________________________________________
> >
> > OK. So I decided to just try it the way it's set up. I've downloaded
> > and
> > installed the PGP FW program and now when I send a test order to see
> > if the
> > credit card info will decrypt, I get the same thing as before when I
> > didn't
> > have the program at all. The order I get in my e-mail says, "Credit
> > Card
> > Info: NEED ENCRYPTION KEY POINTER." The plug ins for Outlook seem to
> > be
> > working. When I try to decrypt the credit card info when I'm logged
> > into
> > the admin section of Interchange I get "No PGP info was found".
> > Anybody got any answers I can use on this?
> > Please help...I thought this was going to be an easy set up, but now
> > I'm 15
> > days behind schedule.
> > -Brett
>
> Have you seen these?
>
> http://www.icdevgroup.org/archive/interchange-users/2001/msg12160.html
>
> http://www.icdevgroup.org/archive/interchange-users/2001/msg12402.html
>
> Josh
>
>
> ------------------------------
>
> Message: 20
> Date: Tue, 28 Oct 2003 09:37:08 -0500
> From: Doug Alcorn <doug at lathi.net>
> Subject: Re: [ic] "==" and "!=" as DB field values
> To: interchange-users at icdevgroup.org
> Message-ID: <87y8v5pgx7.fsf at lathi.net>
> Content-Type: text/plain; charset=us-ascii
>
> Stefan Hornburg <racke at linuxia.de> writes:
>
> > $Db{products}->query("select * from products where name =
'$CGI->{foo}'");
> >
> > => that's unsafe IMHO
>
> Just to clarify, if
>
> $GCI->{foo} = "'; delete from products;'"
>
> Then there could be problems. In this case, you should escape any
> single quotes in $CGI->{foo}.
>
> [perl]
> # racke says my perl is "rusty", so take this with a few grains of
sandpaper
> my $foo = $Tag->filter('sql', $CGI->{foo});
> my $ref = $Db{products}->query("select * from products where name =
'$foo'");
> [/perl]
>
> The moral of the story is that it's very, very rare when anything the
> user inputs is valid. Almost always there are a certain set of
> characters that are invalid. Try to think about this and escape these
> characters or manage those cases. Thank the IC core team for the
> filter tag and it's flexibility.
> --
> (__) Doug Alcorn - Unix/Linux/Web Developing
> oo / PGP 02B3 1E26 BCF2 9AAF 93F1 61D7 450C B264 3E63 D543
> |_/ mailto:doug at lathi.net http://www.lathi.net
> mailto:tarpit at lathi.net is a spam trap
>
> ------------------------------
>
> Message: 21
> Date: Tue, 28 Oct 2003 09:50:06 -0500
> From: Barry Newman <packet at tampabay.rr.com>
> Subject: [ic] Forcing Login
> To: interchange-users at icdevgroup.org
> Message-ID: <200310280950.06299.packet at tampabay.rr.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Hello , I am wanting to use interchange for a wholesale company that
dosen't
> want end-users able to view pricing. So I need to either make pricing
empty
> until a user logs in or block access completly until user logs in. Thanks
in
> advance for any assistance!!!
>
>
> Barry Newman
>
> ------------------------------
>
> Message: 22
> Date: Tue, 28 Oct 2003 10:07:42 -0500
> From: Aaron Hazelton <aaronmail at hazenet.net>
> Subject: Re: [ic] Forcing Login
> To: interchange-users at icdevgroup.org
> Message-ID: <oprxrdm40irpbzox at mail.hazenet.net>
> Content-Type: text/plain; charset=iso-8859-15; format=flowed
>
> On Tue, 28 Oct 2003 09:50:06 -0500, Barry Newman <packet at tampabay.rr.com>
> wrote:
>
> > Hello , I am wanting to use interchange for a wholesale company that
> > dosen't want end-users able to view pricing. So I need to either make
> > pricing empty until a user logs in or block access completly until user
> > logs in. Thanks in advance for any assistance!!!
> >
> >
> > Barry Newman
> > _______________________________________________
>
> using the standard foundation-type templates, you can simply add this:
>
> [tmp members_only]1[/tmp]
>
> to each page. This will bounce any user to the login page and force them
> to log in, and they must be in the user db table.
>
> --
> Aaron Hazelton
> Hazenet.net
>
> ------------------------------
>
> Message: 23
> Date: Tue, 28 Oct 2003 17:13:45 +0100
> From: Alexander Schmitz <a.schmitz at axon-e.de>
> Subject: Re: [ic] Forcing Login
> To: interchange-users at icdevgroup.org
> Message-ID: <3F9E95B9.3070504 at axon-e.de>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Barry Newman wrote:
>
> > Hello , I am wanting to use interchange for a wholesale company that
dosen't
> >want end-users able to view pricing. So I need to either make pricing
empty
> >until a user logs in or block access completly until user logs in. Thanks
in
> >advance for any assistance!
> >
>
> Hy,
>
> use:
>
> [if !session logged_in]
> [or session login_table ne 'userdb']
> [bounce page="login.html"]
> [/if]
>
> in every page (header) to force the user to goto
> login.html until he logs in.
>
> bye Alex
>
> --
> AXON-E interaktive medien
> tel. +49(0)941 5998545
> fax. +49(0)941 5998541
>
>
>
> ------------------------------
>
> Message: 24
> Date: Tue, 28 Oct 2003 08:24:57 -0700
> From: "Barry Treahy, Jr." <Treahy at MMaz.com>
> Subject: Re: [ic] Forcing Login
> To: interchange-users at icdevgroup.org
> Message-ID: <3F9E8A49.9040703 at MMaz.com>
> Content-Type: text/plain; charset=us-ascii; format=flowed
>
> Barry Newman wrote:
>
> > Hello , I am wanting to use interchange for a wholesale company that
dosen't
> >want end-users able to view pricing. So I need to either make pricing
empty
> >until a user logs in or block access completly until user logs in. Thanks
in
> >advance for any assistance!!!
> >
> >
> >
> You can modify the template to confirm a logged in session so that any
> page that is referenced is tested and if it fails, then redirect to the
> accounts login page...
>
> Barry
>
> --
>
> Barry Treahy, Jr E-mail: Treahy at MMaz.com
> Midwest Microwave Phone: 480/314-1320
> Vice President & CIO FAX: 480/661-7028
>
>
>
>
>
> ------------------------------
>
> Message: 25
> Date: Tue, 28 Oct 2003 17:34:53 +0200
> From: "Rene Hertell" <interchange-users at hertell.com>
> Subject: RE: [ic] Forcing Login
> To: <interchange-users at icdevgroup.org>
> Message-ID:
> <PBEAKFLPAMBMOAAHMENNEEBDFHAA.interchange-users at hertell.com>
> Content-Type: text/plain; charset="iso-8859-15"
>
> > using the standard foundation-type templates, you can simply add this:
> >
> > [tmp members_only]1[/tmp]
> >
> > to each page. This will bounce any user to the login page and force
them
> > to log in, and they must be in the user db table.
> >
>
> .. or you can use
>
> [if session logged_in]
> Dealer price
> [else]
> You have to be logged in to see any prices
> [/else]
> [/if]
>
> René
>
>
>
> ------------------------------
>
> Message: 26
> Date: Tue, 28 Oct 2003 11:01:44 -0500
> From: Mike Heins <mike at perusion.com>
> Subject: Re: [ic] "==" and "!=" as DB field values
> To: interchange-users at icdevgroup.org
> Message-ID: <20031028160144.GA8793 at bill.heins.net>
> Content-Type: text/plain; charset=us-ascii
>
> Quoting Doug Alcorn (doug at lathi.net):
> > Stefan Hornburg <racke at linuxia.de> writes:
> >
> > > $Db{products}->query("select * from products where name =
'$CGI->{foo}'");
> > >
> > > => that's unsafe IMHO
> >
> > Just to clarify, if
> >
> > $GCI->{foo} = "'; delete from products;'"
> >
> > Then there could be problems.
>
> This is not correct; IC doesn't pass statements to a SQL shell, and
> you cannot pass multiple commands in this way.
>
> It might be possible to construct a subselect, but I hope that
> no SQL allows a delete or update as a side-effect of a subselect.
>
> --
> Mike Heins
> Perusion -- Expert Interchange Consulting http://www.perusion.com/
> phone +1.513.523.7621 <mike at perusion.com>
>
> For a successful technology, reality must take precedence over public
> relations, for Nature cannot be fooled. -- Dick Feynman
>
> ------------------------------
>
> Message: 27
> Date: Tue, 28 Oct 2003 17:08:35 +0100
> From: Stefan Hornburg <racke at linuxia.de>
> Subject: Re: [ic] "==" and "!=" as DB field values
> To: interchange-users at icdevgroup.org
> Message-ID: <20031028170835.6c272f0a.racke at linuxia.de>
> Content-Type: text/plain; charset=US-ASCII
>
> On Tue, 28 Oct 2003 09:37:08 -0500
> Doug Alcorn <doug at lathi.net> wrote:
>
> > Stefan Hornburg <racke at linuxia.de> writes:
> >
> > > $Db{products}->query("select * from products where name =
'$CGI->{foo}'");
> > >
> > > => that's unsafe IMHO
> >
> > Just to clarify, if
> >
> > $GCI->{foo} = "'; delete from products;'"
> >
> > Then there could be problems. In this case, you should escape any
> > single quotes in $CGI->{foo}.
> >
> > [perl]
> > # racke says my perl is "rusty", so take this with a few grains of
sandpaper
> > my $foo = $Tag->filter('sql', $CGI->{foo});
> > my $ref = $Db{products}->query("select * from products where name =
'$foo'");
> > [/perl]
>
> With 5.0- you can do (AFAIK)
>
> $Db{products}->query("select * from products where name = %s",
$CGI->{foo});
>
> Ciao
> Racke
>
>
> --
> LinuXia Systems => http://www.linuxia.de/
> Expert Interchange Consulting and System Administration
> ICDEVGROUP => http://www.icdevgroup.org/
> Interchange Development Team
>
>
> ------------------------------
>
> Message: 28
> Date: Tue, 28 Oct 2003 08:12:13 -0800
> From: Anthony Minero <anthony at urbanscooters.com>
> Subject: [ic] Strange font error
> To: <interchange-users at icdevgroup.org>
> Message-ID: <BBC3D55D.8A07%anthony at urbanscooters.com>
> Content-Type: text/plain; charset="US-ASCII"
>
> Hello all,
> I recently had a customer that received a strange error when trying to
check
> out of the cart. They were getting "Invalid Font messages" when they
clicked
> on the final submit button.
>
> I am using style sheets as well as assigning fonts in html on this page.
>
> Has anyone heard of this error before??
>
>
> --
> Anthony Minero
> http://urbanscooters.com
> --
>
>
>
> ------------------------------
>
> Message: 29
> Date: Tue, 28 Oct 2003 11:11:12 -0500
> From: Mike Heins <mike at perusion.com>
> Subject: Re: [ic] Database Connection Concurrency/Exclusivity
> To: interchange-users at icdevgroup.org
> Message-ID: <20031028161112.GB8793 at bill.heins.net>
> Content-Type: text/plain; charset=us-ascii
>
> Quoting Todd L. Cawthron (todd at lunsfordgroup.com):
> > I'm running Interchange using a SQL database (Sybase to be exact).
Recently,
> > I ran into a situation where I wanted to use a transaction when deleting
and
> > then inserting rows into a table.
> >
> > I could stitch together a batch of SQL statements and send the batch as
a
> > single query, or I could use multiple queries. The batch would probably
be
> > the safest route, although it could be a problem if the batch was really
> > large.
> >
> > If I went the multiple query route, I would begin a transaction, run a
> > delete query, then a number of insert queries, and finally commit the
> > transaction. If I do this with a number of calls to the query tag (or by
> > using the underlying database handle directly), will I have any problems
> > running in pre-fork mode? In other words, will the interchange process
that
> > is running this subroutine always use the same database handle for each
call
> > and will it have exclusive use of this handle? Or, will other
interchange
> > processes potentially issue database commands using the same database
> > connection, which might result in queries being unintentionally included
in
> > my transaction?
>
> This should not be a problem. Unless you specify that the table is
> HOT, which is not the default, the same handle will not be used.
>
> You *will* have to specify
>
> Database foo HAS_TRANSACTIONS 1
>
> as we don't do that for Sybase.
>
> The rest should be just like in the other ones:
>
> [flag type=transactions table=foo]
> [query sql="insert into foo values (...)"]
> [query sql="update foo set ..."]
> [flag type=commit table=foo]
>
> The flag for transactions should always be in ITL, not in embedded
> perl. The rest can be in either.
>
> --
> Mike Heins
> Perusion -- Expert Interchange Consulting http://www.perusion.com/
> phone +1.513.523.7621 <mike at perusion.com>
>
> For a successful technology, reality must take precedence over public
> relations, for Nature cannot be fooled. -- Dick Feynman
>
> ------------------------------
>
> Message: 30
> Date: Tue, 28 Oct 2003 09:33:57 -0800
> From: Ed LaFrance <edl at newmediaems.com>
> Subject: Re: [ic] Receipt.html and URL Parameters
> To: interchange-users at icdevgroup.org
> Message-ID: <5.2.1.1.0.20031028090254.02c67518 at mail.newmediaems.com>
> Content-Type: text/plain; charset="us-ascii"; format=flowed
>
> At 05:17 PM 10/27/2003 -0700, you wrote:
> >A client of ours has enrolled in a real-time statistics engine that
supports
> >ecommerce transactions. So far we have been able to implement many of
their
> >coding requests for this tracking system.
> >
> >Part of the system tracking uses the URL. Specifically they want a URL
for
> >the Interchange Receipt page. This page is served up under the
Process.html
> >name after the credit card transaction.
> >
> >Because the Process.html URL is not unique to the Receipt page, it is
> >messing up their stats.
> >
> >I was thinking passing a URL parameter so that the URL parse would be
unique
> >(something like ...../process.html?finished=1). However, I can't figure
out
> >how to do it.
> >
> >Does anyone have any ideas how I might pass a URL parameter to/through
the
> >process.html?
> >
> >Or perhaps I am looking at this the wrong way. Is there another way I
could
> >approach this so that they can get a unique URL instead of Process.html?
> >
> >--------------------------------------------------------------------
> >Gary Norton
> >broadGap Technologies
>
> Gary -
>
> You really did not give enough info for anyone to be able to postulate a
> solution to your problem - there are dozens of ways these kinds of
programs
> do their thing, and without providing the specifics of yours, you've left
> people to guess. This is probably why you have not received an answer. I
> could think of many different ways something like this might work. Why
> don't you give your question another try, with some specific info as to
the
> mechanics of your portion of the tracking system.
>
> - Ed
>
>
> ===============================================================
> New Media E.M.S. Technology Solutions for Business
> 11630 Fair Oaks Blvd., #250 eCommerce | Consulting | Hosting
> Fair Oaks, CA 95628 edl at newmediaems.com
> (916) 961-0446 http://www.newmediaems.com
> (866) 519-4680 Toll-Free (916) 961-0447 Fax
> ===============================================================
>
>
> ------------------------------
>
> Message: 31
> Date: Tue, 28 Oct 2003 12:47:25 -0500
> From: Barry Newman <packet at tampabay.rr.com>
> Subject: [ic] Diff between Catagory and Product Group?
> To: interchange-users at icdevgroup.org
> Message-ID: <200310281247.25951.packet at tampabay.rr.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Hello! Could someone explain the diff between Catagoies and Product
group
> fields? Thanks in advance for your time!
>
> Barry Newman
>
> ------------------------------
>
> Message: 32
> Date: Tue, 28 Oct 2003 11:52:34 -0600
> From: "Hostmaster" <hostmaster at zipp.net>
> Subject: Re: [ic] EXCEL formating problems
> To: <interchange-users at icdevgroup.org>
> Message-ID: <015b01c39d7c$44f33180$65958f42 at sbcglobal.net>
> Content-Type: text/plain; charset="iso-8859-1"
>
>
> > > Finally, with regards to my original search, it appears that
> > > EXCEL will not
> > > retain any text formatting (such as "bold", or "italics") when
> > > imported into
> > > Interchange.
> >
> > HTML tags around the data that is suppossed to be bold or italic work.
> Thank you Jack. That did it for the text formatting. How easy, yet I
didn't
> know I could actually use html within an excel cell.
> Most gratefully,
> Michael G.
>
>
> ------------------------------
>
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>
> End of interchange-users Digest, Vol 4, Issue 28
> ************************************************
>
More information about the interchange-users
mailing list