Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Re: Re:x2 Escaping parentheses in regexps (select distinct is a Red Flag)

by Tanalis (Curate)
on Jan 22, 2003 at 19:07 UTC ( #229108=note: print w/ replies, xml ) Need Help??


in reply to Re: Re:x2 Escaping parentheses in regexps (select distinct is a Red Flag)
in thread Escaping parentheses in regexps

A SELECT DISTINCT isn't possible in this case, though it's a good idea and something we'd thought of.

The DB we're using is global, and belongs to a different group to the one I work in. It has data stored how they need it for their reporting, not how we need it for ours - hence the need to concatenate data when duplicates occur on one (of our) orderids.

It's for a fairly specific use, actually: we're trying to have their systems interface with ours for reconciliation purposes, and it's proving to be a lot less simple than I originally thought :)

It'd make a lot more sense if the company had data storage standards, as we're all essentially in different areas of the the same business, but that'd make life easy ... *grin*

-- Foxcub

  • Comment on Re: Re: Re:x2 Escaping parentheses in regexps (select distinct is a Red Flag)
  • Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://229108]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2016-07-24 09:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What is your favorite alternate name for a (specific) keyboard key?


















    Results (221 votes). Check out past polls.