[clug-talk] Website database access help
me at jonwatson.ca
Sun May 28 15:10:28 PDT 2006
-----BEGIN PGP SIGNED MESSAGE-----
Right...got it. I saw the part about putting the tables into the Drupal
database and made the wrong connection.
> On Sunday 28 May 2006 15:44, Shawn wrote:
>>> I'm using Drupal for the site, and have put our tables into the Drupal
>>> database. My query is no longer finding results (so it seems). However,
>>> if I run the exact same query directly in a mysql shell I see all the
>>> results I need... So I'm kinda stumped here... Any suggestions?
>> Just an update. I thought this *could* be a permissions issue, so I have
>> logged into the MySQL shell using the same credentials the webserver would
>> and ran the query. It returns me a bunch of records. But the web page
>> does not... So at least I know its not a permission problem now....
> Not resolved yet, but go figure - the moment you ask for help, you start
> making progress... It *looks* like the web page IS in fact getting data, but
> due to how some of that data is represented, it's not getting processed.
> Specifically I have a field called "Section", and I'm doing a match on this
> field to determine which records to display. It turns out that I'm looking
> for "Artefact" while the field holds ""Artefact"" (notice the extra set of
> quotes...) So, I *think* this is the culprit, and I just need to figure out
> how to get the system to import the data without those quotes, or modify my
> code to match them....
> Thanks for the suggstion Jon, but I don't think this is an indexing problem.
> This is um... somewhat outside Drupal's framework. Drupal only comes into
> play for presenting the data - I have a drupal page created with PHP code
> that queries our table, but the tables have nothing to do with Drupal, other
> than being in the same database (saves some extra db connection code).
> clug-talk mailing list
> clug-talk at clug.ca
> Mailing List Guidelines (http://clug.ca/ml_guidelines.php)
> **Please remove these lines when replying
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v188.8.131.52 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
More information about the clug-talk