RE: RE: RE: RE: Re: loop criteria not accessable in loop??

Ahh, you mean "blank" when you say "undefined". That's why I asked. Because a blank would not be legal in your SQL syntax. That's why you should use DBI and DBI's placeholders instead of doing it the hard-to-diagnose way.

And that's also why I asked you what "undefined" meant. Because I never would have guessed that you meant "blank". {grin}
footnote:
Ahh, being a customer support person. It's all coming back to me now about why I usually don't do this kind of stuff for free.

Well, I agree with the others in this thread, and what people are telling you in the chatterbox as I type this: You need to get a small example of what isn't working, and post that. Because the small snippets you are posting are working just fine.

-- Randal L. Schwartz, Perl hacker

Comment on RE: RE: RE: RE: Re: loop criteria not accessable in loop??

Replies are listed 'Best First'.
RE: RE: RE: RE: RE: Re: loop criteria not accessable in loop?? by jptxs (Curate) on Aug 16, 2000 at 20:42 UTC
the fun part is that all this worked fine not too long ago, i haven't touched in a week, i come bakc and it's broke... all i was looking for was that what i did have should work because i was breaking my brain going over and over it. I'll start looking further up the chain to see where it could be. There are five layers in this app: Perl, Java, Javascript, DBI and Oracle. it could be anywhere... thanks for the input, sorry to be so dense	[reply]
RE: RE: RE: RE: RE: RE: Re: loop criteria not accessable in loop?? by merlyn (Sage) on Aug 16, 2000 at 20:46 UTC
Ahh.. it's definitely in the Java or Javascript then. I'd look there first. {ducking...} -- Randal L. Schwartz, Perl hacker	[reply]
RE: RE: RE: RE: RE: RE: RE: Re: loop criteria not accessable in loop?? by jptxs (Curate) on Aug 16, 2000 at 20:55 UTC
actually, just found it. it's in someone else's code :) there's another guy writing the admin piece for this and in the program to enter in people (sc's) he has not been chomping the values going into Oracle. So there was a space coming out of the database, which my chomp of course does not truncate since it's not that kind of char and then when i go to split on space first to produce \| sep records which i split on \|, i end up with records of the wrong length and then generate a hash by setting arrays of diff lenths equal to one another, which is a problem :)	[reply]