Displaying 5 results from an estimated 5 matches for "ssql".
Did you mean:
ssl
2006 Jul 30
3
Accessing @org.id yields internal number, not record id
With apologies, I can''t figure out the simplest thing: How to reference
a record id instead of the internal memory location of that value. I''m
new to Ruby but otherwise a veteran VB6/SQL programmer.
My code:
<snip>
sSQL = "SELECT id, org_name FROM organizations WHERE user_id =
''#{sUserId}'' AND user_password = ''#{sPassword}''"
@org = Organization.find_by_sql sSQL
if @org
write_log("Org found. Id = #{@org.id}")
</snip>
My log file...
2008 Aug 12
1
[RODBC] date attribute in sqlQuery
Hello R users,
I would like to use an integer and a date as attributes in sqlQuery,
and these arguments
are defined in my function.
Here is my function:
GetReturn<-function(code,date)
{
channel<-odbcConnect("db","user1","password")
ssql<-paste("select * from TABLE Where PF_CODE =",code,"and PF_DATE=",date)
mydata<-sqlQuery(channel,ssql)
mydata
}
Actually, the channel is open but the query on the table did not work.
The command paste worked for the integer argument but not for the date.
Thank you for h...
2010 Sep 22
1
agregar valores a una tablea de SQL
Hola a todos
Estoy aprendiendo a trabajar con el paquete de RMySQL, y a la vez con bases SQL,
así que a lo mejor no es tan complicado.
Quiero agregar valores, que genero en R, a una tabla de SQL más o menos la idea
es:
> ssql<-"INSERT INTO tabla1 (variableA, variableB) VALUES
(''valor1'',''valor2'')"
> dbSendQuery(conec, ssql)
pero entonces se incertan ceros en tabla1, siendo que valor1 y valor2, son las
variables que me guardan el numerito que generé en R... cómo le...
2005 Sep 21
0
HOWTO: A simple AGI application to modify incomi ng CallerID on the fly using SQL Server and *not* UnixODBC
...nvalid characters:
#!/usr/bin/php -q
<?php
class ODBCSocketServer {
var $sHostName; //name of the host to connect to
var $nPort; //port to connect to
var $sConnectionString; //connection string to use
//function to parse the SQL
function ExecSQL($sSQL) {
$fToOpen = fsockopen($this->sHostName, $this->nPort,
&$errno, &$errstr, 30);
if (!$fToOpen)
{
//contruct error string to return
$sReturn = "<?xml
version=\"1.0\"?>\r\n<result
state=\"failure\">\r\n<error>$errstr</error...
2005 Sep 22
0
AGI Script to interact with ACCESS Databse a nd Set CID info on the fly.
...alid characters:
#!/usr/bin/php -q
<?php
class ODBCSocketServer {
var $sHostName; //name of the host to connect to
var $nPort; //port to connect to
var $sConnectionString; //connection string to use
//function to parse the SQL
function ExecSQL($sSQL) {
$fToOpen = fsockopen($this->sHostName, $this->nPort,
&$errno, &$errstr, 30);
if (!$fToOpen)
{
//contruct error string to return
$sReturn = "<?xml
version=\"1.0\"?>\r\n<result
state=\"failure\">\r\n<error>$errstr</erro...