Forums > Product Discussion - DotNetNuke Modules > Dynamic Views
How complex can the Custom SQL Query can be?
Last Post 10-23-2012 09:42 AM by Cynthina. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
CynthinaUser is Offline
wading in the water
wading in the water
Posts:21
Avatar

--
10-23-2012 07:13 AM
    Hi -

    I am wondering what can be used for custom sql query....I though you could use a simple join; however, it is erroring out.

    Any suggestions?
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    10-23-2012 07:15 AM
    Hi Cynthia - It can be pretty complex however it might be limited to 2000 characters. Can you tell me if your same query works under Host/SQL?

    Thanks,

    Chad
    CynthinaUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    10-23-2012 08:24 AM
    Yes --- it works fine when I run the SQL query.

    I believe when I use the nomenclature that includes the table+column to differentiate from table is where it does not like it. For example: dbo.web_tour_catalog.TCID vs dbo.web_tour_specials.TCID

    Any idea why?
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    10-23-2012 08:33 AM
    Hi Cynthia -I do believe there is a problem if you are pulling in the same column name twice? So do you think that this is possibly the problem you are having here?

    Thanks,

    Chad
    CynthinaUser is Offline
    wading in the water
    wading in the water
    Posts:21
    Avatar

    --
    10-23-2012 09:42 AM
    No. I am joining two tables using the key TCID --- it was just for sake of discussion I used that. I am using different columns to list the appropriate data once the tables have been joined. 

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Views
    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi