ASP/VBS Using Command to Insert/Update/Delete

[Sanjay]

Hi,

I would just like to know when/why etc would you command and if there any
penalties in using the command.

Thanks,

Sanjay

[Chris In Madison]

The Command object is great when you need to send a query to the database or
need to execute a stored procedure and don't expect any data in return,
unlike the Recordset object which returns something even if there's no data
to return. Very efficient.

Best regards,
Chris

[Sanjay]

Thanks Chris,

must start using this!

Regards,

Sanjay

"Chris In Madison" <cowens@cnwGOAWAYDIRTYRATSPAMMERS.com> wrote in message
news:d43u6v$c1o$1@forums.macromedia.com...

> The Command object is great when you need to send a query to the database

or

> need to execute a stored procedure and don't expect any data in return,
> unlike the Recordset object which returns something even if there's no

data

> to return. Very efficient.
>
> Best regards,
> Chris
>
>