Hi,
I have created several queries which produce the same data based on a slightly difference set of variables: - <cfquery name="KWBand1S" dbtype="query">
-
select ClientFK,
-
ResponseLevelFK,
-
PowerRating,
-
WORecDate,
-
ActualCompDate,
-
QuoteACDate,
-
QuotePDate
-
from getPumpsDate
-
where ResponseLevelFK like 'Standard'
-
and (PowerRating >0
-
and PowerRating <=2.9)
-
</cfquery>
The only variable that changes is the Power Rating - it has various ranges and I just created a query for each one.
The output gets mashed up so that the number of records are counted and divided by a count of the days in the date range to produce a number N: - <cfset intDayTotal = 0>
-
<cfloop query="KWBand1S">
-
<cfset dtFrom = #WORecDate# />
-
<cfset dtTo = #ActualCompDate# />
-
<cfset ctDays = DateDiff ("d", dtFrom, dtTo)>
-
<cfset intDayTotal = intDayTotal + ctDays>
-
</cfloop>
-
<cfset RecCount = KWBand1S.RecordCount>
-
<cfif RecCount NEQ 0>
-
<cfset KWBand1SD = intDayTotal/RecCount>
-
<cfoutput>#numberFormat(KWBand1SD, "___._")#</cfoutput>
-
-
<cfelse>
-
-
-
</cfif>
Which all works. But now I need to output the records in a table - fine, except that I have 12 different query sets to work from.
Is there anyway to have the source of my output table as a variable whose value is changed when the user clicks on the number N - ie showing the records in that query set? I was thinking that an onclick event might change the variable value, but don't know how.
Thanks
Neil
21 8288
This would be more of a JavaScript question, but you could use the same query using <cfif> to decide which power rating to use.
Do you want only one number set to be displayed at a time, or would the whole lot do? Also, does the change have to happen instantly or is a page unload/reload not a problem?
hi Acoder,
how would I achieve this? i only want it to display one number change at a time, but obviously want to give the user the choice of changing it (whether clicking on the number or selecting the criteria from a drop down list box).
I need instantaneous update really.
You have at least two choices:
1. Load all the data into JavaScript data structures, e.g. arrays to use to update the table. Use Coldfusion to generate the JavaScript code.
2. Use Ajax. Make a Http request to a Coldfusion page which gets the correct data for the passed parameter.
Which one would you be more comfortable with?
Note: Coldfusion 8 has a few Ajax tags, but I personally haven't really looked into them, because I'm quite comfortable with JavaScript/Ajax.
The first really, as I`m using a company server that only runs CF5 and no ajax (as far as I am aware).
The only other thing i was thinking of doing was generating a table from each query, then hiding it until the user clicks on a number, which would show the table, but I`m guessing that a javascript question!
Yes, that would be another option, but you would need to use Coldfusion to generate it.
Note that Ajax support is more to do with the browser rather than the version of Coldfusion, so it's still an option for you.
Thanks acoder - what I've done is generate all the tables then just hidden them using .css, using a javascript function to open them: - <script language="JavaScript">
-
//here you place the ids of every element you want.
-
var ids=new Array('s1','s2','s3','s4','s5','s6','c1','c2','c3','c4','c5','c6');
-
-
function switchid(id){
-
hideallids();
-
showdiv(id);
-
}
-
-
function hideallids(){
-
//loop through the array and hide each element by id
-
for (var i=0;i<ids.length;i++){
-
hidediv(ids[i]);
-
}
-
}
-
-
function hidediv(id) {
-
//safe function to hide an element with a specified id
-
if (document.getElementById) { // DOM3 = IE5, NS6
-
document.getElementById(id).style.display = 'none';
-
}
-
else {
-
if (document.layers) { // Netscape 4
-
document.id.display = 'none';
-
}
-
else { // IE 4
-
document.all.id.style.display = 'none';
-
}
-
}
-
}
-
-
function showdiv(id) {
-
//safe function to show an element with a specified id
-
-
if (document.getElementById) { // DOM3 = IE5, NS6
-
document.getElementById(id).style.display = 'block';
-
}
-
else {
-
if (document.layers) { // Netscape 4
-
document.id.display = 'block';
-
}
-
else { // IE 4
-
document.all.id.style.display = 'block';
-
}
-
}
-
}
-
</script>
Where the div has the ID shown in the function.
One other thing tho - if I include in my table another link (a particular order number for example) can I use CF to open that link, carrying the order number variable to another bit of cfm script? (in this case a script that shows the order details for that number, which I already have).
Thanks for your help
Neil
That code should work, though the code is badly out of date. @ndeeley
Either use the same method, i.e. keep hidden initially and show with JavaScript, or use Ajax to show only the ones required as and when needed. The advantage of the first way is that you've already got something similar working, but if there's a lot of stuff, it may affect page load.
Yes, I didn't write it - I found it on the web, and it workd, so I used it. I haven't done any training in Javascript. Unfortunately I`m in one of those jobs where you get trained on something, use it for a while, and then not for 12 months...
Thanks for your comments - I'll give it a go!
Cheers
Neil
I saw - thanks very much for your help!
You're welcome :)
Did you get the order number/details part working?
No....I was going to post it!
Here's my hyperlink: - <td class="tdpump" style="width: 120px;"><a href="http:\\marlin\engeastl\scripts\repairworkshops\devaction_search2.cfm?ClientWONO=#ClientWONO#">#ClientWONO#</a></td>
And the script that processes it: - <cfquery datasource="repairmdb" name="GetClientNo">
-
select ID,
-
WorkshopFK,
-
ClientFK,
-
SiteFK,
-
WORecdate,
-
ResponseLevelFK,
-
ClientWONO,
-
WorkshopWONO,
-
WorkshopJOBNO,
-
AssetNO,
-
AssetClassFK,
-
LocalID,
-
ManufacturerFK,
-
SerialNO,
-
BuildYear,
-
ModelFK,
-
Frame,
-
PowerRating,
-
Volts,
-
Rmin,
-
Amps,
-
Ph,
-
Head,
-
ImpellerDetails,
-
Hz,
-
ExRated,
-
AssetNotes,
-
QuoteP,
-
QuotePDate,
-
Price,
-
QuoteAccepted,
-
QuoteACDate,
-
TargetCDate,
-
UQuoteNotes,
-
ActualCompDate,
-
DeliveryDate,
-
FailureReasonFK,
-
FRNotes,
-
RSLoggedDate,
-
RSInspectDate,
-
InspectedByFK,
-
RSQuotedDate,
-
RSApprovedDate,
-
RSWIPDate,
-
AssignedToFK,
-
RSDelDate,
-
RSCompDate,
-
DateRecordAdded
-
from tblWorkshops
-
where ClientWONO like #ClientWONO#
But its not working...
What do you mean by not working?
Shouldn't "ClientWONO like #ClientWONO#" be "ClientWONO = #ClientWONO#"? Is ClientWONO a string or a number?
Yes, sorry i posted the wrong code.
The actual hyperlinking is this: - <td style="width: 100px;"><a href="http://marlin/engeastl/scripts/RepairWorkshops/Devaction_search2.cfm?WorkshopWONO='#WorkshopWONO#'">#WorkshopWONO#</a></td>
and the processing code is: - <cfquery datasource="repairmdb" name="GetClientNo">
-
select ID,
-
WorkshopFK,
-
ClientFK,
-
SiteFK,
-
WORecdate,
-
ResponseLevelFK,
-
ClientWONO,
-
WorkshopWONO,
-
WorkshopJOBNO,
-
DateRecordAdded
-
from tblWorkshops
-
where WorkshopWONO = '#WorkshopWONO#'
WorkshopWONO is a string (tho actually a number stored in a text field, for reasons that they don't all have a WONO).
The processing page appears, but tells me that no record is found, so it's not processing the received value properly.
You don't need the single quotes around WorkshopWONO, so the link should be: - Devaction_search2.cfm?WorkshopWONO=#WorkshopWONO#
Note that you could still store it as a number and use NULL for non-values.
That's grand - thanks acoder!
Neil
Though it's probably not as much of a problem with an internal application (except with an programming-savvy disgruntled employee), a point to bear in mind is that you should sanitise inputs before using them in queries (e.g. use cfqueryparam), otherwise you could be subject to an SQL injection attack.
Ok...for the non technically minded (ie given a book on CF and dumped in the deep end) what is an SQL injection attack?
This article should help, though maybe one or two things may not apply to Coldfusion 5. For a general link on SQL injection, see the Wikipedia entry.
Interesing, and not about a cure for Swine Flu like I first thought...
I'm cleaning up my code so I shall apply all the instructions within!
Cheers acoder!
Neil
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Zalek Bloom |
last post by:
Hello,
Here is my problem:
I am displaying to a user a row of buttons. Depending on which button
user presses, I want to go to a different URL and to give a different
value to a hidden...
|
by: KS |
last post by:
Just to show some code to show the consept.
<img id="date" onclick="javascript:show_calendar();"
src="/PlexSysWeb/images/show-calendar.gif" width=20 height=18 border=0>
What i want the...
|
by: WindAndWaves |
last post by:
Hi Gurus
I have the following code:
function CI(ImgN, Alt){
if( document.getElementById && document.getElementById('il') ){
var d=document.getElementById('il');
|
by: Dark Magician |
last post by:
Comrades:
Am trying to build a UI widget. I'm sure part of the problem is proper
variable scope or object reference, and part of the problem may be the
way I'm calling the function, but, here...
|
by: Ben |
last post by:
Hi,
I have a number of images whose src's are changed when a button is
pressed. At the moment the href is also changed and the images are
opened. However I have a function which opens the...
|
by: johnsuth |
last post by:
I want to produce a trivial demonstration of dynamic modification.
I thought that pressing a button might change its color.
I studied O'Reillys books and successfully created the button with a...
|
by: gakman_2006 |
last post by:
I am trying to get an onclick event to pass some values to a function to display in an alert box for now. I can get it sort of working but now the way I need it. I will be changing the alert in the...
|
by: Andrew C |
last post by:
Hi, folks.
I've recently been doing a few simple tests and experiments. As a result,
I've noticed that, in dealing with 'onclick', IE seems less able than
Firefox to keep up with rapid clicking....
|
by: sourcie |
last post by:
I am changing an existing quiz found on "JavaScriptKit.com Multiple Choice Quiz"
I have an image. Instead of using the radio buttons with the normal true/false question, I want to place two...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |