ASP ecommerce help

[Laphan]

Hi All

I seem to be getting to grips with the whole ASP DB ecommerce thing, but
there are certain aspects that my knowledge is really thin. If poss, could
you please advise or point me in the right direction re the below:

1) I use the getrows feature all the time now for recordsets rather than
doing a DO ... LOOP recurse of the records.

At present this works great with the data I'm working with, but is there a
possibility that a getrows call can hog resources to the point of the
collapse where a DO .. LOOP recurse will never cause this?

I'm not dealing with thousands of recs/rows, but I'd like to know if it is
the norm for devs to use the getrows over the old recurse.

2) Because I'm checking a cookie on every page of my site, I believe I have
to use the Response.Buffer = true on each page (right??). This seems to be
fine if my server isn't being hogged, but middle of the day and evening
traffic means that as there is a lot of ASP work to be done on my pages then
the Response.Buffer command can sometimes cause timeouts on my pages. Do I
have to use this command when using cookies and if so, whats the best way to
eliminate the timeout issue? I know this is pretty generic question, but I
want to get a feel for how you tackle this.

3) My final question may be more addressed to UK users as it deals with the
aspect of processing orders once they have been received on the secure
server. At the moment, the details are entered via a https page and stored
in a MySQL db, a notification email is sent to the merchant (no ccard
details sent), the merchant retrieves the order from the MySQL db via a
hidden https page, prints the order, processes it on their pdq and then
confirms that the order has been placed. This confirmation obliterates most
of the credit card details in the MySQL DB so that they cannot be retrieved
again.

I know WorldPay and SecureTrading offer a straight to the bank service, but
sometimes the goods might not be able to shipped so the merchant can be
constantly losing out if they have to credit a transaction whereby these
companies still take a % of the original inv and then the credit.

Can somebody advise me or point me in the direction of a forum/newsboard
where like-minded devs are doing this day-in day-out.

Thanks

Laphan

[Bob Barrows [MVP]]

Laphan wrote:

Hi All

I seem to be getting to grips with the whole ASP DB ecommerce thing,
but there are certain aspects that my knowledge is really thin. If
poss, could you please advise or point me in the right direction re
the below:

1) I use the getrows feature all the time now for recordsets rather
than doing a DO ... LOOP recurse of the records.

At present this works great with the data I'm working with, but is
there a possibility that a getrows call can hog resources to the
point of the collapse where a DO .. LOOP recurse will never cause
this?
No. Why do you have this doubt? Why do you think using DO...LOOP would use
fewer resources than GetRows?

I'm not dealing with thousands of recs/rows, but I'd like to know if
it is the norm for devs to use the getrows over the old recurse.
It's my normal technique.

2) Because I'm checking a cookie on every page of my site, I believe
I have to use the Response.Buffer = true on each page (right??).
Why? I don't recall buffering having anything to do with checking cookies.
This seems to be fine if my server isn't being hogged, but middle of
the day and evening traffic means that as there is a lot of ASP work
to be done on my pages then the Response.Buffer command can sometimes
cause timeouts on my pages.
When? Do you have a repro of a situation where a timeout will occur when
using buffering that will not occur when not using buffering?
Do I have to use this command when using
cookies and if so, whats the best way to eliminate the timeout issue?
I know this is pretty generic question, but I want to get a feel for
how you tackle this.

I don't do ecommerce, but I don't remember ever deliberately turning
buffering off.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[mark | r]

> 3) My final question may be more addressed to UK users as it deals with

the
aspect of processing orders once they have been received on the secure
server. At the moment, the details are entered via a https page and
stored
in a MySQL db, a notification email is sent to the merchant (no ccard
details sent), the merchant retrieves the order from the MySQL db via a
hidden https page, prints the order, processes it on their pdq and then
confirms that the order has been placed. This confirmation obliterates
most
of the credit card details in the MySQL DB so that they cannot be
retrieved
again.
we use an order status and use the database instead of a cookie to save a
cart, in this way you get better basket statistics so the shop owner can see
what items are added to the basket but never bought. it also helps if theres
a problem because you can backtrack the basket items to find out where the
system failed. mort thinngs you can do with this is an order processing
report for a shopper so they can see that the cc has been processed ready
for dispatch (we also have an "item sent" flag). you also get a running
total of all sales etc and other reports which is usefull stuff for when you
need to re-develop the system.

I know WorldPay and SecureTrading offer a straight to the bank service,
but
sometimes the goods might not be able to shipped so the merchant can be
constantly losing out if they have to credit a transaction whereby these
companies still take a % of the original inv and then the credit.
try www.protx.com if you do under 1000 sales a quarter its only £20 per
month flat fee with over this amount being only 10p per transaction, no
setup fees, no other monthly charges.
Can somebody advise me or point me in the direction of a forum/newsboard
where like-minded devs are doing this day-in day-out.

mark

[Jeff Cochran]

On Sat, 4 Sep 2004 14:32:30 +0100, "Laphan" <ne**@DoNotEmailMe.co.uk>
wrote:

1) I use the getrows feature all the time now for recordsets rather than
doing a DO ... LOOP recurse of the records.

