Ok,
Try the following. This works for me, all other routes seem to fall over :-(
- Use a "?" to substitute for each subroutine argument
- Create an ADODB parameter for each argument
- Set the value of the ADODB parameter
- Append that parameter to the command Parameters collection
NOTE: Using the ADODB.Command.CreateParameter does NOT seem to work with
UniOleDB.
Assuming that dbConn is an open UniOleDB connection, this calls a subroutine
SelectTitle (similar to the one I posted before) in VB - and should work the
same in VBScript:
Dim dbParam As ADODB.Parameter
Dim dbCmd As ADODB.Command
' Set the command to point to the SelectTitle subroutine
Set dbCmd = CreateObject("ADODB.Command")
dbCmd.ActiveConnection = dbConn
dbCmd.CommandText = "CALL SelectTitle(?)"
' Create an unnamed parameter to substitute.
Set dbParam = CreateObject("ADODB.Parameter")
dbParam.Type = adBSTR
dbParam.Value = Text1.Text
dbCmd.Parameters.Append dbParam
' Execute and display results. RecordCount is -1 if data is found.
Set dbRS = dbCmd.Execute
If dbRS.RecordCount <> 0 Then
dbRS.MoveFirst
Do
List1.AddItem dbRS.Fields("TITLE")
dbRS.MoveNext
Loop Until dbRS.EOF
End If
Hope this helps,
Brian
> This is exactly what I wantto do. However the VBScript syntax
> is where I'm getting stuck. How do I set the arguments... I
> know with uvobj sub calls you need to set the parameter
> values for the routine. I'm assuming the same is true here.
> But this is what I have :
>
> dim cnn
> set cnn = Server.CreateObject("ADODB.Connection")
> cnn.Provider = "IBM.UniOLEDB.1"
> dim dns
> dsn = "DATA SOURCE=localuv;LOCATION=test;USER
> ID=test;PASSWORD=test;"
> cnn.Open(dsn)
> dim rs, sql
> set rs = server.createobject("adodb.recordset")
> txtSubroutine = "MYSUB"
> SQL = "{CALL """ & txtSubroutine & "}"
> rc = cnn.Execute (SQL)
>
>
>
>
> but my sub has arguments that need to be passed. I'm sure I'm
> looking right at the answer and looking right over it.
>
> Vance
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
