Re: query

On Sun, 4 Dec 2005 22:46:02 -0800, Tiffany wrote:

>Hi Hugo,
>
>I tried the script but it only remove the hyphen in some models but not all.
>Is there a full proof way?

Hi Tiffany,

I'm not sure what "script" you tried, since I posted only a partial
suggestion that you have to complete yourself. For further
trouble-shooting, I can only repeat what I wrote in my original reply:

If that's not what you want, then please check out www.aspfaq.com/5006,
an excellent description of what information you need to provide if you
want to help us help you.

>Also, sometimes, i have models that have more than one hypen. e.g.
>abc-ded-123-dvd

How do you want to handle these? If you want to remove all hyphens, then
stick with the REPLACE I suggested. If you want to remove only some of
them, then you'll first have to explain me how to decide which hyphens
should go and which should stay. I can then try to translate your
requirements into SQL.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.

Relevant Pages

  • Mod_rewrite/PHP problem driving me crazy!!
    ... Trying to convert a script to use friendly URLs, ... but my PHP skills are basic so I'm not great at PHP. ... So the rules work until I try to use hyphens! ... The data is from a CSV file with typ representing the type of product ...
    (alt.internet.search-engines)
  • Problem with mod_rewrite and replacing spaces in URL
    ... I'm trying to convert a script to use friendly URLs, ... before, but my PHP skills are quite basic so far, far from proficient ... function text2url($string){ ... It converts spaces to hyphens, but within a browser it fails. ...
    (alt.php)
  • Problem with mod_rewrite and replacing spaces in URL
    ... I'm trying to convert a script to use friendly URLs, ... but it's not the format I want and there are other characters I'd like ... function text2url($string){ ... It converts spaces to hyphens, but within a browser it fails. ...
    (comp.lang.php)
  • Re: query
    ... >model is the column which i want to remove all the hyphens. ... Sample data, in the form of INSERT statements. ... UNION ALL ... Best, Hugo ...
    (microsoft.public.sqlserver.mseq)
  • Re: variable with "-" sign
    ... > than starting to use ones with hyphens. ... > Now on to the real problem. ... > name and then create a patch and write the stupid author and send the ... > because he wrote a non POSIX conforming script. ...
    (comp.unix.shell)