cfencrypt alternative that also works in visual basic 6 and visual basic .NET
I have been working on an encrypt/decrypt alternative that works in(code) both ColdFusion, Visual Basic .NET, and Visual Basic 6. This makes encrypted values available to applications outside of ColdFusion.For example, lets say that you have a ColdFusion application and have stored the user's password in the database with UrlEncodedFormat(encrypt(UserPassword,DatabaseKey)) ..but later, you want to have a chat server application to be able to compare encrypted versions of the password.Currently, you can't do that with the encrypt function because its functionality cannot be simulated(except..possibly in JAVA using the mimic object). Other solutions make use of third party COM objects that are another point of pain/failure for some developers. This solution makes it possible to write multiple applications in different languages and have access to encrypted values. See Macromedia ColdFusion Forums thread # 647580 Full Link: http://webforums.macromedia.com/coldfusion/messageview.cfm? catid=7threadid=647580 Be sure to copy and paste the full link as it looks as if it will be split between two lines. Best Regards Zine [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
COM Object With Return Variables. How do I get the return variables out of the object?
I'm dealing with COM objects more and more lately.. Here's my problem..The Com object(objOnHand) has a method with parameters that point to variables which we would later be able to use in Visual Basic.. VB Code Snippet --- objOnHand.AuthorizeEx strAuthenticationcode, strErrorInfo, strIsApproved --- This allows us to Use the variables strAuthenticationcode, strErrorInfo, and strIsApproved in any code following. Malfunctioning Corresponding CF Snippet --- cfscript //Call the AuthorizeEX function hresult=objOnHand.AuthorizeEx(strAuthenticationcode, strErrorInfo, strIsApproved); /cfscript --- The problem.. is I am unable to use the return variables as I doubt that I'm passing them correctly. The COM object executes.. with no return variables. Also, a cfdump of #hresult# yields an, Undefined variable error. I was thinking that Hresult would be a collection that I can loop over for the return values.. but that doesn't seem to be the case. Any Ideas on how I can get these values out of the com's instance space? -Zine ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: track duplicate survey votes
If you are looking for the closest thing to secure as you can without requiring a log-in..the do track both cookies and IP. There are two things with just tracking IP.. that you should know about anyway..I If you have a client on a network behind NAT or behind a firewall..and he tells his co-worker behind the firewall..then they will probably both have the same IP address.. so it won't let his co-worker vote.. and Dial up users get a new IP address when they disconnect and reconnect(a process that takes all of 30 seconds). The point is though.. that while tracking cookie and ip is a good solution.. it can't beat having the user log-in for higher security type polls. For all other polls/surveys where you want the most security that you can without requiring the user to log-in.. then IP and cookie is as high as you can go as far as I know. You might also look into getting one of those images that have numbers that only humans can read.. so people will not be able to program bots that will simply submit over and over again. -Zine -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Sunday, July 20, 2003 1:53 AM To: CF-Talk Subject: Re: track duplicate survey votes store cgi.remote_addr with each submission and dont let the same IP vote twice its easy to delete cookies and vote again. It's more of a pain to change ur ip to vote again and if someone does... hey... they've got nothing better to do anyway : ) Tim Laureska [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I have a basic yes/no survey question at a site that is not password protected (we'd like to keep it that way so as not discourage response) Our recent survey question was obviously jumped on by somebody who placed many more yes votes than would be realistic for the issue I'm trying to figure out the best way to track duplicate votes if this is possible ... this may be a simple problem but its new to me and was hoping someone could give me a best way to do this nudge in the right direction Thanks in advance Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Encrypt/Decrypt Functions - Questions
Hey there again I have been using the Encrypt/Decrypt functions to store encrypted values into the database. I have a Visual Basic application that I want to integrate with the user database.. however the database is encrypted with the Encrypt/Decrypt functions. I have the code for the VB application..so I am planning on editing the code in the VB application to encrypt the password string I have the string I'm using to seed the Encrypt function as well :)..so In theory.. I have everything that I need to do that.. except.. VB provides no encrypt/decrypt function. So.. My question.. is how does the encrypt function use the key to seed the 32 bit value that it uses to XOR the string? I read from macromedia's website that the Encrypt/Decrypt functions use the XOR method to encrypt and decrypt the string using a 32 BIT seed...The seed is determined by the key... but how does it actually take the key and convert it to the seed? The end result of this is; I'm going to replicate the encrypt function so I can compare against the value encrypted in the database..I'm just missing how to use the key to make the seed for the XOR of the string. Any help would be greatly appreciated. Zine ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Solutions on 'Error parsing the Tag Library Descriptor'?
This is an error that appears from time to time in the production environment. 'Error parsing the Tag Library Descriptor' -Seems to happen by client.- If the client gets the message once.. they will.. indefinitely. Might this one be fixed in updater 3? -Zine -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Sunday, June 08, 2003 1:52 PM To: CF-Talk Subject: RE: Update on the Installer Freeze Failure to Auto-Start on Windo ws Issues... I may be mistaken but I think the only time you'll see the JRE listed in the add/remove programs is if you've installed the JRE/SDK yourself separately. -Stace -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Sunday, June 08, 2003 11:28 AM To: CF-Talk Subject: Re: Update on the Installer Freeze Failure to Auto-Start on Windo ws Issues... Thanks for the communication, Damon. I am sure many of us are excited about a soon-to-come solution. I know I am. I am sure it will help Michael's blood pressure as well! g The less-than 256 bit color display is reproducible on most any machine, by switching to the default vga driver. You can always change it back after testing, regardless of the video card setup. I just checked the Add/remove listing on my developer box (Win2k) and see that Java 2 runtime Environment, SE shows both v1.4.0_01 and v1.4.0_03. I don't see a listing for java runtime on either my Win2k server (CF 5.0) or my Win2003 server (CFMX Pro) I have no idea is this has any significance at all. Most hosting providers will leave the default video driver in place, to reduce resource requirements while the server is up and running, however, it is not much of a problem to switch to 256 colors (or more) when install packages require it. Most of them do, from what I have seen. Important here is that the installer kick up an error message if the color setting is not high enough. I have seen this reminder a number of times. I, for one will be glad to test whatever scenario you come up with. Jochem accessed my Win2003 server, remotely, yesterday and successfully installed CFMXPro on the machine and while it is installed as a stand-alone, it did complete the install with updater 3, and rebooted without the freeze-up experienced before. I am going to test this procedure a few more times, to make sure I have the steps in the correct order and down pat. In the meantime, I want to install a web site that uses CFMX for non-critical test purposes and continue the saga. As I mentioned in a previous post, I am not experiencing this with Linux/Apache installs. These are no-brainers compared to the Windows issues. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Check my ISP rating: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 == If you are not satisfied with my service, my job isn't done! - Original Message - From: Damon Cooper [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, June 08, 2003 9:41 AM Subject: Update on the Installer Freeze Failure to Auto-Start on Windo ws Issues... | I've not had the cycles to keep up with the feeding frenzy this has turned into, but I thought I'd update everyone on where we are regarding the 2 issues reported and discussed here at the one machine at Mike's hosting site: | | 1) ZeroG Java-based Updater installer hang. | | It took us a little while to track this down (we had to find a machine with less-than 8-bit color display capability...harder than you'd think these days). | | Here's the scoop: | | a) For the GUI-based installer, a minimum of 8-bit color depth (256 colors) is required to run InstallAnywhere-based installers. Additionally, installers require a minimum 640 X 480 screen resolution. | | b) The Updater installer can be invoked in silent mode on Windows, if you have a machine that doesn't meet (a) above for the GUI install, or (b) you have a need to apply the Updater to many machines via batch scripts, etc, etc. Follow the instructions here for a silent install: | | http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenote s_mx_updater03.html#silentinstall | | | 2) CF not automatically starting reliably on Windows after system reboot: | | We had 3 engineers working this all day Friday, and we believe we have a reproducible case, and have started debugging the process to see what's happening. | | One of the things we're about to try is to simply switch Java VM's to see if this is the result of a Java VM bug (we've had several in the interacting-with-Windows-as-a-Service area before, so we're not ruling that out, and it's a quick thing to try. Recall that the CFMX Gold bits shipped out of the box with the Sun 1.3.1_03 VM. Trying the 1.3.1_08 VM, the 1.4.1_03 VM and the 1.4.2 Beta VM will determine whether it's something that's fixed in the VM. If anyone on this list is experiencing the issue,
More Aggravation RE: Very unsatisfied with Macromedia's support attention ...
I hate to aggravate this issue any further.. however.. Coldfusion on our dev server returns a 404 on every cfm page that is directly accessed(but not index pages for some reason.. Ex: http://www.domain.com/ works fine even if the index page is a .cfm file.. but http://www.domain.com/index.cfm returns a 404 error.) This happens until we re-install the connectors ..every time the dev server restarts..I have to run the remove connector script.. and the install IIS connector script otherwise all scripts that have their name in the URL return a 404. Weird.. Went through some of the tutorials on how to fix this issue. (make ColdFusionMX depend on W3 service.. Etc.. ) It still has the same result..Since it is a Dev server.. it doesn't matter much.. still .. if it happened on the Dev server.. it could happen on the Production server. WINNT 4.0 SP6a 800Mhz, 256MB RAM, MS-SQL. The point is.. there are some operating system/CFMX issues out there.. Macromedia is doing beta testing now of the next updater.. Code named Red Sky. I'm looking forward to see if it will fix my issue. -Zine -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 1:43 PM To: CF-Talk Subject: Very unsatisfied with Macromedia's support attention ... I'm very unsatisfied with the attention that Macromedia are paying to the problem at my hosting company. Damon Cooper very generously stepped in to help a few days ago, then passed the problem to one of his support guys and since then it's all gone pear-shaped. There was a couple of phone calls back and forth, and they tried some stuff, but suddenly it's stopped. No emails to Macromedia's support are being replied to. Emails to Damon have not been answered. I am worried that they're all going off for the weekend leaving this unresolved. This is totally unsatisfactory. Here's what they think is an answer ... do you people think this is satisfactory? PROBLEM: The sysadmin was trying to apply updater 3, and every time he did, ColdFusion would hang. Damon thought it was caused by the server only having 16 colour graphics card instead of 256 colour. WHAT'S BEEN DONE: The sysadmin has replaced the card with a 256col card, and tried again to reinstall updater3. Now it seems to install, but CF won't start automatically. Every time the server gets booted, ColdFusion has to be manually started. (I don't consider this to be satisfactory in a large shared environment data centre!) MACROMEDIA'S RESPONSE: Here's what the last response says ( and no further correspondence has been received in the last few hours from Macromedia - to either me or the Sysadmin - we face another weekend with a failed CFMX installation!) [quote] Macromedia: After you install Updater 3, the connector won't work with any prior version of CFMX before Updater 3 so you're all set. FYI. Here's the connector FAQ: http://www.macromedia.com/support/coldfusion/ts/documents/connector_inst all_faq.htm The service starting issue normally logs this to the event viewer. Windows Event log details: System Log The ColdFusion MX Application Server service terminated with service-specific error 2 (0x2). What we found is if you reboot and log in right away, the CF Applcation Server service throw this error. If you wait a minute or two after reboot before logging in, services start up fine. Known bug that currently isn't an easy fix. As long as you know about this bug (and to start CF manually), it should not be too bad. SYSADMIN: So, this is a know error and what you are saying is that if I reboot and wait a few minutes the service will start automatically wihtout the need of anyone to start the service manual ? [/quote] So does the system have to be manually started or not? We can't get them to answer. The MM engineer says at one point if we wait minutes, it'll start, and at another point, he says we have to start CF manually. So which is it? Both the SYSADMIN and I have sent emails to try to clarify this and haven't got an answer. Do you people think it's satisfactory to have a CF installation that won't start automatically? Is this common? What have I done to deserve this? Why can't I have a CF installation that bloody well works properly? Cheers, Michael Kear Windsor, NSW, Australia AFP Webworks. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Duplicate URL parameters?
You can do a listfirst(formfield) to get the first one of the duplicated parameters. so if you have index.cfm?id=6id=5id=4 Coldfusion MX will treat it like,Id=6,5,4 and, listfirst will get the first item in the list, (6) Listfirst takes two parameters, listfirst(list,Delimiters). Delimiters is optional(if delimiters is not included, CFMX assumes a comma). -Zine -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 2:13 PM To: CF-Talk Subject: Duplicate URL parameters? We're moving from CF4.5 to CFMX (yay!). Unfortunately, our Developers have coded duplicate URL parameters, and CFMX treats them differently that CF 4.5 does. It would be nice to just filter out the dupes with a routine called from Application.cfm (at least until the Developers can catch up). Has anybody done this? If I remove dupes from cgi.query_string and save cgi.query_string will CF read the query string correctly and get the URL parameters out of it? thanks, Chris Norloff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Problem with shopping cart (probably bad session coding)
Hrm..perhaps this has to do with browser caching :).. You also may want to make sure that on a multiple product listing.. that the other products on the form are not also getting added to the user's cart. Also.. be careful when storing the price in a hidden field in the HTML form..a known attack to set the price of an item in a cart that stores the price in hidden fields to $0.. is to simply copy the html to a file on your hard drive and edit the html so that the hidden field for the price says 0.. and submit it from the file on your hard drive. -Zine -Original Message- From: Mark Picker [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 11:48 AM To: CF-Talk Subject: Problem with shopping cart (probably bad session coding) Hi All, Now this is really starting to s*t me off. Has been giving me a headache for weeks now and I'm sure it will turn out to be something very very simple that I changed that is causing my problems. More or less these pages come from a shopping cart tag I got a long time ago from the Developers Exchange and had been working fine, but recently has started doing something weird. So first some of the code : application.cfm cfapplication name=ttzed clientmanagement=Yes setClientCookies = Yes sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,30,0)# applicationtimeout=#CreateTimeSpan(1,0,0,0)# cfif NOT IsDefined(session.basket) cflock scope=Session timeout=10 type=Exclusive !--- Create the shopping basket --- CFSET session.basket = queryNew(PartID, PartNumber, ProductURL, Price, Quantity, saleDate, GroupBuy, Grouping) /cflock /cfif ... Now the index page is loaded which has various checks in it, but gets to a section that does an action check. (In this case defaults to list which causes the products_listing.cfm page to be included) cfif NOT IsDefined(attributes.thispage) cfset attributes.thispage = #GetFileFromPath(GetTemplatePath())# /cfif cfif NOT IsDefined(attributes.querystring) cfset attributes.querystring = ? /cfif cfset thisPage = attributes.thisPage cfset queryString = attributes.queryString CFCASE value=list!--- Product listing --- cf_products_listing action=list thispage=#thispage# querystring=#querystring# dsn=#request.dsn#/CFCASE On the products_listing.cfm page is a form : cfoutput query=qryParts cfform action=products_compilebasket.cfm method=post style=vertical-align: middle; enablecab=No td align=center valign=middle bgcolor=EBEBEB class=greytext style=vertical-align: middle; ..content to display product summary, image etc... input type=Hidden name=Quantity value=#dftqty# input type=Hidden name=PartID value=#fldPartID# input type=Hidden name=PartNumber value=#fldPartNumber# input type=Hidden name=Price value=#tempPrice# input type=Hidden name=ProductURL value=long winded URL here.. cfif grouping EQ 2 input type=Hidden name=GroupBuy value=1 cfelse input type=Hidden name=GroupBuy value=0 /cfif input type=Hidden name=Grouping value=#grouping# input type=Hidden name=action value=Add to basket brinput type=image src=../images/add_to_basket.gif alt=Add to basket align=top border=0 onClick=javascript:submit(); /td /cfform /cfoutput .. Now to keep things simple on the products_compilebasket.cfm (where the form is submitting to) I have the absolute top of the page using this code : START Current list of IDs in basket (product_index):br cflock timeout=30 throwontimeout=No type=READONLY scope=SESSION cfloop query=session.basket cfoutput #session.basket.PartID#, /cfoutput /cfloop /cflock START Current list of Quantity in basket (product_index):br cflock timeout=30 throwontimeout=No type=READONLY scope=SESSION cfloop query=session.basket cfoutput #session.basket.Quantity#, /cfoutput /cfloop /cflock Then some code to check if product was already in the basket and if so, add new quantity to old oneotherwise add product etc. !--- Add product to query --- cfif action is Add to basket cflock scope=Session timeout=10 type=Exclusive !--- check to see if the product is in the basket already --- cfset productRow = listFind(valueList(session.basket.PartID), form.PartID) /cflock hr Product Row : cfoutput#productRow#/cfoutput hr !--- Product is in basket, update quantity --- cfif productRow neq 0 cflock scope=Session timeout=10 type=Exclusive !--- determine the new quantity and the correct row --- cfset oldQuantity = listGetAt(valueList(session.basket.quantity), productRow) cfset newQuantity = form.Quantity + oldQuantity cfset tempValue = querySetCell(session.basket, Quantity, newQuantity, productRow) /cflock Then the bottom of the page it has the same code as the top, outputing what the new value of session.basket.PartID is. Now...the problem. Sometimes, you click to add a product to the basket that you know isn't in
RE: Removing bad emails from newsletter db
Have the e-mail come back to an address you pick up with cfpop.. then parse the e-mail for keywords.. such as 'Undeliverable' and 'not deliver' and 'delivery failure' and 'quota'.. and 'transient delivery failure' etc... -Zine -Original Message- From: Python Python [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 1:51 PM To: CF-Talk Subject: Removing bad emails from newsletter db Oops, i guess i do not make myself clear. I dont need to hangle those cfmail that goest o the undeliverable folder of CF, i need to handle those returned emails that bouces when the user does not exist(Errors returned by SMTP server, like 550, user unknow, mailbox full and so on). BP. Blood, It's fairly straight forward to code yourself. You can access the undeliverables folder using CFDIRECTORY and then parse the messages for the e-mail address that bounced and use that to update the database. If on MX I suggest using server.coldfusion.rootDir etc. to locate the undeliverable folder etc. On CF5 and Windows you can use CFREGISTRY etc. Note: the .cfmail file formats are different from CF5 to CFMX. Also, if you want to re-spool messages in CFMX you need to rename the file and restart the CF's mail spool service...which is technically possible to do programmatically using yet more undocumented functions. André -Original Message- From: Blood Python [mailto:[EMAIL PROTECTED] Sent: 28 May 2003 16:40 To: CF-Talk Subject: Removing bad emails from newsletter db One of my client's has about 103k people in his mailing list. He's running his website since 99 and many of these e-mails are bad ones. He wants me to remove the bad e-mails from this list. I used to do that using a software called worldcast, from fairlogic (www.fairlogic.com). It uses DNS to validate e-mails, pretending to send an e-mail and stopping just after he got the 250 code (user exists) or 550 (unknow). Unfortunatly, many networks are not allowing DNS sends, because of spam, so it its not a good solution anymore. I will need to build a tool that interprets the returned e-mails from an actual send (those Undeliverable e-mails) and delete the user based on this e-mail's content. Do you guys knows any software or code that do such thing? Doesn't need to be in cf... I will need to code it myself if i don't find something like that to use, because client needs it very bad (he needs to reduce bandwidth costs). Thank you for your repplies in advance. BP. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Removing bad emails from newsletter db
There is a piece of software out there called MAILLOOP which does that http://www.mailloop.com/ We used it on over 120,000. Be warned of popups on the site though.. -Zine -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 2:35 PM To: CF-Talk Subject: Re: Removing bad emails from newsletter db oi Blood!! have a gander at http://www.mach5.com mach5 mailer... Wednesday, May 28, 2003, 11:39:45 AM, you wrote: BP One of my client's has about 103k people in his mailing list. He's running BP his website since 99 and many of these e-mails are bad ones. BP He wants me to remove the bad e-mails from this list. I used to do that BP using a software called worldcast, from fairlogic (www.fairlogic.com). It BP uses DNS to validate e-mails, pretending to send an e-mail and stopping just BP after he got the 250 code (user exists) or 550 (unknow). BP Unfortunatly, many networks are not allowing DNS sends, because of spam, so BP it its not a good solution anymore. I will need to build a tool that BP interprets the returned e-mails from an actual send (those Undeliverable BP e-mails) and delete the user based on this e-mail's content. BP Do you guys knows any software or code that do such thing? Doesn't need to BP be in cf... I will need to code it myself if i don't find something like BP that to use, because client needs it very bad (he needs to reduce bandwidth BP costs). BP Thank you for your repplies in advance. BP BP. BP _ BP STOP MORE SPAM with the new MSN 8 and get 2 months FREE* BP http://join.msn.com/?page=features/junkmail BP ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX Webservices hangup
Tyler, perhaps if you CFHTTP to it first as a test with a timeout of 10 seconds of something of that nature? And, if an error occurs, trap it with cftry and cfcatch.. and then display a message that states, Sorry the x service is not available now. Check back in a few hours. The CFHTTP would only check if there is an issue contacting the server. If the server is up.. but the page is returning a blank html page.. you may also want to interrogate the contents of the page before you call the web-service(cfhttp.filecontent) for a line of code that stays static.. (perhaps the XML declaration?). -Zine -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 1:46 PM To: CF-Talk Subject: CFMX Webservices hangup Is there any way to check to see if a webservice exists before you call it? We have a application on a shared server, and as far as we can tell whenever the webservice can't connect to the remote server, it creates a server-crashing thread that eventually brings ColdFusion. It's on a shared box, so we're in a panic trying to get it fixed...any ideas? Tyler ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion MX Still crashing after updater. *pulling hair out*
Thanks for your response Jim LOL, I know..definitely odd.. I appreciate you responding. there are no CFX tags at all.. The only outside resource it uses is the Database. It also uses some of the CGI variables and verifies they are not null(or a zero length string) before using them... If I check the CGI variable Http_host several times.. is it going to cause DLLHOST to shoot up? Perhaps DLLHOST is providing that information to JRUN?.. Is there any way that that request that is running behind the scenes.. could be how CFMX stores a cached query? Just a thought.. Recent news: I removed the CFFORM tag in one page on the application.. and I am now relying on the ColdFusion isnumeric() function.. to test and make sure that the value is numeric. It seems to be running better.. It was definitely causing the NULL Pointer JVM error.. I have since(removing it[cfform]).. not seen any of the java.lang.NullPointer errors in the exception.log file. That's good news at least.. and.. at least it is now stable.. Still.. DLLHOST shoots up.. now and then.. but it doesn't hold the processor at 100% for several minutes like it did yesterday(causing the CF overload). Perhaps the CFFORM tag has some problems? Thanks again -Zine -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Saturday, March 22, 2003 3:28 PM To: CF-Talk Subject: RE: ColdFusion MX Still crashing after updater. *pulling hair out* -Original Message- From: Ezine [mailto:[EMAIL PROTECTED] Sent: Saturday, March 22, 2003 2:39 AM To: CF-Talk Subject: ColdFusion MX Still crashing after updater. *pulling hair out* Coldfusion is set to time out all requests after 9 milliseconds(90 seconds).. and yet..iistracer is reporting scripts running for a couple of hours.. during that time.. DLLHOST jumps around.. and Are you calling any external objects? CF can only timeout a thread/request that it has control over - if it's given control of the thread to a another source (database, COM, CFX, etc) then it must wait until that source returns control to it before it can time out the thread. That fact that CF isn't timing out leads me to believe that it not in control (or that it's just plain toast - but since you say that JRUN is still queueing requests it seems to be working). Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: IBM JRE with ColdFusion MX
Dave, I've been running a portal for some time..and it would pop-up as a process during the time when the server would get unstable and crash :).. *grin* It's been one full day without crashing :).. good good. -Zine -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2003 1:30 AM To: CF-Talk Subject: RE: IBM JRE with ColdFusion MX Yes, IIRC, Jikes is in fact the JRE that comes with CFMX. While CFMX appears to come with Jikes, I think that the JRE that it uses by default is the Sun 1.3.1 JRE, on Windows. That's what's in \CFusionMX\runtime\jre, which is the path specified by default in the CF Administrator I think. The file jikesw.exe is found in \CFusionMX\runtime\bin, and I'm not sure what uses it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ColdFusion MX Still crashing after updater. *pulling hair out*
As much as I hate to mention things like this.. In a previous e-mail I mentioned that I had an issue with Coldfusion MX crashing on a high hit site. At the time, Coldfusion MX was un-patched.. Yesterday I ran the ColdFusion MX Updater 2. and, is still crashing at least three times a day.. if not more. There is on average 200+ people on this server... with up to 5 requests simultaneously running(most of the time.. it is 1-2). We have ASP a few ASP scripts running on the same machine. The issue is..DLLHOST.exe will suddenly take up 100% of the processor power and not leave anything for the jrun process.. then the Jrun process queues up users.. until the DLLHOST.exe is finished processing.. or coldfusion gets 230+ queued requests.. then coldfusion quits entirely. The service is still running after it quits.. ..but no response from .cfm pages.. and the processor usage goes down to 1%. It was suggested that there might be a runaway ASP process that is executing.. I examined that possibility with iistracer..and it is, indeed, a coldfusion script that is running. (But.. it doesn't hang like this through most of the requests.. just every so often.. with no pattern)... Coldfusion is set to time out all requests after 9 milliseconds(90 seconds).. and yet..iistracer is reporting scripts running for a couple of hours.. during that time.. DLLHOST jumps around.. and frequently stays at 100% processor utilization(causing there not to be enough processing power and coldfusion to queue up the requests). Also, ColdFusion reports that it has no processes running during this time. Also .. stopping and re-starting the CF application service doesn't get rid of the process that is running.... you have to stop and restart IIS entirely to stop the process that seems to 'every so often' not end. I get this error in my cfmxroot\runtime\logs\default-err.log; 03/21 23:18:23 error Connection reset by peer: JVM_recv in socket input stream read java.net.SocketException: Connection reset by peer: JVM_recv in socket input stream read I sometimes get this error on my cfmxroot\logs\exception.log; Error,jrpp-25494,03/13/03,15:46:20,i3replication_session,null The specific sequence of files included or processed is: D:\Webs\FreeStoreClub\www\default.cfm java.lang.NullPointerException at coldfusion.runtime.ClientScopeKey.hashCode(Unknown Source) at java.util.Hashtable.get(Unknown Source) at coldfusion.runtime.ClientScopeServiceImpl.GetClientScope(Unknown Source) There is at least 250MB of free physical ram... on a Win2K Server with 512MB of RAM Processor speed:800Mhz (single processor) Running the Standard MS SQL JDBC drivers.. SQL Server is running fine.. no issues there. At least a GB of free space on the WIN2K drive.. and at least 6 GB of space on the CFMX drive. Coldfusion performance monitor counters are enabled. Client variables are stored in the database 1 processor = 5 processing pages maximum JRE settings are set to default. I don't use a single application/session variable in the application..so that rules CFLOCK out. We are not using any COM objects.. so that rules COM Objects out.. I'm looking for a solution here.. any Ideas? -Zine ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
DLLHOST.exe woes. Part of ColdFusion MX? IIS Connector?
Hey there again I'm wondering what part DLLHOST.exe plays in the coldfusionMX implementation. It would make sense that dllhost.exe is what is calling the coldfusion connector...right? Is it normal for DLLHOST to be using more processing power then the jrun.exe process? Does DLLHOST play an intricate part in the page assembly? Zine -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 11:39 AM To: CF-Talk Subject: RE: CFX_Tags and Multiple Servers Interesting concept for the webservice - I'm pretty new to webservices - any tutorials, reading on how start with something like this? Thanks, Mark -Original Message- From: Ryan Emerle [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 11:15 AM To: CF-Talk Subject: RE: CFX_Tags and Multiple Servers In CFMX you could make a webserivce wrapper for the CFX tag, but other than that, im pretty sure you would need a copy of the CFX on the other server. -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 10:52 AM To: CF-Talk Subject: CFX_Tags and Multiple Servers Hi All, Is a CFX Custom Tag installed on a web server able to be called and run from websites located on a remote server, if so how would it be done? Thanks, Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DLLHOST.exe woes. Part of ColdFusion MX? IIS Connector?
I'm less worried about the RAM it is taking up and more worried about the amount of processing time it is taking. 100% for long periods of time. What ends up happening..is Jrun.exe doesn't have enough processing power to execute the pages.. and the server queues up users -Zine -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 12:38 PM To: CF-Talk Subject: RE: DLLHOST.exe woes. Part of ColdFusion MX? IIS Connector? Hey there again I'm wondering what part DLLHOST.exe plays in the coldfusionMX implementation. It would make sense that dllhost.exe is what is calling the coldfusion connector... right? Is it normal for DLLHOST to be using more processing power then the jrun.exe process? Does DLLHOST play an intricate part in the page assembly? When you use CF (MX or any other version) with IIS, within IIS you have an Application Isolation option for each virtual server. If you choose Low, the CF ISAPI DLL will be run in-process by the IIS process (INETINFO.EXE, I think). If you choose Medium (in IIS 5) or High, the CF ISAPI DLL will be run out-of-process. Since it's a DLL, not an EXE, it has to be run by something else, and that something else will be DLLHOST.EXE in this case. So, if you have Application Isolation set to Medium or High for the virtual servers running CF, it's not unusual to see high memory usage by DLLHOST.EXE. Macromedia recommends that you run the CF ISAPI DLL in-process for better performance, in which case you wouldn't see DLLHOST.EXE using the memory, but rather INETINFO.EXE. There's nothing necessarily wrong with seeing high memory usage by either, though, as long as your server remains responsive. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What on earth? I don't even know where to begin Troubleshooting this error...
when renaming files, be careful of the case.. Lets us this scenario: You have a Index.cfm that you are editing..(notice the capital 'I' in Index.cfm) ColdFusion already Ran the Index.cfm and made an Index3939493.class You then rename Index.cfm to index.cfm(lower case 'i') and save the page.. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Unique random number?
Eventually though..this will cause a page to loop many times.. and run the Query many times increasing load time and processor time. -Zine -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 1:14 PM To: CF-Talk Subject: Re: Unique random number? I'm having trouble seeing why you need a loop for this?? Can you explain? From your description I would think you'd follow these steps (conditional statements and not loops): 1) set your random number (as you have) 2) run a query to see if that number is used in either table (simple SELECT statement) 3) IF there is a recordcount to the above query then it's in use - do whatever you need to do to handle this. IF NO recordcount then use it as your new job number to create the record(s) you need. HTH Cheers 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: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, March 20, 2003 9:55 AM Subject: Unique random number? Need to set a job number to a unique number, based of creating a number using the RandRange function, but then I need to take that number and bounce it off two access tables (called openjobs closejobs) to see if that random number is already used, then loop back if it is to start over, but if it isn't, then use it to create a new record in openjobs table. What I don't know how to do is the loop structure if the number already exists on one of the two tables. Could someone direct me in how the code would look starting with this CFSET statement? CFSET job_number = RandRange(1, 10) ...and as always, thanks in advance! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: How do I stop losing my cookies and stay logged in?
Dave This type of error is usually caused by a Date/Time issue for cookie expiration. this may be solved by a number of methods.. depending on the issue.. Ex: one time my user login script was doing exactly what yours is doing.. and it ended up.. the system clock was incorrect.. one of the admins had set the timezone of the server to their timezone at home.. and then another admin noticed the time was incorrect and set it to the correct time in a different time zone .. and the majority of the cookies expired immediately. Check your system clock.. and server system clock to make sure that it is correct.. You may also want to check your server variable timeouts. -Zine -Original Message- From: Dave Babbitt [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 1:04 PM To: CF-Talk Subject: How do I stop losing my cookies and stay logged in? Hi Guys! I am running CF Server 5. Everything was working fine until a few weeks ago. Now sometimes when I click on a form link, I lose my User_Info cookie that tells me if I'm logged in or not. This causes the Application.cfm to cf include the login page and abort. If I hit Ctrl-F5 when I am sent to this forced relogin page, it always corrects itself and gives me the intended page. How do I stop losing my cookies and stay logged in? Thanx Dave P.S. Check out my Experts Exchange question for further details. Referring URL 1: http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20557348.htm l Referring URL 2: http://www.clipboardsolutions.net/RentACoder/test_form_field_inpection_logic cfm Referring URL 3: http://www.clipboardsolutions.net/RentACoder/test_cgi_http_host.cfm Referring URL 4: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=12threadid =578875 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Another Challenging question
Ok.. lets say that I have a HTML form with field names from the database.. Like.. ShoppingItem_ItemCode Or a better example.. : 'ShoppingItem_' database.itemcode so..as people add items to their shopping cart.. this list gets longer.. input type=text name=ShoppingItem_Gyro value=1 input type=text name=ShoppingItem_GarbageCan value=3 This works all good and well in the recalculate quantity processor by getting the second element in the list with delimeter, _ to know what product is in the cart and evaluating the full variable to know the new quantity.. and using the string 'ShoppingItem_' to distinguish a field containing the items quantity in the fieldnames variable(skip all of the rest). The problem occurs when someone makes a item with a '-' in the product code.. Ex: someone makes a product with the code; goober-pokerman The form field looks like this; input type=text name=ShoppingItem_goober-pokerman But when the processor goes to evaluate the form field.. for the quantity.. it looks like this, (evaluate(field)) which translates to (evaluate(ShoppingItem_goober-pokerman)).. and Coldfusion treats it as a math equation.. (ShoppingItem_goober - pokerman) = Error: ShoppingItem_goober(missing '-pokerman') is undefined. I tried using the DE function and it returns the fieldname instead of the value of the fieldname Any Ideas on how to get around this Dynamic Evaluation quandary? I'm looking for the value of the fieldname.. It is stored two layers deep here... First.. the field name is stored in a variable(currentitem).. then evaluate(currentitem)= Item quantity in cart. This works unless the field name contains a '-'. If it does.. the evaluate statement treats it as a math equation and can't find the value of only part of the variable name. I'm thinking parhaps something like cfset currentvalue=shoppingcartitem_#currentitem# or something like that.. parhaps.. Any Ideas? -Zine -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 12:15 AM To: CF-Talk Subject: RE: CFMX crashes with high load on cfwddx Found I can bring down our MX server where cfwddx is used. This is a known problem, i am not sure if MM is doing anything about it. Some MM folks here might be able to answer the status on the cfwddx issue. Joe Eugene -Original Message- From: Buckland, Ramon [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 8:31 PM To: CF-Talk Subject: CFMX crashes with high load on cfwddx Hi, Found I can bring down our MX server where cfwddx is used. In a nut shell, obtain wddx string and convert it. cfwddx action=WDDX2CFML input=#wddxPacket# output=st_RS We use WDDX all over the site as our data layer by retreiving through cfhttp. I tested the cfhttp connections but it all came down to this example. (no cfhttp at all) - cfset wddxPacket = wddxPacket version='1.0'header/datastructvar name='STATUS'string1/string/varvar name='RETURNCODE'stringno_db/string/var/struct/data/wd dxPacket cfwddx action=WDDX2CFML input=#wddxPacket# output=st_RS - Put that in a cfm file and ... Stress testing pages by holding down ,CTRL-R in a browser (IE) the server stops resonding. + From a fresh restart it takes about 5 minutes to bring the server down + From a page with many wddx conversions, I am able to bring the server down in about 5 seconds. * WARNING * This crashes my Dev MX Server on IIS PIII 1.4Ghz , 1.3G RAM IIS5 Win2k All latest patches from MS as of 10 hrs ago. MX Updater 3 Please tell me I can fix this with config changes :-) Symptoms of the crash are: MX stops responding, IIS keeps purring Restart MX a few times and eventually, IIS stops as well (I even had inetinfo hang and not die until I restarted IIS Admin Service) suggestions ? - NOTICE - This message may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee named above. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient of this message you are hereby notified that you must not use, disseminate, copy it in any form or take any action in reliance on it. If you have received this message in error please delete it and any copies of it and notify CREDIT SUISSE ASSET MANAGEMENT immediately. Any views expressed in this message are those of the individual sender, except where the message specifically states otherwise and the sender is authorized to state them to be the views of CREDIT SUISSE ASSET MANAGEMENT. CREDIT SUISSE GROUP, CREDIT SUISSE FIRST BOSTON, and each legal entity in the CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications through its networks.
CFMX Giving up in high strain conditions.
Hey This server is pre-updater 1. I'm having an issue with a pair of twin ColdFusionMX (Win2000 Server 500MB RAM, 800Mhz) servers, where CFMX seems to give up when it cannot muster enough system resources. then when the resources are available.. it is still down and the only way to fix it is to re-start the ColdFusionMX application server service(it appears to just 'give up').The ColdFusion server can 'give up' in three different ways.. The first way is to simply not return a response(results in a 'can't contact the server' on the client). The second way is to display a blank white page.. htmlhead/headbody/body/html. The third way is to produce a JRUN 404 error. Two specific triggers of this problem as of late are.. Database outages.. and Processor time.This server occasionally fights for processing time with .ASP pages.. ...and an asp page that runs for a while(some times more then 50 seconds(the asp timeout has been removed so that the reports don't error..the reports take a while.) It would make sense if it simply queued up the requests until the resources became available.. ..but after they become available.. it simply sits there with all the requests in the queue not doing anything. Is this issue resolved in an updater? Has anyone experienced anything similar where coldfusion MX gives up in an extremely high strain environment where Jrun doesn't seem to be doing anything at all(after it gives up)? This is a high hit server with limited resources..and I'd like to resolve this without 'requiring' that we get another CPU if possible(we will invest in new hardware if there is no other way). -Zine ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Linkpoint
Jason, It is relatively expensive to set up an API account.. though I have seen it for as low as $500. The Actual API is extremely complicated :)..'C++' Libraries are provided for free for anyone who wants to make one.. but they also offer the API/wrapper as a separate product(an additional $40) It is also extremely fast.. and a C++ CFX_Custom Tag. It also does Tax Calculation, virtual check, address verification service, Zone based Shipping. It does do Recurring transactions! http://www.linkpoint.com/product_solutions/internet/linkpointselectapi/lpa_m ain.html sorry if this wraps ;). The CFX tag uses a query data type to return the product data back to the LinkPoint So you must Create that Query using the queryNew function Ex: CFSET ItemContext = queryNew(ITEMID, DESCRIPTION, ITEMPRICE, ITEMQTY) cfoutput query=orders CFSET TempValue = queryAddRow(ItemContext) CFSET TempValue = querySetCell(ItemContext, ITEMID, #product#) CFSET TempValue = querySetCell(ItemContext, DESCRIPTION, #description#) cfset retailpricen=#retailprice# CFSET TempValue = querySetCell(ItemContext, ITEMPRICE, #retailpricen#) CFSET TempValue = querySetCell(ItemContext, ITEMQTY, #quantity#) /cfoutput Here is some example code using the CFX tag: This code has had the Item and Customer queries removed for security purposes so IT WON'T work out of the box.. you will need to grab the parts that help you understand the Linkpoint CFX_ API. CFSET Chargetype_Auth = 0 !--- Funds Captured upon approval, funds will be set to transfer --- CFSET Chargetype_Sale = 0 !--- Funds Captured upon approval, funds will be set to transfer --- CFSET Chargetype_Preauth = 1 !--- Funds Reserved upon approval, Postauth will be needed to transfer funds --- CFSET Chargetype_Postauth = 2 !--- Reserved funds will be transferred, use upon shipping a hardgood --- CFSET Chargetype_Credit = 3 !--- Return or Refund of funds that were, AUTH, SALE or POSTAUTH --- CFSET Chargetype_Error = 0 !--- this option no longer used, please disregard --- CFSET Result_Live = 0 !--- Run transactions in LIVE mode, transaction charges apply --- CFSET Result_Good = 1 !--- Run transactions in TEST mode, no transaction charges --- CFSET Result_Duplicate = 2 !--- Return a duplicate transaction result --- CFSET Result_Decline = 3 !--- Return a decline transaction result --- CFSET Esdtype_None = 0 !--- Electronic softgood download type none --- CFSET Esdtype_Softgood = 1 !--- Electronic softgood download type file --- CFSET Esdtype_Key = 2 !--- Electronic softgood download type key (serial number) --- cftry!--- ORDERTAX = #tax# ORDERSUBTOTAL= #total# - Unchecked ---!--- cfloop index=a from=1 to=#arraylen(cfcatch.tagcontent)# cfset current_tag_stack = '#cfcatch.tagcontent[a]#' LIB#current_tag_stack[ID]#/b (#current_tag_stack[LINE]#, #current_Tag_stack[COLUMN]#) #current_tag_stack[TEMPLATE]# /cfloop --- !--- #cfcatch.tagcontext#, --- cfset pdate='#dateformat(now(),mmdd)##timeformat(now(),HHmmss)#' !--- Query: Select Items in shopping cart --- CFSET ItemContext = queryNew(ITEMID, DESCRIPTION, ITEMPRICE, ITEMQTY) cfoutput query=orders CFSET TempValue = queryAddRow(ItemContext) CFSET TempValue = querySetCell(ItemContext, ITEMID, #product#) CFSET TempValue = querySetCell(ItemContext, DESCRIPTION, #description#) cfset retailpricen=#retailprice# CFSET TempValue = querySetCell(ItemContext, ITEMPRICE, #retailpricen#) CFSET TempValue = querySetCell(ItemContext, ITEMQTY, #quantity#) /cfoutput cfif itemcontext.recordcount eq 0 !--- Error Report.. No Items Selected? --- cfabort /cfif CFX_LinkAPI REQSTORENAME = 507035 REQKEYFILE = c:\\winnt\\system32\\drivers\\etc\\darrencslp.pem REQHOSTADDR = secure.linkpt.net REQPORT = 1139 ORDERUSERID = #cookie.user# ORDERBCOMPANY = ORDERBCOUNTRY = #bcountry# ORDEROID=#pdate# ORDERIP=#REMOTE_HOST# ORDERBNAME = #trim(fname)# #trim(lname)# ORDERBADDR1 = #trim(baddress)# ORDERBCITY = #trim(bcity)# ORDERBSTATE = #bstate# ORDERBZIP = #trim(bpostalcode)# ORDERSNAME = #trim(fname)# #trim(lname)# ORDERSADDR1 = #trim(daddress)# ORDERSCITY = #trim(dcity)# ORDERSSTATE = #dstate# ORDERSZIP = #trim(dpostalcode)# ORDERSCOUNTRY = #dcountry# ORDERPHONE = #trim(telephone1)# ORDERFAX = ORDERCOMMENTS = On Dans Shopping cart ORDERCARDNUMBER = #trim(ccnumber)# ORDERCHARGETYPE = #Chargetype_Auth# ORDERCARDEXPMONTH = #expmonth# ORDERCARDEXPYEAR = #right(exp_year,2)# ORDEREMAIL = #trim(email1)# ORDERRESULT = 0 ORDERSUBTOTAL= #subtotal# ORDERSHIPPINGPRICE = #sh# ORDERTAX = #tax# QUERY = ItemContext cfcatch type=anycfset tagerror='#listgetat(cfcatch.detail,2,-:)#' cftry cfif tagerror eq
RE: Installation problem Wont ANYONE help?????
lol, I had to re-build the DSNs when I upgraded to CFMX.( NT 4.0 SP6a).. but I happily did.. and it has been working since.. Installation never failed for me.. but it didn't work right off.. had to edit a JRUN XML file to get it to work. *shrugs*such is the way of upgrading.. expect the unexpected.. and then you still get hit on the head. -Zine. -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 2:49 PM To: CF-Talk Subject: Installation problem Wont ANYONE help? Below is an easy step-by-step configuration approach for windows web server configuration. Applicable for IIS, Apache and iPlanet. Please ignore steps that do not apply. 1) Stop your web server. 2) Please uninstall CFMX, 3) Delete any registry key for HKLM\Software\Macromedia\ColdFusion, 4) Delete the CFusionMX_installdir and rename the CFIDE and CFDOCS from your IIS webroot. 5) Reboot your machine. 6) On reinstalling CFMX, please use the stand alone webserver that came with CFMX. 7) Try to access the CFMX Administrator on port 8500. 8) From your CFusionMX\Bin\Connectors folder, double click on the particular connector you wish to work with CFMX. If you receive an error stating that Jrun is not started, please close the DOS window and launch C:\CFusionMX\Bin\cfstart.bat then launch the web_connector.bat again. 9) A directory C:\CFusionMX\runtime\lib\wsconfig\1, should have been created with jrun.dll for IIS, mod_jrun.so for Apache and jrun_nsapi35.dll inside the 1 directory. 10) Please verify from your CF documentation on what entries should have been created/inserted to Apache and Netscape conf files. For IIS, there might be a need to Map .cfm to C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll in your IIS console. To apply the instruction, please go to START SETTINGS CONTROL PANEL ADMINISTRATIVE TOOLS INTERNET SERVICES MANAGER. Double click on the computer icon/name. Right click on the Default website, or onto the virtual site you need to define the mapping, and select properties. Click on the Home Directory tab and click on the Configuration button. This is where internet documents are mapped, by their extension, and this is where you will need to apply Step # 10. 11) If you did not delete or rename your old CFIDE and CFDOCS folders from your webroot, please rename/delete them now and copy the CFIDE and CFDOCS folders from CFusionMX_installdir\wwwroot to your webroot. 12) Try launching the CFMX Administrator using the port of your web server. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX null null errors
Interesting, In the past..I have seen this only on a site that is hit pretty hard.. (1 million hits a day+).. thanks for the info in checking into the cfform tag. Zine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 2:55 PM To: CF-Talk Subject: RE: CFMX null null errors I'm not using CFFORM at all. I think it may happen when trying to use rereplace() on a large string. Could this be the culprit? Brook At 11:39 AM 3/6/2003 -0800, you wrote: java.lang.StackOverflowError means that the JVM ran out of room in memory for processing more method calls. This shouldn't happen under normal use; it's usually tied to runaway recursive calls, or possibly infinite loops. I'd check for either of those cases, perhaps with some code library that you're using on all your forms. I successfully submit huge forms (up to about 80 fields) to CFMX without any issues, so I suspect its a problem with the CF code being executed, not the CF server. However, it might be tied to using CFFORM for validation, if you're using it. I'm not on my forms, so that might be the difference. HTH, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 11:33 AM To: CF-Talk Subject: CFMX null null errors Does any one know when these CFMX null null errors come from? It looks to me like when a form with lots of fields (30+) gets submitted, sometimes this happens. The error diagnostics are: null null brThe error occurred on line -1. Type java.lang.StackOverflowError and sometimes in the browser all you see is 500 Null. Anyone seen this also? Brook Davies logiforms.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: New Macromedia.com launched! -- THE END
How about holding down shift when clicking on the link? (the keyboard shortcut?) -Zine -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 12:54 PM To: CF-Talk Subject: RE: New Macromedia.com launched! -- THE END As Stan points out, I never realized how much I desperately need a right-click Open in New Window until it disappeared in the DevEx. That one is definitely going into the feedback form. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Database Results - Quick DB -- CFOUTPUT Tutorial
Well, Then you are going to like Coldfusion :) In ColdFusion.. it is much simpler(and less wordy).. more so then ASP because ColdFusion handles the details of the record set. For example... lets say that you have a table called 'names' with two fields in it; FirstName and LastName. And the table lays out like this: LastName,FirstName { McNally,Jhon Gooble,Billy Pizza,Italian } To display all of those records.. would look something like this; ---Snip- !--- //Get Data from the Database --- cfquery datasource=Your_ColdFusion_Administrator_Datasource name=What_ever_You_want_To_Name_It select * from names /cfquery !--- //Output the data --- cfoutput query=The_Name_Parameter_on_the_cfquery_statement #lastname#,#firstname# /cfoutput --End Snip-- And ColdFusion handles everything else.. even down to incrementing the array position. Nice huh? Don't need to worry about arrays.. or initializing data objects.. or any of the ASP overhead. *grin* The Query field values are like an associative array.. for example..if you want to access the the firstname field of a query you named FirstnameLastname (In the CFQUERY statement; cfquery name=FirstnameLastname datasource=Your_ColdFusion_Administrator_Datasource) you would use the variable;FirstnameLastname.firstname (queryname.fieldname). Using the CFOUTPUT tag with the 'query' parameter also does something special.. It tells ColdFusion to try to preface your variables with the query (in the query parameter) you specified(unless you already have a regular variable by that name). So, using the cfoutput statement will reduce a variable like; #The_Name_Parameter_On_the_cfquery_statement.firstname#, to #firstname# within the open and close CFOUTPUT tag. In the example above, see how I didn't use the unimaginably long query name I specified? However, I could if I wanted to..use #The_name_Parameter_on_the_cfquery_statement.lastname#,#The_Name_Parameter_O n_the_cfquery_statement.firstname#. *grin* but nobody would want to use that! ColdFusion automatically 'scopes' the variable to the query for you. Of course you'd want to put a BR or place table control tags to format the HTML, ex; (the cfquery tag stays the same) -Snip table cfoutput query=The_Name_Parameter_on_the_cfquery_statement TRTD#lastname#,/tdtd#firstname#/td/tr /cfoutput /table -End Snip- Also, ColdFusion populates certain values that you can use(but you have to reference with the 'queryname.' before..For example:Coldfusion automatically populates the RecordCount value for the query. Tip: The Recordcount value is the number of rows returned in a query. So.. when you want to see how many records were returned from a query, use the variable, #queryname.recordcount#. Ex: you have a query named FirstnameLastname (from the table above) and you want to display the whole table..AND make sure that if there is nothing in the table, you tell the user that 'there are no names in the table' instead of showing nothing. I'll also use the ColdFusion datasource on my server named,'customerdata'. --Snip--- cfquery datasource=customerdata name=FirstnameLastname select * from names /cfquery cfif FirstnameLastname.RecordCount eq 0 !--- //There aren't any records if RecordCount is 0 --- BRThere are no names in the table! cfelse!--- //The query returned records, Displaying them! --- cfoutput query=FirstnameLastname BR#Lastname#,#Firstname# /cfoutput /cfif -End Snip- Ex: To see if a UserName and password submitted is valid Table userinfo's fields: ID, UserName, Password { 1,'Dan','1234' 2,'Joseph','Z1Gzp-Vqr' 3,'Angus','Goober' ) The User submitted the form variables, 'User' for Username and 'pass' for password.(POST or GET.. ColdFusion deals with them seamlessly[ColdFusion even deals with URL parameters seamlessly, No Extra Code Needed to parse each type!]) Snip-- cfquery name=IsValidLogon datasource=customerinfo SELECT ID FROM userinfo WHERE UserName = '#form.User#' AND Password = '#form.pass#' /cfquery cfif IsValidLogon.RecordCount neq 0 !--- //RecordCount will be zero if no records and something else(nonzero) when there is records // TIP: the ' neq 0' part isn't really needed because the tags between the if branch will execute when Recordcount is // nonzero. That is, of course.. unless you are also testing for duplicate username and password combinations --- Congratulations! You logged IN! cfelse invalid Username or password cfinclude template=logon_form.cfm!--- Include the Login form in the execution --- cfabort!--- Stop processing (after the login form is loaded)--- /cfif ---End Snip- Warning.. the code above does a case-INsensitive match for most SQL distributions. If you wanted
RE: CFMX load test
Hey, Have a look at http://femnet.freestoreclub.com/ Those prices are all dynamically calculated :).. and the catalogs are dynamic also.. It is an extremely complex shopping cart program that allows users that are logged in (and paid) to mark-up products on their subdomain, hide.. show/products from the company wide catalog..:)..all of the products.. at once.. or one product.. or both :). I'm not at liberty to mention how many simultaneous users it supports :) *grin* or the hardware of the servers.. however I can vouch for Coldfusion being capable of handling huge amounts of load. Site was previously using ASP for the shopping cart.. however the ASP TO IIS handler was constantly taking 50% of the processor!.. Totally dynamic pages(assembled at runtime) (dynamic menus.. dynamic site contents) an average of 45Kb, range of 200Kb to about 16KB About 19-25 different .cfm pages run on each page load Range of 1-16 queries per page load.. average of 12 Cookies not needed for site to function. Cookie variable encryption supported. Random Ordering of over 600 products on page load. Execution time is about 350ms - 850ms ( 1000ms is one second ) If you are going to do load testing on your own server,Make sure that you do not enable debug mode while load testing as It adds a huge amount of load to the servers and the statistics generated from the load test are not accurate because of the excess stress from producing the debug information. Ezine -Original Message- From: Ken Beard [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 9:25 AM To: CF-Talk Subject: CFMX load test I'm looking for CFMX load test statistics for a shopping cart-type application which were not done by macromedia.. sort of validating the cfmx platform for a major client. Anyone know where I can find some? Ken ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: Random SQL statement
I have a table of 600 or so products that I store as a cached query.. then generate a random number from one to the recordcount in CF and use it as the rowstart and rowend.Works like a charm unless you intend to have it update the data in real time.. performance gains are seen in as little as caching the query for 5 minutes :). -Ezine -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:15 PM To: CF-Talk Subject: RE: Random SQL statement This link goes into this in depth. http://www.aspalliance.com/stevesmith/articles/randomselect.asp ~Jason -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 12:09 PM To: CF-Talk Subject: Random SQL statement I have a table with a Unique ID field and I would like to do a random select on the table UID. Basically I want to send the user to a page that displays that random record. Does SQL have a random function? I cant find anything in my books. SELECT rand(ID) FROM table Or should I select all records from the table and use CF to pick a random record from the dataset? Thanks, Chad ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: nesting cfoutputs?
lol, In 4.5, you could nest cfoutputs without the group attribute by putting them inside a cfincluded document. Daniel Olivares WorldWideWebz.com Phone: (760) 268-0504 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] URL: http://www.worldwidewebz.com mailto:[EMAIL PROTECTED] -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 11:31 PM To: CF-Talk Subject: RE: nesting cfoutputs? Sorry -- misread your message. Yes, weird, works for me too cfmx/iis. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 20 November 2002 5:23 p.m. To: CF-Talk Subject: nesting cfoutputs? not that i care or would ever need to do this, but oddly enough i am able toi can nest cfoutputs? we werent able to in cf5. i dont think? cfset tony=tony can nest cfoutputs cfoutput#tony#cfoutput#tony#/cfoutput/cfoutput i am running cfmx on iis5 jussa wondrin' ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
(OT) Is Microsoft Using ColdFusion?
Hey, Check it out.. Microsoft Using ColdFusion for a specific service? http://solutions.greatplains.com/FreeToWork1/form1_tdm.cfm?user=1code=22ci d=48mediatype=dm 'Great Plains Software Inc. is a wholly-owned subsidiary of Microsoft Corporation. The names of actual companies and products mentioned herein may be the trademarks of their respective owners. Microsoft will not share the information you provide with third parties without your permission except where necessary to complete the services or transactions you have requested, or as required by law.' Daniel Olivares WorldWideWebz.com Phone: (760) 268-0504 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] URL: http://www.worldwidewebz.com mailto:[EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 1:25 AM To: CF-Talk Subject: Re: Server Scope / UDFs On Tuesday, Nov 19, 2002, at 12:05 US/Pacific, Dave Watts wrote: Well, personally, I'm not much of a fan of the idea of loading UDFs into memory anyway - memory is good for storing data, but is wasted on code. Well, functions are just data. The benefit is that you don't have to include the file that defines the function... I have a sneaky suspicion that cfset myudf = application.udf.myudf is faster than cffunction name=myudf ... /cffunction or the cfscript equivalent... I've never load tested it, but i would expect that the CF processing engine, whether it's CF 5 pcode or CF MX Java has to take more time to read in and create the function than to assign a pointer to it. The pointer is after all only a byte or two of volatile memory lookup vs. the function definition which is invariably larger, plus time to actually parse and validate the code and make sure it's not missing a double-quote or a close-parenthesis somewhere, etc. Does anybody know for sure? Has anyone done any load testing to compare them? s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: secure email...
Storing 'IP', 'Cftoken'(if using client state management) and 'address to' database. Then checking against them based on SQL aggragate functions :) It isn't likely that user/customer would send it out to more then 20 friends... and.. it isn't likey that a user/customer would send the same e-mail to their friend more then twice. Might also be able to be done with arrays and application variables!(faster) Daniel Olivares WorldWideWebz.com Phone: (760) 268-0504 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] URL: http://www.worldwidewebz.com mailto:[EMAIL PROTECTED] -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 8:04 PM To: CF-Talk Subject: secure email... so we are in the process of changing email servers and we toggled relaying on and somehow the malicious spammers found it in record time and started bombing us with email to broadcast... That we are going to address on Monday in litigation against the sending companies... I was wondering how people were dealing with email from Cold Fusion applications to respond to such issues... Since CFMAIL doesn't support any login and password login type stuff... We have applications like mail to a friend that are particularly troublesome where the origin is an email that is not local to our servers and the recipient isn't local either... by every definition it fits the whole looks like spam definition to a properly closed email server... Interested in hearing what everyone is doing :) Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Shopping Cart
If your SSL provider supports it, parhaps passing the order number would also be an acceptable option.. I particularly like either UUID, or 'mmdd-hhmmss-ip1-ip2-ip3-ip4', example: 01132002-201001-192-168-0-1 if UUID isn't available. Code snippet: -- !--- Daniel Olivares - Update: 03_17_2002 --- cfset tempvalue='#right(year(Now()),2)##month(Now())##day(Now())#-#timeformat(Now( ),HH)##timeformat(Now(),mm)##timeformat(Now(),ss)#-#REMOTE_ADDR#' !--- Write the date string and append the IP address like this.. 03012002-120320-192.168.0.1 --- cfset OrderNumber='#Replace(tempvalue, ., -, ALL)#' !--- Replace periods from the remote address with dashes --- --- End Code snippet This would probably make more sense in a cfscript block.. so here. Code snippet: -- cfscript // Daniel Olivares - Update: 03_17_2002 tempvalue='#month(Now())##day(Now())##right(year(Now()),4)#-#timeformat(Now( ),HH)##timeformat(Now(),mm)##timeformat(Now(),ss)#-#REMOTE_ADDR#'; // Write the date string and append the IP address like this.. 03012002-120320-192.168.0.1 OrderNumber='#Replace(tempvalue, ., -, ALL)#'; // Replace periods from the remote address with dashes /cfscript --- End Code snippet Daniel Olivares WorldWideWebz.com Phone: (760) 268-0504 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] URL: http://www.worldwidewebz.com mailto:[EMAIL PROTECTED] -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 16, 2002 2:58 PM To: CF-Talk Subject: Shopping Cart Hey everyone. I have a shopping cart CFC which is working fine. My problem is this: in order to pay via CC, the user is taken to a third party site that is branded to look like mine running except this is SSL. Now when the suer leaves my site, I have a session variable holding the shopping cart object; but a previous replier stated that going from http to https requires manually tracking the CFID and CFTOKEN... so when the third party site redirects the user back to my site, i check the order processed for Yes or No and if Yes I am unable to record the sale since the session variable is not valid anymore. Does this make sense? Is there some other technique I can use? Client Variables? etc.. Thanks. Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: HTML E-mails with CFMAIL
I wouldn't mind taking a look at the multipart e-mail sender also :). Thanks for the offer Daniel Olivares WorldWideWebz.com Phone: (760) 268-0504 Email: [EMAIL PROTECTED] mailto:dco;worldwidewebz.com URL: http://www.worldwidewebz.com mailto:dan;worldwidewebz.com -Original Message- From: Matt Robertson [mailto:matt;mysecretbase.com] Sent: Monday, November 04, 2002 1:46 PM To: CF-Talk Subject: RE: HTML E-mails with CFMAIL Does anyone know if wrapping email outpuut to make it a truly fully formatted html page is good, bad or indifferent? If 'good', would a doctype help or hurt? As I mentioned in a previous post a handful of recipients out of a few thousand got blank messages using that tag I posted, and I'm trying to nail down the cause. cfmail ... #my.taggedoutput# ... /cfmail Versus cfmail ... htmlheadtitleEmail Message/title/headbody #RecShow.PageText# /body/html ... /cfmail --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Thane Sherrington [mailto:tsherr;auracom.com] Sent: Monday, November 04, 2002 10:13 AM To: CF-Talk Subject: Re: HTML E-mails with CFMAIL At 12:56 PM 11/4/02 -0500, S. Isaac Dealey wrote: You can use type=html in the cfmail tag, although the mail client I use ( not Eudora ) doesn't recognize this as a properly formatted html email. If I tried this but no luck. you're going to send these emails to anyone other than yourself you might want to look into using a multi-part email with a text format followed by an html format -- somewhere I've got a custom tag i built for myself that pushes an email this way and allows me to toggle between text and html in the email client I use. Let me know if you'd like to see the source and I'll forward it on. I wouldn't mind seeing the tag if you have time to look for it. T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com