Ole
|
| Posted: 09/06/2004, 3:01 AM |
|
Hello
I have a CCS-project generating ASP-code, and using MS SQL-server as database.
Due to some very complex queries in a grid, i need to raise the commandtimeout-valse before executing the query.
I need something like this:
Set objCommand = Server.CreateObject("ADODB.Command")
Set objCommand.ActiveConnection = strConnection
objCommand.CommandTimeout = 120
How can I do that from CCS ?
Best regards
Ole
|
|
|
 |
Tuong Do
|
| Posted: 09/07/2004, 11:32 PM |
|
I normally do it like this
Assume you have the connection call Connection1
<Code>
Dim myconnection
Dim SQL
SET myconnection = new clsDBConnection1
myconnection.CommandTimeOut = 1000
myconnection.open
SQL = "Insert into Customers (surname, firstname) Values ('SMITH', 'John')"
myconnection.Execute(SQL)
</Code>
"Ole" <Ole@forum.codecharge> wrote in message
news:6413c356a57cee@news.codecharge.com...
> Hello
>
> I have a CCS-project generating ASP-code, and using MS SQL-server as
> database.
>
> Due to some very complex queries in a grid, i need to raise the
> commandtimeout-valse before executing the query.
>
> I need something like this:
>
> Set objCommand = Server.CreateObject("ADODB.Command")
> Set objCommand.ActiveConnection = strConnection
> objCommand.CommandTimeout = 120
>
> How can I do that from CCS ?
>
> Best regards
>
> Ole
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
