similar to: Seeking help constructing SQL Queries from search pages with many optional attributes

Displaying 20 results from an estimated 10000 matches similar to: "Seeking help constructing SQL Queries from search pages with many optional attributes"

2005 Feb 07
2
questions sur R
bonjour, Je suis actuellement en derniere annee d'ecole d'ingenieur en informatique et statistiques et je dois réaliser mon projet de fin d'études sur le logiciel R. En fait, je dois réaliser un scoring sous R puis le meme sous SAS et comparer les resultats. Mon fichier se prete à une regression logistique. J'ai donc utilisé la fonction glm sous R et Catmod sous SAS seumement, je
2013 Feb 02
1
Why replacement has length zero? And How can I fix it?
Hi for the loop section runif needs curved brackets Try IAP <-NA for (i in 1:Sample.Size){ if (DataSet$SES[i]>0) { IAP[i] <- ifelse(runif(1)>0.75, 1, 0) # High SES, higher chance to be in Treatment # } else { IAP[i] <- ifelse(runif(1)<=0.25, 1, 0) # Low SES, lower chance to be in Treatment # } } # End loop # IAP IAP zjiaqi19880219 wrote > Hi,
2008 Jan 08
3
Dovecot too many open files???
Dovecot experts, We just recently deployed Dovecot 1.0.rc15 on a Redhat 5 system. I have over 1400 users. At first it appeared to work fine. But soon, we had complaints of students that couldn't retrieve their email. I looked in the logs and found this error. Jan 7 22:27:31 stu dovecot: auth(default): pam(pucklisl,<http://144.89.40.6>144.89.40.6): pipe() failed: Too many
2006 Jan 06
0
Constructing a query from an object
Hi, Apart from checking each field in an object created from form params, is there an easy way I can construct a query from an object? For example, I''m doing this: @candidate = Candidate.new(params[:candidate]) And go on to check each attribute if it''s blank and thereby constructing a query. It''s pretty common, so I''m guessing there should be a easier
2008 Mar 26
0
seeking hardware/software consultant to build system with 64-bit OS, R, SQL DBMS
I am seeking to hire a hardware/software consultant to help me build a stem with a 64 bit OS, R, and a SQL-compatible DBMS. Please contact me if you know of anyone qualified. Details: I am in need of a robust system that will run R, and a SQL compatible database. I will be working with large datasets, and wish to take advantage of as much RAM as possible, and therefore think I should use a 64
2006 May 07
3
Webrick not showing sql queries any more?
Hi all, I updated rails to 1.1.2, and somehow, when I run script/server on a new rails project, I don''t see the sql queries in the console any more... It was very useful to see them live... Does any one have any idea why? Thank you very much! Nauhaie -- Posted via http://www.ruby-forum.com/.
2006 Mar 02
2
custom sql queries beyond CRUD
Hi, I am just starting of in rails. I am trying to understand the features of rails and I have this burning question. (and search is not available now): Apart from relying on the automatic CRUD sql script produced, is there a way I can create my own sql script ex: with many joins between exixting tables (for reporting ). All I need is to declare the custom query and place the result in a
2008 May 16
1
Sql queries in rails
I have an assignment and I need to be able to run a query inputted by the user (no matter what the query). Also I need to display the result cleanly with the field names if the query was a select query. So far I have @result = ActiveRecord::Base.connection.execute(params[:query]) and in my view I have <% for result in @result %> <%= result %> <% end %> but this returns all
2011 Feb 11
0
SQL Queries in Rails Console <a href="sdf"></a><object></object>
ActiveRecord::Base.logger = Logger.new(STDOUT) -- View this message in context: http://old.nabble.com/SQL-Queries-in-Rails-Console-%3Ca-href%3D%22sdf%22%3E%3C-a%3E%3Cobject%3E%3C-object%3E-tp30901356p30901356.html Sent from the RubyOnRails Users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk"
2005 Dec 20
1
Feature Request - Different SQL queries to retrieve pop and imap auth tokens
Hi! I world like to have different queries to let a user use pop only or imap only (webmail) accounts. It would really be very useful. I have not found any workaround get it working with dovecot. Could it be possible ? It should not be too difficult, I suppose. Max
2015 Jun 22
0
Quota SQL separate queries?
Hello, We are trying to enforce per-domain quotas. Currently my quota-sql.conf looks like this: connect = host=/var/run/postgresql dbname=mail user=mailreader map { pattern = priv/quota/storage table = quota username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota username_field = username value_field = messages } With quota =
2019 Aug 29
1
User / Pass SQL queries
Hi all, Is there any reason Dovecot shows the 'user' variable (ie: user at domain.tld) being obtained in the password query and not the (more logical) user query? Thanks, Michael
2008 Nov 14
2
Embed SQL queries in R?
Hi All, Most of the work I am doing with R uses data which I am pulling from various SQL queries. To streamline the process even more, I was wondering if it was possible to embed SQL queries in R - that way avoiding the need to first get the data, then move to R to process it. I haven't found anything out there on this yet, so if you know of a good resource that includes this topic, I would
2006 Jun 26
2
How can I minimize SQL queries
I have users, who have friends that are also users in mysql database. I have a foreign key for both users, so that I can reference their data directly. My problem is displaying friends. My for statement would look something like this: for i in(0..@user.friends.length) puts @user.friends[i].user.name end so @user is the user that i''m displaying friends for... .friends are the
2011 Oct 28
0
Are you successfully using using SQL queries to manage Dovecot2 Quota Values & Limits?
On Mon, Oct 24, 2011 at 11:14 AM, Rich <pgnet.dev+rich-dovecot at gmail.com> wrote: > I'm able to consistently reproduce this problem/behavior, but not > workaround or fix it, yet. > > Rich > > On Wed, Oct 19, 2011 at 7:41 AM, Rich <pgnet.dev+rich-dovecot at gmail.com> wrote: >> I've made some progress, but quota 'Limit' is still not fully
2019 Aug 31
0
Singaporean Mr. Teo En Ming's Refugee Seeking Attempts, In Search of a Substantially Better Life
Subject: Singaporean Mr. Teo En Ming's Refugee Seeking Attempts, In Search of a Substantially Better Life In reverse chronological order: [1] Petition to the Government of Taiwan for Refugee Status, 5th August 2019 Monday Photo #1: At the building of the National Immigration Agency, Ministry of the Interior, Taipei, Taiwan, 5th August 2019 Photo #2: Queue ticket no. 515 at the National
2010 Apr 26
2
Indexless interpolation search seeking code
http://www.xiph.org/ogg/doc/oggstream.html says: "An index is only marginally useful in Ogg for the complexity added; it adds no new functionality and seldom improves performance noticeably. Empirical testing shows that indexless interpolation search does not require many more seeks in practice than using an index would." I am keen to see seeking code which is almost as fast as
2005 Oct 10
1
Need help with SQL queries after updating to 1.0a3
I upgraded to 1.0a3 - i have everything in the config migrated over, but I'm unsure about the way i should be querying postgres my db handles virtual accounts only, and is set as such: CREATE TABLE accounts ( local_part VARCHAR(64) NOT NULL, domain VARCHAR(64) NOT NULL, password VARCHAR(64) NULL, home_dir VARCHAR(256) NOT NULL, uid INTEGER DEFAULT
2009 Apr 22
1
Upgrading from 1.4.21.2 to 1.6.0.5 breaks sql queries with backslashes?
Hi, all. I've been searching google, bug reports and forums and have looked in all the asterisk-users list archives back to 2003 but haven't seen an answer to this, so thought I'd post here. The problem seems to be that Asterisk 1.6.0.5 is sending backslashes (needed to escape commas and so forth in 1.4.21.2) as *literal* backslashes to Mysql, so that Mysql gives a syntax error
2008 Jul 23
2
Using RODBC to use SQL queries
Hello, I am new to the RODBC package, but I have looked over the PDF as well as a few websites that go over the SQL language. I can connect to my database fine using >channel<-odbcConnect("Oracle ODBC") # then am prompted to enter my user id and password After that I'd like to use the odbcQuery function and the SQL statement: SELECT * FROM table_name WHERE SAMPLE_YEA LIKE