v_progkey = "1" GetProg = "Select * from programs where rtrim(ltrim(progrm_key)) = '"+v_progkey+"'" dbobj = createobject("ADODB.Connection") dbobj.open("DATABASE=PROGLIB;DSN=DDHELP;UID=someone;PWD=;") Prog = dbobj.execute(GetProg) stepkeyval = Prog.Fields("steps_key").value ? Prog.Fields("progdesc").value ? "Criteria:" ? ltrim(Prog.Fields("condition").value) ? ltrim(Prog.Fields("objective").value) ? ltrim(Prog.Fields("criteria").value) ? ltrim(Prog.Fields("domain_key").value)When I execute this code.. All lines below '? "Criteria:"' fail. IF I remove the line 'stepkeyval = Prog.Fields("steps_key").value' it works again. I also tried building multiple recordsets and when I do that it fails as well.
progdesc - char - 35 - nulls=Yes condition - varchar - 66 - nulls=Yes objective - varchar - 66 - nulls=Yes criteria - varchar - 66 - nulls=Yes domain_key - char - 6 - nulls=YesI've changed the fields from varchar to char and back again. The reason I'm using ADO is for portability. I may want to reuse this code in another language later (VB, ASP, etc..) and the code for all the should be pretty similar. Can anyone give me any info on what I'm doing wrong? or is ADO broke? TIA!!