similar to: Custom Command to Generate SQL

Displaying 20 results from an estimated 2000 matches similar to: "Custom Command to Generate SQL"

2006 Apr 16
1
Design question: Years/Teams/Students
People, I want to design a historical sports db for my old school. I think at the moment it should be like: A year has many teams A team has many students A student has one lastname, firstname and middlename but a student can also have many teams (eg summer/winter abd over a number of years) . . Is there a problem with this? Doesn''t it just mean that there will be a student table
2006 Feb 26
2
auto_complete on steroids
I am trying to get more out of auto_complete than it apparently was designed to deliver. My problems seem to be two fold. 1 - I use aggregations on names... :first_name, :middle_initial, :last_name and then aggregate them using a composed_of :wholename thing auto_complete_for seems to be wired to only use table columns directly and gags on the aggregate form. 2 - foreign table columns -
2018 Sep 29
3
Authenticate users using their firstname
Hi, I'm setting up a Postfic and Dovecot with LDAP email server. My users in LDAP is like this: dn: uid=firstname,ou=People,dc=domain,dc=com uid: firstname uidNumber: 4025 gidNumber: 4025 givenName: firstname objectClass: top objectClass: person objectClass: posixAccount objectClass: shadowAccount objectClass: organizationalPerson objectClass:
2018 Oct 01
2
Authenticate users using their firstname
> On 01 October 2018 at 15:19 Steffen Kaiser <skdovecot at inf.h-brs.de> wrote: > > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Sat, 29 Sep 2018, Fady AL HAYALI wrote: > > > I'm setting up a Postfic and Dovecot with LDAP email server. My users in LDAP is like this: > > > > dn: uid=firstname,ou=People,dc=domain,dc=com > >
2009 Aug 25
5
uninitialized constant
API-> hello_message_api.rb. class HelloMessageApi < ActionWebService::API::Base api_method :hello_message, :expects => [{:firstname=>:string}, {:lastname=>:string}], :returns => [:string] end controller -> class HelloMessageController < ApplicationController web_service_api HelloMessageApi web_service_dispatching_mode :direct wsdl_service_name
2006 Jul 26
2
Question about Recipe 52
I''m reading Rails Recipes, for the precision the recipe 52 that speak about ''Making your own Rails plugin''. The question, so stupid, is that i don''t understand wath do the code def self.search(query, fields, options = {}) find :all, options.merge(:conditions => [[fields].flatten.map { |f| "LOWER(#{f}) LIKE :query"}.join(''
2018 Oct 01
1
Authenticate users using their firstname
On Mon, Oct 01, 2018 at 11:25:48PM +0200, Admin wrote: > > > Von unterwegs gesendet > > > Am 01.10.2018 um 18:27 schrieb Aki Tuomi <aki.tuomi at open-xchange.com>: > > > > > >> On 01 October 2018 at 15:19 Steffen Kaiser <skdovecot at inf.h-brs.de> wrote: > >> > >> > >> -----BEGIN PGP SIGNED MESSAGE----- >
2015 Jan 19
1
dsadd doesn't work correct
Hi together, I installed samba 4 on a server with Debian-Wheezy-OS. Everything seems to work fine. I can add a user with RSAT. The user is added to the AD, the profile is stored in the server-profile-path and homepath can be accessed. I have to import about 400 datasets to the AD. Therefore I want to use the commandlinetool dsadd. With this tool I can import datasets, which I can see with RSAT.
2006 Mar 02
3
Custom SQL Question
Hello, can search with following SQL Statement: def execute_search @result = Search.find_by_sql ["SELECT * FROM customers WHERE firstname LIKE ? LIMIT 10",params[:firstname]] render :template => "search/resultlist", :layout => false end My question is, how do I use 2 or more Parameters - and with the "%"? (I Like to use SQL-Statements because
2004 Oct 23
1
login with alias
Hi all, i'm setting up mail server and here is the question: if, for example "firstname.lastname at domain.com" is e-mail address, then how can i setup login as "firstname.lastname" and "password" not only "firstname". Of course, users want all things simple. But i don't want to use login names longer than 8 chars. Any ideas? Or should i try
2006 Jan 05
7
HOWTO: Combine fields from 2 two tables in 1 object
Hi all, For a dropdownlist (showing "Company - FirstName Lastname'') I want to fill an object @project_contacts with "Name" from table Companies and "Firstname" and "Lastname" from table contacts. Any idea? Regards, Gerard. -- "Who cares if it doesn''t do anything? It was made with our new Triple-Iso-Bifurcated-Krypton-Gate-MOS
2006 Jul 17
14
REST Relationship Models
I''m trying to figure out an elegant way to do this: I have the following three tables: people, employer, employees And consequently the following three models: class Person < ActiveRecord::Base end class Employer < ActiveRecord::Base has_many :employees end class Employee < ActiveRecord::Base belongs_to :person belongs_to :employer end I want to be able to say:
2011 Dec 22
1
Properly Escaping Quotes and Commas
Hello all, I have a setup where Asterisk sends a message to a few jabber users on each incoming call, like: exten => s,n,Macro(sendim,"Incoming call from ${CALLERID(all)}") The macro looks like this: [macro-sendimuser2] exten => s,n,JabberSend(asterisk,user2 at gmail.com,${ARG1}) exten => s,n,JabberSend(asterisk,user2 at internal.jabber.server.tld,${ARG1}) [macro-sendim]
2005 Oct 30
2
Cyrus firstname.lastname@domain
I'm converting an environment from mandrake to centos, and always try to use the applications standard on the distribution. This means a switch from courier to cyrus. A bit of reading uncovered a potential problem - the site uses firstname.lastname at domain, and I have come across references that Cyrus does not support this. I couldn't find this limitation in the Cyrus
2009 Apr 19
19
Controller spec: testing that scope is set
In a Rails controller I set the scope on a model class in an around filter. I have defined expectations on the model classes, and ideally, I would add a further expectation for the scope. Is this already possible in some way? How would I go about adding support a scope expectation? Michael -- Michael Schuerig mailto:michael at schuerig.de http://www.schuerig.de/michael/
2011 Jan 05
5
Login with firstname.lastname instead of loginname - WORKING
3 years ago (!) I aksed about this and finally I implemented it today: >> # NEW >> passdb { >> driver = passwd >> # firstname.lastname at charite.de:password:uid:gid:(gecos):home:(shell):user=realloginname >> args = /usr/local/etc/dovecot.login_via_email >> } >If you're only using it as a passdb, you don't need the uid/gid/home.
2008 Jul 01
5
Attaching event observers to a series of elements - best practice?
Hi all, New member here. I''ve been working with Prototype for a while, and I love it. However, there''s one thing I still can''t figure out. Let''s say I have an array of objects, representing contacts in an address book: var contacts = [ { id: 1, firstName: "Bob", lastName: "Smith" }, { id: 2, firstName: "Sue", lastName:
2015 Apr 17
2
user authentication issue
Hey Samba list, First a brief comment regarding my background and situation. This is my first time posting to this list. I've been asked to resolve a Samba authentication issue, but I have next to no experience using Samba. Unfortunately no one else here knows how to use it either; we're operating with an inherited environment from a sysadmin who left minimal documentation, and we have
2008 Mar 25
2
responseXML not working on XML file
When creating an Ajax.Request(''/path.xml'') i don''t get responseXML. I''m confused what I am doing wrong. If i change the response variable and dump responseText, it shows the file, it just doesn''t recognize it as xml. function xml(url){ new Ajax.Request(url, { method: ''post'', parameters:''resultSet=simcall'',
2009 Oct 28
1
replacing <NA> in character column
I have a small Excel data file with two columns of character variables, one column with a numeric variable and three rows. One of the character cells is blank and one of the numeric cells is blank. I read the data file with the following code: library(RODBC) channel <- odbcConnectExcel('u:/test.xls') sqlTables(channel) s1 <- sqlFetch(channel, "Sheet1")