Remote Scripting vs XMLHttp: Validating field without submitting a form.

[CJM]

I have a form where I want to be able to validate a field against a DB
*before* the form has been submitted.

After doing a bit of homework, it seems there are two general approaches:

1) Remote Scripting [using RSExecute/RSGetASPObject]
2) Using XMLHTTP/XMLDOM objects

I have no experience with either, so I though I'd see what my peers are
using.

Does anybody have any suggestions/preferences? Any good code examples?

Thanks

Chris

[Bob Barrows]

CJM wrote:

I have a form where I want to be able to validate a field against a DB
*before* the form has been submitted.

After doing a bit of homework, it seems there are two general
approaches:

1) Remote Scripting [using RSExecute/RSGetASPObject]
2) Using XMLHTTP/XMLDOM objects

I have no experience with either, so I though I'd see what my peers
are using.

Does anybody have any suggestions/preferences? Any good code examples?

Thanks

Chris

Remote Scripting is pretty dead. It was a PITA to implement.

In an intranet environment, xmlhttp has proved very useful to me, but,
depending on the amount of data that needs to be validated against, there
are other approaches possible via xml. Here's a couple ideas:
http://www.davidpenton.com/testsite/tips/

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[CJM]

"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:ur**************@TK2MSFTNGP12.phx.gbl...

Remote Scripting is pretty dead. It was a PITA to implement.

In an intranet environment, xmlhttp has proved very useful to me, but,
depending on the amount of data that needs to be validated against, there
are other approaches possible via xml. Here's a couple ideas:
http://www.davidpenton.com/testsite/tips/

Bob Barrows

Bob,

If I've digested your code correctly, the asp creates a recordset contain
the whole dataset, which is then displayed when the button is pressed.

This is not really a solution to my problem; my dataset is toolarge for
this - I need to query the DB AFTER the page is sent to the client. I just
need to confirm that the value entered by the user is a valid key on in a
particular table.

I have two examples of code that would/should work (as I explained before).
I take your point about Remote Scripting, but the XMLHTTP solution looks
like it is a PITA as well!

I'll wait a day or so for any further replies, but after that I'm going to
have to bite the bullet and pick one of these two nightmare beasts!

Thanks anyway

Chris
I've heard tha

[Bob Barrows]

CJM wrote:

"Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message
news:ur**************@TK2MSFTNGP12.phx.gbl...

Remote Scripting is pretty dead. It was a PITA to implement.

In an intranet environment, xmlhttp has proved very useful to me,
but, depending on the amount of data that needs to be validated
against, there are other approaches possible via xml. Here's a
couple ideas: http://www.davidpenton.com/testsite/tips/

Bob Barrows

Bob,

If I've digested your code correctly, the asp creates a recordset
contain the whole dataset, which is then displayed when the button is
pressed.

This is not really a solution to my problem; my dataset is toolarge
for this -

That's why I said it depends on how large the dateset is.

I need to query the DB AFTER the page is sent to the client. I just need to confirm that the value entered by the user is
a valid key on in a particular table.

I have two examples of code that would/should work (as I explained
before). I take your point about Remote Scripting, but the XMLHTTP
solution looks like it is a PITA as well!

Actually, it isn't. As long as the clients are using IE5.5 or higher, there
is nothing to set up on the client machines.

Aaron has a few examples on the aspfaq site. They do not appear to be too
intimidating to me, but then again, I've been using it for months. The most
intimidating part was learning to navigate the xmldom.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.