Determine if PDF previously flattened
We have a process where some PDFs are flattened and some are not. They'll be flattened later. We use cfpdf for this. Is there a test that we can do to determine if a PDF has been flattened already? Currently we're trying to insert a watermark and if it fails, we suspect it's been flattened. However, I'd like a real test, like a function call that can determine it. All my searches for flatten or flattened right now bring back links to how to flatten or was is flattening. Anyone know of a way to tell, outside of using failure as a tool? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360191 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Determine if PDF previously flattened
Also, I should have said that we are on CF9 for this. thank you. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam to varchar raw problem
I found that if I decouple the encrypt_column from the insert script by requesting it from dual first, that it then works fine. While I would prefer to do it without a two-step process, this works fine for now. cfquery name=qInsertF9099AlienInfo_prep datasource=#application.dbDataSource# select Encrypt_Column(RPAD(UPPER(NVL(cfqueryparam cfsqltype=cf_sql_varchar value=#arguments.inStruct.a_alien_last_name#,' ')),56,' '),'CFASJAAAEPTSKEJPI') as a_alien_ln from dual /cfquery cfquery name=qInsertF9099AlienInfo datasource=#application.dbDataSource# INSERT INTO F9099_ALIEN_INFO( F9099_id, alien_last_name ) VALUES ( cfqueryparam cfsqltype=cf_sql_INTEGER value=#arguments.inStruct.l_F9099_id#, cfqueryparam cfsqltype=CF_SQL_VARBINARY value=#qInsertF9099AlienInfo_prep.a_alien_ln# ) /cfquery ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam to varchar raw problem
I suspect you have a charset mismatch. What is the DB charset, CF charset and what is the setting for sending cfqueryparams as Unicode? Our Oracle 11g displays âAL16UTF16â as the char set. PERM is UTF-8 However encrypt_column is returning a binary and it's going into a RAW field. So should that matter then? I've done some further experiments that seem to exonerate encrypt_column and I'll comment on those below. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam to varchar raw problem
I did an experiment, calling ENCRYPT_COLUMN without doing the INSERT. I ran it 300 times and it didn't fail once. cfloop index = x from = 1 to = 300 cfquery name=qInsertF9099AlienInfo datasource=#application.dbDataSource# select Encrypt_Column(RPAD(UPPER(NVL(cfqueryparam cfsqltype=cf_sql_varchar value=#a_alien_last_name#,' ')),56,' '),'CFASJAAAEPTSKEJPI') as my_test from dual /cfquery cfoutput#x#:/cfoutput cfdump var = #qInsertF9099AlienInfo.my_test# !--- cfoutputploop = #x#:#qInsertF9099AlienInfo.my_test#/p/cfoutput --- /cfloop However, I couldn't output the data directly since it's binary (CF said NO!), so I did a dump and that was fine. Since ENCRYPT_COLUMN didn't fail once, I'm led to believe that the problem is that the actual INSERT has problems with the data returned or it has problems transmitting the returned data properly. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam to varchar raw problem
Here is the code, simplified somewhat. This is the INSERT. The a_alien_last_name goes into a RAW (56bytes) field. It used to go into a VARCHAR. Following this is the ENCRYPT_COLUMN function in Oracle that is called in the INSERT. CFSET a_alien_last_name = '' cfquery name=qInsertF9099AlienInfo datasource=#application.dbDataSource# INSERT INTO F9089_ALIEN_INFO ( F9089_id, alien_last_name ) VALUES ( cfqueryparam cfsqltype=cf_sql_INTEGER value=#arguments.inStruct.l_F9099_id#, Encrypt_Column(RPAD(UPPER(NVL(cfqueryparam cfsqltype=cf_sql_varchar value=#a_alien_last_name#,' ')),56,' '),'CFASJAAAEPTSKEJPI')) /cfquery encrypt_column in Oracle: CREATE OR REPLACE function encrypt_column (input_string in varchar2, key_string in varchar2) return raw is encrypted_string RAW(2048); begin if input_string is NULL then return NULL; else encrypted_string:=dbms_obfuscation_toolkit.DES3Encrypt(input = UTL_RAW.CAST_TO_RAW(input_string), key = UTL_RAW.CAST_TO_RAW(key_string)); return (encrypted_string); end if; end; ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam to varchar raw problem
I'll ask about this. I have to wait for the dba to come in. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam to varchar raw problem
Previously the encrypt_column was going to a varchar, so it didn't need to do any of the RAW stuff. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358676 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfqueryparam to varchar raw problem
I may be outside of the CF bounds here, but this problem wasn't showing up until we added CFQueryParams. We are in CF9. I am adding CFQueryparams to an INSERT. The item that I am sending over to the oracle 11g db is empty text. The CFQueryParam is varchar because I am sending it over as text. From there, it is encrypted and a Cast_to_RAW is done on it to be put in a RAW field. This is failing with an invalid hex number error. Overall, I don't receive the error consistently. However, I haven't been able to reproduce this without the CFQueryparam. Any thoughts on this? Or any clarification questions? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfpdf import an image into a pdf
I am working on CF9 and I am making a pdf. We did this in CF7, but it's much different in CF9. I have a signature that certifies my document and it's in .gif form. I need to import that into the pdf right where a form field goes. I have CFSET image = expandpath(images\A_CO_Signature.gif) cfpdfformparam name=CO_Signature value=#image# But that puts the image path into the field, not the image. A coworker friend told me that it can be done a particular way, but I'd like to know if that's the best way or the standard way of getting this done. cfpdf action=addwatermark image=signature.jpg opacity=10 position=75,265 source=#variables.mainPDF# pages=6 foreground=yes destination=#variables.finalPDF# showonprint=true overwrite=true thank you for your time and replies. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357428 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF7 to CF9 timeout issues
We are trying to migrate from CF7 to CF9. We are receiving many timeout errors (500 internal server error. The request has exceeded the allowable time limit Tag: CFQUERY). We do not receive these errors on the CF7 server. They both point to the same database. The Oracle Views that are timing out are quite long. So we saw this as an opportunity to tune those queries.They are tuned and we saved about 70% of the time it takes to run them. Still, they time out on the CF9 server and not the CF7 server. We changed the SETTINGS - TIMEOUT REQUESTS AFTER to 190 seconds to match our Production server (where it does NOT time out). Still it is timing out. Oddly, the timeout times are longer than the 190 seconds. However, there would be much political grief if I just upped the timeout limit, especially since it works fine on the CF7 server. CF7 time it takes to load page - 293 seconds and does not time out CF9 time it takes to load page - 221 seconds and times out Both these are with the much more efficent queries/views. So why does it time out on CF9 and not CF7 or rather, what do I need to do to correct this and make it work like CF7? Secondly, why does it run past the 190 seconds anyway? I'm more just curious on this one, but maybe it will help me understand to I can determine a cure. - The only other setting that I see that might apply is: REQUEST TUNING - Timeout Requests waiting in queue after N seconds. This N is currently set to the default of 60 where it says it should be the same as the Timeout Request setting. I can have them change this but I need to know that it is the correct change to make. Do you think that this is the problem? If not, or even if so, do you have any other recommendations, especially server recommendations? I'm pretty much at a loss at this point. We don't have direct access to the servers and when we ask for changes to the system, that takes a few days to enact them, so I need to be pretty sure that I am asking them to do something that will make an impact - without a lot of back and forth of (try this, oh, and try this, oh...) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
No directory deletion after cfcontent
I am on CF9. I am making a temp folder and putting pdfs in it. Then I do a
merge.
Afterwards, I do a CFContent to view the pdf. Then I do a cfdirectory, get a
list of the Directories and delete any directories over an hour old. This is
not working.
If I comment out the cfcontent, it works fine and all is well. Put the
cfcontent back in and my directories are left. Some of these directories are
days old, so there is no active/open content in them. To assure this, I still
create the directories for the pdfs to merge, but I output it and view it in
the parent directory, so deleting these directories should be simple.
If I move the directory deletion BEFORE the cfcontet tag, then it deletes them
fine, but that's not where I need them to be.
So here's the code, but there is a directory created with a unique name (e.g.
Z-13221-503881377293800337) before this and stuffed with pdfs.
CFCONTENT type=application/pdf file=#view_file# deletefile=yes!---
---
!--- delete currently used dir ---
cfdirectory action=delete directory=#output_path# recurse=yes
cfdirectory action=list name=pdf_dir_listing directory=#directory_path#
after 1 folder deletebr
cfdump var=#pdf_dir_listing#
cfloop query=pdf_dir_listing
cfset the_mod_date = ParseDateTime(datelastmodified)
cfif DateDiff('n',the_mod_date,now()) gt 60 !--- more than 1 hr old ---
cfif DirectoryExists(tmp_path)
cfdirectory action=delete directory=#tmp_path# recurse=yes
/cfif
/cfif
/cfloop
after many folder deletebr
cfdirectory action=list name=pdf_dir_listing
directory=#directory_path# cfdump var=#pdf_dir_listing#
The paths are fine because this works without the cfcontent.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356554
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: pdf COM object
Thanks. I actually did read the manual before posting. I appreciate the assistance. Here's a reference for merging PDF files with CF9: http://help.adobe.com/en_US/ColdFusion/9. 0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-798f.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
pdf COM object
We are moving from cf7 to cf9 and because of that, we can no longer use COM objects. I've replaced most of the code with cf9 calls, but I cannot do so with CopyForm, which copies pages of the form. Here is an example: CFSET r = PDF.CopyForm(14,14) http://www.activepdf.com/AltDownloads/Documentation/TK2011/CopyForm.html Can cannot have a separate server for COM objects. Can anyone recommend a path for correcting this? I don't know the cf pdf calls well. Is there a replacemnt for this within cf9? thank you. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
pdf.com object CopyForm
We use the COM object to update fields in our PDF. However, since we are going from CF7 to CF9, we are no longer able to use COM objects. I have been able to replace most of the calls, but we use the COM object call 'copyForm', which copies pages of the pdf and reinserts it into the same pdf. For example: CFSET r = PDF.CopyForm(14,14) http://www.activepdf.com/AltDownloads/Documentation/TK2011/CopyForm.html Can anyone recommend a method for replacing this call? My first thought is to have PDFs of the section that I want to copy and then merge them in. That's a heavy rewrite. Is there simply a CF call that I don't yet know that does the same thing as copyForm? thank you. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
pdf COM object
We are moving from cf7 to cf9 and because of that, we can no longer use COM objects. I've replaced most of the code with cf9 calls, but I cannot do so with CopyForm, which copies pages of the form. Here is an example: CFSET r = PDF.CopyForm(14,14) http://www.activepdf.com/AltDownloads/Documentation/TK2011/CopyForm.html Can cannot have a separate server for COM objects. Can anyone recommend a path for correcting this? I don't know the cf pdf calls well. Is there a replacemnt for this within cf9? thank you. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356428 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: now( ) is off by an hour
Updating to JVM 1.6 worked great. Thank you all very much for your assistance. You've been a great help. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355037 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
now( ) is off by an hour
I am working on an application that does it's own timeout, at 45 minutes. It gets the last logged in time and compares it to the database current time. The database time is correct. However, the now() time is incorrect by an hour. I assume this is due to daylight savings time. So where does now() get it's time? I'm on a VPN and that has the correct time when I check it's clock. Would it then be the server that hosts the VPN? Or someplace else? thank you. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: now( ) is off by an hour
It's a localhost CFServer (developer mode). That is on a VPN that I am using. The VPN has the correct time. However the now() is incorrect. It was correct until daylight savings time. At this point, I assume that it's getting the time from the machine that is hosting the VPN, which means that the VPN can have a different time. However since I don't know where now() gets it's time, I can't get any traction on this from our support staff. Check the date and time on the ColdFusion server. Also, make sure that your DB server and ColdFusion server are in the same time zone. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354935 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: now( ) is off by an hour
Thanks bobby. I can only see the VPN OS, not the computer that serves up the VPN. It sounds like I should ask them to check that server's time. thank you. It doesn't get its time form the VPN, it gets its time from the host machine running the CF service. Clock in the bottom right corner of windows has the time that the CF server would use. If, for some reason, you've hidden the clock, cmd.exe echo %time% Your windows timezone could be off or you don't have the option set to adjust for daylight savings time. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354938 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: now( ) is off by an hour
I get: JRE:=Java(TM) 2 Runtime Environment, Standard Edition 1.4.2_09-b05 tz:=Eastern Daylight Time dst savings:=1 uses DST: YES in DST now: NO I saw that there is an update to 1.4.2_11, but that came out around 2007 I think. So I would need a more recent update. A coworker said that she updated her jvm and still sees the error. However, I'm waiting for her to come in to work and run this script that you gave me. Maybe it gives some different info. When it says in dst now, that means that JVM thinks it's not in DST or that the computer does not think it's in DST? script jre=createObject(java,java.lang.System); JREname=jre.getProperty(java.runtime.name); JREversion=jre.getProperty(java.runtime.version); tz=createObject(java,java.util.TimeZone).getDefault(); tzName=tz.getDisplayName(true,tz.LONG); dstSavings=tz.getDSTSavings()/360; writeoutput(JRE:=#JREname# #JREversion#br tz:=#tzName#brdst savings:=#dstSavings#br uses DST: #tz.useDaylightTime()#br in DST now: #tz.inDaylightTime(now())#); /cfscript ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354939 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: now( ) is off by an hour
I've been using the term VPN when I meant VM (virtual machine). Sorry about any confusion and thank you all for your help so far. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
convert to cfqueryparam
I have a line of Oracle pl/sql (9i) where I'm trying to add cfqueryparam in CF7. I have: #iif(len(trim(arguments.inStruct.a_person_id))eq 0,DE(NULL),DE(#arguments.inStruct.a_person_id#))#, a coworker suggested: cfqueryparam value = #arguments.inStruct.a_person_id# CFSQLType = CF_SQL_NUMERIC null=#IIF(len(arguments.inStruct.a_person_id),0,1)# But in reviewing it, I cannot tell if that is correct or not. I've gone over the sql several times. Also, I don't know DE(). Any information on this is welcome. Thank you. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: convert to cfqueryparam
Ah I understand. Great, thank you. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352380 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Not instantiating object
ah that worked! Thank you. And thanks everyone for your assistance. Java classes don't use or require mappings. They need to be specified in your JVM's CLASSPATH. If you're using CF Standard, you can add directories to the classpath in the Java and JVM menu of your CF Administrator. If you're using CF Enterprise, you may have to edit the jvm.config directly. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351237 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Not instantiating object
hi, same person here. I am trying to migrate this to another server. However, I cannot read my old CF7 settings. I have a java folder with classes in it that are used by the project. The java folder is at c:/java. I recall that I need to update the Coldfusion Administrator so that these classes can be used. However, I can not determine where I should update these. I did this in the mappings section. My logical path is set to /java and my directory path is set to c:/java. I've been banging my head against this for at least two days. Can someone please tell me how to get these classes working? thank you. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Not instantiating object
it is probably easier if you justr put then in one of the existing paths rather than add a new one c:\coldfusion9\runtime\lib I'll try that to get by, but I need to duplicate the production environment. It's difficult to update these settings? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Migrate back and forth between cf7 and cf8 on IIS
I should begin this by saying that I am not a server admin by any means and I am a novice at IIS. I've been on CF7 for my app for the past year. I have the developer cf7 installed on the IIS on XP. It's been working great as my localHost. I've now been given a site that is on CF8. I've chosen to not have the two servers run at the same time if I can stop one and restart the other. So I installed CF8, changed my Home directory in IIS, stopped the cf7 services, restarted the server and it went to CF8 fine. I had a problem returning to CF7. I switched the home directory in IIS, disabled cf8 services, enabled cf7 services, restarted the IIS server. I now receive the error on localHost of Could not connect to JRun Server. I don't know what to do next. Any thoughts? In the end, I need a process for switching between the two setups. thank you. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrate back and forth between cf7 and cf8 on IIS
What services are running? They're the CF ones that are installed. For cf7: ColdFusion MX 7 Application Server ColdFusion MX 7 ODBC Agent ColdFusion MX 7 Search Server For cf8: ColdFusion 8 .NET Service ColdFusion 8 Application Server ColdFusion 8 ODBC Agent ColdFusion 8 ODBC Server At the moment, since I intend to have CF7 running, it's the first set. Otherwise, my machine is pretty generic. Did I answer the question? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrate back and forth between cf7 and cf8 on IIS
What services are running? On Mar 9, 2012 11:47 AM, daniel kessler dani...@umd.edu wrote: In going through my web site configuration - application configuration, I see a bunch of paths that go through ColdFusion8 and end with jrun.dll. Could this be the problem? Will I need to delete these and import the cf7 ones each time I switch? oy. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrate back and forth between cf7 and cf8 on IIS
Check your services for jrun... You may need to copy your web inf over On Mar 9, 2012 11:51 AM, daniel kessler dani...@umd.edu wrote: I didn't see a service that started with the term jrun. i don't think that I see any with jrun in the name anywhere. I do see a Java Quick Starter. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrate back and forth between cf7 and cf8 on IIS
Just set the ISAPI paths at the website level for the CF7 site to point to your CF7 install directory (specifically at the jrun dll's).. ok, that worked. Thank you very much. Is that the sort of thing that can be adjusted using a .bat file? I don't know much about them. However, I'm trying to make switching between these two environments as easy as possible. I appreciate the assistance everyone. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350320 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrate back and forth between cf7 and cf8 on IIS
why not just setup separate sites and set each site to use the appropriate cf version instead of keep switching one site between different home directories and cf version ? It's my understanding that the IIS can only do one site (I'm in XP). To do more, I have to buy the IIS Server. Please correct me and tell me that I am wrong. Please! As I said, I'm a novice with IIS. However, I couldn't find a new site button. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Migrate back and forth between cf7 and cf8 on IIS
thank you Andrew; I'll read that. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
instance of a cfm
I'm in CF7. I'm trying to determine where in my interface a .cfm may be referenced. The interface is very, very complicated with many pages and sections, so rooting through it isn't a good solution. I have queries that references a table that I updated. I know the files that references this table. Some of those files are .cfm files. In searching for these, I find now blah.cfm file. If it were an instance, I would look for blah. To assure that I only need to look for blah.cfm I have the question, can .cfm files be birthed into instances? Was this too long an explanation for a simple question? thank you for your knowledge. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: instance of a cfm
I don't think it was too long. However, I don't really understand the question at all. What do you mean by instances, or interface in this context? For instance, I mean something like: request.oExistCheck = createObject(component,cfc.ExistCheck); Note that if I searched for ExistCheck.cfc, this would not be found. So I must search for ExistCheck, which will give me many, many returns. As for Interface, I mean a web page, which each page has many includes, modules, instances and references many scopes of variables. In this case, it has tabs and many pages within tabs to get at information. It's impractical to root through that convoluted interface to find something (we have the cf debugger ON). If I can assure that .cfm files can not be birthed into instances and that only cfc can be birthed into instances, then I can eliminate .cfm files from my search. I'm really lost on finding where these table queries are enacted on the interface and have been at it for four days, just to be able to tell our QA people where to test. thank you for listening. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: instance of a cfm
the code you gave is for instantiating a CFC (ColdFusion component) and only applies to a .cfc file, you cannot do this with a .cfm files as no extension is given, a .cfc extension is thus implicitly implied. so this wouldn't work then: request.oExistCheck = createObject(component,cfm.ExistCheck); ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: instance of a cfm
this would create an instance of ExistCheck, using the file cfc/ExistCheck.cfc, meaning that wherever this line of code is, there would need to be a subdirectory called cfc, with a file called ExistCheck.cfc in it. You can only create instances from CFCs, though. Great explanation. Thank you very much both of you. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349892 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
you have cf_abort in your code instead of cf_abort() I am using cf_abort. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
Looks like the issue is that you have the cf_dump() and cf_abort() calls outside of the curly braces. ok, that's a thought that I hadn't considered. I moved them inside the brackets and now I don't receive an error. Thank you! Unfortunately, I also don't receive the dump or the abort. I even built an array to dump to simplify the test and assure that there's dumpable data. sigh I guess I'm just not used to this. Maybe the logs will reveal what happened. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
Unfortunately, I also don't receive the dump or the abort. I even built an array to dump to simplify the test and assure that there's dumpable data. sigh I guess I'm just not used to this. Maybe the logs will reveal what happened. ok, it looks like the cf_dump() is working. If I put a cfabort inside it's function. I tried following the cf_dump() with a cf_abort for it's own function, but that didn't do the abort and I didn't see the dump (which should even display without the abort), but once I put the cfabort inside the cf_dump function, I saw the output. thank you everyone for your help. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349848 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
I added this to my component, but I'm getting an error while calling it from within the component. cfcomponent hint=Replaces The Package PK_employer cffunction name=cf_abort output=false returntype=void cfabort / /cffunction cffunction name=cf_dump output=false returntype=void cfargument name=objToDump type=any required=false default= / cfdump var=#arguments.objToDump# / /cffunction Then further down, I call the cf_dump, like cf_dump(dbResult); How do I implement this correctly? Thank you for your assistance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349835 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
To clarify, I receive an error when these function calls are used and no error
when they're commented out.
---
Invalid CFML construct found on line 78 at column 33.
ColdFusion was looking at the following text:
else
The CFML compiler was processing:
a script statement beginning with { on line 63, column 39.
a script statement beginning with if on line 63, column 17.
a cfscript tag beginning on line 52, column 18.
a cfscript tag beginning on line 52, column 18.
The error occurred in C:\localServer\beatch\cfc\emp.cfc: line 78
76 : //cf_dump(dbResult);
77 : cf_abort;
78 :else
79 :request.inStruct.beatch_id = ;
80 :
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349836
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
First off, this is a nearly 4 year old thread. It may or may not apply to what you're working on now. What CFML engine and version are you using? What is the relevant code? I didn't think reposting was a good idea, since there was a thread with a relevant history. I'm using CF7. I posted the relevant code: part of the component, the cfabort/dump code, and my call. Is there more code that you would like? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging in cfscript
The error code mentions Line 63 as the start of an if () statement, and
Line 52 as the start of the cfscript tag. We'll need probably the entire
if () block at the least, as it would seem the issue lies in there.
Hard to speculate based solely upon the error message, as CF is notorious
for providing rather cryptic error messages which often send one off
chasing ghosts.
In this case, it is reporting loosely. If I comment out the cf_abort, there is
no error. So it has a problem with the cf_abort. That being a problem, messes
with the next line, the else. Since the else is part of the IF, it complains
about the whole IF. Really, it's complaining about the cf_abort, like it
doesn't know what it is.
However, the IF is several hundred lines long. Here's the relevant part up to
the 'else' that works fine with the cf_abort commented out:
if (len(arguments.inStruct.a_agent_first_name) gt 0 OR
len(arguments.inStruct.a_agent_middle_initial) gt 0 OR
len(arguments.inStruct.a_agent_last_name) gt 0 OR
len(arguments.inStruct.a_agent_firm_ein) gt
0 OR len(arguments.inStruct.a_agent_firm_name) gt 0 OR
len(arguments.inStruct.a_agent_phone) gt 0 OR
len(arguments.inStruct.a_agent_phone_ext) gt
0 OR len(arguments.inStruct.a_agent_address_1) gt 0 OR
len(arguments.inStruct.a_agent_address_2) gt 0 OR
len(arguments.inStruct.a_agent_city) gt 0 OR
len(arguments.inStruct.a_agent_state_id) gt 0 OR
len(arguments.inStruct.a_agent_province) gt 0 OR
len(arguments.inStruct.a_agent_country_id)
gt 0 OR len(arguments.inStruct.a_agent_postal_code) gt 0 OR
len(arguments.inStruct.a_agent_email) gt 0)
{
dbResult =
request.oEmployer.Ins_Agent_Tbl(arguments.inStruct);
if (dbResult eq 0,)
request.inStruct.l_agent_id =
listGetAt(dbResult,2);
else
request.inStruct.l_agent_id =
;
}
//cf_dump(dbResult);
cf_abort;
else
request.inStruct.l_agent_id = ;
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349840
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
COM error
I'm receiving this error: An exception occurred when instantiating a Com object. The cause of this exception was that: java.lang.RuntimeException: Can not use native code: Initialisation failed. The code making the call is here: CFOBJECT action=Create type=COM class=APToolkit.Object name=PDF This has been working fine for several months and suddenly we're getting this error when we try and build a pdf through code. It's not actually getting to the point where it builds the PDF since it's receiving an error when it tries to initialize the COM. I'd like some pointers, leads on investigating this please. I'm googling now, but it's bringing up all sorts of ways to use this rather than when it fails. thank you. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: COM error
Oh, btw it's in CF7. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345971 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: COM error
When was the last time you fully re-booted the server? I don't know. The server is in another part of the country. This morning, we asked them to restart it, though I've not received a reply. So we are going to try that method. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345973 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: loop timing out
Any chance the looping couple be done in a stored proc? No, it's calling a page and that page is full of CF. However, I've decided to just do 5 at a time and reload the page. It seems to be working fine. Thank you everyone for your help. When I move to an app on CF8 or CF9, I'll look further into CFThread. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345920 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: loop timing out
What about running the task in a cfthread? I have some tasks that run on a schedule (or manually triggered) for an hour or two without issue... It sounds interesting, but from my checking, it doesn't appear to be a CF7 tag. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345822 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: loop timing out
Setting up a 'grouped' plan to only run x of them is a valid
assessment, but I would suggest that you do this by tracking which
ones need to be redone outside of the page.
An example would be, you could have each of the necessary redone's to
show up in a database table, and mark them as completed once they are
done. The you would just need to pull the oldest 5 of them each time
you load the page. (this would mean the page would have to be loaded
more often.
There isn't much to the page with the loop. It's mainly a db call and then I
do the loop based on that, over the page that has the db calls. While I can
see the db page (it has 12 database INSERTs or UPDATEs), I can't alter it, so
no use in posting that.
I thought last night that a way to do sets of five is similar to your
suggestion. I could run the page, having it do just 5 as you suggest. Then I
could have the page reload itself with a cflocation and have it then do the
next 5. That gives time for other processes to be called in between. I could
have the page count up and send the count through the URL and do a certain
number of reloads before it's done for awhile. Then the next time the schedule
comes up, it can go through more of the set. Right now there's a buildup of
records to be worked through. As it cleans up, I would only expect it to have
less than 5 each time it runs.
Here's the loop code:
CFQUERY name=qry_stuck datasource=#application.dbDataSource#
dbtype=#application.dbType#
SELECT f.g_id
FROM g f, case_event ce, spnshp_check sc
WHERE f.g_id = ce.g_id
AND f.g_id = sc.g_id
AND f.status_id = 3
AND ce.locked_by_id IS NULL
AND sc.spnshp_chk_type = 'A'
AND sc.on_your_behalf IS NOT NULL
/CFQUERY
cfloop query=qry_stuck_in_spnshp
CFQUERY NAME=qryEmpInfo DATASOURCE=#application.dbDataSource#
DBTYPE=#application.dbType#
SELECT g.employer_info_id, ei.employer_id, ei.agent_id, g.case_no
case_no,
g.office_location_id, g.Status_ID,
TO_CHAR(g.submitted_date,'mm/dd/') date_received,
ei.address_1 employer_address1, ei.address_2 employer_address2,
ei.Name employer_name,
ei.City employer_city, ei.State_Id employer_state_id, ei.State_Id
employer_state,
s.code employer_state_code, ei.Postal_Code employer_zip,
ei.province employer_province,
ei.country_id employer_country_id,c.name employer_country_name,
substr(ei.postal_code,1,5) employer_postal_code1,
substr(ei.postal_code,7,4) employer_postal_code2, ei.Phone
employer_phone, ei.Phone_Ext employer_phone_ext
FROM g, EMPLOYER_INFO ei, state s, country c
WHERE g.g_id = #g_id# AND g.Employer_Info_Id =
ei.Employer_Info_Id
and ei.state_id = s.state_id(+) and ei.country_id = c.country_id(+)
/CFQUERY
CFLOOP INDEX=x LIST=#qryEmpInfo.ColumnList#CFSET
#x#=#evaluate('qryEmpInfo.' x)#/CFLOOP
cfinclude template=/insert_spnshp_inc.cfm
/cfloop
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345823
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
loop timing out
I'm creating a scheduled_task to correct a problem. For the correction, I'm doing a query for the list of problem records. Then I'm looping through the problem records and resending each one of them through the same code that it went through when it developed the problem. That code has several database updates. Unfortunately, I'm timing out of the cfloop. I don't have access to the page that I'm looping through, so I can't change it. Is there a way to let a loop have other transactions so that it doesn't time out? I thought of putting the loop in another loop, so that it only does 5 at a time, but then that's just a loop in a loop and then the outer one will time out. Did I state this clearly? A friend of mine suggested the line: cfsetting requestTimeOut = 120â I am told that this setting will only be persistent for that page and that the timeout will revert to it's previous setting once the page is done running. Is that correct? I was also concerned that when CF is upgraded (we're on CF7 for this app) that this setting might be trouble. Any thoughts? Overall, I'd like a different solution than this, something that will make the loop more acceptable. thank you for any assistance. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
stored proc timeout
I have a page with a stored procedure on it. After the stored proc runs, I have a database call to set some variables. The variables aren't getting set in the database occasionally. It also seems that the stored procedure, before the variables are set, times out at occasionally. If a stored procedure times out, should the rest of the script run? I don't know if that's the cause of the stored proc is timing out. Maybe the cf is timing out from the stored proc timing out. I have no access to the server that is having the problem because it's in production. thanks for any information. back to googling. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Not instantiating object
I've inherited a project and am not familiar with the code. When this line appears, I receive an error: cfobject type=java name=encryptObj class=GenerateKey action=create The error using cfcatch is: cfcatch.message: Object Instantiation Exception. cfcatch.detail: Class not found: GenerateKey I've set up a local server on my machine (IIS, CF7, Oracle) and the problem is occuring there. On the development server, it's working fine. Same files, so I assume it's a configuration problem. Is it? If so, is there something in CFAdministrator that I should be doing? Am I maybe missing files? Thanks for any assistance. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Not instantiating object
okay, I found a directory of java files and GenerateKey.class is one of them. My local host is:C:/localServer/PERM and my java files are on the directory above, just like on the dev server. So I just want to be sure, I reference them like this? C:/localServer/java Then I restart the Coldfusion services, right? This is all a bit new to me. and thank y'all very much. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Not instantiating object
Dan, Post the whole class path of the dev (one that's working) and local... might be easier if we saw it. I'm not sure how to post the path of the dev because it's mounted as a drive. I have it as F:\java and the one on my local server is C:/localServer/java. It's working, so I suppose it's fine. I was just asking because I'd not done this before. I was wondering though, would enabling the java classes and setting a class path slow down the server at all? Since I did it, page refreshes seem slower, but it may just be my imagination or some other variable. Thank y'all for your help. It's been great. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342054 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORACLE DATE INSERT ERROR.. Help.
I have a date/time that I made using SYSDATE and inserted into an oracle table. It looks like 2010-09-30 13:34:17.0. I have queried for that date to insert into another table, but when I go to insert it, I receive a missing comma error. I assume that it has to do with the date because when I remove the date or put in SYSDATE, it works fine. What do I have to do to this date to make it reinsert-able? I'd prefer to not parse it and then remake it with createDateTime because it seems it a fine date as-is. thanks for the help. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ORACLE DATE INSERT ERROR.. Help.
I receive the same error with that, missing comma. However, I have just had an epiphany and this worked: #createODBCDateTime(registered.date_added)# I didn't realize it needed to be an ODBC Date, nor do I really know what an ODBC date is. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Seems like the error isn't really giving much help. Can you get full debugging from that error on jobs.cfm? Can we see the code on and around line 346 of jobs.cfm? How would I get the full error? The code on and around 346 is the block of code that I posted last. cfhttp method=POST url=https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp; columns=di_0_20156 name=blah port=443 cfhttpparam type=formfield name=di_20156 value=SPHL-School of Public Health / /cfhttp Line 346 is the: cfhttpparam type=formfield name=di_20156 value=SPHL-School of Public Health / though as pointed out earlier, the value should be 20 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Though I still have hope, I'm starting to think that this is a wasted effort, because I think it's working off a timed session and that Timestamp is constantly changing. I suspect that's the reason for the 302 error. I can ask them to provide a query just for me, but the chance of it being done is really remote. It's a different unit in the University with their own deadlines and responsibilities. Thank you for your thoughts. It returns a 302 instead of search results - probably because there's still some missing fields or it doesn't like the windowTimestamp or whatever. But all of this seems to be a waste of effort - is there a reason you can't just ask the guys who created this to do one specifically for your department? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Hey William, I did try that. It didn't help, but thank you. try changing the value in your script from SPHL-School of Public Health to 20 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336590 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
sending a form through CF and catching the results
I want to send a form through CF, without the user entering anything, to the this page: https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp I would like it to display particular results, so I would have to also send it a field with a value in it. I wish to do this through code only without the user participating. Then, I would like to catch the results, parse that out and display it on another page. Is this possible? Is it somehow done through cfhttp? That look promising, but I didn't know how to send over field information too. I want the college/division field to only search for the information SPHL - School of Public Health to get our job listings. Thank you for any assistance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sending a form through CF and catching the results
Howdy Jason, I'm having significant trouble making this work. I'm going through, trying to simplify it as I go. Here's the current state of the code: cfhttp method=POST url=https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp; columns=di_0_20156 name=blah port=443 cfhttpparam type=formfield name=di_20156 value=SPHL-School of Public Health / /cfhttp cfdump var=#CFHTTP# / I'm receiving an error with no description. http://sph.umd.edu/test/error_display.jpg Also, what if I don't know the columns to be returned and just want whatever it gives me? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336510 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Making static files from requested data
I've been take information that I query regularly and instead using cfschedule to daily write the output to a static file and then using cfinclude on that. It's been working great. However, I'm trying to do that with a twitter feed and it's not working. It seems to doing a callback in javascript to get the information. That seems to be throwing a wrench into this. I need help in getting my code below to work. This is the way that I usually do it (trimmed down). cfsavecontent variable=twitter div class='widget HTML' id='HTML1' a id=twitter-link style=display:block;text-align:right; href=http://twitter.com/healthyturtle;follow me on Twitter/a script src=http://twitter.com/javascripts/blogger.js; type=text/javascript/script script src=http://twitter.com/statuses/user_timeline/healthyturtle.json?callback=twitterCallback2amp;count=5; type=text/javascript/script span class='item-control blog-admin' a class='quickedit' href='http://www.blogger.com/rearrange?blogID=1550840680584738668widgetType=HTMLwidgetId=HTML1action=editWidget' onclick='return _WidgetManager._PopupConfig(document.getElementById(HTML1));' target='configHTML1' title='Edit' /span /div /cfsavecontent -- then I write the file here using the variable twitter ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
list of declared functions
I am receiving the error Routines cannot be declared more than once, which is true. This function can be declared in multiple places so it's sort of difficult to track. Is there a way I can test and check whether a function is already declared (please say yes, it's easy? Can I query for a list of declared functions? Also, this is on a shared hosting server, if that makes any difference. thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list of declared functions
When I use an included file, I set a variable = true. then in all places where you might want to include it again, you check for that variable, and if it is not present, include the file. if it is present, you don't include it. I'm specifically hoping to avoid that. It means that I must always set a variable without possibly knowing (remembering far into the future) that I have to do so. So I'd be doing it many times. If I instead do a check in the called file, then it's automatically handled from then on out and I only have to do it once. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334655 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
concatenating email address
I'm looking to loop through a query and make a list of these: Daniel Kesslerdan...@umd.edu cfset the_from = '#the_from#,#fname# #lname##email#' However, having the and makes it so that the email address doesn't appear at all. Put in colons instead and it displays the email address fine. However, I want it formatted the way that I display above. How can I do that? I tried concatenating it with symbols, but I had the same result. thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: concatenating email address
Problem's not the concatenation, it's just the browser interprets anything between and as tags, so they're hidden by design. Once you have your list, try this: cfoutput#htmlCodeFormat(the_from)#/cfoutput I tried this and the email message failed anyway. It looked great when I did the output to a web page, but on checking the source, it instead had: PREDaniel Kesslerlt;dani...@umd.edugt;/PRE Clearly, I want the actual characters instead of the PRE and lt; ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334570 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: concatenating email address
cfset the_from = the_from , fname lnameemail ok, so this worked. I swear that I had tried this before I posted, but I probably didn't try and send the email, just viewed it for debugging. In the view, it's going to do the same wrong thing. So it's sending emails fine now. Thank you very much for your assistance. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
create cf-tags as code for a file
I want to generate a file (by code) that has CF tags in it so that it can be included into another file. I can write in the # by escaping them, but I also want to escape the cold fusion tags so that they're not enacted when I write the file, but rather when that generated file is included in another file. cfsavecontent variable=xml_counts ul style=margin-top:-10px; cfloop condition=ea_date gte start_date cfoutput --- I don't want the following cfoutput tag to be enacted by rather written into the file, so that when it's included into another file, it has the cfoutput tag to work. I need to escape the tag. How to do that? --- cfoutput lia href='##the_page##?archive=#the_content#/li /cfoutput /cfloop /ul /cfsavecontent ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: create cf-tags as code for a file
This is the right way to do it, in general: cfsavecontent var=content #chr(60)#cfoutput li.../li #chr(60)#/cfoutput /cfsavecontent hey thanks! That worked very well. yay! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled task isn't running the item in the url
When you say you run the URL separately are you doing this from the server console? If not, the server may not be able to resolve the FQDN. Dave, I'm still not able to get this cfschedule working. When I say run it separately, it means that instead of cfschedule activating the cf code that I have (which then sends email) that I instead bring up the url on my own browser to have it do it's task. That makes it run (and send my urls) just fine. So, no I'm not doing it from the server console, which I don't have access to. Are you saying that it should not be able to work with a URL that's fully qualified like http://sph.umd.edu/blah.cfm? I would think that would be best because it knows the whole path and it is on a centralized server. From what I've been able to gather, people replace the relative url with a full url on cfschedule when they run into a problem. Any more assistance would be great. I'm sure I'm close. I've been at this on and off for weeks now and it's tiring. oh and I've not been able to get the log file to work either. I'm feeling useless. daniel ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled task isn't running the item in the url
Logging is your friend. :-) Create a log file for your scheduled task. Does this page sit in an application that requires authentication? If so, make sure to specify the username and password. Qing, I'm not having much luck logging either. jeez. and no, there's no username and password for the directory or file. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled task isn't running the item in the url
Could it be DNS (change not getting there yet) or permissions (automatic Windows domain authorisation, for instance, or saved credentials in your browser). Testing directly on the server or locally with something like 'wget' is normally the best path forwards. I can't test directly on the server. I don't have access to it. It's a shared host. I may have to learn wget for this, I suppose. I dunno. I've never looked at it. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Scheduled task isn't running the item in the url
Did you see any problems with the code above? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333697 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Scheduled task isn't running the item in the url
I have the following task (CF7). The URL that it specifies is not being run.
This is my first task so I assume I'm doing something wrong. I run that url
separately and it works fine. I check my list of scheduled tasks and my task
shows up in that list and appears to be set up the way I expect. However, it
doesn't work. What the heck is wrong with it?
Help. . . please . . .
cfset start_date = createDate(year(now()),month(now()),day(now()))
cfset start_time = createTime(hour(now()),minute(now()),second(now()))
cfset start_time = dateAdd('n',5,start_time)
cfschedule
action=update
task=facilities_daily_notification
interval=600
operation=httprequest
startdate=#start_date#
starttime=#start_time#
url=http://sph.umd.edu/home/facilities_request/email/daily_notifcation.cfm;
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333054
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfschedule tasks
These all worked great. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfschedule tasks
Those were both very interesting. Thank you. They will help alot. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfschedule tasks
Is there a way to query to find out if I have any active CFSchedule items? I tried to set up a cfschedule and it's not executing the file that I specified. I don't have access to the CF server other than through code and I'm looking for ways to trouble shoot this. I've not used cfschedule before. any help is appreciated. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfschedule help
I'm trying to get cfschedule to send out an email. I've checked out a few tutorials and I don't see the problem I'm having. I have a page to set the cfschedule and it contains: cfschedule action=update task=facilities_daily_notification interval=60 operation=httprequest startdate=#now()# starttime=#now()# url=http://sph.umd.edu/home/facilities_request/email/daily_notifcation.cfm; The daily_notification.cfm page contains: cftry cfmail TO = dani...@umd.edu FROM = Daniel Kesslerdani...@umd.edu SUBJECT = Email Notification Test TIMEOUT = 30 failto = dani...@umd.edu Hey man, good morning! So I guess this thing works... /cfmail cfcatch type=any There was a problem sending the message to the mail server. Please try again later.br cfoutput #cfcatch.Message# br (#cfcatch.type#) /cfoutput cfabort /cfcatch /cftry I've tried the daily_notification.cfm page and it sends an email if I just run that, but I can't get it to run as a scheduled task. help?! thanks. daniel ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfschedule help
Are you aware that you can schedule tasks using a nice GUI from inside of ColdFusion Administrator? It's a centralized server so I don't have access to the Administrator. The problem might be related to setting the start time to now(), since the CF scheduler is checked for new jobs to process on an interval basis, not on a continual basis. Try scheduling the execution time for 20 minutes in the future to see if those emails go out. Scheduling a task to run now isn't much of a schedule. Schedule implies that it happens in the future. Why not run the email code inline? It needs to send an email out daily. I want it to start now and then each day send out another. I had it set to 60 seconds to test it as I didn't want to wait a day to find that I did it wrong and it failed. I've changed that to 120 seconds and it didn't work. I don't understand why there would be a problem with starting now() though. However, I changed the start_time to this: cfset start_date = createDate(year(now()),month(now()),day(now())) cfset start_time = createTime(hour(now()),minute(now())+10,second(now())) cfschedule action=update task=facilities_daily_notification interval=120 operation=httprequest startdate=#start_date# starttime=#start_time# url=http://sph.umd.edu/home/facilities_request/email/daily_notifcation.cfm; It doesn't seem to have worked. Is there a problem with the code? I've asked and cfschedule is enabled. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfschedule help
Try 61 seconds... You can't set a schedule to run every 60 seconds. good to know, thanks. I set it to 120 with no effect. See my reply above, please, for the full code. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfschedule help
Maybe the problem is the way that I'm designating start-date and start time.
This code:
cfset start_date = createDate(year(now()),month(now()),day(now()))
cfset start_time = createTime(hour(now()),minute(now())+10,second(now()))
produces:
{ts '2010-03-26 00:00:00'}
{ts '1899-12-30 14:28:29'}
The time on the bottom looks wrong. The14:28:29 looks right, but not the
1899-12-30. I'm trying to look up what that is now.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332337
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: session variables
Session data in ColdFusion is tied to unique combinations of user, browser and domain. And the http and https versions of your website are viewed as two different domains. This is due to the normal behavior of ColdFusion using cookies to pass the tokens that lets it know with session data goes with what http requests. so how do I get rid of these variables? I did a page full of structDeletes and that didn't help. Do I need to restart the server? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
session variables
I have a login page that sets session (session.user). I was told that to make it a secure login, I needed to go to that page using https instead of http. I did that and had certificate problems so I backed out my changes. Since then, anyone that tried to log in when it was using https is now having problems with their session variables when logging now that it is using http. Is this expected? Is there a session space that is different when using https rather than http? Is it maybe not letting go of old information? Am I explaining this well? If not, please ask questions. Also, I don't have access to the server (it's a central, shared environment), but I can make a request that something specific be done. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: session variables
Are you using the secure attribute when setting the cookies? I don't know about a secure attribute. I'm not setting cookies though, but session variables. Is the SSL domain the same as the non-SSL domain (i.e. secure.example.com vs. www.example.com)? I'm just adding an s to http. In other words http://sph.umd.edu/home/index.cfm became https://sph.umd.edu/home/index.cfm And then I reverted the change back again to http://sph.umd.edu/home/index.cfm ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: session variables
From a session perspective, the session cookie (the browser side of the session) for https://www.mysite.com is *not* shared with the session cookie for http://www.mysite.com. It sounds like they then won't mess with each other. If I wanted to get rid of the https variables then I could just have a blank page with a structDelete in it, it would seem. Honestly, I'm not sure I'm understanding the problem and I am just trying to work through it. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL Join help needed
OPPS... Change the on a.student_id = d.student_id to on a.passport_listing_id = d.passport_listing_id That didn't work. It returned too many entries. I put up a page that has: 1 - attendance dataset in my original query (on passport_listing_id) 2 - my original join that was working except i couldn't integrate the passport_attendance_id. 3 - the join that you gave me. It returns way too many entries. It should be 26 like #2, but with passport_attendance_id inserted where it exists and null where it does not. I'm hoping that by seeing the data, it'll be clear if I have not explained it well. btw, thanks for the assistance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327788 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Join help needed
OPPS... Change the on a.student_id = d.student_id to on a.passport_listing_id = d.passport_listing_id http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321 That didn't work. It returned too many entries. I put up a page that has: 1 - attendance dataset in my original query (on passport_listing_id) 2 - my original join that was working except i couldn't integrate the passport_attendance_id. 3 - the join that you gave me. It returns way too many entries. It should be 26 like #2, but with passport_attendance_id inserted where it exists and null where it does not. I'm hoping that by seeing the data, it'll be clear if I have not explained it well. http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321 btw, thanks for the assistance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327792 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Join help needed
OPPS... Change the on a.student_id = d.student_id to on a.passport_listing_id = d.passport_listing_id http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321 That didn't work. It returned too many entries. I put up a page that has: 1 - attendance dataset in my original query (on passport_listing_id) 2 - my original join that was working except i couldn't integrate the passport_attendance_id. 3 - the join that you gave me. It returns way too many entries. It should be 26 like #2, but with passport_attendance_id inserted where it exists and null where it does not. I'm hoping that by seeing the data, it'll be clear if I have not explained it well. http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321 btw, thanks for the assistance. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Join help needed
And here's the page with the data: http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321 I seem to be having trouble posting today, so sorry if this shows up a bunch of times. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327796 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Join help needed
Sorry about the multiple posts. I waited hours for the others to go through and they didn't, then all at once. That worked GREAT! Thank you very much. However, I don't really see any differences from my attempts and yours except that you did the joins on the FROM and I did it on the WHERE. Is that the major difference? Also, I substituted: On a.passport_listing_id = d.passport_listing_id and (a.student_id = d.student_id or a.people_id = d.people_id) for On a.passport_listing_id = d.passport_listing_id and a.s_uid = d.s_uid I put in s_uid for that purpose. The student_id and people_id are often used differently but the same here so I have s_uid as a field where they co-exists. dunno if it's a good idea, but it has made things simpler. If you have any education for me on why yours worked, I'd like it. Otherwise - THANK YOU VERY VERY MUCH. daniel ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Join help needed
I think I should be doing an outer join. I have a set of data (passport_registration) and I want to add a field from passport_attendance. passport_registration is a total set because it's the people that registered for the event. passport_attendance is a subset of those that attended the event. I want passport_registration to have the passport_attendance field passport_attendance_id. Here's my latest attempt: CFQUERY NAME=passport_registration2 DATASOURCE=dpch SELECT a.passport_listing_id, a.passport_registration_id, a.email_sent_attendance,a.s_uid, a.student_id, a.people_id,d.passport_attendance_id FROM passport_registration a,passport_attendance d WHERE a.s_uid (+) = d.s_uid AND d.passport_listing_id = #url.passport_listing_id# ORDER BY s_uid ASC /CFQUERY It's actually much more complicated, but this is the simplified query. Just for grins, here's the whole query that I started with and am trying to add the passport_attendance_id to (this works fine until I try to add passport_attendance_id: CFQUERY NAME=passport_registration DATASOURCE=dpch SELECT a.passport_listing_id,a.passport_registration_id,a.email_sent_attendance,a.s_uid,a.student_id,a.people_id, CASE WHEN a.student_id is not null THEN b.fname ELSE c.fname END fname, CASE WHEN a.student_id is not null THEN b.lname ELSE c.lname END lname, CASE WHEN a.student_id is not null THEN b.email ELSE c.email END email FROM passport_registration a, students b, people c WHERE a.student_id = b.student_id (+) AND a.people_id = c.id (+) AND a.passport_listing_id = #url.passport_listing_id# /CFQUERY thanks for any assistance. daniel ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327766 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL Join help needed
I meant to say - this is Oracle. thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327768 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL Join help needed
This code isn't using inner/outer join notation, but the old style. Is there a reason for this? It's the way that I learned to do it. I've read your notation; it's certainly more explicit. Further though, the assistance that I needed was adding the field 'passport_attendance_id' from the 'passport_attendance' table. I don't see that in there and I am having difficulties adding it. any help on that, please? Here is the structure of passport_attendance: passport_attendance_id NUMBER Primary Key, date_added date, person_scanning VARCHAR2(100), passport_listing_id NUMBER REFERENCES passport_listing(passport_listing_id), student_id NUMBER REFERENCES students(student_id), people_id NUMBER REFERENCES people(id), s_uid VARCHAR2(50), approved VARCHAR2(20) thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327771 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Error
I'm using Oracle and CF7, doing a Query of Query. I'm attempting to research a
query to find any that the title doesn't have affiliate Faculty in it.
The query of query is giving me an error:
The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
Here's the first query:
CFQUERY NAME=people_search DATASOURCE=dpch
SELECT
id,fname,mname,lname,type,title,dept,phone,location,email,email_alternate,summary
FROM PEOPLE
WHERE upper(dept) Like upper('%epidemiology%')
ORDER BY upper(lname) ASC, upper(fname) ASC
/CFQUERY
Here's the second query that gives the error:
cfquery dbtype=query name=faculty
select *
FROM people_search
WHERE upper(people_search.title) not like upper('%Affiliate Faculty,
Epidemiology Biostatistics%')
/cfquery
Oddly if I change out title for lname it works fine. Here's the
information on those two fields:
TITLE VARCHAR2200
LNAME VARCHAR2100
So they're largely similar, but daggummit, I need it to be title I use.
thank you.
daniel
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323387
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF - mySQL (and OT from there)
I'm trying to learn to set up a mySQL database. Does CF have to be on the same machine/server for it to talk to the mySQL database? I'm also not sure if I have to set up a web server for anything to talk to the database or can I just give it an IP that the database is on, somehow. Finally, can anyone suggest a mySQL user group? I've seen several, but I'd like a recommendation. thanks. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318181 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF - mySQL (and OT from there)
When you set up the CF DSN one of the fields is for the DB server, just add the IP (or name if you have one) of the server and the port number (probably 3306) and you should be good to go. okay. I see. In my case, I'm in a shared hosting environment where CF and Oracle are given to me. I don't have access to the management of either, except as a user. So I couldn't point the CF to my mySQL database on another machine. I was hoping that there was a way as a CF user I could do that for certain queries. It sounds like that's a no. So to learn mySQL, it seems that I should also install the CF single-user server on my Mac OSX. I guess I should then go the whole route and enable the Apache that comes with the machine. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318183 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF - mySQL (and OT from there)
Those are good points. Thank you very much. It's way past time I learned the management side of CF anyway. I'm sure it'll be good for me. thanks for taking the time to respond. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318185 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT Oracle query OR problem
I'm doing this query in Oracle and am encountering the error: Encountered student_id = OR. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, CFQUERY NAME=passport_attendance dbtype=query SELECT passport_attendance_id FROM passport_attendance WHERE student_id = #passport_registration.student_id[pr]# OR people_id = #passport_registration.people_id[pr]# /CFQUERY The problem appears to be that sometimes passport_registration.student_id[pr] is empty. It's a numeric, so when I wrapped it in quotes, it didn't like that either cause it was comparing different types. How do I handle that sort of situation? One of the two is always gonna be empty. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
