If rXML.documentElement.selectNodes("Fare").Item(0).s electNodes("fType").Item(0).Text = "NET" Then
adultFareLine = rXML.documentElement.selectNodes("AdultFareLine"). Item(0).Text
childFareLine = rXML.documentElement.selectNodes("ChildFareLine"). Item(0).Text
infantFareLine = rXML.documentElement.selectNodes("InfantFareLine") .Item(0).Text
con.Execute ("update trip_cost set adult_fare_line = '" & adultFareLine & "' where trip_id = '" & tripid & "'")
End If

Can anyone tell me why this code is not working? Syntax problems?

Picco

www.crmpicco.co.uk

__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk

If trip_id is a number, then change the last where to

& "' where trip_id = " & tripid)


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division