ASP ecommerce help

External Since: Oct 22, 2003 Posts: 35

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

External Since: Aug 13, 2003 Posts: 257

On Sat, 4 Sep 2004 14:33:51 +0100, 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?
>
> 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.

You're better off posting this at one of Microsoft's newsgroups where many
helpful ASP experts gather, such as
microsoft.public.inetserver.iis.activeserver. Your news source should
provide it.

Go to <a style='text-decoration: underline;' href="http://www.aspin.com" target="_blank">www.aspin.com</a> and check out links to communites.

--
Karim
<a style='text-decoration: underline;' href="http://www.cheapesthosting.com" target="_blank">http://www.cheapesthosting.com</a> - Receive 98% spam free emails