Re: populating neighbourhood dropdown based on municipality chosen
Another solution which I like is from one of the _javascript_s in the following url: (I always like these!) http://www.mattkruse.com/_javascript_/ On a related note, I had to fix a version ofCF_TwoSelectsRelated as it doesnt work with Chinese characters. I can post the solution (a functoin) that converts the results into unicode for proper display on the second drop down box I hope that helps -- Mark Drew mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IsDefined(Array[element])
IsDefined doesn't work on array syntax. For arrays you have to use try/catch to see if the index exists in the array. Keep in mind that in CF, once a variable exists, it always has a value. Maybe you are thinking abaout empty strings when you say no value (although empty strings are a value). Then right after testing if the array index exists, check for the Len() IF it exists. You could make it into a function (look at http://www.cflib.org/udf.cfm/ArrayDefinedAt). -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: maandag 7 juni 2004 19:12 To: CF-Talk Subject: IsDefined(Array[element]) how to check is the array element is defined or not cfif IsDefined('lineout[#xyz#]') according to the coldfusion documentation it will always return false, no matter even the element has a value. what is the alternate way to see that the element has a value or undefined. thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating neighbourhood dropdown based on municipality chosen
WoW -- the goodies at http://www.mattkruse.com/_javascript_/are really fantastic -- thanks for sharing Mark... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion TechNote Notification: ColdFusion MX: Enabling verbos e web server connector logging
Check out the new TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/verbose_conn_loggi ng.htm Intro: When using an external web server with Macromedia ColdFusion MX, it's possible to enable verbose web server connector logging. The information that is logged with this feature can be useful when troubleshooting issues with the web server connector. This logging is available for ColdFusion MX Server configuration or ColdFusion MX in the J2EE configuration on JRun. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
checking if a table exists?
Is it possible and if so how to check if a table exists? I'm trying to add a automatic setup to my template, user specifies the DSN, and the template will look to see if the tables exist, and if they don't then create them with some basic entries..I've never created tables in CFM, but I assume CREATE TABLE will work? -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: MX2004 Tools and New OS X Update
Simeon, Your main issue is Permissions. you should try to run Repair Permissions again. also make sure that your account on the machine has Admin access (system preferences accounts security, it should say Admin under your account name). You most likely do have that type of access but just to make sure. If that does not work you will have to go to the terminal (Applications Utilities Terminal [it's the command line]). Once there type this command: sudo chown -R YourAccountName:staff /Applications/MacromediaDirectories/ You have to change YourAccountName to your account name (the *short name* under the System Pref / Accounts). And change MacromediaDirectories to the directory you have your MX stuff in. Do this for each directory. This will do no harm. Good luck! Ian - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Ian Sheridan [EMAIL PROTECTED] http://www.savagevines.com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - On Jun 7, 2004, at 10:11 PM, Jeff wrote: On 6/7/04 7:21 PM, Simeon Bateman [EMAIL PROTECTED] wrote: Has anybody else taken the update?Similiar problems?Anybody think they might have a solution?I know this is off topic but this is the biggest pool of Macromedia/OSX users i know of.None of my other applications are effected. Thanks for any help. simeon Hi Simeon. I came home today and installed the update on my Powerbook running 10.3.4, and I just checked, and all my Macromedia MX tools work. I'm able to open up each one...sorry, wish I could help, but I've installed the update, restarted, and everything is able to start okay... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: checking if a table exists?
Well, in CF you would and could make a call to the table name, but place it in a cftry block and getting the result try SELECT * FROM YOURTABLE catch your code to check if it exists /catch /try BUTyou are best to perform any checking in CF (assuming you are using SQL Server) DECLARE @vcUserTable varchar(500) SET @vcUserTable = 'mychosentablename' IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = @vcUserTable) BEGIN SELECT 'TRUE' -- PRINT 'TRUE' -- this will be ok END ELSE BEGIN SELECT 'FALSE' -- PRINT 'FALSE' END GO Adding this into an SP will be a doddle and you can use it anywhere... HTH N _ From: techmike [mailto:[EMAIL PROTECTED] Sent: 08 June 2004 13:21 To: CF-Talk Subject: checking if a table exists? Is it possible and if so how to check if a table exists? I'm trying to add a automatic setup to my template, user specifies the DSN, and the template will look to see if the tables exist, and if they don't then create them with some basic entries..I've never created tables in CFM, but I assume CREATE TABLE will work? -mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: checking if a table exists?
Is it possible and if so how to check if a table exists? Depending on the database but in MSSQL is: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[que_log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[que_log] GO AND in MySQL it is; DROP TABLE IF EXISTS que_log; Hope that helps -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Replacing strings as part of a query
What database are you using? This sounds like something that would be best handled at the database level, instead of running it through CF. - Original Message - From: Richard Crawford Actually, my question about replacing special characters (thanks to all who answered, by the way) was part of a larger question.What I really need to do is select all rows of one table, modify the value of one field, and insert all of the rows, with that one modified field, into another table. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion TechNote Notification: Content length error posting f orms with ColdFusion MX on WebSphere
Check out the new TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/content_length_web sphere.htm http://www.macromedia.com/support/coldfusion/ts/documents/content_length_we bsphere.htm Intro: When submitting a form with Macromedia ColdFusion MX 6.1 running on IBM WebSphere version 5.0.2.2, 5.0.2.3, or 5.0.2.4, the following error will occur: post body contains less bytes than specified by content-length [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: checking if a table exists?
I would also go with your second option, but if the db doesn't allow it and you have to use try/catch don't do select *. It can possibly return a lot of info. You could use select count(*). In your catch use type=Database and try to find the correct errorcode for a non-existing table. Pascal -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: dinsdag 8 juni 2004 14:27 To: CF-Talk Subject: RE: checking if a table exists? Well, in CF you would and could make a call to the table name, but place it in a cftry block and getting the result try SELECT * FROM YOURTABLE catch your code to check if it exists /catch /try [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: checking if a table exists?
From: Mark Drew Depending on the database but in MSSQL is: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[que_log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[que_log] GO Why not use INFORMATION_SCHEMA.TABLES rather than sysobjects If exists (select * from INFORMATION_SCHEMA.TABLES where table_name = 'YourTable') Much more readable [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: checking if a table exists?
It can possibly return a lot of info. If you are doing a select (with a try catch) you can do SELECT * FROM table WHERE 1=2 Hope that helps Mark Drew -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
restricting access by IP address
Hi all how to restrict access for my apps based on IP Address? How to restrict access for only IP address like: 192.168.200.3, 192.168.200.7, 192.168.200.11? It's possible? How? Application.cfm? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: restricting access by IP address
Hi there, this is usually carried out with the webserver rather than Application.cfm as if you needed to change it you would have to recode it. Having said that you could add something at the top of APplication.cfm along the lines of cfset lAuthIps = 192.168.200.3,192.168.200.7,192.168.200.11 cfif ListFind(lAuthIps , CGI.REMOTE_ADDR) EQ 0 You are not allowed here cfabort /cfif Hope that helps On Tue, 08 Jun 2004 09:53:56 -0300, Spectrum WebDesign [EMAIL PROTECTED] wrote: Hi all how to restrict access for my apps based on IP Address? How to restrict access for only IP address like: 192.168.200.3, 192.168.200.7, 192.168.200.11? It's possible? How? Application.cfm? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: restricting access by IP address
Is that easy to go by? is it secure to do that or it would be easy to find a work around? Pat _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: June 8, 2004 09:07 To: CF-Talk Subject: Re: restricting access by IP address Hi there, this is usually carried out with the webserver rather than Application.cfm as if you needed to change it you would have to recode it. Having said that you could add something at the top of APplication.cfm along the lines of cfset lAuthIps = 192.168.200.3,192.168.200.7,192.168.200.11 cfif ListFind(lAuthIps , CGI.REMOTE_ADDR) EQ 0 You are not allowed here cfabort /cfif Hope that helps On Tue, 08 Jun 2004 09:53:56 -0300, Spectrum WebDesign [EMAIL PROTECTED] wrote: Hi all how to restrict access for my apps based on IP Address? How to restrict access for only IP address like: 192.168.200.3, 192.168.200.7, 192.168.200.11? It's possible? How? Application.cfm? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: restricting access by IP address
You could use something like cfif #CGI.REMOTE_ADDR# is 196.168.0.3 whatever /cfif Not exactally how secure that would be..I'm still learning here..:) -Original Message- From: Spectrum WebDesign [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tue, 08 Jun 2004 09:53:56 -0300 Subject: restricting access by IP address Hi all how to restrict access for my apps based on IP Address? How to restrict access for only IP address like: 192.168.200.3, 192.168.200.7, 192.168.200.11? It's possible? How? Application.cfm? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: restricting access by IP address
you sure could. there are myriad ways to accomplish, prolly a few less ways to get around it or spoof it, but would be a fairly good first layer of sec. is this to protect an intranet or something? tw -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 9:15 AM To: CF-Talk Subject: Re: restricting access by IP address You could use something like cfif #CGI.REMOTE_ADDR# is 196.168.0.3 whatever /cfif Not exactally how secure that would be..I'm still learning here..:) -Original Message- From: Spectrum WebDesign [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tue, 08 Jun 2004 09:53:56 -0300 Subject: restricting access by IP address Hi all how to restrict access for my apps based on IP Address? How to restrict access for only IP address like: 192.168.200.3, 192.168.200.7, 192.168.200.11? It's possible? How? Application.cfm? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: restricting access by IP address
From: Spectrum WebDesign how to restrict access for my apps based on IP Address? How to restrict access for only IP address like: 192.168.200.3, 192.168.200.7, 192.168.200.11? It's possible? How? Application.cfm? In Application.cfm you could list all of the relevant IP addresses, then if the current address isn't there, display a not authorized and CFABORT [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: checking if a table exists?
That is a good point Phil.It is better practice to use INFORMATION_SCHEMA.TABLES as there is no guarantee that the sysobjects table code will always work From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: 08 June 2004 13:54 To: CF-Talk Subject: RE: checking if a table exists? From: Mark Drew Depending on the database but in MSSQL is: if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[que_log]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[que_log] GO Why not use INFORMATION_SCHEMA.TABLES rather than sysobjects If exists (select * from INFORMATION_SCHEMA.TABLES where table_name = 'YourTable') Much more readable [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: restricting access by IP address
My approach was the opposite but the implementation would work. I needed to ban IPs from my blog. cfquery datasource=#ATTRIBUTES.datasource# name=qCheckForBannedIPs SELECT IP FROM BANNEDLIST WHERE IP = '#CGI.REMOTE_ADDR#' /cfquery CFIF qCheckForBannedIPs.Recordcount GT 0 CFSET VARIABLES.Banned = 1 CFELSE CFSET VARIABLES.Banned = 0 /CFIF _ From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 5:54 AM To: CF-Talk Subject: restricting access by IP address Hi all how to restrict access for my apps based on IP Address? How to restrict access for only IP address like: 192.168.200.3, 192.168.200.7, 192.168.200.11? It's possible? How? Application.cfm? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: restricting access by IP address
IP Spoofing is easy, I would also add a secure login depends on how much effort is required and how sensitive the data is you REALLY could go to town,I hear there are some nice fingerprint reading tools out there too! Up to you, usually secure enough for most applications Hope that helps! On Tue, 8 Jun 2004 09:15:27 -0400, Tony Weeg [EMAIL PROTECTED] wrote: you sure could. there are myriad ways to accomplish, prolly a few less ways to get around it or spoof it, but would be a fairly good first layer of sec. is this to protect an intranet or something? tw -Original Message- From: techmike [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 9:15 AM To: CF-Talk Subject: Re: restricting access by IP address You could use something like cfif #CGI.REMOTE_ADDR# is 196.168.0.3 whatever /cfif Not exactally how secure that would be..I'm still learning here..:) -Original Message- From: Spectrum WebDesign [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tue, 08 Jun 2004 09:53:56 -0300 Subject: restricting access by IP address Hi all how to restrict access for my apps based on IP Address? How to restrict access for only IP address like: 192.168.200.3, 192.168.200.7, 192.168.200.11? It's possible? How? Application.cfm? Thanx for your time. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: restricting access by IP address
IP Spoofing is easy, I would also add a secure login While I'd recommend a secure login as well, I would take issue with your statement that IP spoofing is easy. It is not easy, to the best of my knowledge, to send a message to a web server that says you're using one IP address and have it respond to your actual IP address, which would be necessary to circumvent IP address restrictions within your application or within the web server. http://www.iss.net/security_center/advice/Underground/Hacking/Methods/Techni cal/Spoofing/default.htm 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]
Slightly OT: Help with CF/IIS
Any thoughts would be greatly appreciated: I know you can use host headers with IIS to serve 2 domains with one IP. Can you map a subdomain to the same IP as the root domain entry, and have the same IIS web site/application server the same files for both domain names? I assume this is the default behavior. For example DNS entry: www.mydomain.com = 123.45.678.99 DNS entry: sub1.mydomain.com = 123.45.678.99 Will IIS just serve the same pages, regardless of the requested host name, because they are mapped to the same IP? Thanks for guidance here! -- Alex Sherwood PHS Collection Agency THE COLLECTORS P:813-283-4579 F:301.664.6834 W: www.phs-net.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
BlueDragon : CFFILE
Hi all, I'm developping a littl something on BD with the internal webserver and when I upload a file with the cffile upload it's telling me that the destination directory does'nt exist... it was working fine under CF5... Does anyone has an idea? Thanks Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: checking if a table exists?
techmike wrote: Will that work in MySql as well as MSSQL? No, MySQL doesn't support schema's. It will work in PostgreSQL though, and I think you can download a SQL script to add information_schema support to Oracle. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
WDDX Insanity
I have a wddx that I'm trying to turn back into a CFML structure. The wddx looks fine. It CFDUMP's nicely as well. But whenever I try to turn it back to CFML, I get: WDDX packet parse error at line 1, column 1. The markup in the document preceding the root element must be well-formed. Is there something painfully obvious that I'm missing? Thanks, Rich [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: checking if a table exists?
From: techmike Will that work in MySql as well as MSSQL? No - INFORMATION_SCHEMA is a MSSQL feature [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: WDDX Insanity
At 10:16 AM 6/8/2004, you wrote: I have a wddx that I'm trying to turn back into a CFML structure. The wddx looks fine. It CFDUMP's nicely as well. But whenever I try to turn it back to CFML, I get: WDDX packet parse error at line 1, column 1. The markup in the document preceding the root element must be well-formed. Is there something painfully obvious that I'm missing? Post the whole WDDX packet here [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: restricting access by IP address
It is rather hard to spoof an ip address, while it is relatively easy to spoof the domain name you are coming from. This is why you can take out spamers based on the IP addresses they are using to spam you but not the domain names they are using (the use whatever they like all the time). TK -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:13 AM To: CF-Talk Subject: RE: restricting access by IP address IP Spoofing is easy, I would also add a secure login While I'd recommend a secure login as well, I would take issue with your statement that IP spoofing is easy. It is not easy, to the best of my knowledge, to send a message to a web server that says you're using one IP address and have it respond to your actual IP address, which would be necessary to circumvent IP address restrictions within your application or within the web server. http://www.iss.net/security_center/advice/Underground/Hacking/Methods/Techni cal/Spoofing/default.htm 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: checking if a table exists?
Philip Arnold wrote: From: techmike Will that work in MySql as well as MSSQL? No - INFORMATION_SCHEMA is a MSSQL feature The INFORMATION_SCHEMA is not a MS SQL Server specific feature, it comes straight from the SQL standard. MySQL is just not very compliant. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Trying to solve slow Stored Proc
Okay I'm at a loss here and any suggestions / help is greatly appreciated. If I run the SP code through SQL+ it will return records almost instantly (we're talking only 350 records returned here), but via the CF code the server (web) will either hang FOREVER or return the statement that the server is busy. SERVER: - Compaq Proliant (not sure of the model I don't have access to the server) - WIN 2000 - Over 1gig memory - dual processor - CF5 Ent Database: - Unix - Oracle 9i - not sure about the rest but I can find out if necessary (again I don't have access to the room containing the servers) Here's the CF Code: cfstoredproc procedure=pkg_analysis.getGridAnswers datasource=#mysession.dcname# blockfactor=20 cfprocparam type=In maxlength=10 cfsqltype=CF_SQL_INTEGER value=#session.currentbase# cfprocparam type=In maxlength=10 cfsqltype=CF_SQL_INTEGER value=#bq2.questionid# cfprocparam type=In maxlength=10 cfsqltype=CF_SQL_INTEGER value=#URL.afid# !--- CF5 adds an ascii value of 0 (not the digit 0, but the ascii value of 0) to string parameters.It needs to be stripped off inside Oracle. --- cfprocparam type=In cfsqltype=CF_SQL_LONGVARCHAR value=#URL.searchvalue# maxlength=4000 !--- this CF_SQL_REFCURSOR only works for cf5 and causes errors in MX --- cfif left(mysession.cfProductVersion,1) LT 6 !--- had to pull this out of because it doesn't compile on CF/MX --- cfprocparam type=Out cfsqltype=CF_SQL_REFCURSOR variable=Yo2 maxrows=-1 /cfif cfprocresult name=analysisgridanswers /cfstoredproc And here's the SP code: CREATE OR REPLACE PACKAGE BODY pkg_analysis AS PROCEDURE getGridAnswers (pi_OrgIdINsafiebsec.org.orgid%TYPE ,pi_Questionid INquestion.questionid%TYPE ,pi_AnswerfieldId INanswerfield.answerfieldid%TYPE ,pi_AnswerINbaseanswerfield.answer%TYPE ,pio_arg_CursorIN OUT analysis_ref_cursor ) IS v_answer baseanswerfield.answer%TYPE := RTRIM(pi_answer,CHR(0)); BEGIN OPEN pio_arg_Cursor FOR SELECT bq.orgid ,ba.baseanswerid ,af.answerfieldorder ,baf.gridrowid ,baf.gridrow ,SUBSTR(baf.answer,1,128) answer ,baf.baseanswerfieldid ,DECODE(LENGTH(SUBSTR(baf.ANSWER,1,129)),129, 1, NULL) overflow ,sc.statuscolor ,sc_cmdlevel.statusnamecmdlevel_statusname ,sc_cmdlevel.statuscolor cmdlevel_statuscolor --,PKG_ANALYSIS.ROW_HAS_THIS_VALUE(baf.baseanswerid,pi_answerfieldid,baf.gridrowid,pi_answer) hasvalue --,length(pi_answer) lenans --,ascii(substr(pi_answer,5,1)) asciians --,LPAD(LTRIM(TO_CHAR(bq.orgid)),10,'0') || '.' || baf.gridrowsortvalue FROM basequestion bq ,baseanswerba ,baseanswerfield baf ,answerfieldaf ,statuscodesc ,statuscodesc_cmdlevel ,basestatusbs WHERE bq.orgidIN (SELECT orgid FROM orgvw START WITH orgid = pi_orgid CONNECT BY PRIOR orgid = parentorgid) AND bq.questionid= pi_questionid AND bq.basequestionid = ba.basequestionid AND ba.baseanswerid= PKG_VALGRID.GET_LATEST_BA(bq.basequestionid) AND PKG_ANALYSIS.ROW_HAS_THIS_VALUE(baf.baseanswerid,pi_answerfieldid,baf.gridrowid,v_answer) = 'Y' AND ba.baseanswerid= baf.baseanswerid AND baf.answerfieldid = af.answerfieldid AND bq.statuscodeid= sc.statuscodeid AND bq.orgid = bs.orgid AND bq.datacall = bs.datacall AND 'CMDLEVEL'= sc_cmdlevel.usedby AND bs.cmdlevel = sc_cmdlevel.statusname UNION ALL SELECT bq.orgid ,TO_NUMBER(NULL) ,af.answerfieldorder ,TO_NUMBER(NULL) ,TO_CHAR(NULL) ,' ' ,TO_NUMBER(NULL) ,NULL ,sc.statuscolor ,sc_cmdlevel.statusnamecmdlevel_statusname ,sc_cmdlevel.statuscolor cmdlevel_statuscolor FROM basequestion bq ,answerfieldaf ,statuscodesc ,org o ,statuscodesc_cmdlevel ,basestatusbs WHERE bq.orgidIN (SELECT orgid FROM orgvw START WITH orgid = pi_orgid CONNECT BY PRIOR orgid = parentorgid) AND bq.questionid= pi_questionid AND bq.orgid = o.orgid AND bq.orglevelname= 'Base' AND PKG_VALGRID.GET_LATEST_BA(bq.basequestionid) IS NULL AND bq.questionid= af.questionid AND bq.statuscodeid= sc.statuscodeid AND bq.orgid = bs.orgid AND bq.datacall = bs.datacall AND 'CMDLEVEL'= sc_cmdlevel.usedby AND bs.cmdlevel = sc_cmdlevel.statusname ORDER BY 1,5,4,3 ; END; FUNCTION row_has_this_value (pi_baseansweridINbaseanswer.baseanswerid%TYPE ,pi_answerfieldid INanswerfield.answerfieldid%TYPE ,pi_gridrowidINbaseanswerfield.gridrowid%TYPE ,pi_answerINbaseanswerfield.answer%TYPE ) RETURN VARCHAR2 -- Y or N IS return_value VARCHAR2(1) := 'N'; CURSOR chk_value IS SELECT 'Y' FROM baseanswerfield baf WHERE baf.baseanswerid= pi_baseanswerid AND baf.answerfieldid = pi_answerfieldid AND (baf.gridrowid = pi_gridrowid OR (baf.gridrowid IS NULL AND pi_gridrowid IS NULL)) AND (baf.answer LIKE pi_answer OR (baf.answer IS NULL AND pi_answer IS NULL)) ; BEGIN IF pi_answerfieldid IS NULL OR pi_answerfieldid = 0 THEN return_value := 'Y'; ELSE OPENchk_value; FETCH chk_value INTO return_value; CLOSE chk_value; END IF; RETURN return_value; END; END; / Thanks in advance, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Oracle Equivalent to @@Identity?
Does anyone know if Oracle has an eqivalent to @@Identity in SQL Server? Thanks for the help Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher Pilles.vcf [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle Equivalent to @@Identity?
I think you just have to select nextval or currval from the sequence you're interested in. -Original Message- From: Kristopher Pilles [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:49 AM To: CF-Talk Subject: Oracle Equivalent to @@Identity? Does anyone know if Oracle has an eqivalent to @@Identity in SQL Server? Thanks for the help Kristopher Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] Kristopher Pilles.vcf [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Trying to solve slow Stored Proc
Run your query through SQL+ using different optimizer hints like so: select /*+ CHOOSE */ column from table etc etc select /*+ RULE */ column from table etc etc It could be that ColdFusion is using a different default hint than Oracle is. -Original Message- From: Semrau Steven Ctr SAF/IE Sent: Tuesday, June 08, 2004 10:49 AM To: CF-Talk Subject: Trying to solve slow Stored Proc Okay I'm at a loss here and any suggestions / help is greatly appreciated. If I run the SP code through SQL+ it will return records almost instantly (we're talking only 350 records returned here), but via the CF code the server (web) will either hang FOREVER or return the statement that the server is busy. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: checking if a table exists?
From: Jochem van Dieten The INFORMATION_SCHEMA is not a MS SQL Server specific feature, it comes straight from the SQL standard. MySQL is just not very compliant. Wow, I didn't know this - I've not seen it in all SQL apps, so I thought it was MSSQL Strange that something MS has and others hasn't, yet it's a standard g [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: connect to a network db, and log on account - XP
I appreciate your taking time to answer but, sorry, I have absolutely no idea what any of that means. What is a Domain Environment? What does create an account in the domain mean? What is a resource provider? How do you create a local user on the CF server? I'm on XP as noted. I don't use any account or password. (Or maybe I do and it starts automatically, I have no idea. How would I even check?) The db is on another computer. I try to access it using that computer's name and the shared folder name (just as I would enter in windows Exporer to get there) but it won't work in the cf admin without error. If you could explain in plain English more along the lines of Click x, write y in the field named z etc., it would be much appreciated. Unfortunately, if you want to manage servers, you'll need some knowledge of the operating system and general environment to manage them effectively, or even to understand how to start looking for solutions to problems you're having. That said, I'll take a crack at answering your questions. First, whenever you do anything in Windows NT/2000/XP/2003, you are using an account and password, whether you know it or not. Every process within Windows runs within a specific user account or security context. Your XP machine is configured to log you in automatically, which is why you don't have to log in manually. Everything within Windows relies on user rights, however. Every file has permissions set upon it, every registry key has permissions, and so on. Every time a program attempts to use a file, the operating system checks the permissions of the file before allowing the program to continue. Second, the CF server runs as a service. Services are Windows programs that run independently of the desktop. They typically start when the machine itself is started. Each service runs within a specific user account or security context (a security context is kind of like a generic user account). By default, most services run as SYSTEM, which is a security context that corresponds to the operating system itself. This SYSTEM account has rights to do practically anything on the machine, but doesn't have any rights to access network resources. If you want CF to be able to access network resources, you'll need to run it within a user account that has appropriate rights to those resources, as well as appropriate rights to whatever local files and resources it needs. Third, when one Windows machine can access another's shares or printers, this is done through Windows Networking. There are two ways Windows Networking can be configured. Windows machines can be part of a workgroup, which is really just an arbitrary collection of machines who choose to use the same workgroup name, or they can be part of a domain. A domain is a managed environment consisting of one or more domain controllers which are in charge of managing domain user accounts, and any number of domain members, whose resources may be available to those user accounts. Domains have their own user accounts, which can be used at any domain member to log into the domain itself. Once logged into the domain, an account will typically have preassigned rights to domain shares and the like. Domains make it easy to create user accounts with rights to many machines' shares at once - this is a bit more difficult in a workgroup. Even within a domain, though, each machine has its own local user accounts as well, and the SYSTEM account on each machine won't have any rights to domain resources on other machines. It sounds to me like you don't have a domain, though. The easiest way to solve your immediate problem - although not necessarily the best way - would be to create a new account within the Administrators group on the machine running CF and configure CF to run within this account, and to create an account with the same username and password on the other machine hosting the database, and to make sure that this account has rights to access the files in question. Here are the steps to configure CF to run as a local user within the Administrators group: 1. From the machine running CF, open a command prompt. 2. Type compmgmt.msc and press Enter. 3. Select the Users folder within Local Users and Groups. 4. Go to the Action menu and select New User. 5. Type in the new username and password, and clear the User must change password at next logon checkbox. 6. Check the User cannot change password and Password never expires checkboxes. 7. Close this dialog, then right-click on the new user and select Properties. 8. Click on the Member Of tab, click on the Add... button and add Administrators. 9. At the bottom of the Computer Management interface, click the plus sign in front of Services and Applications. 10. Click on Services. 11. Find the CF server service - the name of this service will vary depending on how you installed CF. 12. Right-click on the service and select Properties. 13. Click on the Log On tab, and enter the
MySQL question
Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Trying to solve slow Stored Proc
Can you see the server logs? What's happening? Is a connection being made to Oracle? What about the oracle logs? Can your DBA see what's happening on that side? - Original Message - From: Semrau Steven Ctr SAF/IE Okay I'm at a loss here and any suggestions / help is greatly appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
You can get all your mysql needs over at http://www.mysql.com I like the applicatoin but you MUST remember that it is mainly command line based. 1) get yourself the applicatoin install it 2) go to c:\mysql\bin and run the mysql admin, this will install it as a service You can do a lot of funky things with mySQL but what you cannot do (yet) is views and store procedures There are a lot of things right and wrong, but for a free bit of kit... it is very nice just my opinions On Tue, 8 Jun 2004 10:04:21 -0500, Eric Creese [EMAIL PROTECTED] wrote: Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Slightly OT: Help with CF/IIS
I know you can use host headers with IIS to serve 2 domains with one IP. Can you map a subdomain to the same IP as the root domain entry, and have the same IIS web site/application server the same files for both domain names? I assume this is the default behavior. For example DNS entry: www.mydomain.com = 123.45.678.99 DNS entry: sub1.mydomain.com = 123.45.678.99 Will IIS just serve the same pages, regardless of the requested host name, because they are mapped to the same IP? The short answer is yes, you can do this with IIS. If you don't specify any host header requirements at all within IIS, any requests to that IP address will be handled the same way by IIS. Alternatively, you can specify multiple host headers for a single IIS virtual server. It's worth pointing out that this doesn't have anything to do with subdomains. I'm pretty sure that you can specify whatever host header string you like within IIS, and as long as a request to the IP address of the virtual server contains a Host header with that string, IIS will process it. For example. I could create a host header string within IIS: foo.bar.baz, and as long as any HTTP request contained the line Host: foo.bar.baz, IIS would respond normally. Of course, most nameservers won't know what to do with a baz TLD, so you probably wouldn't want to do that in real life. 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: MySQL question
Eric Creese wrote: First where do I get a copy of MySQL http://www.google.com/search?q=download+mysql and second any pitfalls I need to be concerned about? Not if you read the manual 3 times from cover to cover. But else: http://sql-info.de/mysql/gotchas.html Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Still No Luck
Well I appreciate all of you help and comments.I am still unable to connect to those tools. For anyone who is listening, I have run the Repair Permission and I have checked my persmissions on those directories and and files and all are well.I know how to check permissions but I thought what the heck and i reset them anyway.I am an admin, but none of those things seem to be enough. So I guess here is my next question.Who's support line do i call.Apple because it was thier security patch, or Macromedia becuase its only their products that dont work? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Slightly OT: Help with CF/IIS
At 11:16 AM 6/8/2004, you wrote: I know you can use host headers with IIS to serve 2 domains with one IP. Can you map a subdomain to the same IP as the root domain entry, and have the same IIS web site/application server the same files for both domain names? I assume this is the default behavior. For example DNS entry: www.mydomain.com = 123.45.678.99 DNS entry: sub1.mydomain.com = 123.45.678.99 Will IIS just serve the same pages, regardless of the requested host name, because they are mapped to the same IP? It's worth pointing out that this doesn't have anything to do with subdomains. I'm pretty sure that you can specify whatever host header string you like within IIS, and as long as a request to the IP address of the virtual server contains a Host header with that string, IIS will process it. For example. I could create a host header string within IIS: foo.bar.baz, and as long as any HTTP request contained the line Host: foo.bar.baz, IIS would respond normally. Of course, most nameservers won't know what to do with a baz TLD, so you probably wouldn't want to do that in real life. Gotcha. Most of the docs as MS were configuring different hosts to feed off the same IP. I dig deeper and found the docs on giving 1 IIS virtual site multiple identities. I have to say, MS has done a good job of enhancing their search and organizing KB articles! Thanks for your help, Dave. -- Alex Sherwood 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: MySQL question
If I were you, I would test/develop on the Linux machine right from the start. - Original Message - From: Eric Creese To: CF-Talk Sent: Tuesday, June 08, 2004 11:04 AM Subject: MySQL question Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Still No Luck
I'd try this hotfix first: http://www.macromedia.com/support/service/ts/documents/mac_archive_install.h tm http://www.macromedia.com/support/service/ts/documents/mac_archive_install. htm (Apple's update/archive-install processes have been known to cause some issues) ... and if that doesn't help get you up and running, then yes- definitely contact MM tech support directly, as they'll want to look into it further. HTH! - Scott scott fegette macromedia, inc. http://www.macromedia.com/go/blog_sfegette http://www.macromedia.com/go/blog_sfegette _ From: Simeon Bateman [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 8:15 AM To: CF-Talk Subject: Still No Luck Well I appreciate all of you help and comments.I am still unable to connect to those tools. For anyone who is listening, I have run the Repair Permission and I have checked my persmissions on those directories and and files and all are well. I know how to check permissions but I thought what the heck and i reset them anyway.I am an admin, but none of those things seem to be enough. So I guess here is my next question.Who's support line do i call.Apple because it was thier security patch, or Macromedia becuase its only their products that dont work? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFX_JSpellCheck CFMX in a J2EE Configuration
Ok I found some documentation on Macromedia on how to load the class path into the JMC. I did set it to: C:\\CFusion\\CFX_Tags\\CFX_JSpellCheck\\CFX_JSpellCheck.jar Then I stopped all JRun services (servers), had to modify the jvm.config based on the TechNote on Macromedia: http://www.macromedia.com/support/coldfusion/ts/documents/server_jvm_arg.htm (watch the WRAP) Made the change and restarted all JRun services, but I still get the following: Error processing CFX custom tag quot;CFX_JSpellCheckquot;. The CFX custom tag CFX_JSpellCheck was not found in the custom tag database. Please be sure to add custom tags to the database before using them. If you have added your tag to the database then you should check the spelling of the tag within your template to insure that it matches the database entry Any ideas on this and how to go about resolving it? This does not happen in the other configuration on one of the other boxes. I am trying to resolve it rather than unsintalling and re-installing. TIA!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Oracle Mutating Table
Sorry for off topic but this is the only list i am on. I am having a problem with oracle's mutating table error.All I want to do is, ON BEFORE UPDATE, Check the number of rows in the table being updated. If the number of rows is 0 set the :New.DateZero to the sysdate.Does anyone know a simple way around this? Tyler Clendenin GSL Solutions [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_JSpellCheck CFMX in a J2EE Configuration
Ok I found some documentation on Macromedia on how to load the class path into the JMC. I did set it to: C:\\CFusion\\CFX_Tags\\CFX_JSpellCheck\\CFX_JSpellCheck.jar Then I stopped all JRun services (servers), had to modify the jvm.config based on the TechNote on Macromedia: http://www.macromedia.com/support/coldfusion/ts/documents/serv er_jvm_arg.htm (watch the WRAP) Made the change and restarted all JRun services, but I still get the following: Error processing CFX custom tag quot;CFX_JSpellCheckquot;. The CFX custom tag CFX_JSpellCheck was not found in the custom tag database. Please be sure to add custom tags to the database before using them. If you have added your tag to the database then you should check the spelling of the tag within your template to insure that it matches the database entry I'm pretty sure you'll still have to enter the CFX tag in the CF Administrator, in addition to putting the JAR in the classpath. 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: help for the speed of this query?
John Ho [EMAIL PROTECTED] 06/07/2004 11:11 AM Please respond to cf-talk To:CF-Talk [EMAIL PROTECTED] cc: Subject:Re: help for the speed of this query? Dov Katz wrote: size(a) x size(b) x size(C) x size(D) x size(E) and only then does it start restricting the results using the WHERE clause I was reading Joe Celko's chapters on trees/hierarchies last week and one small point stuck -- Celko states that performance diminishes when querying 5 or more tables ... now I have a better understanding why (cartesian product). btw, the Celko books are well worth the time/money! http://www.celko.com/books.htm) Also, I just ran a test against a 'normalized' table (setup like 1-1-1-1-1-1-many...) cfquery name=test datasource=#application.dsn# SELECT ObjectivesMaster.Objective, ObjectivesXref.LangId, ObjectivesXref.TrackId, ObjectivesXref.CategoryId, ObjectivesXref.GroupId, ObjectivesXref.TaskId, ObjectivesXref.ObjectiveId, ObjectivesXref.ListOrder, ObjectivesXref.Notes FROM ObjectivesMaster, ObjectivesXref WHERE ObjectivesXref.LangId = #t# AND ObjectivesXref.TrackId = #u# AND ObjectivesXref.CategoryId = #v# AND ObjectivesXref.GroupId = #w# AND ObjectivesXref.TaskId = #x# /cfquery This took about 200 milliseconds on my 'average' laptop (1 ghz/256mb) running ms access. Currently there are about 7000 records in this ...Xref table and when it goes into production, this particular table will grow to 20K records (or more... and hopefully leveling off before it hits 6 figures!). The target DB is to be Oracle 9i once we fill out more paperwork than a pentagon lawyer (and undergo the interrogation of the IT security analysts ;) I've had the opportunity to rebuild this structure from scratch and have tried to embrace 'normalization' concepts for 2 basic reasons: 1) tighter/easier code and 2) SPEED! I hope some of this is helpful, -mike John Ho wrote: yeah I use either join or innter join like you. And both has same speed 6second. try this: select distinct myFields from (((A inner join B on B.ID=A.ID) inner join C on C.ID=A.ID) inner JOIN D on D.ID=A.ID) inner join E on E.ID=A.ID [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle Mutating Table
Have you tried doing an after trigger, looking for 1 row? - Original Message - From: Tyler Clendenin Sorry for off topic but this is the only list i am on. I am having a problem with oracle's mutating table error.All I want to do is, ON BEFORE UPDATE, Check the number of rows in the table being updated. If the number of rows is 0 set the :New.DateZero to the sysdate.Does anyone know a simple way around this? Tyler Clendenin GSL Solutions [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
Does it come with a SQL interface like Query analyzer or SQL Plus? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: restricting access by IP address
IP Spoofing is easy.I've tested it and spoofed IP's using just CFML as the spoofing client.You can send a request to a server from your IP and your IP goes into the TCP/IP packet but can send a different IP in the HTTP request as a CGI variable.None of IIS, iPlanet. or JWS test if the TCP/IP supplied address is the same as the HTTP CGI address. http://www.rewindlife.com/archives/000159.cfm The link you provided talks about router level (tcp/ip) address spoofing but it's sufficient to just provide a CGI variable in the HTTP packet to spoof IP address. IP based security at web server/web app level is not safe (router level is much safer). Best regards, Sam -- Blog:http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:13 AM To: CF-Talk Subject: RE: restricting access by IP address IP Spoofing is easy, I would also add a secure login While I'd recommend a secure login as well, I would take issue with your statement that IP spoofing is easy. It is not easy, to the best of my knowledge, to send a message to a web server that says you're using one IP address and have it respond to your actual IP address, which would be necessary to circumvent IP address restrictions within your application or within the web server. http://www.iss.net/security_center/advice/Underground/Hacking/Methods/Techni cal/Spoofing/default.htm Dave Watts, CTO, Fig Leaf Software [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
I thought My SQL is free? I can not seem to find a free download on their site. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:08 AM To: CF-Talk Subject: Re: MySQL question You can get all your mysql needs over at http://www.mysql.com I like the applicatoin but you MUST remember that it is mainly command line based. 1) get yourself the applicatoin install it 2) go to c:\mysql\bin and run the mysql admin, this will install it as a service You can do a lot of funky things with mySQL but what you cannot do (yet) is views and store procedures There are a lot of things right and wrong, but for a free bit of kit... it is very nice just my opinions On Tue, 8 Jun 2004 10:04:21 -0500, Eric Creese [EMAIL PROTECTED] wrote: Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
Does it come with a SQL interface like Query analyzer or SQL Plus? The included interface is a command line one like iSQL (if you know it) having said that (and I posted about his before) check out the php administration for mysql . very powerful and has a lot of very handy features http://www.phpmyadmin.net/home_page/. You will also be able to find a gui for it to run on windows from http://www.mysql.com I hope this helps Regards -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help for the speed of this query?
[EMAIL PROTECTED] wrote: size(a) x size(b) x size(C) x size(D) x size(E) and only then does it start restricting the results using the WHERE clause Probably, but we don't know that before we see the query execution plan, which John still hasn't sent. But if it does, you might want to force the planner to push the restrictions down in the tree: SELECT DISTINCT A.id, B.w, C.x, D.y, E.z FROM A, (SELECT DISTINCT w FROM B) AS B, (SELECT DISTINCT x FROM C) AS C, (SELECT DISTINCT y FROM D) AS D, (SELECT DISTINCT z FROM E) AS E WHERE A.ID = B.ID AND A.ID = C.ID AND A.ID = D.ID AND A.ID = E.ID; I was reading Joe Celko's chapters on trees/hierarchies last week and one small point stuck -- Celko states that performance diminishes when querying 5 or more tables ... now I have a better understanding why (cartesian product). That very much depends on whether the query can be optimized and how smart the optimizer is. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IMAP in ColdFusion?
I am considering trying to build a webmail interface using IMAP, but as far as I can tell, my only option for accessing my IMAP server using CF would be through a CFX or Java (which I am not too familiar with).I looked at the exchange and saw 2 IMAP CFX tags.One was from the creator of CFX_POP3, and costs $75.The other was free and was called CFX_mIMAP.Does anyone have experience with either of these?Also, I believe I heard some rumor about the possibility of built-in IMAP support in the next CF release.While I know that no one can say for sure if it will be there or not, is it true that this is a goal?I'd hate to spend $75 if I can wait it out a little bit and have it included in CF.Your thoughts would be appreciated. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
FW: Question about Licensing my CF Web Application
Thank you!Rather than e-mail a thank you every time for all the wonderful feedback I got from you folks on my post yesterday, I wanted to just thank you all.I received some very good advice from many of you.I am still open to your feedback and any other ideas you may have regarding my situation below. Thanks again! Dave Phillips __ From: Dave Phillips Sent: Monday, June 07, 2004 10:05 AM To: '[EMAIL PROTECTED]' Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically. However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
thanks and I believe I found the download in the devloper section. I hope this is correct? -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:46 AM To: CF-Talk Subject: Re: MySQL question Does it come with a SQL interface like Query analyzer or SQL Plus? The included interface is a command line one like iSQL (if you know it) having said that (and I posted about his before) check out the php administration for mysql . very powerful and has a lot of very handy features http://www.phpmyadmin.net/home_page/. You will also be able to find a gui for it to run on windows from http://www.mysql.com I hope this helps Regards -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
http://dev.mysql.com/downloads/index.html I thought My SQL is free? I can not seem to find a free download on their site. -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_JSpellCheck CFMX in a J2EE Configuration
Dave, I have the CFX Tag registered within the CF Admin. That's the problem.. still not locating it.. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 11:39 AM To: CF-Talk Subject: RE: CFX_JSpellCheck CFMX in a J2EE Configuration Ok I found some documentation on Macromedia on how to load the class path into the JMC. I did set it to: C:\\CFusion\\CFX_Tags\\CFX_JSpellCheck\\CFX_JSpellCheck.jar Then I stopped all JRun services (servers), had to modify the jvm.config based on the TechNote on Macromedia: http://www.macromedia.com/support/coldfusion/ts/documents/serv er_jvm_arg.htm (watch the WRAP) Made the change and restarted all JRun services, but I still get the following: Error processing CFX custom tag quot;CFX_JSpellCheckquot;. The CFX custom tag CFX_JSpellCheck was not found in the custom tag database. Please be sure to add custom tags to the database before using them. If you have added your tag to the database then you should check the spelling of the tag within your template to insure that it matches the database entry I'm pretty sure you'll still have to enter the CFX tag in the CF Administrator, in addition to putting the JAR in the classpath. 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: Replacing strings as part of a query
Deanna Schneider wrote: What database are you using? This sounds like something that would be best handled at the database level, instead of running it through CF. Deanna, I'm using SQL Server 7.The problem is that the field with the characters to be replaced is a TEXT field, and you can't use the REPLACE function on a TEXT field.And, unfortunately, the data is too big in some of the records to CAST to VARCHAR. Here is the SQL that I've tried using: - select msgID, msgSent, msgFromType, msgFromID, msgSubject, REPLACE (CAST(msgMessage AS varchar(8000)), CHAR(13), 'BR') AS newMessage, msgOriginal, attID into tblMessageNew from tblMessage -- In records where the value of msgMessage is greater than 8000 characters, the SQL bombs and no results are returned. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
Eric, http://dev.mysql.com/downloads/mysql/4.0.html Scroll down to windows section and click on mirrors and then follow the prompts. That's version 4.0. Sincerely, Dave Phillips National Marketing Director Legacy for Life 615-746-3851 [EMAIL PROTECTED] From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:44 AM To: CF-Talk Subject: RE: MySQL question I thought My SQL is free? I can not seem to find a free download on their site. -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:08 AM To: CF-Talk Subject: Re: MySQL question You can get all your mysql needs over at http://www.mysql.com I like the applicatoin but you MUST remember that it is mainly command line based. 1) get yourself the applicatoin install it 2) go to c:\mysql\bin and run the mysql admin, this will install it as a service You can do a lot of funky things with mySQL but what you cannot do (yet) is views and store procedures There are a lot of things right and wrong, but for a free bit of kit... it is very nice just my opinions On Tue, 8 Jun 2004 10:04:21 -0500, Eric Creese [EMAIL PROTECTED] wrote: Have a client who needs their app developed using MySQL. I have never used it before. Anyway I need to get a copy of it and run it on Windows2000. Then When I am done developing I will be putting it on a Linux machine. First where do I get a copy of MySQL and second any pitfalls I need to be concerned about? Eric _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
popup from image
I have an image named edit and I would like to have it generate a popup when its clicked. I would like to pass a parameter with it as well. I've grabbed and edited a previous script I had (see below) but before I continue I was wondering if there were any good ideas out there please? Its all contained in the arraytest.cfm file. a href="" src="" alt=edit border=0/a CFIF isDefined(url.edit) here is the _javascript_ code I need to generate a popup with the passed parameter which corresponds to the record. /CFIF Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
You can user mysqlfront : www.mysqlfront.de Pat _ From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: June 8, 2004 11:38 To: CF-Talk Subject: RE: MySQL question Does it come with a SQL interface like Query analyzer or SQL Plus? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
IT is free http://dev.mysql.com/downloads/mysql/4.0.html == Our Anti-spam solution works!! http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com http://www.forta.com/cf/isp/isp.cfm?isp_id=1069 == - Original Message - From: Eric Creese To: CF-Talk Sent: Tuesday, June 08, 2004 10:44 AM Subject: RE: MySQL question I thought My SQL is free? I can not seem to find a free download on their site. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IMAP in ColdFusion?
I am considering trying to build a webmail interface using IMAP, but as far as I can tell, my only option for accessing my IMAP server using CF would be through a CFX or Java (which I am not too familiar with).I looked at the exchange and saw 2 IMAP CFX tags.One was from the creator of CFX_POP3, and costs $75.The other was free and was called CFX_mIMAP.Does anyone have experience with either of these?Also, I believe I heard some rumor about the possibility of built-in IMAP support in the next CF release.While I know that no one can say for sure if it will be there or not, is it true that this is a goal?I'd hate to spend $75 if I can wait it out a little bit and have it included in CF.Your thoughts would be appreciated. I believe DRK 6 (http://www.macromedia.com/software/drk/productinfo/product_overview/volume6/coldfusionmx.html) has a IMAP tag in it as well as those you've mentioned. That may be an option. As for waiting until Blackstone is released, I wouldn't wait for that, even if that feature is in there somewhere. I believe they have mentioned that it won't be out until some time in early to mid 2005. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
.Net list
There has been a call for a .Net list on HoF. A general .net list for technical talk only (ala CF-Talk) is currently set up at: http://www.houseoffusion.com/cf_lists/threads.cfm/44 Those who wish to join are welcome. If the list grows larger, then it may be split into sub-lists such as Asp.Net or C#.net. For those who wish to debate this decision or aspects of it, please post your comments to the CF-OT list. Thank you -- Michael Dinowitz House of Fusion http://www.houseoffusion.com Finding technical solutions to the problems you didn't know you had yet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IMAP in ColdFusion?
$75 isn't much to spend for a tag that adds this functionality if you need it.waiting it out seems like not such a great option since Blackstone isn't scheduled for release until some time next year (at least that's what I remember hearing, someone correct me if it's sooner). My $0.02. Sam -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 11:48 AM To: CF-Talk Subject: IMAP in ColdFusion? I am considering trying to build a webmail interface using IMAP, but as far as I can tell, my only option for accessing my IMAP server using CF would be through a CFX or Java (which I am not too familiar with).I looked at the exchange and saw 2 IMAP CFX tags.One was from the creator of CFX_POP3, and costs $75.The other was free and was called CFX_mIMAP.Does anyone have experience with either of these?Also, I believe I heard some rumor about the possibility of built-in IMAP support in the next CF release.While I know that no one can say for sure if it will be there or not, is it true that this is a goal?I'd hate to spend $75 if I can wait it out a little bit and have it included in CF.Your thoughts would be appreciated. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
WSCONFIG problem
Hi, I just installed CF MX 6.1 and tried to run wsconfig.exe to set up IIS. wsconfig cant find the Java Runtime Environment. I have done this several times before without any problem. The error message I get is: Error: could not find JRE Error: could not find Java 2 Runtime Environment. I tried editing the wsconfig_jvm.config file did not help either. Anyone out there know hoe to fix this? Kevin Roche [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help for the speed of this query?
I dont know why this query run with same speed 6second, doesn't matter when I use join or not. I am afraid I will have problem when this database becomes large. Currently if I do select distinct join of 5 tables I have around 1000 records and it runs about 6 seconds. I think it is slow. I have very fast machine. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: popup from image
Check out the reference:window.open One way it to have the JS on the same page and have the OnClick event call the function: function POPWin(myparam1,myparam2){ url = "" + myparam1 + param2= + myparam2; var newwin = window.open(url,MyNewWindow); } img src="" > something like that -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 11:54 AM To: CF-Talk Subject: popup from image I have an image named edit and I would like to have it generate a popup when its clicked. I would like to pass a parameter with it as well. I've grabbed and edited a previous script I had (see below) but before I continue I was wondering if there were any good ideas out there please? Its all contained in the arraytest.cfm file. a href="" src=""> alt=edit border=0/a CFIF isDefined(url.edit) here is the _javascript_ code I need to generate a popup with the passed parameter which corresponds to the record. /CFIF Robert O. HWW _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MySQL question
Is there a user guide casue I have started this thing and I am having troubles. -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:44 AM To: CF-Talk Subject: RE: MySQL question You can user mysqlfront : www.mysqlfront.de Pat _ From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: June 8, 2004 11:38 To: CF-Talk Subject: RE: MySQL question Does it come with a SQL interface like Query analyzer or SQL Plus? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IMAP in ColdFusion?
I dropped the price of CFX_IMAP4with the professional version now costing £15.00 which is about $25 give or take a couple depending on the exchange rate.If people ask for a more advanced trial off list then depending on the circumstances, I do provide a more complete (or even complete) version which generally means that I put my trust into the person receiving the tag to buy it after the fact if they do get on with it I did also ask the list about a month ago if anyone was interested in beta testing the next version of CFX_IMAP4 which supports SSL and TLS connections too. If you are still interested in trying out CFX_IMAP4 then drop me a line. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Replacing strings as part of a query
Don't know SQL Server. Sorry. But, as for your 500 error - make sure that show friendly http errors is turned off in your IE preferences. Then, you should at least see more info. - Original Message - From: Richard Crawford Deanna Schneider wrote: What database are you using? This sounds like something that would be best handled at the database level, instead of running it through CF. Deanna, I'm using SQL Server 7.The problem is that the field with the characters to be replaced is a TEXT field, and you can't use the REPLACE function on a TEXT field.And, unfortunately, the data is too big in some of the records to CAST to VARCHAR. Here is the SQL that I've tried using: - select msgID, msgSent, msgFromType, msgFromID, msgSubject, REPLACE (CAST(msgMessage AS varchar(8000)), CHAR(13), 'BR') AS newMessage, msgOriginal, attID into tblMessageNew from tblMessage -- In records where the value of msgMessage is greater than 8000 characters, the SQL bombs and no results are returned. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
Eric Creese wrote: Is there a user guide casue I have started this thing and I am having troubles. http://www.mysql.com/ and type manual in the search box. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: WSCONFIG problem
Kevin Roche wrote: wsconfig cant find the Java Runtime Environment. The error message I get is: Error: could not find JRE Error: could not find Java 2 Runtime Environment. Set the JRE_HOME environment variable: set JRE_HOME=c:\cfusion\runtime\blahblah Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help for the speed of this query?
John Ho wrote: I dont know why this query run with same speed 6second, doesn't matter when I use join or not. Show us the execution plan. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Replacing strings as part of a query
Deanna Schneider wrote: Don't know SQL Server. Sorry. But, as for your 500 error - make sure that show friendly http errors is turned off in your IE preferences. Then, you should at least see more info. That in itself isn't an issue (I don't use IE if I can possibly avoid it).I had hoped that I could find more information by checking the CF server log, but it was unrevealing. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
Eric I would be glad to help off list as much as I can Regards -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFX_JSpellCheck CFMX in a J2EE Configuration
I had this same problem, at least in my instance it was a case-sensitivity issue. The CFX must be capitalized in the CFX reg page. Tag Name: CFX_JSpellCheck Class Name: CFX_JSpellCheck John -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 11:51 AM To: CF-Talk Subject: RE: CFX_JSpellCheck CFMX in a J2EE Configuration Dave, I have the CFX Tag registered within the CF Admin. That's the problem.. still not locating it.. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 11:39 AM To: CF-Talk Subject: RE: CFX_JSpellCheck CFMX in a J2EE Configuration Ok I found some documentation on Macromedia on how to load the class path into the JMC. I did set it to: C:\\CFusion\\CFX_Tags\\CFX_JSpellCheck\\CFX_JSpellCheck.jar Then I stopped all JRun services (servers), had to modify the jvm.config based on the TechNote on Macromedia: http://www.macromedia.com/support/coldfusion/ts/documents/serv er_jvm_arg.htm (watch the WRAP) Made the change and restarted all JRun services, but I still get the following: Error processing CFX custom tag quot;CFX_JSpellCheckquot;. The CFX custom tag CFX_JSpellCheck was not found in the custom tag database. Please be sure to add custom tags to the database before using them. If you have added your tag to the database then you should check the spelling of the tag within your template to insure that it matches the database entry I'm pretty sure you'll still have to enter the CFX tag in the CF Administrator, in addition to putting the JAR in the classpath. 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]
CF access to NT Performance Stats?
Is there any way for CF access the info that the NT performance (perfmon.mmc) displays? I am looking to have that info emailed OR viewable via web interface to me on a daily basis. I know the CF stat data is viewable via a template named perfmon.cfm written by Christian Schneider. Also, is there any way to get access to the data in the processes tab in the task manager? I would really like to see if there is a task that is taking 100% CPU before it is too late. Thanks. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
Yah I would use DB tool to connect with your MySQL ( I like Chili Source: SQL Console ) For all around multi-database use - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Tuesday, June 08, 2004 12:24 PM Subject: Re: MySQL question Eric Creese wrote: Is there a user guide casue I have started this thing and I am having troubles. http://www.mysql.com/ and type manual in the search box. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IMAP in ColdFusion?
BlueDragon implements a built-in CFIMAP tag, and it's free (the entire server, not just CFIMAP): http://www.newatlanta.com/products/bluedragon/index.cfm Be sure to download BlueDragon 6.1 Release Candidate 3: http://www.newatlanta.com/c/products/bluedragon-beta/download/home The final BlueDragon 6.1 release will available in about two weeks. Regards, Vince Bonfanti New Atlanta Communications, LLC http://www.newatlanta.com -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 11:48 AM To: CF-Talk Subject: IMAP in ColdFusion? I am considering trying to build a webmail interface using IMAP, but as far as I can tell, my only option for accessing my IMAP server using CF would be through a CFX or Java (which I am not too familiar with).I looked at the exchange and saw 2 IMAP CFX tags.One was from the creator of CFX_POP3, and costs $75.The other was free and was called CFX_mIMAP.Does anyone have experience with either of these?Also, I believe I heard some rumor about the possibility of built-in IMAP support in the next CF release.While I know that no one can say for sure if it will be there or not, is it true that this is a goal?I'd hate to spend $75 if I can wait it out a little bit and have it included in CF.Your thoughts would be appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MySQL question
I have been getting into Aqua Data Studio http://www.aquafold.com/ as I have been using the same DB's (mySQL and MS SQL) from both Mac's and PC's so it has been nice to have a useful interface (I like it ok?) On Tue, 8 Jun 2004 12:40:21 -0400, Daniel Farmer [EMAIL PROTECTED] wrote: Yah I would use DB tool to connect with your MySQL ( I like Chili Source: SQL Console ) For all around multi-database use - Original Message - From: Jochem van Dieten To: CF-Talk Sent: Tuesday, June 08, 2004 12:24 PM Subject: Re: MySQL question Eric Creese wrote: Is there a user guide casue I have started this thing and I am having troubles. http://www.mysql.com/ and type manual in the search box. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help for the speed of this query?
Jochem van Dieten wrote: ...the query execution plan... What's a query execution plan? -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: popup from image
Robert Orlini wrote: ... a href="" src="" alt=edit border=0/a CFIF isDefined(url.edit) !--- here is the _javascript_ code I need to generate a popup with the passed parameter which corresponds to the record. --- function getArgs() { var args = new Object(); var query = location.search.substring(1); var pairs = query.split(); for (var i = 0; i pairs.length; i++) { var pos = pairs[i].indexOf('='); if (pos == -1) continue; var argname = pairs[i].substring(0,pos); var value = pairs[i].substring(pos+1); args[argname] = unescape(value); } return args; } /CFIF -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: WSCONFIG problem
Jochem, I already tried that. And also tried putting it in the wsconfig_jvm.config file. neither works. Just makes the program hand without giving an error message. Strange thing is that the CFMX uninstall won't work either. Kevin -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 08 June 2004 17:27 To: CF-Talk Subject: Re: WSCONFIG problem Kevin Roche wrote: wsconfig cant find the Java Runtime Environment. The error message I get is: Error: could not find JRE Error: could not find Java 2 Runtime Environment. Set the JRE_HOME environment variable: set JRE_HOME=c:\cfusion\runtime\blahblah Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: restricting access by IP address
IP Spoofing is easy. I've tested it and spoofed IP's using just CFML as the spoofing client. You can send a request to a server from your IP and your IP goes into the TCP/IP packet but can send a different IP in the HTTP request as a CGI variable.None of IIS, iPlanet. or JWS test if the TCP/IP supplied address is the same as the HTTP CGI address. http://www.rewindlife.com/archives/000159.cfm The link you provided talks about router level (tcp/ip) address spoofing but it's sufficient to just provide a CGI variable in the HTTP packet to spoof IP address. IP based security at web server/web app level is not safe (router level is much safer). With IIS 6, at least, if you specify an IP address restriction within the IIS management console, IIS will reject requests for CF pages and static files unless they come from that IP address, whether the request has a CGI variable with the allowed address or not. I hadn't really thought about how CF deals with those CGI variables, though, and you're certainly right about that. Out of curiosity, do you know whether that's been submitted as a bug to Macromedia? 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: WSCONFIG problem
I just installed CF MX 6.1 and tried to run wsconfig.exe to set up IIS. wsconfig cant find the Java Runtime Environment. I have done this several times before without any problem. The error message I get is: Error: could not find JRE Error: could not find Java 2 Runtime Environment. I tried editing the wsconfig_jvm.config file did not help either. Anyone out there know hoe to fix this? http://www.houseoffusion.com/cf_lists/index.cfm/method=messagemessageid=484 5forumid=10 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]
CFC problems
(Revised Repost) Does anyone have an example of a CFC used to instantiate an object. Something with a defined structure, get and set methods, etc. Someone suggested cfczone.org, but none of these that I have downloaded so far seem to be this type of object. Trying to figure out why mine doesn't seem to be working (first time with this type of usage, very frustrating at this point). Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help for the speed of this query?
Jochem van Dieten wrote: ...the query execution plan... What's a query execution plan? When you send an SQL query to your database, the database figures out what it thinks is the most efficient way to process that query. This is the execution plan. You can usually take a look at this plan, and see if it really is the most efficient way to run the query. If you're using SQL Server, you can do this very easily from Query Analyzer by clicking on the Display Estimated Execution Plan button on the toolbar, or by using SET SHOWPLAN within an SQL batch. 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]
get one record from array
I have a URL as: a href="" border=0 src=""> The #i# is in an Array. My question is how do I search for that specific record on the popup page? Right now I have a CFLOOP (CFLOOP from=1 to=#arraylen(session.item)# index=i step=1) which of course goes thru and displays all the records. I just want the popup to display that particular record. I'm new to arrays sorry. Roberto HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
searching CF-Talk archives
I've just begun using CF-Talk . . . what a wealth of info. I see on the site that the threads are archived, but is there a way to at least search (titles?) for keyword matches? nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: WSCONFIG problem
i set the java.home in wsconfig_jvf.config like below java.home=d:/JRun4/runtime/jre bamm, it works fine.I sis not add any info to PATH either. Doug -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 12:56 PM To: CF-Talk Subject: RE: WSCONFIG problem Jochem, I already tried that. And also tried putting it in the wsconfig_jvm.config file. neither works. Just makes the program hand without giving an error message. Strange thing is that the CFMX uninstall won't work either. Kevin -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 08 June 2004 17:27 To: CF-Talk Subject: Re: WSCONFIG problem Kevin Roche wrote: wsconfig cant find the Java Runtime Environment. The error message I get is: Error: could not find JRE Error: could not find Java 2 Runtime Environment. Set the JRE_HOME environment variable: set JRE_HOME=c:\cfusion\runtime\blahblah Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: get one record from array
#session.item[url.edit]# -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: dinsdag 8 juni 2004 19:37 To: CF-Talk Subject: get one record from array I have a URL as: a href="" border=0 src=""> The #i# is in an Array. My question is how do I search for that specific record on the popup page? Right now I have a CFLOOP (CFLOOP from=1 to=#arraylen(session.item)# index=i step=1) which of course goes thru and displays all the records. I just want the popup to display that particular record. I'm new to arrays sorry. Roberto HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: searching CF-Talk archives
There is a search on the site. It currently uses google. -Original Message- From: Nick Cabell [mailto:[EMAIL PROTECTED] Sent: dinsdag 8 juni 2004 19:46 To: CF-Talk Subject: searching CF-Talk archives I've just begun using CF-Talk . . . what a wealth of info. I see on the site that the threads are archived, but is there a way to at least search (titles?) for keyword matches? nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFC problems
Join the cfcdev list http://www.cfczone.org/listserv.cfm On Jun 8, 2004, at 1:23 PM, Cutter (CF-Talk) wrote: (Revised Repost) Does anyone have an example of a CFC used to instantiate an object. Something with a defined structure, get and set methods, etc. Someone suggested cfczone.org, but none of these that I have downloaded so far seem to be this type of object. Trying to figure out why mine doesn't seem to be working (first time with this type of usage, very frustrating at this point). Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: searching CF-Talk archives
you can google search it too... http://www.houseoffusion.com/cf_lists/index.cfm/method=searchforumid=4 watch out for wrapping... tw -Original Message- From: Nick Cabell [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 1:46 PM To: CF-Talk Subject: searching CF-Talk archives I've just begun using CF-Talk . . . what a wealth of info. I see on the site that the threads are archived, but is there a way to at least search (titles?) for keyword matches? nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: searching CF-Talk archives
The entire House of Fusion site is specially designed for Google and other search engines to spider it effectively. Each list has a search button that gives access to Google to do such a search. Problem is that the searches are about a day or two away from current at all times. You might also want to look at the Best of Talks that are posted to Fusion Authority, the House of Fusion technical magazine. (www.fusionauthority.com). I'll be moving the search button onto the top bar to ease searching. I've just begun using CF-Talk . . . what a wealth of info. I see on the site that the threads are archived, but is there a way to at least search (titles?) for keyword matches? nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]