search for: qry

..._query)(struct multi_pgsql_query *); +}; + +static void start_new_query_on_pgc(struct multi_pgsql_query *, struct multi_pgsql_pgc *); +static void start_query_on_pgc(struct multi_pgsql_pgc *); +static void done_with_query(struct multi_pgsql_pgc *); + +/*** method invocation wrappers */ +#define the_qry(q) ((struct multi_pgsql_query *)q) + +static inline void start_query(void *q, struct multi_pgsql_pgc *pgc) +{ + dprintf(("%s: %p", __func__, q)); + the_qry(q)->vtable->start(the_qry(q), pgc); +} + +static inline void query_result(void *q, struct multi_pgsql_pgc *pgc, + PGresult *...

...out at f46e5eadc307beaef6e8dd0602bb4c63ca41fd50. To create MCJIT i use provided llvm-c apis: LLVMInitializeMCJITCompilerOptions(&options, sizeof(options)); options.OptLevel = MODULE_OPT_LEVEL; /* 3 of 0 */ options.CodeModel = LLVMCodeModelJITDefault; if (LLVMCreateMCJITCompilerForModule(&qry->llvm.engine, qry->llvm.mod, &options, sizeof(options), &error) != 0) { fprintf(stderr, "%s\n", error); LLVMDisposeMessage(error); abort(); } LLVMRunStaticConstructors(qry->llvm.engine); Then I do the IR building and get the function pointer i need: iter->run = LLVMG...

...TABLE_NAME TABLE_TYPE REMARKS 1 c:\\temp\\test <NA> Sheet1$ SYSTEM TABLE <NA> 2 c:\\temp\\test <NA> Sheet2$ SYSTEM TABLE <NA> 3 c:\\temp\\test <NA> Sheet3$ SYSTEM TABLE <NA> Everything seems to be fine. Then I did > qry <- paste("SELECT * FROM", tbls$TABLE_NAME[1], sep = ' ') > qry [1] "SELECT * FROM Sheet1$" > sqlQuery(con, qry) and got the error message [1] "42000 -3506 [Microsoft][ODBC Excel Driver] Syntax error in FROM clause." "[RODBC] ERROR: Could not...

...b4c63ca41fd50. > To create MCJIT i use provided llvm-c apis: > > LLVMInitializeMCJITCompilerOptions(&options, sizeof(options)); > options.OptLevel = MODULE_OPT_LEVEL; /* 3 of 0 */ > options.CodeModel = LLVMCodeModelJITDefault; > > if (LLVMCreateMCJITCompilerForModule(&qry->llvm.engine, qry->llvm.mod, > &options, sizeof(options), &error) != 0) { > fprintf(stderr, "%s\n", error); > LLVMDisposeMessage(error); > abort(); > } > LLVMRunStaticConstructors(qry->llvm.engine); > > Then I do the IR building and get the funct...

