|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today! |
|
#1
May 6th, 2008, 11:32 PM
|
|||
|
|||
|
Problem with IXMLDOMNode assignment from Recordset
Here is the code snippet
Code:
mynode.Attributes.getNamedItem("PRDID").nodeValue = RS("productname")
mynode.Attributes.getNamedItem("COLOR").nodeValue = RS("color")
mynode.Attributes.getNamedItem("SIZE").nodeValue = RS("size")
mynode.Attributes.getNamedItem("PRICE").nodeValue = RS("price")
mynode.Attributes.getNamedItem("ID").nodeValue = RS("id")
mynode.Attributes.getNamedItem("ITEMNUM").nodeValue = RS("itemnum")
mynode is decalred as IXMLDOMNode And I checked in the Immediate Window that RS is getting all the values from the stored procedure but when I run the program I get stopped at this line 'mynode.Attributes.getNamedItem("SIZE").nodeValue = RS("size") with the error "Object variable or With block variable not set" Does someone has any clues?
__________________
Contact info: Primary email: advanced.programmer@gmail.com MSN/email: superprg@hotmail.com AIM: superprg
|
|
#2
May 6th, 2008, 11:39 PM
|
||||
|
||||
|
are you sure "size" for each object is valid? put a breakpoint in that line and get the value for each object.
|
|
#3
May 7th, 2008, 12:37 AM
|
|||
|
|||
|
Get the value...sorry.....how?
|
|
#4
May 7th, 2008, 04:19 AM
|
||||
|
||||
|
Do you know how to put break point?
On the left side there is a vertical bar, click it. Here is the screenie it will look like this.  Run your program then it will stop at that breakpoint. Then point the cursor to the "size" then it will popup the value from the database. See if it matches or the value is null.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Problem with IXMLDOMNode assignment from Recordset |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
