• RELEVANCY SCORE 4.77

    DB:4.77:"Nested" Queries Clobber Datasource In Query They Are Called From! x1





    Much to my dismay, I discovered that "nested" queries clobber the datasource in the query they are called from. You can get a nested query if inside cfquery tags you call a function (through # signs) that runs its own query. If that query is to a different datasource, then the original query will actually be run against the nested query's datasource.

    I thought I'd let you all know to see your thoughts, and ask if there is a better way to report this "Bug" (if we all agree its a bug) to Adobe.

    DB:4.77:"Nested" Queries Clobber Datasource In Query They Are Called From! x1


    This came up a couple of weeks ago, and has been raised as a bug: http://cfbugs.adobe.com/cfbugreport/flexbugui/cfbugtracker/main.html#bugId=79382

    It might help for you to vote for it.

    --

    Adam

  • RELEVANCY SCORE 2.80

    DB:2.80:Nested Queries In Xsql_Servlet za




    --
    Is it possible to nest queries in the xsql servlet. I tried
    nesting the query elements. It doesn't generate errors, but
    the nested query isn't executed.

    Thanks,
    KrisC
    null

    DB:2.80:Nested Queries In Xsql_Servlet za

    --
    Is it possible to nest queries in the xsql servlet. I tried
    nesting the query elements. It doesn't generate errors, but
    the nested query isn't executed.

    Thanks,
    KrisC
    null

  • RELEVANCY SCORE 2.70

    DB:2.70:Where In, Group By, Having Count = Nested Query cz




    Hi again... I'm struggling on translating sql queries to linq queries. The problem right now is GROUP BY HAVING COUNT = NESTED QUERY. Look what I mean in the sql query below:

    SELECT CodigoProduto
    FROM dbo.lstProdutosRepresentantes
    WHERE CodigoColaborador IN
    (
    SELECT CodigoColaborador
    FROM lstCarteiras
    WHERE CodigoConta = 10
    )
    GROUP BY CodigoProduto
    HAVING COUNT(CodigoProduto) = (SELECT COUNT(*) FROM lstCarteiras WHERE CodigoConta = 10

  • RELEVANCY SCORE 2.65

    DB:2.65:Problem With Nested Queries Using Linq To Entities 7x


    How to achieve using linq an equivalent of the following SQL query:

    Code Snippet

    DB:2.65:Problem With Nested Queries Using Linq To Entities 7x

    How about the first example slightly modified like this.
     
    from c in db.Customers
    where c.Locations.Any(l = l.Name = 'Warsaw').Select(c = c);
     
    Zeeshan Hirani

  • RELEVANCY SCORE 2.65

    DB:2.65:Problem With Hot Deployment Of Datasource. ad



    I have problem with hot deployment of datasource.I just touch file - no content change.Datasource is redeployed.Trying to make a query and exteption is frown:javax.ejb.FinderException: Find failed: org.jboss.util.NestedSQLException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.; - nested throwable: (javax.resource.ResourceException: You are trying to use a connection factory that has been shut down: ManagedConnectionFactory is null.) at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:223)TRACE log on org.jboss.resource gives no clue.

    DB:2.65:Problem With Hot Deployment Of Datasource. ad


    Hi all.I just wanted to add that I _also_ see this problem with my current jboss: 3.2.5.Also, I didn't find anywhere anything about this problem.If someone could point me to some directions...I also noted that this seems to be fixed in 4.0.2. I don't know if this was preivously fixed, I only tested 4.0.2 today and tried that.I hope it helps.

  • RELEVANCY SCORE 2.64

    DB:2.64:Escaping Text Queries With Backslash mp


    According to the documentation, we can use "\" to escape characters in a CONTAINS query. However, when I escape a keyword like "NT", Oracle Text gives a parse exception.

    select * from myTable where contains(myColumn, '\N\T') 0;

    ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 5 ; nested exception is java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine

    Is this a bug?

    DB:2.64:Escaping Text Queries With Backslash mp

    Put curly brackets around it.

    SCOTT@orcl_11g create table mytable (mycolumn varchar2 (30))
    2 /

    Table created.

    SCOTT@orcl_11g insert into mytable values ('NT')
    2 /

    1 row created.

    SCOTT@orcl_11g create index myindex on mytable (mycolumn)
    2 indextype is ctxsys.context
    3 /

    Index created.

    SCOTT@orcl_11g select * from myTable where contains(myColumn, '{NT}') 0
    2 /

    MYCOLUMN
    ------------------------------
    NT

    SCOTT@orcl_11g

  • RELEVANCY SCORE 2.61

    DB:2.61:Query Of Queries Syntax Error. dk


    Hi all,

    I have the following query:

    cfquery name="agent" datasource="datasourcename"
    SELECT * FROM quotes where status = 'Pending'
    cfif isDefined("form.agent")
    AND agent = '#FORM.agent#'
    /cfif
    /cfquery

    Then, I have the following query of that query

    cfquery name="totalvalue" dbtype="query"
    SELECT SUM(value) as total FROM agent
    /cfquery

    however I get the following error:

    Query Of Queries syntax error.
    Encountered "SUM ( value. Incorrect Select List,

    on line 20 which is:

    cfquery name="totalvalue" dbtype="query"

    now i'm sure this is identical to what ive used before but
    getting the error. the totals query works fine when querying the
    database direct, only got this error when I changed it to query the
    master query.

    i appreciate any help in advance, as no matter how much i
    stare at it I can't see whats wrong!

    DB:2.61:Query Of Queries Syntax Error. dk

    Great, the reserved word was the answer. Sometimes
    Dreamweaver put a " " round words in a insert statement for
    example, is this because they are reserved words? will watch my
    column names from now on!

    many thanks

  • RELEVANCY SCORE 2.61

    DB:2.61:Help To Tune Nested Query 89


    Hi I have a following type of query which is using inline views .
    select a,b,c,d,e,f
    from
    (select a,b
    from (select a,c from t)),
    (select c,d
    from (select d,c from t1))

    What would be best approach to tune these type of queries?
    Can we use Global temp Table these queries

    -kuldeep

    DB:2.61:Help To Tune Nested Query 89

    hi,

    please see this thread

    Re: What is the best way to replace the Inline Views for better performance

  • RELEVANCY SCORE 2.61

    DB:2.61:Info-Set Query Datasource a3



    Hi Geeks,

    I have created an infoset query. Based on tables

    VBAK - Sales order header data

    VBAP - Sales order item data

    VBUP - Sales document item status

    VBPA - Parnter function table.

    I created a custom data-source in RSO2 based on this infoset query.

    Now I want to delete tables (VBPA) or entries (VBPA-KUNNR) in field groups from infoset query.

    system is not allowing me to do this saying

    System says "VBPA-KUNNR" is used in queries.

    Can anybody please suggest me any way to change the infoset inturn datasource created over it.

    Thanx in advance.

    Monica

    DB:2.61:Info-Set Query Datasource a3


    Hi,

    A wild suggestion of Executing a small Abap Program to delete the Kunnr Data. I have not tried. Giving a suggestion

    regards

    Happy Tony

  • RELEVANCY SCORE 2.59

    DB:2.59:Expose Query With Parameters As Odata? 33


    Hi,
    I got a SQL server DB witch I expose with LS as external datasource. I added some custom queries with parameter. Now I want to use these queries in a Win8 metro app. But I can't seem to find them in the ODATA feed is this correct?

    DB:2.59:Expose Query With Parameters As Odata? 33

    indeed :)
    Buttom line is when it comes to odata to check always the $metadata, which tells you exactly what the odata service supports or not. The client tools (like add service reference implement what they want, and especially what they don't want :)

    paul van bladel

  • RELEVANCY SCORE 2.59

    DB:2.59:Datasource Jta aa



    Hi,

    can someone explain to me what is the difference between jta=true and jta=false in a JBoss datasource-configuration.

    I had the situation where the jta flag was false and native-queries were atomic (they have not been rolled back if after the native query an error happens)

    DB:2.59:Datasource Jta aa


    Hi,

    can someone explain to me what is the difference between jta=true and jta=false in a JBoss datasource-configuration.

    I had the situation where the jta flag was false and native-queries were atomic (they have not been rolled back if after the native query an error happens)

  • RELEVANCY SCORE 2.58

    DB:2.58:Combine Queries fc


    Hi,
    I've trouble combining queries. I'm not trying to join the
    tables, but get results based on WHERE statement.

    Query one:
    cfquery name="notes_get" datasource="#APPLICATION.ds#"
    cachedWithin="#CreateTimeSpan(0, 0, 2, 0)#"
    SELECT *
    FROM db_new.notes
    WHERE myID = #ARGUMENTS.myID#
    /cfquery

    Query two:
    cfquery name="favorite_sites"
    datasource="#APPLICATION.ds#" cachedWithin="#CreateTimeSpan(0, 0,
    2, 0)#"
    SELECT *
    FROM db_new.favorite_sites
    WHERE myID = #ARGUMENTS.myID#
    /cfquery

    What i've tried is:
    cfquery name="uniqueQuery" datasource="db"
    cachedWithin="#CreateTimeSpan(0, 0, 2, 0)#"
    SELECT *
    FROM db_new.favorite_sites, db_new.notes
    WHERE db_new.notes.myID = 2 OR db_new.favorite_sites.myID =
    2
    /cfquery

    What it does it, shows join query. I dont want repeated data
    to combine it with other table. I want exactly as it was working as
    individual query.

    Thanks for any help!

    DB:2.58:Combine Queries fc

    CF_Oracle, that did solve the problem. Thanks everyone for
    helping out!

  • RELEVANCY SCORE 2.58

    DB:2.58:Adding Nested Queries To Idfquerybuilder a9


    I am in the process of customizing the 5.3 SP3 Webtop Advance Search component. As a part of my search query I need to build a nested query. Does anyone know if it is possible to add a nested query to the IDfQueryBuilder object that is created? For example, my query has some functionality like this...select * from type_contract where a_status = 'Active' and r_object_id in (select parent_id from dm_relation)If it is not possible does anyone have any suggestions on how to handle this type of functionality through Webtop?Thanks.

    DB:2.58:Adding Nested Queries To Idfquerybuilder a9

    I discovered that it is not possible to nest queries. I had to revert to the 5.2.5 version of the search and manipulate the dql string.

  • RELEVANCY SCORE 2.56

    DB:2.56:Problem With Transaction Of 100.000 Queries x7



    I sent 100.000 queries (updates and inserts). In the query 99.708 the server report the next exception:disconnect(ManagedConnection mc: null, Object c: org.jboss.resource.adapter.jdbc.local.LocalConnection@91f022) called with unknown managed connection; nested exception is: java.lang.IllegalArgumentException: disconnect(ManagedConnection mc: null, Object c: org.jboss.resource.adapter.jdbc.local.LocalConnection@91f022) called with unknown managed connection.We are using jboss-3.0.1RC1 + postgress 7.2Some idea?

    DB:2.56:Problem With Transaction Of 100.000 Queries x7


    I suggest you post this in the JCA forum as this looks like an error in the JDBC JCA wrapper.

  • RELEVANCY SCORE 2.56

    DB:2.56:How To Do Nested Igrouping With Datatables? pk


    I have DataTable with following columns. Country, State,City,NumberOfPeople. I want to group by Country and then by State. How do i do that? Note that the datasource is DataTable. The below query which does
    the grouping by Country but now i want further group by State and then loop it.
    var result = MyDataSet.Tables[data]
    .AsEnumerable()
    .GroupBy(x = x.Fieldstring(Country))

    DB:2.56:How To Do Nested Igrouping With Datatables? pk

    i think i got it, sorry i should have check the forum first
    http://social.msdn.microsoft.com/Forums/en-US/ca15f6d3-b358-4a86-82c6-d749bc9e7e1c/how-to-do-a-nested-groupby?forum=linqprojectgeneral

  • RELEVANCY SCORE 2.55

    DB:2.55:Sharepoint 2007 Issue : Some Part Of Your Sql Statement Is Nested Too Deeply. Rewrite The Query Or Break It Up Into Smaller Queries. d8


    Dear Members,
    While viewing/editing an item in Sharepoint 2007 , i'm getting below error
    Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    Kindly provide your valueable inputs here.
    Gone through many threads of same error but end with no conclusing on threads.

    Thanks in advance.

    DB:2.55:Sharepoint 2007 Issue : Some Part Of Your Sql Statement Is Nested Too Deeply. Rewrite The Query Or Break It Up Into Smaller Queries. d8

    Dear Members,
    While viewing/editing an item in Sharepoint 2007 , i'm getting below error
    Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    Kindly provide your valueable inputs here.
    Gone through many threads of same error but end with no conclusing on threads.

    Thanks in advance.

  • RELEVANCY SCORE 2.53

    DB:2.53:Nested Queries jz



    I am trying to nest queries on a permanent basis. For example, if I drag one query to another it will give me a static list of machines that meet both queries. Is there a way to create a new dynamic query that will constantly update? I do not want to have to manually create these queries every time by hand.

    What we are specifically trying to do is only patch a certain set of machines (based on one query) against a query listing all the machines that need a certain patch (the second query). When we have new images come online, they might not be in the static listing of machines from the nested query and we want to ensure it is automatically added.

    DB:2.53:Nested Queries jz


    In addition to what James said, If you are running 9.0 there is a query filter you maybe able to use inside the vulnerabilities. Also prereq queries may help.

  • RELEVANCY SCORE 2.51

    DB:2.51:Nested Queries And Jet Database Engine. sz



    I have an access database that has nested queries. For example, the querydef below is called qs_Pedon_type:
    SELECT qs_Pedon_basic.peiid, metadata_domain_detail.domain_id, metadata_domain_detail.choice, qs_Pedon_basic.siteiidref
    FROM qs_Pedon_basic LEFT JOIN metadata_domain_detail ON qs_Pedon_basic.pedontype = metadata_domain_detail.choice_id
    WHERE (((metadata_domain_detail.domain_id)=1273));
    qs_Pedon_basic is a separate query def in access.
    When I call qs_Pedon_type using ODBC I get the following:The Microsoft Jet database engine cannot find the input table or query 'qs_Pedon_basic'.
    Any help? I am using asp .net vs 2010 to code this.
    Paige

  • RELEVANCY SCORE 2.50

    DB:2.50:Sql Ce Query dx


    hi,I am new to SQL CE. I am facing a problem in writing one query. I need to get the 10th to 20th records from the table which has 50 rows. I tried the following.1. with joins, but this table contains one ntext type column. So I cant use the joins. 2. Nested queries are not allowed in select. so nested query is ruled out.3. Row_Number() not available in SQL CE.Please let me know how to achieve this?

    DB:2.50:Sql Ce Query dx

    I'm by no means an expert, but I don't think there's a quick and easy way to do it.  The TOP operator returns the first x number of rows.  This may or may not be useful, but I found someone asking the same question here with some ideas:http://channel9.msdn.com/forums/TechOff/115493-How-to-retreive-a-range-of-records-in-SQL/

  • RELEVANCY SCORE 2.50

    DB:2.50:Nested Object Collection Datasource dk


    HiI am binding an Object Datasource into WEB FORM Report Viewer Control in Local Mode. Object Source contains child/nested object collection. In order to bind this, I used the expression, like this ParentPropertyName.Value.ChildPropertyName, as most of the posts suggested (http://www.gotreportviewer.com/objectdatasources/index.html) . But Still I am getting #Error while rendering.  Do I need create sub report in order to bind the Child Object Collection?My RDLC file Dataset Info for you reference. The Child object collection, name is FailedCourses.
    DataSets
    DataSet Name=AthleticEligibilityReport
    Fields

    Field Name=StudentName
    DataFieldStudentName/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=DateOfBirth
    DataFieldDateOfBirth/DataField
    rd:TypeNameSystem.Nullable`1[System.DateTime]/rd:TypeName
    /Field
    Field Name=Age
    DataFieldAge/DataField
    rd:TypeNameSystem.Int32/rd:TypeName
    /Field
    Field Name=FailedCourses
    DataFieldFailedCourses/DataField
    rd:TypeNameAthleticEligibilityFailedCoursesReport[]/rd:TypeName
    /Field

    /Fields

    Query
    DataSourceNameAthleticEligibilityReport/DataSourceName
    CommandText
    /CommandText
    rd:UseGenericDesignertrue/rd:UseGenericDesigner
    /Query
    rd:DataSetInfo
    rd:DataSetName
    /rd:DataSetName
    rd:TableName
    /rd:TableName
    rd:ObjectDataSourceTypeReportsDAL, App_Code.np0i0gm0, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null/rd:ObjectDataSourceType
    /rd:DataSetInfo
    /DataSet
    /DataSetsAmzu

    DB:2.50:Nested Object Collection Datasource dk

     http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/08db0df6-80ac-44b0-8f6f-e6748be1ecb4Amzu

  • RELEVANCY SCORE 2.50

    DB:2.50:Php - Chained Queries Nested In "While" Loops 31



    Hello,

    would like to know if someone already saw the issue i'm facing and how to avoid it.

    I have some code parts looking like :

    $query="SELECT id FROM ... WHERE ...";
    $result=maxdb_query($link, $query);
    while($object=maxdb_fetch_object($result)) {
    $query2="SELECT id FROM ... WHERE id='".$object-ID."' ...";
    $result2=maxdb_query($link, $query2);
    while($object2=maxdb_fetch_object($result2)) {
    echo $object2-ID;
    ...
    }
    maxdb_free_result($result2);
    }
    maxdb_free_result($result);

    DB:2.50:Php - Chained Queries Nested In "While" Loops 31


    Hello dinard,

    Can you specify why exactly do you want to use nested "while" loops?

    I would use any kind of outer join on the query, in order to avoid your situation.

  • RELEVANCY SCORE 2.50

    DB:2.50:Explain Plan Statements ca


    Dear legends,

    I want to know what is the first SELECT STATEMENT, NESTED LOOPS and HASH JOIN indicates in the EXPLAIN PLAN?

    Tell me whether my thinking is correct or not please,

    SELECT STATEMENT -- indicates the basic execution of a query

    NESTED LOOPS -- this will be shown whether the SQL has been used more sub queries?

    HASH JOIN -- to speed up the query than the nested loops hash join is used.

    Thanks a lot in advance
    With Regards,
    Karthik singh

    DB:2.50:Explain Plan Statements ca

    Hi Nikolay,

    Sorry I will be using two accounts for my issue, i use this account more rare and u can find my another account also

    karthiksingh_india

    Status Level: Newbie
    Registered: Dec 8, 2011
    Total Posts: 170
    Total Questions: 26 (17 unresolved)
    Name Karthik Singh
    Location India
    Occupation DBA_TRAINEE
    Biography Just now finished OCP and working as Trainee. But i still need practical experience in DBA

    i had googled, MOS and so many performance docs but i need some clarification whether what i have understood is correct or wrong.. thats why i have posted. if someone helps me in giving the opt answer which i can understand in a easier way it would be a great help for beginners like me. Thanks a lot for your valuable reply.

    Regards,
    Karthik

  • RELEVANCY SCORE 2.50

    DB:2.50:Code Generated xs


    We are working with an OWB mapping and the code its generating has a large number of nested queries and the job is running for a considerable amount of time. It looks as if you specify criteria for a particular table like customer_type = 5, it will create a nested query for that. If you have a join going into another join then it creates a nested query for that join. Some of the code being generated has 20+ nested queries in it. If we rewrite the code to use joins it runs much faster. Is there a way to get OWB to use joins instead of nested queries?

    DB:2.50:Code Generated xs

    Good morning,

    That's just the way OWB works. If you have a big mapping (i.e. lots of subsequent operators) you'll indeed get lots of inline views (nested queries), not much you can do about that I fear. You could add some query hints but whether that helps in your situation I don't know.

    A workaround is to define a view that performs most (all?) joins and other operations you desire on your source set and use that to load your target; this way you have full control over the final query, although you'll miss out on some of the auditing (e.g. intermediate results between operators), but if you're confident that the built view returns exactly the desired set it should be OK.

    Good luck, Patrick

  • RELEVANCY SCORE 2.48

    DB:2.48:F4 In Query For Custom Infoobject/Characteristic sf



    Hi All,

    F4 values for Z infoobjects show no values in queries.

    This Z infoobject resides in our operating concern. It's datasource is the system generated 0G_xxxxx that the system creates automatically. The data is loaded to the master data tables, but F4 in query variable screen shows no values.

    Can someone let me know how to resolve this?

    Thanks, Colleen

    DB:2.48:F4 In Query For Custom Infoobject/Characteristic sf


    Hi Colleen,

    The F4 values for any characteristic can be set up at two places.

    1) In the definition of the info-object under 'Business Explorer' tab. In this tab the settings made for 'Query Execution Filter Val selection' determines what values are displayed to the users when the query is executed.

    2) However the settings made above is overridden by the settings made in the info-provider (cube). You can make the settings for F4 query by going to 'Extras - Structure Specific Properties'.

    Thanks

    Soumya

  • RELEVANCY SCORE 2.48

    DB:2.48:Nested Sql Statements For Complex, Detailed Queries. kk


    Is it possible to write nested SQL statements for complex, detailed queries. A nested query
    has a WHERE clause that includes a SELECT statement ? Is it true or false ?

    DB:2.48:Nested Sql Statements For Complex, Detailed Queries. kk

    Hi wahid,
    Here are pretty good examples:

    http://www.databasejournal.com/features/mssql/article.php/3464481/Using-a-Subquery-in-a-T-SQL-Statement.htmhttp://technet.microsoft.com/en-us/library/aa213252(v=sql.80).aspxRegards Harsh

  • RELEVANCY SCORE 2.48

    DB:2.48:Bam And Nested Select Query da


    hi

    i have a nested query in bam which is working fine when executed from database console but returns 0 value when executed from bpm.
    I am unable to figure out the problem as the individual queries are working just fine but when nested they do not work from BPM.

    DB:2.48:Bam And Nested Select Query da

    Please update with the whole query for more details and also check with your project's log and engine logs whether there is any exception occurred.

    Edited by: Brijesh Kumar Singh on Oct 12, 2010 9:10 PM

  • RELEVANCY SCORE 2.47

    DB:2.47:Grouping On Same Table as


    Hello All,
    Our oracle version is 9i on linux.

    Our application has most of the queries styled as below ,

    select
    from
    act A ,
    best B
    where a.id = b.id
    and b.end_dt = (

    select max(end_dt)

    from best BB

    where b.id = bb.id
    );

    Is there anyway i can avoid the sub query as the sub query logic is the reason for slowing of most queries.

    Also one query in the same structure takes nested loop with RULE hint and with out hint it gives Cartesian join in addition to nested loop.

    Thanks in advance ,
    vijay G

    DB:2.47:Grouping On Same Table as

    You are welcome!

    Mahir M. Quluzade

  • RELEVANCY SCORE 2.47

    DB:2.47:Connecting Jdbc Single Row Query To Sql Server 2008 3s



    Hello,

    I am new to workbench and am having a very dificult time accessing a database and running a query on it. I have searched a lot on the internet for suggestion on how to accomplish this but nothing has worked. The LiveCycle was intaled on the same server that the SQL Server is sintalled, and was installed by an administrator who is no longer at our company. So I am trying to have the user input an account number into the form I have created, then take that account number and use an xpath expression to query the database and extract the information for that account. Could anyone please help me set this up.

    I Changed my my-db2-ds.xml to the following:

    local-tx-datasource

    jndi-nameSQLDB_IMACS/jndi-name

    connection-urljdbc:sqlserver://CBS-SQL-001;databaseName=DB_IMACS;integratedSecurity=tru e;/connection-url

    driver-classcom.microsoft.sqlserver.jdbc.SQLServerDriver/driver-class

    /local-tx-datasource

    and I get the following error message:

    Exception: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: com.microsoft.sqlserver.jdbc.SQLServerDriver)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: com.microsoft.sqlserver.jdbc.SQLServerDriver)))

    I have the following file sqljdbc.jar in my Adobe LiveCycle ES2\jboss\server\lc_turnkey\lib\ folder.

    If you could please let me know what I can do to connect that would be very useful.

    Thanks,

    sgarciacode19

    DB:2.47:Connecting Jdbc Single Row Query To Sql Server 2008 3s


    Hello,

    I am new to workbench and am having a very dificult time accessing a database and running a query on it. I have searched a lot on the internet for suggestion on how to accomplish this but nothing has worked. The LiveCycle was intaled on the same server that the SQL Server is sintalled, and was installed by an administrator who is no longer at our company. So I am trying to have the user input an account number into the form I have created, then take that account number and use an xpath expression to query the database and extract the information for that account. Could anyone please help me set this up.

    I Changed my my-db2-ds.xml to the following:

    local-tx-datasource

    jndi-nameSQLDB_IMACS/jndi-name

    connection-urljdbc:sqlserver://CBS-SQL-001;databaseName=DB_IMACS;integratedSecurity=tru e;/connection-url

    driver-classcom.microsoft.sqlserver.jdbc.SQLServerDriver/driver-class

    /local-tx-datasource

    and I get the following error message:

    Exception: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: com.microsoft.sqlserver.jdbc.SQLServerDriver)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.microsoft.sqlserver.jdbc.SQLServerDriver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: com.microsoft.sqlserver.jdbc.SQLServerDriver)))

    I have the following file sqljdbc.jar in my Adobe LiveCycle ES2\jboss\server\lc_turnkey\lib\ folder.

    If you could please let me know what I can do to connect that would be very useful.

    Thanks,

    sgarciacode19

  • RELEVANCY SCORE 2.47

    DB:2.47:Vc Application Based On Bw Queries z7



    Hi,

    I am trying to develop an VC application based on queries designed with the Business Explorer Query Designer.

    A designed query works fine with the BEX Analyzer, but I have problems using it in VC.

    I can add the designed query in VC, but there occur problems using an input form for mandatory variables ( ... Nested Exception: INVALID_VARIABLE_VALUES ...).

    I dont know the correct format for the input fields in VC.

    The variables in my query need only Single Value Input.

    How can I find out the appropiate format for the requierd input fields?

    Thanks in advance.

    Slawomir

    DB:2.47:Vc Application Based On Bw Queries z7


    Hi Slawomir,

    In rsrt2, on top of the result screen, there is web api command string. look for VAR_VALUE in the command string, the value for this command is the correct value for the variable.

    best regards,

    Shan

  • RELEVANCY SCORE 2.46

    DB:2.46:Nested Xmlagg Order By a7


    Hi,

    i would like to sort (order by) a nested xmlAgg Query but it seems not to work, why ?

    My table:
    select * from dummy;

    NAME
    -------------------------
    scoot
    alice

    My Query:
    select xmlelement("NAMES", xmlelement("TIMESTAMP", sysdate), (select xmlagg(xmlelement("NAME", name)) from dummy order by name)) from dual;

    I get allways the error:
    ORA-00907: Rechte Klammer fehlt
    (ORA-00907 right parenthesis missing)

    Without the "order by"-clause the query works perfectly.
    Perhaps sorting nested queries is impossible ?

    regards

    Adam

  • RELEVANCY SCORE 2.46

    DB:2.46:Index Usage And Nested Views da


    We've got some performance problems when using a complex view that queries against a couple nested views.
    We need to use views because we have two outer joins against the same table.
    Here's a simplified version:

    create or replace view_b as
    select a1, b1, c1, d1
    from table_c, table_d, view_a
    where table_c.c1 = view_a.a1(+)
    and table_c.c2= table_d.d1

    create or replace view_a as
    select a1
    from table_a, table_b
    where table_a.a1 = table_b.b1(+)

    A query that may present problems with large amounts of data is:

    select a1, b1
    from view_b
    where a1 = 1234;

    Do indexes of nested views get utilized? Any suggestions?

    Thanks

    DB:2.46:Index Usage And Nested Views da

    We've got some performance problems when using a complex view that queries against a couple nested views.
    We need to use views because we have two outer joins against the same table.
    Here's a simplified version:

    create or replace view_b as
    select a1, b1, c1, d1
    from table_c, table_d, view_a
    where table_c.c1 = view_a.a1(+)
    and table_c.c2= table_d.d1

    create or replace view_a as
    select a1
    from table_a, table_b
    where table_a.a1 = table_b.b1(+)

    A query that may present problems with large amounts of data is:

    select a1, b1
    from view_b
    where a1 = 1234;

    Do indexes of nested views get utilized? Any suggestions?

    Thanks

  • RELEVANCY SCORE 2.46

    DB:2.46:Nested Tables Select Query Soooooo Slow af


    I know that varrays are supposed to be used for small arrays. But, we are comparing nested tables to varrays and two table joins. Nested table query is unimaginably ,unacceptably slow.
    Is there anybody else out there who experienced the same thing. Are there ways to speed up the select queries.(besides indexes)

    DB:2.46:Nested Tables Select Query Soooooo Slow af

    If you try to use nested sql statement. Please be sure to setup the index to some specific tables inside oracle

    Doing this will speed up your performance about 5 ~ 9 times original.

    cxy19@mail2000.com.tw

  • RELEVANCY SCORE 2.46

    DB:2.46:Combine Query, Result From Another Query On Sap Bi Query Universe? df



    Hello all,

    We are using SAP BI queries as datasource for our universes. Is the combined query option disabled for webi reports written on such universes?

    result from another query - is this option active for such webi reports? I see both these options greyed out so wanted to check.

    One last thing what is really difference between subquery and results from another query? subquery - you can use filters from that one data provider only right? or can you use a different data provider/report in sub query?

    Thanks a lot for all the replies.

    DB:2.46:Combine Query, Result From Another Query On Sap Bi Query Universe? df


    Hi,

    in BO 3.1 Combined query and result from another query options are not available in webi report on OLAP Universes (SAP BW Universe.)

    Thanks,

    Amit

  • RELEVANCY SCORE 2.46

    DB:2.46:Enabling Nested Query Option For Linked Servers? k1


    We have a number of SQL 2000 linked servers that query SQL 2005 and SQL 2000 servers.  I just determined that using the Provider Option Nested Query causes a big performance boost for queries against our SQL 2005 databases containing a nested SELECT statement in the FROM clause.  My questions are:(1) should I always enable this provider option for any SQL 2000 to 2005 and 2000 to 2000 where a nested query is used?(2) will enabling this option cause overhead and possibly slow down performance where the query referencing a linked server is not nested?(3) In SQL 2005 should I turn this option ON for the OLE DB provider or could that negatively impact performance?Thanks,   Dave
     

    DB:2.46:Enabling Nested Query Option For Linked Servers? k1

    The nested query option can make SQL Server delegate the nested query operations to the providers, so it is good to use it if the provider supports nested queries.

  • RELEVANCY SCORE 2.46

    DB:2.46:Sql Tuning Efficiency 8j


    HI ,
    I wanted to ask which of the SQL is Efficeint in terms of speed
    and memory requiremensts and why?

    Query 1 - select A.* from A,B where A.a = B.b
    Query 2 - Select * from A where A.a in ( Select B.b from B)

    Actually i had to use multiple nested queries in my Plsql block

    Thanks in advance
    Ravinder

    DB:2.46:Sql Tuning Efficiency 8j

    The first query should run faster because of the join but may
    return more rows back than what you're expecting. If B.b is in
    table B multiple times for each occurence of A.a you'll get a
    result back for each row in table B.

    So say the data is
    A.a
    1
    2
    3

    B.b
    1
    1
    1
    2

    Your first query will return
    1
    1
    1
    2

    not
    1
    2

    Using IN (Select B.b from B) will execute once and return all
    rows from B for each row you return from A and then see if A.a is
    in the entire result set from B. So if you have 1 million rows in
    B and run the second statement:

    select 1 million rows from B and see if A.a in B.b for first row

    select 1 million rows from B and see if A.a in B.b for second
    row...

    This will take a long time to run but using my data from above
    this query will return:
    1
    2

    If possible, when using a subquery always try to correalate it
    and use EXISTS instead of IN, you'll see better performance. You
    could rewrite your second query as:

    select A.a from A where exists(select B.b from B where A.a = B.b)

    which would return
    1
    2

    and should run fast too.

    Hope this helps.

    HI ,
    I wanted to ask which of the SQL is Efficeint in terms of speed
    and memory requiremensts and why?

    Query 1 - select A.* from A,B where A.a = B.b
    Query 2 - Select * from A where A.a in ( Select B.b from B)

    Actually i had to use multiple nested queries in my Plsql block

    Thanks in advance
    Ravinder

  • RELEVANCY SCORE 2.45

    DB:2.45:Nested Queries In Cmp In Wl 6.1 Sp1 99



    Hello,

    I was wondering is nested queries are supported in the finder queries for CMP Deployment Descriptors.

    I would like to make a finder-query for a SQL query like below,
    Select x where id in (Select id from table where y=z)

    I am using EJB 1.1 and weblogic 6.1 sp1.
    Could you help me in writing a query for this?

    Thanks,
    Sejal

    DB:2.45:Nested Queries In Cmp In Wl 6.1 Sp1 99

    I suggest that you post in the BEA newsgroup section titled
    "weblogic.developer.interest.ejb.cmp".

    Peace,

    --
    Cameron Purdy
    Tangosol Inc.
    Tangosol Coherence: Clustered Coherent Cache for J2EE
    Information at http://www.tangosol.com/

    "Sejal Patel" sejal@towerj.com wrote in message
    news:3c43c4e4$1@newsgroups.bea.com...

    Hello,

    I was wondering is nested queries are supported in the finder queries forCMP Deployment Descriptors.

    I would like to make a finder-query for a SQL query like below,
    Select x where id in (Select id from table where y=z)

    I am using EJB 1.1 and weblogic 6.1 sp1.
    Could you help me in writing a query for this?

    Thanks,
    Sejal

  • RELEVANCY SCORE 2.45

    DB:2.45:Java &Amp; Nested Queries ... Urgent ! dz


    Hey people !

    I have coded my program to run multiple queries using nested Result Sets. This nested Result Sets worked fine ! Note that, I have 3 SQL`s and each is returning fine results.

    Now, when I query more than 4 columns in my 1st SQL it gives NullPointerException.

    I`m using Oracle 8i and Classes12.zip at the JDBC driver.

    What should I do ?

    DB:2.45:Java &Amp; Nested Queries ... Urgent ! dz

    OK, two big glaring issues that I see. The first is, as I stated earlier, the innerRset is being queried before it has been initialized.ResultSet innerRset = null;
    out.println("BR"+myQuery1 +"BR");
    while (outerRset.next())
    {
    System.out.println("I`m in OuterRset");
    System.out.println(outerRset.getString(2) );
    String[] columnsLot = new String[15];
    columnsLot[0] = outerRset.getString(1);
    columnsLot[1] = outerRset.getString(2);
    columnsLot[2] = outerRset.getString(3);
    columnsLot[3] = outerRset.getString(4);
    columnsLot[4] = innerRset.getString(5);Your innerRset is null when columnsLot[4] is being loaded, so a NullPointerException should be thrown here. Perhaps you wanted outerRset.getString(5)?

    The second issue is that I only see one Statement declaration in your code, and this is a definite no-no for nested ResultSets. Any given Statement object can have AT MOST one active ResultSet. Open a second ResultSet and the first ResultSet is automatically closed. For proper operation of nested ResultSets you'll need two separate Statement declarations in your code.Statement statement1 = conn.createStatement();
    Statement statement2 = conn.createStatement();
    ...
    ResultSet outerRset = statement1.executeQuery(sql);
    ...
    ResultSet innerRset = statement2.executeQuery(sql);

  • RELEVANCY SCORE 2.45

    DB:2.45:Query k8



    I have the queries that get values from other two tables and then insert those values into the final tables. My code below did not inserted the correct record.

    Thanks

    !---list all purNo, padNo where purNo = 3215---Cfquery name="getDetails" datasource="#dsn#"select purNo, padNo from tbl_details where purNo = 3215/Cfquery

    !---list all cusNO where purNo = 3215---Cfquery name="getCust" datasource="#dsn#"select cusNO from tbl_customer where purNo = 3215/Cfquery

    From the form, I have one text box for user to enter new date then hit submit. Once submit button is clicked, I would like to get the results from above two queries to insert into tblOrder.

    cfset note ="new date changed from" /

    cfloop query="getDetails"cfloop query="getCust"

    cfquery name="insert" datasource="#dsn#"

    insert into tblOrder (purNo, padNo, cusNO, note)

    values

    (

    cfqueryparam value ="#getDetails.purNo#" /,

    cfqueryparam value ="#getDetails.padNo#" /,

    cfqueryparam value = "#getCust.cusNO#" /,

    cfqueryparam value="#note# #getDetails.old_ate# 'to' #form.new_date#" /

    )

    /cfquery

    /cfloop/cfloop

    DB:2.45:Query k8


    You could do a join, enabling you to use just one query. Something like

    !--- space appended ---

    cfset note ="new date changed from " /

    Cfquery name="getCustDetails" datasource="#dsn#"

    select tbl_details.purNo, tbl_details.padNo, tbl_customer.cusNO

    from tbl_details, tbl_customer

    where tbl_details.purNo = tbl_customer.purNo

    and tbl_details.purNo = 3215

    /Cfquery

    cfloop query="getCustDetails"

    !--- note: 'old_date' replaces 'old_ate' and " to " replaces "to" ---

    cfset note = note getCustDetails.old_date " to " form.new_date

    cfquery name="insert" datasource="#dsn#"

    insert into tblOrder (purNo, padNo, cusNO, note)

    values

    (

    cfqueryparam value = "#getCustDetails.purno#" cfsqltype = "cf_sql_varchar" /,

    cfqueryparam value = "#getCustDetails.padNo#" cfsqltype = "cf_sql_varchar" /,

    cfqueryparam value = "#getCustDetails.cusNO#" cfsqltype = "cf_sql_varchar" /,

    cfqueryparam value = "#note#" cfsqltype = "cf_sql_varchar" /

    )

    /cfquery

    /cfloop

  • RELEVANCY SCORE 2.45

    DB:2.45:Need Help In Assigning New Datasource kk



    Hi Experts,

    I have a pre-created report and I need to change the datasource used. Currently the report is using two BW queries and I need to replace both queries with a single query that I modified. I tried removing both queries using the Database Expert and then assigning a new one but the mapping fields window won't appear. I am pretty sure I am doing something wrong. Can someone please post the correct steps? Any help will be greatly appreciated.

    Thanks!

    DB:2.45:Need Help In Assigning New Datasource kk


    Hi Experts,

    I have a pre-created report and I need to change the datasource used. Currently the report is using two BW queries and I need to replace both queries with a single query that I modified. I tried removing both queries using the Database Expert and then assigning a new one but the mapping fields window won't appear. I am pretty sure I am doing something wrong. Can someone please post the correct steps? Any help will be greatly appreciated.

    Thanks!

  • RELEVANCY SCORE 2.44

    DB:2.44:Nested Queries s1


    Hi,

    I am trying to use the resultset of one query to run against another and I need to use a nested query. Does anybody know how to do this? It seems that I need to close one query to open another. Is there a way around this dilemma? I cannot use a join in this instance...
    Thanks!

    DB:2.44:Nested Queries s1

    Hi,
    I am using a Blazix web server, and it does not seem to understand the resultsetmeta data. Any other suggestions? And also the table contains both strings and integers.
    Any other suggestions?
    Thanks!

  • RELEVANCY SCORE 2.44

    DB:2.44:Problem About Ejb-Ql Compile In Cmp 2.X 93



    i desperately need your help, i can't deploy my cmp, it always saysorg.jboss.deployment.DeploymentException: Error compiling EJB-QL statement ''; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not found)my ejb-jar.xml: query-method method-namefindByName/method-name method-params method-paramjava.lang.String/method-param method-paramjava.lang.String/method-param /method-params /query-method ejb-ql ![CDATA[ SELECT OBJECT(o) FROM TestEntity o WHERE o.firstName = ?1 AND o.lastName = ?2 ]] /ejb-qland my jbosscmp-jdbc.xml: java:/jbossDS datasource-mappingMS SQLSERVER2000/datasource-mappingwhat is the problem? i have check it thousands times.thanks in advance.

    DB:2.44:Problem About Ejb-Ql Compile In Cmp 2.X 93


    i desperately need your help, i can't deploy my cmp, it always saysorg.jboss.deployment.DeploymentException: Error compiling EJB-QL statement ''; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not found)my ejb-jar.xml: query-method method-namefindByName/method-name method-params method-paramjava.lang.String/method-param method-paramjava.lang.String/method-param /method-params /query-method ejb-ql ![CDATA[ SELECT OBJECT(o) FROM TestEntity o WHERE o.firstName = ?1 AND o.lastName = ?2 ]] /ejb-qland my jbosscmp-jdbc.xml: java:/jbossDS datasource-mappingMS SQLSERVER2000/datasource-mappingwhat is the problem? i have check it thousands times.thanks in advance.

  • RELEVANCY SCORE 2.44

    DB:2.44:Sqlj Query Help d8


    I ran the following query first with SQLplus and it returns without problems; but in SQLJ it blocks my app, is Ok to have nested queries in JDBC?

    int p_iCodpedv=442

    #sql [m_ctx] { update item_pedido_venta it set cant_aprob=0
    where it.codpedv= (select pedido.codpedv from pedido_venta pedido,
    inventario inv where it.codpedv=pedido.codpedv and it.codprod=inv.codprod
    and inv.codemp=pedido.codemp and inv.codsuc=pedido.codsuc
    and inv.existencia=0 and it.codpedv=:p_iCodpedv)};Thank you

    DB:2.44:Sqlj Query Help d8

    There should not be any difference.

    Depending on how you created your connection, auto-commit may or may not be turned on. While this can make a difference in certain cases (such as when using SELECT ... FOR UPDATE...) I do not see how this could have an effect in your case.

    It would be nice to get more information or -better- a reproducible test case.

  • RELEVANCY SCORE 2.44

    DB:2.44:Custom Datasource On Dso sp



    Hi All,

    I have built a query on Invoice Detail DSO and included it in SPM UI as a standard query. I dont need this query as jump target hence it is included as standard query. My question here is, is it not possible to have standard datasources on SPM where the Bex queries are on DSO? I added this datasource but it dint reflect in datasource list in Adminstration - Datasouce properties, whereas all the data sources i add based on queries built on Cube/ Multiprovider are seen there.

    Regards,

    Sampat Desai

    DB:2.44:Custom Datasource On Dso sp


    Hi All,

    I have built a query on Invoice Detail DSO and included it in SPM UI as a standard query. I dont need this query as jump target hence it is included as standard query. My question here is, is it not possible to have standard datasources on SPM where the Bex queries are on DSO? I added this datasource but it dint reflect in datasource list in Adminstration - Datasouce properties, whereas all the data sources i add based on queries built on Cube/ Multiprovider are seen there.

    Regards,

    Sampat Desai

  • RELEVANCY SCORE 2.44

    DB:2.44:Queries For Sap Bw And Sap Bw Mdx Data Sources. km



    Hi All,

    When selecting query using "Set Datasource Location" option, datas fetched by selecting the query from SAP BW Query datasource are not the same when i select the same query from SAP BW MDX Query folder.

    Can anyone help me in solving this issue?Is there any difference in queries for the datasources.Or Can i use the same query for those two data sources?

    DB:2.44:Queries For Sap Bw And Sap Bw Mdx Data Sources. km


    Hi,

    the BW Query Driver is an old version (several years old) of the BW connectivity and the BW MDX Driver is the newer enhanced version which is recommended to be used

    Ingo

  • RELEVANCY SCORE 2.44

    DB:2.44:How To Disable Nested Loop Option On A 10gr2 Olap Environment? jx


    is it possible to disable nested loop option on a 10gR2 OLAP environment? There are some thousands of automatically generated report queries and whenever a join is needed we want to force hash join if possible(equality) or sort merge but never nested loop. optimizer sometimes can go for NL because of broken ETL, last steps as collecting statistics can not be finished successfully before the users start to do their reporting.

    of course looking for a global parameter and do not want to hint each and every possible report query :)

    thank you.

    DB:2.44:How To Disable Nested Loop Option On A 10gr2 Olap Environment? jx

    is it possible to disable nested loop option on a 10gR2 OLAP environment? There are some thousands of automatically generated report queries and whenever a join is needed we want to force hash join if possible(equality) or sort merge but never nested loop. optimizer sometimes can go for NL because of broken ETL, last steps as collecting statistics can not be finished successfully before the users start to do their reporting.

    of course looking for a global parameter and do not want to hint each and every possible report query :)

    thank you.

  • RELEVANCY SCORE 2.43

    DB:2.43:Query Help Nested In Query Getting Error: Queries With Local Collections Are Not Supported x9


    var productIDs = from p in db.Products where p.ID == productID || p.ParentID == productID select p.ID;   var fileinfoIDs = from d in db.DocumentProductFiles where productIDs.Contains(d.ProductID) select d.FileInfoID;   var files = from f in db.DocumentFileInfos  where fileinfoIDs.Contains(f.ID) where f.CategoryID == categoryID orderby f.DateUpdated descending select f; 

    DB:2.43:Query Help Nested In Query Getting Error: Queries With Local Collections Are Not Supported x9

    This is likely a bug in LINQ to SQL.  Have you tried writing the query an a single expression instead of broken into separate variables.  My guess is that L2S is confusing a local variable containing a piece of the query as a local collection.Wayward LINQ Lacky

  • RELEVANCY SCORE 2.43

    DB:2.43:Analysis For Office Using Bw Datasource And Boe Landscape Promotion fp



    Hi,

    We have AO workbooks that have BW queries embedded ( not BI OLAP connection queries, but queries inserted using Data Sources and then logging onto a BW system ) and we are storing the AO files in a BI4 SP4 Patch 2 system. The AO workbooks are saved in a BOEDEV system and the BW queries selected were from the BW DEV system.

    We promoted these AO files to the BOEQA system using BI Promotion Management. When we launch the AO workbooks from BOEQA the BW query still points to the BW DEV system. Is there specific configuration required in the CMC / BI system to update the system reference for the BW query as the AO file moved through the landscape?

    The BW queries used in the AO workbooks exist in all of our BW environments.

    If anyone has any insight into this problem feedback would be appreciated.

    Thanks, Mel

  • RELEVANCY SCORE 2.43

    DB:2.43:Nested Select Count(*) Sub Queries k8


     
    I've seen many LINQ to SQL queries that generate a query with a nested sub-query that is essentially a Select Count(*)
     
    For example the following LINQ query...
     

    Code Snippet

    DB:2.43:Nested Select Count(*) Sub Queries k8

    Thanks Matt although I'm thinking that it's still not 100% necessary and maybe it's a little extra strain on the SQL Server. Is there a way to turn this off? I'm assuming this would cause a little extra overhead on the client side to iterate through the records to know exactly how many objects to materialize.
     
    Barry Gervin
    www.ObjectSharp.com/Barry
     

  • RELEVANCY SCORE 2.43

    DB:2.43:Subquery And Nested Query c9


    i was 1 question in intrvw

    what is the diffference b/w Subquery and Nested Query?

    manish.

    DB:2.43:Subquery And Nested Query c9

    i was 1 question in intrvw

    what is the diffference b/w Subquery and Nested Query?

    manish.

  • RELEVANCY SCORE 2.43

    DB:2.43:Can We Use Query Of Queries To Insert Into A Db Table? 71


    Hi,

    Can we use Query of Queries to insert into database. For example:

    Here email value is obtained from an array.

    cfquery name="chkexistingrecord" datasource="#DSN#"

    select * from records where email = #arrDat[i][3]#

    /cfquery

    cfif chkexistingrecord.recordcount gte 1

    cfquery name="insertduplicate" dbtype="query"

    INSERT INTO [Duplicate_Records]

    (

    [record created]

    ,[record updated]

    ,[email]

    values

    #chkexistingrecord['record created'][1]#

    ,#chkexistingrecord['record updated'][1]#

    ,#chkexistingrecord['email'][1]#

    )

    /cfquery

    Both records and the Duplicate records tables are in the same database. When I

    tried doing this I got the following error.

    Message: Error Executing Database Query.

    Detail: Query Of Queries syntax error.

    Encountered "INSERT.

    DB:2.43:Can We Use Query Of Queries To Insert Into A Db Table? 71


    As an aside, if "duplicate_records" represents some sort of history / audit table you may want to chose a different naming convention. Going strictly off of objects names, I thought the code was searching for duplicate records

  • RELEVANCY SCORE 2.43

    DB:2.43:Debug Source Qualifier Transformation Query With Multiple Left Joins fz



    I have a source qualifier query with multiple nested left outer joins. This was developed by some one many years back. Now some changes were made and I have to test it. To test the data I've started creating dummy data satisfying all joins. Now there are like 15 source tables so Im confused where to start. what will be the best approach to start debugging the query. Please post your experiences and insights that might help me in debugging the existing SQ override queries, Cause I've to deal with so many queries like this.

    DB:2.43:Debug Source Qualifier Transformation Query With Multiple Left Joins fz


    Debugging a query with 15 nested joins?

    If at all possible, don't bother trying this. Use relational Source Qualifiers for each table which select the data in question, then use Joiner transformations to join these data streams. If at all possible, make sure that the data are always sorted by join key, this not only speeds up processing but also minimises the building of cache files for the Joiner transformations.

    I know that's easy to say for me, but I simply refuse to debug SQL queries; rebuilding them in PowerCenter usually is faster, safer, more stable, easier to debug, and easier to extend than rebuilding such SQL queries. But that's just my personal attitude.

    Regards,

    Nico

  • RELEVANCY SCORE 2.42

    DB:2.42:Strange Eq / Evaluation Behavior jj


    Hello all,

    I'm a longtime CF developer who's experiencing strange
    behavior on a page being run on MX 6.

    I've got two queries that are nested and that I loop through.
    I have a query variable for the top level query
    (qGetRevenues.liUID), and I have a query variable for the nested
    query (qGetLineItems.UID). If you look at my code, I am trying to
    get it so that in the select box, as the nested query loops and
    builds options, I would like the option that matches the current
    value to be the pre-selected option in the box. For whatever
    reason, it is setting all of the boxes to the first option choice,
    and not the correct option

    Code:
    cfquery name="qGetLineItems"
    datasource="#application.dsn#"
    SELECT UID,
    Description
    FROM tLineItems
    ORDER BY Description
    /cfquery

    cfquery name="qGetRevenues"
    datasource="#application.dsn#"
    SELECT tLineItems.Description,
    tLineItems.UID as liUID,
    tObjectRevenues.UID,
    tObjectRevenues.Amount,
    tObjectRevenues.Monthly,
    tObjectRevenues.Annually,
    tObjectRevenues.Comments,
    tObjectRevenues.sortOrder
    FROM tLineItems INNER JOIN tObjectRevenues ON tLineItems.UID
    = tObjectRevenues.liUID
    /cfquery

    form action="?action=edit" method="post"
    cfoutput
    cfloop query="qGetRevenues"
    tr
    tdinput type="Checkbox" name="riUID"
    value="#UID#"/td
    td#qGetRevenues.Description#/td
    td class="admin"
    select name="rLI#UID#"
    cfloop query="qGetLineItems" startrow="1"
    option value="#qGetLineItems.UID#" cfif
    qGetRevenues.liUID EQ qGetLineItems.UIDselected/cfif
    #qGetLineItems.Description#
    /cfloop
    /select
    /td
    /tr
    /cfloop
    /cfoutput

    Am I experiencing some sort of weird variable type issue (ie
    trying to perform a mathematical computation on string vs. string
    or string vs. numeric)? HELP!

    DB:2.42:Strange Eq / Evaluation Behavior jj

    CRidgeway,

    Here's the error that pops with the first code.

    [Table (rows 8 columns DESCRIPTION, LIUID, UID, AMOUNT,
    MONTHLY, ANNUALLY, COMMENTS, SORTORDER): [DESCRIPTION:
    coldfusion.sql.QueryColumn@e07209] [LIUID:
    coldfusion.sql.QueryColumn@15ec5f0] [UID:
    coldfusion.sql.QueryColumn@115407a] [AMOUNT:
    coldfusion.sql.QueryColumn@3c2e0b] [MONTHLY:
    coldfusion.sql.QueryColumn@f2f72c] [ANNUALLY:
    coldfusion.sql.QueryColumn@1419025] [COMMENTS:
    coldfusion.sql.QueryColumn@15e780a] [SORTORDER:
    coldfusion.sql.QueryColumn@11ada40] ] is not indexable by 1

    And I tried the exact same thing as the second possible fix,
    to no avail. Thanks for trying though...

  • RELEVANCY SCORE 2.42

    DB:2.42:Nested Query 3d


    In a nested select query, what are key features to look into to improve performance

    DB:2.42:Nested Query 3d

    Correlated or non-correlated?

    If correlated, you should consder an index on the join key between the inner and outer tables.

    If non-correlated you can tune the sub-query independently.

  • RELEVANCY SCORE 2.42

    DB:2.42:Sample Reports Using Different Queries az


    from where i can download sample videos or document file, for creating these sample reports:-
    i have tried but have'nt got

    b) Query with filters c)Query with complex filters d) Query with sort e) Query with complex joins f) Query with nested queries g) Corelated Queries f) Aggregation on SQL Query

    Please send some hyperlink so that i can get videos or in the form of document file

    DB:2.42:Sample Reports Using Different Queries az

    Hi,
    Please refer to this link: http://msftrsprodsamples.codeplex.com/Wikipage
    Also, you may follow this tutorial to learn how to build a report step by step: http://msdn.microsoft.com/en-us/library/ms170246(SQL.90).aspx
    Hopefully this helps.Yao Jie Tang -Microsoft Online Community

  • RELEVANCY SCORE 2.41

    DB:2.41:Querying The Datasource In Other Instance c1


    is there a way i can query a table from datasource wich is in other instance in case of linked servers? is there a way to do it i saw we can do with distributed queries ,can some one help me with some sample example or refrence links thanks

    DB:2.41:Querying The Datasource In Other Instance c1

    As far you have your linked server configured properly you can run queries agains different servers (more details of linked servers here
    http://msdn.microsoft.com/en-us/library/ms188279.aspx)
    After that you can use your linked server in your queries using the multipart stament like SELECT * FROM YourLinkedServer.AdventureWorks.Person.Address

  • RELEVANCY SCORE 2.41

    DB:2.41:Oas 10g War File Deployment Error (Errors In Named Queries) js


    Hi again,

    I setup a 10G 10.1.3.1 Application Server and tried deploying my WAR file. In tomcat the WAR file deployment works fine. however in OAS I get this error and currently I'm clueless as to what causes the error.

    [Oct 24, 2007 6:03:37 PM] Operation failed with error: Error creating bean with name 'entityManagerFactory' defined in ServletContext resource [WEB-INF/applicationContext.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: org.hibernate.HibernateException: Errors in named queries: Book_List_By_RegisterDate ... (other named queries)

    My ApplicationContext.xml file contains this
    bean id="entityManagerFactory"
    class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"
    property name="persistenceUnitManager" ref="persistenceUnitManager" /
    property name="persistenceUnitName" value="BookStudy" /
    property name="dataSource" ref="dataSource" /
    property name="jpaVendorAdapter"
    bean
    class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter"
    property name="database" value="ORACLE" /
    property name="showSql" value="true" /
    /bean
    /property
    /bean

    And a sample named query in the hbm.xml file is this

    query name="Book_List_By_RegisterDate"
    from BookData
    where to_char(regdate, 'MM/dd/yyyy') = to_char(:regdate, 'MM/dd/yyyy')
    order by Author.author_name desc, bookname desc
    /query

    Thanks,

    DB:2.41:Oas 10g War File Deployment Error (Errors In Named Queries) js

    Uncomment, or add, the following line in your application's orion-web.xml file:

    web-app-class-loader search-local-classes-first="true" include-war-manifest-class-path="true" /

    See njr28's comments @ http://forum.hibernate.org/viewtopic.php?t=951324highlight=oc4j

  • RELEVANCY SCORE 2.41

    DB:2.41:How To Keep Analysis For Office Workbooks Changing The Datasource Query f7



    Hi all,

    We have many customers using complex Analysis for Office workbooks created by themselves, however they were using 3.x queries and now we need to replace the queries with 7.x queries with a different technical name.

    We tried by changing the datasource in "components", here we change the 3.x query for the new 7.x query. The problem is that the workbook layout is changed to the initial layout of the query, the workbook layouit saved by the user changes.

    Do you know a way to chenge the query behind keeping the layout of the workbook?

    Thanks in advance

    DB:2.41:How To Keep Analysis For Office Workbooks Changing The Datasource Query f7


    Hi Andrew,

    I'm very sorry for the late reply, but we were testing many options, and as you say the workbook layout doesn't change if we keep the same technical name, the version can change from 3.x to 7.x.

    However we cannot implement it because we must change the technical name.

    Anyway thanks for the answer it was really useful.

    Kind Regards

  • RELEVANCY SCORE 2.41

    DB:2.41:Can You Set Datasource In Crystal Xi Report To Union Query In Access 2007? sp



    Hi all,

    I have been able to install Office 2007 OLE DB Driver with Crystal Reports which allows me to link my Crystal XI Report to my Access 2007 Db. Unfortunately, my Union Query is not available in my drop down list when I set my datasource. I can see my two tables and two other queries. Just can't see the Union query. Does Crystal XI recognize and am I able to use a Union query as a data source?

  • RELEVANCY SCORE 2.41

    DB:2.41:Nested Object Collection Datasource 7f


    HiI am binding an Object Datasource into WEB FORM Report Viewer Control in Local Mode. Object Source contains child/nested object collection. In order to bind this, I used the expression, like this ParentPropertyName.Value.ChildPropertyName, as most of the posts suggested (http://www.gotreportviewer.com/objectdatasources/index.html) . But Still I am getting #Error while rendering.  Do I need create sub report in order to bind the Child Object Collection?My RDLC file Dataset Info for you reference. The Child object collection, name is FailedCourses.
    DataSets
    DataSet Name=AthleticEligibilityReport
    Fields

    Field Name=StudentName

    DataFieldStudentName/DataField
    rd:TypeNameSystem.String/rd:TypeName
    /Field
    Field Name=DateOfBirth
    DataFieldDateOfBirth/DataField
    rd:TypeNameSystem.Nullable`1[System.DateTime]/rd:TypeName
    /Field
    Field Name=Age
    DataFieldAge/DataField
    rd:TypeNameSystem.Int32/rd:TypeName
    /Field
    Field Name=FailedCourses
    DataFieldFailedCourses/DataField
    rd:TypeNameAthleticEligibilityFailedCoursesReport[]/rd:TypeName
    /Field

    /Fields

    Query
    DataSourceNameAthleticEligibilityReport/DataSourceName
    CommandText
    /CommandText
    rd:UseGenericDesignertrue/rd:UseGenericDesigner
    /Query
    rd:DataSetInfo
    rd:DataSetName
    /rd:DataSetName
    rd:TableName
    /rd:TableName
    rd:ObjectDataSourceTypeReportsDAL, App_Code.np0i0gm0, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null/rd:ObjectDataSourceType
    /rd:DataSetInfo
    /DataSet
    /DataSetsAmzu

    DB:2.41:Nested Object Collection Datasource 7f

    This is the answer for this post. http://www.gotreportviewer.com/objectdatasources/index.html. That is I need to create a sub report to bind the Child Object Collection. Amzu

  • RELEVANCY SCORE 2.41

    DB:2.41:Nested Query In Where Clause xp


    Hi, I saw some reports using nested queries in reports, I am newbie so need some help. I have isa and mcafee web gateway logs in web table and I want to locate top ten social network users. Isa has user info and web gateway has category information. I want to link both of them. Regards Usman

    DB:2.41:Nested Query In Where Clause xp

    hi, i was actually referring to device_list table in nested queries, which after studying the architecture found out is the only one that can be used in nested query. Anyway i have gained that information using Event Explorer. regards usman

  • RELEVANCY SCORE 2.40

    DB:2.40:Re: Order By - Nested Queries xx


    Hi,

    i_i cannot reach to 2nd level of subquery.
    You may have to think about the logic of the query again may be by writing in different way.

    Regards
    Anurag Tibrewal.

    Wont this solve your problem

    i_i.END_COMPETENCY_DATE - h_internal.END_COMPETENCY_DATE

    Edited by: Anurag Tibrewal on Sep 21, 2009 4:25 PM

    DB:2.40:Re: Order By - Nested Queries xx

    Yes the logial steps are the following:

    1. I look for the item in the same month ( for example 01/2009)
    2. I find the headers corresponding
    3. I choose between these headers the latest ( then with the greater INVOICING_DATE)
    4. I return the id_invoice and the date of INVOICING_DATE

  • RELEVANCY SCORE 2.40

    DB:2.40:Nested Table Queries 8m


    Hai all,
    When querying a nested table gets the output as
    sqlselect * from manfs;
    NAME ADDR BEERS(NAME, KIND, COLOR)
    Man1 Addr1 BEERTABLETYPE(BEERTYPE('Beer1Man1 ', 'Strong ', 'Red '), BEERTYPE('Beer2Man1 ', 'Mild ', 'Green ')) Can I ,anyhow , query the table to get the o/p in a more readable format?
    Any documents? Me searched but failed..
    Thanks ..

    jeneesh

  • RELEVANCY SCORE 2.40

    DB:2.40:Jboss 4.0 And Mysql Configuration sf



    I'm having a problem configuring MySQL with JBoss 4.0. The same configuration that works for JBoss 3.2.3 doesn't work. I get the following exceptions when deploying the mysql-ds.xml file in the default/deploy directory: local-tx-datasource jndi-nameDefaultDS/jndi-name connection-urljdbc:mysql://localhost:3306/X/connection-url driver-classorg.gjt.mm.mysql.Driver/driver-class user-nameroot/user-name /local-tx-datasourceException:2004-02-05 15:40:02,893 ERROR [org.jboss.mq.pm.jdbc2.PersistenceManager] Starting failed: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query)))2004-02-05 15:40:02,893 WARN [org.jboss.system.ServiceController] Problem starting service jboss.mq:service=PersistenceManagerorg.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query))) at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:287) at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1255) at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:233) at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:72)...Caused by: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query))Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Can not issue empty query)Caused by: java.sql.SQLException: Can not issue empty queryNow, 3.2.3 had a mysql-jdbc2-service.xml file deployed in the default/deploy/jms directory but I don't see a corresponding one for the 4.0 installation.Anybody have any ideas or has successfully configured 4.0 with mySQL?Thanks for any help,Mike

    DB:2.40:Jboss 4.0 And Mysql Configuration sf


    From looking at the JBoss source code (for 4.0 DR2), the actual SQLException that is raised in the JDOAbstractCommand class is lost and with it the actual cause. Does anybody have any idea on what is going on here?Thanks,Mike

  • RELEVANCY SCORE 2.40

    DB:2.40:Odbc Datasource For Sn Instance sx



    experts questions.

    1. how to find on what backend database is our SN instance running? Trying to configure ODBC linked server connection as outlined in wiki. But how to find out the datasource or database name of our SN instance used to establish ODBC connection ?

    2. can we write sql queries to select or update cmdb_ci tables using backend or odbc ? can we only use gliderecord to query cmdb_ci tables from SN instance?

    DB:2.40:Odbc Datasource For Sn Instance sx


    1. The backend is MySQL.

    You have to use the instructions for setting up the ODBC driver first. ODBC Driver - ServiceNow Wiki

    Then once you have the ODBC setup, use the linked server SQL instructions to connect to the ODBC datasource (DSN) you setup. Using ODBC Driver in SQL Server 2008 and 2012 - ServiceNow Wiki

    2. You can't update records through the linked server connection or ODBC. It's read only.

  • RELEVANCY SCORE 2.40

    DB:2.40:Re: Sql Nested Query pp


    JSP technology is irrelevant to the SQL you run.
    You can run any SQL through JDBC as long as your underlying database and jdbc driver support it.

    So the question becomes does your database support nested queries like that?

    As long as the database accepts the SQL query, and returns the appropriate result, your java/jsp code can handle it.

    DB:2.40:Re: Sql Nested Query pp

    sorry guys.. just wanna does Sun microsystem provide downloads for this driver??? if they do can what's the link .. cos there are so many of them..

  • RELEVANCY SCORE 2.40

    DB:2.40:Performance Of Batch Processing With Multipleactiveresultsets = True Is Very Inconsistent 1k


    Hi,I have a batch process running which interacts with the database. It contains several nested and non-nested SELECT query. Previously the non-nested SELECT query used DataReader whereas the the nested SELECT query used SQLCursor. Currently I am trying to migrate the nested SELECT queries to use datareader with the help of turning MultipleActiveResultSets(MARS) on.But we are seeing a very high deviation in the elapsed time(varing from 900sec to 1200sec) of the batch after this.The machine and all other parameter were kept constant across the runs.Has anyone encounted such a thing and if so how was it resolved?Also can anyone please tell me how MARS works internally. How are multiple datareaders maintained within a single connection.RegardsNasiq.

    DB:2.40:Performance Of Batch Processing With Multipleactiveresultsets = True Is Very Inconsistent 1k

    Hi,I have a batch process running which interacts with the database. It contains several nested and non-nested SELECT query. Previously the non-nested SELECT query used DataReader whereas the the nested SELECT query used SQLCursor. Currently I am trying to migrate the nested SELECT queries to use datareader with the help of turning MultipleActiveResultSets(MARS) on.But we are seeing a very high deviation in the elapsed time(varing from 900sec to 1200sec) of the batch after this.The machine and all other parameter were kept constant across the runs.Has anyone encounted such a thing and if so how was it resolved?Also can anyone please tell me how MARS works internally. How are multiple datareaders maintained within a single connection.RegardsNasiq.

  • RELEVANCY SCORE 2.40

    DB:2.40:Generating Nested Xml Documents k9


    Hi,
    We want to generate nested XML documents from sql queries using pl/sql.
    If the output of the query is
    EMPNO NAME MGRNO
    ---------- ------------------------------ ----------
    1 Super Admin 0
    2 Mgr1 1
    4 SubMgr1_1 2
    5 SubMgr2_1 2
    3 Mgr2 1
    6 SubMgr1_2 3

    then XML generated should be in the format

    Super Admin
    Mgr1
    SubMgr1_1
    SubMgr2_1
    Mgr2
    SubMgr1_2

    Your early response is appreciated.

    Thanks.

    DB:2.40:Generating Nested Xml Documents k9

    Hi,
    We want to generate nested XML documents from sql queries using pl/sql.
    If the output of the query is
    EMPNO NAME MGRNO
    ---------- ------------------------------ ----------
    1 Super Admin 0
    2 Mgr1 1
    4 SubMgr1_1 2
    5 SubMgr2_1 2
    3 Mgr2 1
    6 SubMgr1_2 3

    then XML generated should be in the format

    Super Admin
    Mgr1
    SubMgr1_1
    SubMgr2_1
    Mgr2
    SubMgr1_2

    Your early response is appreciated.

    Thanks.

  • RELEVANCY SCORE 2.40

    DB:2.40:Nested For Xml Queries / With Namespaces 1d


    I want to assign the result of a FOR XML query containing nested queries to an xml variable.  The problem is, the namespace declarations propagate down to every nested element generated in the query.
     
    DECLARE @x xmlBEGIN  WITH XMLNAMESPACES('one' AS ns1, 'two' AS ns2)  SELECT @x = (    SELECT -1 @id,           'invalid' @status,           (SELECT 'false' @flag,                   'etc' @comment              FOR XML PATH ('ns2:inner'), TYPE)      FOR XML PATH('ns1:0uter'), TYPE);  SELECT @xEND;
     
    This is the XML that is generated:
     
    ns1:0uter xmlns:ns2=two xmlns:ns1=one id=-1 status=invalid  ns2:inner xmlns:ns2=two xmlns:ns1=one flag=false comment=etc //ns1:0uter
     
    Is there an alternate way to declare a namespace in a nested query (in this case, move the namespace declaration for 'two AS ns2' out of the outer query into the nested select)?  If not, then are there alternative ways to remove this extraneous stuff?  This is a simple example, but real-world instances involving several levels of nesting these declarations are too much.

    DB:2.40:Nested For Xml Queries / With Namespaces 1d

    There is a connect for that. Please vote.
    https://connect.microsoft.com/SQLServer/feedback/details/265956/suppress-namespace-attributes-in-nested-select-for-xml-statements
    As I'm sure you are aware, the additional namespaces don't do any harm but can bloat the XML. There are methods of removing it, eg global find and replace, XSLT, some custom .net code etc, and the old-school way using FOR XML EXPLICIT, which is a bit
    hard to use.
    What is the particular reason you need to remove it? Is it just because it is ugly, or is the file so big it's unmanageable?

  • RELEVANCY SCORE 2.40

    DB:2.40:Querying Data Across Two Different Data Sources (One Sql And The Other Oracle) ma


    What is the proper way to create a query using the tableadapters or designer to query across multiple data sources.  In the designer it appearsthat the queries can only contain information from one datasource at a time.Any suggestion how to accomplish.  I would like to take a table from an SQL datasource and use some of its fields to query into an Oracle database on a different datasource and server.

    DB:2.40:Querying Data Across Two Different Data Sources (One Sql And The Other Oracle) ma

    What is the proper way to create a query using the tableadapters or designer to query across multiple data sources.  In the designer it appearsthat the queries can only contain information from one datasource at a time.Any suggestion how to accomplish.  I would like to take a table from an SQL datasource and use some of its fields to query into an Oracle database on a different datasource and server.

  • RELEVANCY SCORE 2.39

    DB:2.39:Bug In Cf11 Regarding Query Of Queries Syntax? pm



    So I have decided to try CF11 because of an official outstanding CF10 bug.

    Once I installed CF11, I get an error when running code like this:

    cfquery name="LOCAL.stat_questions" datasource="#APPLICATION.dsn#"
    SELECT survey_questionID
    FROM tbl_survey_questions
    ;
    /cfquery

    cfset LOCAL.this_statID = 1

    cfquery name="LOCAL.subset" dbtype="query"
    SELECT survey_questionID
    FROM [LOCAL].stat_questions
    WHERE survey_questionID = cfqueryparam cfsqltype="cf_sql_numeric" value="#LOCAL.this_statID#"
    ;
    /cfquery

    The error I receive is: "Query Of Queries syntax error. Encountered ";. "

    If I remove the semi-colon... No error! Is this a bug, or was the semi-colon always bad, but just ignored?

    Thanks

    DB:2.39:Bug In Cf11 Regarding Query Of Queries Syntax? pm


    I just always put it in out of habit from typing out actual MySQL queries (non QoQ). Never was a problem and I always did it. Now running CF11... it requires fixing. Thought it was strange.

    I actually didn't even notice that the semi-colons weren't required in QoQ until I ran into this CF11 bug. I also notice the semi-colon isn't necessary for a MySQL query either in cfquery! Seems weird that it accepts them, but isn't required. Just ignores them?

  • RELEVANCY SCORE 2.39

    DB:2.39:Can We Build Nested Querie In Vc kx



    Hi all,

    Can we build nested queries in Visual composer?

    (i.e the result of one query should be the result of another query)

    Thanks

    Rani

    DB:2.39:Can We Build Nested Querie In Vc kx


    Hi,

    Is there any way by taking the results of the first query and getting the output of another query, in visual composer for BI applications.

    According to me one option is that in the bw itself i can use the replacement path variable by getting the result.

    Is there any option of taking the result of one query as an output for other query in visual composer level. If yes please tell me how it can be acheived?

    Thanks

    rani.

  • RELEVANCY SCORE 2.39

    DB:2.39:Identify Datasource For Standard Bex Query c9



    Hi,

    I am in SAP BI 7.3 EHP1. I have a requirement to install the BI content standard queries.

    User will give the standard BEx query name, then my challenge is to identify the datasource in the ECC for that paricular query. Then i must install the datasource in ECC and replicate it to the BI side.

    Now i need to identify the datasource in ECC for the BEx queries.

    I know that we can collect these details from "data flow before and after" in RSA1----BI content---grouping mode.

    I checked in BI content, for both query and for the infocube even though i have given "data flow before and after"i could not see the transformations, ECC datasource etc . Why is this case? Am i missing anything?

    DB:2.39:Identify Datasource For Standard Bex Query c9

    Source system release 701 is not the same as local information 700
    Message no. RSAR671
    Diagnosis
    The replicated system information (table RSBASIDOC) indicates that system RIXHRD040 has Basis Release 700. However, the system actually has Basis Release 701.
    System Response
    If BI Content is delivered for the Release, the system cannot find it when it collects the BI Content.
    Procedure
    Activate the source system and refresh the metadata

  • RELEVANCY SCORE 2.39

    DB:2.39:Convert 3.5 Queries To 7.0 Queries 8x



    Hi Gurus,

    How to convert 3.5 queries to BI 7.0 queries in Query Designer(BEx).

    Thanks

    Liza

    DB:2.39:Convert 3.5 Queries To 7.0 Queries 8x


    Hi Liza,

    When 3.5 queries are opened and saved using 7.0 query designer, they automatically gets coneverted into 7.0. The word of caution is that once you open and save them using 7.0 designer, you would not able to revert back to 3.5 version. Hope this helps.

    Thanks,

    Bansi.

  • RELEVANCY SCORE 2.38

    DB:2.38:Query Strategy pc


    I notice that you can create queries in the DataSource container by designing a Query for a give entity.
    I also notice that if you build a screen against a complete entity set, you can edit the query for the screen in the screen designer.
    Are these two methods equivalent? Does it matter if you are using 2 tier or 3 tier deployment, web or desktop?Roger

    DB:2.38:Query Strategy pc

    Another difference between screen queries and global queries is that global queries have a PreprocessQuery interception method. This interception method allows you to define more complex queries that cannot be defined within the query designer.

  • RELEVANCY SCORE 2.38

    DB:2.38:How To Write Nested Queries Using Db Adapter? 89


    I want to write following nested query using DB Adapter can any one help...SELECT INVOICE_ID,FILE_NAME FROM BILLING_INVOICE_PDF_V where FILE_ID =((SELECT MAX(FILE_ID) FROM BILLING_INVOICE_PDF_V WHERE (INVOICE_ID = 12345)));Thanks,Ram.

    DB:2.38:How To Write Nested Queries Using Db Adapter? 89

    Hi Ananth,i did not recognize, Thanks for your time and help.

  • RELEVANCY SCORE 2.38

    DB:2.38:Qaaws - Multiple Queries For An Xcelsius Dashboard mj



    Hi,

    I created a webI report using two queries and I merged dimensions showed as a single report and creating a for an Xcelsius Dashboard. Now I am asked to use QaaWS as source and connect directly to this, without WebI as intermediate. Is this possible to to create multiple queries and merge dimensions in Qaaws. i do not see this option,1) any work round? My datasource is Multiprovider and not BEx Query.

    2) Can two different QaaWS queries can be used as source for a single dashboard?

    Please help.

    Nanda Kishore

  • RELEVANCY SCORE 2.38

    DB:2.38:Nested Select In Group By To Get Owner Of Max xk


    Hi,

    I have a table with columns PAGE_NUM, MOD_DATE, USER_ID, ID, etc.

    I want one query which groups records by PAGE_NUM and returns rows as follows:

    PAGE_NUM, count(PAGE_NUM), max(MOD_DATE) and USER_ID associated with max(MOD_DATE).

    I can do the 1st three, but don't know how to get the USER_ID associated with max(MOD_DATE) in one query. Maybe its faster anyways to do 2 queries?

    Andy

    DB:2.38:Nested Select In Group By To Get Owner Of Max xk

    Hi,
    user9990110 wrote:
    Hi,

    I'm using Oracle + Hibernate. Hibernate uses HQL which is the most common sql subset. It then runs that thru a parser to convert to SQL for Oracle. I think this query needs to be HQL friendly, and I'll research whether LAST is supported or not. If not, it will have to be a scalar subquery, and that's what I was trying to figure out how to do when I posted. I didn't realize that there was a faster way without the subquery. Also, Hibernate has a native SQL mode too, but I've found that it runs the native sql thru its parser too, and if it doesn't like it for some reason, it throws an exception. So I'm not sure LAST will work for me, and I know TopN won't. All this sounds like a good reason to use a view. Hibernate will think you're just referencing another table.
    So if you could show me the scalar subquery..., which I know works with Hibernate.Here's how to do that with a scalar sub-query:
    SELECT page_num
    , COUNT (page_num)AS cnt
    , MAX (mod_date)AS last_mod_date
    , ( SELECT MIN (user_id)
    FROM table_xs
    WHERE page_num= x.page_num
    AND mod_date= ( SELECT MAX (mod_date)
    FROM table_x
    WHERE page_num= s.page_num
    )
    ) AS last_mod_user_id
    FROM table_xx
    GROUP BY page_num
    ;By the way, what does DENSE_RANK do? Nothing that I know of. It's a mandatory keyword that must be used with FIRST and LAST. (It is not the same as the analytic DENSE_RANK function.)
    Is there a way to write your original query with LAST but without dense_rank?No.

  • RELEVANCY SCORE 2.38

    DB:2.38:Does Merge Dimension Button Work On Bi Olap Universe Webi Reports a9



    Hello all,

    we are using BI 7.0 queries as our datasource for creating universes. When we are using the webi rich client to create a query, there is add query button and we are able to add query but once I add query I am not able see the Merge dimensions button active, is there some setting that is missing or this capability is not active for BI OLAP query universes?

    Thanks in advance for the answers.

    DB:2.38:Does Merge Dimension Button Work On Bi Olap Universe Webi Reports a9


    Amit,

    Thanks for the reply, you are right I should have checked first in Dev or Qa. I do not have right security in Prod, but in dev and qa I do see the mereg button.

    Thanks,

  • RELEVANCY SCORE 2.38

    DB:2.38:Advanced Query 7j



    Hello,I am trying to do a left outer join query by doing a nested loop which queries left table's value with right table. You can imagine how inefficient this is and therefore was wondering if there was a better way to approach such queries. Also, the query returns a huge result and therefore is really tough to display effectively. I have used the setLimit function, but it only accepts upper bound. However, I know MySQL has a lower bound capability too such that I can do "LIMIT 30,60." Is there a way to use this using GlideRecord object.Thank You,Jay Desai

  • RELEVANCY SCORE 2.38

    DB:2.38:Database Authentication With Jboss/Jaas 3k



    I have configured the login-config.xml with my own datasource..Also, written the queries that points to my 'end_user' and 'roll_mstr' tables.But, all I am getting is 'No username found in Principal'..It is always firing my query in Principal tables.My data source is well configured..whats wrong ?Regards,Ash

    DB:2.38:Database Authentication With Jboss/Jaas 3k


    Hi,could you please provide more details on your configuration?I assume that you activated logging (as shown in post 2 of this thread http://www.jboss.org/index.html?module=bbop=viewtopict=154228) and checked that JBoss picks your security domain and your login module, and that your queries are executed?Hope this helpsWolfgang

  • RELEVANCY SCORE 2.38

    DB:2.38:Sql Parser Supporting Nested Queries mj


    Hi,

    I require a SQL parser that supprt nested queries. JavaCC doesnt support nested queries so that one is out. If anyone knows of any open sourse parser, please enlighten me. I have already looked enough on Google but not of much use.

    thanks,
    abulkd

    DB:2.38:Sql Parser Supporting Nested Queries mj

    Hi,

    I require a SQL parser that supprt nested queries. JavaCC doesnt support nested queries so that one is out. If anyone knows of any open sourse parser, please enlighten me. I have already looked enough on Google but not of much use.

    thanks,
    abulkd

  • RELEVANCY SCORE 2.38

    DB:2.38:Sessionexception: Session Closed After Very Large Native Que s8



    Hi All,I've got a PostgreSQL 8.1 database that I'm performing a series of large queries on under JBoss 4.0.5, and the EntityManager is closing after each query such that the next fails. The queries are native SQL, and return in excess of 250,000 rows.The datasource is defined as non-transactional to avoid transaction timeouts:

    no-tx-datasource
    jndi-nameMyDB/jndi-name
    connection-urljdbc:postgresql://localhost:5432/MyDB/connection-url
    driver-classorg.postgresql.Driver/driver-class
    user-name.../user-name
    password.../password
    /no-tx-datasource

    DB:2.38:Sessionexception: Session Closed After Very Large Native Que s8


    Hi All,I've got a PostgreSQL 8.1 database that I'm performing a series of large queries on under JBoss 4.0.5, and the EntityManager is closing after each query such that the next fails. The queries are native SQL, and return in excess of 250,000 rows.The datasource is defined as non-transactional to avoid transaction timeouts:

    no-tx-datasource
    jndi-nameMyDB/jndi-name
    connection-urljdbc:postgresql://localhost:5432/MyDB/connection-url
    driver-classorg.postgresql.Driver/driver-class
    user-name.../user-name
    password.../password
    /no-tx-datasource

  • RELEVANCY SCORE 2.38

    DB:2.38:What Is A Nested Query 3m



    Hi,

    What is a nested query? Can anyone give me an example of how to create a nested query? Please expain me in detail with an example?

    Thanks

    Rani

    DB:2.38:What Is A Nested Query 3m


    HI

    Please have a look at the below url for more clarity on Replacement path variable( to use one query result in another query as a parameter)

    https://www.sdn.sap.com/irj/sdn/advancedsearch?query=replacementpathvariablecat=sdn_all

    Thanks,

    Teja

  • RELEVANCY SCORE 2.38

    DB:2.38:Nested Sql Queries 88


    Hi,Does Labview Database connectivity tool support nested SQL Queries ? If so can someone tell me how to perform the following query:SELECT NAME,ADDRESS FROM EMP_TABLE WHERE salary=(SELECT MAX(salary) FROM EMP_TABLE)

    DB:2.38:Nested Sql Queries 88

    Hi,Another option that will keep the LV app more flexible is to create a stored procedure in the DB (if they are supported). Then, you make a simple call to the stored procedure and desired data is returned. This allows for the SQL statement to be debugged and changed withthout ever modifying your LV code.RS

  • RELEVANCY SCORE 2.38

    DB:2.38:Nested Cfoutput Group Processing... xa


    Hi,

    I have been using the group attribute of CFOUTPUT for some
    time now, it's really really helped a lot!

    However, I am now in a situation where two separate queries
    (each of which needs it's own grouping) need to be nested. But,
    this doesn't seem to be possible because CF throws an error about
    the query "driving" the process.

    See the example code below...

    cfoutput query="foo" group="a"
    #foo.a#
    cfoutput query="foo" group="b"
    #foo.b#
    /cfoutput

    /cfoutput

    This works great, BUT, if I do the following it will fail.

    cfoutput query="foo" group="a"
    #foo.a#
    cfoutput query="foo" group="b"
    #foo.b#

    cfoutput query="bar" group="c"
    #bar.c#
    /cfoutput

    /cfoutput

    /cfoutput

    However, for many reasons I NEED to have nested grouping like
    this and I can't see another way around it. While it is perfectly
    fine to have queries looped within other queries (usually with
    CFLOOP) CFLOOP does not support the GROUP attribute like CFOUTPUT
    does.

    If anyone can help I'd really appreciate it. I'm not sure how
    to get around this issue at all.

    Thanks,
    Mikey.

    DB:2.38:Nested Cfoutput Group Processing... xa

    quote:

    Originally posted by:
    Newsgroup User
    Ian Skinner wrote:

    Here is a super simple correction to my original ...

    super simple sample.

    cfoutput
    cfset aFieldValue = ""
    cfloop query="myQuery"
    cfif myQuery.aField NEQ aFieldValue
    !--- output grouped content here, once per value of
    aField. ---
    #myQuery.aField#
    cfset aFieldValue = myQuery.aField !--- new line
    ---
    /cfif
    !--- output content here for every record.
    #myQuery.bField#
    /cfloop
    /cfoutput

    Thank you thank you thank you for this Ian. I tried your
    method and it worked a treat. So much simpler than I thought it
    would be and I have no problems with it. Much appreciated.

    Thank you also to everyone else who chipped in their ideas.

    Thanks!!
    Mikey

  • RELEVANCY SCORE 2.38

    DB:2.38:Problem With Transaction Of 100.000 Queries pp



    We sent 100.000 queries (updates and inserts). In the query 99.708 the server report the next exception:disconnect(ManagedConnection mc: null, Object c: org.jboss.resource.adapter.jdbc.local.LocalConnection@91f022) called with unknown managed connection; nested exception is:java.lang.IllegalArgumentException: disconnect(ManagedConnection mc: null, Object c: org.jboss.resource.adapter.jdbc.local.LocalConnection@91f022) called with unknown managed connection.We tested :jboss-3.0.1 + Jdk1.4/Jdk1.3 + postgres 7.2+ winNT/Linux RedHat 7.2.We don't know what to do?, we have been having that problem for 5 monthsSome idea?

    DB:2.38:Problem With Transaction Of 100.000 Queries pp


    We are testing our application with JUnit.For this requirement we are using a Session Bean.The service iterate over a collection of queries and sendthe statements to the DB.***** . . .for (int i = 0; i listaQueries.size(); i++) { try { int result = statement.executeUpdate((String) listaQueries.elementAt(i)); ejecutado = true; } catch (Exception e) { e.printStackTrace(); ejecutado = false; }}try { connection.close();} catch (Exception e) { e.printStackTrace(); ejecutado = false;}***********Thank you for your possible help

  • RELEVANCY SCORE 2.38

    DB:2.38:Localreport Object And Xml Data cm


    Hi, I want to create a LocalReport object in code and let it create a report in Excel with an RDL file as report definition and an XMLDocument object as data input. The report was designed with an XML datasource. DesignTime this works well, the XML datasource is pointing to a XML file and the report is rendered in the preview tab no problem.But run-time it doesn't work (yet). I don't know how to load the xmlDocument in the LocalReport object. I don't think converting it to a DataSet is going to work. The XML structure has lot of nested nodes. In the RDL file, the design of the report, a custom Dataset is used, based on queries on the XML data source: 
    DataSet Name=ClientDataFieldsField Name=nameDataFieldname/DataFieldrd:TypeNameSystem.String/rd:TypeName/FieldField Name=wwIdDataFieldwwId/DataFieldrd:TypeNameSystem.String/rd:TypeName/Field/Fields
    QueryDataSourceNameAssessmentData/DataSourceNameCommandTextData{} /Plugin{}/assessments/client/CommandText/Query/DataSetSo what I want to do is runtime set the datasource to an xmldocument, something like:XmlDocument data = new XmlDocument()//code to load data in XmlDocument
    LocalReport report = new LocalReport();
    report.DataSources.Add(new ReportDataSource(AssessmentData, data));...
    byte[] result = report.Render(Excel, deviceInfo, out mimeType, out encoding, out fileExtension, out streams, out warnings);
    But this doesn't work, the error message is:A data source instance has not been supplied for the data source ReportData. (which is one of the datasets that design time is filled by a query on the XML data source)So it looks like wat is happening is that runtime the XML data is not translated to Datasets. This does work design time, the datasets are filled with the queries specified in the report definition. Does this not work the same run-time? I could of course create the datasets in code and pass data to the report as data tables. But then I would do work outside the report that is already defined inside the report (the queries). Is there another way of doing this?Thanks,Bert-Jan

    DB:2.38:Localreport Object And Xml Data cm

    Hi, I want to create a LocalReport object in code and let it create a report in Excel with an RDL file as report definition and an XMLDocument object as data input. The report was designed with an XML datasource. DesignTime this works well, the XML datasource is pointing to a XML file and the report is rendered in the preview tab no problem.But run-time it doesn't work (yet). I don't know how to load the xmlDocument in the LocalReport object. I don't think converting it to a DataSet is going to work. The XML structure has lot of nested nodes. In the RDL file, the design of the report, a custom Dataset is used, based on queries on the XML data source: 
    DataSet Name=ClientDataFieldsField Name=nameDataFieldname/DataFieldrd:TypeNameSystem.String/rd:TypeName/FieldField Name=wwIdDataFieldwwId/DataFieldrd:TypeNameSystem.String/rd:TypeName/Field/Fields
    QueryDataSourceNameAssessmentData/DataSourceNameCommandTextData{} /Plugin{}/assessments/client/CommandText/Query/DataSetSo what I want to do is runtime set the datasource to an xmldocument, something like:XmlDocument data = new XmlDocument()//code to load data in XmlDocument
    LocalReport report = new LocalReport();
    report.DataSources.Add(new ReportDataSource(AssessmentData, data));...
    byte[] result = report.Render(Excel, deviceInfo, out mimeType, out encoding, out fileExtension, out streams, out warnings);
    But this doesn't work, the error message is:A data source instance has not been supplied for the data source ReportData. (which is one of the datasets that design time is filled by a query on the XML data source)So it looks like wat is happening is that runtime the XML data is not translated to Datasets. This does work design time, the datasets are filled with the queries specified in the report definition. Does this not work the same run-time? I could of course create the datasets in code and pass data to the report as data tables. But then I would do work outside the report that is already defined inside the report (the queries). Is there another way of doing this?Thanks,Bert-Jan

  • RELEVANCY SCORE 2.37

    DB:2.37:Performance Of Batch Processing With Multipleactiveresultsets = True Is Very Inconsistent 8d


    Hi,I have a batch process running which interacts with the database. It contains several nested and non-nested SELECT query. Previously the non-nested SELECT query used DataReader whereas the the nested SELECT query used SQLCursor. Currently I am trying to migrate the nested SELECT queries to use datareader with the help of turning MultipleActiveResultSets(MARS) on.But we are seeing a very high deviation in the elapsed time(varing from 900sec to 1200sec) of the batch after this.The machine and all other parameter were kept constant across the runs.Has anyone encounted such a thing and if so how was it resolved?Also can anyone please tell me how MARS works internally. How are multiple datareaders maintained within a single connection.RegardsNasiq.

  • RELEVANCY SCORE 2.37

    DB:2.37:Sql Query - Without Nested/Sub Queries k7


    Dear experts,

    I've the below requirement for which I need to write a SQL query without using any nested/sub queries. Can you please help?

    Query should list the names, which bought more than 1 uique items (like a bought pen and pencil, but b and c bought 2 same items..so in this case it has to output only a)..

    Name Items
    a pen
    a pen
    a pencil
    b book
    b book
    c bulb
    c bulb

    Thanks,

    DB:2.37:Sql Query - Without Nested/Sub Queries k7

    This will be good performance-wise

    SELECT name
    FROM(SELECT name, RANK() OVER (PARTITION BY name ORDER BY items) rn
    FROM table_name)
    WHERE rn 1

  • RELEVANCY SCORE 2.37

    DB:2.37:Can't Run Queries 78


    I have a new development machine I have set up that has the
    same environment as my current machine. The database gives an "ok"
    status in the CF 7 admin and I can run queries just fine through
    the query analyzer. However, CF pages won't execute any queries
    whether they are procedures or standard queries. The error message
    is "Error Executing Database Query"

    The ability to run queries and stored procs is set to yes in
    the datasource settings.

  • RELEVANCY SCORE 2.37

    DB:2.37:Using Msolap Data Provider In Ssas Supported? 87


    This may be a silly question but out of curiousity, does SSAS truly support building datasource views and using them in a cube using another Cube as the datasource???I noted that the option to use a MSOLAP datasource provider is present when creating a datasource, and I've even experimented by successfully performing MDX queries against the datasource to create a named query. But I always get an error that says Errors in the high-level relational engine. The 'Datasource Name' secondary data source is not a relational data source, or does not use an OLE DB provider.Which leads me to believe that it probably isn't supported.Any gurus out there able to provide some feedback on this???

    DB:2.37:Using Msolap Data Provider In Ssas Supported? 87

    Thanks furmangg,Apparently this area isn't well documented and I am venturing into fairly uncharted territory based on your posted URL. I will do more individual research and try to see how much ground I can cover.Really appreciate the feedback.

  • RELEVANCY SCORE 2.37

    DB:2.37:No Output When Using Cfthread For Parallel Queries 8c



    Hi,

    I want to execute some queries at the same time using cfthread.

    But when I join the threads and try to output the query results I get following error:

    "The value of the attribute query, which is currently q_emp, is invalid."

    Here is my sample code:

    cfthread name="t1"

    cfquery name="q_emp" datasource="test"

    SELECT empno,ename

    FROM emp

    /cfquery

    /cfthread

    cfthread name="t2"

    cfquery name="q_dept" datasource="test"

    SELECT deptno, name

    FROM dept

    /cfquery

    /cfthread

    cfthread action="join" name="t1,t2" /

    cfoutput

    cfloop query="q_emp"

    #empno# #ename# /br

    /cfloop

    cfloop query="q_dept"

    #deptno# #name#/br

    /cfloop

    /cfoutput

    What's wrong in my code?

    I'm using ColdFusion 9 Standard Edition and Oracle 11g.

    regards Claudia

    DB:2.37:No Output When Using Cfthread For Parallel Queries 8c


    I suspect the variables q_emp and q_dept can only be accessed in their respective thread-local scopes. That is, within the respective cfthread tags in which they are defined.

    I would redefine q_emp and q_dept in the thread scope, to extend their context to the entire page, as follows:

    cfthread name="t1"

    cfquery name="q_emp" datasource="test"

    SELECT empno,ename

    FROM emp

    /cfquery

    cfset thread.q_emp = q_emp

    /cfthread

    cfthread name="t2"

    cfquery name="q_dept" datasource="test"

    SELECT deptno, name

    FROM dept

    /cfquery

    cfset thread.q_dept = q_dept

    /cfthread

    cfthread action="join" name="t1,t2" /

    cfoutput

    cfloop query="t1.q_emp"

    #empno# #ename# /br

    /cfloop

    cfloop query="t2.q_dept"

    #deptno# #name#/br

    /cfloop

    /cfoutput

  • RELEVANCY SCORE 2.37

    DB:2.37:Is Query Of Queries Faster Than Multiple Where Criteria? x7



    If I need a recordset based on two table column fields (let's say firstName and lastName), is it better to run one query with a WHERE firstName = x AND lastName = y, or is it better to query of queries and find all records with a specified firstName, and then query that query to filter only records with a specified last name? Which is the better/faster method?

    cfquery name="somequery" datasource="someds"

    SELECT *

    FROM sometable

    WHERE firstName = 'John' AND lastName = 'Smith'

    /cfquery

    or....

    cfquery name="somequery" datasource="someds"

    SELECT *

    FROM sometable

    WHERE firstName = 'John'

    /cfquery

    cfquery name="somequery2" dbtype="query"

    SELECT *

    FROM somequery

    WHERE lastName = 'Smith'

    /cfquery

    DB:2.37:Is Query Of Queries Faster Than Multiple Where Criteria? x7


    When combining data from more than one datasource.

    When cfoutput query="yourquery" group="somefield" isn't going to get the job done..

  • RELEVANCY SCORE 2.37

    DB:2.37:Queries Regarding The Datasource To Be Used In The Report fs



    Hi All,

    I have to use the query "0BBP_DOC_Q001" i.e "Document Flow: Shopping Cart Purchase Requisition (Backend)".for this,what datasource should i use??? the link in help.sap.com is http://help.sap.com/saphelp_nw70/helpdata/EN/30/906e3acb8f686ae10000000a114084/frameset.htm

    plz.guide me which datasource to use,i am using the datasource for shopping carts i.e 0BBP_TD_SC_1.

    thanks in advance,points will be assigned:)

    regards,

    Manjari.

    DB:2.37:Queries Regarding The Datasource To Be Used In The Report fs


    Thanks Swetha..

    i need to create a datasource for it...can u tell me how to do it...

    Regards,

    Manjari.

  • RELEVANCY SCORE 2.37

    DB:2.37:Re: Help Required.....Nested Bean ax


    Use a SQL JOIN query (advantage: single query, disadvantage: duplicate data) or a SQL IN query (disadvantage: two queries, advantage: no duplicate data). Which to use depends on how large the duplicate data is and how it can be weighted against the cost of a 2nd query. How to handle the resultset for each is pretty straightforward.

    DB:2.37:Re: Help Required.....Nested Bean ax

    Hello All I have two tables(Account, Info) respectively. their table structure would be as follows Account_ Accont_Number Number(10) Primary Key BankNamve Varchar2(30) Info_ Accont_Number Number(10) Forign Key Details Varchar2(300) ________________________________________________________________________________________________________________________________ So for each value of Account_number(in Account table) there exixts multiple entries in info table. And i need info table bean as an arraylist in Account table bean. How do i proceed with this? the solution i am trying to write individual beans. i want an arraylist for the Info table bean. How can i do this? How to call info table bean from Account bean? AccountTableBean{ int AccNumber; String Bank; Arraylist infoTableBean; } InfoTableBean{ int AccNumber; String Details; } Thanks Diana

  • RELEVANCY SCORE 2.36

    DB:2.36:Analysis For Excel - Issue On Deleting Measures Option 3k



    Hi,

    I'm facing an issue regarding the option of deleting measures or to change its position in the Excel using the Analysis. The Remove option is somehow disabled.

    My datasource is a BEx query, and for other queries everything seems to be working.

    Any hint? Any explanation for this?

    Regards,

    Joo Seixas

    DB:2.36:Analysis For Excel - Issue On Deleting Measures Option 3k


    Thank you for sharing your version

    It looks like you are on the early version of Analysis Office 1.4 - would you please download 1.4 SP5 and see if the issue remains?

  • RELEVANCY SCORE 2.36

    DB:2.36:Sharepoint 2007 Error - Some Part Of Your Sql Statement Is Nested Too Deeply 8p


    Hi All,
    Im working with an application on SharePoint 2007, I encountered an issue where the list item unable to view.
    It hit error 1309 Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries
    how can I solve this issue?
    Thank you in advanced.

    DB:2.36:Sharepoint 2007 Error - Some Part Of Your Sql Statement Is Nested Too Deeply 8p


    Hello Stefan,

    This links shows why the CAML query is producing this issue and how to fix this, but in my case I have just my sharepoint list and everything is Out of box.. query generated is by sharepoint itself to view
    the item's details... when i click for viewitem it says expected error occured and i checked the event logs the same some part of your SQL statement is nested too deeply error is thrown... it is only for 2 items out of 200... i have cleared the workflow
    history but for no use... can u help me with this??

  • RELEVANCY SCORE 2.36

    DB:2.36:Converting Rdl To Rdlc p1


    I have a RDL file , which takes in 4 parameters and generates a report . The query nested within the RDL file .I now wish to Convert this RDL file to RDLC and have some basic doubts 1)Is it true that RDLC files cannot have queries nested in them?  I have the query like Select * From Sales where SalesPersonId = @SalesPersonId ? nested within the RDL file will this work if I convert RDL to RDLC?2)I renamed RDL to RDLC and used ReportViewer to poin to this RDLC file , however I get the error 'A data source instance has not been supplied for the data source' , I opend the RDLC file and could not see any DataSource binding? Now how will I go about to bind the datasource?3)I created a new DataSet ,however my query would also use SET and DECLARE statements...and this is not supported.What would be the optimum way i could workaround this problem?..C# Fan!

    DB:2.36:Converting Rdl To Rdlc p1

    Hi Ananda,Just add to Robert's response, here is a article about how to covert RDL and RDLC files:http://msdn.microsoft.com/en-us/library/ms252109(VS.80).aspxIf you have any more questions, please feel free to ask.Thanks,JinJin Chen - MSFT

  • RELEVANCY SCORE 2.36

    DB:2.36:How To Use A Non-Default Query From A Custom Ria Service km


    I have a custom RIA service that I use in my LS application. I added the RIA service by doing Add Datasource. One of the queries in my ria service is as follows:

    [Query]
    public IEnumerableUser GetUsersByRole(string in_role)

    DB:2.36:How To Use A Non-Default Query From A Custom Ria Service km

    Support for non-default queries has been added to the product but you will have to wait to Beta2.
    That's good news! can't wait for beta2, thanks!

  • RELEVANCY SCORE 2.36

    DB:2.36:How Does Bi Server Switch Queries? dd


    Hi,

    I notice that BI server issues seperate queries to fulfill the analysis. But sometimes I find a single statement with nested sub queries, but most of the time just the individual queries.

    So my question is, when it issues multiple queries and bring the data, probably into its memory - do it perform a stich query at this point of time? Can we see this query?

    Thanks.

    DB:2.36:How Does Bi Server Switch Queries? dd

    You might be knowing that the within RPD you can control whether you want to use with clause or stitch joins.

    To analyze the queries in detail it is recommended to increase the query log level. you are right it creates temp files when it federating data across multiple databases or multiple aggregation tables/partition tables etc.

    Hope this gives more pointers..

  • RELEVANCY SCORE 2.36

    DB:2.36:Nested Table Collection: Bad Performance cz


    I have a report region whose datasource is based on a select statement that retrieves data from a nested table data collection. I'm using this approach so that users can query on data that will eventually appear on a bill, but without writing to the physical table that will be used to create the bill.

    The query looks like this: (Note the following: the package maintaining the collection is: bill_fac_run_time_maint, the function returning the collection is: bill_fac_runtime(), and the nested table type is: bfrttypeset)

    SELECT facid, facility, str1, str2, city_state_zip, categ_type, ea_code, vcc,
    actor_id, address_id, mm_addr_id
    FROM TABLE
    (CAST
    (bill_fac_run_time_maint.bill_fac_runtime () AS bfrttypeset
    )
    ) bft

    The package: bill_fac_run_time_maint has a an initialization procedure which simply instantiates the collection to a set of records (approx. 9700) returned from a query on a view. I put it into the initialization section so the collection would be built ONCE per session when a package component is first referenced.

    Initial queries in SQL*Plus and Oracle Forms take approximately 1 minute, but subsequent queries return data instantaneously because the collection is in memory.

    My problem in APEX, however, is that, in addition to the first query being slow as in SQL*Plus, all subsequent page refreshes (i.e. every time I click for the next 15 (standard report region page)) are also slow. What's also disturbing is that you have no indication that anything is going on and suddenly the next batch of records appears.

    The one hint that I have that it may be a pagination issue is the bottom message I got when I first clicked on the "next" button: javascript:$a_report('99999999999','16','15','15')

    This leads me to believe that its requesting the next 15 records starting from row 16, but how does APEX know where it left off?

    I just tried running it in APEX's SQL Workshop and subsequent queries also took rather long.

    This is confusing because that collection should be available for the duration of a given session.

    Any ideas would be greatly appreciated.

    Bill

    DB:2.36:Nested Table Collection: Bad Performance cz

    Thank you for your clear and concise response.

    I will certainly take a look at using APEX Collections and see how that works.

    Regards,
    Bill McG