RE: Problems with MX - Can anyone help please !!!

2003-11-12 Thread Ian Vaughan
I think Univers is by IBM The steps below are what happens when trying to set up a datasource to this database through Coldfusion. Steps Involved. 1. Install ODBC Driver for Universe (IBM) - 2. Setup ODBC connection locally Control Panel/Administrative Tools/Datasources ODBC - 3.

RE: Problems with MX - Can anyone help please !!!

2003-11-12 Thread Craig Dudley
MDAC 2.3 ? That's very old, try a later MDAC, 2.8 s deffinatley available. www.microsoft.com/data -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 12 November 2003 08:11 To: CF-Talk Subject: RE: Problems with MX - Can anyone help please !!! I think Un

RE: OT:Transparent Div question.

2003-11-12 Thread [EMAIL PROTECTED]
Thanks Bryan, Doesn't seem to make any difference though. Could it be anything to do with the fact that the div1_txt div is within another div (transcontainer div)? It's quite annoying really as I have the whole thing sorted apart from this one div issue, oh well one of those things I guess ! -Da

RE: Problems with MX - Can anyone help please !!!

2003-11-12 Thread Ian Vaughan
Sorry I am using MDAC 2.8 -Original Message- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 12 November 2003 09:35 To: CF-Talk Subject: RE: Problems with MX - Can anyone help please !!! MDAC 2.3 ? That's very old, try a later MDAC, 2.8 s deffinatley available. www.

SOT: Dreamweaver MX 2004 update forthcoming

2003-11-12 Thread peter . tilbrook
After the recently received Flash MX 2004 update MM are preparing a similar update for DWMX 2004. See http://www.markme.com/cantrell/archives/003703.cfm for more info. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonsto

RE: OT:Transparent Div question.

2003-11-12 Thread Tangorre, Michael
Not sure if this is going to help, but remember that the visibility property still renders the container and hides its' content whereas the display property when set to 'none', does not render the container. Send me your rendered source code that is not working and I will try and help.. email

RE: Flash Remoting question

2003-11-12 Thread Dave Watts
> Are there any issues with having multiple installations of > flash remoting on the same server? There can be, I think, but I have both the .NET and CFMX versions working on my laptop. I know there's an issue if you install CFMX onto a J2EE server that already has Flash Remoting (like JRun by def

CFLOGIN

2003-11-12 Thread Tangorre, Michael
I am noticing something a bit strange here while trying to use cflogin/cfloginuser/cflogout. I have a CFC that handles all the checking, validating, etc... When I put the cfloginuser tag inside the cfc and set its attributes it works, however if I try and set properties within the cfc and then ca

RE: How to determine if a scheduled task is already running?

2003-11-12 Thread [EMAIL PROTECTED]
But notification of failures via inference is not necessarily a good thing... > Ummm... wouldn't you know it when you didn't get an email? :-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

converting workstation from CFMX 6.1 Standalone to Apache/CFMX 6.1

2003-11-12 Thread John Paul Ashenfelter
Folks, I've got a (win2k) development box that has been running CFMX 6.1 = standalone. I've customized the jrun-web.xml file a bit to add a few = directory mappings and such, but basically it's just serving = http://localhost:8500. Problem is that I'd like to move it to Apache 2.048/CFMX6.1 for m

RE: How to determine if a scheduled task is already running?

2003-11-12 Thread Haggerty, Mike
Um... perhaps I am missing something here, but the scheduler.log file lists the name of the task and the result of running it. Couldn't you either manually check to see if it is running, or else write some script that checks to see when it was last run? M -Original Message- From: Pete Ru

RE: Outputting an XML Object to browser

2003-11-12 Thread Jeff Beer
thanks to all who have replied. I have it outputting now, and when I view the source it looks like an XML document.  However, in the browser, it's all one long string of text - I'd like the browser to recognize it as xml. Once again, I'm using cfsavecontent to wrap up the nodes, then outputting w

CFCookie Question

