Re: encrypting SQL Server data
Does anybody have any experience or recommendations about what to use or how to go about doing it? http://developer.perthweb.com.au/textcrypt.html -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: encrypting SQL Server data
That is a public key cryptosystem, he needs symmetric key. You can use one of the encryption functions on the http://www.cflib.org Plus functions there are free to use. TK http://www.tomkitta.com [Tom Kitta] -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 4:29 PM To: CF-Talk Subject: Re: encrypting SQL Server data Does anybody have any experience or recommendations about what to use or how to go about doing it? http://developer.perthweb.com.au/textcrypt.html -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: good error.cfm template
a good debugging tool that a developer can use to troubleshoot issues when they arise tony -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 4:14 PM To: CF-Talk Subject: RE: good error.cfm template What do you consider a good error template? Good reporting to development staff? Good description of error for user, including next steps? Good error logging/catching in the logfiles? Good automated error recovery (system recovery, disk cleanup, link repair, CF recycling) Jerry Johnson [EMAIL PROTECTED] 05/11/04 04:04PM yeah, that's what I have begun to do as well :) but, was just wondering what people thought of, and what they did... any one else have a cool error.cfm template? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: good error.cfm template
Here's something I have used for a while and just tweaked for each project - I never got around to making this a truly dynamic custom tag that I could just plug into an app I guess I should but I'm just to lazy :) Hope this helps for some ideas. cfsilent !--- = --- !--- NAME: --- !---customErrTrap--- !--- --- !--- PURPOSE: --- !---Provide a single template for processing (CFTRY/CFCATCH) errors with the ability to:--- !--- 1.Send an email with detailed error information to 1 or more persons (Default Option)--- !---And / Or--- !--- 2.Abort after processing and display minimal error information to the customer--- !---with the site administrator's email address as a contact if they wish to report anything. --- !--- --- !---IF YOU DO NOT SELECT THIS OPTION IT IS UPON THE DEVELOPER TO HANDLE THE ERROR GRACEFULLY --- !---WITHIN THEIR CODE.--- !--- --- !--- NOTES:--- !---This tag must be between cfcatch/cfcatch to function properly.--- !---This tag assumes, if you are passing email addresses, they are valid.No validation at this time. --- !---(Possibility to check for valid email addresses [multiple listing] @ a future date.) --- !--- --- !--- USAGE:--- !---Default Option #1 above: --- !---cf_customErrTrap --- !---Selecting Options:--- !--- cf_customErrTrap--- !---errMail=0/1 --- !---errMailTo= [EMAIL PROTECTED]--- !---errMailSubject=Hey there was a problem --- !---errAbort=0/1 --- !---errSiteAdmin= [EMAIL PROTECTED]--- !---errPath=#getCurrentTemplatePath()# --- !--- --- !--- ATTRIBUTES: --- !---errMail : {Optional} (Default = On) Send Email with error info? [0=Off / 1=On]--- !---errMailTo : {Optional} Who is the Email to?--- !---errMailSubject: {Optional} What is the Email subject?--- !---errAbort: {Optional} (Default = Off) Abort after processing display error? [0=Off / 1=On] --- !---errSiteAdmin : {Optional} Email address to display when we 'abort' and display the error?--- !---errPath: {Optional} Path and template name throwing error--- !--errDeveloper : {Optional} Email address to send error email to.This would be used for--- !--- Development / Testing and WILL OVERRIDE the errMailTo attribute--- !--- if used. --- !--- --- !--- AUTHOR:--- !---Steven Semrau ( [EMAIL PROTECTED])--- !--- --- !--- DATE: --- !---Tuesday, April 02, 2002--- !--- --- !--- MODIFICATION LOG: --- !---DATEAUTHORNOTES --- !---= --- !---03/22/2004 S.SemrauModified for use with BRAC Application--- !---03/30/2004S.SemrauAdded Local (variables.xxx) and Application.xxx variables to the email --- !---output.Also added SQLState and NativeErrorCode cfcatch variables to--- !---the email output.--- !--- = --- /cfsilent !--- Copy Application scoped variables to request scope variables to avoid unnecessary CFLOCKs --- cflock timeout=5 throwontimeout=no type=readonly scope=application cfset request.application = duplicate(application) /cflock !--- Copy session scoped variables to request scope variables to avoid unnecessary CFLOCKs --- cflock timeout=5 throwontimeout=no type=readonly scope=session cfset request.session = duplicate(session) /cflock !--- --- !--- Set Defaults --- !--- --- cfparam name=errMail type=numeric default=1 cfparam name=errMailFrom type=string default=#request.session.systemdescription# [EMAIL PROTECTED] cfparam name=errMailTo type=string default=#request.application.errorEmail# cfparam name=errMailSubject type=string default=A #caller.cfcatch.type# error has been encountered on the (#cgi.server_name#) server. cfparam name=errAbort type=numeric default=0 cfparam name=errSiteAdmin type=string default= [EMAIL PROTECTED] cfparam name=errPath type=string default=No template path provided to custom error tag. !--- Check and set any attributes passed by the custom tag --- cfif isDefined(attributes.errMail) AND len(trim(attributes.errMail)) GT 0 cfset variables.errMail = attributes.errMail /cfif cfif isDefined(attributes.errMailTo) AND len(trim(attributes.errMailTo)) GT 0 cfset variables.errMailTo = attributes.errMailTo /cfif cfif isDefined(attributes.errMailSubject) AND len(trim(attributes.errMailSubject)) GT 0 cfset variables.errMailSubject = attributes.errMailSubject /cfif cfif isDefined(attributes.errAbort) AND len(trim(attributes.errAbort)) GT 0 cfset variables.errAbort = attributes.errAbort /cfif cfif isDefined(attributes.errSiteAdmin) AND len(trim(attributes.errSiteAdmin)) GT 0 cfset variables.errSiteAdmin = attributes.errSiteAdmin /cfif cfif isDefined(attributes.errPath) AND len(trim(attributes.errPath)) GT 0 cfset variables.errPath = attributes.errPath /cfif cfif isDefined(attributes.errDeveloper) AND len(trim(attributes.errDeveloper)) GT 0 cfset varilabes.errMailTo = attributes.errDeveloper /cfif !---
CFFILE UPLOAD ???
Hi All, How do I append a string value to the name of the file I am upload to the server? EXAMPLE: File Name to upload is: Readme.txt File Name AFTER Upload: FOO-Readme.txt Thanks Sam Komolafe --- [This E-mail scanned for viruses.] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE UPLOAD ???
You can specify a full path, includeing filename in the CFFILE ACTION="" tag, or you can upload it, and then do a CFFILE ACTION="" to rename it to whatever you want.The advantage of the second method is that you will have access to the CFFILE scope that the upload generates, containing all the info about the file. Cheers, barneyb -Original Message- From: sam komolafe [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 3:14 PM To: CF-Talk Subject: CFFILE UPLOAD ??? Hi All, How do I append a string value to the name of the file I am upload to the server? EXAMPLE: File Name to upload is: Readme.txt File Name AFTER Upload: FOO-Readme.txt Thanks Sam Komolafe --- [This E-mail scanned for viruses.] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Could someone give this a try?
I am using Oracle9i Release 2 (9.2.0.3.0) with CFMX 6.1 I am calling the Oracle Stored procedure find_NestedTable with cfstoredproc and I get an empty recordset/query.But when I use another oracle tool like TOAD or SQLPLUS to call the TEST procedure which calls find_NestedTable, I get the 7 items printed out. Could someone give this code a try and see if you get the same results? Package Spec: CREATE OR REPLACE PACKAGE Test_PKG AS /***/ /* Public Package Variables, etc.*/ /***/ -- Define a generic cursor type. TYPE generic_curtype IS REF CURSOR; -- -- /*** * **/ PROCEDURE find_NestedTable ( p_p IN VARCHAR2 DEFAULT '1,3,6,22,30,66,98', p_cur IN OUT generic_curType ); /*** * **/ PROCEDURE TEST; /*** * **/ END; / End Package Spec -- Package Body: CREATE OR REPLACE PACKAGE BODY test_pkg AS /*** * **/ PROCEDURE list2table ( p_list IN VARCHAR2, p_tbl IN OUT number_nt_type ) AS -- v_str VARCHAR2(100) DEFAULT p_list || ','; v_pos NUMBER := NULL; --v_tbl number_nt_type := number_nt_type(); BEGIN LOOP v_pos := INSTR( v_str, ',', 1 ); EXIT WHEN v_str IS NULL OR NVL(v_pos,0) = 1; p_tbl.EXTEND; p_tbl( p_tbl.COUNT ) := SUBSTR(v_str,1,v_pos-1); v_str := SUBSTR( v_str, v_pos+1); END LOOP; -- --FOR i IN v_tbl.FIRST..v_tbl.LAST LOOP --DBMS_OUTPUT.PUT_LINE( i || ':' || v_tbl( i ) ); --END LOOP; -- END; /*** * **/ PROCEDURE find_NestedTable ( p_p IN VARCHAR2 DEFAULT '1,3,6,22,30,66,98', p_cur IN OUT generic_curType ) IS -- should be present v_p number_nt_type := number_nt_type();-- (1,3,6,22,30,66,98); BEGIN list2table( p_p, v_p ); OPEN p_cur FOR SELECT * FROM TABLE(CAST(v_p AS number_nt_type)) c; END; /*** * **/ PROCEDURE TEST IS -- should be present v_str VARCHAR2(100):= '1,3,6,22,30,66,98'; v_cur generic_curType; v_num NUMBER; BEGIN find_NestedTable( v_str, v_cur ); LOOP FETCH v_cur INTO v_num; IF v_cur%NOTFOUND THEN EXIT; END IF; DBMS_OUTPUT.PUT_LINE( v_num ); END LOOP; END; /*** * **/ END; / End Package Body Begin CFMX code: cfstoredproc procedure=#variables.schema#.test_pkg.find_NestedTable datasource=#variables.dsn# cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=p_p value=1,3,6,22,30,66,98 null=yes cfprocresult name=qry resultset=1 maxrows=20 /cfstoredproc End CFMX code Thanks, Troy -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Index Verity Collection - cannot load style.ddd
I'm also having this problem.I followed what Jerry said:I had already created the collection so I made sure the style.ddd file was in cfusionmx\verity\collections\COLLECTIONNAME\file\style it wasn't there, but it was in cfusionmx\verity\collections\COLLECTIONNAME\style well, now it's in both, but I'm still getting the same error.Any thoughts? Thanks in advance. --Tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Could someone give this a try?
This appears to be bug in the Macromedia JDBC Driver for Oracle... Troy Simpson wrote: I am using Oracle9i Release 2 (9.2.0.3.0) with CFMX 6.1 I am calling the Oracle Stored procedure find_NestedTable with cfstoredproc and I get an empty recordset/query.But when I use another oracle tool like TOAD or SQLPLUS to call the TEST procedure which calls find_NestedTable, I get the 7 items printed out. Could someone give this code a try and see if you get the same results? Package Spec: CREATE OR REPLACE PACKAGE Test_PKG AS /***/ /* Public Package Variables, etc.*/ /***/ -- Define a generic cursor type. TYPE generic_curtype IS REF CURSOR; -- -- /*** * **/ PROCEDURE find_NestedTable ( p_p IN VARCHAR2 DEFAULT '1,3,6,22,30,66,98', p_cur IN OUT generic_curType ); /*** * **/ PROCEDURE TEST; /*** * **/ END; / End Package Spec -- Package Body: CREATE OR REPLACE PACKAGE BODY test_pkg AS /*** * **/ PROCEDURE list2table ( p_list IN VARCHAR2, p_tbl IN OUT number_nt_type ) AS -- v_str VARCHAR2(100) DEFAULT p_list || ','; v_pos NUMBER := NULL; --v_tbl number_nt_type := number_nt_type(); BEGIN LOOP v_pos := INSTR( v_str, ',', 1 ); EXIT WHEN v_str IS NULL OR NVL(v_pos,0) = 1; p_tbl.EXTEND; p_tbl( p_tbl.COUNT ) := SUBSTR(v_str,1,v_pos-1); v_str := SUBSTR( v_str, v_pos+1); END LOOP; -- --FOR i IN v_tbl.FIRST..v_tbl.LAST LOOP --DBMS_OUTPUT.PUT_LINE( i || ':' || v_tbl( i ) ); --END LOOP; -- END; /*** * **/ PROCEDURE find_NestedTable ( p_p IN VARCHAR2 DEFAULT '1,3,6,22,30,66,98', p_cur IN OUT generic_curType ) IS -- should be present v_p number_nt_type := number_nt_type();-- (1,3,6,22,30,66,98); BEGIN list2table( p_p, v_p ); OPEN p_cur FOR SELECT * FROM TABLE(CAST(v_p AS number_nt_type)) c; END; /*** * **/ PROCEDURE TEST IS -- should be present v_str VARCHAR2(100):= '1,3,6,22,30,66,98'; v_cur generic_curType; v_num NUMBER; BEGIN find_NestedTable( v_str, v_cur ); LOOP FETCH v_cur INTO v_num; IF v_cur%NOTFOUND THEN EXIT; END IF; DBMS_OUTPUT.PUT_LINE( v_num ); END LOOP; END; /*** * **/ END; / End Package Body Begin CFMX code: cfstoredproc procedure=#variables.schema#.test_pkg.find_NestedTable datasource=#variables.dsn# cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=p_p value=1,3,6,22,30,66,98 null=yes cfprocresult name=qry resultset=1 maxrows=20 /cfstoredproc End CFMX code Thanks, Troy -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Could someone give this a try?
This appears to be a bug in the Macromedia JDBC Driver for Oracle... -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: encrypting SQL Server data
Tom Kitta wrote That is a public key cryptosystem, he needs symmetric key No, the original post didn't say that, and asymmetric key systems work in the scenario he provided.Granted they are more trouble to deal with when used properly (i.e. the decryption key is kept off the server and input -- pasted in -- at the start of each work session), but the sacrifice in convenience is made up for by the increased security. Provided of course the users know not to do things like email someone the private key. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Could someone give this a try?
Disregard my post.Is was the oddest thing causing my problem. All I had to do is change the null=yes to null=no or remove the null attribute. cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=p_str value=#v# null=yes When the attribute null=yes then you get a very very ambiguous error message like this: Message Error Executing Database Query. Detail [Macromedia][Oracle JDBC Driver]Unsupported data conversion. That took me about 5 days to figure out.What a was of time. Troy -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: helpdesk
On Tuesday, May 11, 2004, 9:01:30 PM, CF-Talk wrote: What does everyone use/recommend? Doesn't have to be CF specific, or opensource is fine as well. Check out: http://www.cerberusweb.com/ It's PHP, reasonably priced, and the support is excellent. jim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Writing Websites for Phone Web Browsers
I was wondering if anyone has any experience making their websites accessible via Phone Web-Browsers? What I am planning to do is check what kind of browser the client is using and based on that, they would view the WML version of the website. The thing is how do you program a CF page to be a WML page? Would you just use the CFContent tag to specify that the page is WML and just add the ?xml tag? What about the dynamic parts of the page? I'm pretty clueless on this matter so if anyone has any experience or advice I would greatly appreciate it. Thanks, Ali [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
TranslateRSSItems problem
Does anyone have any experience with the TranslateRSSItems UDF? (http://www.cflib.org/udf.cfm?ID=813) It hangs for me as soon as the script function is called.Using CF 5.0. Thanks in advance for the help, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfcatch question
Does anyone know why this line errors out only in CF 5?The following code is being run inside of a catch block: error occurred on Line #CFCATCH.TAGCONTEXT[1][LINE]# I could have sworn it worked in CF 4.5.1, but my memory is fading daily on them good ol' days. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: http_referer
Thanks Matt for the comprehensive reply. I kind of thought that there was a flaw in setting a persistant uuid because cookies can be hijacked etc. On a related note I wonder if using a secure site (https://) can stop cookie hijacking - I have a feeling it can't ? Andrew. I used to create a uuid, store it in a persistent scope, hash it, put that in the hidden form field and then do a comparison on the form post side.I thought this would stop scrapers as they couldn't know the hash source. I threw this out here in another thread and asked if it had holes.Dave Watts pointed out that anyone can visit the form page and take the hidden field and the key pair cookie values.Once they have those and can fake headers they can blow right past pretty much anything but the gif-code thingie, but even that just requires a human to submit. I'd recommend doing all of the tests you can think of.Referrers, request method, hidden fields, input scrubbing, cfqueryparam etc.But I don't think the solution can be made truly ironclad. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: http_referer
HTTPS will only secure the cookies in transit.They'll still be stored in plain text on the user's computer, and may even be sent to the server over plain HTTP if they weren't specifically set with the secure option. However, if you're using a new UUID for each time the form is generated, then the odds of this hole being exploited is acceptably small, at least to me. What are the odds that you'll generate a form, and before the person submits it or a timeout happens some malicious user is going to get both the HTML of the form sent to the user (for the hidden form field) AND their cookie values?About the only chance you've got is packet sniffing, which HTTPS will take care of, and killing the user at their terminal and taking over, which there is no way to prevent. You can also consider mixing other data in the hash, such as the visitor's user agent, or even their IP (though that can get you in trouble if a network has multiple outbound routers). Cheers, barneyb -Original Message- From: Andrew Grosset [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 8:10 PM To: CF-Talk Subject: Re: http_referer Thanks Matt for the comprehensive reply. I kind of thought that there was a flaw in setting a persistant uuid because cookies can be hijacked etc. On a related note I wonder if using a secure site (https://) can stop cookie hijacking - I have a feeling it can't ? Andrew. I used to create a uuid, store it in a persistent scope, hash it, put that in the hidden form field and then do a comparison on the form post side.I thought this would stop scrapers as they couldn't know the hash source. I threw this out here in another thread and asked if it had holes.Dave Watts pointed out that anyone can visit the form page and take the hidden field and the key pair cookie values.Once they have those and can fake headers they can blow right past pretty much anything but the gif-code thingie, but even that just requires a human to submit. I'd recommend doing all of the tests you can think of.Referrers, request method, hidden fields, input scrubbing, cfqueryparam etc.But I don't think the solution can be made truly ironclad. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [cf-talk] Digest Number 92
The CFWDDX ACTION='' is enclosed within a CFTRY with some following code, capturing data passed to it in a FORM variable from another site.The code following CFWDDX has to work if any data are captured, as it CFOUTPUTs over the CFWDDX output.If there is a CFTRY failure the WDDX code passed to the page is captured to the database in the CFCATCH.For debugging purposes I'm also presently capturing all good WDDX tests captured too. The strange part is that I already did as you suggested, comparing failed WDDX with good WDDX to see what the difference might be, but the WDDX can be identical! I cannot make it fail on demand.It will just decide to fail one time and pass another.In one case the code failed repeatedly as I reloaded the test page numerous times, and I went to bed but left the computer on.In the morning I hit the refresh button and the code worked just as it should, capturing the exact same WDDX that had been passed to the browser and held in its form variable cache since the night before.Flabbergasted, I compared the two sets of WDDX in the database and they were identical, character for character.I even saved them to two text files and did a text comparison of the two and they tested identical that way. I don't have direct access to one of the sites but I could arrange to have someone set up a ping-pong test page on it for me.What do you have in mind, how would that help? At 07:38 PM 5/9/04, you wrote: Message: 11 Date: Sun, 9 May 2004 15:43:26 -0700 From: [EMAIL PROTECTED] Subject: Re: WDDX on CF 5.0 What error do you get? I did a lot of WDDX exchanges in 5.0 between remote hosts -- once I got the programs debugged there was no problem with WDDX. Can you make it fail? Could a timeout be the cause? Could you catch a unaccepted WDDX packet and save it to a text file where you could do a diff compare with a good packet. Do you have access to both sites so that you could write a program that ping-pongs a packet back and forth? Just some thoughts. Dick On May 9, 2004, at 2:42 PM, Karl Simanonok wrote: I'm running CF 5.0 and using WDDX to get data back from another site.What's weird is sometimes the WDDX code is accepted on my server, sometimes it isn't and throws an error.Exact same WDDX code is returned in both cases.Has anybody seen this happen before?Any ideas about what to do about it?(Please don't tell me to upgrade to MX though, that isn't going to happen). Regards, Karl S. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Shanje refugees
I was just notified today that Shanje.com will no longer be supporting its ColdFusion customers after June 1.They even have a web page where they seem to seriously suggest that I should drop everything else I'm doing and rewrite tens of thousands of good, functioning CF code before June 1 so that I may have the privilege of migrating to their new .NET platform. Can anyone suggest an alternative CF host that has most of the best features that Shanje.com offered?I need SQL Server support and lots of domains and subdomains hopefully without getting nickel-and-dimed to death for each new database, domain and email address I set up.I liked Shanje's Web Control Panel even if it was a bit clunky. Regards, Karl S. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Shanje refugees
Unlinkearth..(http://www.uplinkearth.com) I have the Quantim plan. WHich allows me, 10 domains and 10 sub-domains. Both Access SQL are available and I have to say, adding Sub-domains on the fly with their control panel is a breeze! Not to mention their support is excellent. Most all cases are answered within minutes. - Original Message - From: Karl Simanonok To: CF-Talk Sent: Tuesday, May 11, 2004 5:57 AM Subject: Shanje refugees I was just notified today that Shanje.com will no longer be supporting its ColdFusion customers after June 1.They even have a web page where they seem to seriously suggest that I should drop everything else I'm doing and rewrite tens of thousands of good, functioning CF code before June 1 so that I may have the privilege of migrating to their new .NET platform. Can anyone suggest an alternative CF host that has most of the best features that Shanje.com offered?I need SQL Server support and lots of domains and subdomains hopefully without getting nickel-and-dimed to death for each new database, domain and email address I set up.I liked Shanje's Web Control Panel even if it was a bit clunky. Regards, Karl S. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Shanje refugees
The big thing about Shanje's plan is that they DON'T nickel and dime you. They charge one price and don't care how many domains you have.YOU pay for the disk space, bandwidth etc you use not per domain.Anything you need, you add yourself through the control panel.Ive found the same thing with the setup I have.Almost all the support questions I had disappeared when we installed the current control panel, because the clients could do their own modifications to the plan any time they like - extra databases, additional disk space, additional mailboxes, subdomains,sqlserver2000 databases, mySQL databases,the lot. Give me a day to sort out how to do the practical stuff like issue control panel access and I'll have a plan modelled on Shanje's structure.(although perhaps not the same actual amounts). Karl, If you want to discuss this further, you can email me or find me on MSN Messenger. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: ColdFusion Developer [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 May 2004 8:43 PM To: CF-Talk Subject: Re: Shanje refugees Unlinkearth..(http://www.uplinkearth.com) I have the Quantim plan. WHich allows me, 10 domains and 10 sub-domains. Both Access SQL are available and I have to say, adding Sub-domains on the fly with their control panel is a breeze! Not to mention their support is excellent. Most all cases are answered within minutes. - Original Message - From: Karl Simanonok To: CF-Talk Sent: Tuesday, May 11, 2004 5:57 AM Subject: Shanje refugees I was just notified today that Shanje.com will no longer be supporting its ColdFusion customers after June 1.They even have a web page where they seem to seriously suggest that I should drop everything else I'm doing and rewrite tens of thousands of good, functioning CF code before June 1 so that I may have the privilege of migrating to their new .NET platform. Can anyone suggest an alternative CF host that has most of the best features that Shanje.com offered?I need SQL Server support and lots of domains and subdomains hopefully without getting nickel-and-dimed to death for each new database, domain and email address I set up.I liked Shanje's Web Control Panel even if it was a bit clunky. Regards, Karl S. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX 6.1 and Order By Error
Nope. All I know is that it's in this list: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/express4.htm - Original Message - From: Eric Davis Yep.I noticed when I took out 'section' the query worked just fine. Any idea what the keyword 'Section' relates to in either CF or SQL? -e [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: QofQ with Like returns nullnull error
The docs say you can use like, though. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_20.htm - Original Message - From: J E VanOver Sorry, I don't think you can use LIKE on QofQ I couldn't find any citations to confirm it.Anyone care to contradict me? J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Shanje refugees
Would you mind sharing the URL? I'm just curious to see their justifications. Of course, even if they had good reasons, it's pretty slimy to do this with only about 20 days notice. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: http_referer
I think the point was that when you create the UUID to put in the hidden form field, you also stick it in a persistent variable scope. That way you can compare the submitted UUID with the original value. If they don't match, you know the form has been spoofed and can act accordingly. This method will stop the submission of form data without having actually filled the form, but it wouldn't stop screen-scrapers reading the hidden field as well as the visible ones. For that you'd need one of those type the word you see in the graphic thingies (I know there's a name for them but can never remember it). -- Howard Fore, [EMAIL PROTECTED] On May 10, 2004, at 10:37 PM, Andrew Grosset wrote: I don't follow...couldn't I just copy the uuid and place it in a hidden field in MY form and submit that? Stick a uuid in a hidden field and check that you get the same one back. cgi.http_referer can't be trusted as it can be easily spoofed. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Shanje refugees
Would you mind sharing the URL? I'm just curious to see their justifications. Of course, even if they had good reasons, it's pretty slimy to do this with only about 20 days notice. They started talking about it months ago. They also never upgraded to CF MX, for me that was a strong signal already Anyway, it's a shame, because the way they added unlimited domains was handy Massimo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Shanje refugees
I have had great experiences with Crystaltech.net Karl Simanonok wrote: I was just notified today that Shanje.com will no longer be supporting its ColdFusion customers after June 1.They even have a web page where they seem to seriously suggest that I should drop everything else I'm doing and rewrite tens of thousands of good, functioning CF code before June 1 so that I may have the privilege of migrating to their new .NET platform. Can anyone suggest an alternative CF host that has most of the best features that Shanje.com offered?I need SQL Server support and lots of domains and subdomains hopefully without getting nickel-and-dimed to death for each new database, domain and email address I set up.I liked Shanje's Web Control Panel even if it was a bit clunky. Regards, Karl S. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Performance Question best practive
Which would be faster Select users.username, project.projectname Fromusers inner join project on (users.userid = project.projectowner) - Or - Select (select username from users where userid = project.projectowner), project.projectname Fromproject Bob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Performance Question best practive
From: Robert Everland III Which would be faster Select users.username, project.projectname Fromusers inner join project on (users.userid = project.projectowner) - Or - Select (select username from users where userid = project.projectowner), project.projectname Fromproject Joins are faster than sub-queries [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
why? are we different?
1084281167 = 05/11/2004 14:12:47 as number of seconds since jan 1, 1970. .NET says it is 1084281167 = 05/11/2004 13:12:47 which one is right? which one is wrong? why cant they be the same?time is time. I know there are different implementations etc...but how can we be soo wrong? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: why? are we different?
Since it's only an hour I'd guess it's a summer time/daylight issue...perhaps? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 11 May 2004 14:52 To: CF-Talk Subject: why? are we different? 1084281167 = 05/11/2004 14:12:47 as number of seconds since jan 1, 1970. .NET says it is 1084281167 = 05/11/2004 13:12:47 which one is right? which one is wrong? why cant they be the same?time is time. I know there are different implementations etc...but how can we be soo wrong? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: why? are we different?
1084281167 = 05/11/2004 14:12:47 as number of seconds since jan 1, 1970. .NET says it is 1084281167 = 05/11/2004 13:12:47 which one is right? which one is wrong? why cant they be the same?time is time. I know there are different implementations etc...but how can we be soo wrong? Looks like it's a Daylight Savings issue? Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IIS/CF permissions problem
Yes, I have one of those nasty issues with permissions that crop up with IIS, sometimes related to CF. And I'll start by saying that I have attempted all the permissions fixes that I can find in both the Macromedia and Microsoft knowledge bases. Basically, yesterday my development server (CFMX 6.1, Windows 2003 Server) stopped accepting anonymous accesses. It began presenting a challenge box. However, it wouldn't accept authentication, either, for any user on the server. The problem, while possibly related to CF, does not simply affect the processing of .cfm pages. Even static content (.htm, .gif) produces a 401 error. This followed a change of the user under which CF was running, but not immediately. I made that change last Friday, but things continued to work fine. I cannot say for sure whether the machine was rebooted at some time after that, before the permissions problems arose. But to reiterate -- it won't accept either anonymous access or Windows authorization. After going through all the fixes suggested in knowledge base articles, I finally uninstalled both IIS and CF, then reinstalled IIS. At that point, anonymous access worked again, for static content (I did not test ASP pages). I then reinstalled CFMX 6.1, and the problem returned. No access, either anonymous or Windows authenticated, regardless of the settings within IIS (Anonymous on, Windows off - or vice versa). I have checked the file permissions multiple times. The web root directory shows Read and Execute permissions for the anonymous Internet user account, and these permissions are not inherited, but applied directly to the web root and all enclosed files and folders. When I look at the permissions of individual files, they read the same way. But IIS will not allow me access, either anonymous or authenticated. I'm guessing there's something buried in the Registry that's causing this, but it's beyond me. Any help would certainly be appreciated. -- Thanks, Tom Tom McNeer MediumCool A Marketing, Creative and Construction Company for the World Wide Web 530 Means St NW, Suite 110 Atlanta, GA 30318 404-589-0560 FAX 404-589-0510 http://www.mediumcool.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: why? are we different?
more of a rhetorical question. I knew the answer, mm acknowledged the bug last year during redsky beta, however its still not fixed. WTF tw -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:56 AM To: CF-Talk Subject: RE: why? are we different? 1084281167 = 05/11/2004 14:12:47 as number of seconds since jan 1, 1970. .NET says it is 1084281167 = 05/11/2004 13:12:47 which one is right? which one is wrong? why cant they be the same?time is time. I know there are different implementations etc...but how can we be soo wrong? Looks like it's a Daylight Savings issue? Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Performance Question best practive
The simple thing to do would be to time both of them. But in general (and this can easily change depending on the DBMS you use) I would say that the first (a simple join) would be faster than the second (a sub-select).Just make sure that you're join columns are indexed for best performance. Jim Davis _ From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 8:28 AM To: CF-Talk Subject: SQL Performance Question best practive Which would be faster Select users.username, project.projectname Fromusers inner join project on (users.userid = project.projectowner) - Or - Select (select username from users where userid = project.projectowner), project.projectname Fromproject Bob _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: why? are we different?
I knew the answer, mm acknowledged the bug last year during redsky beta, however its still not fixed. Soon Weegs, soon. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Embedded wav files not playing on XP
Weird one: A certain page has a wav embedded in it for audible notification of the user. This page executes great with NT and IE 6.0.2. in the following format embed src="" width=0 height=0 hidden=true autostart=true volume=50 The sounds cannot be heard when the page renders in XP and IE 6.0.2. and media player 8.0 If I put the path of the wav in the browser and directly render it, it plays fine. Anyone have any ideas? John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: why? are we different?
ok. so its wrong. will it ever be right? or is it wrong? who is right here? any macromedians that can comment? please. ben, christian, christene?? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:58 AM To: CF-Talk Subject: RE: why? are we different? more of a rhetorical question. I knew the answer, mm acknowledged the bug last year during redsky beta, however its still not fixed. WTF tw -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:56 AM To: CF-Talk Subject: RE: why? are we different? 1084281167 = 05/11/2004 14:12:47 as number of seconds since jan 1, 1970. .NET says it is 1084281167 = 05/11/2004 13:12:47 which one is right? which one is wrong? why cant they be the same?time is time. I know there are different implementations etc...but how can we be soo wrong? Looks like it's a Daylight Savings issue? Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: why? are we different?
Did the latest hotfix correct this? Or was that only a different issue? Docs on what was fixed note a bug as 53972 - DateDiff function incorrectly accounts for Daylight Saving Time Ken -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:58 AM To: CF-Talk Subject: RE: why? are we different? more of a rhetorical question. I knew the answer, mm acknowledged the bug last year during redsky beta, however its still not fixed. WTF tw -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:56 AM To: CF-Talk Subject: RE: why? are we different? 1084281167 = 05/11/2004 14:12:47 as number of seconds since jan 1, 1970. .NET says it is 1084281167 = 05/11/2004 13:12:47 which one is right? which one is wrong? why cant they be the same?time is time. I know there are different implementations etc...but how can we be soo wrong? Looks like it's a Daylight Savings issue? Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: why? are we different?
From: Tony Weeg I knew the answer, mm acknowledged the bug last year during redsky beta, however its still not fixed. I tend to treat it with the GetTimeZoneInfo() and update the value [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: why? are we different?
but that's a kludge.isnt it? I mean, if I say, give me the correct day/time when I add these seconds, and I don't care if im in DST or EST, the server should realize this, and give me the correct dateAdd() return value. right? tw -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:46 AM To: CF-Talk Subject: RE: why? are we different? From: Tony Weeg I knew the answer, mm acknowledged the bug last year during redsky beta, however its still not fixed. I tend to treat it with the GetTimeZoneInfo() and update the value [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Problem with CFMail
I'm trying to use a cfmail with a query and a replyto. There seems to be an error with this as it tells me I can use a queryreplyto instead of just a reply to. However, when I change it to a queryreplyto I recieve a different error that tells me this is an invalid attribute. Any suggestions, Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
The other shoe drops
At work a couple of weeks ago the Manager of IT was informed that he has a new boss as Directory of IT, to better set strategic direction and bridge the gap between IT and the user community. One of the new strategic directions is towards Java/J2EE/JSP. We've been having some serious memory leaks with JRun/CFMX J2EE/Linux that have been locking up our servers about once a month. (It was once every two weeks, so IT decided to throw RAM, about 4.5GB per server, at the problem.) The new guy comes from a major web hosting shop and has some poor opinions of CF (I don't know what versions he has experience with). Rather than isolate the issue to CFMX or the underlying J2EE server, he's decided to switch major directions. While I am predicting that soon I will be moved from Marketing (back) into IT due to my role, I don't have the political will/pull to question his move, all I can really do is brush off my Java skills and roll with the punches. The question (I'm sure you were wondering) is how usable is Fusebox in JSP? I'd rather not go back to Struts, although I may not have a choice. FB just makes more sense to me than Struts. I know there are other frameworks (Velocity, Tapestry) - can someone make a comparison between them and the way FB works? Is there anyone working one Mach-II for Java? It's possible I'm leaping to conclusions. I'd be happy moving data access to an EJB middle tier and keeping the user interface in CF but I'm betting the new guy won't like that. -- Howard Fore, [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Help...
I guess I am having an off day with SQL. I think technically this should work but I get a syntax error UPDATE Account a SET a.last_update = (SELECT TOP 1 h.tranDate FROM History h WHERE a.Account_Number = h.Account_Number ORDER BY h.tranDate DESC) Basically what this is supposed to do is look at each account number in the account table. Go to the history table for that account number and grab the last date it sees for the history of that account number and populate the account table with that date. Any help would greatly be appreciated! Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Flash to animated GIF
OK...no idea if this is doable, but is there any way to convert a Flash animation into an animated GIF?? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The other shoe drops
The question (I'm sure you were wondering) is how usable is Fusebox in JSP? I'd rather not go back to Struts, although I may not have a choice. FB just makes more sense to me than Struts. I know there are other frameworks (Velocity, Tapestry) - can someone make a comparison between them and the way FB works? Is there anyone working one Mach-II for Java? I can't help, but I heard this book does some interesting comparison of different Java frameworks for the web: http://www.manning.com/ford Take a look at the TOC and see if it may help: http://www.manning.com/catalog/view.php?book=forditem=contents Massimo Foti http://www.massimocorner.com Co-Author of Dreamweaver MX 2004 Magic: http://www.dwmagic.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Flash to animated GIF
Check 'save as type' in Export Movie -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:06 AM To: CF-Talk Subject: OT: Flash to animated GIF OK...no idea if this is doable, but is there any way to convert a Flash animation into an animated GIF?? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Help...
Jeff I guess I am having an off day with SQL. I think technically this should work but I get a syntax error UPDATE Account a SET a.last_update = (SELECT TOP 1 h.tranDate FROM History h WHERE a.Account_Number = h.Account_Number ORDER BY h.tranDate DESC) I would think this is likely to give an error because there's no reason syntactically why the subselect should return a single value - that 1 could be any other number. How about something like UPDATE Account a SET a.last_update = (SELECT max(h.tranDate) FROM History h WHERE a.Account_Number = h.Account_Number) Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash to animated GIF
LOLguess I shoulda checked there first huh ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Turetsky, Seth To: CF-Talk Sent: Tuesday, May 11, 2004 8:08 AM Subject: RE: Flash to animated GIF Check 'save as type' in Export Movie -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:06 AM To: CF-Talk Subject: OT: Flash to animated GIF OK...no idea if this is doable, but is there any way to convert a Flash animation into an animated GIF?? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Flash to animated GIF
No problem :) I don't know how good it is though, it could make very large sized files -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:14 AM To: CF-Talk Subject: Re: Flash to animated GIF LOLguess I shoulda checked there first huh ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Turetsky, Seth To: CF-Talk Sent: Tuesday, May 11, 2004 8:08 AM Subject: RE: Flash to animated GIF Check 'save as type' in Export Movie -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:06 AM To: CF-Talk Subject: OT: Flash to animated GIF OK...no idea if this is doable, but is there any way to convert a Flash animation into an animated GIF?? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The other shoe drops
At work a couple of weeks ago the Manager of IT was informed that he has a new boss as Directory of IT, to better set strategic direction and bridge the gap between IT and the user community. One of the new strategic directions is towards Java/J2EE/JSP. We've been having some serious memory leaks with JRun/CFMX J2EE/Linux that have been locking up our servers about once a month. (It was once every two weeks, so IT decided to throw RAM, about 4.5GB per server, at the problem.) The new guy comes from a major web hosting shop and has some poor opinions of CF (I don't know what versions he has experience with). Rather than isolate the issue to CFMX or the underlying J2EE server, he's decided to switch major directions. While I am predicting that soon I will be moved from Marketing (back) into IT due to my role, I don't have the political will/pull to question his move, all I can really do is brush off my Java skills and roll with the punches. Increasing the amount of RAM never fixes memory leaks. Further, unless you are using a 64bit CPU and OS, then you can't make use of more than 4GB of RAM anyway. In fact, most 32bit operating systems won't allow you to even use all 4GB. The question (I'm sure you were wondering) is how usable is Fusebox in JSP? I'd rather not go back to Struts, although I may not have a choice. FB just makes more sense to me than Struts. I know there are other frameworks (Velocity, Tapestry) - can someone make a comparison between them and the way FB works? Is there anyone working one Mach-II for Java? Apparently there is a Mach-II in development for Java, but no idea when it will be done. It's possible I'm leaping to conclusions. I'd be happy moving data access to an EJB middle tier and keeping the user interface in CF but I'm betting the new guy won't like that. Don't do that. EJB is a bear that has little benefit for you in this case. It would take less work to find the memory leak than it would to implement an EJB middle-tier. I would recommend trying a different J2EE application server. Sun One and JBoss are both freely available. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Flash to animated GIF
There is recommendation that if you are serious about animated gifs you should optimize them in a gif animation specific program. TK http://www.tomkitta.com -Original Message- From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:16 AM To: CF-Talk Subject: RE: Flash to animated GIF No problem :) I don't know how good it is though, it could make very large sized files -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:14 AM To: CF-Talk Subject: Re: Flash to animated GIF LOLguess I shoulda checked there first huh ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Turetsky, Seth To: CF-Talk Sent: Tuesday, May 11, 2004 8:08 AM Subject: RE: Flash to animated GIF Check 'save as type' in Export Movie -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:06 AM To: CF-Talk Subject: OT: Flash to animated GIF OK...no idea if this is doable, but is there any way to convert a Flash animation into an animated GIF?? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash to animated GIF
Oh ya...it's huge an grainy oin gradientsbut for the part of the animation I need it might just do the trick. FYI a 341K FLA file became a 14.1 MB GIF ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Turetsky, Seth To: CF-Talk Sent: Tuesday, May 11, 2004 8:15 AM Subject: RE: Flash to animated GIF No problem :) I don't know how good it is though, it could make very large sized files -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:14 AM To: CF-Talk Subject: Re: Flash to animated GIF LOLguess I shoulda checked there first huh ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Turetsky, Seth To: CF-Talk Sent: Tuesday, May 11, 2004 8:08 AM Subject: RE: Flash to animated GIF Check 'save as type' in Export Movie -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:06 AM To: CF-Talk Subject: OT: Flash to animated GIF OK...no idea if this is doable, but is there any way to convert a Flash animation into an animated GIF?? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Help...
Without thinking about it too hard (which means this may or may not be the real issue) it looks like you're missing a couple of 'as' clauses: update account as a ... from history as h ... --Ben Doom Jeff Waris wrote: I guess I am having an off day with SQL. I think technically this should work but I get a syntax error UPDATE Account a SET a.last_update = (SELECT TOP 1 h.tranDate FROM History h WHERE a.Account_Number = h.Account_Number ORDER BY h.tranDate DESC) Basically what this is supposed to do is look at each account number in the account table. Go to the history table for that account number and grab the last date it sees for the history of that account number and populate the account table with that date. Any help would greatly be appreciated! Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: http_referer
I used to create a uuid, store it in a persistent scope, hash it, put that in the hidden form field and then do a comparison on the form post side.I thought this would stop scrapers as they couldn't know the hash source. I threw this out here in another thread and asked if it had holes.Dave Watts pointed out that anyone can visit the form page and take the hidden field and the key pair cookie values.Once they have those and can fake headers they can blow right past pretty much anything but the gif-code thingie, but even that just requires a human to submit. I'd recommend doing all of the tests you can think of.Referrers, request method, hidden fields, input scrubbing, cfqueryparam etc.But I don't think the solution can be made truly ironclad. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The other shoe drops
[Tom Kitta] I agree with the memory leaks but not with the size of RAM limitation. There is no problem with going past 4Gb on Windows server. For example you can have SQL server use 8Gb. For how to do this see http://www.sql-server-performance.com/ As far as I know same holds true for other server class OS. On non-server OS 4Gb is a limit, like on Windows XP Pro. The OS must do a re-mapping trick to use memory past 4Gb on 32bit systems and I think this is what Matt was referring to. TK http://www.tomkitta.com Increasing the amount of RAM never fixes memory leaks. Further, unless you are using a 64bit CPU and OS, then you can't make use of more than 4GB of RAM anyway. In fact, most 32bit operating systems won't allow you to even use all 4GB. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Shanje refugees
I second that motion - Cystaltech has been great. -Original Message- From: Pete Ruckelshaus - CFList [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 8:11 AM To: CF-Talk Subject: Re: Shanje refugees I have had great experiences with Crystaltech.net Karl Simanonok wrote: I was just notified today that Shanje.com will no longer be supporting its ColdFusion customers after June 1.They even have a web page where they seem to seriously suggest that I should drop everything else I'm doing and rewrite tens of thousands of good, functioning CF code before June 1 so that I may have the privilege of migrating to their new .NET platform. Can anyone suggest an alternative CF host that has most of the best features that Shanje.com offered?I need SQL Server support and lots of domains and subdomains hopefully without getting nickel-and-dimed to death for each new database, domain and email address I set up.I liked Shanje's Web Control Panel even if it was a bit clunky. Regards, Karl S. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Image reset button
Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src="" name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Help...
Ben, Without thinking about it too hard (which means this may or may not be the real issue) it looks like you're missing a couple of 'as' clauses: update account as a ... from history as h ... Unfortunately, AS is a voluntary addition to SQL statements. I would love to see them made compulsory... ;) Jeff, I guess I am having an off day with SQL. I think technically this should work but I get a syntax error UPDATE Account a SET a.last_update = (SELECT TOP 1 h.tranDate FROM History h WHERE a.Account_Number = h.Account_Number ORDER BY h.tranDate DESC) Umm... Isn't this going to update last_update on every record in Account to be the one record from History that you get? You're probably looking for something more like : UPDATE Account AS a LEFT JOIN History AS h ON a.Account_Number = h.Account_Number SET a.last_update = h.tranDate But even thats not quite right Just a thought.The transaction history table isn't going any place is it?If its sticking around, then why do you need to duplicate the data into the account table?You can just SELECT it out at the appropriate time. SELECT Account.*, MAX(History.tranDate) AS Last_Update FROM Account LEFT JOIN History ON Account.Account_Number = History.Account_Number WHERE Account.Account_Number = 123 Or if you really do need to duplicate the data into the account table, why not do at the time of writing the record to the history table? Hope that helps Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help...
Nick, worked like a charm, the only thing I had to do was get rid of all the aliasing.. For whatever reason Query analyzer was throwing a fit with the aliases. Ben, Aliasing on tables can be set like that. :) I think your thinking of column aliases. Thanks all, Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The other shoe drops
Howard, You're in an unenviable situation, where it sounds like politics will play just as important a role as technical merit in making the decisions. My suggestion is that you push your idea of using CF for the front-end and Java for the back-end. CF is vastly superior (IMHO) to JSP for building the user interface, and Java is better for modeling business objects and processes. You don't need to wait for Mach-II for Java. Use the current Mach-II with CF handling the View-Controller pieces (e.g. filters and listeners) and Java handling the Model. It's not hard to do and gives you the best of both worlds. And don't assume that you need EJBs in the middle tier. EJBs have their use, but unless you're running a highly complex distributed environment (or possibly interfacing a legacy app), you should be just fine with a J2SE solution. If you don't like JRun, check out Tomcat, JBoss or SunOne. Dave Jones NetEffect At 10:56 AM 5/11/04 -0400, you wrote: At work a couple of weeks ago the Manager of IT was informed that he has a new boss as Directory of IT, to better set strategic direction and bridge the gap between IT and the user community. One of the new strategic directions is towards Java/J2EE/JSP. We've been having some serious memory leaks with JRun/CFMX J2EE/Linux that have been locking up our servers about once a month. (It was once every two weeks, so IT decided to throw RAM, about 4.5GB per server, at the problem.) The new guy comes from a major web hosting shop and has some poor opinions of CF (I don't know what versions he has experience with). Rather than isolate the issue to CFMX or the underlying J2EE server, he's decided to switch major directions. While I am predicting that soon I will be moved from Marketing (back) into IT due to my role, I don't have the political will/pull to question his move, all I can really do is brush off my Java skills and roll with the punches. The question (I'm sure you were wondering) is how usable is Fusebox in JSP? I'd rather not go back to Struts, although I may not have a choice. FB just makes more sense to me than Struts. I know there are other frameworks (Velocity, Tapestry) - can someone make a comparison between them and the way FB works? Is there anyone working one Mach-II for Java? It's possible I'm leaping to conclusions. I'd be happy moving data access to an EJB middle tier and keeping the user interface in CF but I'm betting the new guy won't like that. -- Howard Fore, [EMAIL PROTECTED] -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:162826This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=1210.1130.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help...
From: Jeff Waris I guess I am having an off day with SQL. I think technically this should work but I get a syntax error UPDATE Account a SET a.last_update = (SELECT TOP 1 h.tranDate FROM History h WHERE a.Account_Number = h.Account_Number ORDER BY h.tranDate DESC) Basically what this is supposed to do is look at each account number in the account table. Go to the history table for that account number and grab the last date it sees for the history of that account number and populate the account table with that date. I'll have to dig something up... But - look into (like Ben said) UPDATE table SET fields FROM table2 WHERE The problem with some SQL engines is that it doesn't allow aliasing of the UPDATE table, so you'd have to refer to that by name, but you can alias any of the tables in the FROM [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Image reset button
From: Robert Orlini Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src="" name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Have an image and a JS onClick calling document.form.reset() I think that'll work, but I've not tested it [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The other shoe drops
On May 11, 2004, at 11:18 AM, Matt Liotta wrote: Increasing the amount of RAM never fixes memory leaks. Further, unless you are using a 64bit CPU and OS, then you can't make use of more than 4GB of RAM anyway. In fact, most 32bit operating systems won't allow you to even use all 4GB. Hmm, top is showing Mem:3870956k av, 3853716k used,17240k free, 0k shrd, 227888k buff 2836168k actv,879872k in_d,22252k in_c Swap: 3072216k av, 1535548k used, 1536668k free 589904k cached So that's about 3.6GB total memory (((3853716k + 17240k) / 1024) / 1024) right? Maybe I'm reading it wrong, Linux admin isn't my strong suit. Right or wrong, I think IT's point was to increase the time between crashes so they could collect more metrics information to share with Macromedia support. We've an open ticket but until another crash MM says they can't tell us anything useful. I think the Java stack heap is filling up. Don't do that. EJB is a bear that has little benefit for you in this case. It would take less work to find the memory leak than it would to implement an EJB middle-tier. I would recommend trying a different J2EE application server. Sun One and JBoss are both freely available. But neither are officially supported CFMX platforms by MM, right? And as far as that goes, the choices as I understand them are Weblogic and Websphere. From past experience I believe that either would make the software investment in CFMX seem like a drop in the bucket. -- Howard Fore, [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Image reset button
image src="" / - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 8:49 AM Subject: Image reset button Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src=""> name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Image reset button
You could use this: button type=reset style=border:none;background-color:#fff img src=""> -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:49 AM To: CF-Talk Subject: Image reset button Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src=""> name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Image reset button
Actually, instead of background-color:#fff, use background:transparent The neat benefit of this is that you still get the depressed movement when you click the button/image. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Marlon Moyer Sent: Tuesday, May 11, 2004 11:05 AM To: CF-Talk Subject: RE: Image reset button You could use this: button type=reset style=border:none;background-color:#fff img src=""> -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:49 AM To: CF-Talk Subject: Image reset button Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src=""> name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX Error : Object Instantiation Exception
Anyone have any idea why this error appears?!I get a useful message of ColdFusion cannot determine the line of the template that caused this error. This is often caused by an error in the exception handling subsystem. (class: cfAdvSearch2ecfm1661571554, method: _factor9 signature: (Ljavax/servlet/jsp/tagext/Tag;Ljavax/servlet/jsp/JspWriter;)Ljava/lang/Obje ct;) Illegal exception table range Only happens when clicking on one particular link.. TIA Neil This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IIS/CF permissions problem
Yes, I have one of those nasty issues with permissions that crop up with IIS, sometimes related to CF. And I'll start by saying that I have attempted all the permissions fixes that I can find in both the Macromedia and Microsoft knowledge bases. Basically, yesterday my development server (CFMX 6.1, Windows 2003 Server) stopped accepting anonymous accesses. It began presenting a challenge box. However, it wouldn't accept authentication, either, for any user on the server. The problem, while possibly related to CF, does not simply affect the processing of .cfm pages. Even static content (.htm, .gif) produces a 401 error. This followed a change of the user under which CF was running, but not immediately. I made that change last Friday, but things continued to work fine. I cannot say for sure whether the machine was rebooted at some time after that, before the permissions problems arose. But to reiterate -- it won't accept either anonymous access or Windows authorization. After going through all the fixes suggested in knowledge base articles, I finally uninstalled both IIS and CF, then reinstalled IIS. At that point, anonymous access worked again, for static content (I did not test ASP pages). I then reinstalled CFMX 6.1, and the problem returned. No access, either anonymous or Windows authenticated, regardless of the settings within IIS (Anonymous on, Windows off - or vice versa). I have checked the file permissions multiple times. The web root directory shows Read and Execute permissions for the anonymous Internet user account, and these permissions are not inherited, but applied directly to the web root and all enclosed files and folders. When I look at the permissions of individual files, they read the same way. But IIS will not allow me access, either anonymous or authenticated. Have you set the permissions on the CFMX ISAPI extension to allow read/execute by Authenticated Users? You can find the path of the ISAPI extension by looking in the IIS management console by going to the Home Directory tab for your site, clicking on the Configuration button at the bottom of the tab dialog, then finding the ISAPI DLL that .cfm is mapped to. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The other shoe drops
I would recommend trying a different J2EE application server. Sun One and JBoss are both freely available. But neither are officially supported CFMX platforms by MM, right? Sun ONE is supported, JBoss is not: http://www.macromedia.com/software/coldfusion/productinfo/systemreqs/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Image reset button
Thank you Marlon. Does this button function work in Netscape as well? RO -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 12:05 PM To: CF-Talk Subject: RE: Image reset button You could use this: button type=reset style=border:none;background-color:#fff img src=""> -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:49 AM To: CF-Talk Subject: Image reset button Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src=""> name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Fusetalk Categories visible to registered users only.
OK.Officially stumped! I want to make all the categories in a/the forum visible only to registered users, so that guests that wander along only get to see an empty form/message telling them to go register. Now I've done this and it was all working ages ago, but I suspect the client has accidently switch this option off and now the categories are all visible to anyone who visits the forums.I'd like to check the option is still set to only allow registered users to see categories, but can I find it???No can I heck!! Can anyone point me at the settings to make categories visible only to registered users please?? Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Image reset button
Isn't that IE only? John -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 12:09 PM To: CF-Talk Subject: RE: Image reset button Actually, instead of background-color:#fff, use background:transparent The neat benefit of this is that you still get the depressed movement when you click the button/image. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Marlon Moyer Sent: Tuesday, May 11, 2004 11:05 AM To: CF-Talk Subject: RE: Image reset button You could use this: button type=reset style=border:none;background-color:#fff img src=""> -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:49 AM To: CF-Talk Subject: Image reset button Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src=""> name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Thanks. Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Image reset button
Thanks Charles. I get a _javascript_ error when I click the button though. RO -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 12:04 PM To: CF-Talk Subject: Re: Image reset button image src="" / - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 8:49 AM Subject: Image reset button Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src=""> name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash to animated GIF
try publish settings - u have to play around quite a bit with colors and other variables to get the right look cheers nick Bryan Stevenson wrote: Oh ya...it's huge an grainy oin gradientsbut for the part of the animation I need it might just do the trick. FYI a 341K FLA file became a 14.1 MB GIF ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Turetsky, Seth To: CF-Talk Sent: Tuesday, May 11, 2004 8:15 AM Subject: RE: Flash to animated GIF No problem :) I don't know how good it is though, it could make very large sized files -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:14 AM To: CF-Talk Subject: Re: Flash to animated GIF LOLguess I shoulda checked there first huh ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Turetsky, Seth To: CF-Talk Sent: Tuesday, May 11, 2004 8:08 AM Subject: RE: Flash to animated GIF Check 'save as type' in Export Movie -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:06 AM To: CF-Talk Subject: OT: Flash to animated GIF OK...no idea if this is doable, but is there any way to convert a Flash animation into an animated GIF?? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Image reset button
From: Robert Orlini Thanks Charles. I get a _javascript_ error when I click the button though. In Charles' example, the form name was myFormName If your form wasn't named that, then it would error [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Image reset button
dumb question (bear with me)...but did you change the onclick attributes? myFormName should be the actual name of your form (?) - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:42 AM Subject: RE: Image reset button Thanks Charles. I get a _javascript_ error when I click the button though. RO -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 12:04 PM To: CF-Talk Subject: Re: Image reset button image src="" / - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 8:49 AM Subject: Image reset button Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src=""> name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Access Question
Off topic:When a table is opened in Access in the spreadsheet-like view, sometimes a boolean Yes/No field appears as -1/0 and sometimes as checkboxes.What controls this, and is it indicative in any way of how the data field itself is defined? On topic:Is it always safe to do a query on an Access table through the MS ODBC drivers and test a Yes/No field using 1/0 rather than -1/0?I realize why Access stores booleans that appear as -1.What I'm wondering is if the ODBC layer masks this from the developer. SELECT * FROM mytable WHERE booleanfield = 1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Getting GetMetricData() information with ColdFusion MX for J2EE
Hi I just realized that GetMetricData() isn't directly available when using CFMX for J2EE. Are there any other options for getting that data if using JRun? I know it's possible to write that information to log file but I'm looking to use that information in a CFML page. Parsing from a log file would be possible solution but I don't think it's too elegant. Thanks in advance! Tero Pikala ps. what I really want to do is to create script that can be used with JMeter to monitor state of the server. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Access Question
I haven't used access in quite a while, but I believe you can control the formatting of boolean fields in the schema edit form, down in the bottom part where all the options are. If you're using an integer in a boolean context, the safest bet is always comparing to zero, because zero is always the only false value, whereas true can have multiple values. SELECT * FROM mytable WHERE booleanfield 0 Cheers, barneyb -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:08 AM To: CF-Talk Subject: Access Question Off topic:When a table is opened in Access in the spreadsheet-like view, sometimes a boolean Yes/No field appears as -1/0 and sometimes as checkboxes.What controls this, and is it indicative in any way of how the data field itself is defined? On topic:Is it always safe to do a query on an Access table through the MS ODBC drivers and test a Yes/No field using 1/0 rather than -1/0?I realize why Access stores booleans that appear as -1.What I'm wondering is if the ODBC layer masks this from the developer. SELECT * FROM mytable WHERE booleanfield = 1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: The other shoe drops
Well, that's good to know, sort of. MM says they support Sun ONE 7. Sun says that Sun ONE 7 is supported on Red Hat 7.2. Good grief! RH just sent me the End Of Life email on RH 9. If it's not one thing, it's another. However, Sun ONE is certainly something to try on one of our testing boxes. -- Howard Fore, [EMAIL PROTECTED] On May 11, 2004, at 12:25 PM, Dave Watts wrote: I would recommend trying a different J2EE application server. Sun One and JBoss are both freely available. But neither are officially supported CFMX platforms by MM, right? Sun ONE is supported, JBoss is not: http://www.macromedia.com/software/coldfusion/productinfo/systemreqs/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: why? are we different?
The hotfix kind of works. On my developer's edition, which is single user Enterprise, it worked. On my production server, Professional 6.0 upgraded to 6.1, it doesn't. Why am I not surprised? Did the latest hotfix correct this? Or was that only a different issue? Docs on what was fixed note a bug as 53972 - DateDiff function incorrectly accounts for Daylight Saving Time Ken -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:58 AM To: CF-Talk Subject: RE: why? are we different? more of a rhetorical question. I knew the answer, mm acknowledged the bug last year during redsky beta, however its still not fixed. WTF tw -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:56 AM To: CF-Talk Subject: RE: why? are we different? Looks like it's a Daylight Savings issue? Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Image reset button
That's what happens to newbies - me culpa. I will change it and thanks for the help -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 1:02 PM To: CF-Talk Subject: Re: Image reset button dumb question (bear with me)...but did you change the onclick attributes? myFormName should be the actual name of your form (?) - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:42 AM Subject: RE: Image reset button Thanks Charles. I get a _javascript_ error when I click the button though. RO -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 12:04 PM To: CF-Talk Subject: Re: Image reset button image src="" / - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 8:49 AM Subject: Image reset button Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src=""> name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Thanks. Robert O. HWW _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: why? are we different?
whats the difference between the two?besides the obvious? macromedians? anyone? why is this sooo wrong? tony -Original Message- From: Larry White [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 1:39 PM To: CF-Talk Subject: Re: why? are we different? The hotfix kind of works. On my developer's edition, which is single user Enterprise, it worked. On my production server, Professional 6.0 upgraded to 6.1, it doesn't. Why am I not surprised? Did the latest hotfix correct this? Or was that only a different issue? Docs on what was fixed note a bug as 53972 - DateDiff function incorrectly accounts for Daylight Saving Time Ken -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:58 AM To: CF-Talk Subject: RE: why? are we different? more of a rhetorical question. I knew the answer, mm acknowledged the bug last year during redsky beta, however its still not fixed. WTF tw -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 9:56 AM To: CF-Talk Subject: RE: why? are we different? Looks like it's a Daylight Savings issue? Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
no subject
I¹m looking for a solution to the the ³back button² problem. I¹m sure there is a stardard way of dealing with this but I don¹t know what it is. When a transaction is complete in my shopping cart an invoice is displayed. I eliminate all cookies and zero all session variables so the customer can return to shop on the site if he or she decides to. Unfortunately instead of clicking the ³continue shopping² button, customers will most times hit the back button. This causes an error from the lack of session variables/cookies that are no longer present. I not sure what the best solution to this problem is. Is there a prevent the customer from using the ³back² button? Any help would be much appreciated. BZaccheo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Image reset button
Nope, it's part of the HTML 4 spec, but netscape 4 doesn't support it. Didn't even think of that since my company decided not to support that browser anymore.Good news is that mozilla/gecko supports it :) -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:38 AM To: CF-Talk Subject: RE: Image reset button Thank you Marlon. Does this button function work in Netscape as well? RO -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 12:05 PM To: CF-Talk Subject: RE: Image reset button You could use this: button type=reset style=border:none;background-color:#fff img src=""> -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:49 AM To: CF-Talk Subject: Image reset button Is there a way to make an image button to function as a reset button? Here is a SUBMIT as an image: input type=image src=""> name=submit2 value=submit2 How would I revise this w/an image? input type=reset value=Clear name=B2 Thanks. Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Seeking some elementary SQL teachings?
Wise Ones, We have to change hosting services and need to make a quick decision about converting from MS Access to SQL and/or MYSQL.Two questions, if one of you experts would like to advise on? 1. I think that I recently saw a posting in CFTalk that you can convert an existing DB by reading from Access and writing to SQL and/or MYSQL. 2. The bigger unknown in my mind is the coding, i.e., just how much different is the coding? Assuming an illustration would simplest. What changes would need to be made to the following code to operate on SQL and/or MYSQL? Thanks, Nick CFQUERY NAME=GetRecords DATASOURCE=DB1 DBTYPE=ODBC SELECT * FROM Table1 WHERE ID = ID /CFQUERY CFQUERY NAME=ExtractData DATASOURCE=DB1 DBTYPE=ODBC SELECT * FROM Table1 WHERE ID = ID /CFQUERY CFQUERY NAME=CreateTable DATASOURCE=DB1 DBTYPE=ODBC CREATE TABLE Table1 ( ID AUTOINCREMENT, Field1 TEXT (100), Field2 NUMBER (20) ) /CFQUERY CFQUERY NAME=AddCompletions DATASOURCE=DB1 insert into Table1 (Field1,Field2) values('#session.Variable1#', #session.Variable2#) /CFQUERY [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: no subject
On the previous page, check to see if the variables exist, and if they don't, forward them to the continue shopping destination. -Original Message- From: Butch Zaccheo [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:52 AM To: CF-Talk Subject: no subject I¹m looking for a solution to the the ³back button² problem. I¹m sure there is a stardard way of dealing with this but I don¹t know what it is. When a transaction is complete in my shopping cart an invoice is displayed. I eliminate all cookies and zero all session variables so the customer can return to shop on the site if he or she decides to. Unfortunately instead of clicking the ³continue shopping² button, customers will most times hit the back button. This causes an error from the lack of session variables/cookies that are no longer present. I not sure what the best solution to this problem is. Is there a prevent the customer from using the ³back² button? Any help would be much appreciated. BZaccheo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: no subject
You could...and really should be checking for the existence of those variables before calling them.If they don't exist, use cflocation to redirect the user to the correct page. John -Original Message- From: Butch Zaccheo [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 1:52 PM To: CF-Talk Subject: no subject I¹m looking for a solution to the the ³back button² problem. I¹m sure there is a stardard way of dealing with this but I don¹t know what it is. When a transaction is complete in my shopping cart an invoice is displayed. I eliminate all cookies and zero all session variables so the customer can return to shop on the site if he or she decides to. Unfortunately instead of clicking the ³continue shopping² button, customers will most times hit the back button. This causes an error from the lack of session variables/cookies that are no longer present. I not sure what the best solution to this problem is. Is there a prevent the customer from using the ³back² button? Any help would be much appreciated. BZaccheo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: The other shoe drops
Just FYI We've successfully deployed CFMX on JBoss. (don't remember which version but was within past 4-5 months) in order to have a backup plan for JRun. -Stace _ From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:19 AM To: CF-Talk Subject: Re: The other shoe drops At work a couple of weeks ago the Manager of IT was informed that he has a new boss as Directory of IT, to better set strategic direction and bridge the gap between IT and the user community. One of the new strategic directions is towards Java/J2EE/JSP. We've been having some serious memory leaks with JRun/CFMX J2EE/Linux that have been locking up our servers about once a month. (It was once every two weeks, so IT decided to throw RAM, about 4.5GB per server, at the problem.) The new guy comes from a major web hosting shop and has some poor opinions of CF (I don't know what versions he has experience with). Rather than isolate the issue to CFMX or the underlying J2EE server, he's decided to switch major directions. While I am predicting that soon I will be moved from Marketing (back) into IT due to my role, I don't have the political will/pull to question his move, all I can really do is brush off my Java skills and roll with the punches. Increasing the amount of RAM never fixes memory leaks. Further, unless you are using a 64bit CPU and OS, then you can't make use of more than 4GB of RAM anyway. In fact, most 32bit operating systems won't allow you to even use all 4GB. The question (I'm sure you were wondering) is how usable is Fusebox in JSP? I'd rather not go back to Struts, although I may not have a choice. FB just makes more sense to me than Struts. I know there are other frameworks (Velocity, Tapestry) - can someone make a comparison between them and the way FB works? Is there anyone working one Mach-II for Java? Apparently there is a Mach-II in development for Java, but no idea when it will be done. It's possible I'm leaping to conclusions. I'd be happy moving data access to an EJB middle tier and keeping the user interface in CF but I'm betting the new guy won't like that. Don't do that. EJB is a bear that has little benefit for you in this case. It would take less work to find the memory leak than it would to implement an EJB middle-tier. I would recommend trying a different J2EE application server. Sun One and JBoss are both freely available. -Matt _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: no subject -- back button
i think you will have to use the _javascript_ onLoad to do the handling, put your logic there. . -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 2:13 PM To: CF-Talk Subject: RE: no subject You could...and really should be checking for the existence of those variables before calling them.If they don't exist, use cflocation to redirect the user to the correct page. John -Original Message- From: Butch Zaccheo [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 1:52 PM To: CF-Talk Subject: no subject I¹m looking for a solution to the the ³back button² problem. I¹m sure there is a stardard way of dealing with this but I don¹t know what it is. When a transaction is complete in my shopping cart an invoice is displayed. I eliminate all cookies and zero all session variables so the customer can return to shop on the site if he or she decides to. Unfortunately instead of clicking the ³continue shopping² button, customers will most times hit the back button. This causes an error from the lack of session variables/cookies that are no longer present. I not sure what the best solution to this problem is. Is there a prevent the customer from using the ³back² button? Any help would be much appreciated. BZaccheo _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
multiple hosts one server
hi there. I cant remember, whats the xml file that must be altered so that you can show multiple sites on one server...for some reason, this server Im on decided to only show one root...and I cant get multiple ones to show? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: multiple hosts one server
On 6.1 it's exposed in the CF admin. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:22 AM To: CF-Talk Subject: multiple hosts one server hi there. I cant remember, whats the xml file that must be altered so that you can show multiple sites on one server...for some reason, this server Im on decided to only show one root...and I cant get multiple ones to show? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: multiple hosts one server
ok, the ghost went away, the site is back now weird. thank buddha its only a dev server :) tw -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 2:30 PM To: CF-Talk Subject: RE: multiple hosts one server On 6.1 it's exposed in the CF admin. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:22 AM To: CF-Talk Subject: multiple hosts one server hi there. I cant remember, whats the xml file that must be altered so that you can show multiple sites on one server...for some reason, this server Im on decided to only show one root...and I cant get multiple ones to show? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IIS/CF permissions problem
Have you set the permissions on the CFMX ISAPI extension to allow read/execute by Authenticated Users? I haven't actively set the permissions that way, but it appears that Users do have permission to read/execute the extension. I assume you mean they should have that permission, right? Would that affect the serving of non-CF files, though? The problem applied to .htm, .gif, you name it. I use applied, past tense, because the problem (thankfully) has gone away, although (unfortunately) I still don't know why it occurred, nor why the reinstall and permissions fixes didn't work the first time. I uninstalled and reinstalled IIS and CFMX one more time. The only actual difference I can discern is that I made sure to delete the CFMX folder before reinstalling. During both uninstalls, CFMX never completed its uninstall. It hung on registry changes, and eventually I had to reboot. Also, between reinstalling IIS and CFMX, I walked through Microsoft's list of default permissions (NTFS permissions, registry permissions, security policy permissions) for IIS 6.0 and made sure they were set according to the document. But I don't know whether that made a difference. The first time I checked these permissions and modified a couple after the reinstall. Anyway, after reinstalling IIS, the authentication issue went away for static/ASP files. And after this last reinstall of CFMX, the issue did not reoccur. Can't say I'm happy that the source of the problem is undiscovered; but at least things are working now. On to re-applying CFMX patches. (Unless someone has encountered permissions problems arising from any of them.) Specifically, Dave, have you ever encountered a problem like this after changing the Login account for CFMX from System to a less-privileged User? (I ask since you've addressed changing the Login many times in the past.)The problem didn't occur immediately after that change; but that change was the last modification made on that server prior to the problem. -- Thanks, Tom Tom McNeer MediumCool A Marketing, Creative and Construction Company for the World Wide Web 530 Means St NW, Suite 110 Atlanta, GA 30318 404-589-0560 FAX 404-589-0510 http://www.mediumcool.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Seeking some elementary SQL teachings?
On May 11, 2004, at 10:53 AM, Nick Baker wrote: Wise Ones, We have to change hosting services and need to make a quick decision about converting from MS Access to SQL and/or MYSQL. Two questions, if one of you experts would like to advise on? 1. I think that I recently saw a posting in CFTalk that you can convert an existing DB by reading from Access and writing to SQL and/or MYSQL. 2. The bigger unknown in my mind is the coding, i.e., just how much different is the coding? Assuming an illustration would simplest. What changes would need to be made to the following code to operate on SQL and/or MYSQL? Thanks, Nick CFQUERY NAME=GetRecords DATASOURCE=DB1 DBTYPE=ODBC SELECT * FROM Table1 WHERE ID = ID /CFQUERY none CFQUERY NAME=ExtractData DATASOURCE=DB1 DBTYPE=ODBC SELECT * FROM Table1 WHERE ID = ID /CFQUERY none CFQUERY NAME=CreateTable DATASOURCE=DB1 DBTYPE=ODBC CREATE TABLE Table1 ( ID AUTOINCREMENT, Field1 TEXT (100), Field2 NUMBER (20) ) /CFQUERY in SQL-SERVER . id Identity primary key in MySQL no change CFQUERY NAME=AddCompletions DATASOURCE=DB1 insert into Table1 (Field1,Field2) values ('#session.Variable1#', #session.Variable2#) /CFQUERY no change [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: multiple hosts one server
Which web root is deemed the one will fluctuate across requests.So one request it'll work, come back in 10 minutes and it won't. Cheers, barneyb -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:31 AM To: CF-Talk Subject: RE: multiple hosts one server ok, the ghost went away, the site is back now weird. thank buddha its only a dev server :) tw [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IIS and Web? Hopefully CF
Does anyone know a good utility to manage IIS, creating Virtual Sites and such from a web browser? (Would like a CF based one) I tried to download the IHTK however there was an error on their site so I am not sure what else would be available. I am running IIS 5 on a Windows platform. TIA! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Seeking some elementary SQL teachings?
Nick, 1. I think that I recently saw a posting in CFTalk that you can convert an existing DB by reading from Access and writing to SQL and/or MYSQL. I use mySQL and a product called mySQLFront (vers 2.5 - version 3 is a commercial product now).I often get excel spreadsheets of data, so a quick conversion into mySQL is excel -- Access -- mySQL.The Access to mySQL bit is done using the mySQLFront.mySQLFront has a ODBC import tool that allows you to connect to an Access database and import structures and data straight into a database set up in mySQL.There's not much else to tell you really its that easy. 2. The bigger unknown in my mind is the coding, i.e., just how much different is the coding? Coding differences.For the basics... Not much, as long as you haven't used access' feature of letting you do all sorts of naughty things like use reserved words for tables or columns, columns with spaces or strange characters. Assuming an illustration would simplest. What changes would need to be made to the following code to operate on SQL and/or MYSQL? CFQUERY NAME=GetRecords DATASOURCE=DB1 DBTYPE=ODBC SELECT * FROM Table1 WHERE ID = ID /CFQUERY CFQUERY NAME=ExtractData DATASOURCE=DB1 DBTYPE=ODBC SELECT * FROM Table1 WHERE ID = ID /CFQUERY Right well these two queries don't need the where id = id and you don't need the quotes around the tablenamesin either access or mysql, as long as you haven't used invalid SQL names for your tables that is. CFQUERY NAME=CreateTable DATASOURCE=DB1 DBTYPE=ODBC CREATE TABLE Table1 ( ID AUTOINCREMENT, Field1 TEXT (100), Field2 NUMBER (20) ) /CFQUERY CREATE TABLE `Table1` (`ID` INT (3) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, `Field1` VARCHAR (100), `Field2` INT (20) UNSIGNED DEFAULT '0', PRIMARY KEY(`ID`), INDEX(`ID`)) Except I've done some extra things like making ID the primary key and indexing it. Incidently, Access doesn't do an Number(20) only Number which I usually find translates to Int(11) CFQUERY NAME=AddCompletions DATASOURCE=DB1 insert into Table1 (Field1,Field2) values('#session.Variable1#', #session.Variable2#) /CFQUERY No change. Hope that helps Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]