Search results for query: *

Thanks for your replies, very useful indeed

Thanks for your help. I'm actually trying to get away from hardcoding this in. Basically there is a table in Oracle with vbCrLf and xml with this in it is read by vb. I can hardcode in that "vbCrLf" gets replaced by vbCrLf but there will be other similar constants and I don't want to have to...

I can't I'm reading this from an xml attribute and it reads it as a string

I have a string markExists = "vbCrLf" which I want to use in the following: markExists & "freddy mercury" & markExists But this displays as vbCrLffreddymercuryvbCrLf. How can I make this display as carriage return line feed. Basically making string into vbCrLf constant.

Thanks for your posts which were better than my cheat of replacing the comma with a number for the purpose of testing. I did do an advanced search but obviously searched on words which didn't register. thanks again.

I have a string sText. sText.search(/^\d+\.\d\d$/) I was using the above to check that a field (value=sText)has the format #.## which works very well. I now need to amend this to allow only 0-9 and format .## (as above) and also to allow commas to be input. I don't need to check that the...

Here is the code. PROCEDURE GetPhrases(pXMLin VARCHAR2,pXMLout OUT VARCHAR2)IS /* <availablephrases> <PHRASES> <PHRASE id=x userinput=y> <DESC/> <APPENDAGES> <PHRASE id=x> <DESC/> </PHRASE> <EXCEPTIONS> <PHRASE id=x> <DESC/> </PHRASE> </PHRASE> </PHRASES>...

I really don't think it's a vb problem. I really think it's a oracle problem, as I have had strings longer than this coming into vb where there isn't this problem. I think because I can stipulate the size of the output when in the sql window this is overcoming the problem.

I've realised the problem isn't as simple as I thought. I have an oracle package with parameters in and out as follows: PROCEDURE GetPhrases(pXMLin VARCHAR2,pXMLout OUT VARCHAR2) etc If I run this in sql window and stipulate the size of the input and output at 30000 then there is no problem...

I have some pl/sql which is falling over, I think because the size of the string is too long. The string xml and the number of chars is 5155. If I take off about 1270 chars it works fine. Is there a way I can estimate the byte size. I know the limit for bytes is 32672, but is there an approx...

I've managed to solve my problem. <xsl:template match="BALANCES/data"> <xsl:variable name="counter"> <xsl:value-of select="position()"/> </xsl:variable> <xsl:if test="$counter&lt;=2"> <tr> <td width="25%" valign="top" class="small" align="right"> <b> <xsl:value-of select="CLASS/BALANCE"/> </b>...

My xml is as follows: <BALANCES> <data> <recno>1</recno> <CLASS> <TYPE>C</TYPE> <CODE>70</CODE> <DESCRIPTION>UNKNOWN</DESCRIPTION> <ISIN/> <BALANCE>1066.0000</BALANCE> <REGNDATE>25-FEB-2003</REGNDATE> <PUBLICVIEW>Y</PUBLICVIEW> </CLASS>...

I want to create an attribute for an input box as follows <xsl:attribute name="onBlur">JAVASCRIPT:checkFieldValidation({@id}, {$minlen})</xsl:attribute> This javascript works if I just have an input box, but for various reasons I need to split the element down into attributes. Can anyone help...

Trust me I do need to escape this. I'm using xsl. \, doesn't work

I can't change any of the following so I need to escape the comma. Any ideas how to do this? I know for ' it's \'. addComp('T22', 'freddy,asdf bob\'s asdf') function addComp(code,name) { sComps+=code+','+name+','; } Thanks for your help.

Cheers

function getCoordinates(inputBoxName) { var newX=findPosX(form1.txtEffectiveDate) var newY=findPosY(inputBoxName) } function findPosX(obj) { ...... } If I type in form1.txtEffectiveDate then it accepts it as an object. If I get this as a parameter "inputBoxName" it doesn't treat it as an...

Can anyone tell me what is wrong with the syntax I've used. The error comes up where marked ******* DECLARE CURSOR f_merge_data is SELECT ftc_merge_field_id, mf_merge_field_tag, mf_merge_prompt FROM free_text_control, merge_fields WHERE ftc_doc_id = '30' AND ftc_merge_field_id =...

Thank you all for taking the time. Worked wonderfully.

I am using xml to get {@id}, and xsl to display a page. <select name=&quot;zx&quot; id=&quot;zx&quot; onchange=&quot;JAVASCRIPT:showField('zx')&quot;> The above works in my function. The following doesn't <select name=&quot;{@id}&quot; id=&quot;{@id}&quot...