2003-11-12 Thread dsmith
I need to set a cookie with a name of WB-Pass.  Apparantly CF 6 doesn't like the special character "-".  This works in CF5.  Does anyone know a way to use CF to set the cookie or do I need to use _javascript_ or ASP. Thanks, Daron Smith [Todays Threads] [This Message] [Subscription] [Fast

OT: Gen purpose log analyzer

2003-11-12 Thread Phillip B
I'm looking for a program that can take a log file from FTP, email, web, and have it give me some information about what's going on. Any suggestions? Price isn't a real big issue. -- Phillip B. www.LoungeRoyale.com www.FillWorks.com [Todays Threads] [This Message] [Subscription]

Installing Dreamweaver mx 6.1 on machine running cf 5 server

2003-11-12 Thread Smith, Don , CTR , WHS/PSD
Unbeknownst to me a coworker was running a version of cf 5 server on a desktop machine.  When he installed CF Studio MX on that machine it wiped out the CF 5 installation completely and created a strange directory called /cfide_old. Has anyone seen this before?  I know only a few people would be r

RE: How to determine if a scheduled task is already running?

2003-11-12 Thread cf-talk
Neither is falling asleep at the wheel when you're driving. :-) The only point I was trying to make is that when you didn't get your "daily" email you might start to wonder if something was wrong and check it out.  Is it the best line of defense... certainly not.  Is it better than having no che

RE: Gen purpose log analyzer

2003-11-12 Thread John Wilker
take a look at http://www.abacre.com/ala/index.htm I found it on downloads.com I think, great app, only 40 bucks. Can DL the logs for you, makes nice little HTML reports, pretty slick. there's a 30 day trial of course -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED]

CFMX integration with virus scanners?

2003-11-12 Thread Howard Fore
Hi, I'm working on an application where the users will frequently upload document files from Word, Excel, Project, etc. through the HTTP Upload method. IT is wondering how we can interface the application with a virus scanning engine so that as soon as the file is saved to the server, it will

RE: How to determine if a scheduled task is already running?

2003-11-12 Thread Tom Kitta
I definitely agree with Novak, it works for me without any problems. I am a bit puzzled as to a better solution, a separate task management system maybe? But how about an easy, quick and cheap solution that is better than e-mail notification, any ideas here? TK   -Original Message-   From:

RE: CFMX integration with virus scanners?

2003-11-12 Thread Tom Kitta
How about command line scanner executed using cfexecute? At least this is what  would do on Windowz. Also, you may restrict size/extension of the files uploaded. I think there was a thread about something similar on this group not a while ago, so you may check the archives for any leads. TK   

cfhttp connection failure

2003-11-12 Thread d.a.collie
Can anyone help with this? CFHTTP call to a LDAP authetication script Works on serveral servers in our DMZ to the master server but not on this single server Its a CF4.5 SErver calling a CF5 Server and all I keep getting is a Connection Failure error!  I've tried the usual tech notes etc

cfprocessingdirective and Unicode

2003-11-12 Thread Matt Robertson
Can anyone see a more efficient use of cfprocessingdirective than what I describe here?  This is my first try at implementation.  I'm developing strictly for MX 6.1, if that matters. I'm using Its my understanding this is technically redundant but making the statement explicit is a best practic

Re: CFMX integration with virus scanners?

2003-11-12 Thread Michael Dinowitz
PrismAV for ColdFusion is a custom tag that allows you to scan for, and repair, virus-infected files from your ColdFusion environment. It is the first and only anti-virus solution designed specifically for ColdFusion applications. http://www.coolfusion.com/products/prismav/prismavforcoldfusion.cfm

RE: Gen purpose log analyzer

2003-11-12 Thread Matt Robertson
http://sawmill.net Sawmill can handle about a zillion different log formats.  I use it for Imail, Declude and for a global report on all sites on a server.  It has real flexible options for how it gets and then uses logs.  Its quite a resource pig, though.  Best suited to pulling logs down and pro

Re: How to determine if a scheduled task is already running?

