CFX_EXCEL ERROR

2002-10-07 Thread JAIME HOI
hi I juz downloaded this custom tag , but it keeps giving me this error when using : Error in CFX_Excel Tag Can't start Excel Does anyone knows what wrong with it ? ** This email and any files transmitted with it

RE: Variable locking

2002-10-07 Thread Kola Oyedeji
Hi I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? Thanks Kola -Original Message- From: Sean A Corfield [mailto:[EMAIL

OT: Primary Keys Duplicate Values

2002-10-07 Thread Srimanta
Hi, Once again its me. I have a table with 18000 records. There are three fields say field1, field2 and field3. There are no primary keys at the moment. I want to delegate field1 as the primary key in the modified table. When I try to create field1 as the primary key, an error is generated as

Re: OT: Primary Keys Duplicate Values

2002-10-07 Thread Jochem van Dieten
Quoting Srimanta [EMAIL PROTECTED]: I have a table with 18000 records. There are three fields say field1, field2 and field3. There are no primary keys at the moment. I want to delegate field1 as the primary key in the modified table. When I try to create field1 as the primary key, an

RE: Primary Keys Duplicate Values

2002-10-07 Thread Robertson-Ravo, Neil (REC)
Yep, your problem is that you have dupes in the column you want to tag as a PK. is Field 1 the only field which is uses dupe values? are the records technically unique or can you safely delete them? -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002

Need more coffee - help with CFIF logic please...

2002-10-07 Thread Les Mizzell
Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show error

CFFORM validation issue

2002-10-07 Thread Les Mizzell
CFFORM validation testing great locally (Cold Fusion MX) Once files are placed out on the server, validation is ignored. I don't see anything in the CFADMIN that would control this. Ideas? ~| Archives:

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Robertson-Ravo, Neil (REC)
A case statement would be more logical... cfswitch -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 11:00 To: CF-Talk Subject: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Robertson-Ravo, Neil (REC)
A Case statement would be more logical : cfswitch expression=#cfformfield# cfcase value=20101-23217,23290-24658 delimiters=, DO THIS /cfcase cfcase value=27060-28909 DO THIS /cfcase cfcase value=27060-28909

RE: CFFORM validation issue

2002-10-07 Thread Mike Townend
Is there a virtual directory so that cfide/scripts exists as the CFForm javascript is now referenced rather than being included in the page like previous versions... HTH -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 11:03 To: CF-Talk

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Mike Townend
This *might* work... Havnt tested it and my cases are a bit rusty... CFSWITCH EXPRESSION=#FORM.Zip# CFCASE VALUE=20101-23217,23290-24658 Do One (altho the above case may need to be split into 2 cases) /CFCASE CFCASE VALUE=27060-28909 do 2

How do I send email with logos(images) after a query result?

2002-10-07 Thread Kodjo Ackah
Hi there, How can I send a HTML mail to my users after they register? The snippet below does not work. Any help? CFQUERY NAME=ValidateUser DATASOURCE=#application.PrimaryDataSource# dbtype=ODBC SELECT client_username, client_password, client_id, client_firstname, client_surname,

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Robertson-Ravo, Neil (REC)
the 3rd case has the wrong value, but it should work! generally a case statement is more efficient than a big IF block. For a multiple decision flow like you have, then I would more than 99% select a case over an IF. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL

RE: OT? Easy data entry util for SQL?

2002-10-07 Thread A.Little
If you are going to use an access data project to connect to the SQL tables, the SQL table must have a primary key - or access won't let you edit data in the table (the PK can be composite) Alex -Original Message- From: Jeff [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 02:44 To:

Re: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Stephen Moretti
Trying to evaluate and assign various stuff depending on a zip code coming from a cfform field. Basically: If the zipcode is 20101-23217 or 23290-24658 do thing ONE If the zipcode is 27060-28909 do thing TWO If the zipcode is 23218-23298 show error message ONE All other Zip Codes, show

Re: How do I send email with logos(images) after a query result?

2002-10-07 Thread Stephen Moretti
Kodjo, Hi there, How can I send a HTML mail to my users after they register? The snippet below does not work. Any help? Why doesn't it work? What happens? Is there an error that you receive? Stephen ~| Archives:

RE: How do I send email with logos(images) after a query result?

2002-10-07 Thread Kodjo Ackah
I expect to see the image in the first row at the top of the email but I only see a place holder. Kodjo Ackah Principal Consultant Concrete Media Ltd 32 Great Sutton Street Clerkenwell London, EC1V 0DX Tel:+44 (0)20 7251 8090 Fax: +44 (0)20 7251 8780 Mobile: +44 (0)7748 79 1038 Office

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Robertson-Ravo, Neil (REC)
A Case can certainly handle ranges. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 11:40 To: CF-Talk Subject: Re: Need more coffee - help with CFIF logic please... Trying to evaluate and assign various stuff depending on a zip code coming

Re: How do I send email with logos(images) after a query result?

2002-10-07 Thread Patric Stumpe
Hi Kodjo, could it be that you need to use an absolute URL or embed the image manual? Patric KA I expect to see the image in the first row at the top of the email but I KA only see a place holder. KA Kodjo Ackah KA Principal Consultant KA Concrete Media Ltd KA 32 Great Sutton Street KA

Re: How do I send email with logos(images) after a query result?

2002-10-07 Thread Stephen Moretti
I expect to see the image in the first row at the top of the email but I only see a place holder. You need to use fully qualified file path. You only have a relative path so the image won't be found. img src=images/top_half_red_600.jpg width=615 height=58 needs to be img

RE: How do I send email with logos(images) after a query result?

2002-10-07 Thread Mike Townend
When it gets to the client then if images are not included in-line of the email then they should be referenced with a fully qualified path... i.e. http://www.yourserver/images/foo.gif HTH -Original Message- From: Kodjo Ackah [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002

How to get MS-Access Table Column info without cfobject

2002-10-07 Thread Dick Applebaum
I used to be able to get system info from a MS-Access DB using cfobject ADO. I can't do that anymore because I am running CFMX on Mac OS X (Linux), The MS-Access database is running under emulated windows. This is a large Access97 database I can manipulate it OK from CFMX (I know some of

RE: How to get MS-Access Table Column info without cfobject

2002-10-07 Thread Craig Dudley
You need read permissions on table 'MSysObjects', you have to set thee inside Access, once you have, the following query should return table names ok. select MSysObjects.Name from MSysObjects where (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1)) order by MSysObjects.Name Craig.

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Les Mizzell
: A Case can certainly handle ranges. This don't work though... cfcase value GT 20100 and value LT 23218 So, how would you define a range for case? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Mike Townend
With a - So for that case you would have... CFCASE VALUE=20100-23218 HTH -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 13:06 To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... : A Case can certainly handle

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Everett, Al
Since when does CFCASE allow a range (27060-28909) ? -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 6:15 AM To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... This *might* work... Havnt tested it and my

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Robertson-Ravo, Neil (REC)
ahhh, I though 27060-28909 was a number :-) c'mon, its Monday! -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 13:36 To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... Since when does CFCASE allow a range (27060-28909)

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Everett, Al
cfset x=5 cfswitch expression=#x# cfcase value=1-4 1 - 4 /cfcase cfcase value=5-8 5 - 8 /cfcase cfcase value=9-12 9 - 12 /cfcase cfdefaultcase Not found /cfdefaultcase /cfswitch Outputs Not found -Original Message- From: Everett, Al [mailto:[EMAIL

