Seqanswers Leaderboard Ad

Collapse

Announcement

Collapse
No announcement yet.
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Do you know what is this queri problem?

    source("http://bioconductor.org/biocLite.R")
    biocLite("GEOmetadb")

    library(GEOmetadb)

    ###################################################################################################
    # Connect with the DB
    ###################################################################################################

    con <- dbConnect(SQLite(),'GEOmetadb.sqlite')

    sql <- paste("SELECT DISTINCT ",
    "gpl.ID ",
    "gds.platform_technology_type ",
    "FROM ",
    "gpl ",
    "JOIN ","gds_subset ON gds.gds = gds_subset.gds ",
    "JOIN ","gpl ON gds.gpl = gpl.gpl ",
    "WHERE ",
    "gds_subset.type LIKE 'time' ",
    "WHERE ",
    "gpl.technology LIKE 'high-throughput sequencing' ",sep="" )


    It gave me this error:
    Error in sqliteSendQuery(con, statement, bind.data) :
    error in statement: near ".": syntax error

  • #2
    Error in sqliteSendQuery(con, statement, bind.data) :
    error in statement: near ".": syntax error

    Comment


    • #3
      I am not sure what is causing the error message, because the code you showed doesn't go as far as submitting the sql query, but there are a couple of problems with your SQL SELECT statement.

      You have 2 WHERE clauses in the SELECT statement. What you should have is the two parts of the WHERE clause separated by AND. So remove the second 'WHERE' and replace with 'AND'.

      Your second JOIN statement looks like it is a typo and you should probably have

      JOIN ","gds ON gds.gpl = gpl.gpl ",

      instead of
      JOIN ","gpl ON gds.gpl = gpl.gpl ",

      Have a look at the examples in the documentation for GEOmetadb.

      Comment


      • #4
        THANKS MASTAL

        I changed the code as you said

        however, I still get the error

        sql <- paste("SELECT DISTINCT ",
        "gpl.ID ",
        "gds.platform_technology_type ",
        "FROM ",
        "gpl ",
        "JOIN ","gds_subset ON gds.gds = gds_subset.gds ",
        "JOIN ","gds ON gds.gpl = gpl.gpl ",
        "WHERE ",
        "gds_subset.type LIKE 'time' ",
        "AND ",
        "gpl.technology LIKE 'high-throughput sequencing' ",sep="" )



        rs <- dbGetQuery(con,sql)
        rs

        Comment


        • #5
          Are you running R interactively, and if so, at what stage are you getting the error message?

          Comment


          • #6
            I am using R studio if that you mean.

            I changed the code a little, now there is no error but also no result.

            But I am seeing some result in tables, I want to see ll of them an dI am sure there are more than a few row including this condition.

            > sql <- paste ("SELECT DISTINCT ",
            + "gpl.ID, gds.platform_technology_type ",
            + "FROM ",
            + "gpl ",
            + "JOIN ",
            + " gds ON gds.gpl = gpl.gpl ",
            + "JOIN ",
            + "gds_subset ON gds.gds = gds_subset.gds ",
            + "WHERE ",
            + " gds_subset.type LIKE '%time%' AND ",
            + "gpl.technology LIKE '%high-throughput%'",sep="")
            > rs <- dbGetQuery(con,sql)
            > dim(rs)
            [1] 0 2
            > rs
            [1] ID platform_technology_type
            <0 rows> (or 0-length row.names)

            Comment


            • #7
              I think it actually worked.

              I want to see how many rna-seq platform are in GEO that are time series and apparntly nothing.

              Unless the coding is wrong and has to indicate something else.

              Comment


              • #8
                The thing to do is to try a simple sql command that should return a small number of results.

                For example:
                sql <- SELECT * FROM gpl LIMIT 10

                And when reporting errors with R, you should always give the results of sessionInfo().

                Comment

                Latest Articles

                Collapse

                • seqadmin
                  Best Practices for Single-Cell Sequencing Analysis
                  by seqadmin



                  While isolating and preparing single cells for sequencing was historically the bottleneck, recent technological advancements have shifted the challenge to data analysis. This highlights the rapidly evolving nature of single-cell sequencing. The inherent complexity of single-cell analysis has intensified with the surge in data volume and the incorporation of diverse and more complex datasets. This article explores the challenges in analysis, examines common pitfalls, offers...
                  06-06-2024, 07:15 AM
                • seqadmin
                  Latest Developments in Precision Medicine
                  by seqadmin



                  Technological advances have led to drastic improvements in the field of precision medicine, enabling more personalized approaches to treatment. This article explores four leading groups that are overcoming many of the challenges of genomic profiling and precision medicine through their innovative platforms and technologies.

                  Somatic Genomics
                  “We have such a tremendous amount of genetic diversity that exists within each of us, and not just between us as individuals,”...
                  05-24-2024, 01:16 PM

                ad_right_rmr

                Collapse

                News

                Collapse

                Topics Statistics Last Post
                Started by seqadmin, Today, 07:23 AM
                0 responses
                8 views
                0 likes
                Last Post seqadmin  
                Started by seqadmin, 06-17-2024, 06:54 AM
                0 responses
                12 views
                0 likes
                Last Post seqadmin  
                Started by seqadmin, 06-14-2024, 07:24 AM
                0 responses
                24 views
                0 likes
                Last Post seqadmin  
                Started by seqadmin, 06-13-2024, 08:58 AM
                0 responses
                18 views
                0 likes
                Last Post seqadmin  
                Working...
                X