2003-11-12 Thread Thomas Chiverton
On Wednesday 12 Nov 2003 16:53 pm, Tom Kitta wrote: > I definitely agree with Novak, it works for me without any problems. I am a > bit puzzled as to a better solution, a separate task management system > maybe? But how about an easy, quick and cheap solution that is better than > e-mail notificati

Re:cfhttp connection failure

2003-11-12 Thread David Collie
Forget it... doesn't matter now -dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Admin question about multiple email addresses

2003-11-12 Thread David Collie
POSTED ON CF-OT Yesterday, Any takers... Hi there, I've lurked on the list for a while, but caught a sniff of someone talking about a secondary email address. When I go to my account info, I am not given any choice in secondary email address and thus if I am at home I need to go in and manua

IIS4 FTP Service Does Not restart on server reboot

2003-11-12 Thread David Collie
POSTED ON CF-OT Yesterday... any takers? I'm looking for a solution... I was thinking that if I can't fix it... what about a batch file that checks to see if the service is running and starts it if it is not?  Anyone see any probs with that? --- original message -- Hi there, Can anybody give m

RE: Admin question about multiple email addresses

2003-11-12 Thread Tangorre, Michael
The whole account maintenance area needs some work in my opinion... I have about 5 orphan accounts under different variations of my name and can never really access them. -Original Message- From: David Collie [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 11:43 AM To: CF-Tal

Custom tag to see list of cached queries!

2003-11-12 Thread A Tamuri
Hello, I have written a CFX custom tag for CFMX, called cfx_queryCache, which allows you to get a list of all your cached queries and flush individual queries based on its key. I'd be interested in any ideas for improvements, both functionality and improving the Java code. It's open-source and av

Re: Admin question about multiple email addresses

2003-11-12 Thread Michael Dinowitz
I agree. I'm trying to find a spare second to rework the entire login section as well as add in the new features that are basically done. It's a matter of time and I apologize for not being able to get to it. If anyone has a problem with their account, please email me off list and I'll handle it fo

RE: Admin question about multiple email addresses

2003-11-12 Thread d.a.collie
Cheers for the response It's all a bit strange... i just hate having multiple accounts anywhere these days cos it just ends up that you get about four newsletters from other sites where they just haven't checked for duplicate email addresses when sending mail  (the reason why I haven't just

Dissappearing session.sessionid

2003-11-12 Thread David Collie
And another question... I have cfapplication with session management enabled I use session.sessionid in a lot of my cflog calls... Can anybody tell me why for some users this variable is not created and erros out with a undefined message, ie 'Error resolving parameter SESSION.SESSIONID' Sh

RE: Admin question about multiple email addresses

2003-11-12 Thread d.a.collie
No need to apologise, its a fairly minor inconvenience on the grand scale of things and it's not that we're not appreciative of what we've got Michael!!! It's a grand job you've done and continue to do with the lists and fusion authority :-)  Respect goes out. -Original Message- From:

RE: Admin question about multiple email addresses

2003-11-12 Thread Tangorre, Michael
In deed! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 1:01 PM To: CF-Talk Subject: RE: Admin question about multiple email addresses No need to apologise, its a fairly minor inconvenience on the grand scale of things and it's not

Re:Dissappearing session.sessionid

2003-11-12 Thread David Collie
ps there is no 'session killing' going on, so it is not that I have killed it and then tried to access it It is used in a template cfincluded into the main http called script if that matters... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Admin question about multiple email addresses

2003-11-12 Thread DURETTE, STEVEN J (AIT)
I think that this is a great resource and you do a good job with it. That said... We are a community of CF programmers.  If you'd like it I'm guessing that some of us can step up and help out. If you'd like some help, let us know. Steve -Original Message- From: [EMAIL PROTECTED

CFFILE Deletinng Files

2003-11-12 Thread brob
I'm getting an Access Denied Error.  WHY  please helpy. :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Admin question about multiple email addresses

2003-11-12 Thread d.a.collie
i concur :-) -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: 12 November 2003 18:07 To: CF-Talk Subject: RE: Admin question about multiple email addresses I think that this is a great resource and you do a good job with it. That said...

Session and Client variable problems?

2003-11-12 Thread Schuster, Steven
Ok, here it goes... I have one domain (call it IP 1.1.1.1) On this domain I have multiple sites, but they use redirects... So, we have sites A, B, C If you ping any of these sites you get IP 1.1.1.1 they simply route to different directories based on the server_name variable. Ok s

CFMX61 and Oracle 8.1.7

2003-11-12 Thread Stacy Young
Anyone have any problems? We're on 8.1.6 with zero issues but DBAs are upgrading us to 8.1.7 in the near future...and I know how sensitive these jdbc drivers can be across versions. Appreciate any input! Stace AVIS IMPORTANT: --- Les informations contenues dans le pr

JavaScript question

2003-11-12 Thread Eric Creese
I am writing a small database data dictionary app. Since the db has over 500 tables I created a small form at the top of the page where I can start to type in the first few letters of the tables and it will parse the list down of available tables to choose from. Once I get the table I want, I want

Re: CFMX61 and Oracle 8.1.7

2003-11-12 Thread Chris Norloff
Should work fine. You do need to be sure you have updated drivers - I think 8.1.7.2 or newer. There's a TechNote on it. Chris Norloff -- Original Message -- From: "Stacy Young" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date:  Wed, 12 Nov 2003 13:26:45

RE: CFFILE Deletinng Files

2003-11-12 Thread Dave Watts
> I'm getting an Access Denied Error. WHY please helpy. :) Perhaps the CF server doesn't have permissiony to delete the file, or perhaps the file is locky. I'm sorry, I couldn't resist that. There are a lot of reasons why you might not be able to delete a file, though. If CF is running as SYS

RE: Session and Client variable problems?

2003-11-12 Thread John Burns
I did this for a content management system for my clients.  I wanted them to be able to log in and edit the information on their site.  Then, for my convenience, I wanted to log in (once) and be able to just from site to site and edit stuff without having to log in. Because of the domain/cookie iss

Re: Installing Dreamweaver mx 6.1 on machine running cf 5 server

2003-11-12 Thread Calvin Ward
Sounds to me like CFMX of some flavor was installed at the same time. This would likely do the rename action that you mentioned. - Calvin   - Original Message -   From: Smith, Don , CTR , WHS/PSD   To: CF-Talk   Sent: Wednesday, November 12, 2003 11:36 AM   Subject: Installing Dreamweav

Multiple Server Versions

2003-11-12 Thread Barney Boisvert
We've got a dev server running a few instances of CF for J2EE, and its great for working on different CVS branches of our apps.  However, now we need to work on a couple apps that will be deployed to Standard servers.  We'd like to just leave everything on the same dev server, but I'm concerned abo

RE: Outputting an XML Object to browser

2003-11-12 Thread Tyler Silcox
Dave said: "I'd recommend that you skip the CFSAVECONTENT, and use CFXML to create your document, and use ToString to output your document." Even though cfxml is intended for this use, I'm going to recommend the use of cfsavecontent. I've had some unexpected Null Null errors when using cfxml and

Re: Session and Client variable problems?

2003-11-12 Thread Matt Robertson
setdomaincookies doesn't help you if you don't have a domain in play.  numeric IPs don't count. :( Found this out the hard way.  Discovered my cfid and cftoken values were resetting themselves on every page view when I was working with setdomaincookies=yes in place prior to assigning a domain name

Ghost variables

2003-11-12 Thread Venable, John
Hello All, I have a very troubling issue with an application I wrote. I have a tabbed interface to a job tracking application. When a user selects the profile that they want to view or edit, I throw that profileID (pid) into the session scope, then I duplicate the session scope into the request s

RE: Outputting an XML Object to browser

2003-11-12 Thread Steven Erat
This is bug 48509 and is not fixed as of the current version.  It occurs when sandbox security is enabled. -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 2:20 PM To: CF-Talk Subject: RE: Outputting an XML Object to browser Dave said: "I

Multiple versions of IE on the same machine!!!

2003-11-12 Thread Mike Kear
W really clever-clogs developer in Chicago, with far too much time on his hands has figured out how to have several versions of IE on his machine at once.. Read all about it here . http://www.insert-title.com/web_design/?page=articles/dev/multi_IE Cheers, Michael Kear Windsor, NSW, Austral

RE: Multiple Server Versions

2003-11-12 Thread Dan Phillips \(CFXHosting.com\)
No you bring up a good point. Even though each install is separate, CPU useage is still shared out and can't be isolated. If someone makes a mistake (say an endless loop) on the dev side and it makes the CPU jump up to 100% usage, the production sites are going to suffer. Now I don't know if you

RE: JavaScript question

2003-11-12 Thread Mosh Teitelbaum
Eric: Instead of using location.href you should be using location.hash as in: function goTo(url) { location.hash = document.SearchForm.cbSearchSelect.options[number].value; } -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.

RE: Multiple Server Versions

2003-11-12 Thread Matt Liotta
On Wed, 12 Nov 2003, Dan Phillips (CFXHosting.com) wrote: > No you bring up a good point. Even though each install is separate, CPU > useage is still shared out and can't be isolated. If someone makes a > mistake (say an endless loop) on the dev side and it makes the CPU jump > up to 100% usage, t

RE: Multiple Server Versions

2003-11-12 Thread Barney Boisvert
There won't be any production sites on that server, it's all dev.  I'd really like to just spawn a couple new CF instances for the new apps and run them there, rather than on actual Standard edition installs, but I'm not sure that's a good idea. I guess my question is really "Is developing an app

Odd db error

2003-11-12 Thread DeMarco, Alex
What would cause this error? "No More data avilable to read" It's a simple query, that has never returned an error before... - Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Multiple Server Versions

2003-11-12 Thread Dan Phillips \(CFXHosting.com\)
I've never used it in a development or production situation but I have had a chance to sit with MM tech reps and really explore it and pick their brain about it. From what I can tell, there should be no trouble when you deploy to a standard server. Dan Phillips www.CFXHosting.com 1-866-239-4678

Re: Odd db error

2003-11-12 Thread Bryan Stevenson
You now know everythingthere is no more data...please wipe your brain clean and press "Re-Start" ;-) Sorry had to. I've seen that error before, but can't remeber what caused it.  Did you give Google Groups a whirl yet for that error? Bryan Stevenson B.Comm. VP & Director of E-Commerce Develo

