[thelist] Pausing ASP script when no acces to SQL server

[Chris Dempsey]

Hi,

I require to pause an ASP script for around 1 second after doing a database
insert so I can grab the unique ID from the new record in an access database
using: SELECT MAX (itemID) AS maxID FROM tblItems"

If I don't pause the script I get the previous maxID.

I've seen suggestions for how to pause the script if an SQL database is
available or using a free component by ServerObjects called WaitFor 1.0.

I don't have an SQL database and the component no longer appears on
ServerObjects website.

To allow me to write the rest of the script I've added:

		dim i : i = 1

		do while not i = 999999
			i = i + 1
		loop

as a temporary measure.  Obviously I this whacks the processor usage up to
99% but only for about half a second [going by task manager set to update
every 0.5sec].

I know this is a botch so is there any other option available I've missed?
Or is this just about acceptable given that only 1 user will have access to
the script when it's on the live server and at most it will be run 5 times a
day?

Chris.

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Juan Manuel Lucero
Sent: 16 August 2006 12:44
To: thelist at lists.evolt.org
Subject: Re: [thelist] Ibox javascript problem

Hi Lee.
Actually, the problem was with the images. The name of the images was i.e.
"bigPicture.jpg" and the script seems not to recognize Caps. Weird...

Thanks,

Juan Manuel

-----Mensaje original-----
De: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org]
En nombre de Lee kowalkowski
Enviado el: martes, 15 de agosto de 2006 6:02
Para: thelist at lists.evolt.org
Asunto: Re: [thelist] Ibox javascript problem

On 15/08/06, Juan Manuel Lucero <listas at innovaestudio.com.ar> wrote:
> Hi,
>
> Test page is on http://www.semiosis.com.ar/inicio.htm
> I can see the black layer on top but it never loads the big image.
>
> Any ideas?

Ibox.js doesn't even parse on my machine.  You have this:

var strHTML = "{snip} src=\""images/+url+"\" {snip}";

I think should be: "src=\"images/" + url.

Using a good syntax highlighter would make this easier to spot.  Also, I
would have used single quotes for this string literal, so I didn't have to
escape all my double quotes, making it easier to read.

--
LK
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester and archives
of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! 

-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !