 |
horks
Apprentice
Joined: 20 Jul 2001
Posts: 127
Location: USA
|
 Posted: Mon Jul 14, 2003 1:23 am
Another DB problem
|
This script used to work, what happened? :( I'm cut&pasting it as is. hope it comes out.
#DBGET %1
#FORALL edged|blunt|fire|ice|acid|mind|poison|energy {
#IF (&{%i}="0") {#VARIABLE so_%i {None}} {
#IF (&{%i}="1") {#VARIABLE so_%i {VLittle}} {
#IF (&{%i}="2") {#VARIABLE so_%i {VPoor}} {
#IF (&{%i}="3") {#VARIABLE so_%i {Poor}} {
#IF (&{%i}="4") {#VARIABLE so_%i {BAvg}} {
#IF (&{%i}="5") {#VARIABLE so_%i {Avg}} {
#IF (&{%i}="6") {#VARIABLE so_%i {AAvg}} {
#IF (&{%i}="7") {#VARIABLE so_%i {Good}} {
#IF (&{%i}="8") {#VARIABLE so_%i {VGood}} {
#IF (&{%i}="9") {#VARIABLE so_%i {Excellent}} {
#IF (&{%i}="10") {#VARIABLE so_%i {Supreme}} {
#IF (&{%i}="11") {#VARIABLE so_%i {Ultra}} {
#IF (&{%i}="12") {#VARIABLE so_%i {Absurd}} {
#IF (&{%i}="13") {#VARIABLE so_%i {OTS}}}}}}}}}}}}}}}}}
the &{%i} part is what is wrong i think. can anyone help me with this? I tried just removing the {}, but it still doesn't work :( |
|
|
|
|
Vijilante
SubAdmin
Joined: 18 Nov 2001
Posts: 5187
|
Posted: Mon Jul 14, 2003 2:34 am
|
When did this stop working? Did you recently upgrade from a pre 6.6x version to 6.62?
There was a change in the handling of %i, this change was to expand %i early to facilitate the addition of %j..%z to operate on nested loops. That change should not have affected your script though. Some debugging with #ECHO prior to your #IF else chain should be able to diagnose whether this is actually the problem. Possible solutions would be %rec.%i and %db(%rec,"%i"). |
|
|
|
|
|
|
|
