|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 12th, 2009, 11:57 AM
|
|||
|
|||
|
Assigning parameters for ADODB Command object
I'm curious about assigning parameters to an ADODB command object and maybe someone could explain why one of the two methods below works and the other doesn't. I can't seem to determine the difference really between these two.
Example 1 works: Code:
set objParam1 = thecommand.createparameter("p_MsgHostname",200,1,255,peer_ip)
thecommand.Parameters.Append objParam1
The above example will append the variables. The below example will give the error: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Example 2 does not work: Code:
set param = thecommand.Parameters
param.append thecommand.createparameter("p_MsgHostname",200,1,255,peer_ip)
thecommand.parameters.append param
Thanks for any help on this, Curt
|
|
#2
May 12th, 2009, 11:18 PM
|
|||
|
|||
|
I dunno, but if it helps here's a link to the reference for the Parameters collection that you're trying to append to in your 2nd example. There are links to example code for vbscript.
http://msdn.microsoft.com/en-us/lib...564(VS.85).aspx
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Assigning parameters for ADODB Command object |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
