Zugg Software :: %find

Register to post in forums, or Log in to your existing account

Home » Knowledge Base » CMUD » CMUD Manual Source

Contents

Database
	#DBCLOSE
	#DBDELETE
	#DBFIRST
	#DBGET
	#DBLOAD
	#DBNEXT
	#DBOFFLINE
	#DBONLINE
	#DBPREV
	#DBPUT
	#DBRESET
	#DBSAVE
	#FIND
	#LOOPVIEW
	#NEW
	#QUERY
	#VIEW
	%average
	%count
	%dbget
	%dblist
	%dbmax
	%dbmin
	%iskey
	%numkeys
	%numrec
	%query
	%stdev
	%sum
	%viewrec
	Database

Function Reference
	%abs
	%additem
	%addkey
	%alarm
	%alias
	%ansi
	%array
	%arrget
	%arrhigh
	%arrset
	%ascii
	%average
	%begins
	%bitand
	%bitnot
	%bitor
	%bitset
	%bitshift
	%bittest
	%bitxor
	%btncol
	%btnenable
	%btnimage
	%case
	%char
	%charcomment
	%charnotes
	%class
	%clip
	%color
	%colorname
	%colorsyntax
	%comactive
	%comcreate
	%comget
	%comset
	%concat
	%copy
	%count
	%countlist
	%crtonl
	%db
	%dbget
	%dbitems
	%dbkey
	%dbkeys
	%dblist
	%dbmax
	%dbmin
	%dbvalues
	%dde
	%ddeclose
	%ddemacro
	%ddeopen
	%ddepoke
	%defined
	%delete
	%delitem
	%delkey
	%delnitem
	%destroom
	%dice
	%diceavg
	%dicedev
	%dicemax
	%dicemin
	%doorname
	%dups
	%ends
	%eval
	%exec
	%exp
	%expand
	%expanddb
	%expandlist
	%filesize
	%find
	%float
	%format
	%getglobal
	%grep
	%gsl
	%handle
	%hexcolor
	%hexnum
	%hexstr
	%htmldecode
	%htmlencode
	%iconstate
	%if
	%insert
	%int
	%inwalk
	%isfloat
	%iskey
	%ismember
	%isnumber
	%isvalue
	%item
	%json
	%lastdir
	%left
	%leftback
	%len
	%line
	%list
	%literal
	%look
	%lower
	%mapfilter
	%maplocked
	%mapquery
	%mapvnum
	%match
	%max
	%mcp
	%min
	%mod
	%mss
	%nextdir
	%nltocr
	%norm
	%null
	%number
	%numbuttons
	%numitems
	%numkeys
	%numparam
	%numrec
	%numrooms
	%numwords
	%numzones
	%packages
	%param
	%params
	%parsemode
	%parsenumbers
	%pat
	%pathcompress
	%pathexpand
	%pathfrom
	%pathreverse
	%pick
	%pop
	%portal
	%portalenabled
	%pos
	%pref
	%priority
	%prompt
	%proper
	%push
	%query
	%quote
	%random
	%read
	%ref
	%regex
	%remove
	%repeat
	%replace
	%replaceitem
	%reversedir
	%rgb
	%right
	%rightback
	%roomcol
	%roomcom
	%roomcontents
	%roomcost
	%roomdesc
	%roomexit
	%roomflags
	%roomid
	%roomint
	%roomkey
	%roomkind
	%roomlink
	%roomload
	%roommode
	%roomname
	%roomnote
	%roomnum
	%roomportal
	%roomvnum
	%roomzone
	%round
	%section
	%setglobal
	%sort
	%sql
	%sqldb
	%sqrt
	%state
	%stdev
	%string
	%stripansi
	%stripq
	%subchar
	%subregex
	%sum
	%switch
	%threadid
	%threadname
	%time
	%trigger
	%trim
	%trimleft
	%trimright
	%upper
	%url
	%vartype
	%viewrec
	%walk
	%walkactive
	%walkconfirm
	%walkmode
	%walkroom
	%window
	%word
	%write
	%yesno
	%zonename
	%zonenum
	%zonevnum

Related Links:
	Database
	Setting View Filters

%find

[[cmud_%find]]

find

Syntax: %find(s,view,column)

returns a list of records in a database whose first column contains the string s. If view is specified, it is a string list whose first value is the name of the View to search, and optional second item is the two-character database name. Column is the name of the column to search instead of the first column and is optional. The string list that is returned is a list of record numbers with the database name attached.

Example:

If records 8 and 20 in the Potions view have a name in the first column containing the word "blue", then

#SHOW %find("blue",Potions)

would return the list 8eq|20eq

Viewer Comments [0 - Post your comments]