Variable not passing to sql - code attached

[gcole]

I am having trouble passing a variable to a SQL statement.
The address of the window is "

http://gcole/woedit/WOedit.asp?WOnum=1582a".

I need the 1582a in an sql statment. This is my code:

<script LANGUAGE=&quot;JavaScript&quot; RUNAT=&quot;server&quot;>
function _initrstWO()
{
//get address variable
var m_wo = request(&quot;wonum&quot
var DBConn = Server.CreateObject('ADODB.Connection');
DBConn.ConnectionTimeout = Application('ConnWO_ConnectionTimeout');
DBConn.CommandTimeout = Application('ConnWO_CommandTimeout');
DBConn.CursorLocation = Application('ConnWO_CursorLocation');
DBConn.Open(Application('ConnWO_ConnectionString'),
Application('ConnWO_RuntimeUserName'),
Application('ConnWO_RuntimePassword'));
var cmdTmp = Server.CreateObject('ADODB.Command');
var rsTmp = Server.CreateObject('ADODB.Recordset');
cmdTmp.ActiveConnection = DBConn;
rsTmp.Source = cmdTmp;
cmdTmp.CommandType = 1;
cmdTmp.CommandTimeout = 30;
//pass m_wo to sql
cmdTmp.CommandText = 'SELECT calls.*, workorderNum AS wo1 FROM calls WHERE
workorderNum = &quot; & m_wo & &quot; ;'
rsTmp.CacheSize = 100;
rsTmp.CursorType = 3;
rsTmp.CursorLocation = 3;
rsTmp.LockType = 3;
rstWO.setRecordSource(rsTmp);
rstWpen();

Is my problem with the variable passed to the form or the sql code?
Thanks,
Gail [sig][/sig]

 

[gcole]

This problem has been solved. [sig][/sig]