RE: Multiple Server Versions

2003-11-12 Thread Samuel Neff
We all use our own systems for development and deploy to shared test, demo, and production servers.  Two of us use J2EE for development and everything else is still standard.  Never had any issues. I don't think you would unless you use a J2EE specific feature (and there aren't that many). Sam -

RE: Odd db error

2003-11-12 Thread Nathan Strutz
It's a DataDirect 3.2 JDBC generic error. It happens under load. AFAIK, Macromedia is looking at it. Solving it is difficult... First, make sure you've installed this patch: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx61_sqlserver_c pu.htm Second, check this thread on the CF fo

RE: Multiple Server Versions

2003-11-12 Thread Barney Boisvert
Great!   I figured it wouldn't be a big deal, just wanted to make sure. Thanks all.   -Original Message-   From: Samuel Neff [mailto:[EMAIL PROTECTED]   Sent: Wednesday, November 12, 2003 12:00 PM   To: CF-Talk   Subject: RE: Multiple Server Versions   We all use our own systems for devel

Re: Odd db error

2003-11-12 Thread ksuh
This is a known bug with CFMX 6.1. Look here: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6&threadid=684306 The workaround sucks, but you might not have any choice. - Original Message - From: Bryan Stevenson <[EMAIL PROTECTED]> Date: Wednesday, November 12, 2003 12:56