...s in anticipation. Vishal Belsare > library(RODBC) > con = odbcConnectExcel(file.choose()) > tbls <- sqlTables(con) > tbls TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 T:\\data\\in\\nameclass <NA> nameclass$ SYSTEM TABLE <NA> > qry = paste("SELECT * FROM '",tbls$TABLE_NAME[1],"'",sep="") > result = sqlQuery(con,qry) > result [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "42000 -3506 [Microsoft][ODBC Excel Driver] Syntax error in FROM clause." [[alternative...

...ode. My aim is to read in the data starting in H69:H283 in sheet 2. v<-"http://www.statistics.gov.uk/elmr/01_09/downloads/Table1_07.xls" dest<-"C:/Data/onstest.xls" download.file(url=v,destfile=dest,mode="wb") library(RODBC) channel <-odbcConnectExcel(dest) qry <- paste("SELECT * FROM '",tbls$TABLE_NAME[2],"'",sep="") onstest <- sqlQuery(channel,qry) close(channel) very grateful for any help simeon [[alternative HTML version deleted]]

...Ajax'', { method:''get'', parameters: {action: ''createRegion'', name: name} }); return true; } else { return false; } } } <<< PHP >>>>>>>>>>>>>>>>>>>> qry = "check if a region exists with same name"; if (region does not exist) { qry = "insert new region into db"; } qry = "select all regions in alphabetical order" while (regionsexist) { echo "<option value="id" ".(newregion == existingregion ? &...

...1 Ubuntu 64amd RODBC 1.2-5 --------------------------------- This was a hard-to-track bug for me, because sqlQuery() did not fail - instead, it looked like it returned some good data and some NA where there should have been numbers and 0 where there should have been NAs. I did: (a) sqlQuery( o, qry, as.is=TRUE, errors=TRUE, rows_at_time=1024 ); (b) sqlQuery( o, qry, as.is=TRUE, errors=TRUE ); My qry was a bit complex, with an outer join, so the first thing I did was check from a win32 bit machine and check on 64amd with the mysql client command-line. Both worked fine. Both (a) and (b) work...

...kup.agi -- AGI Script calleridnamelookup.agi completed, returning 0 I've even received that result calling in to my iconnect account, which delivers only ANI information. I notice that the URL that it queries does not respond when I enter it manually into a browser: http://www.anywho.com/qry/wp_rl/index.html?npa=719&telephone=4710000. A box comes up that says "Fetching Results", and then the request times out. Any idea how to structure the query on ANYWHO or how to use the script with another reverse lookup service? Thanks in advance.

...k written by Phil Spector. It seems very straightforward, yet I get the same error everytime I try it, with different excel sheets and trying to tweek the code a bit. This is what I do: library(RODBC) sheet='X:\\example.xls' con=odbcConnectExcel(sheet) tbls=sqlTables(con) tbls$TABLE_NAME qry=paste("SELECT * FROM '",tbls at TABLE_NAME[1],"'", sep=" ") The error I get is: Error in paste("SELECT * FROM '", tbls at TABLE_NAME[1], "'", sep = " ") : trying to get slot "TABLE_NAME" from an object (class...

...ar R Users, I was using R to import five years traffic data, but the error always come up as shown below. The data frame contains 12 columns and unknown number of records. Would you have any ideas that how I should deal with this situation?? Many thanks for any hints. >wim<-sqlQuery(channel,qry) Error: cannot allocate vector of size 24.0 Mb In addition: There were 16 warnings (use warnings() to see them) >memory.size(max=T) [1] 1535.62 >memory.size(max=F) [1]16.24 >gc() used (Mb) gc trigger (Mb) max used (Mb) Ncells 141802 3.8 6160587 164.6 5130092 137.0 Vcells 110...

...e. Can experts on the list please throw some light as how to improve the speed with which RMySQL queries can be processed ? RMySQL database access is done as follows: ------------------------------------------- library(RMySQL) # 1 con <- dbConnect( ... ) # 2 ... rs <- dbSendQuery(con,qry) # 3 rdat <- fetch(rs,n=10000) # 4 ... dbDisconnect(con) # 5 ------------------------------------------- lines #3 and #4 are repeated about 10000 times in the script. Thanks in advance for any help. Sukhaswami Malladi *********************************************************************...

...lass = "try-error"))}) 7: try({ ps <- oraPrepareStatement(con, statement, bind = NULL) rs <- oraExecStatement(ps, ora.buf.size = as(ora.buf.size, "integer"))}) 8: oraExecDirect(con, statement, ...) 9: oraQuickSQL(conn, statement, ...) 10: dbGetQuery(dotsConnection(), qry) -- This is the type of query (template) that crashes it, I know this is not too helpful as you cannot run it, but maybe someone spots a certain pattern in it: SELECT TIMESTAMP, VALUE, VM FROM (WITH ev AS (SELECT audit_key_new key, audit_date dt, audit_batch_nbr, audit_date...

Sure I will split it and put it in two patches. Give me few hours. I need to test those patches. Sirish On 4/19/2012 8:40 AM, Tom Stellard wrote: > On Wed, Apr 18, 2012 at 11:18:05PM -0500, Sirish Pande wrote: >> Hi, >> >> Here's a patch for Hexagon Packetizer for review. This patch does >> not yield any warnings. >> > Would it be possible to split this

Hi, I would like to report that Tuncmatik Newtech Pro 1 KVA (http://www.tuncmatik.com/en-US/productDetail.asp?RecID=290) works with nut(2.4.1) blazer_usb, blazer_ser and megatec drivers. The UPS came with an usb cable and a java based software for both linux and windows, named ViewPower (http://www-power-software-download.com). This UPS has double interface a USB interface and a serial

Hello list. I'm trying to rebuild the 2.6.9.67.0.20.EL kernel, but it fails even without modifications. How did I try it? Created a (non-root) build environment (not a mock ) Installed the kernel.scr.rpm and did a rpmbuild -ba --target=`uname -m` kernel-2.6.spec 2> prep-err.log | tee prep-out.log The build failed at the end: Processing files: kernel-xenU-devel-2.6.9-67.0.20.EL Checking

...;XWc5bDj8d;R;6MqsPg)0KLX~ydJExuxmm;Ms86x^iCS#FiRWsg z7_()uIb195rib_P&;f3)LD*WrI>36s2EazZCcsxnw;9hZfR6!HfCL~3NCCD2ssS~C zTEI5ICxGpM9e|yHT}E-YE5iqPXg4=M#rJN&9>Dv6y?}jy{RZ)~n}_!QE1dm2w1=Aq z4ElG_C}QRzqfMP;er9xRZXPx|wlI$v9j`Et8Xd1Rj~N|Xnx7jTo0-Rrj#rr{jE+~E zUl?uTl6lhT*vkCU=y;9!mC^B9^OVuC(EQryc%6Bg-p<h5H%7<n&9g?w*5)~*W0Co- z(Xmap7U4Z&qm1V2l>2O*a-YyC_i=pFm4q4z7FtN!K=N#Z8mgjal^UvbPc+AB)liB8 zQ)*}jJ$I<~)b_IG%Bb}uqXud;m}y~ey_$%vr-pvT!$=XvAP*x2j1*xE_Aqu3#;YF2 z4q)scj3JsT*_#WuY0)#B{+{JIm_<O-Ja0U+*=SF1Df?}^&|5;=RcnK4UNEAYjc%;a zzr~Pa+lkm~nheo(Q+ at qmgG%~CqqP2zbQOos(~...