craigs052998
asked on
error in return code
when this line is ran it quits after the space in the item being returned(cursor.AGNT_ADDRE SS). so if "Billings Street" is in the database "Billings" is the only thing printed in the box. any ideas ??
TIA
<SERVER>
write("<TD WIDTH=240><INPUT id=FormsEditField2 TYPE=text NAME=address1 VALUE="+escape(cursor.AGNT _ADDRESS)+ "
SIZE=30 MAXLENGTH=30></TD>");
</SERVER>
TIA
<SERVER>
write("<TD WIDTH=240><INPUT id=FormsEditField2 TYPE=text NAME=address1 VALUE="+escape(cursor.AGNT
SIZE=30 MAXLENGTH=30></TD>");
</SERVER>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The E.E. server does some quote stripping of its own..
the line of code I sent should read:
.address1 VALUE=" + " <singlequotehere> "+cursor.AGNT_ADDRESS + " <singlequotehere> " + " SIZE=30 ...
I hope that's legible.. :)
-iDT
the line of code I sent should read:
.address1 VALUE=" + " <singlequotehere> "+cursor.AGNT_ADDRESS + " <singlequotehere> " + " SIZE=30 ...
I hope that's legible.. :)
-iDT
ASKER
adding the single quote did it
Hi Craigs,
This is very unfair, I send u the same answer and u accepted idt's answer. Please read my comment if u have time to do so.
Best Of Luck...
This is very unfair, I send u the same answer and u accepted idt's answer. Please read my comment if u have time to do so.
Best Of Luck...
ASKER
I went with who answered it first not as a comment. In the past I had problems with people taking one persons comment and answering it as theirs. So I give the points to the first one to answer it, not comment it, and have to refuse and reopen the the first one that did it as a comment. That sounded confusing but I think you got the idea.
And yes yours did the same thing
And yes yours did the same thing
Sorry MagicJ, when I read your comment I really thought you misunderstood his question and thought the escape() function contributed to his problem.
I know it is frustrating when an answer seems to be posted as an end run.
regards
-iDT
I know it is frustrating when an answer seems to be posted as an end run.
regards
-iDT
<SERVER>
write("<TD WIDTH=240><INPUT id=FormsEditField2 TYPE=text NAME=address1 VALUE='" + cursor.AGNT_ADDRESS + "'
SIZE=30 MAXLENGTH=30></TD>");
</SERVER>
escape() function will just replace all the occurences of special chars by it's Hex equivalent. In the text box u don't want a hex char to be seen. Try putting a single quote before and after the string as shown above and let me know.
Best of Luck