RE: Problems with MX - Can anyone help please !!!
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. In Coldfusion Administrator setup an ODBC connection using the system DSN version you have created in step 2 above. But when running the cfm page I am receiving the following error Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2301529]Invalid argument value. Even though in the Coldfusion Administrator the datasource verifies as OK ? I have MDAC 2.3 installed as im using MX 6.1 ? Any other ideas?? -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: 05 November 2003 10:33 To: CF-Talk Subject: RE: Problems with MX - Can anyone help please !!! TO be brutally honest I have never even heard of Univers. What is the nearest likeminded database server? Have you tried setting up the datasource manually (first - before CF Admin) through the ODBC wizard (Control Panel)? Alternatively using ODBC socket? Also you might try updating to the latest MDAC - 2.8 I think by now - at www.microsoft.com/data Just ideas but HTH. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2003 9:22 PM To: CF-Talk Subject: Problems with MX - Can anyone help please !!! I am having the following problem when trying to access a Univers database through an ODBC socket through the CFAdministrator in Coldfusion MX 6.1 It worked fine when we were using CF 4.5 against Univers but it will not work in MX ? I followed the same approach - installing the latest Univers ODBC driver on the IIS server and set it up via the control panel on IIS, and created a Local System Account, which I then set up in the administrator as ODBC socket data datasource.But when running the cfm page I am receiving the following error Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2301529]Invalid argument value. Even though in the Coldfusion Administrator the datasource verifies as OK ? Can anybody in Macromedia, Ben Forta, Rob ?help me resolve this please From other posts I have read it seems as though there a lot of people with similar type problems, or can Coldfusion MX no longer connect to a Univers database. If this is the case then we will have to look at asp to resolve this. Yours Sincerely Ian Vaughan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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.microsoft.com/data http://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 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. In Coldfusion Administrator setup an ODBC connection using the system DSN version you have created in step 2 above. But when running the cfm page I am receiving the following error Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2301529]Invalid argument value. Even though in the Coldfusion Administrator the datasource verifies as OK ? I have MDAC 2.3 installed as im using MX 6.1 ? Any other ideas?? -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: 05 November 2003 10:33 To: CF-Talk Subject: RE: Problems with MX - Can anyone help please !!! TO be brutally honest I have never even heard of Univers. What is the nearest likeminded database server? Have you tried setting up the datasource manually (first - before CF Admin) through the ODBC wizard (Control Panel)? Alternatively using ODBC socket? Also you might try updating to the latest MDAC - 2.8 I think by now - at www.microsoft.com/data Just ideas but HTH. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2003 9:22 PM To: CF-Talk Subject: Problems with MX - Can anyone help please !!! I am having the following problem when trying to access a Univers database through an ODBC socket through the CFAdministrator in Coldfusion MX 6.1 It worked fine when we were using CF 4.5 against Univers but it will not work in MX ? I followed the same approach - installing the latest Univers ODBC driver on the IIS server and set it up via the control panel on IIS, and created a Local System Account, which I then set up in the administrator as ODBC socket data datasource.But when running the cfm page I am receiving the following error Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2301529]Invalid argument value. Even though in the Coldfusion Administrator the datasource verifies as OK ? Can anybody in Macromedia, Ben Forta, Rob ?help me resolve this please From other posts I have read it seems as though there a lot of people with similar type problems, or can Coldfusion MX no longer connect to a Univers database. If this is the case then we will have to look at asp to resolve this. Yours Sincerely Ian Vaughan _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT:Transparent Div question.
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 ! -Darren -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 11 November 2003 17:29 To: CF-Talk Subject: RE: OT:Transparent Div question. Make sure you put z-index on all the layers. Higher numbers make the layer sit on top of layers with a lower z-index. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 12:19 PM To: CF-Talk Subject: RE: OT:Transparent Div question. OK, now this is driving me up the wall. Can anyone spare 10 secs to look over this source code (I've stripped away all the unimportant stuff) The default top bar overwrites everything in the div1_txt. Any ideas ? -Darren cfsetting showdebugoutput=No cfset request.DealerID = 4705 cfset request.width=1135 cfset request.totalHeight = 864 cfset request.topBarHeight=300 cfset request.topMiddleBarHeight=800 cfset request.middleBarHeight = #request.topMiddleBarHeight# - #request.topBarHeight# cfset request.bottomBarTop = #request.topMiddleBarHeight# - 70 cfset request.bottomBarHeight = #request.totalHeight# - #request.bottomBarTop# cfoutputdiv ID=TransContainer STYLE=position:absolute;top:0px;left:0px;width:#request.width#px; height:#request.topMiddleBarHeight#px;filter:progid:DXImageTransform.Mic roso ft.Fade(duration=1.0,overlap=0.0); !--- ##003056 --- div id=div1_txt style=z-index:2;visibility:hidden;font-family:Verdana;font-size:50px;ba ckgr ound:transparent; style .textbold {font-family:Arial;font-size:60px;color:white;padding-left:80px; } .text {font-family:Arial;font-size:20px;color:white; } .textorange {font-family:Arial;font-size:40px;color:orange;padding-left:80px; } /style !--- Top Band --- table width=100% border=0 height=#request.topBarHeight# cellspacing=0 cellpadding=0 tr td colspan=2 font class=textboldVehicle/fontbr font class=textorange£Price/font /td /tr /table /div /div/cfoutput cfoutputdiv ID=defaultTop STYLE=position:absolute;top:0px;left:0px;width:#request.width#px;visibi lity :visible;height:#request.topBarHeight#px table width=100% border=0 height=300 bgcolor=##003056 tr align=left td /td td align=right/td /tr /table /div/cfoutput cfoutputdiv style=position:absolute;bottom:0px;left:0px;width:#request.width#px;vis ibil ity:visible;top:#request.bottomBarTop#px;background:##003056; table width=100% border=0 height=#request.bottomBarHeight# bgcolor=##003056/cfoutput tr align=left tdcfoutputdiv style=visibility:visible;font-family:Verdana;font-size:20px;color:white ;pad ding-left:50px; To contact us outside of opening hours call BOB on 0123 356 789/div/cfoutput /td td align=right/td /tr /table /div -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 November 2003 12:53 To: CF-Talk Subject: RE: OT:Transparent Div question. Yeah thats what I thought, I have the default divs outside the central content area div. Still can't get the other top divs to display on top of the default top div. Div layout as follows: div defaultTop /div defaultTop div changable div top /div top div middle div image /div image div text /div text /div middle /div changable div bottom /div bottom -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: 05 November 2003 15:05 To: CF-Talk Subject: Re: OT:Transparent Div question. Try making everything BELOW the blue bar another div called ContentArea or something andplace your other divs inside that cheers - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Wednesday, November 05, 2003 6:49 AM Subject: OT:Transparent Div question. Hello All, I've got a slideshow app,using data from a DB I build a series of divs and switch between them using JS and timeouts. (in a nutshell) Everything works hunkey dorey except for one small problem with one of the Div's: The page consists of a top blue bar (title and subtitle),bottom blue bar (generic contact info) and a middle area (content area - consisting of a table and an image). The top and middle areas change with each cycle of the loop but because the page background is white I want to create a default top Div so that the different content top divs can be transparent and the change over of div's is smooth. Basically I have tried setting the content top divs with background:transparent; in the style and have played around with the z-index but, no matter what I try the default top div (the big blue bar) covers up all the content top Divs (blue bar with White and orange text) Surely can't I setup something like: div id=defaultTop style=background:darkblue; /div div
RE: Problems with MX - Can anyone help please !!!
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.microsoft.com/data http://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 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. In Coldfusion Administrator setup an ODBC connection using the system DSN version you have created in step 2 above. But when running the cfm page I am receiving the following error Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2301529]Invalid argument value. Even though in the Coldfusion Administrator the datasource verifies as OK ? I have MDAC 2.3 installed as im using MX 6.1 ? Any other ideas?? -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: 05 November 2003 10:33 To: CF-Talk Subject: RE: Problems with MX - Can anyone help please !!! TO be brutally honest I have never even heard of Univers. What is the nearest likeminded database server? Have you tried setting up the datasource manually (first - before CF Admin) through the ODBC wizard (Control Panel)? Alternatively using ODBC socket? Also you might try updating to the latest MDAC - 2.8 I think by now - at www.microsoft.com/data Just ideas but HTH. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] World Wide Web: http:/www.coldgen.com/ -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2003 9:22 PM To: CF-Talk Subject: Problems with MX - Can anyone help please !!! I am having the following problem when trying to access a Univers database through an ODBC socket through the CFAdministrator in Coldfusion MX 6.1 It worked fine when we were using CF 4.5 against Univers but it will not work in MX ? I followed the same approach - installing the latest Univers ODBC driver on the IIS server and set it up via the control panel on IIS, and created a Local System Account, which I then set up in the administrator as ODBC socket data datasource.But when running the cfm page I am receiving the following error Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][IBM][UVODBC][2301529]Invalid argument value. Even though in the Coldfusion Administrator the datasource verifies as OK ? Can anybody in Macromedia, Ben Forta, Rob ?help me resolve this please From other posts I have read it seems as though there a lot of people with similar type problems, or can Coldfusion MX no longer connect to a Univers database. If this is the case then we will have to look at asp to resolve this. Yours Sincerely Ian Vaughan _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: Dreamweaver MX 2004 update forthcoming
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 Symonston ACT 2609 Tel: (02) 62115927 Important:This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege.If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament.If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT:Transparent Div question.
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 me off list. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:43 AM To: CF-Talk Subject: RE: OT:Transparent Div question. 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 ! -Darren -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: 11 November 2003 17:29 To: CF-Talk Subject: RE: OT:Transparent Div question. Make sure you put z-index on all the layers. Higher numbers make the layer sit on top of layers with a lower z-index. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 12:19 PM To: CF-Talk Subject: RE: OT:Transparent Div question. OK, now this is driving me up the wall. Can anyone spare 10 secs to look over this source code (I've stripped away all the unimportant stuff) The default top bar overwrites everything in the div1_txt. Any ideas ? -Darren cfsetting showdebugoutput=No cfset request.DealerID = 4705 cfset request.width=1135 cfset request.totalHeight = 864 cfset request.topBarHeight=300 cfset request.topMiddleBarHeight=800 cfset request.middleBarHeight = #request.topMiddleBarHeight# - #request.topBarHeight# cfset request.bottomBarTop = #request.topMiddleBarHeight# - 70 cfset request.bottomBarHeight = #request.totalHeight# - #request.bottomBarTop# cfoutputdiv ID=TransContainer STYLE=position:absolute;top:0px;left:0px;width:#request.width#px; height:#request.topMiddleBarHeight#px;filter:progid:DXImageTransform.Mic roso ft.Fade(duration=1.0,overlap=0.0); !--- ##003056 --- div id=div1_txt style=z-index:2;visibility:hidden;font-family:Verdana;font-size:50px;ba ckgr ound:transparent; style .textbold {font-family:Arial;font-size:60px;color:white;padding-left:80px; } .text {font-family:Arial;font-size:20px;color:white; } .textorange {font-family:Arial;font-size:40px;color:orange;padding-left:80px; } /style !--- Top Band --- table width=100% border=0 height=#request.topBarHeight# cellspacing=0 cellpadding=0 tr td colspan=2 font class=textboldVehicle/fontbr font class=textorange£Price/font /td /tr /table /div /div/cfoutput cfoutputdiv ID=defaultTop STYLE=position:absolute;top:0px;left:0px;width:#request.width#px;visibi lity :visible;height:#request.topBarHeight#px table width=100% border=0 height=300 bgcolor=##003056 tr align=left td /td td align=right/td /tr /table /div/cfoutput cfoutputdiv style=position:absolute;bottom:0px;left:0px;width:#request.width#px;vis ibil ity:visible;top:#request.bottomBarTop#px;background:##003056; table width=100% border=0 height=#request.bottomBarHeight# bgcolor=##003056/cfoutput tr align=left tdcfoutputdiv style=visibility:visible;font-family:Verdana;font-size:20px;color:white ;pad ding-left:50px; To contact us outside of opening hours call BOB on 0123 356 789/div/cfoutput /td td align=right/td /tr /table /div -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 November 2003 12:53 To: CF-Talk Subject: RE: OT:Transparent Div question. Yeah thats what I thought, I have the default divs outside the central content area div. Still can't get the other top divs to display on top of the default top div. Div layout as follows: div defaultTop /div defaultTop div changable div top /div top div middle div image /div image div text /div text /div middle /div changable div bottom /div bottom -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: 05 November 2003 15:05 To: CF-Talk Subject: Re: OT:Transparent Div question. Try making everything BELOW the blue bar another div called ContentArea or something andplace your other divs inside that cheers - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Wednesday, November 05, 2003 6:49 AM Subject: OT:Transparent Div question. Hello All, I've got a slideshow app,using data from a DB I build a series of divs and switch between them using JS and timeouts. (in a nutshell) Everything works hunkey dorey except for one small problem with one of the Div's: The page consists of a top blue bar (title and subtitle),bottom blue bar (generic contact info) and a middle area (content area - consisting of a table and an image). The top and middle areas change with each cycle of the loop but because the page background is white I want to create a default top Div so that the different content top divs can be transparent and the change over of div's is smooth.
RE: Flash Remoting question
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 default). In my case, the .NET stuff and the CFMX stuff are on separate virtual servers, and that works fine. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFLOGIN
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 call the getter functions to complete the cfloginuser tag, it does not work. I am trying not to tie the cflogin stuff into the cfc so that I can use this in other apps where we do not wish to use the built in role based security. THIS WORKS (cfloginuser is insde the cfc) cfoutput cflogin cfif NOT isDefined(cflogin) cfinclude template=form_login.cfm / cfabort cfelse cfif objAuthentication.login(form.j_username,form.j_password) IS true cflocation url="" addtoken=No / cfelse cfset request.message = Please, try again. / cfinclude template=form_login.cfm / cfabort /cfif /cfif /cflogin /cfoutput THIS DOES NOT WORK (loginuser is not inside the cfc): cfoutput cflogin cfif NOT isDefined(cflogin) cfinclude template=form_login.cfm / cfabort cfelse cfif objAuthentication.login(form.j_username,form.j_password) IS true cfloginuser name=#objAuthentication.getUsername()#,#objAuthentication.getUserId()# password=#objAuthentication.getPassword()# roles=ADMIN,GU / cflocation url="" addtoken=No / cfelse cfset request.message = Please, try again. / cfinclude template=form_login.cfm / cfabort /cfif /cfif /cflogin /cfoutput Why would one work and not the other? Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to determine if a scheduled task is already running?
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
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 many, = many reasons. I've got Apache up and running fine but having weird = problems with CFMX 6.1 -- I've run the Apache_Connector.bat to modify = Apache and the httpd.conf looks normal for CFMX 6.1, but while the CF = templates run, the relative pathing is really messed up -- all the = images disappear for example with bad links=20 I've got 3 production servers running Apache 2.048/CFMX 6.1 on Win2k in = production, so I certainly have done the Apache/CFMX install before -- = and I copied the virtual hosting section of one of those functional = servers over to the development box (changing to appropraite IPs, = virtual host names) so pretty confident *that* part of the configuration = is right -- problem is with the Apache/CFMX integration, not Apache = itself. So basically the question it, should I just uninstall CFMX from the box = and then reinstall it pointing to Apache or is there some instructions = for manually setting up this scenario I've missed. I *have* noticed that = the standalone install has a j2ee-web.xml file that my production = servers do not, so guessing there's a few steps I've missed... Is there = somewhere I can find the difference Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to determine if a scheduled task is already running?
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 Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 12:47 PM To: CF-Talk Subject: How to determine if a scheduled task is already running? Simple question (relatively).Is there a way to determine if a specific scheduled task is running?I'm using CFMX 6.1 on Win2K. Thanks Pete [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Outputting an XML Object to browser
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 with: cfcontent type=text/xml reset=yes CFOUTPUT#myDoc#/CFOUTPUT -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 5:30 PM To: CF-Talk Subject: RE: Outputting an XML Object to browser I've created an XML object from a query (using CFSAVECONTENT) and it CFDUMPs just fine.Now I simply need to output that as XML to the browser (or calling application). I keep getting: The XML page cannot be displayed Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later. Invalid at the top level of the document. Error processing resource 'http://10.0.0.1/Admin/administrators/xml/reviews-api.cfm'. Line 1, Position 1 [EMAIL PROTECTED] ^ Here's the output code I'm using currently: (myDoc was created with CFSAVECONTENT) CFSETTING showdebugoutput=No cfcontent type=text/xml Reset=yes cfoutput#ToString(myDoc)#/cfoutput I've also tried creating myDoc with CFXML - same error result, and I've tried this: cfset myXmlObj = XMLParse(myDoc) !--- cfdump var=#myxmlObj# --- CFSETTING showdebugoutput=No cfcontent type=text/xml Reset=yes cfoutput#myDoc#/cfoutput I don't think you need to use ToString with something you create using CFSAVECONTENT, although I don't see why it would screw things up either. I'd recommend that you skip the CFSAVECONTENT, and use CFXML to create your document, and use ToString to output your document. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFCookie Question
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 Unsubscribe] [User Settings]
OT: Gen purpose log analyzer
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] [Fast Unsubscribe] [User Settings]
Installing Dreamweaver mx 6.1 on machine running cf 5 server
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 running the client and server tools on the same box. Thanks, Don [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to determine if a scheduled task is already running?
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 checks and balances in place?Absolutely. -Novak -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 7:33 AM To: CF-Talk Subject: RE: How to determine if a scheduled task is already running? 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]
RE: Gen purpose log analyzer
take a look at http://www.abacre.com/ala/index.htm 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] Sent: Wednesday, November 12, 2003 8:32 AM To: CF-Talk Subject: OT: Gen purpose log analyzer 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] [Fast Unsubscribe] [User Settings]
CFMX integration with virus scanners?
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 be scanned and dealt with. Does anyone have any experience they could share about hooking a web app to such an engine? I've looked at the Symantec Antivirus Scan Engine but not enough to tell if it will do what we want. Also, the engine should run on Linux. Thanks. -- Howard Fore, [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How to determine if a scheduled task is already running?
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: cf-talk [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 11:35 AM To: CF-Talk Subject: RE: How to determine if a scheduled task is already running? 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 checks and balances in place?Absolutely. -Novak -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 7:33 AM To: CF-Talk Subject: RE: How to determine if a scheduled task is already running? 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]
cfhttp connection failure
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. Please help me... it's been put into my lap late and needing attention cheers -dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfprocessingdirective and Unicode
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 cfprocessingdirective pageEncoding=utf-8 Its my understanding this is technically redundant but making the statement explicit is a best practice.Is that incorrect? Presently I'm planning on plugging in the code in all files that either a)output to the screen, b)interact with the db, c)interact with a file stored on disk in utf-8 format or d)if form or url vars are being processed. The statement is to go in individually, one at a time, on every template including includes and called modules.Am I overdoing it? I am also doing cfcontent type=text/html; charset=utf-8 and using setencoding on form and url vars, but will do these once in the app in an include and application.cfm, respectively. Any advice pro/con the above would be appreciated. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX integration with virus scanners?
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 Actually, I think this might be Windows only, but you can ask them to be sure. 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 be scanned and dealt with. Does anyone have any experience they could share about hooking a web app to such an engine? I've looked at the Symantec Antivirus Scan Engine but not enough to tell if it will do what we want. Also, the engine should run on Linux. Thanks. -- Howard Fore, [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Gen purpose log analyzer
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 processing them locally, IMHO. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to determine if a scheduled task is already running?
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 notification, any ideas here? Have a database table that is appended to each time the task runs. Have something reliable check the most recent entry, and do something if it's over a day old or whatever. Sooner or later you have to have a scheduler that you trust to run things though :-) We use Mon for this. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:cfhttp connection failure
Forget it... doesn't matter now -dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Admin question about multiple email addresses
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 manually change my email address, then change it back to my work one in the morning... If I log out and create a new account, I am given the option of multiple email addresses is it because I have an old account? Am I missing something?A secondary email address would be quite useful for me Cheers! -dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IIS4 FTP Service Does Not restart on server reboot
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 me pointers on this?With regards to NT4 Server, IIS4, up to date with the major patches from MS We have an old box that is used for static HTML pages and FTP service is utilised to allow uploading for users to specific directories using NT permissions. We also have Perception Assessment software and the infrastructure geezers tell me that this piece of software requires that the server be restarted every morning to ensure that the software works correctly. Thing is, every couple of days the FTP service (not the WWW service tho) just fails to start and then of course the support calls start flooding in, somebody's gotta run through and restart the service. Which is getting annoying :-) Had a look at the event viewer and there is nothing out of the ordinary in there that doesn't happen every day due to the restart Can anybody give me pointers on where to look/fix/boot to fix this problem? Cheers -dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Admin question about multiple email addresses
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-Talk Subject: Admin question about multiple email addresses 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 manually change my email address, then change it back to my work one in the morning... If I log out and create a new account, I am given the option of multiple email addresses is it because I have an old account? Am I missing something?A secondary email address would be quite useful for me Cheers! -dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Custom tag to see list of cached queries!
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 available from http://tamuri.cfdeveloper.co.uk/ Thanks, Tamuri [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Admin question about multiple email addresses
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 for them by hand. I'm trying to work at a really terrible job while looking for something better and it's taking all my energy. :( 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-Talk Subject: Admin question about multiple email addresses 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 manually change my email address, then change it back to my work one in the morning... If I log out and create a new account, I am given the option of multiple email addresses is it because I have an old account? Am I missing something?A secondary email address would be quite useful for me Cheers! -dc _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Admin question about multiple email addresses
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 bitten the bullet and created a new account) not that I've ever coded a newslist send like that... recently anyway ;-) -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 12 November 2003 17:42 To: CF-Talk Subject: RE: Admin question about multiple email addresses 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-Talk Subject: Admin question about multiple email addresses 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 manually change my email address, then change it back to my work one in the morning... If I log out and create a new account, I am given the option of multiple email addresses is it because I have an old account? Am I missing something?A secondary email address would be quite useful for me Cheers! -dc _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Dissappearing session.sessionid
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' Should this not be created on every request where the CF Server hasn't already initialised it? Cheers.. David PS I'm off home now had a bad enuff day of it as it is :-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 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: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 12 November 2003 17:51 To: CF-Talk Subject: Re: Admin question about multiple email addresses 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 for them by hand. I'm trying to work at a really terrible job while looking for something better and it's taking all my energy. :( 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-Talk Subject: Admin question about multiple email addresses 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 manually change my email address, then change it back to my work one in the morning... If I log out and create a new account, I am given the option of multiple email addresses is it because I have an old account? Am I missing something?A secondary email address would be quite useful for me Cheers! -dc _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Admin question about multiple email addresses
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 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: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 12 November 2003 17:51 To: CF-Talk Subject: Re: Admin question about multiple email addresses 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 for them by hand. I'm trying to work at a really terrible job while looking for something better and it's taking all my energy. :( 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-Talk Subject: Admin question about multiple email addresses 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 manually change my email address, then change it back to my work one in the morning... If I log out and create a new account, I am given the option of multiple email addresses is it because I have an old account? Am I missing something?A secondary email address would be quite useful for me Cheers! -dc _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Dissappearing session.sessionid
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
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] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 12:51 PM To: CF-Talk Subject: Re: Admin question about multiple email addresses 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 for them by hand. I'm trying to work at a really terrible job while looking for something better and it's taking all my energy. :( 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-Talk Subject: Admin question about multiple email addresses 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 manually change my email address, then change it back to my work one in the morning... If I log out and create a new account, I am given the option of multiple email addresses is it because I have an old account? Am I missing something?A secondary email address would be quite useful for me Cheers! -dc _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFILE Deletinng Files
I'm getting an Access Denied Error.WHYplease helpy. :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Admin question about multiple email addresses
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... 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] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 12:51 PM To: CF-Talk Subject: Re: Admin question about multiple email addresses 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 for them by hand. I'm trying to work at a really terrible job while looking for something better and it's taking all my energy. :( 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-Talk Subject: Admin question about multiple email addresses 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 manually change my email address, then change it back to my work one in the morning... If I log out and create a new account, I am given the option of multiple email addresses is it because I have an old account? Am I missing something?A secondary email address would be quite useful for me Cheers! -dc _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Session and Client variable problems?
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 so that explains that. Each of the separate sites have an Application page that is set up basically with the code below. Each sites has the exact same info in the App.cfm file except for some path stuff that I use. cfapplication name=eProduct clientmanagement=Yes setclientcookies=Yes sessionmanagement=yes SESSIONTIMEOUT=#CreateTimeSpan(0,8,0,0)# APPLICATIONTIMEOUT=#CreateTimeSpan(0,8,0,0)# SETDOMAINCOOKIES=Yes Ok, now on each of these sites you can order items. I do that with the code below using a client variable. cfset SC_cart = client. Attributes.Cart So basically here is my problem I want the cart to be globally available to all sites. I though setting my domain cookie flag to yes would accomplish that but apparently in conjunction with using client variables for my cart that is not the case. Anyone got any ideas??? Thanks, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX61 and Oracle 8.1.7
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 present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
JavaScript question
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 to hit the go button and it will take me to the table definition lower in the page beneath the form. The parsing piece works, the problem I am having is trying to get the url to post correctly through the form to go down to the part in the page the data is. Here is my code. any ideas? cfquery name=gettabs datasource=dictionary SELECT DISTINCT tablename FROM dictionary ORDER BY tableName /cfquery cfquery name=getdic datasource=dictionary SELECT * FROM dictionary ORDER BY tableName,fieldname /cfquery SCRIPT LANGUAGE=_javascript_ function goTo(url) { location.href = ""> } /SCRIPT SCRIPT language=_javascript_ function searchSelectBox(in_sFormName, in_sInputName, in_sSelectName) { sSearchString = document.forms[in_sFormName].elements[in_sInputName].value.toUpperCase(); iSearchTextLength = sSearchString.length; for (j=0; j document.forms[in_sFormName].elements[in_sSelectName].options.length; j++) { sOptionText = document.forms[in_sFormName].elements[in_sSelectName].options[j].text; sOptionComp = sOptionText.substr(0, iSearchTextLength).toUpperCase(); if(sSearchString == sOptionComp) { document.forms[in_sFormName].elements[in_sSelectName].selectedIndex = j; break; } } } /SCRIPT body FORM NAME=SearchForm INPUT type=text name=edSeachInput searchSelectBox('SearchForm', 'edSeachInput', 'cbSearchSelect')BR select NAME=cbSearchSelect > cfoutput query=gettabs option value=index.cfm###tablename##UCase(tablename)#/option /cfoutput /select input type=submit value=go > /FORM p cfoutput query=getdic group=tablename table width=760 valign=top tr valign=top td valign=top colspan=4ba name=#tablename##UCase(tablename)#/a/b/td /tr tr bgcolor=cc td valign=top width=30%font size=2Column/font/td td valign=top width=15%font size=2Data Type/font/td td valign=top width=5%font size=2Size/font/td td valign=top width=50%font size=2Description/font/td /tr cfoutput tr td valign=topfont size=2#fieldname#/font/td td valign=topfont size=2#fielddatatype#/font/td td valign=topfont size=2#fieldlength#/font/td td valign=topfont size=2#fielddesc#/font/td /tr /cfoutput trtd colspan=4a href="" font color=red size=1back to top/font/abrnbsp;/td/tr /table /cfoutput /body [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX61 and Oracle 8.1.7
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 -0500 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 present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFFILE Deletinng Files
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 SYSTEM (on Windows), it usually has rights to delete any file on the machine by default, but if you've changed filesystem ACLs, that may not be true. So, it's more likely that the file is locked. If you did anything to the file within the same CF program, or if the file was requested by a browser, it may well be locked. You can shorten this file locking time within IIS's configuration. You might want to read this stuff: http://support.microsoft.com/default.aspx?scid=kb;en-us;265279 You might also find it useful to post more details about what exactly you're trying to do, and the environment in which you're trying to do it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Session and Client variable problems?
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 issue, what I did was create a separate domain that the people log into.For instance, you might create cart.domain.com and have all of your different carts point to that domain.Then they always stay on the same domain.Not sure if that helps or meets your needs. John Burns -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 1:29 PM To: CF-Talk Subject: Session and Client variable problems? 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 so that explains that. Each of the separate sites have an Application page that is set up basically with the code below. Each sites has the exact same info in the App.cfm file except for some path stuff that I use. cfapplication name=eProduct clientmanagement=Yes setclientcookies=Yes sessionmanagement=yes SESSIONTIMEOUT=#CreateTimeSpan(0,8,0,0)# APPLICATIONTIMEOUT=#CreateTimeSpan(0,8,0,0)# SETDOMAINCOOKIES=Yes Ok, now on each of these sites you can order items. I do that with the code below using a client variable. cfset SC_cart = client. Attributes.Cart So basically here is my problem I want the cart to be globally available to all sites. I though setting my domain cookie flag to yes would accomplish that but apparently in conjunction with using client variables for my cart that is not the case. Anyone got any ideas??? Thanks, Stephen _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Installing Dreamweaver mx 6.1 on machine running cf 5 server
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 Dreamweaver mx 6.1 on machine running cf 5 server 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 running the client and server tools on the same box. Thanks, Don [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Multiple Server Versions
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 about potential screwups stemming from developing an application on the J2EE version and deploying it on the Standard version. That a baseless concern?If not, anyone have any clever ideas to have two distinct installs of Standard on a single machine (aside from using different Apache installs and different ports?). We're running Apache2 on linux along with CF, if that matters at all. TIA, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax: 360.647.5351 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Outputting an XML Object to browser
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 the ToString() function with a validated XML object, and cfsavecontent works like a charm in the same situation. I've googled and found others that have had the same problem.So, cfsavecontent might save you a headache down the road, otherwise use cfxml at your own risk- Tyler (see message from monday: http://www.houseoffusion.com/cf_lists/index.cfm?method=message http://www.houseoffusion.com/cf_lists/index.cfm?method=messagemessageID=14 3641forumid=4 messageID=143641forumid=4 ) _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 5:30 PM To: CF-Talk Subject: RE: Outputting an XML Object to browser I've created an XML object from a query (using CFSAVECONTENT) and it CFDUMPs just fine.Now I simply need to output that as XML to the browser (or calling application). I keep getting: The XML page cannot be displayed Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later. Invalid at the top level of the document. Error processing resource 'http://10.0.0.1/Admin/administrators/xml/reviews-api.cfm'. Line 1, Position 1 [EMAIL PROTECTED] ^ Here's the output code I'm using currently: (myDoc was created with CFSAVECONTENT) CFSETTING showdebugoutput=No cfcontent type=text/xml Reset=yes cfoutput#ToString(myDoc)#/cfoutput I've also tried creating myDoc with CFXML - same error result, and I've tried this: cfset myXmlObj = XMLParse(myDoc) !--- cfdump var=#myxmlObj# --- CFSETTING showdebugoutput=No cfcontent type=text/xml Reset=yes cfoutput#myDoc#/cfoutput I don't think you need to use ToString with something you create using CFSAVECONTENT, although I don't see why it would screw things up either. I'd recommend that you skip the CFSAVECONTENT, and use CFXML to create your document, and use ToString to output your document. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Session and Client variable problems?
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.Now I develop without the setting and put it in only after a domain gets assigned to an IP. -- --- Matt Robertson,[EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Ghost variables
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 scope for 'general' use so I don't have to worry about locking. Here's the code: cflock timeout=10 throwontimeout=no type=exclusive scope=session cfset Session.pid = form.pid cfset Request.Ses = Duplicate(Session) /cflock Now I have a user that says that he chooses a profile say profile 150, the profile page displays correctly, but when he clicks on another tab, I have one for enrollments, he will get the information for another profile, say 200. All I am doing on the enrollment page is a few queries with the where clause: WHERE ProfileID = cfqueryparam value=#request.ses.pid# cfsqltype=CF_SQL_SMALLINT I cannot replicate his problem. It seems like it might be browser cahce related, since the URL of the page remains the same and only the request variable will be different. Does this make sense? How can I fix it? Thanks John Venable --- John Venable Director of Web Architecture Epilepsy Foundation [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Outputting an XML Object to browser
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'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 the ToString() function with a validated XML object, and cfsavecontent works like a charm in the same situation. I've googled and found others that have had the same problem.So, cfsavecontent might save you a headache down the road, otherwise use cfxml at your own risk- Tyler [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Multiple versions of IE on the same machine!!!
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, Australia AFP Webworks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multiple Server Versions
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 can isolate the processor on Linux (never tried it myself) but if you can, then you should be ok. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 2:15 PM To: CF-Talk Subject: Multiple Server Versions 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 about potential screwups stemming from developing an application on the J2EE version and deploying it on the Standard version. That a baseless concern?If not, anyone have any clever ideas to have two distinct installs of Standard on a single machine (aside from using different Apache installs and different ports?). We're running Apache2 on linux along with CF, if that matters at all. TIA, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax: 360.647.5351 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JavaScript question
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.com/ -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 1:21 PM To: CF-Talk Subject: _javascript_ question 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 to hit the go button and it will take me to the table definition lower in the page beneath the form. The parsing piece works, the problem I am having is trying to get the url to post correctly through the form to go down to the part in the page the data is. Here is my code. any ideas? cfquery name=gettabs datasource=dictionary SELECT DISTINCT tablename FROM dictionary ORDER BY tableName /cfquery cfquery name=getdic datasource=dictionary SELECT * FROM dictionary ORDER BY tableName,fieldname /cfquery SCRIPT LANGUAGE=_javascript_ function goTo(url) { location.href = ""> } /SCRIPT SCRIPT language=_javascript_ function searchSelectBox(in_sFormName, in_sInputName, in_sSelectName) { sSearchString = document.forms[in_sFormName].elements[in_sInputName].value.toUpperCase(); iSearchTextLength = sSearchString.length; for (j=0; j document.forms[in_sFormName].elements[in_sSelectName].options.length; j++) { sOptionText = document.forms[in_sFormName].elements[in_sSelectName].options[j].text; sOptionComp = sOptionText.substr(0, iSearchTextLength).toUpperCase(); if(sSearchString == sOptionComp) { document.forms[in_sFormName].elements[in_sSelectName].selectedIndex = j; break; } } } /SCRIPT body FORM NAME=SearchForm INPUT type=text name=edSeachInput > searchSelectBox('SearchForm', 'edSeachInput', 'cbSearchSelect')BR select NAME=cbSearchSelect > cfoutput query=gettabs option value=index.cfm###tablename##UCase(tablename)#/option /cfoutput /select input type=submit value=go > /FORM p cfoutput query=getdic group=tablename table width=760 valign=top tr valign=top td valign=top colspan=4ba name=#tablename##UCase(tablename)#/a/b/td /tr tr bgcolor=cc td valign=top width=30%font size=2Column/font/td td valign=top width=15%font size=2Data Type/font/td td valign=top width=5%font size=2Size/font/td td valign=top width=50%font size=2Description/font/td /tr cfoutput tr td valign=topfont size=2#fieldname#/font/td td valign=topfont size=2#fielddatatype#/font/td td valign=topfont size=2#fieldlength#/font/td td valign=topfont size=2#fielddesc#/font/td /tr /cfoutput trtd colspan=4a href="" font color=red size=1back to top/font/abrnbsp;/td/tr /table /cfoutput /body [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multiple Server Versions
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, the production sites are going to suffer. Now I don't know if you can isolate the processor on Linux (never tried it myself) but if you can, then you should be ok. There is ways of creating whole virtual systems on Linux where you can even give out root since the virtual system is run in a sandbox. However, whether you use such an approach or not, it is possible to limit the amount of CPU time a particular user can have. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multiple Server Versions
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 on the J2EE version and then deploying to Standard version a big deal?.Aside from a few obvious things (CFIMPORT of JSP tag libs, some CF admin functions, etc) are there any potentially confounding differences between the editions? thanks, barneyb -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 11:38 AM To: CF-Talk Subject: RE: Multiple Server Versions 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 can isolate the processor on Linux (never tried it myself) but if you can, then you should be ok. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 2:15 PM To: CF-Talk Subject: Multiple Server Versions 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 about potential screwups stemming from developing an application on the J2EE version and deploying it on the Standard version. That a baseless concern?If not, anyone have any clever ideas to have two distinct installs of Standard on a single machine (aside from using different Apache installs and different ports?). We're running Apache2 on linux along with CF, if that matters at all. TIA, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax: 360.647.5351 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Odd db error
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
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 x105 [EMAIL PROTECTED] -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 2:51 PM To: CF-Talk Subject: RE: Multiple Server Versions 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 on the J2EE version and then deploying to Standard version a big deal?.Aside from a few obvious things (CFIMPORT of JSP tag libs, some CF admin functions, etc) are there any potentially confounding differences between the editions? thanks, barneyb -Original Message- From: Dan Phillips (CFXHosting.com) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 11:38 AM To: CF-Talk Subject: RE: Multiple Server Versions 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 can isolate the processor on Linux (never tried it myself) but if you can, then you should be ok. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 2:15 PM To: CF-Talk Subject: Multiple Server Versions 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 about potential screwups stemming from developing an application on the J2EE version and deploying it on the Standard version. That a baseless concern?If not, anyone have any clever ideas to have two distinct installs of Standard on a single machine (aside from using different Apache installs and different ports?). We're running Apache2 on linux along with CF, if that matters at all. TIA, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax: 360.647.5351 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Odd db error
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 Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: DeMarco, Alex To: CF-Talk Sent: Wednesday, November 12, 2003 11:51 AM Subject: Odd db error 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
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 -- Blog:http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 2:51 PM To: CF-Talk Subject: RE: Multiple Server Versions 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 on the J2EE version and then deploying to Standard version a big deal?.Aside from a few obvious things (CFIMPORT of JSP tag libs, some CF admin functions, etc) are there any potentially confounding differences between the editions? thanks, barneyb [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Odd db error
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 forums to get instructions on how to downgrade to the DataDirect 3.1 drivers (from CFMX 6.0) -- I didn't have luck with this one: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6threadid= 684306 Third, you can use your vendor-specific drivers (for example SQL Server, use Microsoft's JDBC driver), check this page for info: http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_config_mssql2 000.htm -nathan strutz -Original Message- From: DeMarco, Alex [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 12:51 PM To: CF-Talk Subject: Odd db error 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
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 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 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Odd db error
This is a known bug with CFMX 6.1. Look here: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6threadid=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 pm Subject: Re: Odd dberror 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 Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: DeMarco, Alex To: CF-Talk Sent: Wednesday, November 12, 2003 11:51 AM Subject: Odd db error 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: JavaScript question
Thanks. But it did not help In my url window I get the following http://localhost:8500/dictionary/index.cfm?edSeachInput=personde http://localhost:8500/dictionary/index.cfm?edSeachInput=persondecbSearchSelect=index.cfm%23PersonDemographic cbSearchSelect=index.cfm%23PersonDemographic I am expecting http://localhost:8500/dictionary/index.cfm#PersonDemographic -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 1:39 PM To: CF-Talk Subject: RE: _javascript_ question 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.com/ -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 1:21 PM To: CF-Talk Subject: _javascript_ question 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 to hit the go button and it will take me to the table definition lower in the page beneath the form. The parsing piece works, the problem I am having is trying to get the url to post correctly through the form to go down to the part in the page the data is. Here is my code. any ideas? cfquery name=gettabs datasource=dictionary SELECT DISTINCT tablename FROM dictionary ORDER BY tableName /cfquery cfquery name=getdic datasource=dictionary SELECT * FROM dictionary ORDER BY tableName,fieldname /cfquery SCRIPT LANGUAGE=_javascript_ function goTo(url) { location.href = ""> } /SCRIPT SCRIPT language=_javascript_ function searchSelectBox(in_sFormName, in_sInputName, in_sSelectName) { sSearchString = document.forms[in_sFormName].elements[in_sInputName].value.toUpperCase(); iSearchTextLength = sSearchString.length; for (j=0; j document.forms[in_sFormName].elements[in_sSelectName].options.length; j++) { sOptionText = document.forms[in_sFormName].elements[in_sSelectName].options[j].text; sOptionComp = sOptionText.substr(0, iSearchTextLength).toUpperCase(); if(sSearchString == sOptionComp) { document.forms[in_sFormName].elements[in_sSelectName].selectedIndex = j; break; } } } /SCRIPT body FORM NAME=SearchForm INPUT type=text name=edSeachInput > searchSelectBox('SearchForm', 'edSeachInput', 'cbSearchSelect')BR select NAME=cbSearchSelect > cfoutput query=gettabs option value=index.cfm###tablename##UCase(tablename)#/option /cfoutput /select input type=submit value=go > /FORM p cfoutput query=getdic group=tablename table width=760 valign=top tr valign=top td valign=top colspan=4ba name=#tablename##UCase(tablename)#/a/b/td /tr tr bgcolor=cc td valign=top width=30%font size=2Column/font/td td valign=top width=15%font size=2Data Type/font/td td valign=top width=5%font size=2Size/font/td td valign=top width=50%font size=2Description/font/td /tr cfoutput tr td valign=topfont size=2#fieldname#/font/td td valign=topfont size=2#fielddatatype#/font/td td valign=topfont size=2#fieldlength#/font/td td valign=topfont size=2#fielddesc#/font/td /tr /cfoutput trtd colspan=4a href="" font color=red size=1back to top/font/abrnbsp;/td/tr /table /cfoutput /body _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Query of query question
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
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 the 2000 cd in it. However, the system boots, recognizes the HDs, the light comes on the cd but it then reboots and does not start the Server 2000 setup. Did I explain enough or is there more to this than meets the eye? Thanks as always and excuse the OT on this please. Robert Orlini HW Wilson 718-588-8400 x2656 ¿ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JavaScript question
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 = document.SearchForm.cbSearchSelect.options[selIdx].value; } The function was not being passed any parameter and it made reference to a variable (number) that did not seem to exist.Also, it was not getting the value of the currently selected select list option.The above code corrects these problems. Then, change your select list's OPTION code to only include the anchor name and not the filename as in: cfoutput query=gettabs option value=#tablename##UCase(tablename)#/option /cfoutput Hopefully this will work for you.If not, let me know what the next error message is and we'll take it from there 8^). -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:36 PM To: CF-Talk Subject: RE: _javascript_ question Thanks. But it did not help In my url window I get the following http://localhost:8500/dictionary/index.cfm?edSeachInput=personde http://localhost:8500/dictionary/index.cfm?edSeachInput=persondecbSearchSe lect=index.cfm%23PersonDemographic cbSearchSelect=index.cfm%23PersonDemographic I am expecting http://localhost:8500/dictionary/index.cfm#PersonDemographic -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 1:39 PM To: CF-Talk Subject: RE: _javascript_ question 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.com/ -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 1:21 PM To: CF-Talk Subject: _javascript_ question 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 to hit the go button and it will take me to the table definition lower in the page beneath the form. The parsing piece works, the problem I am having is trying to get the url to post correctly through the form to go down to the part in the page the data is. Here is my code. any ideas? cfquery name=gettabs datasource=dictionary SELECT DISTINCT tablename FROM dictionary ORDER BY tableName /cfquery cfquery name=getdic datasource=dictionary SELECT * FROM dictionary ORDER BY tableName,fieldname /cfquery SCRIPT LANGUAGE=_javascript_ function goTo(url) { location.href = ""> } /SCRIPT SCRIPT language=_javascript_ function searchSelectBox(in_sFormName, in_sInputName, in_sSelectName) { sSearchString = document.forms[in_sFormName].elements[in_sInputName].value.toUpperCase(); iSearchTextLength = sSearchString.length; for (j=0; j document.forms[in_sFormName].elements[in_sSelectName].options.length; j++) { sOptionText = document.forms[in_sFormName].elements[in_sSelectName].options[j].text; sOptionComp = sOptionText.substr(0, iSearchTextLength).toUpperCase(); if(sSearchString == sOptionComp) { document.forms[in_sFormName].elements[in_sSelectName].selectedIndex = j; break; } } } /SCRIPT body FORM NAME=SearchForm INPUT type=text name=edSeachInput > searchSelectBox('SearchForm', 'edSeachInput', 'cbSearchSelect')BR select NAME=cbSearchSelect > cfoutput query=gettabs option value=index.cfm###tablename##UCase(tablename)#/option /cfoutput /select input type=submit value=go > /FORM p cfoutput query=getdic group=tablename table width=760 valign=top tr valign=top td valign=top colspan=4ba name=#tablename##UCase(tablename)#/a/b/td /tr tr bgcolor=cc td valign=top width=30%font size=2Column/font/td td valign=top width=15%font size=2Data Type/font/td td valign=top width=5%font size=2Size/font/td td valign=top width=50%font size=2Description/font/td /tr cfoutput tr td valign=topfont size=2#fieldname#/font/td td valign=topfont size=2#fielddatatype#/font/td td valign=topfont size=2#fieldlength#/font/td td valign=topfont size=2#fielddesc#/font/td /tr /cfoutput trtd colspan=4a href="" font color=red size=1back to top/font/abrnbsp;/td/tr /table /cfoutput /body _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Query of query question
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] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query of query question
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 delete a record from a query using QofQ. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Scsi hd
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 mine momentary, when doing an install, flashing to a BSOD (Blue Screen Of Death), then rebooting, if I did not load the driver for my Adaptec card. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:03 PM To: CF-Talk Subject: OT - Scsi hd 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 the 2000 cd in it. However, the system boots, recognizes the HDs, the light comes on the cd but it then reboots and does not start the Server 2000 setup. Did I explain enough or is there more to this than meets the eye? Thanks as always and excuse the OT on this please. Robert Orlini HW Wilson 718-588-8400 x2656 ¿ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query of query question
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 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] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT - Scsi hd
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 (floppy) or (cd) provided with your SCSI drive when you purchased them. Just insert the disk, select the appropriate drive and off you go. If you do not have the disk then you are in bad luck unless you can get to a PC/MAC get on the net and download one. Steve -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:34 PM To: CF-Talk Subject: RE: OT - Scsi hd 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 mine momentary, when doing an install, flashing to a BSOD (Blue Screen Of Death), then rebooting, if I did not load the driver for my Adaptec card. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:03 PM To: CF-Talk Subject: OT - Scsi hd 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 the 2000 cd in it. However, the system boots, recognizes the HDs, the light comes on the cd but it then reboots and does not start the Server 2000 setup. Did I explain enough or is there more to this than meets the eye? Thanks as always and excuse the OT on this please. Robert Orlini HW Wilson 718-588-8400 x2656 ¿ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Import/Export - Excel to/from Access/SQL Server
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 to do all of his data entry in Excel, and then do an import into his tables to add new records, and edit/delete existing records. I had thought about doing an import/export routine to/from an Excel file, but the export alone pegs the server at 100% CPU for almost 25-30 seconds. I am interested in setting up the most efficient method that will minimize the load on the server. Any suggestions would be appreciated! Thank you, Stan Winchester Aftershock Web Design, LLC [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Import/Export - Excel to/from Access/SQL Server
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 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 to do all of his data entry in Excel, and then do an import into his tables to add new records, and edit/delete existing records. I had thought about doing an import/export routine to/from an Excel file, but the export alone pegs the server at 100% CPU for almost 25-30 seconds. I am interested in setting up the most efficient method that will minimize the load on the server. Any suggestions would be appreciated! Thank you, Stan Winchester Aftershock Web Design, LLC [EMAIL PROTECTED] http://www.aftershockweb.com/http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Import/Export - Excel to/from Access/SQL Server
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 [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 1:46 PM To: CF-Talk Subject: Import/Export - Excel to/from Access/SQL Server 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 to do all of his data entry in Excel, and then do an import into his tables to add new records, and edit/delete existing records. I had thought about doing an import/export routine to/from an Excel file, but the export alone pegs the server at 100% CPU for almost 25-30 seconds. I am interested in setting up the most efficient method that will minimize the load on the server. Any suggestions would be appreciated! Thank you, Stan Winchester Aftershock Web Design, LLC [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Import/Export - Excel to/from Access/SQL Server
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 serialization and de-serialization.It's a lot of work, but it worked out well and client was very happy in end. HTH, Sam -- Blog:http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:46 PM To: CF-Talk Subject: Import/Export - Excel to/from Access/SQL Server 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 to do all of his data entry in Excel, and then do an import into his tables to add new records, and edit/delete existing records. I had thought about doing an import/export routine to/from an Excel file, but the export alone pegs the server at 100% CPU for almost 25-30 seconds. I am interested in setting up the most efficient method that will minimize the load on the server. Any suggestions would be appreciated! Thank you, Stan Winchester [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Query of query question
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 Subject: Query of query question 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]
Best Practices
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 same queries on different tables, and update them as well. Each page is a report is a self posting page that has reports that need to be checked off by the user as completed. So now this is what I am trying to do.When the user clicks on the report I have appended ?Reportname=myreport to the link. Now I have a case statement that uses #url.reportname# that will set all my variables for that page.Until now it is fine.The only problem that I am running into is when I try posting the page to itself to the the update (set the completed from 0 to 1) of course my reportname variable is non existant.What would be the most best way to do set up this?When I try to post the same page of course my URL.ReportName does not exist so my switch statement does not work. Any pointers in the right direction would be much appreciated. Thanks. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Joins in Excel?
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 database, such as membership type, etc. I could write a CF script to join the tables and dynamically produce an Excel spreedsheet that can be downloaded from the web server.But I was wondering if I just cut and pasted several tables onto different worksheets in an Excel file, can I do something like a join of the main worksheet with the others in the same file? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Best Practices
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 is fine.The M only problem that I am running into is when I try posting the page M to itself to the the update (set the completed from 0 to 1) of M course my reportname variable is non existant.What would be the M most best way to do set up this?When I try to post the same page M of course my URL.ReportName does not exist so my switch statement M does not work. This should allow your form to pass the URL.ReportName variable back to the processor: form action=""> or form action=""> ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Import/Export - Excel to/from Access/SQL Server
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 data integrity. I'll setup data constraints when I build the SQL Server database, though I wonder if there is there a way to force data integrity in Excel? Thanks, Stan 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 [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 1:46 PM To: CF-Talk Subject: Import/Export - Excel to/from Access/SQL Server 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 to do all of his data entry in Excel, and then do an import into his tables to add new records, and edit/delete existing records. I had thought about doing an import/export routine to/from an Excel file, but the export alone pegs the server at 100% CPU for almost 25-30 seconds. I am interested in setting up the most efficient method that will minimize the load on the server. Any suggestions would be appreciated! Thank you, Stan Winchester Aftershock Web Design, LLC [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFCookie Question
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 PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 7:33 AM To: CF-Talk Subject: CFCookie Question 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 Unsubscribe] [User Settings]
Comparing Values
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 CLOOP query using the first query to loop over the second query.So it's basically like #firstquery.recordcount# loops and checking each value. pseudo code CFLOOP query=firstquery CFQUERY name=secondquery SELECT name from images where project_id = #url.id# AND name = #name# /CFQUERY CFIF secondquey.recordcount EQ 0 CFSET error_list = listappened(error_list, name) /CFIF /CFLOOP CFOUTPUT#error_list#/CFOUTPUT Right now, it takes like minutes to get results!Even if there's only 1 value in the list!Is there a better way to do what I am doing?Or some way to make it faster?Cos this is slow!Thankie! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Comparing Values
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: cfset idList = valueList(firstQuery.idField) cfquery name=secondQuery datasource=blah select columns from table where table.idField in (#valueList) /cfquery Should head you down towards a quicker solution.The other idea would be to alias the table against itself and do a join against itself something like: cfquery name=getStuff datasource=blah select t.columns, ta.columns from table t, table ta where t.this = ta.this OR where t.this != ta.this /cfquery Without knowing the table and the desired result though I am not sure if this is what your looking for at all. HTH Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 7:13 PM To: CF-Talk Subject: Comparing Values 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 CLOOP query using the first query to loop over the second query.So it's basically like #firstquery.recordcount# loops and checking each value. pseudo code CFLOOP query=firstquery CFQUERY name=secondquery SELECT name from images where project_id = #url.id# AND name = #name# /CFQUERY CFIF secondquey.recordcount EQ 0 CFSET error_list = listappened(error_list, name) /CFIF /CFLOOP CFOUTPUT#error_list#/CFOUTPUT Right now, it takes like minutes to get results!Even if there's only 1 value in the list!Is there a better way to do what I am doing?Or some way to make it faster?Cos this is slow!Thankie! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Comparing Values
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 the same are appended to a variable named error_list.I'm basically using a CLOOP query using the first query to loop over the second query.So it's basically like #firstquery.recordcount# loops and checking each value. pseudo code CFLOOP query=firstquery CFQUERY name=secondquery SELECT name from images where project_id = #url.id# AND name = #name# /CFQUERY CFIF secondquey.recordcount EQ 0 CFSET error_list = listappened(error_list, name) /CFIF /CFLOOP CFOUTPUT#error_list#/CFOUTPUT Your explanation and code are slightly inconsistent, but I presume you mean this: cfquery name=theQuery SELECT i.name FROM images i LEFT JOIN images j ON i.name = j.name WHERE i.project_id = cfqueryparam cfsqltype=cf_sql_integer value=#URL.firstID# AND j.project_id = cfqueryparam cfsqltype=cf_sql_integer value=#URL.secondID# AND j.name IS NULL /cfquery cfoutput#ValueList(theQuery.name)#/cfoutput Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Comparing Values
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 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 the same are appended to a variable named error_list.I'm basically using a CLOOP query using the first query to loop over the second query.So it's basically like #firstquery.recordcount# loops and checking each value. pseudo code CFLOOP query=firstquery CFQUERY name=secondquery SELECT name from images where project_id = #url.id# AND name = #name# /CFQUERY CFIF secondquey.recordcount EQ 0 CFSET error_list = listappened(error_list, name) /CFIF /CFLOOP CFOUTPUT#error_list#/CFOUTPUT Your explanation and code are slightly inconsistent, but I presume you mean this: cfquery name=theQuery SELECT i.name FROM images i LEFT JOIN images j ON i.name = j.name WHERE i.project_id = cfqueryparam cfsqltype=cf_sql_integer value=#URL.firstID# AND j.project_id = cfqueryparam cfsqltype=cf_sql_integer value=#URL.secondID# AND j.name IS NULL /cfquery cfoutput#ValueList(theQuery.name)#/cfoutput Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Best Practices
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 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 is fine.The M only problem that I am running into is when I try posting the page M to itself to the the update (set the completed from 0 to 1) of M course my reportname variable is non existant.What would be the M most best way to do set up this?When I try to post the same page M of course my URL.ReportName does not exist so my switch statement M does not work. This should allow your form to pass the URL.ReportName variable back to the processor: form action=""> or form action=""> ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ReSolved: Comparing Values
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 Values 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: cfset idList = valueList(firstQuery.idField) cfquery name=secondQuery datasource=blah select columns from table where table.idField in (#valueList) /cfquery Should head you down towards a quicker solution.The other idea would be to alias the table against itself and do a join against itself something like: cfquery name=getStuff datasource=blah select t.columns, ta.columns from table t, table ta where t.this = ta.this OR where t.this != ta.this /cfquery Without knowing the table and the desired result though I am not sure if this is what your looking for at all. HTH Timothy Heald Web Portfolio Manager Overseas Security Advisory Council U.S. Department of State 571.345.2319 The opinions expressed here do not necessarily reflect those of the U.S. Department of State or any affiliated organization(s).Nor have these opinions been approved or sanctioned by these organizations. This e-mail is unclassified based on the definitions in E.O. 12958. -Original Message- From: brob [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 7:13 PM To: CF-Talk Subject: Comparing Values 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 CLOOP query using the first query to loop over the second query.So it's basically like #firstquery.recordcount# loops and checking each value. pseudo code CFLOOP query=firstquery CFQUERY name=secondquery SELECT name from images where project_id = #url.id# AND name = #name# /CFQUERY CFIF secondquey.recordcount EQ 0 CFSET error_list = listappened(error_list, name) /CFIF /CFLOOP CFOUTPUT#error_list#/CFOUTPUT Right now, it takes like minutes to get results!Even if there's only 1 value in the list!Is there a better way to do what I am doing?Or some way to make it faster?Cos this is slow!Thankie! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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 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 get put into the HTTP request body. So, you could have a form like this: form action="" method=post input type=text name=foobar ... /form and in your action page, you could have code like this: cfoutput #URL.bar#br #Form.foobar# /cfoutput Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Best Practices
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 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 get put into the HTTP request body. So, you could have a form like this: form action="" method=post input type=text name=foobar ... /form and in your action page, you could have code like this: cfoutput #URL.bar#br #Form.foobar# /cfoutput Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Round and Format - Best Way?
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 - Mihi placent, O Pincerna! Virent ova! Viret perna! Dapem posthac non arcebo. Gratum tibi me praebebo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Comparing Values
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: cfquery name=theQuery SELECT i.name, i.project_id, j.name, j.project_id FROM ( SELECT name, project_id FROM images WHERE project_id = cfqueryparam cfsqltype=cf_sql_integer value=#URL.firstID# ) i LEFT JOIN ( SELECT name, project_id FROM images WHERE project_id = cfqueryparam cfsqltype=cf_sql_integer value=#URL.secondID# ) j ON i.name = j.name WHERE j.name IS NULL /cfquery cfoutput#ValueList(theQuery.name)#/cfoutput Jochem -- Who needs virtual reality if you can just dream? - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re[2]: Best Practices
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?
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).then a temp variable makes sense. cheers, barneyb -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:58 PM To: CF-Talk Subject: Round and Format - Best Way? 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 - Mihi placent, O Pincerna! Virent ova! Viret perna! Dapem posthac non arcebo. Gratum tibi me praebebo. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMail Send Problem
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 example, I've tested on Outlook 2002 and 2003 and AOL 9 with no problem, but we have others using Netscape 7.1, Outlook 98-2000, et al receiving blank messages). My thought is that there may be a problem with the charset encoding or with the syntax of cfsavecontent. Here's the process of what happens: 1) On the application.cfm page for the Admin area !--- URL and FORM encoding --- cfset setEncoding(FORM, ISO-8859-1) cfset setEncoding(URL, ISO-8859-1) !--- output encoding --- cfcontent type=text/html; charset=ISO-8859-1 2) Message data from form field (enctype=multipart/form) insered to MS-SQL2000 3) Query retrieves data from SQL 2000, in particular the qMailMessage.txtMessage is the body of the message. 4) Message composition cfoutput cfsavecontent variable=VARIABLES.textCopy #qMailMessage.txtMessage##crlf# cfif qMailMessage.unsubscribeLinkID NEQ 1#Replace(qMailMessage.unsubscribeLinkText, Chr(10), #lf#, ALL)##crlf#/cfif cfif qMailMessage.signatureLineID NEQ 1#Replace(qMailMessage.signatureLineText, Chr(10), #lf#, ALL)#/cfif /cfsavecontent /cfoutput 5) Message sendout !--- Send out to the subscribers --- cfmail from=#VARIABLES.mailFrom# #VARIABLES.mailFromEmail# query=qSubscribers group=emailAddress groupcasesensitive=no to=#firstname# #lastname# #emailaddress# cc=#copyTo# bcc=#blindCopyTo# subject=#VARIABLES.subjectLine# failto=#VARIABLES.mailFailTo# server=#REQUEST.mailserver# cfmailpart type=text#VARIABLES.textCopy#/cfmailpart cfmailparam name=Reply-To value=#VARIABLES.mailFrom# #VARIABLES.mailFromEmail# cfmailparam name=Message-ID value=#CreateUUID()[EMAIL PROTECTED] /cfmail === Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Wierd error in JRUN log for CFMX instance
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
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 for legibility at least. Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Best Practices
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. Andy -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:45 PM To: CF-Talk Subject: Best Practices 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 same queries on different tables, and update them as well. Each page is a report is a self posting page that has reports that need to be checked off by the user as completed. So now this is what I am trying to do.When the user clicks on the report I have appended ?Reportname=myreport to the link. Now I have a case statement that uses #url.reportname# that will set all my variables for that page.Until now it is fine.The only problem that I am running into is when I try posting the page to itself to the the update (set the completed from 0 to 1) of course my reportname variable is non existant. What would be the most best way to do set up this?When I try to post the same page of course my URL.ReportName does not exist so my switch statement does not work. Any pointers in the right direction would be much appreciated. Thanks. Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Network
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 frequently takes a bit longer for each image to show up. We can't have that, as this guy can tag anywhere from 70 to 85 images a minute. The images vary from 50k to 200k in size, and i am confused why that would slow down the network I thought a closed network in general is pretty fast.Is there any way to speed up the network?right now we use a 10/100mbps hub.and also i am wonderin how do u know if your network is running at 10mbps or 100mbps?? Or maybe it would help if we got a faster hard drive?right now it's a 7200rpm would it help to get a scsi hard drive, in terms of spitting out an image to the network? Thankie! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Network
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 == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases. Suggested corporate Anti-virus policy: http://www.dshield.org/antivirus.pdf == If you are not satisfied with my service, my job isn't done! - Original Message - From: brob [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:06 PM Subject: Network | 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 frequently takes a bit longer for each image to show up. We can't have that, as this guy can tag anywhere from 70 to 85 images a minute. | | The images vary from 50k to 200k in size, and i am confused why that would slow down the network I thought a closed network in general is pretty fast.Is there any way to speed up the network?right now we use a 10/100mbps hub.and also i am wonderin how do u know if your network is running at 10mbps or 100mbps?? | | Or maybe it would help if we got a faster hard drive?right now it's a 7200rpm would it help to get a scsi hard drive, in terms of spitting out an image to the network? | | Thankie! | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Re[2]: Best Practices
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. This isn't the case. POST and GET are ways to make HTTP requests, and CFMX can't deprecate them - it has nothing to do with how the browser sends data to the server. If you're referring to the CFFORM tag, which generates an HTML form for you, it will always generate a form with METHOD=POST, but this doesn't mean anything has been deprecated - this has always been the case with CFFORM, as far as I can recall. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]