Re: Controling spider access

2004-06-08 Thread Andrew Grosset
Another way is to turn the link into a form submission using _javascript_. I've seen a used car site do this primarily to prevent others from spidering the site and stealing the contentas far as I am aware this will stop "spiders". [Todays Threads] [This Message] [Subscription] [Fast Uns

RE: OT - Remove SQL Server user

2004-06-08 Thread Qasim Rasheed
Thanks Dave. That link was really helpful. Qasim -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 10:11 PM To: CF-Talk Subject: RE: OT - Remove SQL Server user > Sorry for an off topic question. How would one proceed to > remove the remove a

Re: connect to a network db, and log on account - XP

2004-06-08 Thread stylo stylo
Thank you very much, sir! I'll try that. >>if you want to manage servers Actually not at all (as you can tell!), I just have my little 4 computer office (through a workgroup). Just happens that I want daily to modify a program's db on another computer, converting all the prices from dollars to po

RE: OT - Remove SQL Server user

2004-06-08 Thread Dave Watts
> Sorry for an off topic question. How would one proceed to > remove the remove a user from a SQL server db who has > ownership for some objects. > Here is my scenario, I restored a backed up database using > the from device option. When this database is restored it has > a default user name wh

RE: Backup SQL Server Users

2004-06-08 Thread Dave Watts
> I don't think I was clear in my original post. There are a > lot of databases & users for this SQL Server installation. > Before the re-install what do I need to do in order to backup > the users & permissions for all the databases? Do I just > backup the Master database or maybe if I backup

OT - Remove SQL Server user

2004-06-08 Thread Qasim Rasheed
Hi everyone, Sorry for an off topic question. How would one proceed to remove the remove a user from a SQL server db who has ownership for some objects. Here is my scenario, I restored a backed up database using the from device option. When this database is restored it has a default user name wh

Re: Backup SQL Server Users

2004-06-08 Thread Cary Gordon
I agree.  We have a variety of otherwise pretty good backup software available - Retrospect and BrightStor.  They seem to do backup okay.  It is only the restore that never seems to work. We dump everything to a file via a maintenance plan and back that up. Caveat:  If you are doing big league

RE: Appropriate CFMX Service Account?

2004-06-08 Thread Dave Watts
> > Does the technote at > > > > > > tn17279.htm> > > adequately describe what permissions need to be set for > > CFMX, or is there a better set of instructions for CFMX? > > I never gave CF MX any additional registry permissions (au > contraire, I removed quite a bit) and didn't have any prob

Re: Appropriate CFMX Service Account?

2004-06-08 Thread Jochem van Dieten
Mike Chabot wrote: > > I would like to change the CFMX service from running under the local system > account to running under a user account. I think it would make more sense > to run the service under a domain account than a local account, but I would > like to know if anyone sees any advantag

Appropriate CFMX Service Account?

2004-06-08 Thread Mike Chabot
Hello, I would like to change the CFMX service from running under the local system account to running under a user account. I think it would make more sense to run the service under a domain account than a local account, but I would like to know if anyone sees any advantage to running under a lo

Re: help for the speed of this query?

2004-06-08 Thread mavinson
Thanks! Jochem van Dieten wrote: http://www.postgresql.org/docs/7.4/static/overview.html -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: help for the speed of this query?

2004-06-08 Thread Barney Boisvert
This is somewhat off topic, but MySQL will give you a look at the execution plan for a specific query by prefixing the query with the 'explain' keyword. It lists the tables in the order they will be joined, what indexes will be used, how "good" the relationship is, and a few other things.  It also

Re: help for the speed of this query?

2004-06-08 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > Jochem van Dieten wrote: "...the query execution plan..." > > What's a query execution plan? It is a high level overview of the way in which a database will execute the query, i.e. which indexes it will use, in what order it will do joins and sorts etc. A pretty dece

FW: ColdFusion TechNote Notification: "GIOP version supported by ColdFusion MX"

