CF Set form.variable for query and Next/Previous pages error

-

i have cf form select posts cf "action" page.

 

on action page i: cfset itemnumber=#form.itemnumber#

 

i cfoutput 'itemnumber' cfquery (which inner join dependant on '#itemnumber#')...

 

all of above works fine , displays database fields in color alternating rows, per rest of code.

 

here's problem:

 

i'm displaying 40 rows on page per "next , previous" code. (cfparam name="start" default="1" , cfparam name="disp" default="40" along rest of nextn code in header , body). display 40 rows on page , puts link @ bottom of page "next 40 rows", etc.

 

note: i'm querying database once , using query (query name="data") populate table rows , nextn code (cfoutput name="data") , (cfif start + disp greater data.recordcount, etc)...

 

the problem happens when click "next 40 rows" link display 2nd page of rows. since (i'm assuming) nextn code 're-reading' same page top bottom, error thrown when code tries read cfset itemnumber=#form.itemnumber# @ top of page.

with #form.itemnumber# on action page coming previous posting of form action page, when "next 40 rows" link clicked , nextn code re-reads action page - cfset itemnumber (#form.itemnumber) not getting populated , throws error...

 

i hope i've not made sound confusing.

 

i can nextn code work when i'm querying database without "flying in" form variable. when cfset variable (#form.itemnumber#) inserted query, second page of nextn throws error , doesn't display.

 

i include page code here lengthy and, well, nextn code 'standard' cf code -- i've narrowed problem down above "element undefined" (when page tries reload "next 40 rows" link) , hoping there's simple fix or way display records in next , previous pages.

 

thanks in advance shedding light on this.

- e

i assume "next/last" links hyperlinks, not form buttons? , they're linking to, say, "mypage.cfm?from=10&count=40...etc.." ?

 

as click hyperlink remember clear form scope, variable won't there in new page - you'll need pass through url scope.

 

i think that's mean, unless i'm misunderstood. likely.

 

o.



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

Joomla site hacked, cant see front and - Joomla! Forum - community, help and support

-
hi all; here thing: i went see site because haven't visited week or 2 , surprised when saw white page some provocation written on tab , acronym of attacker on page. i log on ftp server see if files there , found vital data remind safe. i tried put site off line got same hackers index.html file displaying when press "preview" button in joomla admin. deleted index.html file , tried check offline site option again. time got offline page. but problem resumes when put site online... white page, nothing else written. site date, , joomla updated v. 1.5.10 few days back. virtuemart commponent installed, newest v. 1.1.3 do need install fresh joomla copy , overwrite files previous including data base, or can avoid job fixing index.html on front end. i didn't make backup copy of site, i'll if not working save date in case potential hacker delete server... any suggestions? check template index.html file (edit html in template manager active template) usual source of hacking...
Read more

Christian Home School Programs - Joomla! Forum - community, help and support

-
Image
hello guys, (my first custom template) i got son in accelerated christian home school program. they did not have web site designing , hosting cover fees in trade. website: christian home school programs i've not got content published... the graphics imagination i've installed jumi i have directphp installed mostly custom css layout , i've used css purity seo, christian home shool - 200 million+ organics i have optimized code behind visual design crawlers. any thoughts / recommendations? i'm new custom templating in joomla ears open gurus of joomla richard hey, well done on first custom template. i don't background... @ all. think should going more professional look, maybe isnt repeating on both x , y axis, , isnt shade of blue. as far content goes, there isnt much... site performance good. good luck tim Board index Joomla! Official Sites & Infrastructure Sites & Infrastructure - Feedback/Information ...
Read more

Trouble with PF_OutFlag_I_USE_AUDIO and PF_CHECKOUT_LAYER_AUDIO

-
i trying render graphical representation of layer's audio waveform. have seen this similar thread , problem checking out audio, cannot far.   in globalsetup function set out_flags thus..   out_data-> out_flags = pf_outflag_i_use_audio;   but in pf_cmd_frame_setup function, , pf_cmd_render function ( pf_cmd_smart_pre_render pf_cmd_smart_render)   the pf_indata src_snd structure empty , in_data->start_sampl == 0, in_data->dur_sampl == 0, in_data->total_sampl == 0     i missing something, appreciate guidance,   thanks   steve (london, uk - adobe plugin developers nearby?) More discussions in After Effects SDK adobe
Read more