Iam really going thru a bad time and i request u<br>>not to direct me to someone else.I need this stuff<br>>really bad.Will i find coldfusion programmers in<br>>MIRC..so that i can chat with them..or send them<br>>codes.Please answer my question ..i really need the<br>>solution to the below very very badly.<br>><br>>I am using coldfusion 4.0 on windows and i use<br>>MS-Access.I have a form which submits the query(a<br>>select query)..and i get the result in the next<br>>page.Now i want to know how do i navigate thru the<br>>result which is in the form of a table.I want to use<br>>4 buttons(First,Next,Prev and Last).once the user<br>>presses the first button the cursor automatically<br>>points on the first row..on next it goes to the next<br>>row..and so on..I want to know how do i do this<br>>using coldfusion..pls mail me any suggestions u<br>>have.if i have to use javascript..then how do i go<br>>about it.I saw Recordset function in VB script..can i<br>>use anything similar to this?if possible pls send me<br>><br>><br>>I saw all this is in a ASP book..which uses VB<br>>script.Now i cannot use them here coz i require it<br>>to run in a netscape also..so pls help me by giving<br>>me a solution for the same..by using coldfusion.<br>><br>>I am sending u three files ..one is the database<br>>file(hsnakar.mdb)..pls refer to the info table..one is<br>>the select/cfm file and other is the copy of the<br>>selectquery.cfm..pls send me the neccessary code<br>>required INCORPORATED..in the copy...selectquery.cfm<br>><br>>I will be eternally greatful to ya<br>><br>>Thanx in advance for the reply.<br>><br>>-shanka
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
NAVIGATING THRu RESULTROW IN COLDFUSION
- Thread starter vista
- Start date
say your query is named my_query<br><CFQUERY NAME="my_query" DATASOURCE=".."><br>select my_row<br>from ..<br></CFQUERY><br><CFSET the_array_for_my_query = ArrayNew(1)><br><CFLOOP QUERY = "my_query"><br> <CFSET the_array_for_my_query[CurrentRow]= my_query.my_row[CurrentRow]><br></CFLOOP><br><br>now, the 1st row is : the_array_for_my_query[1]<br>next one : the_array_for_my_query[your_index+1]<br>previous one : the_array_for_my_query[your_index-1]<br>the last one : the_array_for_my_query[my_query.recordcount]<br><br>hope that helps ! but, hey, all that is in the docs :-/<br><br><br>
- Thread starter
- #3
)))- Thread starter
- #5
<br>Wel..iam sorry..maybe iam not doing it correct..i am not getting it to work.<br><br>Can i mail ya my files iza..so that u can take a look at them..The size is also something like 89kb ..u can make aby modifications u want on these files..(There are 3 files)..one database(.mdb) and 2 cfm files.
what are the new errors ?? why isn't it working ?? <br>i'm sorry about the email but i'm at work and there's really plenty of filters and things like those :-/// <p> <br><a href=mailto:miss_lezard@bigfoot.com>miss_lezard@bigfoot.com</a><br><a href= > </a><br>
- Thread starter
- #7
<br><br>I 'll send ya a mail with all these files.<br><br>The error which it is givng me is it says that that the it is not able to recognize (.)<br>in this folowing sentence.<br><br>my_query.my_row[CurrentRow]<br><br>Anyways i think i better mail ya the thing..Thanx a lot for the support.
- Status