No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
3 Posted Topics
Here's one way (from CFMX manual, pages 468-469): <CFQUERY DATASOURCE="your_db" NAME="GetLinks"> SELECT link, link_ID FROM your_table </CFQUERY> <cfparam NAME ="MaxRows" default="10"> <cfparam NAME ="StartRow" default="1"> <CFOUTPUT QUERY="GetLinks" startrow="#StartRow#" maxrows="#MaxRows#"> #GetLinks.currentRow# --- #link#<BR> </CFOUTPUT> <CFIF (StartRow+MaxRows) LTE GetLinks.recordcount> <a href="your_filename.cfm?StartRow=<cfoutput>#evaluate(StartRow+MaxRows)#</cfoutput>"><img src="/images/arrow.gif></a> </CFIF><br> <a href="your_filename.cfm?StartRow=1">Reset counter</a> (too easy, so I decided to …
1. Here's one way (from CFMX manual, pages 468-469): <CFQUERY DATASOURCE="your_db" NAME="GetUser_ID"> SELECT username, user_ID FROM users </CFQUERY> <cfparam NAME ="MaxRows" default="1"> <cfparam NAME ="StartRow" default="1"> <CFOUTPUT QUERY="GetUser_ID" startrow="#StartRow#" maxrows="#MaxRows#"> #GetUser_ID.currentRow# --- #user_ID# --- #username#<BR> </CFOUTPUT> <CFIF (StartRow+MaxRows) LTE GetUser_ID.recordcount> <a href="your_filename.cfm?StartRow=<cfoutput>#evaluate(StartRow+MaxRows)#</cfoutput>">Next username </a> </CFIF><br> <a href="your_filename.cfm?StartRow=1">Reset counter</a> (too easy, …
If the details table has a primary key, include it as the foreign key in your images table for every image record for that particular house. The form will update the images table with this value and you'll never be out of synch.
The End.