Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Assigning a field within rs to another variable.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-08-24 : 19:29:40
Isa writes "I execute an SQL statement at the top of my page.

mySql = "SELECT CorrectiveActionID, ProjectID where CorrectiveActionId = 1"
set rs = server.createobject("adodb.recordset")
rs.open mysql, conn

I want to assign ProjectID to another variable within in vbscript, how do I do that?"

   

- Advertisement -