Hi Sharon
Anyway, several times when
> retrieving the questions, there is html code showing up as a question.
> The
> code is usually the error that has occurred.
What is the error message???? If it is a SQL Server or ASP error message
then the ASP page should be doing its own error checking and returning a
"known error message" to your Director App. That way you can take the
contents of the returned Text and check for that "known" error message and
respond accordingly ie.. not show the "invalid" content.
> My client, who is also a programmer (in authorware), has suggested the
> concept of a variable leak from director to the asp page. I am passing
> the
> information using the postNetText command, with a property list used to
> send the information.
I have no idea what your client is referring to as a "Variable Leak"...
unless he is somehow referring to a previous instance of the getNetText
being confused with the current instance of getNetText but I have my doubts
on that. Your client might be the best one to explain in English what he/she
is actually referring to.
> I use the watcher window and see that director is sending the
> appropriate
> values for each variable,
> BTW, the gentleman programming the asp page, and the stored procedure
> has
> now reprogrammed his page to display the error and the variables values
> when it happens. The values I send are being received correctly.
If you are sending the correct data, and the ASP page is recieving the
correct info, then I have a gut feeling that the stored proceedure and or
the ASP page is the source of the error. You might want to sit down and
write a routine that shows the return value coming back (other than your
field or text member) that displays the value in a legible form. My gut says
that the SP or ASP is the source of your problem and that you won't be able
to fix it from Director's end other than to capture the invalid return
result and handle it appropriately. Again the real information is what comes
back out of the database.. the asp page should be checking the values for
"validity" when it recieves your request especially for correct dataType ie.
string, string length, integer etc... before passing the info to the SQL SP
as SQL has very little sense of haha when it recieves invalid dataTypes. I'd
be telling the ASP programmer to do some error checking to see if what
he/she is recieving from you is valid.
As far as I can tell, once you send the GetNetText message, the data being
sent is completely and wholey disconnected from the Director until a return
result is sent back so Director has really no way to adjust the data ... its
an html request.. a piece of text sent out. So again I have no idea what he
is referring to as a "variable leak".
Hope this helps a little
Sincerely
Mark R. Jonkman
[To remove yourself from this list, or to change to digest mode, go to
http://www.penworks.com/LUJ/lingo-l.cgi To post messages to the list,
email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED])
Lingo-L is for learning and helping with programming Lingo. Thanks!]