RE: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Robertson-Ravo, Neil (REC)
or should I say : an ID. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 13:40 To: CF-Talk Subject: RE: Need more coffee - help with CFIF logic please... ahhh, I though 27060-28909 was a number :-) c'mon, its Monday!

Re: Need more coffee - help with CFIF logic please...

2002-10-07 Thread Stephen Moretti
So I was right after all! Thought that I was going loopy or something!!! Stephen (who thought he'd had a enough coffee when he wrote his reply) - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, October 07, 2002 1:39 PM

RE: OT topics and posts about OT topics

2002-10-07 Thread Yager, Brian T Contractor/Sverdrup
I apologize for this post but I have to speak my mind on this.. I have an Inbox rule that moves all cf-talk emails to another folder. I'm sure all of us are busy most of the day to read every email that comes in. Every 30-60 minutes, I check the folder and scan the topics. If I see something

Re: MX and Javamail - Upgrading MX to Javamail 1.3

2002-10-07 Thread Jesse Houwing
Jon Hall wrote: Ok then I will... ;) Never one to turn down a challenge, but having no clue what I was doing my first thought was to try brute force...and it worked. So here are the steps for anyone interested. Download Javamail 1.3 from Sun's site. Shut down Cold Fusion. Make backup

Randomizing Query Results

