Displaying 20 results from an estimated 300 matches similar to: "SQL Syntax Errors"
2006 Apr 20
5
strange mysql problem
i have this model:
class LineItem < ActiveRecord::Base
belongs_to :quote
end
in the console:
>>l = LineItem.create
ActiveRecord::StatementInvalid: Mysql::Error: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '' , , , )'' at line 1:
INSERT INTO line_items (`qty`, `quote_id`,
2006 Jun 13
13
Pass infomation between different views and controllers
Hi, I am a rails and ruby nuby :-)
How do you pass data between different controllers and views? I have a
page ( a quote) that I am editing url ....quote/edit/6 6 id the
current id. I then go to a catalog (url....catalog) to add an item to
my quote (I do this via a line_item file that the quote reads) I now
want to go back to the quote. I have tried this
<%= link_to ''Back to
2006 Jan 20
11
HABTM relations
Hi,
I have 3 tables with HABTM relation.
USERS -> QUOTE_TO_USER <- QUOTES
Table QUOTE_TO_USER has 3 attributes: quote_id, user_id, component.
I have a form where I can tie multiple users to QUOTE. This is easy one,
thru "user_ids" (@quote[:user_ids] = @params[:quote][:user_ids]).
In this form I have all users and I just check those I want to tie to
this quote, however
2006 May 09
7
going crazy!!!!!! ActiveRecord::StatementInvalid in Project
any suggestions on why I am gaining this error.
ActiveRecord::StatementInvalid in ProjectsController#create
Mysql::Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '' , , , , )'' at line 1: INSERT INTO projects (`name`,
`date_created`, `quote_id`, `client_id`, `description`, `user_id`)
2006 May 08
4
set forign key
hi,
got a small problem below and not to sure how to overcome this using
rails
two tables involved with this projects and quotes
each project has a field quote_id as a forign field.
When a user is ready to upload a quote they are linked to quotes/new
from the show project page. Once the quote is uploaded how can I then
set the quote_id field with the correct key?
--
Posted via
2007 Jul 24
11
Mock or Stub strategy for validates_uniqueness_of
Hi,
I''m a bit stuck with mocking a unit test of a join model with regards to a
validates_uniqueness_of clause.
I have
class Book < AR:B
has_many :clippings
various validates_presence_of etc
end
class Clip < AR:B
has_many :clippings
various validates_presence_of etc
end
class Clipping < AR:B
belongs_to :book
belongs_to :clip
validates_uniqueness_of :clip_id,
2011 Jan 10
2
Calculating Portfolio Standard deviation
Dear R helpers
I have following data
stocks <- c("ABC", "DEF", "GHI", "JKL")
prices_df <- data.frame(ABC = c(17,24,15,22,16,22,17,22,15,19),
DEF = c(22,28,20,20,28,26,29,18,24,21),
GHI = c(32,27,32,36,37,37,34,23,25,32),
2005 May 30
4
Very simple traffic shaping script for H.323
Hello -
What I want to do seems very simple - I want to make sure any H.323
traffic gets processed before anything else entering or leaving this
network. The network has a videoconferencing device on the LAN at
192.168.16.4. A Linux firewall NATs an external IP Address to this
internal address and I have appropriate SNAT and DNAT rules that work.
The NAT and connection tracking rules all work
2009 Nov 22
5
Removing "+" and "?" signs
An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20091123/36ef28cf/attachment-0001.pl>
2016 Feb 08
2
StringSwitch class
> On Feb 5, 2016, at 4:42 PM, Mehdi Amini via llvm-dev <llvm-dev at lists.llvm.org> wrote:
>
>
>> On Feb 5, 2016, at 2:43 PM, Anupama Chandrasekhar via llvm-dev <llvm-dev at lists.llvm.org> wrote:
>>
>> Hi:
>>
>> I have a question about the llvm StringSwitch class. Why is this more efficient than comparing the hashes of the strings or just
2011 Oct 07
2
Data frame aggregation
Hello,
Could anybody help me with this question?
Example data frame
NAME TICKER SHARES PERFORMANCE
John ABC 100 0.05
John ABC 1000 1.5
Alice EFG 20 0.3
Paul HIJ 50 1.0
Paul JKL 60 2.0
Paul MNO 12 3.0
I would like to aggregate this dataframe by
2016 Feb 10
2
StringSwitch class
Sorry for belaboring on a possibly minor point here, but is my
understanding correct that even assuming that the case function is always
inlined so we don't have extra function call overhead, we have the
redundant if (!Result) checks when we use StringSwitch as opposed to a
bunch of if- elses.
Thanks.
On Mon, Feb 8, 2016 at 12:00 PM, Anupama Chandrasekhar <
anupama.lists at gmail.com>
2009 Sep 01
2
Is this a bug?
This programme
for(T in 1:3){
for(j in 1:(5-1)){
for(k in (j+1):5){
for(l in (j+2):5){
print(paste("1 JKL:", j,k,l,sep=" "))
}
}
}
}
Prints out (among other things)
[1] "1 JKL: 4 5 6"
That is for(l in (j+2):5) sets l to 6 one more than the upper limit.
cheers
Worik
[[alternative HTML version deleted]]
2016 Feb 05
4
StringSwitch class
Hi:
I have a question about the llvm StringSwitch class. Why is this more
efficient than comparing the hashes of the strings or just using a bunch of
if statements.
Anupama
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.llvm.org/pipermail/llvm-dev/attachments/20160205/9be0fcc8/attachment.html>
2005 Mar 30
1
name pollution
I've finally got SSH compiling for me, but there are a few filenames
that conflict with other projects out there (zlib, etc.) and I'm unable
to create a monolithic library with SSH without renaming some files.
Could you prefix "ssh" to the following files in the next release of
OpenSSH. Thanks.
crc32,buffer,compress,base64(openbsd file).
Thanks again.
2014 Jan 23
7
[PATCH 0/7] Various fixes for Ceph drives and parsing libvirt XML.
Miscellaneous fixes to:
- Handling of Ceph drives now works end-to-end (RHBZ#1026688).
- In particular, you can now use rbd:/// URIs in guestfish (and
they work).
- Parse Ceph & NBD network drives from libvirt XML correctly, so
that existing domains with Ceph/NBD drives can be added
(eg. using guestfish -d option).
- Add more testing of the above.
2011 Dec 01
2
Counting the occurences of a charater within a string
I am new to R but am experienced SAS user and I was hoping to get some help on counting the occurrences of a character within a string at a row level.
My dataframe, x, is structured as below:
Col1
abc/def
ghi/jkl/mno
I found this code on the board but it counts all occurrences of "/" in the dataframe.
chr.pos <- which(unlist(strsplit(x,NULL))=='/')
chr.count <-
2014 Feb 03
1
[PATCH] hivex: python: value_value no longer generates Unicode strings
This fixes Github issue #2 reported by "kupiakos".
<https://github.com/libguestfs/hivex/issues/2>
---
generator/generator.ml | 2 +-
python/t/210-setvalue.py | 26 +++++++++++++++++---------
2 files changed, 18 insertions(+), 10 deletions(-)
diff --git a/generator/generator.ml b/generator/generator.ml
index 908c5f3..02aaf12 100755
--- a/generator/generator.ml
+++
2009 Oct 02
3
break up a string into strings with a fixed length
dear all,
I have some very long strings and would like to break up each long string
into multiple strings with a fixed length, e.g. to break up
abcdefghijkl
into
abc, def, ghi, jkl
I tried a couple of commands but was not successful. Any help will be
appreciated.
Best,
Jimmy
--
View this message in context:
2011 Feb 11
2
[Q] auth(default): plain(?, 11.111.206.99): Username contains disallowed character: 0x20
Dear all,
A new user with Microsoft Express is trying to use IMAP SSL port
993. However they cannot log in. Its only with them.
The logs details the following:
Feb 11 18:56:03 logout dovecot: auth(default): plain(?,11.111.206.99):
Username contains disallowed character: 0x20
Feb 11 18:58:07 logout dovecot: imap-login: Disconnected (auth failed, 1
attempts): method=PLAIN,