[thelist] Shopping Sites, Credit Cards

[Kathy Long]

>
>> B of A to get the facts.
>
>> They do NOT make cc numbers available to their vendors.
>> They are NOT visible or available in the sales history screen - the only
>> thing the merchant can see there is the type of credit card number used.
>> They DO keep credit card numbers in THEIR system accessible by B of A only.
>
> Interesting. I checked with three associates who run their own gateways and
> have merchant accounts with 3 different acquirer banks. Their response was
> that they always get the numbers on their merchant account statements from
> the banks. So this is something else to look for.

Not here. B of A does not make cc numbers available to us at all on the
statement, online, or by phone. I just spoke to a client of ours who uses
Authorize-net and it's the same thing for him. No credit card numbers
available to him at all, and he's the one who really tried to get them. If I
recall, his merchant account is with B of A, so perhaps this is a B of A
specific thing.

I'd like to know what gateways your associates use. Due to the very good
reasons you gave regarding security and employee theft, I probably won't
recommend them.


Kathy
>
>
>
> Keith
> ====================
> cache at dowebscentral.com
>
>
> --__--__--
>
> Message: 32
> Date: Mon, 1 Jul 2002 22:05:48 -0400
> To: thelist at lists.evolt.org
> From: Morbus Iff <morbus at disobey.com>
> Subject: Re: [thelist] June 2002 stats for evolt.org
> Reply-To: thelist at lists.evolt.org
>
>> Top Referrers
>> disobey.com - 2562
>
> Whoo, whoo!
>
> --
> Morbus Iff ( shower your women, i'm coming )
> Culture: http://www.disobey.com/ and http://www.gamegrene.com/
> Tech: http://www.oreillynet.com/pub/au/779 - articles and weblog
> icq: 2927491 / aim: akaMorbus / yahoo: morbus_iff / jabber.org: morbus
>
> --__--__--
>
> Message: 33
> From: "rudy" <r937 at interlog.com>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] text keys in MySQL
> Date: Mon, 1 Jul 2002 23:20:44 -0400
> Reply-To: thelist at lists.evolt.org
>
>> SELECT artid,faqid,title,content,
>> match (title,content) against ('XYZ') as relevance
>> FROM faqcont
>> WHERE
>> match (title,content) against ('XYZ')>0
>> HAVING relevance>0
>> ORDER BY relevance DESC
>
> chris, i've never seen this type of sql before, but HAVING is usually
> associated only with GROUP BY -- try pulling the HAVING clause out and see
> what you get
>
> i just looked up this syntax in the online mysql docs, and it looks pretty
> spiffy
>
> apparently you can just say WHERE MATCH() AGAINST() without the greater
> than zero test, because it will default to that
>
> the docs also say the results are returned in relevance sequence
>
> rudy
>
>
> --__--__--
>
> Message: 34
> From: "rudy" <r937 at interlog.com>
> To: <thelist at lists.evolt.org>
> Subject: Re: [thelist] text keys in MySQL
> Date: Mon, 1 Jul 2002 23:24:10 -0400
> Reply-To: thelist at lists.evolt.org
>
> the docs also have this comment added by a user --
>
> "Note: you should add at least 3 rows to the table before you try to match
> anything, and what you're searching for should only be contained in one of
> the three rows. This is because of the 50% thereshold. If you insert only
> one row, then now matter what you search for, it is in 50% or more of the
> rows in the table, and therefore disregarded."
> http://www.mysql.com/doc/F/u/Fulltext_Search.html
>
> rudy
>
>
>
> --__--__--
>
> Message: 35
> Date: Mon, 01 Jul 2002 20:26:49 -0700
> To: thelist at lists.evolt.org
> From: Anthony Baratta <Anthony at Baratta.com>
> Subject: Re: [thelist] text keys in MySQL
> Reply-To: thelist at lists.evolt.org
>
> At 06:03 PM 7/1/2002, Christopher Joseph wrote:
>
>> am trying to build a boolean search over mysql using php. Think the php is
>> OK but the SQL doesn't seem to be returning any records.
>>
>> this is the query -->
>>
>> SELECT artid,faqid,title,content,
>> match (title,content) against ('XYZ') as relevance
>> FROM faqcont
>> WHERE
>> match (title,content) against ('XYZ')>0
>> HAVING relevance>0
>> ORDER BY relevance DESC
>
> First off, according to the documentation your Match statement is a bit
> "wrong". There is no need to have > 0 with the Match() Against() nor the
> Having relevance > 0.
>
> e.g.
>
> SELECT * FROM articles
> WHERE MATCH (title,body) AGAINST ('database');
>
> http://www.mysql.com/doc/F/u/Fulltext_Search.html
>
> Also the docs say this:
>
> -=-=-=-=-=-=-=-=-=-=
>
> "MySQL uses a very simple parser to split text into words. A ``word'' is
> any sequence of characters consisting of letters, numbers, `'', and `_'.
> Any ``word'' that is present in the stopword list or is just too short (3
> characters or less) is ignored.
>
> Every correct word in the collection and in the query is weighted according
> to its significance in the query or collection. This way, a word that is
> present in many documents will have lower weight (and may even have a zero
> weight), because it has lower semantic value in this particular collection.
> Otherwise, if the word is rare, it will receive a higher weight. The
> weights of the words are then combined to compute the relevance of the row.
>
> Such a technique w