2002-10-07 Thread David Jones
What is the best way to randomize the results of a CF query? Thanks, Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: Randomizing Query Results

2002-10-07 Thread Mike Townend
In what way? Do you just want to display a random record from a set... Or a load of records just in a random order? -Original Message- From: David Jones [mailto:[EMAIL PROTECTED]] Sent: Monday, October 7, 2002 14:24 To: CF-Talk Subject: Randomizing Query Results What is the best

Re: Randomizing Query Results

2002-10-07 Thread Joe Eugene
Your query results range between 1 and Total Record Count right? So you could do something like cfset r=randRange(1,QueryName.recordCount) cfoutput #QueryName.columnName[r]# /cfouput The above is what i guessed from your question. Joe Eugene Certified Advanced ColdFusion Developer -

mx conversion problem: code exposed

2002-10-07 Thread Kelly Tetterton
We are starting to migrate to mx from cf5, but we're not getting very far off the ground with our first site. When we hit the site, dev.myurlhere.com, all the code of the default page is exposed; it's almost as if the server is not recognizing the .cfm extension. And yet the administrator

RE: mx conversion problem: code exposed

2002-10-07 Thread Robertson-Ravo, Neil (REC)
You havent mapped (or more likely, the installer didnt) the jrun.dll extension. You will have to go into IIS and map the .cfm extension direct to the jrun.dll. Neil -Original Message- From: Kelly Tetterton [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 14:53 To: CF-Talk Subject: mx

Does there exist...

2002-10-07 Thread Che Vilnonis
Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing lists would be great! TIA - Ché ~|

RE: Primary Keys Duplicate Values

2002-10-07 Thread Andy Ousterhout
If all of your current fields have meaning, I recommend that you add a new field that is a meaningless number that you use as your key field. I've found that if I use a field with meaning as my key that I end up wanting to change that value. Exceptions might be code tables like ZIP Code and

Re: help with IIS 5

2002-10-07 Thread David Burt
is the service started? make sure the cf application server service is started... - Original Message - From: Tim Laureska [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, October 06, 2002 9:38 AM Subject: Re: help with IIS 5 I have only 5 hairs left on my head.. I

RE: Primary Keys Duplicate Values

2002-10-07 Thread Subramanian, Samy
U might want to use this query select field1 from yourtable group by field1 having count(*) 1 this would result all the duplicate row. If u want to list down all the duplicate records select * from yourtable where field1 in (select field1 from yourtable group by field1 having count(*) 1)

Re: Does there exist...

2002-10-07 Thread Randell B Adkins
If I am not mistaken There is a SQL list here at House of Fusion. [EMAIL PROTECTED] 10/07/02 10:19AM Does there exist...a forum like CF-Talk or CFDList with regards to Microsoft SQL Server? I need to brush up on Maintaing SQL Server, DTS, stored procedures and T-SQL. Any all encompassing

RE: Does there exist...

2002-10-07 Thread Justin Hansen
http://groups.google.com/groups?hl=enlr=ie=UTF-8group=mailing.database.sql-general this would be your best bet. Justin Hansen -- Uhlig Communications Systems Engineer -- [EMAIL PROTECTED] 913-754-4273 -- -Original

RE: Does there exist...

2002-10-07 Thread Bartee Lamar
http://www.sswug.org/ Bartee Lamar www.enterpriseenergy.com MSN [EMAIL PROTECTED] -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 10:31 AM To: CF-Talk Subject: Re: Does there exist... If I am not mistaken There is a SQL list

Re: Dreamweaver MX keyboard shortcuts...

2002-10-07 Thread David Burt
THANK YOU!!! That has been SOOO annoying!!! - Original Message - From: Anthony Wong [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, October 05, 2002 2:33 PM Subject: RE: Dreamweaver MX keyboard shortcuts... David, 1) Select Edit -- Keyboard Shortcuts 2) On the

Re: Randomizing Query Results

2002-10-07 Thread Jochem van Dieten
David Jones wrote: What is the best way to randomize the results of a CF query? Offload it to the database: SELECT * FROMtable ORDER BYRandom() Jochem ~| Archives:

CF MX and CFTREE

2002-10-07 Thread Kimmett, Michael S
Hello. We just upgraded our CF 4.5 server to CF MX. However, on one of our applications we have a CFTREE that is used to select files. The CFTREE tag worked just fine in CF4.5, however we are not getting the following error message: Error in__CFTree__myForm__DirectoryExplorer value. We found

Struct state between pages in an application

2002-10-07 Thread Yexley Robert D Contr Det 1 AFRL/WSI
OK, I've made this disclaimer before, but it still applies: I'm really new when it comes to CF, so I request that you please keep that in mind as you read this. I don't claim that as an excuse for not searching out the answers on my own, but I've been unable to find an explanation of this

RE: CFX_EXCEL ERROR

2002-10-07 Thread Mosh Teitelbaum
Do you have Excel installed on the server? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:11 AM To: CF-Talk

RE: Struct state between pages in an application

2002-10-07 Thread Everett, Al
Like any other variable in the local scope, the structure you're creating ceases to exist when the page finishes processing. You'll need to put it in a persistent scope (Session, Client) or in some other way pass it to the next page (serialize it with WDDX and put it in a hidden form variable,

CF execute HELP

2002-10-07 Thread Terry Troxel
I have never used cfexecute before and could use a few pointers before I suffer early hair loss. Here is what I am attempting to do. I would like to run Access from the command line opening a database with a linked table in it that will be copied to another datasource using an autoexec macro

RE: Update Problem in CF

2002-10-07 Thread Stephen Hait
This should work with SQL Server update table1 set price = b.price from table1 a join table2 b on a.productid = b.productid and a.modelno = b.modelno I have two tables in a DB containing information about the same products. Table 1 is comprehensive and has complete details about the

OT: Can a subscription site be classed as shipped goods

2002-10-07 Thread Kola Oyedeji
Hi - (sorry for the cross post) This is more legal than technical so excuse me if its OT. Apparently in the US, payment cannot be fully debited from a credit card until the goods have been shipped. If a site provides a subscription service does this count as goods already shipped? In addition to

Re: How to get MS-Access Table Column info without cfobject

2002-10-07 Thread Dick Applebaum
Unfortunately, read permissions on table 'MSysObject are not set. I can't open the db in either Access97 or Access2000 on WinNT or WinXP -- hangs on NT, crashes on XP. I was able to repair the db successfully, but still can't open it. Yet, I can manipulate it with CFMX for any table I can

RE: Big Trouble in T-SQL land

2002-10-07 Thread Rob Rohan
Thanks for you help Paul. Actually, this doesn't fail in cf5. The SET NOCOUNT allows for multi sql statements (in MS SQL). Thanks for your suggestion on checking for objects, but as I am sure you can tell this is only a sample bit of code to explain our problem. This is not on our site. This

Re: OT: Can a subscription site be classed as shipped goods

2002-10-07 Thread Jeffry Houser
At 05:33 PM 10/7/2002 +0100, you wrote: Hi - (sorry for the cross post) This is more legal than technical so excuse me if its OT. Apparently in the US, payment cannot be fully debited from a credit card until the goods have been shipped. If a site provides a subscription service does this count

CF 5 Hack

2002-10-07 Thread Mark A. Kruger - CFG
Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we get

RE: Struct state between pages in an application

2002-10-07 Thread S . Isaac Dealey
I don't think you can store complex objects like structures in the client scope without first serializing them into a wddx packet... ( which would be similar to passing it in a form, just different management of the packet )... however... I think Al's right, sessions are probably your best

RE: CF execute HELP

2002-10-07 Thread Craig Dudley
Try writing a batch file that does what you want, then just cfexecute that instead, I have more luck doing it that way. Craig. -Original Message- From: Terry Troxel [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 16:19 To: CF-Talk Subject: CF execute HELP I have never used cfexecute

Re: Does there exist...

2002-10-07 Thread Michael Dinowitz
We have such a list on HoF. It's low traffic but has enough people to handle almost all SQL questions. subscribe: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/sql archives: http://www.houseoffusion.com/cf_lists/index.cfm?method=threadsforumid=6 Does there exist...a forum like

RE: CF 5 Hack

2002-10-07 Thread Dave Watts
We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to find him (.. and no - the site is not littlebopeep.com). He does not know the cf administrator password and it's important that we

Re: CF 5 Hack

2002-10-07 Thread Alex
As a member of the CF community I suggest you follow proper ethical procedures. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Folks, We have a new client with a self-hosted server who has asked us to make some emergency changes. He lost his previous developer and does not know where to

RE: CF 5 Hack

2002-10-07 Thread Everett, Al
Off the top of my head, no, but if you can get into the registry you can set Administrator to not require a password. Sorry, but I don't know the key either. However, Google is a wonderfult thing: http://www.teratech.com/coldcuts/cutdetail.cfm?cutid=253

Re: CF 5 Hack

2002-10-07 Thread Pete Ruckelshaus
http://www.mail-archive.com/cf-talk@houseoffusion.com/msg05663.html Quote: yeah you can disable it in the registry, set a new one, then enable it again. HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdmi nPassword = 0 That will disable the password Pete -

Re: CF execute HELP

2002-10-07 Thread Jochem van Dieten
Terry Troxel wrote: The reason I am doing this is my financial package (MAS90) uses illegal characters in its database table naming that Access can handle, but not CF. How about: cfquery SELECT [illegal ##$@* name] AS allowed_fieldname FROM [illegal ##$@* name] allowed_tablename /cfquery

SOT:SSL problem

2002-10-07 Thread Ben Densmore
Hey everyone, Maybe someone can give me an ideas as to what may cause this. We have 2 different websites, on the same server, one uses a Verisign Digital Certificate and the other uses a Thawte cert, I know Verisign owns both. I get a small amount of people who when they go to the secure part of

Re: CF 5 Hack

2002-10-07 Thread Casey C Cook
Can someone forward me the proper ethical procedure documentation referenced in the e-mail below. Thanks. Casey Cook Alex axs

RE: CF 5 Hack

2002-10-07 Thread Mark A. Kruger - CFG
I am following those procedures. I think I've been quite open about it. -mk -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:00 PM To: CF-Talk Subject: Re: CF 5 Hack As a member of the CF community I suggest you follow proper ethical

RE: CF 5 Hack

2002-10-07 Thread Mark A. Kruger - CFG
Alex, Would you like me to send you the number or email of my client so you can verify that I'm not doing anything funny? Exactly what would satisfy you beyond the honesty I've already displayed? -mk -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07,

Re: CF 5 Hack

2002-10-07 Thread Michael Dinowitz
Ethical procedures: 1. The owner of the site have full right to know and change the passwords on the site. 2. Any developer must inform their employer of any passwords for the site. 3. A developer who leaves an employer should inform the employer of their change in work status as well as follow

RE: Can a subscription site be classed as shipped goods

2002-10-07 Thread Jeff Beer
As long as the subscription starts immediately upon payment, you can charge the card. If the subscription starts next month or at some future point in time, you have to wait. Basically, you can grab the cash as soon as you deliver the contract, whether it's for service or material goods or

RE: SSL problem

2002-10-07 Thread Matt Robertson
Have you checked the browser vers of the people having the problem, then checked the browser compatibility of the cert? Different certs have different compatibility. I have no idea if Thawte is handicapped over Verisign in this regard, but the cheapie GeoTrust and InstantSSL certs are. --Matt

RE: Custom Tags and CFX

2002-10-07 Thread Adrian Cesana
So is there a separate list for 4.x questions now or did the whole list upgrade? :O -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 11:25 AM To: CF-Talk Subject: Custom Tags and CFX Does the 4.01 engine handle Custom Tags and CFX in

RE: CF 5 Hack

2002-10-07 Thread Rob Rohan
Yes he has. It wouldn't be following those procedures to say something like: Dreamweaver makes a directory on your server that has the name _MMServerScripts that allows one to brute force passwords - for RDS or Administrator. And, as a lovely addition, you can search google for _MMServerScripts

RE: CF 5 Hack

2002-10-07 Thread Paris Lundis
search the archives listed on the footer of this message... you will find what you need probably by searching for RESET or password... -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the

Big Trouble in T-SQL land

2002-10-07 Thread Rob Rohan
This move to MX has been quite the learning experience. Now, we seem to be unable to create temporary tables. The following query returns 0 records in CFMX but 1 record in query analyzer. Anyone else? Suggestions? Glass of hemlock? CFQUERY NAME=test DATASOURCE=foobardb DBTYPE=ODBC SET NOCOUNT

RE: Big Trouble in T-SQL land

2002-10-07 Thread Smith, Matthew P -CONT(DYN)
Try turning the NOCUNT OFF right before the SELECT * FROM ##xyz then back on for the drop? Just a SWAG, perhaps it is similar to resultsets from stored procedures... Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center

Recall: Big Trouble in T-SQL land

2002-10-07 Thread Smith, Matthew P -CONT(DYN)
Smith, Matthew P -CONT(DYN) would like to recall the message, Big Trouble in T-SQL land. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: CF 5 Hack

2002-10-07 Thread Mark A. Kruger - CFG
What does that have to do with my problem? I'm coming in after the fact - the previous developer is the one who failed, we are just trying to clean up the mess. In this case, I am (of course!) giving all the information to the owner of the site. -mk -Original Message- From: Michael

CFMX - I've never seen anything so unstable in my life

2002-10-07 Thread Dave Wilson
Hi all, Is it just me, or is CFMX proving totally unstable for everyone else too? I've been trialling CFMX now for 18 days using our existing development applications, which ran on CF4.5. I have yet to experience a single day without (several instances of) either the CFMX services hanging or

RE: Big Trouble in T-SQL land

2002-10-07 Thread Smith, Matthew P -CONT(DYN)
Try turning the NOCOUNT OFF right before the SELECT * FROM ##xyz then back on for the drop? Just a SWAG, perhaps it is similar to resultsets from stored procedures... Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center

Re: CF 5 Hack

2002-10-07 Thread Michael Dinowitz
Nothing at all. That's the point of what I was saying. All you need is the means to access the admin password and that's been described already. There are no ethical issues that I can see. What does that have to do with my problem? I'm coming in after the fact - the previous developer is the

RE: CFMX - I've never seen anything so unstable in my life

2002-10-07 Thread Ben Densmore
Well, I have had the problem of it losing a connection to SQL Server via JDBC, that is the only problem I have had but has prevented me from buying the full version for use in the company I work for. Other than that it works great, but I can't have these connection reset errors coming up every

I lost my brain - checkboxes

2002-10-07 Thread Tony Carcieri
Hi all, Sorry for the stupid post today but I cannot think. I have an input field on a form: input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput (SID is the primary key in the SQL 2K DB). then on the page: cfloop query=GetInfo tr tdinput type=checkbox name=hotlead

Re: CF 5 Hack

2002-10-07 Thread Sam Farmer
Yeah, change the registry setting. Either with the cfregistry tag or regedit. cfregistry action=SET branch=HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Server entry=UseAdminPassword type=String value=0 Cheers, Sam - Original Message - From: Mark A. Kruger - CFG

Comma-Space as delimiter

2002-10-07 Thread Bruce Holm
When working with Lists, I'm finding that you can't specify a delimiter of comma-space (, ). CF is treating this as , OR . How do I tell it to delimit as comma-space? The ListAppend function in the Reference states you can use , CHR(32) in the delimiter parameter but it doesn't work.

RE: I lost my brain - checkboxes

2002-10-07 Thread Margaret Fisk
You could do a second update as follows: Update survey Set hot = 0 Where SID not in (10,17) A warning though: A not in query only runs well on well-indexed or small tables. If your table doesn't meet those standards then you'd be better off getting the whole list of SIDs as a list and removing

Commit one query while rolling back the rest within a CFTRANSACTION

2002-10-07 Thread Ruslan Sivak
I have a piece of code that has CFTRANSACTION tags around it. When the credit card authorization fails, I roll back all the queries, however I would like to insert a record into a log table. Is there a way to do that? Russ Example cftransaction action=begin cftry some credit card

Re: I lost my brain - checkboxes

2002-10-07 Thread Bryan Stevenson
I always delete ALL previous selections from the DB and then insert the new ones...that way everything stays current and the coding is dead simple. HTH Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED]

RE: Comma-Space as delimiter

2002-10-07 Thread Bryan Love
You can't. You must use replace() to replace the comma/space with a single character that you can use as the delimiter. The bell character works well since it can't be typed (chr(7)). +---+ Bryan Love Macromedia Certified Professional Internet

Re: Variable locking

2002-10-07 Thread Sean A Corfield
On Monday, Oct 7, 2002, at 01:38 US/Pacific, Kola Oyedeji wrote: I'm joining this thread late. Can I just confirm what you guys are saying: In CFMX named locks should be used in place of scoped locks and locks are only needed When a possible race condition could occur? The last part is

RE: CFMX - I've never seen anything so unstable in my life

2002-10-07 Thread Mark A. Kruger - CFG
Ben, I've seen that socket reset error too. Does anyone have an idea why it occurs? -mk -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 12:37 PM To: CF-Talk Subject: RE: CFMX - I've never seen anything so unstable in my life Well, I

RE: CF 5 Hack

2002-10-07 Thread Alex
I was kidding. You could decrypt the Application.cfm page in the admin section and change authentication or do the registry change as mentioned. On Mon, 7 Oct 2002, Mark A. Kruger - CFG wrote: Alex, Would you like me to send you the number or email of my client so you can verify that I'm

RE: CFMX - I've never seen anything so unstable in my life

2002-10-07 Thread Rob Rohan
Just so you know there is a patch on the smack-romedia site that might help (don't know the address though). We are porting cf5 to MX and had several sloppy coding errors, as well as some full fledged product errors. All in all, when the code is optimized for MX - which almost no currently

Re: Comma-Space as delimiter

2002-10-07 Thread Joseph Thompson
sub-optimal but Replace(String,', ',chr(07),'all') would leave you a bell delimited list... How do I tell it to delimit as comma-space? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

Re: CFMX - I've never seen anything so unstable in my life

2002-10-07 Thread Brian Thornton
Maybe Microsoft really owns Macromedia and is dilluting the market with unstable products in a effort to move everyone to a single Microsoft platform... Or maybe it is just the fact that your using a little older database in which a small portion of testing was conducted upon. - Original

RE: I lost my brain - checkboxes

2002-10-07 Thread Everett, Al
I've done stuff where I also pass the universe of values as a hidden tag. So if you have: cfloop query=qry input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput /cfloop I would also put: input type=hidden name=listofleads value=cfoutput#ValueList(qry.SID)#/cfoutput Now on your next

auto tag completion

2002-10-07 Thread Joe Zanter
Hi All, Perhaps this has been covered (but I couldn't find it in the archive).. I used to use the auto completion feature in CF pre-DWMX. Does that feature exist in DWMX. -- Joe Zanter, Materials Lab, Woodward Aircraft Engine Systems 5001 North 2nd Street, Rockford IL 61125 ph 815-639-6312,

RE: CFMX - I've never seen anything so unstable in my life

2002-10-07 Thread Ben Densmore
Rob, If you get an answer to the JDBC Drivers please let us know, I have been asking for like 2 months now, trying to figure out what's going on. And have not gotten an answer, I've used the updater, Installed all the newest sp's for SQL Server and still nothing. Thanks, Ben -Original

Re: CFMX - I've never seen anything so unstable in my life

2002-10-07 Thread Sean A Corfield
On Monday, Oct 7, 2002, at 10:30 US/Pacific, Dave Wilson wrote: Is it just me, or is CFMX proving totally unstable for everyone else too? It isn't *just* you but it is certainly a minority. Unfortunately, mailing lists like this (and the webforums) are typically where people come when they

  1   2   >