RE: JavaScript question

2003-11-12 Thread Eric Creese
Thanks. But it did not help In my url window I get the following http://localhost:8500/dictionary/index.cfm?edSeachInput=personde &cbSearchSelect=index.cfm%23PersonDemographic I am expecting http://localhost:8500/dictionary/index.cfm#PersonDemographic -Original Message- From:

Query of query question

2003-11-12 Thread Sparrow-Hood, Walter
I know I can add rows but is it possible to delete a record from a query using QofQ. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

OT - Scsi hd

2003-11-12 Thread Robert Orlini
Sorry this is OT, but it's only one of the few times I've asked. I need to upgrade my server running CF. I have SCSI HD's and an Adaptec Array adapter. I installed the new HD and then one of the older larger HD's which I will put the OS (windows 200) on it. I setup the cd-rom as the boot and put t

RE: JavaScript question

2003-11-12 Thread Mosh Teitelbaum
Ah, whoops.  That's what I get for not looking at all of the code. OK, so first, you need to change your button from TYPE="submit" to TYPE="button" and revise your goTo function as follows: function goTo() {     var selIdx = document.SearchForm.cbSearchSelect.selectedIndex;     location.hash =

Re: Query of query question

2003-11-12 Thread Jochem van Dieten
Sparrow-Hood, Walter wrote: > I know I can add rows but is it possible to delete a record from a query > using QofQ. Just select all the records except the one you want to delete. Jochem -- Who needs virtual reality if you can just dream?  - Loesje [Todays Threads] [This Message] [S

RE: Query of query question

2003-11-12 Thread Barney Boisvert
Just use a WHERE clause in your QofQ, and you can effectively delete rows.   -Original Message-   From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED]   Sent: Wednesday, November 12, 2003 1:03 PM   To: CF-Talk   Subject: Query of query question   I know I can add rows but is it possible to

