[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

putting a variable into a KirbyBase database cell

Peter Bailey

9/28/2006 6:48:00 PM

Hi,
With a lot of help from Jamey, the KirbyBase inventor, I've managed to
get a script that does what I want it to. I've proven that I can
populate my database properly. But, so far, I've only been able to
update my table if I put in literal values, like the value "39" below.
But, in my real world, I need to put a variable in there. It's a
variable derived prior to this in the program. It's named "$totalpages."
If I put #{$totalpages} in place of the "39" below, I get a parsing
error:

:/PageCounts/pagecounter.rb:91: parse error, unexpected kEND


Dir.glob("*.ps").each do |dirfile|
result = pageinfo_tbl.select(:recno, :filename) { |r| dirfile =~
Regexp.new(r.filename) }
pageinfo_tbl.update(:pagecount=>39) { |r| r.recno ==
result.first.recno } unless result.empty?
end

Thanks,
Peter

--
Posted via http://www.ruby-....
2 Answers

Gary Wright

9/28/2006 6:53:00 PM

0


On Sep 28, 2006, at 2:47 PM, Peter Bailey wrote:

> Hi,
> With a lot of help from Jamey, the KirbyBase inventor, I've managed to
> get a script that does what I want it to. I've proven that I can
> populate my database properly. But, so far, I've only been able to
> update my table if I put in literal values, like the value "39" below.
> But, in my real world, I need to put a variable in there. It's a
> variable derived prior to this in the program. It's named
> "$totalpages."
> If I put #{$totalpages} in place of the "39" below, I get a parsing
> error:

You don't want #{$totalpages} but simply $totalpages.

The #{...} notation is for use within a string such as:

"There are #{$totalpages} total pages"

Gary Wright

Peter Bailey

9/29/2006 3:48:00 PM

0

unknown wrote:
> On Sep 28, 2006, at 2:47 PM, Peter Bailey wrote:
>
>> Hi,
>> With a lot of help from Jamey, the KirbyBase inventor, I've managed to
>> get a script that does what I want it to. I've proven that I can
>> populate my database properly. But, so far, I've only been able to
>> update my table if I put in literal values, like the value "39" below.
>> But, in my real world, I need to put a variable in there. It's a
>> variable derived prior to this in the program. It's named
>> "$totalpages."
>> If I put #{$totalpages} in place of the "39" below, I get a parsing
>> error:
>
> You don't want #{$totalpages} but simply $totalpages.
>
> The #{...} notation is for use within a string such as:
>
> "There are #{$totalpages} total pages"
>
> Gary Wright

Thanks, Gary. Yeh, I tried that too, without the braces. I didn't get
the parse error, but, I didn't get the results I needed, either. I found
that I have some variable problems. But, thanks for the explanation.
I've always been confused about when to use #{ or not.
-Peter

--
Posted via http://www.ruby-....