Validation error for tag cfloop

-

hi all,

 

complete newbie cf here.  i've inherited (or bought) online business has site written in cf.  haven't done sort of stuff before work sql living , object oriented stuff plus have done bit of html , php cf isn't mind blowing me (in simple form).

 

i've downloaded site on computer run local copy can hack pieces if needs be.  reason, have few problems site running locally.  first error i'm getting attribute validation error tag cfloop.

 

basically, index.cfm has bit of code in it:

<cfinvoke component="#datasets#" method="storedprocedure" returnvariable="getfeaturedwineries_qry">
    <cfinvokeargument name="storedprocedure" value="usp_getfeaturedwineries">
</cfinvoke>

 

ok, easy enough.  anyway, there's call down page to:

<cfinclude template = "#request.cfmpath#includes/displayfeaturedwineries.cfm">

 

within displayfeaturedwineries.cfm code calls stored proc invoked above:

<cfloop query="getfeaturedwineries_qry" startrow="1" endrow="2">

 

bam, that's error occurs.  "the value of attribute query, getfeaturedwineries_qry, invalid.

 

what???  stored proc exists , returns 2 records (which begs me wonder why have startrow , endrow anyway, doesn't work or without it).

 

the other interesting thing works on production, no problem!!!  wtf?  how can work on production not locally.

 

the thing i'm starting think is:

a)  i've missed setting somewhere in cf or

b)  i'm running apache compared iis or

c)  i'm running sql 2008 , cf 9 no doubt different production host server.

 

should b or c causing type of problem??

 

thanks,

matt

here thing try.

 

1. can use cfdump tag output values of variables assist in troubleshooting.  if use cfdump output value of getfeaturedwineries_qry on line before cfloop contents appear expected?

 

2. cfdump of #request.cfmpath#includes/displayfeaturedwineries.cfm point file exists on system?

 

3. same #datasets#.

 

4. in regards apache vs. iis, there issue path or other value being case sensitive in apache?

 

5. in regards sql server sql profile/trace show queries/stored procedures being executed?

 

it might helpful have more of code @ more details how enviroment setup.

 

cfdump tag documentation

http://help.adobe.com/en_us/coldfusion/9.0/cfmlref/wsc3ff6d0ea77859461172e0811cbec22c24-7e f7.html



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

CS5 Adobe Media Encoder: Encode failed because the source duration is nil.

-
i've been running production premium on new windows 7 64bit, 6gb i7 system several weeks , haven't had issues exporting media encoder.   i installed trial version of dreamweaver without of add-on's thought might mess licensed installation.   every attempt export -> media -> queue get's following error in ameencodingerrorlog.txt   - source file: c:\users\rob\appdata\local\temp\someproject.prproj - output file: c:\users\rob\videos\someproject.mov - preset used: custom - video: - audio: - bitrate: - encoding time: 00:00:00 7/8/2010 10:14:34 : encoding failed ------------------------------------------------- encode failed because source duration nil.   doing export directly pp works without error, don't want wait each export complete.   any ideas other reinstall pp?   tia i noticed range selector triangles right next each other.   changed source range: work area   not sure why default set 0 range. doesn't remember last setting when selected entire sequ
Read more

cf_sql_integer vs cf_sql_bigint vs cf_sql_int??

-
i have id (primary key) set bigint in sql server. have query following: where whateverid = <cfqueryparam cfsqltype="cf_sql_integer" value="#url.id#"> i got invalid data type it. tried: where whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#url.id#"> i still got invalid data type it. tried: where whateverid = <cfqueryparam cfsqltype="cf_sql_int" value="#url.id#"> and worked. the weird thing cf_sql_int not listed being accepted: http://www.adobe.com/livedocs/coldfusion/5.0/cfml_reference/tags79.htm can explain me. > whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#url.id#"> what value of #url.id#? had no problems either using cf8. > weird thing cf_sql_int not listed being accepted: iirc, when pass in invalid sql type cf uses default: cf_sql_char, accepts anything. ms sql implicit convert() right type , why works. More discussions in Data
Read more

localhost/joomla15/administrator doesnt work - Joomla! Forum - community, help and support

-
hi, i'm starting , address http://localhost/joomla15/administrator doesn't work (it stays blank, no error or anything). wonder if have change in address or somewhere else. joomla installed through web-host dreamhost.com , didn't have much. i appreciate help. silvia http://localhost tells browser not go out internet use localized web server installed on pc. lack of better description, localized web server doing coding , test site development on local pc using software turns pc "local" web server; hence, term - localhost. you mentioned dreamhost.com installing joomla. assume mean installed joomla on hosting account? so need access joomla installation by: http://www.yourdomain.com/joomla15/administrator Board index Joomla! Older Version Support Joomla! 1.5 Installation 1.5
Read more