Displaying 6 results from an estimated 6 matches for "cust_id".
Did you mean:
bus_id
2007 Mar 13
2
RODBC Excel sqlQuery insert into
...limination, but will
take what I can get ). In order to achieve this, I will still have a need
to update spreadsheets directly through R scripts.
Simple queries seem to work fantastic! But, I am missing something when
it comes to writing.
sqlQuery( myChan,"insert into [my customers$] ( CUST_ID, NAME, SOCIAL )
VALUES( 5,'robin',5678 ) " )
[1] "[RODBC] ERROR: Could not SQLExecDirect" "S1000 -3035
[Microsoft][ODBC Excel Driver] Operation must use an updateable query."
myChan = odbcConnectExcel("c:\\foo.xls")
myChan
RODB Connection 13
Detai...
2011 Feb 07
2
problem in merging
Hi all,
I am having this error while trying to merge about 2 dataframes
m_merge = merge(m_accts,m_op, by.y="CUST_ID",by.x="FORACID",all.y=TRUE,all.x=TRUE)
Error: cannot allocate vector of size 10.0 Mb
Taby
[[alternative HTML version deleted]]
2006 Sep 18
5
Undefined method "updated?"
I recently updated Rails to the latests version, and one of my existing
apps broke. More speficially, it can''t find the method "updated?" when
it is attempting to call it on one of my models.
The stack trace follows:
NoMethodError
undefined method `updated?'' for #<MyModel:0xc91d50>
2012 Feb 15
1
Passing date as parameter while retrieving data from database using dbGetQuery
...paste(db_server_pwd, sep = ""))
start_dt <- as.Date('2010-11-01',format="%Y-%m-%d")
end_dt <- as.Date('2011-01-31',format="%Y-%m-%d")
library(sqldf)
target_population <- dbGetQuery(conn,
"select distinct
a.primary_customer_code as cust_id,
a.primary_product_code,
a.account_opening_date,
b.l4_product_hierarchy_code,
b.l5_product_hierarchy_code
from account_dim a,
product_dim b
where a.primary_product_code=b.l5_product_hierarchy_code
and a.account_opening_date between start_dt and end_dt")
#######################################...
2010 Mar 22
2
ActiveMerchant, Authorize.net and Email Receipts
...module Billing #:nodoc:
class AuthorizeNetGateway < Gateway
...snip...
def add_customer_data(post, options)
if options.has_key? :email
post[:email] = options[:email]
post[:email_customer] = false
end
if options.has_key? :customer
post[:cust_id] = options[:customer]
end
if options.has_key? :ip
post[:customer_ip] = options[:ip]
end
end
...etc...
END RUBY
add_customer_data is called within purchase to process its options
hash. My question is in reference to the line that processes the email
key: Wh...
2005 Jan 24
3
cepstral integration with * using AGI?
Hi, I've looked at the Wiki for this, have seen the Swift.agi details,
but has anyone got a current script for Cepstral and an example of
integraton in * please?
I'm a * and linux newbie, so please be gentle ;-)
Thanks
John