Referencing field in a query struct

-

about 5% of time error 'element companystatus undefined in q.' code in snippet 1. can tell me why ever error? if query returns 0 results (which may if user not logged in , session.user.getcompanyid() return 0) should return false since q.recordcount 0. problem know users in @ least cases logged in , query returning @ least 1 row. if statement should short circuit on record count if 0. if doesn't comparison q.companystatus should valid. know why cf flakes out when referencing q.companystatus? see in other areas such in snippet 2. method called cfc can guarantee passed argument '_company_id' valid integer , sql should return 1 result. why error 'element state undefined in q.' bad practice referencing query fields way?

thanks in advance

it looks me not running query?
i see no <cfquery> tag anywhere, sql statement text string...

in cf run sql statements inside <cfquery></cfquery> tag block (or
initiate stored procedure <cfstoredproc> tag...

azadi saryev
sabai-dee.com
http://www.sabai-dee.com/


More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

VIDIOC_S_FMT error 16, Device or resource busy - Raspberry Pi Forums

-
dear all, working on image processing using raspberry pi, have installed intex usb web camera on raspberry pi. have used basic python script of image processing https://www.cl.cam.ac.uk/projects/raspb ... first.html required libraries installed on raspberry pi. script code: import imgproc imgproc import * # open webcam take pictures camera = camera(160, 120) # open viewer window display images viewer = viewer(160, 120, "the first step") # take picture camera img = camera.grabimage() # display image in viewer viewer.displayimage(img) # iterate on each pixel in image x in range(0, img.width): for y in range(0, img.height): # value @ xth column , yth row, place intensities variables red, green, blue = img[x, y] # test find colour dominant if red > green , red > blue: # red dominant, set pixel red img[x, y] = 255, 0, 0 elif green > red , green > blue: img[x, y] = 0, 255, 0 else: # if red or gr
Read more

using a laptop skeleton to build a pi laptop - Raspberry Pi Forums

-
Image
i have laptop dead motherboard . can remove components laptop , in anyway possible connect raspberry pi inbuilt display , keyboard on laptop ? (and touchpad if possible). (i figured remove components inside , fix pie inside , use extended usb cable , connect available usb ports respective holes in laptop skeleton, same headphone out ) . i'm noob when comes pi . on topic appreciated if screen lvds type may possible use screen installing converter board. this: http://www.ebay.com/itm/hdmi-dvi-vga-dr ... 3027&rt=nc need model number of screen , ask seller if work. or search ebay using brand , model number. assuming screen in working order..... back-light not burnt out etc.. other devices...... can used if have usb interface not part of motherboard. have make connector. raspberrypi
Read more

Forum for Joomla? - Joomla! Forum - community, help and support

-
heya, i need forum joomla works community builder , not joomlaboard. im using jb right now, , not working me >< what other *proper* installations there available? i recommend smf, that's forum using here, see link on bottom of page. there's called smf/joomla "bridge" available, see http://extensions.joomla.org/component/ ... itemid,35/ Board index Joomla! Older Version Support Joomla! 1.0 Extensions - 1.0.x Components
Read more