Variable undefined

-

good morning have situation wherein  during insert database, variable created cfif/cfset throws error. missing something? code below...

 

<cfset gradepoint =val('#fcnpoint#') + val('#attitudepoint#') +

val('#guestpoint#') + val('#contactpoint#') + val('#attendancepoint#')

+ val('#nspoint#') + val('#foidpoint#') + val('#otherpoint#')>

 

 

<cfif "#gradepoint#" gte "-20.45" , "#gradepoint#" lte "11.1"><cfset

maingrade= 'f'></cfif>

 

 

insert squadreport (squid,  squgrade)

 

values ('00', '#maingrade#')

</cfquery>

if cfif condition not met, #maingrade# not set.

 

you cfparam #maingrade#, not address issue, prevent error.

 

^_^



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

Joomla 3.3 Installation Error message - Joomla! Forum - community, help and support

-
hi all, bought new hosting account , attempting install joomla 3.3. error message getting, instead of joomla installation page. have spoken godaddy support , claim loaded correctly. error displaying error page: table 'i694666_jos1.jos_template_styles' doesn't exist sql=select id, home, template, s.params jos_template_styles s left join jos_extensions e on e.element=s.template , e.type='template' , e.client_id=s.client_id s.client_id = 0 , e.enabled = 1: table 'i694666_jos1.jos_usergroups' doesn't exist sql=select b.id jos_usergroups left join jos_usergroups b on b.lft <= a.lft , b.rgt >= a.rgt a.id = 1 any idea go here? thanks! robin i guess installation did not completed correctly because looks of it, missing table on site. Board index Joomla! 3.x - Ask Support Questions Here Installation Joomla! 3.x
Read more

Multilanguage infinite redirect loop error. - Joomla! Forum - community, help and support

-
i not sure supposed post description again since it's in fpa generated post, sorry if doubled it: i have error firefox "the page isn't redirecting firefox has detected server redirecting request address in way never complete." other browsers such chromium, chrome, ie , more. goes away if turn off language filter plug in need make multilanguage site. error started after duplicated menus 3 languages (english, thai , italian). erased languages , menus did not resume working correctly (unless disable language filter plug in). right there no other languages menus or modules need use them. site @ http://www.itasne.com/palomnik ps forgot tell when try entering site url looks this: http://www.itasne.com/palomnik/index.php// 2 // language /en/ supposed be. problem description :: forum post assistant (v1.2.4) : 17th april 2014 wrote: multilanguage joomla 2.5 site: have error firefox "the page isn't redirecting firefox has detected server redirecting request address ...
Read more

Thread: Wine can't find the cd

-
Image
lately i've been trying out lots of old windows games (on cd's bought legally) have lying around on wine heck of it. 5 or 6 years old , many don't run on windows 7! been hit or miss. what's worked reliably install game on old windows xp desktop, this: copy relevant folder in program files (for example: c:/program files/warcraft iii) of windows computer usb stick. paste in linux directory (anywhere) configure wine d: drive point @ d: drive, ex: /media/warcraft iii/ find promising .exe file in folder copied windows (like warcraft3.exe) , execute wine. , works charm games! however, in ubuntu think i've installed (while running linux, put cd drive, open installer, install) , run 1 program in linux successfully. happens this: cd automatically mounts, , configure wine's d: drive in /media/warcraft iii/ i'll run installer.exe wine wait game install, seems work fine next time try start game, says "please insert warcraft iii cd...
Read more