transact(ms sql) VS PL SQL(Oracle)
Does anyone have a good article or experiences on the differences between ms sql and oracle databases... thanks, --- phumes1 [EMAIL PROTECTED] wrote: I don't know whats happening... The contents of my output.txt file still contains the following. The output to the screen (console) is totally different and this is what I want dumped into the output file. The executable is a compiled Perl script. Does anyone know how to dump the output of the perl script to a file? C:\tempsetlocal C:\tempc: C:\tempcd c:\temp c:\tempc:\program\runme.exe c:\temp\filename printer At 11:19 AM 6/7/2002 +0100, you wrote: C:\temptest.bat output.txt I'd suggest putting a location before the output.txt, something like Test.bat c:\output.txt I'm not sure where CFEXECUTE calls the file from... Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: 06 June 2002 18:27 To: CF-Talk Subject: cfexecute Hi, This is what I put in my batch file: test.bat setlocal c: cd C:\temp c:\tempc:\program\runme.exe c:\temp\filename printer Then from the command prompt I did: C:\temptest.bat output.txt The programs run just fine. The program displays the processing to the screen. When I open the file output.txt this is what it contains: C:\tempsetlocal C:\tempc: C:\tempcd c:\temp c:\tempc:\program\runme.exe c:\temp\filename printer I don't know whats going on. The output.txt file should contain the output thats dumped to the screen but it doesn't. The executable file is a Perl script which was compiled to a .exe file. Could there be something in the Perl script thats stopping the output to a file? Its works to the screen so I can't figure out whats happening. Any ideas? The bat file seem to be working exactly as you tell them to. In the instance below, when you are calling the exe directly, you are rerouting the screen output to the p.log file. It is routing the ouput of the runme command to the log file. In the CFExecute example you posted earlier, you are routing the output from the BAT file to the log file. Not quite the same thing. Try changing the call in the BAT file to match your example below, including the redirected output stream. (and what are the command switches -e /q /v doing for you in the CFExecute example? Is /q quiet mode, which supresses all bat file output?) Now you've got me curious Jerry Johnson [EMAIL PROTECTED] 06/05/02 02:27PM Why is my output file empty? The filename is passed to the executable for processing but shen I specify the output to be redirected to a file its empty. Why? Run from command prompt: c:\tempc:\program\runme.exe c:\temp\filename printer p.log +- --+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] +- ---+ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Distinct Query help
Hello,
I am having a little trouble constructing this query
because I need a count of a distinct composite
column combo - Date and CMid..for example..here is
the table and the columns in it:
DateCMid value rate
- -- -- --
02/021 3 6
02/021 8 2
02/022 6 9
02/023 5 5
02/023 1 2
05/023 1 5
so the count for the above table should be 4...and the
SELECT stmt needs to look something like the one below
as it is part of a Union stmt...
SELECT Count(*) AS Totals, 'Monthly Contacts' AS
Types,
emp.FirstName, emp.LastName
FROM CMMonthlyContact co, Employee emp
WHERE co.dDateStamp = '#variables.dBeginDate#'
AND co.dDateStamp = '#variables.dEndDate#'
AND co.vUserStamp IN ('#variables.DataEntryEmp#')
AND emp.iEmpID IN ('#variables.DataEntryEmp#')
Any ideas?
Thanks!
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL help - getting first rec of field????
Hello, I have been trying to figure out how to write this SQL stmt..I have it written but it needs one more modificationI need the query to only pull the first unique EventID... SELECT CMME.iMonthlyEventId as EventID, CMME.iCMApptId as CMapptID, cli.vClientFName + cli.vClientLName as ClientName, CMME.dMonthlyEventDate as Event Date, cas.iCasacApptID as CasacID, cas.dCasacDate as CasacDate, emp.vEmpFName + emp.vEmpLNAme as Case_Manager, cd1.vcodedecode as eventtypeName FROMCMMonthlyEvent CMME, codedecode cd1, Client cli, employee emp, CasacAppt cas, CasacApptRelationship rel WHERE emp.iempId = CMME.iempId ANDcas.iClientID = cli.iClientID ANDcd1.icodedecodeId = CMME.cEventTypeId ANDCMME.iCMApptId = rel.iCMApptId ANDcas.iCasacApptID = rel.icasacapptid order by CMME.iCMApptId, dmonthlyeventdate the partial results are: EventID CMapptID ... 601 601 751 751 803 803 803 I want the results to be.. 601 751 803 __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL help - getting first rec of field????
Kevin, I actually tried this earlier and it still gave me the same results...I think its because the CasacID can be a one - two relationshipI am tring to make it work as an embedded query so it will select the top iMonthlyEventID, grouped by iMonthlyEventIDnto sure if this is possible though... --- Kevin Schmidt [EMAIL PROTECTED] wrote: SELECT DISTINCT(CMME.iMonthlyEventID) :) Kevin -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 9:18 AM To: CF-Talk Subject: SQL help - getting first rec of field Hello, I have been trying to figure out how to write this SQL stmt..I have it written but it needs one more modificationI need the query to only pull the first unique EventID... SELECTCMME.iMonthlyEventId as EventID, CMME.iCMApptId as CMapptID, cli.vClientFName + cli.vClientLName as ClientName, CMME.dMonthlyEventDate as Event Date, cas.iCasacApptID as CasacID, cas.dCasacDate as CasacDate, emp.vEmpFName + emp.vEmpLNAme as Case_Manager, cd1.vcodedecode as eventtypeName FROM CMMonthlyEvent CMME, codedecode cd1, Client cli, employee emp, CasacAppt cas, CasacApptRelationship rel WHEREemp.iempId = CMME.iempId ANDcas.iClientID = cli.iClientID AND cd1.icodedecodeId = CMME.cEventTypeId AND CMME.iCMApptId = rel.iCMApptId ANDcas.iCasacApptID = rel.icasacapptid order by CMME.iCMApptId, dmonthlyeventdate the partial results are: EventID CMapptID ... 601 601 751 751 803 803 803 I want the results to be.. 601 751 803 __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MS SQL logon help!!! PLEASE!!!!!!!
Sorry for thowing in this MS SQL questions but its an emergency!! My Sys Admin rebooted the server this morning and now I cannot get acces to MS SQL. When I try to start the services, it gives me a 1069 logon failure errordoes anyone know how I can fix this..I am assuming I need to reset a password some where, just dont know where. Thank you so much! __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
quick SQL question for my add/edit page
Hello, I need to add a new hidden field to my add/edit page that will update the table when a new record it added or updated..not sure how to write the SQL stmt to automatically create this hidden field. The user is required to enter a 6 digit program code, which begins with a letter followed by 5 numbers. So, if the program code is A12345, then I want the hidden field to be an Aif the program code is B67891, then the hidden field needs to be a B... how would I write this SQL stmt? Thanks again! __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Writing Reports - Query vs StoredProc
Hello, The application I am working on has about 10 reports that are being run every month. The queries for these reports are written in the CFML page using CFQUERY. I was wondering if it would be better(execution timewise) to write a stored procedure on the MS SQL side and calling it in the CFML page. The few applications that I have seen have not used stored procedures...does anyone out there use stored procs for report writing...is this not common practice??? Thanks! __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Writing Reports - Query vs StoredProc
You'll have to excuse me on this one but when you say dynamic, do you mean that the report requires form variables to be passed to it from the user? --- Clint Tredway [EMAIL PROTECTED] wrote: I use stored procs and views to do my reports. I find this be the best unle ss my report is dynamic. HTH Clint -- Original Message -- from: Amanda Stern [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Sun, 24 Feb 2002 14:41:10 -0800 (PST) Hello, The application I am working on has about 10 reports that are being run every month. The queries for these reports are written in the CFML page using CFQUERY. I was wondering if it would be better(execution timewise) to write a stored procedure on the MS SQL side and calling it in the CFML page. The few applications that I have seen have not used stored procedures...does anyone out there use stored procs for report writing...is this not common practice??? Thanks! __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Developer available in DFW
Hello, I am looking for a CF Developer position(Beginner to intermediate) in the Dallas Fort Worth area. Please email me offline if you would like me to send you a copy of my resume. TIA! __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Network Admin position - NYC
Hello, We have an immediate need for a newtork admin...below is a description of the position...please email me your resumes if you are interested or if you have any further questions.. Thanks, --- In this position, the Manager Information Technology will be responsible for maintaining all hardware/software for our growing agency. Will maintain all databases as well as solve any computer-related problems on a day-to-day basis. Successful candidate will consult with management to determine priorities of new projects and discuss system capacity and equipment acquisition. Other responsibilities include: training employees, leading a team, and having vision to forsee our on-going and future technology needs. Qualified candidate will have a minimum of 2 years previous computer and LAN experience. The individual must be able to think logically, be organized and detailed-oriented. Must possess strong communication skills wit the ability to interpret work to others. must be able to manage a number of assignments simultaneously. Strong computer knowledge in MS Windows NT 4/2000, Cisco router, MS SQL 2000 Server administration, Cold Fusion Server, Microsoft Office 97/2000, database administration and networking. __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: twoselectesrelated frustration!!!!! please help
I am getting another error. I must be missing something where I need to put in a CFPARAM somewhere for the query...I did not edit the template at all from the Developers Gallery and I also cut and past it into my page(is this okay to do?)this is the error message I am getting thanks again for your help!!! - The required parameter Attributes.Query was not provided.This page uses the CFPARAM tag to declare the parameter 'Attributes.Query' as required for this template. The parameter is not available. Please verify that you have passed or initialized the parameter correctly. If you wish to set a default value for the parameter you should use the DEFAULT attribute of the CFPARAM tag. --- Kola Oyedeji [EMAIL PROTECTED] wrote: Also when you added the cfparams do they all have the correct scope i.e. are all attributes prefixed with the attributes scope? Just a thought Kola Oyedeji -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 04 January 2002 19:42 To: CF-Talk Subject: RE: cf_twoselectesrelated help What does your query look like? Also, shouldn't the onchange even be this.form.submit();? Are you submitting to the same form? It seems like you're calling the query once for the selectsrelated tag, submitting the form to itself but the query i s not called again. -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 12:55 PM To: CF-Talk Subject: cf_twoselectesrelated help Hello, thanks for the tips on thisI am trying to get the cf_twoselectsrelated custom tag going but cant seem to get it to work.I downloaded the Custom Tag into my Custom Tag folder and the only changes/additions I made were to the cfparam items where a default value was not already assigned(the first 3 items). Now I get this error: An error occurred while evaluating the expression: MyQuery = Evaluate(Caller.#Attributes.Query#) An error has occurred while processing the expression: Caller. --- do I need to update this custom tag in anyway... also, my cf_twoselectsRelated code is as follows: CF_TwoSelectsRelated QUERY=get_outcome DISPLAY1=Master_Cat DISPLAY2=vcodedecode VALUE1=icodedecodetablenameid VALUE2=icodedecodeid FORCEWIDTH1=70 FORCEWIDTH2=70 SIZE1=1 SIZE2=1 HTMLBETWEEN=BR AUTOSELECTFIRST=Yes EMPTYTEXT1=(choose a category) EMPTYTEXT2=(now choose a subcategory) ONCHANGE=Submit! FORMNAME=MyOtherForm I am sure I am overlooking a few things here...any ideas? Thanks again!!! --- Raymond Camden [EMAIL PROTECTED] wrote: You are correct. Form.method won't be set until the user picks it and submits the form. Now, you can default form.method to something so that the second drop down will have values in it initially. By the way, this is VERY bad: cfoutput cfif #form.method1# IS 1 /cfoutput This should be: cfif form.method is 1 Notice, no cfoutput is needed. Remember, cfoutput is ONLY necessary when you want the user to see the value of a CF variable. By itself, CF doesn't need it. Ie, you DONT do this: cfset x = 1 cfoutput cfset y = #x# /cfoutput (well, that works, but is unnecessary) This is fine... cfset x = 1 cfset y = x Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 2:25 PM To: CF-Talk Subject: Simple FORM Variable ERROR? Hello, I am trying to create a simple form that depending on which item is selected in one dropdown will determine the contents of the next dropdown fieldit doesnt to recognize my form variable though here is my code: td width=300 *Outreach Method:br select name=OutreachMethod1 option value=--Select One--/option option value=1Telephone/option option value=2Home Visit/option /select /td cfoutput input type=hidden name=method1 value=Form.OutreachMethod1 /cfoutput cfoutput cfif #form.method1# IS 1 /cfoutput So depending on which value from the OutreachMethod1 drop down they choose will determine the cfif code that follows...but it doesnt recognize #form.method1# ...do I need to have 2
cf_twoselectesrelated help!!!!
Hello, thanks for the tips on thisI am trying to get the cf_twoselectsrelated custom tag going but cant seem to get it to work.I downloaded the Custom Tag into my Custom Tag folder and the only changes/additions I made were to the cfparam items where a default value was not already assigned(the first 3 items). Now I get this error: An error occurred while evaluating the expression: MyQuery = Evaluate(Caller.#Attributes.Query#) An error has occurred while processing the expression: Caller. --- do I need to update this custom tag in anyway... also, my cf_twoselectsRelated code is as follows: CF_TwoSelectsRelated QUERY=get_outcome DISPLAY1=Master_Cat DISPLAY2=vcodedecode VALUE1=icodedecodetablenameid VALUE2=icodedecodeid FORCEWIDTH1=70 FORCEWIDTH2=70 SIZE1=1 SIZE2=1 HTMLBETWEEN=BR AUTOSELECTFIRST=Yes EMPTYTEXT1=(choose a category) EMPTYTEXT2=(now choose a subcategory) ONCHANGE=Submit! FORMNAME=MyOtherForm I am sure I am overlooking a few things here...any ideas? Thanks again!!! --- Raymond Camden [EMAIL PROTECTED] wrote: You are correct. Form.method won't be set until the user picks it and submits the form. Now, you can default form.method to something so that the second drop down will have values in it initially. By the way, this is VERY bad: cfoutput cfif #form.method1# IS 1 /cfoutput This should be: cfif form.method is 1 Notice, no cfoutput is needed. Remember, cfoutput is ONLY necessary when you want the user to see the value of a CF variable. By itself, CF doesn't need it. Ie, you DONT do this: cfset x = 1 cfoutput cfset y = #x# /cfoutput (well, that works, but is unnecessary) This is fine... cfset x = 1 cfset y = x === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 2:25 PM To: CF-Talk Subject: Simple FORM Variable ERROR? Hello, I am trying to create a simple form that depending on which item is selected in one dropdown will determine the contents of the next dropdown fieldit doesnt to recognize my form variable though here is my code: td width=300 *Outreach Method:br select name=OutreachMethod1 option value=--Select One--/option option value=1Telephone/option option value=2Home Visit/option /select /td cfoutput input type=hidden name=method1 value=Form.OutreachMethod1 /cfoutput cfoutput cfif #form.method1# IS 1 /cfoutput So depending on which value from the OutreachMethod1 drop down they choose will determine the cfif code that follows...but it doesnt recognize #form.method1# ...do I need to have 2 forms and submit the first part? TIA __ Do You Yahoo!? Send your FREE holiday greetings online! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Simple FORM Variable ERROR?????
Jeff, I have been trying, with no success, to get the cf_twoselectsrelated tag to workcan I take a look at your javascript code and see if that will better do the trickthanks again --- Garza, Jeff [EMAIL PROTECTED] wrote: I don't think CF is what you want to use here... Since it is run server side, what you are attempting to do would require a round trip to the server. Try checking out the TwoSelectsRelated tag at the Allaire Developers Exchange. This should do what you want. Alternately you can roll your own using javascript. I think I have a script from one of my sites that I can send to you if you'd like. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Amanda Stern [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 12:25 PM To: CF-Talk Subject: Simple FORM Variable ERROR? Hello, I am trying to create a simple form that depending on which item is selected in one dropdown will determine the contents of the next dropdown fieldit doesnt to recognize my form variable though here is my code: td width=300 *Outreach Method:br select name=OutreachMethod1 option value=--Select One--/option option value=1Telephone/option option value=2Home Visit/option /select /td cfoutput input type=hidden name=method1 value=Form.OutreachMethod1 /cfoutput cfoutput cfif #form.method1# IS 1 /cfoutput So depending on which value from the OutreachMethod1 drop down they choose will determine the cfif code that follows...but it doesnt recognize #form.method1# ..do I need to have 2 forms and submit the first part? TIA __ Do You Yahoo!? Send your FREE holiday greetings online! __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Simple FORM Variable ERROR?????
Hello, I am trying to create a simple form that depending on which item is selected in one dropdown will determine the contents of the next dropdown fieldit doesnt to recognize my form variable though here is my code: td width=300 *Outreach Method:br select name=OutreachMethod1 option value=--Select One--/option option value=1Telephone/option option value=2Home Visit/option /select /td cfoutput input type=hidden name=method1 value=Form.OutreachMethod1 /cfoutput cfoutput cfif #form.method1# IS 1 /cfoutput So depending on which value from the OutreachMethod1 drop down they choose will determine the cfif code that follows...but it doesnt recognize #form.method1# ...do I need to have 2 forms and submit the first part? TIA __ Do You Yahoo!? Send your FREE holiday greetings online! __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Sys Admin needed in NY area
Hello, I work for a small Non-Profit organization in New York City. We are currently looking for a Sys Admin. We have an NT platform and run a CF application and MS SQL Server 2000. Please email me at [EMAIL PROTECTED] if you are interested in finding out more info. Thanks, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
simple array help - newbie
Hello, I am trying to build an array and cannot get around this error message: The element at position 2 in dimension 1 of object aggdata.AggHours cannot be found. The object has elements in positions 1 through 1. Please, modify the index expression. This is my code for populating the array: cfset Suparray = Arraynew(2) cfloop query=QRYdetail cfset Suparray[CurrentRow][1] = QRYdetail.efirst[CurrentRow] cfset Suparray[CurrentRow][2] = QRYdetail.vSSN[CurrentRow] cfset Suparray[CurrentRow][3] = QRYdetail.TrainDate[Currentrow] cfset Suparray[CurrentRow][4] = QRYdetail.Site[CurrentRow] cfset NADAPSuparray[CurrentRow][5] = QRYdetail.units[CurrentRow] cfset Suparray[CurrentRow][6] = QRYdetail.sFirst[CurrentRow] cfquery name=aggdata datasource=#request.DB# Select ISNULL(Sum(nc.nNumHrs), 0) as AggHours From HospitalLog nc Where cHospitalCodeID =498 and nc.iEmpID = '#QRYnc.iEmpID#' and nc.dDate= '#variables.Fiscal#' and nc.dDate = '#QRYnc.TrainDate#' Group by nc.iEmpID, nc.dDate Order By nc.iEmpID, nc.dDate /cfquery cfset Suparray[CurrentRow][7] = aggdata.AggHours[CurrentRow] /cfloop I am thinking it may have to do with the fact that each iEmpID appears in the HospitalLog table more than once or maybe it has nothing to do with thatam new to arrays and am at a loss as to how to fix this Any ideas? Thanks again for your help!!! ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
heading on every page?
Hello, I have a CF report that is about 15 pages long.how do I get the headings to print on every page? Thanks again! ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL help/group in CFOUTPUT not working??????
hello, I've been working on this query for a while and cant get it to work the way I need it to, i am close though.here is the problem - the cas table is keyed by [iCasacApptID], the cats table has a composite key of [iCasacApptID, cTreatSelectID]. So when I output the results if iCasacApptID is found in the cats table twice, then two records are outputed in my report instead of oneso, if there are 2 TreatSelects to one CasacApptID, then I want that to be one row..I though that table cfoutput tr td#QRYtp.TreatSelect#/td /tr /cfoutput /table would accomplish thisbut it isnt. here is my code belowcan anyone see what I am missing... Thanks yet again! cfloop query=treatCount cfif treatcount.TreatCount gt 6 cfquery name=QRYtp datatasource=#DB# Select cas.iClientID , cd1.vCodeDecode as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA From CasacAppt cas, CasacApptTreatSelect cats, CodeDecode cd1 Where '#treatCount.TreatProgID#' = cas.iTreatProgID and cas.iCasacApptID = cats.iCasacApptID AND cats.cTreatSelectID = cd1.icodedecodeID AND cas.dCasacDate = '#variables.DBeginDate#' AND cas.dCasacDate = '#variables.dEndDate#' AND cas.iCasacApptID in (select cs.icasacApptID from CasacApptTreatSelect cs) Union Select cas.iClientID , 'None' as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA From CasacAppt cas, CodeDecode cd1, Client cl Where cas.iClientID = cl.iClientID AND '#treatCount.TreatProgID#' = cas.iTreatProgID AND cas.dCasacDate = '#variables.DBeginDate#' AND cas.dCasacDate = '#variables.dEndDate#' AND cas.iCasacApptID not in (select cs.icasacApptID from CasacApptTreatSelect cs) /cfquery table align=center border=1 width=650 tr cfoutput query=QRYtp group=iCasacApptID td#QRYtp.iCasacApptID#/td td#QRYtp.TrueProg#/td td#QRYtp.iClientID#/td TD table cfoutput tr td#QRYtp.TreatSelect#/td /tr /cfoutput /table /TD /tr/cfoutput /table/cfif /cfloop ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL help/group in CFOUTPUT not working??????
hello, I've been working on this query for a while and cant get it to work the way I need it to, i am close though.here is the problem - the cas table is keyed by [iCasacApptID], the cats table has a composite key of [iCasacApptID, cTreatSelectID]. So when I output the results if iCasacApptID is found in the cats table twice, then two records are outputed in my report instead of oneso, if there are 2 TreatSelects to one CasacApptID, then I want that to be one row..I though that table cfoutput tr td#QRYtp.TreatSelect#/td /tr /cfoutput /table would accomplish thisbut it isnt. here is my code belowcan anyone see what I am missing... Thanks yet again! cfloop query=treatCount cfif treatcount.TreatCount gt 6 cfquery name=QRYtp datatasource=#DB# Select cas.iClientID , cd1.vCodeDecode as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA From CasacAppt cas, CasacApptTreatSelect cats, CodeDecode cd1 Where '#treatCount.TreatProgID#' = cas.iTreatProgID and cas.iCasacApptID = cats.iCasacApptID AND cats.cTreatSelectID = cd1.icodedecodeID AND cas.dCasacDate = '#variables.DBeginDate#' AND cas.dCasacDate = '#variables.dEndDate#' AND cas.iCasacApptID in (select cs.icasacApptID from CasacApptTreatSelect cs) Union Select cas.iClientID , 'None' as TreatSelect, cas.iCasacApptID, '#treatCount.TreatProgID#' as TrueProgID, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA From CasacAppt cas, CodeDecode cd1, Client cl Where cas.iClientID = cl.iClientID AND '#treatCount.TreatProgID#' = cas.iTreatProgID AND cas.dCasacDate = '#variables.DBeginDate#' AND cas.dCasacDate = '#variables.dEndDate#' AND cas.iCasacApptID not in (select cs.icasacApptID from CasacApptTreatSelect cs) /cfquery table align=center border=1 width=650 tr cfoutput query=QRYtp group=iCasacApptID td#QRYtp.iCasacApptID#/td td#QRYtp.TrueProg#/td td#QRYtp.iClientID#/td TD table cfoutput tr td#QRYtp.TreatSelect#/td /tr /cfoutput /table /TD /tr/cfoutput /table/cfif /cfloop ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cf in Select Stmt help
Hello, I am trying to get this query to work and not sure how...anyone have any ideas? The problem is in the joining of the cas table and the cats tablethere is a 0 to many relationship between these tablesie[cas.iCasacApptID = cats.iCasacApptID] many never equal each other because there may not be an iCasacApptID in the cats table. If thats the case then I want the word None as my cats.cTreatSelectID. is there a way I can put a cfif statement around that join..if so how..or is there a simplier way I am not thinking of Thanks again for the help! cfquery name=QRYtp datasource=#request.projectAceDb# cfloop query=treatCount cfif treatcount.TreatCount gt 6 Select cas.iClientID , cd1.vCodeDecode as TreatSelect, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA From CasacAppt cas, CasacApptTreatSelect cats, TreatmentProg tp, CodeDecode cd1, Client cl Where cas.iClientID = cl.iClientID AND '#treatCount.TreatProgID#' = cas.iTreatProgID AND cas.iCasacApptID = cats.iCasacApptID AND cats.cTreatSelectID = cd1.icodedecodeID AND cas.dCasacDate = '#variables.stFieldNames.DBeginDate#' AND cas.dCasacDate = '#variables.stFieldNames.dEndDate#' AND cas.dCasacDate '#request.dContractDate#' /cfif /cfloop /cfquery ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cf in select stmt help -Works - THANKS
Thank you!! That did the trick. --- Deanna Schneider [EMAIL PROTECTED] wrote: Whew! This is an interesting query, Amanda. There are a couple of issues here. Your loop should be outside the query, otherwise what you'll end up with is multiple select statements within the query. My guess is that's not really what you're after. As to the other issue, you need to use an outer join, so that if there is no value in the joined table, you still receive a record. I think you're trying to do something like this: cfloop query=treatCount cfif treatcount.TreatCount gt 6 cfquery name=QRYtp datasource=#request.projectAceDb# Select cas.iClientID , cd1.vCodeDecode as TreatSelect, '#treatCount.TreatProg#' as TrueProg, '#treatCount.HRACode#' as TrueHRA From (CasacAppt cas LEFT OUTER JOIN CasacApptTreatSelect cats ON cats.icasacapptid = cas.icasacapptid), TreatmentProg tp, CodeDecode cd1, Client cl Where cas.iClientID = cl.iClientID AND '#treatCount.TreatProgID#' = cas.iTreatProgID AND cats.cTreatSelectID = cd1.icodedecodeID AND cas.dCasacDate = '#variables.stFieldNames.DBeginDate#' AND cas.dCasacDate = '#variables.stFieldNames.dEndDate#' AND cas.dCasacDate '#request.dContractDate#' /cfquery /cfif /cfloop There are going to be some issues with your other tables, as I don't know the relationships there, and I always have to play with the database query builder in Access (I'm assuming this is access). I'm better at writing sql for oracle, but this should get you started. Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ahh....help with rpt grouping troubles
Hello, I am having trouble fixing this report and I am quite new to CFgetting a bit frustrated... my report should look something like this: (the problem is that the numbers for Recipient are in the Neither column and the numbers for the Neither are in the Recipient column. Applicant is fine. I know this should be simple to fix but I cant seem to get itany ideas as to why) Applicant Recipient Neither Treatments Types New Treatment Incomplete 1 3 0 Complete0 1 1 Old Treatment Incomplete 5 1 1 Complete1 2 2 the CF code is: cfoutput query=QRYTreatment group=TreatmentTypes tr td#QRYTreatment.TreatmentTypes#/td /tr cfoutput group=CompIncomp tr tdnbsp;#QRYTreatment.CompIncomp#/td cfset variables.intTreatTotal = 0 cfoutput cfset variables.intTreatTotal = variables.intTreatTotal + QRYTreatment.CountTotal td#QRYTreatment.CountTotal#/td /cfoutput /td /tr /cfoutput /tr /cfoutput ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: NY Fast Track to Cold Fusion Classes???
www.winmill.com --- Joshua Miller [EMAIL PROTECTED] wrote: Anyone know of a reputable organization in the NY area that we could send some developers to for FastTrack and possibly Advanced CF and SQL training? Thanks! Joshua Miller Web Development - Eagle Technologies Group Business Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
legal question?????
Hello, Not sure if anyone can answer this question/concern for me but will ask anyways.I have been creating some reports for HR that will be used internally to keep track of our employees work(ie number of items completed, average numbers etc). One of the averages I am being asked to report will be a very skewed number and I am concerned because these averages are used to grade employees. People have been let go over these numbers. Bottom line is, I do not want to have any numbers on my report that I already know are skewed. I expressed my concern to my employer and they agreed that the numbers will be off but they want it anyways and they say they will take that into consideration. Am I in anyway liable or am I being paranoid??? :) Thanks, ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Time Difference Function - newbie!!!!!
Hello again! I am having some trouble calculating the time difference for two datetime field2 which I then try and add togetherhere is what I have done: My SQL Stmt: Select DateDiff(mi, dApptEndTime, dApptBeginTime) as Diff1, DateDiff(mi, dApptEndTime2, dApptBeginTime2) as Diff2, cas.icasacapptID, cas.dApptBeginTime as BeginTime, cas.dApptEndTime as EndTime, cas.dApptBeginTime2 as BeginTime2, cas.dApptEndTime2 as EndTime2, 'None' as TimeCode, cli.iclientID,etc then later in the code I do a cfset: cfset variables.TimeDifference = CasacActivity.Diff1 + QRYCasacActivity.Diff2 I get an error stating that it cannot convert to number.. How can I get around this? Thanks a million!!! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Cold Fusion Developer - beginner
Hello, Does anyone know of any open Cold Fusion positions available in the Austin TX or Houston TX area requiring about 1 year of experience? Thanks! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
