RE: CF SQLOLEDB provider and Windows 2000
> I have just switched some CF applications over from an ODBC > datasource to the SQLOLEDB provider on a Windows NT Server > 4 machine, with Cold Fusion 4.01 Enterprise and SQL Server > 7, and it all seems to run just fine. > > However - an_identical_in every respect configuration, but > running under Windows 2000 Advanced Server seemingly won't > run the CF apps at all - at least to any significant extent. > > The SQLOLEDB datasources to the CF databases verify fine on > the Win2K machine. > > Win2K is, I think running MDAC 2.5, and in fact I have just > upgraded the NT Server machine to MDAC 2.5 RTM and which again, > runs everything fine. > > Has anyone encountered this problem before specifically with > the CF SQLOLEDB provider and Windows 2000, and if so - what > is the solution? CF 4.5?. The CF installation breaks the version of MDAC which comes with Win2K, MDAC 2.5. Unfortunately, you can't just reinstall MDAC 2.5 on Win2K. Instead, you'll have to "upgrade" Win2K to the latest version - which is probably what you're already running. Just put the Win2K CD in, select "Upgrade your current operating system", wait about half an hour through a couple of reboots, click "OK" a bunch of times, and when you're done, reinstall any drivers that didn't come with the Win2K distribution. After that, you shouldn't have any problems with OLEDB. Of course, if you install CF again, you might have to repeat the process! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OnClick event in CFForm v Form
> Its my experience that a javascript onclick event > works in a form, but not a cfform. Is this true? Any > workarounds for cfform? I've never had that problem. Can you show the code that isn't working? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: De-referencing dynamic variables
> No, currently there's no support for binary files. I haven't > really figured out how to get it to work-since the serialization > all occurs on the client side before the form is actually > submitted. I've played around with it, but have yet to come > up with a solution. (My hunch is, even though WDDX supports > binary files in the current rev, trying to store files within > the packet is going to be a no-no.) You're not going to be able to take the data from a file upload field and serialize it in JavaScript, simply because you don't have very much programmatic access to the file upload field for security reasons, and the browser doesn't do anything with the file until the form is submitted. In any case, if the file were of any size, and you were able to grab it on the client, convert it to base 64 text, and serialize it, you might break the form submission, because it uses a separate MIME part to segregate the uploaded file data, encoded in base 64, from the other form field stuff. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF, Javascript and Form Select Boxes - Need Help
David, To be honest, I don't recall exactly what happens. All the CF and Javascript code was written by other folks where I'm doing some consulting work (I'm the only one subscribed to this list, that's why I'm asking). The person who wrote the Jscript part put the alerts in to "track" each action in the form as it gets updated after something is changed. If memory serves, selecting an Cover_Shipping_Method option threw a Javascript error, but the upshot is the total price value isn't getting updated. I'll try to determine what the error is tomorrow at the office since I'm unable to run it remotely. Thanks for your help. Have a good weekend. Chris Montgomery >-Original Message- >From: David Shadovitz [mailto:[EMAIL PROTECTED]] >Sent: Saturday, March 25, 2000 11:05 PM >To: [EMAIL PROTECTED] >Subject: Re: CF, Javascript and Form Select Boxes - Need Help > > >Chris, >What happens when you choose an option in >Cover_SHIPPING_METHOD? Do you >get the alerts in the calc_Total function? If so, are the >values in the >alerts correct? >-David > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: INOUT TYPE for CFPROCPARAM
> I've looked through the knowledge base for this one and > couldn't find any answers. I'm also new to the list so > you'll have to forgive me if this question has already > been answered. > > Does the InOut Type for CFPROCPARAM work with MS Sql Server > on Cold Fusion? I've read that some people have had problems > with this on Oracle as well, but it seems to have been a > problem with an ODBC driver. > > We're using Sql Server 7 with the latest ODBC drivers as well > as Cold Fusion 4.0. It works fine with SQL Server 7. I didn't know myself until I tried it. Here's the stored proc I used to test: CREATE PROCEDURE sp_Increment @inoutvar int OUTPUT AS SELECT @inoutvar = @inoutvar + 1 and here's the CF script: #mynewvar# Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF, Javascript and Form Select Boxes - Need Help
Chris, What happens when you choose an option in Cover_SHIPPING_METHOD? Do you get the alerts in the calc_Total function? If so, are the values in the alerts correct? -David On Sat, 25 Mar 2000 21:53:26 -0600 "Chris Montgomery" <[EMAIL PROTECTED]> writes: > David, > > Thanks a bunch. I just checked the file and the opening bracket is > in > fact there. Don't know why/how it got dropped when I copied and > pasted > it. > >
RE: for those looking for news feeds
This works for the XML file feed. I am using it at www.uxb.net. However if you upgrade Office 2K to the latest service pack it breaks. I upgraded my development machine to Office 2000 SR1 service pack and now IE5.0 or the XMLDOM won't or read any XML file using iso-8859-1. If I change it to UTF-8 it works fine. Thank you Bill! ==[ code snippet ]=== http://p.moreover.com/cgi-local/page?index_cyberculture+xml"> XML File not loaded into XML COM Object #title.text# ==[ code snippet ]=== Best Regards, Dennis Powers UXB Internet (203)879-2844 http://www.uxbinfo.com -Original Message- From: Timothy C. Hill [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 23, 2000 9:50 AM To: [EMAIL PROTECTED] Subject: Re: for those looking for news feeds Has anyone gotten the CF/WDDX/XML feed from MoreOver.com to work for them? If so, can someone send me some examples as to how they output the information??? I am an XML illiterate..but I do want to learn. thanks, Tim - Original Message - From: Steve Reich <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 21, 2000 12:50 PM Subject: RE: for those looking for news feeds > Yes... and also check out James Carlyle's directory of syndicated new links > at xmltree.com > > Steve > > -Original Message- > From: Ric Smith [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 21, 2000 12:17 PM > To: [EMAIL PROTECTED] > Subject: for those looking for news feeds > > > I've seen some posts asking about news feeds and the suggestion > is usually http://www.isydicate.com. I stumbled upon a jewel this morning in > http://www.moreover.com. They can supply you the feeds in WDDX format. > I haven't tried it yet but it looks like the shiznit. > > -- Ric Smith > > > -- -- > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal k or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ODBC date/time functions (was RE: linux, oracle8, & date functions)
> I never had much luck with #CreateODBCDate(***)# > because it appends > these brackets { t ' '} and MsSQL7 and Access > freak out!! So I just did something like the above for a > quick workaround and never got around asking how you correctly > use the ODBCDate functions. I guess now is as good a time as > ever, anyone ODBC date and time formats use the curly brackets you mention above. To reference values in ODBC date/time format in your CFQUERY tags, just leave off the single quotes that you'd use for strings. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Date and Time Stamp Discrepancy
> We are running the AbleCommerce application under Website and CF 4.5. > The problem is the discrepancy between the date shown by the > CF app and the email date stamp. > > This is the date sent on the email to the customer: > "Sunday, March 19, 2000 7:18 PM". > > This is the date on the invoice contained in the email: > "INVOICE 20-Mar-00 10:18 AM Order Number: 134 Terms: Visa". > > Theoretically, both date/time stamps should be pretty close > to the same, although it appears that the email was sent > before the sale happened. Is it a CF issue or an NT server > issue? Anyone have any idea about what is causing this and > how to fix it? If your SMTP server is on a different machine, as is often the case, make sure that it has the same system time as the CF server's machine. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: QUESTION: CFFORM in CF 4.5
> Does anyone know if there are any known issues with using > CFFORM in CF 4.5 vs 4.0? We are trying to upgrade one server > to 4.5 and I'm getting very ambiguous errors that are thrown > as soon as the server encounters my CFFORM tag. When I pull > the source on both working and errored pages, I notice the > CFFORM tag is rendered differently. On 4.0 CFFORM translates > into . On 4.5, the CFFORM translates into NAME="CFForm_1" METHOD=POST onSubmit="return _CF_checkCFForm_1(this)">. > Notice there's no action added in the second. There's no action > added by myself in the first, but CFserver puts it in for me... > I'm thinking 4.5 doesn't. > > The error I get on the page is: > > Error Occurred While Processing Request > Error Diagnostic Information > unknown exception condition > unknown error while executing a tag. I don't know if you'll like this answer, but the ACTION attribute is required by CFFORM. The fact that CFFORM worked in 4.0.1 without your including an ACTION parameter is a "bug" in 4.0.1, so to speak. If you don't intend to ever actually submit the form, if for example you're using it to display a CFTREE applet, just include a fake action. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF, Javascript and Form Select Boxes - Need Help
David, Thanks a bunch. I just checked the file and the opening bracket is in fact there. Don't know why/how it got dropped when I copied and pasted it.
Re: CF, Javascript and Form Select Boxes - Need Help
I'll take a look, but I see right away that the function cover_price has no opening bracket. -David On Sat, 25 Mar 2000 20:49:32 -0600 "Chris Montgomery" <[EMAIL PROTECTED]> writes: > Howdy folks, > > If any Javascript wizards have a few moments and can help, I would > certainly appreciate it. > > Below is some code for a page that contains a form that uses > Javascript > to update calculated values. The second form SELECT is not updating > the > total_price form field. The team I'm working with needs to resolve > this > problem with Javascript not working in the form by Monday morning, > so > timeliness is of the essence. > > Can anyone see the problem? > > Code follows: > = > > > > > > > > > > > > > > > > SELECT MAL_CLS_CD, MAL_CLS_DESC, MAL_CLS_CST, PLT_PRD.BND_TYP > FROM MAL_CLS_TIER, PLT_PRD > WHERE MAL_CLS_TIER_CD = '#SESSION.MAL_CLS_TIER_CD#' > AND MAL_CLS_TIER.PRD_TYP_CD = '02' > AND PLT_PRD.ORD_ENT_PRD_CD = '#SESSION.COVER_PRODUCT_CODE#' > AND MAL_CLS_TIER.BND_TYP = '#SESSION.BINDING#' > ORDER BY MAL_CLS_CST > > > > > > > > Cover Quantity > > > > > //function to change the cover price > as > multiple quantities are chosen > function cover_price(form) > > > // if only one cover is chosen, the standard cover price is > given > if (form.Cover_QUANTITY.selectedIndex == 0) > { > form.cover_price2.value = >#session.cover_cost# ; > } > else > { > form.cover_price2.value = (form.Cover_QUANTITY.selectedIndex > * >#session.cover_cost_add2# ) + >#session.cover_cost# ; > } > > result = calc_precision(form.cover_price2.value); > > return(result); > } > > function calc_precision(in_value) > { > alert("in calc_precision"); > precision = 2; // Set the precision to 2 places past the > decimal > point > > var whole = "" + Math.round(in_value * Math.pow(10, > precision)); > > var decPoint = whole.length - precision; > > if(decPoint != 0) > { > result = whole.substring(0, decPoint); > result += "."; > result += whole.substring(decPoint, whole.length); > } > else > { > result = whole; > } > alert("calc_precision returning "+result); > return(result) > } > > function calc_Total() > { > alert("in calc_total"); > total_result = > parseFloat(document.Cover_qty.cover_price2.value) + >#COVER_SHIP_COST.mal_cls_cst# ; > alert("calc_total total_result is "+total_result); > result = calc_precision(total_result); > alert("calc_total returning "+result); > return(result); > } > > > > > onLoad="document.Cover_qty.total_price.value=calc_Total()"> > Standard > Delivery for Covers is Bulk Mail.You may upgrade delivery > below. > > target="_top"> > valign="TOP" border="1"> > > > Your Cover Selection: > > >src="../covers/#SESSION.COVER_IMAGE#"> > > > > > > #SESSION.COVER_DESCRIPTION# > Leather > Cover > > > > > Select Cover Quantity: > > > > onChange="document.Cover_qty.cover_price2.value=cover_price(this.form);d > ocument.Cover_qty.total_price.value=calc_Total()"> > 1>selected>1 Cover > 2>selected>2 Covers > 3>selected>3 Covers > 4>selected>4 Covers > 5>selected>5 Covers > Price: $ > value="#DecimalFormat(Evaluate(SESSION.COVER_COST + > (SESSION.COVER_COST_ADD * (SESSION.COVER_QUANTITY - 1#" size="5" > maxlength="5" > onChange="this.value=cover_price(this.form);document.Cover_qty.total_pri > ce.value=calc_Total()"> > > > > > Shipping Method: > > > > > > > > The onChange in the SELECT statement below is where the code > appears to be broken. > > > onChange="document.Cover_qty.total_price.value=calc_Total()"> > > session.cover_shipping_method is #mal_cls_cd#>selected > >#Trim(MAL_CLS_DESC)#: $#Trim(MAL_CLS_CST)# > > > > > >size="2"> > Total: > > > > * > This is where choosing one of the affected Select options > above should update the total price, but it isn't working. > * > >size="2">$ > maxlength="5" > onChange="this.value=calc_Total()"> > > > >size="-1"> > WARNING: UPS does NOT deliver to P.O. Box Addresses. When > selecting > Ground, 2nd Day,
RE: Check for Matching Passwords - Server Side
-S ___ Sean Brown <[EMAIL PROTECTED]> Systems Engineer <[EMAIL PROTECTED]> Westcar Consulting Group www.westcar.com Allaire Alliance Partner www.allaire.com ___ -Original Message- From: Erik Nachbahr [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 25, 2000 9:47 PM To: '[EMAIL PROTECTED] ' Subject: Check for Matching Passwords - Server Side Greetings, I want to be able to check that if a user is setting a password, that the two boxes that they type it in match - on an html form. (this is used all over). I know how to do the checking with JS, but I wanted to make it server-side (with CF) I know that this must be very easy, but I am having a brain-fart. Also, I look forward for some creative ways to do this from the "experts"! thanks in advance! Erik -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Check for Matching Passwords - Server Side
At 9:46 PM -0500 3/25/2000, Erik Nachbahr wrote: > Greetings, > >I want to be able to check that if a user is setting a password, that the >two boxes that they type it in match - on an html form. (this is used all >over). I know how to do the checking with JS, but I wanted to make it >server-side (with CF) > >I know that this must be very easy, but I am having a brain-fart. Also, I >look forward for some creative ways to do this from the "experts"! > >thanks in advance! > >Erik >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal >k or send a message to [EMAIL PROTECTED] with >'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF, Javascript and Form Select Boxes - Need Help
Howdy folks, If any Javascript wizards have a few moments and can help, I would certainly appreciate it. Below is some code for a page that contains a form that uses Javascript to update calculated values. The second form SELECT is not updating the total_price form field. The team I'm working with needs to resolve this problem with Javascript not working in the form by Monday morning, so timeliness is of the essence. Can anyone see the problem? Code follows: = SELECT MAL_CLS_CD, MAL_CLS_DESC, MAL_CLS_CST, PLT_PRD.BND_TYP FROM MAL_CLS_TIER, PLT_PRD WHERE MAL_CLS_TIER_CD = '#SESSION.MAL_CLS_TIER_CD#' AND MAL_CLS_TIER.PRD_TYP_CD = '02' AND PLT_PRD.ORD_ENT_PRD_CD = '#SESSION.COVER_PRODUCT_CODE#' AND MAL_CLS_TIER.BND_TYP = '#SESSION.BINDING#' ORDER BY MAL_CLS_CST Cover Quantity //function to change the cover price as multiple quantities are chosen function cover_price(form) // if only one cover is chosen, the standard cover price is given if (form.Cover_QUANTITY.selectedIndex == 0) { form.cover_price2.value =#session.cover_cost# ; } else { form.cover_price2.value = (form.Cover_QUANTITY.selectedIndex *#session.cover_cost_add2# ) +#session.cover_cost# ; } result = calc_precision(form.cover_price2.value); return(result); } function calc_precision(in_value) { alert("in calc_precision"); precision = 2; // Set the precision to 2 places past the decimal point var whole = "" + Math.round(in_value * Math.pow(10, precision)); var decPoint = whole.length - precision; if(decPoint != 0) { result = whole.substring(0, decPoint); result += "."; result += whole.substring(decPoint, whole.length); } else { result = whole; } alert("calc_precision returning "+result); return(result) } function calc_Total() { alert("in calc_total"); total_result = parseFloat(document.Cover_qty.cover_price2.value) +#COVER_SHIP_COST.mal_cls_cst# ; alert("calc_total total_result is "+total_result); result = calc_precision(total_result); alert("calc_total returning "+result); return(result); } Standard Delivery for Covers is Bulk Mail.You may upgrade delivery below. Your Cover Selection: #SESSION.COVER_DESCRIPTION# Leather Cover Select Cover Quantity: selected>1 Cover selected>2 Covers selected>3 Covers selected>4 Covers selected>5 Covers Price: $ Shipping Method: The onChange in the SELECT statement below is where the code appears to be broken. selected >#Trim(MAL_CLS_DESC)#: $#Trim(MAL_CLS_CST)# Total: * This is where choosing one of the affected Select options above should update the total price, but it isn't working. * $ WARNING: UPS does NOT deliver to P.O. Box Addresses. When selecting Ground, 2nd Day, or Overnight Delivery, please make sure past order was delivered to a physical address. If not, please exit order! http://companynamechangedtoprotecttheinnocent.com/www" target="_top"> = End code Thanks a bunch!! Chris Montgomery = astutia.com -> http://www.astutia.com [EMAIL PROTECTED] Astute e-business applications & web site development 210-490-3249/888-745-7603 Fax 210-490-4692 Allaire Consulting Partner/Authorized NetObjects Reseller Find a Job in San Antonio -> http://www.sajobnet.com = -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Check for Matching Passwords - Server Side
Greetings, I want to be able to check that if a user is setting a password, that the two boxes that they type it in match - on an html form. (this is used all over). I know how to do the checking with JS, but I wanted to make it server-side (with CF) I know that this must be very easy, but I am having a brain-fart. Also, I look forward for some creative ways to do this from the "experts"! thanks in advance! Erik -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: how to use SSL in coldfusion
You used to have to run CF as a desktop app, rather than as a service if you needed to make OUTBOUND ssl connections via CFHTTP. For CF 4.5, that is no longer necessary, and I found that 4.0 systems with IE 5.0+ installed on the server also did not need this. (The problem was in a Microsoft-supplied DLL) Michael J. Sheldon Internet Applications Developer Phone: 480.699.1084 http://www.desertraven.com/ PGP Key Available on Request -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 25, 2000 18:03 To: [EMAIL PROTECTED] Subject: RE: how to use SSL in coldfusion > You use SSL the same in CF as you would in any application. Didn't CF at one time require you to run the server in a less-than-desirable mode if you needed to connect via SSL? Ken -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: how to use SSL in coldfusion
> You use SSL the same in CF as you would in any application. Didn't CF at one time require you to run the server in a less-than-desirable mode if you needed to connect via SSL? Ken -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SSL to secure your Web Server?
This is a multi-part message in MIME format. --=_NextPart_000_0009_01BF56ED.F7A53320 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can you tell you how to use SSL to secure your Web Server? can you tell = me some web site have the information about that. thanks Mark=20 --=_NextPart_000_0009_01BF56ED.F7A53320 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can you tell you how to use SSL to = secure your Web=20 Server? can you tell me some web site have the = information about=20 that. thanks Mark --=_NextPart_000_0009_01BF56ED.F7A53320-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ?
Yes it works very well. If you don't mind the way MS does service packs The MSDE initial installation program from the Microsoft site (which is screwed and doesn't install without performing some really neat tricks) is 20.1MB. The first service pack they released was something like 36MB, now they just released SP2 and its 57MB. Enjoy and I hope you either have it on CD or you've got broadband connection to the internet. Fred - Original Message - From: "Peter Tilbrook" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 25, 2000 6:42 PM Subject: RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ? > Also I found you need Win2000 Advanced Server to run the Enterprise Edition. > Naturally I only found this out AFTER getting the standard server up and > running. Hopefully the upgrade won't be too painful. > > -Original Message- > From: Jessica Shea [mailto:[EMAIL PROTECTED]] > Sent: Sunday, 26 March 2000 10:22 AM > To: ''[EMAIL PROTECTED] ' ' > Subject: RE: Does the SQL7 Desktop Server Evaluation Work with > ColdFusion? ? > > > Opps, I was distracted by all that encoding stuff and misread your message. > Using the desktop edition is fine, but I've never tried the evaluation > version. I wouldn't be surprised if they had a setting to not allow outside > connections in since it's an evaluation copy. > > Still, you could make sure all your settings are correct and your service is > running anyway. > > Jessica > > -Original Message- > From: Jessica Shea > To: 'Kevin Merker '; '[EMAIL PROTECTED] ' > Sent: 3/25/00 4:03 PM > Subject: RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ? > > Works fine for me. You should register the server under you ODBC > setting > the way you would register a full version of SQL. This includes putting > in > the server name, database name, username and password to access the > database-all as part of setting up an ODBC datasource using the SQL > drivers. > > > Also, make sure your desktop edition is running when you try to verify > the > datasource. There should be a little SQL server service manager icon in > you > tool tray-make sure there is a green arrow on the icon-this means it's > running. If it's a red square, double click the icon and click the > start/continue button to start the service. > > Jessica Shea > Lead Developer, Professional Products > Elixis Corp. http://www.elixis.com > > -Original Message- > From: Kevin Merker > To: [EMAIL PROTECTED] > Sent: 3/25/00 8:43 AM > Subject: Does the SQL7 Desktop Server Evaluation Work with ColdFusion?? > > > --6DDD1771C9E38CD1BD4F1CE3 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Can you connect SQL7 Desktop Evaluation with ColdFusion Server > Enterprise 4.0.1? Has anyone ever set this up as a development > environment on Win98 OS. I cannot get Coldfusion Sever to recognize / > verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. > What am I doing wrong? Studio see the ODBC connection to the server. > > PLEASE HELP! > > Kevin Merker > > --6DDD1771C9E38CD1BD4F1CE3 > Content-Type: text/html; charset=us-ascii > Content-Transfer-Encoding: 7bit > > > > Can you connect SQL7 Desktop Evaluation with ColdFusion Server > Enterprise > 4.0.1? Has anyone ever set this up as a development environment on > Win98 OS. I cannot get Coldfusion Sever to recognize / verify the the > ODBC > connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing > wrong? > Studio see the ODBC connection to the server. > PLEASE HELP! > Kevin Merker > > --6DDD1771C9E38CD1BD4F1CE3-- > > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > -- -- > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.co
RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ?
Also I found you need Win2000 Advanced Server to run the Enterprise Edition. Naturally I only found this out AFTER getting the standard server up and running. Hopefully the upgrade won't be too painful. -Original Message- From: Jessica Shea [mailto:[EMAIL PROTECTED]] Sent: Sunday, 26 March 2000 10:22 AM To: ''[EMAIL PROTECTED] ' ' Subject: RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ? Opps, I was distracted by all that encoding stuff and misread your message. Using the desktop edition is fine, but I've never tried the evaluation version. I wouldn't be surprised if they had a setting to not allow outside connections in since it's an evaluation copy. Still, you could make sure all your settings are correct and your service is running anyway. Jessica -Original Message- From: Jessica Shea To: 'Kevin Merker '; '[EMAIL PROTECTED] ' Sent: 3/25/00 4:03 PM Subject: RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ? Works fine for me. You should register the server under you ODBC setting the way you would register a full version of SQL. This includes putting in the server name, database name, username and password to access the database-all as part of setting up an ODBC datasource using the SQL drivers. Also, make sure your desktop edition is running when you try to verify the datasource. There should be a little SQL server service manager icon in you tool tray-make sure there is a green arrow on the icon-this means it's running. If it's a red square, double click the icon and click the start/continue button to start the service. Jessica Shea Lead Developer, Professional Products Elixis Corp. http://www.elixis.com -Original Message- From: Kevin Merker To: [EMAIL PROTECTED] Sent: 3/25/00 8:43 AM Subject: Does the SQL7 Desktop Server Evaluation Work with ColdFusion?? --6DDD1771C9E38CD1BD4F1CE3 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Can you connect SQL7 Desktop Evaluation with ColdFusion Server Enterprise 4.0.1? Has anyone ever set this up as a development environment on Win98 OS. I cannot get Coldfusion Sever to recognize / verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing wrong? Studio see the ODBC connection to the server. PLEASE HELP! Kevin Merker --6DDD1771C9E38CD1BD4F1CE3 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Can you connect SQL7 Desktop Evaluation with ColdFusion Server Enterprise 4.0.1? Has anyone ever set this up as a development environment on Win98 OS. I cannot get Coldfusion Sever to recognize / verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing wrong? Studio see the ODBC connection to the server. PLEASE HELP! Kevin Merker --6DDD1771C9E38CD1BD4F1CE3-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: how to use SSL in coldfusion
You use SSL the same in CF as you would in any application. You use SSL to secure your Web Server, then use https to access the data on your web server using the secure socket layer. From there you can use cf,asp (god forbid), java, html or anything else you like.. At 11:52 AM 04/01/00 -0800, you wrote: >This is a multi-part message in MIME format. > >--=_NextPart_000_0010_01BF56AA.22E00900 >Content-Type: text/plain; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > >Hello, > >Can you tell me how to use SSL for protecting Data exchanging in = >coldfusion.Thanks a lot. > >Mark > >--=_NextPart_000_0010_01BF56AA.22E00900 >Content-Type: text/html; > charset="iso-8859-1" >Content-Transfer-Encoding: quoted-printable > > >Hello, > >Can you tell me how to use SSL for = protecting Data=20 exchanging in >coldfusion.Thanks a lot. > >Mark > >--=_NextPart_000_0010_01BF56AA.22E00900-- > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ?
I have used the eval of SQL Server Standard with Cold Fusion, and I have used the Eval on SQL Server 7 Desktop running on an NT Workstation 4.0 SP4 I have never run SQL Server on a 9x environment but MS Claims that it will work. Check your protocols and make sure the CF box and the SQL box are using the same thing as their primary connection protocol. If they are the same box try using 127.0.0.1 as the DB server when creating the datasource. If they are on the same box then set both CF and SQL to run as the same user, and when you create the datasource do not assign a username/password. Hope one of these helps. At 04:22 PM 3/25/2000 -0800, you wrote: >Opps, I was distracted by all that encoding stuff and misread your message. >Using the desktop edition is fine, but I've never tried the evaluation >version. I wouldn't be surprised if they had a setting to not allow outside >connections in since it's an evaluation copy. > >Still, you could make sure all your settings are correct and your service is >running anyway. > >Jessica > >-Original Message- >From: Jessica Shea >To: 'Kevin Merker '; '[EMAIL PROTECTED] ' >Sent: 3/25/00 4:03 PM >Subject: RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ? > >Works fine for me. You should register the server under you ODBC >setting >the way you would register a full version of SQL. This includes putting >in >the server name, database name, username and password to access the >database-all as part of setting up an ODBC datasource using the SQL >drivers. > > >Also, make sure your desktop edition is running when you try to verify >the >datasource. There should be a little SQL server service manager icon in >you >tool tray-make sure there is a green arrow on the icon-this means it's >running. If it's a red square, double click the icon and click the >start/continue button to start the service. > >Jessica Shea >Lead Developer, Professional Products >Elixis Corp. http://www.elixis.com > >-Original Message- >From: Kevin Merker >To: [EMAIL PROTECTED] >Sent: 3/25/00 8:43 AM >Subject: Does the SQL7 Desktop Server Evaluation Work with ColdFusion?? > > >--6DDD1771C9E38CD1BD4F1CE3 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >Can you connect SQL7 Desktop Evaluation with ColdFusion Server >Enterprise 4.0.1? Has anyone ever set this up as a development >environment on Win98 OS. I cannot get Coldfusion Sever to recognize / >verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. >What am I doing wrong? Studio see the ODBC connection to the server. > >PLEASE HELP! > >Kevin Merker > >--6DDD1771C9E38CD1BD4F1CE3 >Content-Type: text/html; charset=us-ascii >Content-Transfer-Encoding: 7bit > > >Can you connect SQL7 Desktop Evaluation with ColdFusion Server Enterprise >4.0.1? Has anyone ever set this up as a development environment on Win98 >OS. I cannot get Coldfusion Sever to recognize / verify the the ODBC >connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing >wrong? Studio see the ODBC connection to the server. > >PLEASE HELP! > >Kevin Merker >--6DDD1771C9E38CD1BD4F1CE3-- > > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk >or send a message to [EMAIL PROTECTED] with >'unsubscribe' in the body. > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk >or send a message to [EMAIL PROTECTED] with >'unsubscribe' in the body. >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Transfer-Function in ColdFusion ?
Not sure I understand you 100%, but you could try the following select * into your_new_table from your_old_table both tables will need to be in the same database. If having the tables in one db ios not an option, you could alternativly select all records from one db, then loop over the output inserting one record at a time into the new db and datasource. At 12:50 AM 26/03/00 +0100, you wrote: >I have two different DBs and two different independent tables in those DBs. >Both tables do not have the same number of records. >The records of one table can be erased first. > >How can I overwrite/transfer the records of one table with the records of >the other table ? >Delete all records of the first table in the beginning and then do a >cfquery/insert into from one table to the other ? > >Is there the idea of a CF-Transfer-Function similar like in a SQL-Server ? > >Ideas ? > >Uwe > > > >-- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ?
Opps, I was distracted by all that encoding stuff and misread your message. Using the desktop edition is fine, but I've never tried the evaluation version. I wouldn't be surprised if they had a setting to not allow outside connections in since it's an evaluation copy. Still, you could make sure all your settings are correct and your service is running anyway. Jessica -Original Message- From: Jessica Shea To: 'Kevin Merker '; '[EMAIL PROTECTED] ' Sent: 3/25/00 4:03 PM Subject: RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion? ? Works fine for me. You should register the server under you ODBC setting the way you would register a full version of SQL. This includes putting in the server name, database name, username and password to access the database-all as part of setting up an ODBC datasource using the SQL drivers. Also, make sure your desktop edition is running when you try to verify the datasource. There should be a little SQL server service manager icon in you tool tray-make sure there is a green arrow on the icon-this means it's running. If it's a red square, double click the icon and click the start/continue button to start the service. Jessica Shea Lead Developer, Professional Products Elixis Corp. http://www.elixis.com -Original Message- From: Kevin Merker To: [EMAIL PROTECTED] Sent: 3/25/00 8:43 AM Subject: Does the SQL7 Desktop Server Evaluation Work with ColdFusion?? --6DDD1771C9E38CD1BD4F1CE3 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Can you connect SQL7 Desktop Evaluation with ColdFusion Server Enterprise 4.0.1? Has anyone ever set this up as a development environment on Win98 OS. I cannot get Coldfusion Sever to recognize / verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing wrong? Studio see the ODBC connection to the server. PLEASE HELP! Kevin Merker --6DDD1771C9E38CD1BD4F1CE3 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Can you connect SQL7 Desktop Evaluation with ColdFusion Server Enterprise 4.0.1? Has anyone ever set this up as a development environment on Win98 OS. I cannot get Coldfusion Sever to recognize / verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing wrong? Studio see the ODBC connection to the server. PLEASE HELP! Kevin Merker --6DDD1771C9E38CD1BD4F1CE3-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Does the SQL7 Desktop Server Evaluation Work with ColdFusion??
Works fine for me. You should register the server under you ODBC setting the way you would register a full version of SQL. This includes putting in the server name, database name, username and password to access the database-all as part of setting up an ODBC datasource using the SQL drivers. Also, make sure your desktop edition is running when you try to verify the datasource. There should be a little SQL server service manager icon in you tool tray-make sure there is a green arrow on the icon-this means it's running. If it's a red square, double click the icon and click the start/continue button to start the service. Jessica Shea Lead Developer, Professional Products Elixis Corp. http://www.elixis.com -Original Message- From: Kevin Merker To: [EMAIL PROTECTED] Sent: 3/25/00 8:43 AM Subject: Does the SQL7 Desktop Server Evaluation Work with ColdFusion?? --6DDD1771C9E38CD1BD4F1CE3 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Can you connect SQL7 Desktop Evaluation with ColdFusion Server Enterprise 4.0.1? Has anyone ever set this up as a development environment on Win98 OS. I cannot get Coldfusion Sever to recognize / verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing wrong? Studio see the ODBC connection to the server. PLEASE HELP! Kevin Merker --6DDD1771C9E38CD1BD4F1CE3 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Can you connect SQL7 Desktop Evaluation with ColdFusion Server Enterprise 4.0.1? Has anyone ever set this up as a development environment on Win98 OS. I cannot get Coldfusion Sever to recognize / verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing wrong? Studio see the ODBC connection to the server. PLEASE HELP! Kevin Merker --6DDD1771C9E38CD1BD4F1CE3-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Transfer-Function in ColdFusion ?
I have two different DBs and two different independent tables in those DBs. Both tables do not have the same number of records. The records of one table can be erased first. How can I overwrite/transfer the records of one table with the records of the other table ? Delete all records of the first table in the beginning and then do a cfquery/insert into from one table to the other ? Is there the idea of a CF-Transfer-Function similar like in a SQL-Server ? Ideas ? Uwe -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Does the SQL7 Desktop Server Evaluation Work with ColdFusion??
--6DDD1771C9E38CD1BD4F1CE3 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Can you connect SQL7 Desktop Evaluation with ColdFusion Server Enterprise 4.0.1? Has anyone ever set this up as a development environment on Win98 OS. I cannot get Coldfusion Sever to recognize / verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing wrong? Studio see the ODBC connection to the server. PLEASE HELP! Kevin Merker --6DDD1771C9E38CD1BD4F1CE3 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Can you connect SQL7 Desktop Evaluation with ColdFusion Server Enterprise 4.0.1? Has anyone ever set this up as a development environment on Win98 OS. I cannot get Coldfusion Sever to recognize / verify the the ODBC connection to the SQL7 sever. MSDE SQL7 worked fine. What am I doing wrong? Studio see the ODBC connection to the server. PLEASE HELP! Kevin Merker --6DDD1771C9E38CD1BD4F1CE3-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Problems with CFX_EXCEL
Ok, try this on: > File="C:\XLS\OUTPUT.XLS" Write the results to a new spreadsheet called "C:\XLS\OUTPUT.XLS" > Workbook="C:\TEMPLATES\TEST.XLS" using a spreadsheet of the name "C:\TEMPLATES\TEST.XLS" as an input template > Worksheet="MySheet" Using the worksheet "MySheet" in the Workbook (AKA Spreadsheet) "C:\TEMPLATES\TEST.XLS" > Row="5" Starting at Row 5 in the worksheet "MySheet" > Col="2"> and Column 2 in the worksheet "MySheet" In other words: Input template workbook/spreadsheet + CF Query => New output Workbook/ spreadsheet. Steve At 07:45 PM 3/25/2000 +0100, cftalk wrote: >Steve, thank you for your guidance. >To be honest I don't understand the detail-concept of this tag. >Thomas Frey (Tag-Writer) wrote in his manual the following: > >Send the results of a query named "Test" to an existing Excel template named >TEST.XLS in the C:\TEMPLATES directory on the Web server. Start the query >results at Row 5, Column 2 on "MySheet": > File="C:\XLS\OUTPUT.XLS" > Workbook="C:\TEMPLATES\TEST.XLS" > Worksheet="MySheet" > Row="5" > Col="2"> > deletefile="YES" > file="C:\XLS\OUTPUT.XLS"> > >There he tells of an EXISTING excel-file. (see above) >What I want to do is to overwrite an EXISTING worksheet in an EXISTING >xls-file. >The manual-example (above) didn't bring me any further. In my understanding >the FILE and Workbook can just have the same absolute path and file e.g.: >c:\test\test.xls >But this is not working as well. > >Uwe >- Original Message - >From: Stephen Garrett <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Saturday, March 25, 2000 6:57 PM >Subject: RE: Problems with CFX_EXCEL > > >> >> Yes, this is the error I would expect you to get. And the Error is >> telling you what the problem is. The CFX_EXCEL tag does not overwrite >> existing files. You need to pass it a file name that is guaranteed to >> not exist. >> >> So either use CFFILE to delete the previous one if it exists, or >> use a random file name to pass to CFX_EXCEL. >> >> Steve >> >> >> At 02:12 PM 3/25/2000 -, Paul's Mail wrote: >> >Hi, >> > here is the link:- >> >http://www.wheretoflyfish.com >> >Any problems, let me know. >> >Kind regards >> >Paul Burgess >> > >> >> -Original Message- >> >> From: cftalk [mailto:[EMAIL PROTECTED]] >> >> Sent: Saturday, March 25, 2000 1:13 PM >> >> To: [EMAIL PROTECTED] >> >> Subject: Problems with CFX_EXCEL >> >> >> >> >> >> I am using CFX-Excel. >> >> For some reason CF is telling me, that the file >> >> TOPInfo_Excel.XLS >> >> >> >> already exists. >> >> >> >> >> >> Error Diagnostic Information >> >> >> >> Error in CFX_Excel Tag >> >> >> >> C:\cfusion\database\TOPInfo_Excel.XLS already exists. >> >> >> >> The error occurred while processing an element with a general >> >> identifier of >> >> (CFX_EXCEL), occupying document position (13:1) to >> >> (18:19). >> >> >> >> >> >> I am using the same name in file, workbook and worksheet. >> >> Is this a problem ? >> >> >> >> > >>File="C:\cfusion\database\TOPInfo_Excel.XLS" >> >> Workbook="C:\cfusion\database\TOPInfo_Excel.XLS" >> >>Worksheet="TOPInfo_Excel" >> >>Row="2" >> >>Col="1"> >> >> >> >> Best Uwe >> >> >> >> >> >> SD Solutions >> >> Uwe Degenhardt >> >> Fon: 08122/903791 >> >> Fax: 08122/903792 >> >> Net: www.sdsolutions.de >> >> Mail: [EMAIL PROTECTED] >> >> >> >> >> >> -- >> >> >> >> Archives: http://www.eGroups.com/list/cf-talk >> >> To Unsubscribe visit >> >> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf >> >_talk or send a message to [EMAIL PROTECTED] with >> >'unsubscribe' in the body. >> > >> >>--- >> --- >> >Archives: http://www.eGroups.com/list/cf-talk >> >To Unsubscribe visit >> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >> send a message to [EMAIL PROTECTED] with 'unsubscribe' in >> the body. >> > >> >> -- >> Stephen Garrett >> GPS >> [EMAIL PROTECTED] (360) 896-2714 >> ICQ# 10776767 >> -- > >> Archives: http://www.eGroups.com/list/cf-talk >> To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. > > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Stephen Garrett GPS [EMAIL PROTECTED] (360) 896-2714 ICQ# 10776767 ---
Re: Setting Up SQL 7
thank you Dave Clay Interent Facilitator Trus Joist >>> [EMAIL PROTECTED] 03/25/00 01:19PM >>> Setup a user in SQL 7 specifically for your ColdFusion app, giving that user select, insert, delete, and update rights to the corresponding database. Then, in CF Administrator, when you setup the datasource that points to the IP Address of your SQL server, specify the user that you setup in SQL server as the login name and password. This is better security than using the SA username and password for each SQL database that you connect with ColdFusion. - Original Message - From: "David Clay" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 25, 2000 2:11 PM Subject: Setting Up SQL 7 > > Might someone or provide a guide or a URL that has detailed steps to connect CF to SQL 7 on another server. How do I set-up SQL and/or NT so no authorization is required for a public query to take place. > > Thanks > > Dave > > Dave Clay > Interent Facilitator > Trus Joist > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Countries, States and Counties -New Login
Hi! Bud, Thanks for sharing your work. I could connect to the ftp site and download but it is giving me unrecognized format ...can you tell me what version of Access did you use..I have Access 97 with me... regards, kailash - Original Message - From: Bud <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 23, 2000 8:12 PM Subject: Re: Countries, States and Counties -New Login > OK, I've set a new login if the anonymous won't work for you: > > tropicalwebcreations.com > username: user > password: pass > > If anyone can't get to it still let me know off list and I'll send > out an e-mail later today CCd to all who couldn't connect. > > Let's drop this thread from the list now before I get flamed. LOL > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF_QuickMessage
At the folowing URL http://www.allaire.com/developer/gallery/index.cfm?objectID=6943 ], there is a mention of a custom CF tag called CF_QuickMessage. I would like to add such functionality to a site I am developing. Unfortunately, the links to the example and the Aspx website come back with '404' errors. Have any of you used this tag, know how it works, where I can see it in action, and/or know where I can either get ahold of Ashley King (the developer)? * * * * * EP Healy Gaming Outpost.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Setting Up SQL 7
Setup a user in SQL 7 specifically for your ColdFusion app, giving that user select, insert, delete, and update rights to the corresponding database. Then, in CF Administrator, when you setup the datasource that points to the IP Address of your SQL server, specify the user that you setup in SQL server as the login name and password. This is better security than using the SA username and password for each SQL database that you connect with ColdFusion. - Original Message - From: "David Clay" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 25, 2000 2:11 PM Subject: Setting Up SQL 7 > > Might someone or provide a guide or a URL that has detailed steps to connect CF to SQL 7 on another server. How do I set-up SQL and/or NT so no authorization is required for a public query to take place. > > Thanks > > Dave > > Dave Clay > Interent Facilitator > Trus Joist > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Setting Up SQL 7
Might someone or provide a guide or a URL that has detailed steps to connect CF to SQL 7 on another server. How do I set-up SQL and/or NT so no authorization is required for a public query to take place. Thanks Dave Dave Clay Interent Facilitator Trus Joist -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Slightly OT...
Documentation is pretty much universal, feature set usually falls within a certain fixed set of parameters and any bugs are usually a subset of your own, just ask any grand parent ;) Contrats from Northern California ;) > > Everyone's in good condition, but as expected, the documentation > > is lousy... > > > > Documentation? :) > > Wouldn't do ya any good anyway. The feature set and bugs are different on > each version and they seem to keep changing without notice. > > Congratulations and...good luck. > > Ken > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Problems with CFX_EXCEL
Steve, thank you for your guidance. To be honest I don't understand the detail-concept of this tag. Thomas Frey (Tag-Writer) wrote in his manual the following: Send the results of a query named "Test" to an existing Excel template named TEST.XLS in the C:\TEMPLATES directory on the Web server. Start the query results at Row 5, Column 2 on "MySheet": There he tells of an EXISTING excel-file. (see above) What I want to do is to overwrite an EXISTING worksheet in an EXISTING xls-file. The manual-example (above) didn't bring me any further. In my understanding the FILE and Workbook can just have the same absolute path and file e.g.: c:\test\test.xls But this is not working as well. Uwe - Original Message - From: Stephen Garrett <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 25, 2000 6:57 PM Subject: RE: Problems with CFX_EXCEL > > Yes, this is the error I would expect you to get. And the Error is > telling you what the problem is. The CFX_EXCEL tag does not overwrite > existing files. You need to pass it a file name that is guaranteed to > not exist. > > So either use CFFILE to delete the previous one if it exists, or > use a random file name to pass to CFX_EXCEL. > > Steve > > > At 02:12 PM 3/25/2000 -, Paul's Mail wrote: > >Hi, > > here is the link:- > >http://www.wheretoflyfish.com > >Any problems, let me know. > >Kind regards > >Paul Burgess > > > >> -Original Message- > >> From: cftalk [mailto:[EMAIL PROTECTED]] > >> Sent: Saturday, March 25, 2000 1:13 PM > >> To: [EMAIL PROTECTED] > >> Subject: Problems with CFX_EXCEL > >> > >> > >> I am using CFX-Excel. > >> For some reason CF is telling me, that the file > >> TOPInfo_Excel.XLS > >> > >> already exists. > >> > >> > >> Error Diagnostic Information > >> > >> Error in CFX_Excel Tag > >> > >> C:\cfusion\database\TOPInfo_Excel.XLS already exists. > >> > >> The error occurred while processing an element with a general > >> identifier of > >> (CFX_EXCEL), occupying document position (13:1) to > >> (18:19). > >> > >> > >> I am using the same name in file, workbook and worksheet. > >> Is this a problem ? > >> > >> >>File="C:\cfusion\database\TOPInfo_Excel.XLS" > >> Workbook="C:\cfusion\database\TOPInfo_Excel.XLS" > >>Worksheet="TOPInfo_Excel" > >>Row="2" > >>Col="1"> > >> > >> Best Uwe > >> > >> > >> SD Solutions > >> Uwe Degenhardt > >> Fon: 08122/903791 > >> Fax: 08122/903792 > >> Net: www.sdsolutions.de > >> Mail: [EMAIL PROTECTED] > >> > >> > >> -- > >> > >> Archives: http://www.eGroups.com/list/cf-talk > >> To Unsubscribe visit > >> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > >_talk or send a message to [EMAIL PROTECTED] with > >'unsubscribe' in the body. > > > >--- > --- > >Archives: http://www.eGroups.com/list/cf-talk > >To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > > -- > Stephen Garrett > GPS > [EMAIL PROTECTED] (360) 896-2714 > ICQ# 10776767 > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Problems with CFX_EXCEL
Yes, this is the error I would expect you to get. And the Error is telling you what the problem is. The CFX_EXCEL tag does not overwrite existing files. You need to pass it a file name that is guaranteed to not exist. So either use CFFILE to delete the previous one if it exists, or use a random file name to pass to CFX_EXCEL. Steve At 02:12 PM 3/25/2000 -, Paul's Mail wrote: >Hi, > here is the link:- >http://www.wheretoflyfish.com >Any problems, let me know. >Kind regards >Paul Burgess > >> -Original Message- >> From: cftalk [mailto:[EMAIL PROTECTED]] >> Sent: Saturday, March 25, 2000 1:13 PM >> To: [EMAIL PROTECTED] >> Subject: Problems with CFX_EXCEL >> >> >> I am using CFX-Excel. >> For some reason CF is telling me, that the file >> TOPInfo_Excel.XLS >> >> already exists. >> >> >> Error Diagnostic Information >> >> Error in CFX_Excel Tag >> >> C:\cfusion\database\TOPInfo_Excel.XLS already exists. >> >> The error occurred while processing an element with a general >> identifier of >> (CFX_EXCEL), occupying document position (13:1) to >> (18:19). >> >> >> I am using the same name in file, workbook and worksheet. >> Is this a problem ? >> >> >File="C:\cfusion\database\TOPInfo_Excel.XLS" >> Workbook="C:\cfusion\database\TOPInfo_Excel.XLS" >>Worksheet="TOPInfo_Excel" >>Row="2" >>Col="1"> >> >> Best Uwe >> >> >> SD Solutions >> Uwe Degenhardt >> Fon: 08122/903791 >> Fax: 08122/903792 >> Net: www.sdsolutions.de >> Mail: [EMAIL PROTECTED] >> >> >> -- >> >> Archives: http://www.eGroups.com/list/cf-talk >> To Unsubscribe visit >> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf >_talk or send a message to [EMAIL PROTECTED] with >'unsubscribe' in the body. > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Stephen Garrett GPS [EMAIL PROTECTED] (360) 896-2714 ICQ# 10776767 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
how to use SSL in coldfusion
This is a multi-part message in MIME format. --=_NextPart_000_0010_01BF56AA.22E00900 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Can you tell me how to use SSL for protecting Data exchanging in = coldfusion.Thanks a lot. Mark --=_NextPart_000_0010_01BF56AA.22E00900 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Can you tell me how to use SSL for = protecting Data=20 exchanging in coldfusion.Thanks a lot. Mark --=_NextPart_000_0010_01BF56AA.22E00900-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Slightly OT...
> Everyone's in good condition, but as expected, the documentation > is lousy... Documentation? :) Wouldn't do ya any good anyway. The feature set and bugs are different on each version and they seem to keep changing without notice. Congratulations and...good luck. Ken -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Slightly OT...
Hi all, I know I'm breaking the rules, but I want to announce the arrival of a new CF developer-to-be: Harrison Michael Lurie, born 3/23/00 at 6:15 AM. Everyone's in good condition, but as expected, the documentation is lousy... Ian Lurie Portent Interactive Process, Design and Content http://www.portentinteractive.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Variable in stored procedures
Chris, You need to build your SQL statement dynamically and then execute it. Pretty straight forward. Here is an example: /* === */ Create Procedure test @TableName VarChar(50), @CoumnName VarChar(50) AS DECLARE @SQL_Statement VarChar(255) SELECT @SQL_Statement = 'SELECT ' + @CoumnName + 'FROM ' + @TableName EXEC(@SQL_Statement) /* === */ -Original Message- From: Chris Lott [mailto:[EMAIL PROTECTED]] Sent: Friday, March 24, 2000 7:06 PM To: CF-TALK Subject: Variable in stored procedures Is there a way to use tsql variables as tablenames and columnames in stored procedures using SQL Server 7? i.e.: create procedure test @tablename nvarchar(255), @columname nvarchar(255) as select @columnname from @tablename (which doesn't work) etc? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Passing Variables -- Search Engine Friendly?
Hello, I've noticed some URL's set up in ways like these two. Could someone please explain them for me? The little understading I have it is so that the search engines will index the pages. Is that correct? How the commas function? As "="? ( http://www.sportal.co.uk/football/news/article/0,5081,47198,00.html ) ( http://www.internetsoccer.com/handler.cfm/article,display/Con_ID,2/Locatio nCode,NAmerica/ID,26307/At_ID, ) Thank you. == - == == - ==== - == Allen Graetz USI - Web Application Programmer 1-800-USINTERNET x241 612-253-3241 -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Bread Crumb Navigation
This is what I use for breadcrumbs, based on directory structure: | #curdir# | I put this in my custom tags directory and call it in my naviagation bar (CF_NAVIGATION). Chris Evans [EMAIL PROTECTED] http://www.fuseware.com -Original Message- From: Don Cuniff [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 25, 2000 6:31 AM To: [EMAIL PROTECTED] Subject: Re: Bread Crumb Navigation I'd also be interested in learning what you are doing. One of the reasons I am enamored with frames is their unique ability to leave breadcrumbs in their own way. Please advise, Don -Original Message- From: Jeff <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, March 25, 2000 4:18 AM Subject: Re: Bread Crumb Navigation >karen, > >:~~ >: From: Karen Hayward <[EMAIL PROTECTED]> >: >: Has anyone had any experience in setting up bread crumb >: navigation on web sites? >: >: ie. when you click on a link on a web page the next page >: you view has a link to the previous page and so on and so >: on. (eg. computers > hardware > mainboards as links). >: Yahoo use bread crumb navigation. >: >: I would like to do this and am having trouble finding CF >: resources that explain how to do so. >:~~ > >i helped develop a directory browsing utility that does this very thing. it >creates a bread crumb based on how many folders in from the root you are. >one link for each folder deeper you go. unfortunately it's not online yet >so i don't have a live version to show you. > >lemme know if this is what you're looking for and i can let you know some of >the basic logic used to create it. > >thanks, > >.jeff > >name://jeff.howden >game://web.development >http://www.evolt.org/ >mailto:[EMAIL PROTECTED] > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Problems with CFX_EXCEL
Hi, here is the link:- http://www.wheretoflyfish.com Any problems, let me know. Kind regards Paul Burgess > -Original Message- > From: cftalk [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 25, 2000 1:13 PM > To: [EMAIL PROTECTED] > Subject: Problems with CFX_EXCEL > > > I am using CFX-Excel. > For some reason CF is telling me, that the file > TOPInfo_Excel.XLS > > already exists. > > > Error Diagnostic Information > > Error in CFX_Excel Tag > > C:\cfusion\database\TOPInfo_Excel.XLS already exists. > > The error occurred while processing an element with a general > identifier of > (CFX_EXCEL), occupying document position (13:1) to > (18:19). > > > I am using the same name in file, workbook and worksheet. > Is this a problem ? > > File="C:\cfusion\database\TOPInfo_Excel.XLS" > Workbook="C:\cfusion\database\TOPInfo_Excel.XLS" >Worksheet="TOPInfo_Excel" >Row="2" >Col="1"> > > Best Uwe > > > SD Solutions > Uwe Degenhardt > Fon: 08122/903791 > Fax: 08122/903792 > Net: www.sdsolutions.de > Mail: [EMAIL PROTECTED] > > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Problems with CFX_EXCEL
I am using CFX-Excel. For some reason CF is telling me, that the file TOPInfo_Excel.XLS already exists. Error Diagnostic Information Error in CFX_Excel Tag C:\cfusion\database\TOPInfo_Excel.XLS already exists. The error occurred while processing an element with a general identifier of (CFX_EXCEL), occupying document position (13:1) to (18:19). I am using the same name in file, workbook and worksheet. Is this a problem ? Best Uwe SD Solutions Uwe Degenhardt Fon: 08122/903791 Fax: 08122/903792 Net: www.sdsolutions.de Mail: [EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Bread Crumb Navigation
I'd also be interested in learning what you are doing. One of the reasons I am enamored with frames is their unique ability to leave breadcrumbs in their own way. Please advise, Don -Original Message- From: Jeff <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Saturday, March 25, 2000 4:18 AM Subject: Re: Bread Crumb Navigation >karen, > >:~~ >: From: Karen Hayward <[EMAIL PROTECTED]> >: >: Has anyone had any experience in setting up bread crumb >: navigation on web sites? >: >: ie. when you click on a link on a web page the next page >: you view has a link to the previous page and so on and so >: on. (eg. computers > hardware > mainboards as links). >: Yahoo use bread crumb navigation. >: >: I would like to do this and am having trouble finding CF >: resources that explain how to do so. >:~~ > >i helped develop a directory browsing utility that does this very thing. it >creates a bread crumb based on how many folders in from the root you are. >one link for each folder deeper you go. unfortunately it's not online yet >so i don't have a live version to show you. > >lemme know if this is what you're looking for and i can let you know some of >the basic logic used to create it. > >thanks, > >.jeff > >name://jeff.howden >game://web.development >http://www.evolt.org/ >mailto:[EMAIL PROTECTED] > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
ColdFusion Server ODBC Verify (Failed)??
--ABA5A154B7E984D3BB6D0CED Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I just installed SQL7 Server Desktop Edition from the Inside SQL Server 7.0 book, on Win98 OS. ColdFusion Studio verifies (LocalServer) for System Data Sources on localhost. Plus two other data sources I set up in ODBC32 control panel. I just reformatted drive C: and did a complete clean install of Win98 OS, IE5.0, ColdFusion Server 4.0.1 and CF Studio 4.0.1. ColdFusion Server verification of (ODBC Data Sources Available to ColdFusion) fail for LocalServer, MQIS and SQL2 another data source I configured for SQL Server. Do I need to install SP2 service pack? During install of SQL7 I thought I saw SP2 being installed. I'm using Website Pro web server. SQL7 Server is working fine. I just can't get ColdFusion Server to see it. During configuration of SQL server data sources does a dialog box requesting the (Select Create Repair Compact) appear like configuring Access DB. Because this dialog box did not appear. Am I missing something? I have configured MSDE SQL7 data sources that CF Server recognized. Can someone please point me in the right direction. Thanks, Kevin Merker --ABA5A154B7E984D3BB6D0CED Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit I just installed SQL7 Server Desktop Edition from the Inside SQL Server 7.0 book, on Win98 OS. ColdFusion Studio verifies (LocalServer) for System Data Sources on localhost. Plus two other data sources I set up in ODBC32 control panel. I just reformatted drive C: and did a complete clean install of Win98 OS, IE5.0, ColdFusion Server 4.0.1 and CF Studio 4.0.1. ColdFusion Server verification of (ODBC Data Sources Available to ColdFusion) fail for LocalServer, MQIS and SQL2 another data source I configured for SQL Server. Do I need to install SP2 service pack? During install of SQL7 I thought I saw SP2 being installed. I'm using Website Pro web server. SQL7 Server is working fine. I just can't get ColdFusion Server to see it. During configuration of SQL server data sources does a dialog box requesting the (Select Create Repair Compact) appear like configuring Access DB. Because this dialog box did not appear. Am I missing something? I have configured MSDE SQL7 data sources that CF Server recognized. Can someone please point me in the right direction. Thanks, Kevin Merker --ABA5A154B7E984D3BB6D0CED-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Bread Crumb Navigation
karen, :~~ : From: Karen Hayward <[EMAIL PROTECTED]> : : Has anyone had any experience in setting up bread crumb : navigation on web sites? : : ie. when you click on a link on a web page the next page : you view has a link to the previous page and so on and so : on. (eg. computers > hardware > mainboards as links). : Yahoo use bread crumb navigation. : : I would like to do this and am having trouble finding CF : resources that explain how to do so. :~~ i helped develop a directory browsing utility that does this very thing. it creates a bread crumb based on how many folders in from the root you are. one link for each folder deeper you go. unfortunately it's not online yet so i don't have a live version to show you. lemme know if this is what you're looking for and i can let you know some of the basic logic used to create it. thanks, .jeff name://jeff.howden game://web.development http://www.evolt.org/ mailto:[EMAIL PROTECTED] -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.