Zugg Software :: View topic

Beginner Joined: 25 Apr 2009 Posts: 28

Is there a way to get the database variable functions to work with variables that contain special characters?

I have a couple variables stored in my item list that have number values but some of the items are:

* crystal *
>> sword <<
ect

When I try and change or access their values with .* crystal * or with the db functions nothing is returned.

Wizard Joined: 22 Mar 2007 Posts: 2320

Use the functions instead of the dot notation, e.g. %db(@myvar,"* crystal *")

Beginner Joined: 25 Apr 2009 Posts: 28

Neither way works.

Posted: Mon Nov 16, 2009 6:42 pm

AmongTheDecay:

Are you doing it via a trigger? Such as:

#TRIGGER {({@myvar})} {#SAY %db(@myvar, %1)}

?

I've found that special characters don't work like that for some reason, though when you do it directly on the command line, it does.

Charneus

Wizard Joined: 22 Mar 2007 Posts: 2320

If %1 doesn't work in the %db() function (I haven't tried it), then try assigning the value to a local variable and using that:

Beginner Joined: 25 Apr 2009 Posts: 28

I first noticed it not working in a trigger but I tried via the command line with just #SAY %db(@items, * crystal *) and that didn't work either

Magician Joined: 02 Feb 2004 Posts: 364 Location: USA

Wizard Joined: 22 Mar 2007 Posts: 2320

Yes, you need the quotation marks. Your string has both special characters and spaces, so without the quotation marks, Cmud doesn't know how to interpret it.

GURU Joined: 23 Dec 2000 Posts: 4834 Location: USA

Quotes will work if you are putting together a literal name. If you are doing this via a variable (%1, $localvar, etc), however, quotes won't work so you should try surrounding it in {}.

In general, CMud does not restrict the characters that can be used in variable names (although I get the feeling it's supposed to). This means that the more "wrong" you make the variable name the more difficulty you will have in accessing it and in fact some of the most extreme things may make the variable totally impossible to refer to. Spaces, special character symbolics that CMud uses, other symbolics, single- and double-quotes, etc. You can even have a variable named %1, which is just totally messed up because CMud actually can't tell the difference between a @var named %1 and the system-defined variable %1 unless you include the @.

Beginner Joined: 25 Apr 2009 Posts: 28

Ya I've done it with the "s. I was responding via iPod and got lazy. Sorry.