<div>
that's awesome - thanks chanito
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I've got an activex script that emails orders out to suppliers. &nbsp;They need to receive the data in a particular format - and need some field lengths to be a particular size... the problem i'm having is if i use this code....<br />
&nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; elseif x.name = &quot;title&quot; then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strLine= strLine &amp;&nbsp;chr(34) &amp;&nbsp;left(x.value,4) &amp;&nbsp;chr(34) &amp;&nbsp;chr(44)<br />
<br />
and the title field is nchar then i get a field entry of &quot;MR &nbsp;&quot;, &nbsp;(which is right) but if the title field is varchar i get &quot;MR&quot;, &nbsp;(which is wrong)<br />
<br />
Does anyone know how why this happens or if I can get around it without changing all my database fields?<br />
<br />
Many Thanks,
</div>
</div>


Hi Experts,

I've got an activex script that emails orders out to suppliers.  They need to receive the data in a particular format - and need some field lengths to be a particular size... the problem i'm having is if i use this code....
 
          elseif x.name = "title" then
          strLine= strLine & chr(34) & left(x.value,4) & chr(34) & chr(44)

and the title field is nchar then i get a field entry of "MR  ",  (which is right) but if the title field is varchar i get "MR",  (which is wrong)

Does anyone know how why this happens or if I can get around it without changing all my database fields?

Many Thanks,

DTS ActiveX VBScript varchar problem

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.