Adding numbers without resubmitting
Here is my situation: I have 5 questions which ask for a percenatge. I would like a total at the bottom of the column to give a total of the percentages as they are added. I have it working in a form, 5 text boxes, and an onchange submit() in each one. Then cfset=value1+value2+ Is there a way to do this without submitting and redrawing the page every time? Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newbie CFIF for range of data
How would you write a conditional statement like this: CFIF data is greater than 0 and less that 1000 CFSET words="small" CFELSE IF data is greater than 1000 and less than 2000 CFSET words="medium" CFELSE CFSET words="large" /CFIF All of the examples seem to only show an "IS" value. not "IS" range. Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Embedding printer control codes in HTML
Has enyone ever attepted to embed printer control codes into CF or HTML doc? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
[CF-Talk] Re: ESC codes to printer
Is it possible to insert ESC codes in an CF doc so they can be sent to a printer if/when a documant is printed? I am trying to rotate print fom landscape to port and switch paper bins 1 to 2. Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newbie: Refreshing screen after update
I have a form that allows one to update company informaion. Upon submitting the data it reloads the same page and updates changed information. ( no big deal so far ) There is also a HTML link back to the main menu. (CLICK - this appears to work fine.) The problem is if I select the menu item that goes back to the edit company info screen the data is not displaying as the updated version. The database has been updated. If I reload that screen it displays the updated version or if i go into anotherpart of the program and come back to the edit screen it is updated. It is almost like the screen is loading from a cached copy. Has anyone heard of this or know of a way to solve this? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Download Code
I know that looking a source code in a browser will not display any ColdFusion programming code. My question is, is it possible to pull down someone elses code using some other method, other than FTP? Is the CF_Encritpion or some other tag a way to defeat this? Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Securing Code ( was Download Code)
Here is my situation in more detail, and I know I'm not alone. I saw a thread similar to this topic dealing from a legal stand point. early this year. I was sub-contracted by a consulting company to write a test web app for one specific client of theirs. The program is custom written for that specific client and parts would have to be rewritten to work into a general setting. Over the course of development they have really begun to see potential in the project and are seeing dollar signs. It was mentioned in the consulting firms big meeting that they were thinking of downloading the CF code and even the databases, repackage/rewrite it into a marketable fashion and resell it. My concern is, how secure is the ColdFusion code and database structure from downloading? I would like any information on the legal rights of the different parties -- programmer, consultant, client, someone who downloads it. I realise you all aren't lawyers, but any info or opinions would help. Kelly Olson -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newbie:Printing and Page Break
I have to be missing something here but; We have a CF page that displays one right after another. At the end of the form we are placing a h1 style="page-break-before: always"h1 or br style="page-break-before: always" To eject a page. First time through the loop it works, the second time and on it does not. Also, could someone tell me why something like this isn't working. /HEAD BODYasdfasdfsf h1 style="page-break-before: always"/h1 adfga /BODY /HTML Are there some conditions that must be met for this to work. K -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Nested Loops / Page Break Help
I have a page the is displaying certificate and then a multi page description afterwards. If a single certificate is printed everything is gread . CERTIFICATE, page break, DESCRIPTION, page break Now I add CFLOOP to go through multiple Certificates and I get CERTIFICATE, page break, DESCRIPTION, page break,CERTIFICATE, DESCRIPTION, CERTIFICATE, DESCRIPTION Basically the first time through the loop seems to work fine, any cycles of the loop results in no page break running. I am using the BR style="page-break-before: always". Any help would be great. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Page Breaks
Is it possible to do a page break or a Page eject between forms. We are currently using: h1 style="page-break-before: always"h1 This seems to work in netscapre but not IE. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT:MS SQL vs Oracle
Any comments would be helpful., Thanks to all. I have noticed several notes on configuring w/ Oracle and SQL. What I am wondering is what is driving these decisions. If one was building a fast Database server, which would be a Better system. Better being from the standpoint of Speed, Reliability and/or ease of configuration. Assume that all of the computers are dual processor 500 w/ 512 MB Ram. Web is also running on a separate CPU w/ the same configuration MS NT running MS SQL MS NT running Pervasive SQL Novell running Oracle Novell running Pervasive SQL or other configurations may be suggested. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Multiple Select List
This is a multi-part message in MIME format. --=_NextPart_000_003B_01BFFC97.66BBD3F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am creating a select list from some data. What I want to do is be = able to select multiple names out of the list and print/display the next = page several times based on the names, one per record. Basically = print/Display multiple records. I keep getting an error as follows. It does't like 2 + employee ID's. = What options are avaialbe for doing this. ODBC Error Code =3D 37000 (Syntax error or access violation)=20 [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (comma) in = query expression 'EmployeeID=3D107,24'.=20 The error occurred while processing an element with a general identifier = of (CFQUERY), occupying document position (44:1) to (44:46). --=_NextPart_000_003B_01BFFC97.66BBD3F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN" HTML HEAD META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type META content=3D'"MSHTML 4.72.3612.1706"' name=3DGENERATOR /HEAD BODY bgColor=3D#ff DIVFONT color=3D#00 size=3D2I am creating a select list from = some=20 data.nbsp; What I want to do is be able to select multiple names out of = the=20 list and print/display the next page several times based on the names, = one per=20 record.nbsp; Basically print/Display multiple records./FONT/DIV DIVFONT color=3D#00 size=3D2/FONTnbsp;/DIV DIVFONT color=3D#00 size=3D2 PI keep getting an error as follows. It does't like 2 + employee = ID's.nbsp;=20 What options are avaialbe for doing this. Pnbsp;/P PODBC Error Code =3D 37000 (Syntax error or access violation) /P P P[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (comma) in = query=20 expression 'EmployeeID=3D107,24'.=20 P P PThe error occurred while processing an element with a general = identifier of=20 (CFQUERY), occupying document position (44:1) to (44:46)./P P Pnbsp;/P/FONT/DIV/BODY/HTML --=_NextPart_000_003B_01BFFC97.66BBD3F0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Secure Directory
Does any one know of a custom tag what will require a password to get into a directory. Expire if the user exits out of the directory forcing a new logon to return to the secured directory. (it is a locationor URL sensitive issue not a time sensitive one.) The other catch is that I am just checking for a PIN type number not a user and password not to be demanding. Forgive the sentence. Kelly -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Select list Question and javascript
I know there has to be a better way to do this: I have a Select list which is pulling records from an access database. What I am trying to accomplish is display a SELECT BELOW option as the first item in the list. The way I have done it so far is to make a first record in the actuall database of select below. Then when it displays it it there.( crude but effective ) The problem is how to keep that one record from being deleted. Second Question: When I delete I would like a popup box for something like "You are about to Deleted - OK to continue CANCEL to return" before an actual delete takes place." How is the best way to do this? I would assume that it would be a javascript, but I haven't figured on how to pass values to the next cfm page. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Allaire Forums
Does any one use Allaire Forums, or other suggestions are welcome that we may look at. Allaire's forums keep telling me the server is to busy to handel my request!!!@#$%^* Great selling point guys.. ;-) Kelly Olson -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newbie: SELECT Question
Is it possible to move several fields form a form select. I have a database of two fields: CatagoryID and CatagoryDesc. I am building a select as follows: SELECT NAME="CatagoryID" SIZE="7" CFOUTPUT QUERY="GetCatagory" option value='#CatagoryID#' #CatagoryDescription# #CatagoryID# /CFOUTPUT /SELECT I am then reloading the same template page where at the top I have: CFIF IsDefined("CatagoryID") CFINSERT DATASOURCE="SCENARIO" TABLENAME="ScenarioDetail" /CFIF What I really need to do is insert both the CatagoryID and the CatagoryDescription, but a SELECT only seems to be able to move one value. Is there a way to move the second value? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Query within a select
Is something like this possible: SELECT NAME="ScenarioDetailID" SIZE="7" CFOUTPUT QUERY="GetCatagoryLIST" option value=#ScenarioDetailID# #ScenarioID# CFOUTPUT QUERY="GetCompany"#CompanyName# /CFOUTPUT /CFOUTPUT /SELECT Or better yet, how could something like this be done, where you may wany to display a field not in the same table as the table which a select list is being built? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFloop question? Can't get desired output
--02EDDFCBC443DB118DB040CB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sorry about all the detail. I just thought it would make it easy to explain my problem. I am doin g two queries in a loop 1 to get main items and one to get item details. I am trying to get them to match by the two fields ScenarioDetailID and ScenarioID. The queries do work to the extent that it does match ScenarioDetailID=#ScenarioDetailID# from the complete list but seem sto ignore what I would expect would keep the detail limited to the proper item. I guess I don't get the way the loops work. In my mind this should work. The long and short of my problem is that I cannot get my outout to list the way I want ( see Below at bottom). It is as if the conditions in the "Get Detail" query are being skipped. If anyone has in idea of the logic I'm missing or a better way to accomplish this I am more than open to suggestions. Kelly Olson THE DATA - Sample Only ScenarioDetail ScenarioDetailID ScenarioID CatagoryID 76 54 0 77 54 6 78 55 1 79 55 3 80 55 7 Detail DetailID DetailDescription CompanyID ScenarioDetailID ScenarioID 21 0 12 49 50 23 0 12 78 55 24 0 12 78 55 25 0 12 78 55 26 0 12 78 55 THE QUERY (#ScenarioID# is coming from the Previous page) CFQUERY NAME="ScenarioDetail" datasource="SCENARIO" SELECT a.CatagoryID, b.CatagoryDescription, a.ScenarioDetailID, b.CatagoryID FROM ScenarioDetail a, Catagory b WHERE ScenarioID=#ScenarioID# and a.catagoryID=b.catagoryID /CFQUERY CFQUERY NAME="GetDetail" datasource="SCENARIO" SELECT a.ScenarioDetailID, a.ScenarioID, b.ScenarioDetailID, b.ScenarioID, b.employeeskill, b.documentsUsed, b.EquipmentUsed, b.Interactions FROM ScenarioDetail a, Detail b WHERE a.ScenarioDetailID=b.ScenarioDetailID and a.scenarioID=#ScenarioID# and a.ScenarioID=b.ScenarioID /CFQUERY THE CFLOOP FORM METHOD="POST" CFLOOP QUERY="ScenarioDetail" CFOUTPUT #CatagoryDescription# #ScenarioID# #ScenarioDetailID#br /CFOUTPUT CFOUTPUT QUERY="GetDetail" #ScenarioDetail.ScenarioDetailID# #ScenarioID# #EmployeeSkill# #DocumentsUsed# #EquipmentUsed# #Interactions#br/CFOUTPUT /CFLOOP /FORM THE OUTPUT (ScenarioID = 55 ScenarioDetailID=78) Acceptance Inspection 55 78 78 55 Employye 1 doc 1 78 55 employee 2 equip 2 78 55 employee 3 mod 2 mod 3 inter 3 78 55 employee 4 doc 4 equip 4 inter 4 Outgoing Inspection 55 79 78 55 Employye 1 doc 1 78 55 employee 2 equip 2 78 55 employee 3 mod 2 mod 3 inter 3 78 55 employee 4 doc 4 equip 4 inter 4 Communication Skills 55 80 78 55 Employye 1 doc 1 78 55 employee 2 equip 2 78 55 employee 3 mod 2 mod 3 inter 3 78 55 employee 4 doc 4 equip 4 inter 4 THE OUTPUT - DESIRED Acceptance Inspection 55 78 78 55 Employye 1 doc 1 78 55 employee 2 equip 2 78 55 employee 3 mod 2 mod 3 inter 3 78 55 employee 4 doc 4 equip 4 inter 4 Outgoing Inspection 55 79 Communication Skills 55 80 --02EDDFCBC443DB118DB040CB Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit !doctype html public "-//w3c//dtd html 4.0 transitional//en" html bttSorry about all the detail. I just thought it would make it easy to explain my problem./tt/bbtt/tt/b pbttI am doin g two queries in a loop 1 to get main items and one to get item details.nbsp; I am trying to get them to match by the two fields ScenarioDetailID and ScenarioID.nbsp; The queries do work to the extent that it does match ScenarioDetailID=#ScenarioDetailID# from the complete list but seem sto ignore what I would expect would keep the detail limited to the proper item./tt/b brbtt/tt/bnbsp;btt/tt/b pbttI guess I don't get the way the loops work.nbsp; In my mind this should work.nbsp; The long and short of my problem is that I cannot get my outout to list the way I want ( see Below at bottom).nbsp; It is as if the conditions in the "Get Detail" query are being skipped./tt/bbtt/tt/b pbttIf anyone has in idea of the logic I'm missing or a better way to accomplish this I am more than open to suggestions./tt/b brbtt/tt/bnbsp;btt/tt/b pbttKelly Olson/tt/b brbtt/tt/bnbsp; brbtt/tt/bnbsp; brbtt/tt/bnbsp; brbtt/tt/bnbsp; brbtt/tt/bnbsp;btt/tt/b pbttTHE DATA - Sample Only/tt/b brbttScenarioDetail/tt/b brttScenarioDetailID ScenarioID CatagoryID/tt brtt76nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 54nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 0/tt brtt77nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
OT: ODBC Strange Problem
Help Anyone!! Anyone seen this, that can give me a little info. This is comming out of a 2 field table AccountID and AccountDescription. It works great up to 5 records and on the 6 record or above it generates the error above. It is basically a list of choices that are selected and a record inputed into a second table. Nothing special and it works great as long as I only have 5 records in the selecting table. There is no validation. I have tried deleting the table and recreating it with the same problem. Error Diagnostic Information ODBC Error Code = 22003 (Numeric value out of range) [Microsoft][ODBC Microsoft Access 97 Driver]Numeric value out of range The error occurred while processing an element with a general identifier of (CFINSERT), occupying document position (3:2) to (3:61). Date/Time: 07/06/00 13:19:51 Browser: Mozilla/4.73 [en] (Windows NT 5.0; U) Remote Address: 63.238.222.92 HTTP Referer: http://www.mfglinks.org/scenarios/scenario/create_scenario5.cfm Template: D:\webclients\mfglinks.org\scenarios\scenario\create_scenario5.cfm -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Query Question
Hi All, I am having a heck of a time conceptualizing this query. I basically have two tables I am working with one is a Company Database with beside address and contact have a check box field that is labeled PRIVATE (YES/NO). I also have a database of records that have an items of which there may be duplicates from several companies. itemdesccompany 500item1com1 600item2com1 600item3com3 600item4com4 If the company record is marked as private. Then when I select all with a value of 600, How do I except records where the company record has private="yes" Find all records in database with a value of 600 except those from a company that is marked PRIVATE Kelly -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Creating PDF
This may have been asked, or even easy to do but; Can you create a pdf file and have it created with cf data? What does it take to to do this? Kelly -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.