2004-06-08 Thread Debbie Dickerson
Check out the new TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/giop_cfmx.htm    Intro: GIOP (General Inter-ORB Protocol) is the protocol that is used for communicating between CORBA ORBs. GIOP specifies the syntax and message format for communicating between ORBs. [Tod

RE: Oracle Mutating Table

2004-06-08 Thread Tyler Clendenin
Yeah, i was kinda hoping to avoid using a package and three triggers to do something so simple.  Thank you for your help. Tyler Clendenin GSL Solutions   _   From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 3:06 PM To: CF-Talk Subject: Re: Oracle Mutating Table

RE: searching CF-Talk archives

2004-06-08 Thread Dave Watts
> Someone else gave me the URL > http://www.houseoffusion.com/cf_lists/index.cfm/method=search& > forumid=4 but how does someone navigate to this. The default > mailing list page makes no mention of it. You might find it easier just to go to Google and search from there, adding "site:houseoffusi

Re: searching CF-Talk archives

2004-06-08 Thread Nick Cabell
Someone else gave me the URL http://www.houseoffusion.com/cf_lists/index.cfm/method=search&forumid=4 but how does someone navigate to this. The default mailing list page makes no mention of it. >There is a search on the site. It currently uses google. > >> [Todays Threads] [This Message] [Su

Re: Purchase a copy of CF 5?

2004-06-08 Thread Stan Winchester
Be careful of anything Macromedia on eBay!!! The only times I've been burned on eBay was when I tried to purchase MX Studio or CF server. Both times I got sent a pirated copy. Also, verify with Macromedia the license of the seller can be transfered. >http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&c

J2EE Configuration & CFX Tags (RESOLVED)

2004-06-08 Thread Adkins, Randy
After many headaches, I ran across a post on Macromedia that corrected the problem. http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=274& threadid=670511&highlight_key=y&keyword1=com%2Fallaire%2Fcfx%2FCustomTag --- Watch the wrapping --- Thanks to all you assisted

RE: Purchase a copy of CF 5?

2004-06-08 Thread Burns, John D
It's not my call.  I suggested that, but management wants to try to keep them both mirrored.  BlueDragon was also a suggestion of mine.  In their mind, it's either install CFMX on both, or find a copy of CF5 for a reasonably low price.  Thanks for the thought though. John -Original Message--

Re: Backup SQL Server Users

2004-06-08 Thread Stan Winchester
I don't think I was clear in my original post. There are a lot of databases & users for this SQL Server installation. Before the re-install what do I need to do in order to backup the users & permissions for all the databases? Do I just backup the Master database or maybe if I backup the correct co

Re: help for the speed of this query?

2004-06-08 Thread John Ho
thanks all for your help. I change query like someone show  like and run better less than 1 second. 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 W

RE: Purchase a copy of CF 5?

2004-06-08 Thread Samuel Neff
Pro: http://shop.macromedia.com/dr/v2/ec_main.entry17c?cid=0&pn=5&sp=10007&sid=46 165&pid=615653&DSP=&CUR=840&PGRP=0&CACHE_ID=0 Enterprise: http://shop.macromedia.com/dr/v2/ec_main.entry17c?cid=0&pn=5&sp=10007&sid=46 165&pid=615659&DSP=&CUR=840&PGRP=0&CACHE_ID=0 Includes free upgrade to CFMX/bl

Re: Where do you get ODBC Drivers for SQL Server and Access? (OS X)

2004-06-08 Thread Dick Applebaum
On Jun 8, 2004, at 11:15 AM, Dave Watts wrote: > > I've got ODBC in my Utilities folder, but when I want to add >  > a datasource, I don't have an Access Driver. I looked all >  > over Microsoft.com but couldn't seem to find it. Is all I >  > need the driver for Access? Where do you go to get one

RE: get one record from array

2004-06-08 Thread Robert Orlini
OK. will do. RO -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 3:10 PM To: CF-Talk Subject: RE: get one record from array It's stuipd to loop like this. If you're confused about not using i in the array, just do before the loop, and then

Re: Purchase a copy of CF 5?

2004-06-08 Thread Doug White
John Have you tried running the CFMX code analyzer against the application?  You just might find it will run just fine under CFMX, or at least with very little modification in syntax. This has been my experience with many CF 5.0 apps. == Our Anti-spam solution w

RE: get one record from array

2004-06-08 Thread Pascal Peters
It's stuipd to loop like this. If you're confused about not using i in the array, just do before the loop, and then get rid of . You can also replace i by url.edit inside the cfloop and then get rid of . Notice I used url.edit instead of edit. It is always best to scope your variables. Pascal >

Re: Oracle Mutating Table

2004-06-08 Thread Janet Schmitt
> > 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 - The FOR EACH

Re: Where do you get ODBC Drivers for SQL Server and Access? (OS X)

2004-06-08 Thread Jeff Small
> I don't think you'll be able to connect to Access very well from OS X. I > haven't actually tried to do this, but I suspect that the SequeLink ODBC > client used by CFMX is only installed on Windows. You should be able to use > the MS SQL Server JDBC driver to connect to SQL Server from CFMX on a

RE: get one record from array

2004-06-08 Thread Robert Orlini
tried: and it worked believe it or not. Thanks anyway you lead me in the right direction. RO -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 2:16 PM To: CF-Talk Subject: RE: get one record from array But I suspect  #session.item[url.edit]#

RE: Purchase a copy of CF 5?

2004-06-08 Thread Greg Luce
http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&category=46326&item=3681020569 &rd=1 -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 2:47 PM To: CF-Talk Subject: Purchase a copy of CF 5? Does anyone have a full licensed copy of CF 5 that they a

Re: CF access to NT Performance Stats?

2004-06-08 Thread Jeff Garza
If you know .NET, then it's trivial to access any of the performance counters on your server.  If you have Visual Studio .NET open a new project and then check the Server Explorer.  There should be an entry for Performance Monitor...  You can then publish them out using a web service and consume th

Purchase a copy of CF 5?

2004-06-08 Thread Burns, John D
Does anyone have a full licensed copy of CF 5 that they are no longer using and would be interested in selling?  Or, is there anywhere that I could buy a copy of CF 5 from an online retailer or something?  We have an existing application running on a server with CF 5 and we're having to install it

Tip: escaping XML delclarations

2004-06-08 Thread Alexander Sherwood
Helpful tidbit that will now be archived: Trying to strip the XML declaration from the top of XML documents created by CF? escapedXMLString = ListRest(xmlString, '>'); Nothing earth shattering, but cleaner that what I've seen suggested in the various forums. TTFN, -

RE: CF access to NT Performance Stats?

2004-06-08 Thread Micha Schopman
As far is I know, this is only possible using cfexecute and a 3rd party executable which gets the cpu load :-)   _   From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 08, 2004 6:40 PM To: CF-Talk Subject: CF access to NT Performance Stats? Is there any way for CF access t

