MS SQL Server cursore dinamico

sub getFromDatabase(mySQL, rsTemp, scriptName)

call openDb()

set rsTemp = server.createObject(“adodb.recordset”)

rsTemp.cursorLocation = adUseClient

‘ set locktype

rsTemp.lockType = adLockReadOnly

‘ set the cursor

rsTemp.cursorType = adOpenDynamic

rsTemp.open mySQL, connTemp

‘if err.number <> 0 then

‘ response.redirect “comersus_supportError.asp?error=”&Server.Urlencode(“Error in ” &scriptName& “, error: “&Err.Description& ” – Err.Number:”&Err.number&” – SQL:”&mySQL)

‘end if

end sub

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: