Run SQL on form button and output result on page

Hi,

I have an asp page with a form.
A user enters a serial number in a text box.

I want to add a button next to the text box such as 'Check Serial' to
run some SQL in the background to see if that serial exists in the
table, and then output 'Serial found' or 'Serial Not Found' next to
the text box, so the user can decide whether to continue with the
form.


Appreciate your help.



Thanks


David

Re: Run SQL on form button and output result on page

"David" wrote in message
news:1176480364.542772.296270@y5g2000hsa.googlegroups.com...
> Hi,
>
> I have an asp page with a form.
> A user enters a serial number in a text box.
>
> I want to add a button next to the text box such as 'Check Serial' to
> run some SQL in the background to see if that serial exists in the
> table, and then output 'Serial found' or 'Serial Not Found' next to
> the text box, so the user can decide whether to continue with the
> form.
>

Have a look at the xmlhttpobject in javascript: www.w3schools.com/ajax

--
Mike Brind

Re: Run SQL on form button and output result on page

Using VB and ADO I have stored proc that checks for a value and give
the return value. And kicks off the event onBlur




onblur="vbscript:getId(WorkoutID.value)">

Re: Run SQL on form button and output result on page

xxshoexx@gmail.com wrote:
> Using VB and ADO I have stored proc that checks for a value and give
> the return value. And kicks off the event onBlur
>
>