Re: Backup SQL Server Users

2004-06-08 Thread Paul Hastings
> AFAICS the standard tools for SQL Server for doing backups, well, um, > suck.  You might try searching for some evaluation copies of 3rd party > tools, there was one I used once but I forget its name now. i think you have that backwards. pretty much most folks on the sql server list will recomme

Re: Backup SQL Server Users

2004-06-08 Thread Damien McKenna
AFAICS the standard tools for SQL Server for doing backups, well, um, suck.  You might try searching for some evaluation copies of 3rd party tools, there was one I used once but I forget its name now. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucomp

RE: restricting access by IP address

2004-06-08 Thread Samuel Neff
I talked to MM's security people before I blogged this in April.  They said it's not a bug because CF just gets whatever CGI variables are passed from the web server so if the web server isn't passing the right variables it's the web-server's bug.  Can't really argue with that.  A technote would be

Backup SQL Server Users

2004-06-08 Thread Stan Winchester
Is there an easy way to backup and restore the users for SQL Server 2000? I will be rebuilding a server soon running SQL Server and I don't want to manually clean up the orphaned users when I reattached the database, and then manually add all the users and set permissions. There must be an easy way

RE: get one record from array

2004-06-08 Thread Pascal Peters
But I suspect  #session.item[url.edit]# is a struct. What do you get if you cfdump it? You will probably need something like #session.item[url.edit].qty# Pascal > -Original Message- > From: Robert Orlini [mailto:[EMAIL PROTECTED] > Sent: dinsdag 8 juni 2004 20:00 > To: CF-Talk > Subject:

RE: Where do you get ODBC Drivers for SQL Server and Access? (OS X)

2004-06-08 Thread Dave Watts
> I've got ODBC in my Utilities folder, but when I want to add > a datasource, I don't have an Access Driver. I looked all > over Microsoft.com but couldn't seem to find it. Is all I > need the driver for Access? Where do you go to get one for > Access and SQL Server if you're running OS X? I'm

RE: get one record from array

2004-06-08 Thread Robert Orlini
I thought it would work Peter but I got this... _expression_ result cannot be converted to a string. Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must evaluate to a value that can be converted to a string for output or dynamic text accumulation purposes. Complex objects, suc

Where do you get ODBC Drivers for SQL Server and Access? (OS X)

2004-06-08 Thread Jeff Small
I've got ODBC in my Utilities folder, but when I want to add a datasource, I don't have an Access Driver. I looked all over Microsoft.com but couldn't seem to find it. Is all I need the driver for Access? Where do you go to get one for Access and SQL Server if you're running OS X? I'm trying to slo

Re: searching CF-Talk archives

2004-06-08 Thread Michael Dinowitz
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

RE: searching CF-Talk archives

2004-06-08 Thread Tony Weeg
you can google search it too... http://www.houseoffusion.com/cf_lists/index.cfm/method=search&forumid=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'v

Re: CFC problems

2004-06-08 Thread Ian Sheridan
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

RE: searching CF-Talk archives

2004-06-08 Thread Pascal Peters
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 th

RE: get one record from array

2004-06-08 Thread Pascal Peters
#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: > > border="0" src=""> > > The #i# is in an Array. My question is how do I search fo

RE: WSCONFIG problem

2004-06-08 Thread Douglas.Knudsen
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: WSCO

searching CF-Talk archives

2004-06-08 Thread Nick Cabell
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]

get one record from array

2004-06-08 Thread Robert Orlini
I have a URL as: 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 () 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 H

RE: help for the speed of this query?

2004-06-08 Thread Dave Watts
> 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

CFC problems

2004-06-08 Thread Cutter (CF-Talk)
(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 doe

RE: WSCONFIG problem

2004-06-08 Thread Dave Watts
> 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 Enviro

RE: restricting access by IP address

2004-06-08 Thread Dave Watts
> 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

RE: WSCONFIG problem

2004-06-08 Thread Kevin Roche
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:[E

Re: popup from image

2004-06-08 Thread mavinson
Robert Orlini wrote: ... alt="edit" border="0"> 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('=');  

Re: help for the speed of this query?

2004-06-08 Thread mavinson
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: MySQL question

2004-06-08 Thread Mark Drew
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 wo

RE: IMAP in ColdFusion?

2004-06-08 Thread Vince Bonfanti
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 BlueD

Re: MySQL question

2004-06-08 Thread Daniel Farmer
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 the

CF access to NT Performance Stats?

2004-06-08 Thread Mark W. Breneman
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

RE: CFX_JSpellCheck & CFMX in a J2EE Configuration

2004-06-08 Thread Venable, John
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

Re: MySQL question

2004-06-08 Thread Mark Drew
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: Replacing strings as part of a query

2004-06-08 Thread Richard Crawford
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 hope

Re: help for the speed of this query?

2004-06-08 Thread Jochem van Dieten
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: WSCONFIG problem

2004-06-08 Thread Jochem van Dieten
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] [T

Re: MySQL question

2004-06-08 Thread Jochem van Dieten
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: Replacing strings as part of a query

2004-06-08 Thread Deanna Schneider
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? Th

RE: IMAP in ColdFusion?

2004-06-08 Thread Paul Vernon
I dropped the price of CFX_IMAP4  with 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 wh

RE: MySQL question

2004-06-08 Thread Eric Creese
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 Cr

RE: popup from image

2004-06-08 Thread Adkins, Randy
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 + "¶m2=" + myparam2;     var newwin = window.open(url,"MyNewWindow"); } img src="" > something like th

Re: help for the speed of this query?

2004-06-08 Thread John Ho
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

WSCONFIG problem

2004-06-08 Thread Kevin Roche
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 trie

RE: IMAP in ColdFusion?

2004-06-08 Thread Samuel Neff
$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 -

.Net list

2004-06-08 Thread Michael Dinowitz
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

RE: IMAP in ColdFusion?

2004-06-08 Thread Dave Carabetta
>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

Re: MySQL question

2004-06-08 Thread Doug White
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 ===

RE: MySQL question

2004-06-08 Thread CFDEV
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] [Subscriptio

popup from image

2004-06-08 Thread Robert Orlini
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 cont

RE: MySQL question

2004-06-08 Thread Dave Phillips
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] __

Re: Replacing strings as part of a query

2004-06-08 Thread 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'

RE: CFX_JSpellCheck & CFMX in a J2EE Configuration

2004-06-08 Thread Adkins, Randy
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 foun

Re: MySQL question

2004-06-08 Thread Mark Drew
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: MySQL question

2004-06-08 Thread Eric Creese
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

FW: Question about Licensing my CF Web Application

2004-06-08 Thread Dave Phillips
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 situati

IMAP in ColdFusion?

2004-06-08 Thread Burns, John D
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

Re: help for the speed of this query?

2004-06-08 Thread Jochem van Dieten
[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 for

Re: MySQL question

2004-06-08 Thread Mark Drew
> 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.

RE: MySQL question

2004-06-08 Thread Eric Creese
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

RE: restricting access by IP address

2004-06-08 Thread Samuel Neff
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

RE: MySQL question

2004-06-08 Thread Eric Creese
Does it come with a SQL interface like Query analyzer or SQL Plus? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Oracle Mutating Table

2004-06-08 Thread Deanna Schneider
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

Re: help for the speed of this query?

2004-06-08 Thread mavinson
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 restrictin

RE: CFX_JSpellCheck & CFMX in a J2EE Configuration

2004-06-08 Thread Dave Watts
> 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: > > h

OT: Oracle Mutating Table

2004-06-08 Thread 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 w

CFX_JSpellCheck & CFMX in a J2EE Configuration

2004-06-08 Thread Adkins, Randy
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

RE: Still No Luck

2004-06-08 Thread Scott Fegette
I'd try this hotfix first: http://www.macromedia.com/support/service/ts/documents/mac_archive_install.h tm 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 dire

Re: MySQL question

2004-06-08 Thread Daniel Farmer
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 befo

RE: Slightly OT: Help with CF/IIS

2004-06-08 Thread Alexander Sherwood
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

  1   2   >