Examine the original form. It will have a field for entering part numbers.. say it is called "SearchText".
All you need to do is create a new form. It will have the same "action" but instead of a input type="text" add an input type="hidden" like:
<form...
There is a method to loop through each row as well.
<cfquery datasource="yours" name="MyQuery">
SELECT stuff, morestuff FROM MyTable
</cfquery>
Some useful variables attached to your returned query
<cfoutput>
Records Returned #MyQuery.RecordCount#
Columns Returned...
That last CFSET is malformed. You can iether CFSET a "temp" variable:
<cfset j=3>
<CFSET aryName = "LOC" & j>
<CFSET aryName=arrayNew(1)>
<CFSET temp=arrayappend(aryName,1)>
<cfoutput>
#aryName[1]#
</cfoutput>
OR use CFSCRIPT
<cfscript>
j=3;
aryName="LOC"...
For SES to work you will want to have all your internal links using the SES format.
Remember that CFLOCATION tags and the like are not part of the generated HTML so are invisible to web spiders.
The standard format (as far as CFML is concerned) is:
month/day/year (not day/month/year as you have)
You could use LSDateFormat() or simply get used to the "US" format.
<!---DateFormat.cfm--->
<cfoutput>
Here is a list of 'Locales' you can use to format dates <br>
<br>
<br>...
There is a script here that breaks the counts (hits in this case) into 10 minute intervals. You could easily change it to 1 hour intervals.
http://cfhub.com/forum//index.cfm?FuseAction=Thread&TopicID=2399
For the duration of the current request.
Custom tags will have access to those variables through the Caller scope.
http://cfhub.com/advanced/customtags/caller.cfm
If it was passed as a tag attribute then prefix it with "Attributes".
If you did not pass it in explicitly you can "grab" it from the calling template by prefixing it with "Caller".
http://cfhub.com/advanced/customtags/index.cfm
It is possible to use JavaScript to lenthen your session timeouts. That is, if the user still has your site loaded in thier browser then perhaps they don't want to be logged off...
Here is a JavaScript that goes and fetches a fresh page (on a timer) so that your session won't expire until...
Add a GROUP BY to your query and add the columns you want to group to it.
Now you can use CFML's GROUP attribute:
<cfoutput query="GetQuestions" GROUP="Question">
#Question#<br>
<cfoutput>
#Answer# #Total#
<cfoutput>
</cfoutput>
A peek at this may help...
Need coffee and an edit button :-)
<CFQUERY NAME="getDomain" DataSource="mysource">
SELECT
name,
url,
langid,
Left(name,1) AS FirstChar
FROM domain
GROUP BY
FirstChar
</cfquery>
<cfoutput query="getDomain"...
A little GROUPing should help.
<CFQUERY NAME="getDomain" DataSource="mysource">
SELECT
name,
url,
langid,
Right(name,1) AS FirstChar
FROM domain
GROUP BY
FirstChar
</cfquery>
<cfoutput query="" group="">...
It is possible that the site administrator has set the session timeout to ten minutes..
If you can't get the administrator to change that value you may want to try a JavaScript to extend the session. There are many such tags in the macromedia developers exchange in addition to this one...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.