Re: Generic way of fetching a list of databases

2018-11-16 Thread Scott Webster Wood via dbi-users
convert to 'rest'ful JSON? Barack-O-phobia: The fear of politicians who think (more) government is the solution to every problem. On Thursday, November 15, 2018, 9:09:44 PM EST, Daniel Kasak wrote: Hi all. I have a project that has to support pretty much every major database

Re: Recursive SQL query?

2008-04-16 Thread Scott Webster Wood
- Original Message From: Colin Wetherbee [EMAIL PROTECTED] My goal was as a time/work saving measure (from the administration perspective) to allow 'children' elements to have blank entries where the values would get inherited down from parents. That makes sense. I haven't delved

Re: Recursive SQL query? - Ah hah!

2008-04-16 Thread Scott Webster Wood
- Original Message From: Tom To: Scott Webster Wood [EMAIL PROTECTED] Sent: Tuesday, April 15, 2008 5:17:09 PM Subject: Re: [WLUG] OT: recursive SQL? I was thinking you would do this with one table with N joins, depending on the depth you wanted to go. ID | p_ID | name | property And outer

Recursive SQL query?

2008-04-15 Thread Scott Webster Wood
I'm trying to figure out the best way to build an heirarchial categorystructure kinda like you'd find on yahoo or ebay. Basically I amcreating a number of items and I am going to tie each item via a linktable to another link table that defines the categories and subcategories. Sample:

Re: Recursive SQL query?

2008-04-15 Thread Scott Webster Wood
You shouldn't really need to go recursing through a data tree to come up with all the parts of a single fact. Well that is unless you are wanting to inherit data from linked elements further up a link list without re-posting redundant information. Then, instead of storing property

Zip Codes, Long/Lat and LAMP?

2006-02-26 Thread Scott Webster Wood
OK, I think I asked something along these lines before, but I am actually starting to code so I wanted to revise the question(s) a bit. I am looking for a good way to keep an up-to-date database (or perhaps use an XML-RPC/SOAP based service) to translate back-and-forth between information such as

Re: [cgiapp] Best free DB for a web-based Perl app response results...

2005-12-01 Thread Scott Webster Wood
Aaron Dancygier [EMAIL PROTECTED] wrote: Just look at the list of companies that use mysql. Would google and yahoo use it if it werent up to par? Corporate entities (i.e. corporate managers) make decisions that are not always generated from the same motivations as the rest of us. Google