java - Can't figure out why this big double inner join isn't working, but when split it does -


here queries split work fine...

    string sqlstatement = "select wblinkwebsiteid, wblinkcategoryparentid, wblinktitle, wblinkurl websitecategory_table wblinkcategoryid = ?";     string[] args = { categorysubid };

part 2

    sqlstatement = "select locations_table.locationwebsiteid, " + "locations_table.locationcity, " + "locations_table.locationstate, " + "locations_table.locationcountry, locations_table.locationtype, " + "locations_table.locationurl, " + "pref_table.pref_savedtitle " + "from pref_table inner join " + "locations_table on pref_table.pref_locationid = locations_table.locationid " + "where " + "pref_table.pref_savedtitle = '" + thesavedpref + "' order locations_table.locationstate, locations_table.locationcity";

now here attempt combine 2 instead of having 2 go in row back , burn time/resources...

    string newsqlstatement = "select locations_table.locationwebsiteid, " + "locations_table.locationcity, " + "locations_table.locationstate, "       + "locations_table.locationcountry, " + "locations_table.locationurl, " + "locations_table.locationid, " + "pref_table.pref_savedtitle, "    + "websitecategory_table.wblinktitle, " + "websitecategory_table.wblinkurl " + "from pref_table inner join "    + "locations_table on pref_table.pref_locationid = locations_table.locationid " + "inner join websitecategory_table " + "on websitecategory_table.wblinkwebsiteid = pref_table.pref_websiteid " + "where " + "pref_table.pref_savedtitle = '" + thesavedpref + "'";

now when try "single" way keeps returning whole database of locations in locations_table query. doesn't exact ones need.

i know query works, because have tested here: http://sqlfiddle.com/#!6/ede97/2

now know example on sqlfiddle using ms server 2014, assumed syntax should pretty same since standard select inner joins, wrong?

anyone know i'm doing wrong? appreciated

edit - fixed sqlfiddle, put wrong statement in example

aren't missing filter on wblinkcategoryid in combined query. shouldn't have this:

... + "inner join websitecategory_table " + "on websitecategory_table.wblinkwebsiteid = pref_table.pref_websiteid " + "where " + "websitecategory_table.wblinkcategoryid in (<value1>,...,<valuen>) , " + "pref_table.pref_savedtitle = '" + thesavedpref + "'";


-

Comments

Post a Comment

Popular posts from this blog

Java 8 + Maven Javadoc plugin: Error fetching URL -

i attempting generate javadoc links javadoc dependencies. have tried various means generate javadoc not produce qualified class names references classes dependencies. wanted links java doc simplified class names. however, java api classnames, no links , have qualified class names. working java 8. have following configuration: <plugin> <groupid>org.apache.maven.plugins</groupid> <artifactid>maven-javadoc-plugin</artifactid> <version>2.10.2</version> <configuration> <reportoutputdirectory>${project.basedir}/target</reportoutputdirectory> <destdir>javadoc</destdir> <windowtitle>epiphany</windowtitle> <doctitle>epiphany</doctitle> <show>private</show> <detectlinks>false</detectlinks> <detectoffline...
Read more

css - SVG using textPath a symbol not rendering in Firefox -

using textpath within symbol doesn't render in firefox. renders fine in latest chrome , ie, when try reference symbol, svg text doesn't render in firefox (37.0.1) - first box appears empty. code below (no external dependencies), there should 2 boxes word test flowing vertically in centre of each. edit: thought issue somehow involved flexbox layout, until paul pointed out issue exists without flexbox layout. the html is: <div> <svg id="not_working" viewbox="0 0 250 1200" preserveaspectratio="xmidymid meet"> <symbol id="test_symbol1" preserveaspectratio="xmidymid meet" viewbox="0 0 250 1200"> <path id="test_symbol_path" d="m 100 1200 l 100 0" /> <text font-size="100" fill="red"> <textpath text-anchor="middle" startoffset="50%" xlink:href="#test_symbol_path...
Read more

python - Subprocess.CREATE_NEW_CONSOLE -

i have python code. import subprocess subprocess.popen("airmon-ng check kill", creationflags = subprocess.create_new_console) python 2.7.6 on linux mint gives me following error: subprocess.popen("airmon-ng check kill", creationflags = subprocess.create_new_console) attributeerror: 'module' object has no attribute 'create_new_console' the same on windows 8.1 gives me this: traceback (most recent call last): file "c:\users\ben\dropbox\coding\jam.py", line 10, in <module> subprocess.popen("airmon-ng check kill", creationflags = subprocess.create_new_console) file "c:\python27\lib\subprocess.py", line 710, in __init__ errread, errwrite) file "c:\python27\lib\subprocess.py", line 958, in _execute_child startupinfo) windowserror: [error 2] system cannot find file specified subprocess.popen("airmon-ng check kill", shell=true) will want, presume open shell , execute ai...
Read more