At present this works great with the data I'm working with, but is there a
possibility that a getrows call can hog resources to the point of the
collapse where a DO .. LOOP recurse will never cause this?
Doesn't make much sense, GetRows consumes fewer resources, depending
on what you actually are coding inot your loop.
I'm not dealing with thousands of recs/rows, but I'd like to know if it is
the norm for devs to use the getrows over the old recurse.
Norm is to use the process appropriate to the task at hand. Which may
mena either one.
2) Because I'm checking a cookie on every page of my site, I believe I have
to use the Response.Buffer = true on each page (right??). This seems to be
fine if my server isn't being hogged, but middle of the day and evening
traffic means that as there is a lot of ASP work to be done on my pages then
the Response.Buffer command can sometimes cause timeouts on my pages. Do I
have to use this command when using cookies and if so, whats the best way to
eliminate the timeout issue? I know this is pretty generic question, but I
want to get a feel for how you tackle this.
Best is not to use cookies. :)
3) My final question may be more addressed to UK users as it deals with the
aspect of processing orders once they have been received on the secure
server. At the moment, the details are entered via a https page and stored
in a MySQL db, a notification email is sent to the merchant (no ccard
details sent), the merchant retrieves the order from the MySQL db via a
hidden https page, prints the order, processes it on their pdq and then
confirms that the order has been placed. This confirmation obliterates most
of the credit card details in the MySQL DB so that they cannot be retrieved
again.
You're still storing credit card data, whether for short time or
longer really isn't factor.
I know WorldPay and SecureTrading offer a straight to the bank service, but
sometimes the goods might not be able to shipped so the merchant can be
constantly losing out if they have to credit a transaction whereby these
companies still take a % of the original inv and then the credit.
Those are the choices to make in eCommerce.
Can somebody advise me or point me in the direction of a forum/newsboard
where like-minded devs are doing this day-in day-out.

How about simply using a commercial canned product to do this? One
that's proven over time and secure?

Jeff

[Roland Hall]

"Laphan" wrote in message news:41**********@127.0.0.1...
: 2) Because I'm checking a cookie on every page of my site, I believe I
have
: to use the Response.Buffer = true on each page (right??).

No, it is not required. However, if you want to put the cookie anywhere on
your page then Response.Buffer = True is required.
http://www.powerasp.com/content/code...ts/cookies.asp

This seems to be
: fine if my server isn't being hogged, but middle of the day and evening
: traffic means that as there is a lot of ASP work to be done on my pages
then
: the Response.Buffer command can sometimes cause timeouts on my pages. Do
I
: have to use this command when using cookies and if so, whats the best way
to
: eliminate the timeout issue? I know this is pretty generic question, but
I
: want to get a feel for how you tackle this.

Response.Buffer shouldn't cause timeouts. Define 'a lot of ASP work'.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

[Laphan]

Roland Hall <nobody@nowhere> wrote in message
news:ev**************@TK2MSFTNGP15.phx.gbl...
"Laphan" wrote in message news:41**********@127.0.0.1...
: 2) Because I'm checking a cookie on every page of my site, I believe I
have
: to use the Response.Buffer = true on each page (right??).

No, it is not required. However, if you want to put the cookie anywhere on
your page then Response.Buffer = True is required.
http://www.powerasp.com/content/code...ts/cookies.asp

This seems to be
: fine if my server isn't being hogged, but middle of the day and evening
: traffic means that as there is a lot of ASP work to be done on my pages
then
: the Response.Buffer command can sometimes cause timeouts on my pages. Do
I
: have to use this command when using cookies and if so, whats the best way
to
: eliminate the timeout issue? I know this is pretty generic question, but
I
: want to get a feel for how you tackle this.

Response.Buffer shouldn't cause timeouts. Define 'a lot of ASP work'.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp
Hi Guys

Thanks for the feedback.

With regard to mark's valued comments, I store most of the basket work in
the db, but in order for me to keep a track of whether the user is still
there (especially when moving between a secure site and a non-secure site
which are on different domains) is really hard without sessions and cookies.
In fact this part of my site brought me to tears trying to figure it out.

Rgds

Laphan

[Roland Hall]

"Laphan" wrote in message news:41**********@127.0.0.1...
:
: Roland Hall <nobody@nowhere> wrote in message
: news:ev**************@TK2MSFTNGP15.phx.gbl...
: "Laphan" wrote in message news:41**********@127.0.0.1...
:: 2) Because I'm checking a cookie on every page of my site, I believe I
: have
:: to use the Response.Buffer = true on each page (right??).
:
: No, it is not required. However, if you want to put the cookie anywhere
on
: your page then Response.Buffer = True is required.
: http://www.powerasp.com/content/code...ts/cookies.asp
:
: This seems to be
:: fine if my server isn't being hogged, but middle of the day and evening
:: traffic means that as there is a lot of ASP work to be done on my pages
: then
:: the Response.Buffer command can sometimes cause timeouts on my pages. Do
: I
:: have to use this command when using cookies and if so, whats the best way
: to
:: eliminate the timeout issue? I know this is pretty generic question, but
: I
:: want to get a feel for how you tackle this.
:
: Response.Buffer shouldn't cause timeouts. Define 'a lot of ASP work'.
:
: --
: Roland Hall
: /* This information is distributed in the hope that it will be useful, but
: without any warranty; without even the implied warranty of merchantability
: or fitness for a particular purpose. */
: Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
: WSH 5.6 Documentation -
http://msdn.microsoft.com/downloads/list/webdev.asp
: MSDN Library - http://msdn.microsoft.com/library/default.asp
:
:
: Hi Guys
:
: Thanks for the feedback.
:
: With regard to mark's valued comments, I store most of the basket work in
: the db, but in order for me to keep a track of whether the user is still
: there (especially when moving between a secure site and a non-secure site
: which are on different domains) is really hard without sessions and
cookies.
: In fact this part of my site brought me to tears trying to figure it out.
:
I'm using cookies to track the user.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp