Hi

does anyone know if there is a limit to the number of variables you are

allowed to include in a single SQL statement?

Thanks

Kat

<conjecture>

I don't think there'd be an ADO limit since the SQL statement is passed

verbatim to the database engine. The limit would thus be determined by the

particular database that you were using...

</conjecture>



Cheers

Ken



----- Original Message -----

From: "Kat Howlett" <kat.howlett@c...>

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, October 12, 2000 5:10 PM

Subject: [asp_databases] SQL VAriable limit





>

> Hi

> does anyone know if there is a limit to the number of variables you are

> allowed to include in a single SQL statement?

> Thanks

> Kat