DOH!!!!!Re: Script help please

[frostie2001uk]

changed the script to eliminate all the common non a-z characters eg:
, . - / \ still only some were being entered....

checked the monitor log looking for patterns actually thought it may
be the "." that was the problem if it was mid way though... ie
"sky
news." for the description was fine but "sky news. sky
weather"
wouldn't be....

anyway enough rambling.... the patterern was descriptions greater
than 50 characters....

I'd created a new table, changed each field to allow null values,
didn't change the default size from 50 to 128....

will run it overnight and see what happens.....

Doh,

Thanks
Neil

--- In <a
href="/group/ukha_xpl/post?postID=YjOGmx1SguUzfVQeRA6WK_RNvIqdXLKcQkpzp_syrtF6uDXx_pRPNXlMW9iIGvw2rgs87jj-EI0XfGpK89kR">ukha_xpl@xxxxxxx</a>,
steve.cooper@u... wrote:
>
> You can sometimes get away with replacing a single quote mark with
two
> single quote marks i.e ' with ''. The database then interrupts
this as
> just one when entering the data.
>
> Not sure if this will work with all database apps though.
>
> S.
>
>
> --------+----------------------->
>   "Tony Tofts"
>   <tony@xplhal.
>   com>
>
>   06/01/2004
>   11:37
>   Please
>   respond to
>   ukha_xpl
>
> --------+----------------------->
> >-----------------------------------------------------------------
-----------------------------------------------------
>


>  To:
<<a
href="/group/ukha_xpl/post?postID=YjOGmx1SguUzfVQeRA6WK_RNvIqdXLKcQkpzp_syrtF6uDXx_pRPNXlMW9iIGvw2rgs87jj-EI0XfGpK89kR">ukha_xpl@xxxxxxx</a>>

>
cc:

>  Subject: RE: [ukha_xpl] Script help
please

> >-----------------------------------------------------------------
-----------------------------------------------------
>
>
>
> > Is there anyway round this?
>
> In vbscript
>
> title=replace(title,"'","")
>
> Is one way
>
> If you can capture a sample message and mail to me, I can look if
there are
> other ways.
>
> Regards
> Tony
>
>
> xPL Links: <a href="http://www.xplproject.org.uk";>http://www.xplproject.org.uk</a>
<a href="http://www.xplhal.com";>http://www.xplhal.com</a>
> <a href="http://www.xpl.myby.co.uk";>http://www.xpl.myby.co.uk</a>
> To Post a Message: <a
href="/group/ukha_xpl/post?postID=YjOGmx1SguUzfVQeRA6WK_RNvIqdXLKcQkpzp_syrtF6uDXx_pRPNXlMW9iIGvw2rgs87jj-EI0XfGpK89kR">ukha_xpl@xxxxxxx</a>
> To Subscribe: <a
href="/group/ukha_xpl/post?postID=Eb7jt6n4Paqpfl7-grqxGSn3jdIGa2kxexckw84GxhCi5Grgj2zEBDP4KNHV4vA5LqxmD2yfebOHFRhPkyPD2dnEFJinTE4cuEvc5W8">ukha_xpl-subscribe@xxxxxxx</a>
> To Unsubscribe: <a
href="/group/ukha_xpl/post?postID=VmJSRmuNNIBvzg6YoBBCjuXeIXNaoCnVohw3c8NfaPdsworsjE-068fCSenYupKZfcBNVljeHoEIkZQ2qPYeVmx0mi9YjiJe_kE">ukha_xpl-unsubscribe@xxxxxxx</a>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> <a href="http://groups.yahoo.com/group/ukha_xpl/";>http://groups.yahoo.com/group/ukha_xpl/</a>
>
> To unsubscribe from this group, send an email to:
> <a
href="/group/ukha_xpl/post?postID=VmJSRmuNNIBvzg6YoBBCjuXeIXNaoCnVohw3c8NfaPdsworsjE-068fCSenYupKZfcBNVljeHoEIkZQ2qPYeVmx0mi9YjiJe_kE">ukha_xpl-unsubscribe@xxxxxxx</a>
>
> Your use of Yahoo! Groups is subject to:
> <a href="http://docs.yahoo.com/info/terms/";>http://docs.yahoo.com/info/terms/</a>
>
>
>
>
>
>
>
>
>
______________________________________________________________________
_____
> The information contained in this message is confidential and may
be
> legally privileged. If you are not the intended recipient, please
do not
> read, copy or otherwise use it and do not disclose it to anyone
else.
> Please notify the sender of the delivery error and then delete the
> message from your system.
> Any views or opinions expressed in this email are those of the
author only.
> Communications will be monitored regularly to improve our service
and for
> security and regulatory purposes.
> Thank you for your assistance.
>
______________________________________________________________________
_____