RE: OT - Scsi hd

2003-11-12 Thread Mark W. Breneman
Robert, Do you have the driver disk (probably a floppy) that came with the Adaptec card?  I am thinking that you will need to specify an additional driver for the Adaptec card when you do the windows 2000 install.  (Hit F6 during the install when it tells you to.) I seem to remember a server of m

RE: Query of query question

2003-11-12 Thread Sparrow-Hood, Walter
Duh - it's been a long day - thanks. -Original Message- From: Jochem van Dieten [SMTP:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:15 PM To: CF-Talk Subject: Re: Query of query question Sparrow-Hood, Walter wrote: > I know I can add rows but is it possible to delete a record fr

RE: OT - Scsi hd

2003-11-12 Thread Schuster, Steven
When you install 2000 it will ask you for any 3rd part SCSI disks. It's a quick screen message you may miss. To prompt for the disk you must press the F6 key during this message. If you miss it the HD will not be recognized and you'll have to reboot and try again. It will ask you for the disk (f

Import/Export - Excel to/from Access/SQL Server

2003-11-12 Thread Stan Winchester
I have a client who is running an ecommerce site with an Access database backend, which will hopefully be upgraded, to SQL Server 2000 very soon. The issue is he has 7,800 records in one table and 43,000 records in another table; both tables will be doubling in size very shortly. My client wants t

Re: Import/Export - Excel to/from Access/SQL Server

2003-11-12 Thread Jim Gurfein
We do this routinely by having the Excel file ftp'd to a known location and then doing a DTS to import into the DB. You can also schedule a DTS to export the Excel file and email to the client. Hope this helps At 04:46 PM 11/12/2003, you wrote: >I have a client who is running an ecommerce site

RE: Import/Export - Excel to/from Access/SQL Server

2003-11-12 Thread Barney Boisvert
If it's a one time deal, 30 seconds of load isn't much of a price to pay. If the mechanism is simple for all concerned, I wouldn't even think twice about doing it that way, unless the load on the server is already pretty high. cheers, barneyb   -Original Message-   From: Stan Winchester [m

RE: Import/Export - Excel to/from Access/SQL Server

2003-11-12 Thread Samuel Neff
I've been in the same situation except the client wanted to use Access and not Excel (primary goal was custom reporting, not just export/edit/re-import). I used XML to transfer data from the web server to the client application. I wrote server and client modules that each handled the appropriate s

RE: Query of query question

2003-11-12 Thread Jillian Carroll
Do you mean delete it from the database, or exclude it from the results? If you just want to exclude it, you could use a WHERE to eliminate it from your new results. -Original Message- From: Sparrow-Hood, Walter [mailto:[EMAIL PROTECTED] Sent: November 12, 2003 3:03 PM To: CF-Talk Subj

Best Practices

2003-11-12 Thread Mickael
Hello, I am in the middle of reworking an app and trying to eliminate many of the templates that were created by me (in my cut paste, make a new template days instead of making smarter templates) What is have in essence are 6 reports that are practically the same the differences are they run the

OT: Joins in Excel?

2003-11-12 Thread Jim McAtee
I have a client with a small website run from an Access 2000 database.  She's requested a "spreedsheet of the database" whatever the hell that is.  I assume she's refering to the main table, which comprises the site membership. Of course that table is normally joined with several others in the data

Re: Best Practices

2003-11-12 Thread Ubqtous
Mickael, On 11/12/2003 at 17:45, you wrote: M> So now this is what I am trying to do.  When the user clicks on the M> report I have appended ?Reportname=myreport to the link. M> Now I have a case statement that uses #url.reportname# that will M> set all my variables for that page.  Until now it

Re:Import/Export - Excel to/from Access/SQL Server

2003-11-12 Thread Stan Winchester
Barney, I agree if this was a one-time event, then I would probably proceed with a CF import/export to and from Excel to Access. The routine would actually be a regularly run on a regular basis. Jim Gurfein suggested DTS to import/export, which sound like a viable solution, though my concern is

RE: CFCookie Question

2003-11-12 Thread J E VanOver
A dash is not a valid name character.  I am guessing there is no way around this -- at least if you continue to use CFCOOKIE.  Yes, you can use _javascript_ to set cookies.  Any good _javascript_ resource will help you with this.   -Original Message-   From: [EMAIL PROTECTED] [EMAIL PROTECT

Comparing Values

2003-11-12 Thread brob
Hey guys.  I have a query that selects about 2,000 rows (by project id) from a table.  Then I use those values to compare with the same table using another query (but from a different project ID.  Any numbers that aren't the same are appended to a variable named error_list.  I'm basically using a C

RE: Comparing Values

2003-11-12 Thread Heald, Tim
Use valueList() to get a comma delimited list from the c=id column of the first query then use IN in the second query   sorta like this:     select columns     from table     where table.idField in (#valueList) Should head you down towards a quicker solution.   The other idea would b

Re: Comparing Values

2003-11-12 Thread Jochem van Dieten
brob wrote: > Hey guys.  I have a query that selects about 2,000 rows (by project id) from a table. Let's call that ID firstID. >  Then I use those values to compare with the same table using another query (but from a different project ID. Let's call that ID secondID. > Any numbers that aren't

Re: Comparing Values

2003-11-12 Thread brob
THat displays EVERYTHING tho.  I want it to display only the names that exists in the first query but does no exist in the second query.   - Original Message -   From: Jochem van Dieten   To: CF-Talk   Sent: Wednesday, November 12, 2003 6:28 PM   Subject: Re: Comparing Values   brob wr

Re: Best Practices

2003-11-12 Thread Mickael
Thanks But my form method is "post" not "get" wouldn't that cause that to fail?   - Original Message -   From: Ubqtous   To: CF-Talk   Sent: Wednesday, November 12, 2003 6:26 PM   Subject: Re: Best Practices   Mickael,   On 11/12/2003 at 17:45, you wrote:   M> So now this is what I

ReSolved: Comparing Values

2003-11-12 Thread brob
Using the IN thingy took less than 10 seconds vs. 2 or 3 minutes!  Wow!  I wonder why my way took so long! (well for one thing it was doing 2000+ queries) hehehe   - Original Message -   From: Heald, Tim   To: CF-Talk   Sent: Wednesday, November 12, 2003 6:18 PM   Subject: RE: Comparing

RE: Best Practices

2003-11-12 Thread Dave Watts
> But my form method is "post" not "get" wouldn't that cause > that to fail? I haven't followed the thread too closely, but if your question is whether you can use URL parameters at the same time as form fields, you can. The URL parameters get put into the HTTP request header, and the form fields

Re: Best Practices

2003-11-12 Thread Mickael
Great thanks that helps!   - Original Message -   From: Dave Watts   To: CF-Talk   Sent: Wednesday, November 12, 2003 7:54 PM   Subject: RE: Best Practices   > But my form method is "post" not "get" wouldn't that cause   > that to fail?   I haven't followed the thread too closely, but

Round and Format - Best Way?

2003-11-12 Thread Les Mizzell
If "AOP.NET_PRICE" equals #1256.98, I need to not only round it off to "1257": #Round(AOP.NET_PRICE)# .but also format the number to show the comma at the thousands #NumberFormat()# doesn't round, so without a horrible nested mess, what's the best way to get this: 1,257 -- Les Mizzell -

Re: Comparing Values

2003-11-12 Thread Jochem van Dieten
brob wrote: > THat displays EVERYTHING tho.  I want it to display only the names that exists in the first query but does no exist in the second query. My mistake: SELECT i.name, i.project_id, j.name, j.project_id FROM ( SELECT name, project_id FROM images WHERE project_id = value="#U

Re[2]: Best Practices

2003-11-12 Thread Ubqtous
Mickael, On Wednesday, November 12, 2003, 7:41:27 PM, you wrote: M> But my form method is "post" not "get" wouldn't that cause that to M> fail? Nope... you can do both! ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Round and Format - Best Way?

2003-11-12 Thread Barney Boisvert
You guessed it: #numberFormat(round(AOP.NET_PRICE), ",")# You could use a temp variable if you want, but that would be less readable, in my opinion.  The exception would be if you're using the rounded value more than once, and it's not always going to be numberformatted (like in a computation).  

CFMail Send Problem

2003-11-12 Thread Mark Leder
Hi All, I have a weird problem occuring with an email send out using CFMail 6.1 from a SQL2000 db.  Seems that SOME recipients of the message get a blank/empty message body (subject line, to and from fields are OK).  We've done some checking and it doesn't seem to be email client specific (for exa

Wierd error in JRUN log for CFMX instance

2003-11-12 Thread DeMarco, Alex
error Cannot create cookie: expires = Fri My log is full of this.. the day changes however.. Any ideas? - Alex [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Re[2]: Best Practices

2003-11-12 Thread Peter Tilbrook
Remember that in CFMX 6.1 the "post" method has been deprecated. As a result you do not need to use the method attribute as it defaults to post anyway. You would still require it for "get" and in my opinion it is good coding practice to still use the method="post" attribute when writng your code f

RE: Best Practices

2003-11-12 Thread Andy Ousterhout
If the user always has to click on a button to move to the next step, you may wish to place the reports needed in a hidden form variable rather then in a URL variable.  You may find that this increases the clarity of the code, especially when someone has to come back to the page at a later date. A

Network

2003-11-12 Thread brob
Hey guys, right now we have an app that allows our people to view files (intranet app), and tag them (tagging the ones with a document number on the top).  We're viewing like 70+ tiff images a minute.  It is fine when one user is hitting the server. But when we get 5 people to hit the server, it fr

Re: Network

2003-11-12 Thread Doug White
70 to 85 200 k images per minute?    I think you are maxing out your network bandwidth. Ever consider converting them to jpeg format (compressed) to reduce file size and thus bandwidth requirement? To find out what a particular node speed is, mouse over the network icon in the system tray ==

  1   2   >