Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: SQL queries from weird data

by RichardK (Parson)
on Feb 19, 2013 at 15:43 UTC ( #1019596=note: print w/replies, xml ) Need Help??


in reply to SQL queries from weird data

To me, the problem looks more like an issue with your database schema design.

If you normalised out the "other" column into its own key/value table then your problem would go away and your code would be nice and simple :)

Replies are listed 'Best First'.
Re^2: SQL queries from weird data
by Neighbour (Friar) on Feb 19, 2013 at 15:47 UTC
    Indeed. And you wouldn't be trying to execute data, which is something to be avoided.
Re^2: SQL queries from weird data
by Anonymous Monk on Feb 19, 2013 at 15:51 UTC
    I should have been more clear, this isn't our schema, these aren't our tables. This is generated by a third party product (VB.Net front end, Oracle back end) over which we have zero control. We're trying to provide more functionality via some scripting. We want to do things this product doesn't do.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1019596]
help
Chatterbox?
[Corion]: Discipulus: Notepad++, or Perl ;)
[marto]: xubuntu or lubuntu
[Corion]: :-D
[marto]: my desktop is a core2 duo, 120GB SSD, 4GB RAM, boots to (GUI) login in less than 10 seconds from cold start
[Discipulus]: mah, winbuntu 10...
[marto]: whent he boys start school I'll build myself as new machine, ryzen based
[Corion]: marto: That's cool! I think my (home) desktop spends 30 seconds in the BIOS...
[Corion]: marto: Heh - currently they seem promising, but I think I'll stay with nVidia+Intel for the time being, as I've been bitten too often by bad AMD drivers
Discipulus is (still?) not a big fan of notepad++
[marto]: Corion, I think in the past this was a big problem for them. GPU driver wise the improve all the time. I use the open source drivers on my machine (old R9 270, 2GB) and had no problems

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2017-07-27 08:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I came, I saw, I ...
























    Results (407 votes). Check out past polls.