Datasource listing under linux.
Dear all, I was wondering if anyone knew a way to obtain the list of datasources available to coldfusion under linux. I know it can be done in windows with use of CFREGISTRY and the odbc.ini file but I am unaware of how to accomplish this under Linux. Any help would be much appreciated. Regards, Martin. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rendering WAP
There was a site where it looks like you can do this. But I haven't used it. Can't remember where I got a previous emulator but there are others out there. The www.gelon.net WebSite allows you to view a WAP page by submitting a link to their emulator located in their server to process. http://gelon.net/cgi-bin/wapalizeericssonr320.cgi?url=http://www.gelon. net/cgi-bin/wap.cgi -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 22 January 2002 03:29 To: CF-Talk Subject: RE: Rendering WAP Apologies for the OT but can anyone advise if you can render WAP in a normal browser. No, normal browsers don't support WML. (WAP is the transport protocol, not the language; WAP is to WML what HTTP is to HTML, to slightly oversimplify.) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cf sites go poof
That's why it's a good idea to run such scripts from at least two different networks. Kinda like the server-checking services that page you at 3:00am because it couldn't rouse your mail (or CF or DNS or whatever) server from their lame connection. Things like this really need to be run from multiple connections to be the least bit reliable. Jim - Original Message - From: Lewis Sellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 21, 2002 9:50 PM Subject: Re: cf sites go poof On Tue, 22 Jan 2002 09:47:16 +0700, [EMAIL PROTECTED] (Paul Hastings) wrote: http://www.coldfusionjournal.com/ not poofed away. No response here. Hmm. http://www.cfmentor.com appears alive well in italy ;-) Ah. I'm getting an under construction page today. http://www.cffaq.org not poofed. I looked... apparently she's there and connecting but it's timing out waiting for the server to respond. Heavy load maybe. Oh well. Maybe it'll all clear up in a few days. --min __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Hits counter at DB? (II)
Please!! Anyone had a similar issue? any help will be appreciated, JAAV - Original Message - From: JAAV [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, January 21, 2002 5:15 PM Subject: Manual statistics/ Hits counter at DB? Hello, Our website is composed by a huge number of business cards. We want to show to our clients their card statistics with pretty interface. Something like: hits by day, hits in the last month, average, etc. The first thing we thought was to make an UPDATE Counter = Counter + 1 query each time the webuser hits each webpage. But We are thinking this can be dangerous cause we have more than 1000 000 hits in a month and growing. We can't give access to a statistics software. May we use and text file instead? What do you recommend? Thanks in advance, ~Jaav __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFX_TCPClient Installation?
Do I do the same thing for the TCPClient? Just regeister the DLL in CFAdmin? I'm really really new to all this...not sure what I'm doing... =) Does it take the same tags as CFX_TCPClinet? Thanks all!! -Ron __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFX_TCPClient Installation?
Not quite, theres a small batch file that comes with the com object, it will register the dll with your machines OS, then your good to go. Useage begins somethign like... cfscript obj = CreateObject(COM, Intrafoundation.TCPClient); /cfscript There are plenty of good examples with the DLL though. -Original Message- From: Ron Davis [mailto:[EMAIL PROTECTED]] Sent: 22 January 2002 11:33 To: CF-Talk Subject: Re: CFX_TCPClient Installation? Do I do the same thing for the TCPClient? Just regeister the DLL in CFAdmin? I'm really really new to all this...not sure what I'm doing... =) Does it take the same tags as CFX_TCPClinet? Thanks all!! -Ron __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Problems with looping
Angel Stewart wrote: Hey all, I tried the two solutions offered, end neither of them worked. The code is still only cycling over the first employee and simply not moving to any other employee in the database. I'm at a complete loss as to why, since the logic should be sound. it's simple, cfloop loses track of it's self when nested, you need to store a reference to the current row of the first cfloop to access the current position in the second cfloop query=qry1 cfset qry1_currentrow=qry1.currentrow cfloop query=qry2 #qry1.name[qry1_currentrow]# #qry2.email# /cfloop /cfloop __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sql Help
set dateformat mdy declare @datevar smalldatetime set @datevar = 'select getdate()' select convert(smalldatetime, @datevar, 101) How come this is not working. I am trying to get the current date stored in a variable in a mm/dd/ format. Please Help. Joshua Tipton __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rendering WAP
WML emulators, i KNOW that nokia has one on their site and BELIEVE moto rola has one too. you might check those out. Declan Maher [EMAIL PROTECTED] on 01/22/2002 03 :38:34 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Rendering WAP There was a site where it looks like you can do this. But I haven't u sed it. Can't remember where I got a previous emulator but there are othe rs out there. The www.gelon.net WebSite allows you to view a WAP page by submitti ng a link to their emulator located in their server to process. http://gelon.net/cgi-bin/wapalizeericssonr320.cgi?url=http://www. gelon. net/cgi-bin/wap.cgi -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 22 January 2002 03:29 To: CF-Talk Subject: RE: Rendering WAP Apologies for the OT but can anyone advise if you can render WAP in a normal browser. No, normal browsers don't support WML. (WAP is the transport protocol , not the language; WAP is to WML what HTTP is to HTML, to slightly oversimplify.) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript/coldfusion--- Can you do this?
i've seen this question before. I'm wondering why it's such a big de al to convert a query into a javascript array... Is it not the case that all you have to do is write the js array to the page in your cfoutput right when you DOING the query? thanks for the help! Steve Oliver [EMAIL PROTECTED] on 01/21/2002 04:16:38 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: javascript/coldfusion--- Can you do this? Look into WDDX, CFML2JS will create an array of all of your values for you. Something like script cfwddx action=cfml2js input=qryName toplevelvariable=variablename /script That will result in script variablename = new array stuff /script You'll need to include wddx.js which is in your cfide/scripts folder. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 4:55 PM To: CF-Talk Subject: javascript/coldfusion--- Can you do this? i have an application that saves a listing entry. this entry can have multiple number of addresses. so i have a child window that pops up. this window then calls addresspost.cfm, this is the code you will fin d below, and with this page i save the address and proceed to get all of the address that belong to the specific listing_id. once i get all of the addresses i place them into an array. but now i'm trying to pass that array into javascript and don't know how. Please help SomeOne Thank you Metzy cfparam name=txtListing_Id default= cfparam name=selArea default= cfparam name=txtStreet1 default= cfparam name=txtStreet2 default= cfparam name=txtCity default= cfparam name=selState default= cfparam name=txtZip default= cfparam name=txtPhone default= cfparam name=txtFax default= cfparam name=txtEmail default= cfparam name=txtHours default= cfparam name=txtDescription default= cfparam name=txtKeywords default= cfparam name=chkActive default=off cfoutput cfquery name=address datasource=#dsn.listings_v2# INSERT INTO address (Listing_Id, area_Id, street1, street2, city, state, zipCode, phone, fax, email, hours, description, keywords, active) VALUES (#txtListing_Id#, '#selArea#', '#txtStreet1#', '#txtStreet2#', '#txtCity#', '#selState#', '#txtZip#', '#txtPhone#', '#txtFax#', '#txtEmail#', '#txtHours#', '#txtDescription#', '#txtKeywords#', '#chkActive#') /cfquery cfquery name=addressArray datasource=#dsn.listings_v2# dbtype=ODBC SELECT address_ID, street1 FROM address WHERE listing_id = #txtListing_id# /cfquery /cfoutput cfif addressArray.recordCount GT 0 cfset arrValue = ArrayNew(1) cfset arrLabel = ArrayNew(1) cfloop index=i from=1 to=#addressArray.recordcount# cfset arrValue = AddressArray.address_id cfset arrLabel = 'addressArra.street' /cfloop HTML HEAD META NAME=ROBOTS CONTENT=NONE SCRIPT LANGUAGE=JavaScript !-- function refreshProduct() { // Rebuilds the catalog list for the product page. // It is built here so that it can be returned to the product page and reloaded window.opener.modifyAddress(#arrLabel#, #arrValue#); window.close(); } //-- /SCRIPT /HEAD BODY onload=javascript: refreshProduct(); /body /HTML cfelse HTML HEAD META NAME=ROBOTS CONTENT=NONE SCRIPT LANGUAGE=JavaScript !-- function refreshProduct() { // Rebuilds the catalog list for the product page. // It is built here so that it can be returned to the product page and reloaded var arrValue; var arrLabel; window.opener.modifyaddress(arrLabel, 0); window.close(); } //-- /SCRIPT /HEAD BODY onload=javascript: refreshProduct(); /body /HTML /cfif - Metzy Matinez __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Rendering WAP
Or you could just use OPERA 5.x plus - they all render wml - it's different (obviously) that an emulator - but it still works. A good emulator/tool is Waptor - with a sort of home-site style wml layout and built in emulator - also IDEs can be got from Motorola, Nokia, Erickson, etc... J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 22 January 2002 13:23 To: CF-Talk Subject: RE: Rendering WAP WML emulators, i KNOW that nokia has one on their site and BELIEVE moto rola has one too. you might check those out. Declan Maher [EMAIL PROTECTED] on 01/22/2002 03 :38:34 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Rendering WAP There was a site where it looks like you can do this. But I haven't u sed it. Can't remember where I got a previous emulator but there are othe rs out there. The www.gelon.net WebSite allows you to view a WAP page by submitti ng a link to their emulator located in their server to process. http://gelon.net/cgi-bin/wapalizeericssonr320.cgi?url=http://www. gelon. net/cgi-bin/wap.cgi -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 22 January 2002 03:29 To: CF-Talk Subject: RE: Rendering WAP Apologies for the OT but can anyone advise if you can render WAP in a normal browser. No, normal browsers don't support WML. (WAP is the transport protocol , not the language; WAP is to WML what HTTP is to HTML, to slightly oversimplify.) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hits counter at DB? (II)
Okay, going on that there are a couple of questions to ask in return. What kind of data source is this running on? Is it running on a dedicated machine or on something that is sharing resources? As far as the business cards, where do they come from? Are they stored in the database or are they static pages that are being called? Counters can be done any number of ways. The easiest would be to do an update or a locked update statement. Another way would be to create a table that was a counter table that you inserted into versus updating. The report would then be along the lines of select count(page_id) as hit_count from counter where page_id = whatever instead of select hit_count from counter. Another idea, a hybrid of the two I just mentioned, would be to have a temp table that a hit would insert into and then a second table that head totals that were calculated nightly by a scheduled process. Hope these give you some food for thought. Hatton Our website is composed by a huge number of business cards. We want to show to our clients their card statistics with pretty interface. Something like: hits by day, hits in the last month, average, etc. The first thing we thought was to make an UPDATE Counter = Counter + 1 query each time the webuser hits each webpage. But We are thinking this can be dangerous cause we have more than 1000 000 hits in a month and growing. We can't give access to a statistics software. May we use and text file instead? What do you recommend? Thanks in advance, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hits counter at DB? (II)
If each one of your pages is dynamic, like buscard.cfm?client=2 In your database, in the client table, you could add a column named hit_counter with a default of 1 Then just add 1 to it each time the page is viewed. Update clients SET hit_counter = hit_counter + 1 Or if you want it tracked by business card, in your business card table you could do the same thing. You could even add a hit_ip column to it, and store the last persons IP in it, this way if a person hits refresh over and over it won't go up. Update clients SET hit_counter = hit_counter + 1 WHERE #cgi.remote_addr# hit_ip __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 8:48 AM To: CF-Talk Subject: RE: Hits counter at DB? (II) Okay, going on that there are a couple of questions to ask in return. What kind of data source is this running on? Is it running on a dedicated machine or on something that is sharing resources? As far as the business cards, where do they come from? Are they stored in the database or are they static pages that are being called? Counters can be done any number of ways. The easiest would be to do an update or a locked update statement. Another way would be to create a table that was a counter table that you inserted into versus updating. The report would then be along the lines of select count(page_id) as hit_count from counter where page_id = whatever instead of select hit_count from counter. Another idea, a hybrid of the two I just mentioned, would be to have a temp table that a hit would insert into and then a second table that head totals that were calculated nightly by a scheduled process. Hope these give you some food for thought. Hatton Our website is composed by a huge number of business cards. We want to show to our clients their card statistics with pretty interface. Something like: hits by day, hits in the last month, average, etc. The first thing we thought was to make an UPDATE Counter = Counter + 1 query each time the webuser hits each webpage. But We are thinking this can be dangerous cause we have more than 1000 000 hits in a month and growing. We can't give access to a statistics software. May we use and text file instead? What do you recommend? Thanks in advance, __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hits counter at DB? (II)
Oh, one more thing, about the text file hit counter. If your using a text file, your server would have to access that file on the hard drive each time it was written to. That would cause serious performance loss. The fastest way would be through the database, adding a hit_counter field to your rows would be less of an impact on the database size then if you added an entire new table that tracked each business card by hits. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 8:48 AM To: CF-Talk Subject: RE: Hits counter at DB? (II) Okay, going on that there are a couple of questions to ask in return. What kind of data source is this running on? Is it running on a dedicated machine or on something that is sharing resources? As far as the business cards, where do they come from? Are they stored in the database or are they static pages that are being called? Counters can be done any number of ways. The easiest would be to do an update or a locked update statement. Another way would be to create a table that was a counter table that you inserted into versus updating. The report would then be along the lines of select count(page_id) as hit_count from counter where page_id = whatever instead of select hit_count from counter. Another idea, a hybrid of the two I just mentioned, would be to have a temp table that a hit would insert into and then a second table that head totals that were calculated nightly by a scheduled process. Hope these give you some food for thought. Hatton Our website is composed by a huge number of business cards. We want to show to our clients their card statistics with pretty interface. Something like: hits by day, hits in the last month, average, etc. The first thing we thought was to make an UPDATE Counter = Counter + 1 query each time the webuser hits each webpage. But We are thinking this can be dangerous cause we have more than 1000 000 hits in a month and growing. We can't give access to a statistics software. May we use and text file instead? What do you recommend? Thanks in advance, __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hits counter at DB? (II)
Well no not really because this file gets cached by the OS, but it would have to be cflocked and this would create a performance loss! -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 23 January 2002 1:31 AM To: CF-Talk Subject: RE: Hits counter at DB? (II) Oh, one more thing, about the text file hit counter. If your using a text file, your server would have to access that file on the hard drive each time it was written to. That would cause serious performance loss. The fastest way would be through the database, adding a hit_counter field to your rows would be less of an impact on the database size then if you added an entire new table that tracked each business card by hits. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 8:48 AM To: CF-Talk Subject: RE: Hits counter at DB? (II) Okay, going on that there are a couple of questions to ask in return. What kind of data source is this running on? Is it running on a dedicated machine or on something that is sharing resources? As far as the business cards, where do they come from? Are they stored in the database or are they static pages that are being called? Counters can be done any number of ways. The easiest would be to do an update or a locked update statement. Another way would be to create a table that was a counter table that you inserted into versus updating. The report would then be along the lines of select count(page_id) as hit_count from counter where page_id = whatever instead of select hit_count from counter. Another idea, a hybrid of the two I just mentioned, would be to have a temp table that a hit would insert into and then a second table that head totals that were calculated nightly by a scheduled process. Hope these give you some food for thought. Hatton Our website is composed by a huge number of business cards. We want to show to our clients their card statistics with pretty interface. Something like: hits by day, hits in the last month, average, etc. The first thing we thought was to make an UPDATE Counter = Counter + 1 query each time the webuser hits each webpage. But We are thinking this can be dangerous cause we have more than 1000 000 hits in a month and growing. We can't give access to a statistics software. May we use and text file instead? What do you recommend? Thanks in advance, __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Paymentech integration
Does anyone have any experience integrating on-line transactions with Paymentech? If so, I'd appreciate some guidance. Thanks! -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sessions and secure servers
I have a shopping cart that uses cfid and cftoken as identifiers for customers. When they get to the end of placing the order, I have the following code to kill the variables: CFSET STRUCTCLEAR(APPLICATION) CFSET STRUCTCLEAR(SESSION) CFLOOP INDEX=X LIST=#GetClientVariablesList()# CFSET DELETED = DELETECLIENTVARIABLE(#X#) /CFLOOP CFCOOKIE NAME=cfid EXPIRES=NOW CFCOOKIE NAME=cftoken EXPIRES=NOW CFCOOKIE NAME=cfglobals EXPIRES=NOW However, since this is done on the secure server (https://myserver.hostdomain.com/clientdir) and the variables were set on the client's domain (www.clientsite.com), it doesn't kill the ones that were set at www.clientsite.com, and when you return to the site, the variables __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: 302 Found with CFLocation?
Evan, we had the same problem. What happened with us is we had CFHTMLHEAD tags in a our application.cfm. So the browser would see the redirect message, with other text at the bottom. This would make it stop auto-redirecting and just show the actual message. So look around and see if there is any extra text in the pages prior to or after the cflocation tag. -- Forwarded message -- Date: Mon, 21 Jan 2002 22:35:12 -0500 From: Evan Lavidor [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Linux [EMAIL PROTECTED] Subject: 302 Found with CFLocation? I have CF5 installed on a RedHat (7.1) box running Apache 1.3.22. Something that I noticed a while ago, but wasn't worried about until recently, is that whenever I do a cflocation I get the a page returned with the following info on it: HTTP/1.1 302 Found Date: Tue, 22 Jan 2002 03:52:09 GMT Server: Apache/1.3.22 (Unix) (Red-Hat/Linux) mod_ssl/2.8.5 OpenSSL/0.9.6 DAV/1.0.2 PHP/4.0.4pl1 mod_perl/1.24_01 Location: ./frameset.cfm Connection: close Content-Type: text/html; charset=iso-8859-1 Found The document has moved here. The word here is linked and links to the file that the cflocation points to. I realize that a cflocation simply writes a 302, but why am I getting this intermediary error page? This wasn't happening when I had CF4.5 installed on the same box. I did some searching on the forums, but couldn't find a conclusive answer from anyone. Please let me know if I can post more info or set up some test pages to help explain the problem, but if anyone has an answer, I'd very much appreciate it. Thanks, Evan Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sessions and secure servers
You could pass something on the url which would indicate to the clientsite to kill the session placing the code to do this before the application.cfm. However if the user notices the url string and keeps adding it, this will kill the session everytime. Another choice option is to check the http referer. Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer ekeda ltd http://www.ekeda.co.uk (+44)020-8429-7300 -Original Message- From: Lacey Lawson [mailto:[EMAIL PROTECTED]] Sent: 22 January 2002 14:54 To: CF-Talk Subject: sessions and secure servers I have a shopping cart that uses cfid and cftoken as identifiers for customers. When they get to the end of placing the order, I have the following code to kill the variables: CFSET STRUCTCLEAR(APPLICATION) CFSET STRUCTCLEAR(SESSION) CFLOOP INDEX=X LIST=#GetClientVariablesList()# CFSET DELETED = DELETECLIENTVARIABLE(#X#) /CFLOOP CFCOOKIE NAME=cfid EXPIRES=NOW CFCOOKIE NAME=cftoken EXPIRES=NOW CFCOOKIE NAME=cfglobals EXPIRES=NOW However, since this is done on the secure server (https://myserver.hostdomain.com/clientdir) and the variables were set on the client's domain (www.clientsite.com), it doesn't kill the ones that were set at www.clientsite.com, and when you return to the site, the variables __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:Paymentech integration
We've done some pretty extensive integration with Paymentech. Our first move was to Authorize.net, but as of late thier stability is a huge issue. The gateway goes down several times a day and forget about getting anyone on the phone never happen. We are in the process of switching to either Plug n' Pay (www.plugnpay.com) or iTransact (www.itransact.com). Both are good, work with paymentech and have CFX tags pre-build for thier individual api's. At this point we are leaning toward Plug n' Pay. Below is a copy and paste from a spreadsheet I was using to compare the prices of the 2. iTransact Plug n' Pay Transaction Fee $0.10 $0.09 Monthly Fee $24.95 $20.00 Free Monthly Transactions 500 1000 Setup Fee $295.00 $295.00 Projected Number of Transactions5,000.00 Total Monthly Cost $474.95 $380.00 Hope that helps, Chris -- Original Message From: Howie Hamlin[EMAIL PROTECTED] Subject: Paymentech integration Date: Tue, 22 Jan 2002 09:58:56 -0500 Does anyone have any experience integrating on-line transactions with Paymentech? If so, I'd appreciate some guidance. Thanks! -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF sessions still having a problem.
Ok people, I have in my application.cfm file my cfapplication tag like so: cfapplication name=CourseRegistration sessionmanagement=Yes clientmanagement=Yes clientstorage=CourseReg I set a default for my session loggedON like so: cfparam name=session.loggedON default=false Then also in my application.cfm file I watch for seesion.loggedON like so: CFIF session.loggedON EQ false !--- Don't send them to the logon screen if the query string contains logon. This means there are at the logon screen. If we didn't watch for this it would send the browser into a loop --- CFIF NOT (application.qryString CONTAINS logon) cflocation addtoken=Yes url=index.cfm?Fuseaction=logon.logon /CFIF /CFIF Ok this works fine. But after the user logs on I cannot write to my session.loggedON i get this error: An error occurred while evaluating the expression: session.d_code = logonUser.DLRCODE Error near line 62, column 9. Attempt to access a Session variable when session management is not enabled. Use the CFAPPLICATION tag to enable session management. Note: This feature may have been disabled by the site administrator. The error occurred while processing an element with a general identifier of (CFTHROW), occupying document position (266:11) to (266:73). Now as you can see I have sessionmanagement set to yes above in my cfapplication tag. I have checked in the admin too and session and client vars are enabled. I have never had this problem before. Anyone have any ideas please help :) Shawn Regan Applications Developer pacifictechnologysolutions __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Hits counter at DB? (II)
First : thank all of you guys... :) Right now, we made this (for people can be interested) 1. An update statement like: UPDATE Statistics SET Displays = Displays + 1 WHERE IDCard= #attributes.IDCard# and DisplayDate = #odbcDate# where: odbcdate: is the date of the day using this format mm/dd/ (without time) This table contains the daily hits statistics. 2. Each month, a process consolidate that data into a montly table (and delete the old ones) --- I know DB (SQL Server in my case) must be able (or we must suppose that) to process tons of transactions without problems but, because of the increa sing of hits, I thought text file can be a better alternative. I hope the current mechanism is a scalable one. Thanks again, JAAV - Original Message - From: Andrew Scott [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 3:36 PM Subject: RE: Hits counter at DB? (II) Well no not really because this file gets cached by the OS, but it wou ld have to be cflocked and this would create a performance loss! -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 23 January 2002 1:31 AM To: CF-Talk Subject: RE: Hits counter at DB? (II) Oh, one more thing, about the text file hit counter. If your using a text file, your server would have to access that file on the hard drive each time it was written to. That would cause serious performance loss. The fastest way would be through the database, adding a hit_counter field to your rows would be less of an impact on the database size the n if you added an entire new table that tracked each business card by hits. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 8:48 AM To: CF-Talk Subject: RE: Hits counter at DB? (II) Okay, going on that there are a couple of questions to ask in return. What kind of data source is this running on? Is it running on a dedicated machine or on something that is sharing resources? As far a s the business cards, where do they come from? Are they stored in the database or are they static pages that are being called? Counters can be done any number of ways. The easiest would be to do a n update or a locked update statement. Another way would be to create a table that was a counter table that you inserted into versus updatin g. The report would then be along the lines of select count(page_id) a s hit_count from counter where page_id = whatever instead of select hit_count from counter. Another idea, a hybrid of the two I just mentioned, would be to have a temp table that a hit would insert into and then a second table that head totals that were calculated nightly by a scheduled process. Hope these give you some food for thought. Hatton Our website is composed by a huge number of business cards. We want to show to our clients their card statistics with pretty interface. Something like: hits by day, hits in the last month, average, etc. The first thing we thought was to make an UPDATE Counter = Counter + 1 query each time the webuser hits each webpage. But We are thinking this can be dangerous cause we have more than 1000 000 hits in a month and growing. We can't give access to a statistics software. May we use and text file instead? What do you recommend? Thanks in advance, __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sessions and secure servers
Not sure why you are killing the application scope variables, as this is across all users to the site anyway and don't need to be killed unless your storing info in here that are used for this user only, and if this is the case change your code so that it doesn't use the application scope unless you have variables that can be shared across multiple users. Secondly, if you are using the client scope check that it is being removed from the DB. Or is this stored in the cookie or Registry, either way the client variable should be killed. The best practice I can recommend if the SSL site is not on the same machine use WDDX encrypted in the url or store the information in the DB to transfer to the SSL site. You have to remember that if the Secured Site is on another domain you will get a complete new set of CFID CFToken variables and this will be why when returning back that the client variables are still there. If it was me, I would store the required info into a DB before going to the secured site then by using a cookie with another value to help identify the user pull this info back out of the DB. There might be a more efficient way, but this has always worked for me. -Original Message- From: Lacey Lawson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 23 January 2002 1:54 AM To: CF-Talk Subject: sessions and secure servers I have a shopping cart that uses cfid and cftoken as identifiers for customers. When they get to the end of placing the order, I have the following code to kill the variables: CFSET STRUCTCLEAR(APPLICATION) CFSET STRUCTCLEAR(SESSION) CFLOOP INDEX=X LIST=#GetClientVariablesList()# CFSET DELETED = DELETECLIENTVARIABLE(#X#) /CFLOOP CFCOOKIE NAME=cfid EXPIRES=NOW CFCOOKIE NAME=cftoken EXPIRES=NOW CFCOOKIE NAME=cfglobals EXPIRES=NOW However, since this is done on the secure server (https://myserver.hostdomain.com/clientdir) and the variables were set on the client's domain (www.clientsite.com), it doesn't kill the ones that were set at www.clientsite.com, and when you return to the site, the variables __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help on Duty Roster
Han WOW, a few years out. Don't know how much help this will be but a few suggestions. I would start with these tables 1) Individual (ID,name, etc) 2) Exemptions (ID, exemption - Leave, Other duty, etc) 3) Dates (IndividualID, ExemptionID, startdate, enddate) ?4) Roster list ( the control number of when Individual last had duty) (Normally high number is up next- could possibly be added to Individual table) There are a number of calendar generators. You need to just find one that fits you best. You would generate the calendar. Loop through control numbers find highest one. Review exemptions if none for the date, place individual on duty (possibly rest to 1 at this time, you might need to have another table to temporally hold the information to accommodate changes). if individual exempt don't reset control number, go to next highest and repeat. When the roster is completed (monthly, quarterly) you could create temp tables to hold each time period. I have manually ran a number of duty rosters, but have never tried to completely automate one. Good luck, Rodney -Original Message- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 7:31 PM To: CF-Talk Subject: Help on Duty Roster Help help!! hi anyone tried to code a duty roster before..?? anyone can shed some light to how to get it up using a cost effective way? sigh.. i can only think of putting every single day, mth, year with its relevant fields into a table. but its going to be tedious if the duty roster need to be done up a few years in advance.. stressed han __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT javascript
how can i cap the 1st letter of every word in a sentence? i tried using regexp inthe following matter to no avail, myRegex=/^[a-z]|\s[a-z]/g mySentence=this is a sentence; mySentence=mySentence.replace(myRegex,/[A-Z]/); now some thing like this would've worked in perl because you can replace a character from a correspondnig character in a set but apparently in javascript you cannot do so. any ideas how this can be done short of breaking the sentence at the spaces in to an array, capitalizing and then using .join(' ') to get everything back together? thanks-Savan __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT javascript
This same topic just came through 2 days ago ;-) Go to cflig.org and grab the UDF that does just what you want Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 8:36 AM Subject: OT javascript how can i cap the 1st letter of every word in a sentence? i tried using regexp inthe following matter to no avail, myRegex=/^[a-z]|\s[a-z]/g mySentence=this is a sentence; mySentence=mySentence.replace(myRegex,/[A-Z]/); now some thing like this would've worked in perl because you can replace a character from a correspondnig character in a set but apparently in javascript you cannot do so. any ideas how this can be done short of breaking the sentence at the spaces in to an array, capitalizing and then using .join(' ') to get everything back together? thanks-Savan __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT javascript
haha, thnx. Bryan Stevenson [EMAIL PROTECTED] on 01/22/2002 10:43 :59 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Re: OT javascript This same topic just came through 2 days ago ;-) Go to cflig.org and grab the UDF that does just what you want Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 8:36 AM Subject: OT javascript how can i cap the 1st letter of every word in a sentence? i tried using regexp inthe following matter to no avail, myRegex=/^[a-z]|\s[a-z]/g mySentence=this is a sentence; mySentence=mySentence.replace(myRegex,/[A-Z]/); now some thing like this would've worked in perl because you can repl ace a character from a correspondnig character in a set but apparently in javascript you cannot do so. any ideas how this can be done short of breaking the sentence at the spaces in to an array, capitalizing and then using .join(' ') to get every thing back together? thanks-Savan __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Query output in a form question
What I'm trying to do is on the result page to dynamically pull only the items that were checked or radio or possibly an input textbox. And not pull the ones that were not chosen. With the The form result page however when I use the variables it only shows the last entry in the input. How do I dynamically pull the data? Example of data Entry1,key,size Entry2,key,size Entry3,key,size Entry4,key,size So if I only want the 1st and 3rd entry on the result page can it be done dynamically so I don't have to modify the page every time I add a new entry in the database? Date: Mon, 21 Jan 2002 15:54:43 -0500 From: Steve Oliver [EMAIL PROTECTED] Subject: RE: Query output in a form question Message-ID: 004501c1a2bd$da3b69d0$[EMAIL PROTECTED] I'm not sure what you mean, do you just want to pass the Item ID of an item with a radio input next to it? If so just do something like this. input type=Radio name=ItemID value=#ItemID# #ItemName# Then the value of FORM.Item on the next page will be your itemID. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Schwartz, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 2:44 PM To: CF-Talk Subject: Query output in a form question Hello, I have a db table that im querying into an html form table. I would like have an input field linked to each entry in the database. So that on submit it will only show the choices that were checked with a radio button or something. Is this possible? Here is the information that Im wanting to carry over to the second form page. Where the number of items in the database is about 25 items. So that if they only click on the radio button for say item 21 on the second page it will pull all of the inputs from the top table and only item number 21 from the second table. Thanks in Advance. Paul Schwartz !---code--- form name=form1 method=post action=FORM2.cfm tabletrtd tr tdName:/tdtdinput type=text name=name/td tdManager:/tdtdinput type=text name=manager/td /tr tr tdEmployee ID:/tdtdinput type=text name=empid/td tdDepartment:/tdtdinput type=text name=dept/td /tr tr tdPhone Number:/tdtdinput type=text name=phone/td tdLocation:/tdtdinput type=text name=location/td /tr tr tdExtension:/tdtdinput type=text name=extension/td /TR table align=center TR TDITEM1/TD TDITEM2/TD TDITEM3/TD TDITEM4/TD TDKEY/TD/TR CFOUTPUT query=ITEMStr td width=45%#ENTRY1#/a/td td#ENTRY2#/td td#ENTRY3#/td td#ENTRY4#/td tdinput type=RADIO name=#key#/td/tr /CFOUTPUT !---code ends--- IMPORTANT NOTICE: This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you have received this message in error, you are hereby notified that we do not consent to any reading, dissemination, distribution or copying of this message. If you have received this communication in error, please notify the sender immediately and destroy the transmitted information. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
well-baked cookies
I'm trying to push cfcookie's usage to the limit, by storing and reading lots of user information on it. Can someone share some thoughts on the following? 1. is it possible to store complexed variables (i.e - arrays and/or structure) into a cookie? is that adviseable? 2. is it possible to store XML or WDDX packets into Cookie? 3. is it possible to store encrypted values in a cfcookie, i.e: cfcookie name=foo value=#Encrypt(foo,123)# and then re-use the ordinary within a cfquery SELECT from . WHERE userpassword='#Decrypt(Cookie.foo,123)#' does this takes noticable time and process usage? I mean - much more then NOT encrypting? -M. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Slashes in the URL
I've posted this yesterday, but I can't see it - can someone share a link or a piece of info on the ability to replace ? and signs with / (slash) as parameters delimiters in the url? i.e - template like: http://mydomain.com/?action=listcategory=3002 would give something like this: http://mydomain.com/action/list/category/3002 I know CDNOW uses a simiilar method, here: http://www.cdnow.com/cgi-bin/mserver/SID=1362066037/pagename=/RP/AO_NR/adv_o rd.html/clickID=tn_ao_txt This are definitly not actual directories... Michael. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Query output in a form question
Like I said, use an input type of radio or checkbox with the name of ItemID If you use checkboxes, then it will send a list of values to your action page. input type=checkbox name=ItemID value=#qryname.ItemID# Say item 1 and 3 were checked, on your action page Form.ItemID would be 1,3 Using this you can do something like this cfquery ... SELECT contents FROM table WHERE 1=0 cfloop list=#FORM.ItemID# index=I OR itemID = #i# /cfloop /cfquery __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Schwartz, Paul [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:54 AM To: CF-Talk Subject: RE: RE: Query output in a form question What I'm trying to do is on the result page to dynamically pull only the items that were checked or radio or possibly an input textbox. And not pull the ones that were not chosen. With the The form result page however when I use the variables it only shows the last entry in the input. How do I dynamically pull the data? Example of data Entry1,key,size Entry2,key,size Entry3,key,size Entry4,key,size So if I only want the 1st and 3rd entry on the result page can it be done dynamically so I don't have to modify the page every time I add a new entry in the database? Date: Mon, 21 Jan 2002 15:54:43 -0500 From: Steve Oliver [EMAIL PROTECTED] Subject: RE: Query output in a form question Message-ID: 004501c1a2bd$da3b69d0$[EMAIL PROTECTED] I'm not sure what you mean, do you just want to pass the Item ID of an item with a radio input next to it? If so just do something like this. input type=Radio name=ItemID value=#ItemID# #ItemName# Then the value of FORM.Item on the next page will be your itemID. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Schwartz, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 2:44 PM To: CF-Talk Subject: Query output in a form question Hello, I have a db table that im querying into an html form table. I would like have an input field linked to each entry in the database. So that on submit it will only show the choices that were checked with a radio button or something. Is this possible? Here is the information that Im wanting to carry over to the second form page. Where the number of items in the database is about 25 items. So that if they only click on the radio button for say item 21 on the second page it will pull all of the inputs from the top table and only item number 21 from the second table. Thanks in Advance. Paul Schwartz !---code--- form name=form1 method=post action=FORM2.cfm tabletrtd tr tdName:/tdtdinput type=text name=name/td tdManager:/tdtdinput type=text name=manager/td /tr tr tdEmployee ID:/tdtdinput type=text name=empid/td tdDepartment:/tdtdinput type=text name=dept/td /tr tr tdPhone Number:/tdtdinput type=text name=phone/td tdLocation:/tdtdinput type=text name=location/td /tr tr tdExtension:/tdtdinput type=text name=extension/td /TR table align=center TR TDITEM1/TD TDITEM2/TD TDITEM3/TD TDITEM4/TD TDKEY/TD/TR CFOUTPUT query=ITEMStr td width=45%#ENTRY1#/a/td td#ENTRY2#/td td#ENTRY3#/td td#ENTRY4#/td tdinput type=RADIO name=#key#/td/tr /CFOUTPUT !---code ends--- IMPORTANT NOTICE: This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you have received this message in error, you are hereby notified that we do not consent to any reading, dissemination, distribution or copying of this message. If you have received this communication in error, please notify the sender immediately and destroy the transmitted information. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slashes in the URL
I actually made a custom tag for this, do you already have IIS setup so you can use index.cfm/id/1 ? You have to uncheck Script Engine, and Ensure File Exists. Then you have to set your folder to allow executables, since it will handle them that way using slashes. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:00 PM To: CF-Talk Subject: Slashes in the URL I've posted this yesterday, but I can't see it - can someone share a link or a piece of info on the ability to replace ? and signs with / (slash) as parameters delimiters in the url? i.e - template like: http://mydomain.com/?action=listcategory=3002 would give something like this: http://mydomain.com/action/list/category/3002 I know CDNOW uses a simiilar method, here: http://www.cdnow.com/cgi-bin/mserver/SID=1362066037/pagename=/RP/AO_NR/a dv_o rd.html/clickID=tn_ao_txt This are definitly not actual directories... Michael. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: sql Help
shouldn it be select @datevar = There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 5:15 AM Subject: sql Help set dateformat mdy declare @datevar smalldatetime set @datevar = 'select getdate()' select convert(smalldatetime, @datevar, 101) How come this is not working. I am trying to get the current date stored in a variable in a mm/dd/ format. Please Help. Joshua Tipton __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: well-baked cookies
1-yes it is possible i am storing an array of portal settings in a cook ie on one of my sites and reading them back 2-possible? sure but you're not going to get very man packets into a co okie 3-possible? yes, but naturally ur not going to get as much info in and in order to use it in a query you'll have to read it back into the page an d submit it to another. Mike [EMAIL PROTECTED] on 01/22/2002 10:56:12 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: well-baked cookies I'm trying to push cfcookie's usage to the limit, by storing and readin g lots of user information on it. Can someone share some thoughts on the following? 1. is it possible to store complexed variables (i.e - arrays and/or structure) into a cookie? is that adviseable? 2. is it possible to store XML or WDDX packets into Cookie? 3. is it possible to store encrypted values in a cfcookie, i.e: cfcookie name=foo value=#Encrypt(foo,123)# and then re-use the ordinary within a cfquery SELECT from . WHERE userpassword='#Decrypt(Cookie.foo ,123)#' does this takes noticable time and process usage? I mean - much more th en NOT encrypting? -M. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: sql Help
Sorry, should be set dateformat mdy declare @datevar smalldatetime select @datevar = getdate() select convert(smalldatetime, @datevar, 101) There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 5:15 AM Subject: sql Help set dateformat mdy declare @datevar smalldatetime set @datevar = 'select getdate()' select convert(smalldatetime, @datevar, 101) How come this is not working. I am trying to get the current date stored in a variable in a mm/dd/ format. Please Help. Joshua Tipton __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: well-baked cookies
You should check the spec for cookies. There are several limitations including: 4k per cookie 20 cookies per domain Also, there are security risks involved with storing infomation on the client. I personally think that it's best to store tracking information in cookies and the actual client or session data on the server. Here's the original Netscape cookie spec: http://home.netscape.com/newsref/std/cookie_spec.html More stuff inline below... HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Mike [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 11:56 AM Subject: well-baked cookies I'm trying to push cfcookie's usage to the limit, by storing and reading lots of user information on it. Can someone share some thoughts on the following? 1. is it possible to store complexed variables (i.e - arrays and/or structure) into a cookie? Yes, as long as it's text. is that adviseable? I don't think so... 2. is it possible to store XML or WDDX packets into Cookie? Yes - xml is only text. However, you would need to URL encode the XML and you are limited to only 4k. 3. is it possible to store encrypted values in a cfcookie, i.e: cfcookie name=foo value=#Encrypt(foo,123)# and then re-use the ordinary within a cfquery Yes... SELECT from . WHERE userpassword='#Decrypt(Cookie.foo,123)#' does this takes noticable time and process usage? I mean - much more then NOT encrypting? I doubt that the process time is appreciable... -M. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Software with Partner Programs
In some places the Macromedia site seems to suggest that partners get developer only copies of all their software and in others that partners get only CF Server and JRUN. Can any current partners let me know which it is? Thanks, Sam __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Software with Partner Programs
Server and Jrunno tools like Studio Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Sam Farmer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 8:38 AM Subject: Software with Partner Programs In some places the Macromedia site seems to suggest that partners get developer only copies of all their software and in others that partners get only CF Server and JRUN. Can any current partners let me know which it is? Thanks, Sam __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Full-Text Search w/ Verity? (Not Working!)
Folks: I need to be able to search our entire web server and find specific strings in .cfm, .html and .cgi files. I have attempted to user Verity to accomplish this, but Verity doesn't appear to index ALL of the ASCII data in a .cfm file. (e.g. Doesn't appear to be a Full-Text search.) Can anyone suggest an efficient method to search the entire ASCII contents of a given list of .cfm, .html and .cgi files? In a nutshell, I need to find how many times cfset myVar = 123 appears in the .cfm files on our web server. Thanks! Christian N. Abad ColdFusion Web Developer __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Slashes in the URL
Say.. that sounds close to what I need. Where are those checkboxes? You have to uncheck Script Engine, and Ensure File Exists. I am using (abusing) IIS 5.0 TIA! I actually made a custom tag for this, do you already have IIS setup so you can use index.cfm/id/1 ? You have to uncheck Script Engine, and Ensure File Exists. Then you have to set your folder to allow executables, since it will handle them that way using slashes. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Full-Text Search w/ Verity? (Not Working!)
If you have Cold Fusion Studio or HomeSite you can use the Search functions there to accomplish this. Chuck Rodgers At 12:22 PM 1/22/02 -0500, you wrote: Folks: I need to be able to search our entire web server and find specific strings in .cfm, .html and .cgi files. I have attempted to user Verity to accomplish this, but Verity doesn't appear to index ALL of the ASCII data in a .cfm file. (e.g. Doesn't appear to be a Full-Text search.) Can anyone suggest an efficient method to search the entire ASCII contents of a given list of .cfm, .html and .cgi files? In a nutshell, I need to find how many times cfset myVar = 123 appears in the .cfm files on our web server. Thanks! Christian N. Abad ColdFusion Web Developer __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slashes in the URL
Look in your IIS manager, right click on Default Web Site, go into the Home directory tab, then click on the Configuration button. Next find .cfm and double click on it, you'll see the 2 checkboxes at the bottom of that form. Other then that, you need to set the folder that you want this enabled in to allow scripts executables to be run. I don't advise setting your entire folder this way, since it does allow executables to be run, (ie. If you have any .exe's for download, they won't download, they'll execute on the server) __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:22 PM To: CF-Talk Subject: Re: Slashes in the URL Say.. that sounds close to what I need. Where are those checkboxes? You have to uncheck Script Engine, and Ensure File Exists. I am using (abusing) IIS 5.0 TIA! I actually made a custom tag for this, do you already have IIS setup so you can use index.cfm/id/1 ? You have to uncheck Script Engine, and Ensure File Exists. Then you have to set your folder to allow executables, since it will handle them that way using slashes. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
sql 7 MDAC
Hi there, has anyone researched which ODBC driver is most stable with CF 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and this query will crash CF to 100% CPU every time I run it: CFQUERY datasource=#request.mainDSN# Name=ViewAssignment SELECT ASSIGNMENTS.num_contentid AS contentid, ASSIGNMENTS.dat_start AS dat_start, ASSIGNMENTS.dat_due AS dat_due, ASSIGNMENTS.bit_complete AS bit_complete, ASSIGNMENTS.txt_description AS txt_description, CONTENT.contenttitle AS title, CONTENT.editable AS editable FROM ASSIGNMENTS, CONTENT WHERE ASSIGNMENTS.num_contentid = CONTENT.contentid AND ASSIGNMENTS.num_contentid = #attributes.contentid# ORDER BY ASSIGNMENTS.dat_due /CFQUERY I'm not exactly sure which MDAC is installed. Is it advisable to update to the most recent MDAC even though we're not running SQL 2000 yet? I noticed on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/ Thanks for any of your help. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql 7 MDAC
Have you tried using OLE DB or a Dynamic query with a connection string? __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:27 PM To: CF-Talk Subject: sql 7 MDAC Hi there, has anyone researched which ODBC driver is most stable with CF 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and this query will crash CF to 100% CPU every time I run it: CFQUERY datasource=#request.mainDSN# Name=ViewAssignment SELECT ASSIGNMENTS.num_contentid AS contentid, ASSIGNMENTS.dat_start AS dat_start, ASSIGNMENTS.dat_due AS dat_due, ASSIGNMENTS.bit_complete AS bit_complete, ASSIGNMENTS.txt_description AS txt_description, CONTENT.contenttitle AS title, CONTENT.editable AS editable FROM ASSIGNMENTS, CONTENT WHERE ASSIGNMENTS.num_contentid = CONTENT.contentid AND ASSIGNMENTS.num_contentid = #attributes.contentid# ORDER BY ASSIGNMENTS.dat_due /CFQUERY I'm not exactly sure which MDAC is installed. Is it advisable to update to the most recent MDAC even though we're not running SQL 2000 yet? I noticed on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/ Thanks for any of your help. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: well-baked cookies
You should check the spec for cookies. There are several limitations including: 4k per cookie 20 cookies per domain Even if you get beyond these limits and manage to somehow encrypt your large data, you do realize that your lots of user information is going to be sent across the wire with every single page request right? Just 100K of data? Might as well plop down 100 extra K on each page. Gonna slow you down me thinks... -Cameron Cameron Childress elliptIQ Inc. p.770.460.1035.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Software -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:08 PM To: CF-Talk Subject: Re: well-baked cookies You should check the spec for cookies. There are several limitations including: 4k per cookie 20 cookies per domain Also, there are security risks involved with storing infomation on the client. I personally think that it's best to store tracking information in cookies and the actual client or session data on the server. Here's the original Netscape cookie spec: http://home.netscape.com/newsref/std/cookie_spec.html More stuff inline below... HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Mike [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 11:56 AM Subject: well-baked cookies I'm trying to push cfcookie's usage to the limit, by storing and reading lots of user information on it. Can someone share some thoughts on the following? 1. is it possible to store complexed variables (i.e - arrays and/or structure) into a cookie? Yes, as long as it's text. is that adviseable? I don't think so... 2. is it possible to store XML or WDDX packets into Cookie? Yes - xml is only text. However, you would need to URL encode the XML and you are limited to only 4k. 3. is it possible to store encrypted values in a cfcookie, i.e: cfcookie name=foo value=#Encrypt(foo,123)# and then re-use the ordinary within a cfquery Yes... SELECT from . WHERE userpassword='#Decrypt(Cookie.foo,123)#' does this takes noticable time and process usage? I mean - much more then NOT encrypting? I doubt that the process time is appreciable... -M. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript/coldfusion--- Can you do this?
Steve- thank you for the direction, it looks i can make it work, i think. but how do a pass the variable through a cflocation. do i just append like any other variable or does it have to be in a form? -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 5:17 PM To: CF-Talk Subject: RE: javascript/coldfusion--- Can you do this? Look into WDDX, CFML2JS will create an array of all of your values for you. Something like script cfwddx action=cfml2js input=qryName toplevelvariable=variablename /script That will result in script variablename = new array stuff /script You'll need to include wddx.js which is in your cfide/scripts folder. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 4:55 PM To: CF-Talk Subject: javascript/coldfusion--- Can you do this? i have an application that saves a listing entry. this entry can have multiple number of addresses. so i have a child window that pops up. this window then calls addresspost.cfm, this is the code you will find below, and with this page i save the address and proceed to get all of the address that belong to the specific listing_id. once i get all of the addresses i place them into an array. but now i'm trying to pass that array into javascript and don't know how. Please help SomeOne Thank you Metzy cfparam name=txtListing_Id default= cfparam name=selArea default= cfparam name=txtStreet1 default= cfparam name=txtStreet2 default= cfparam name=txtCity default= cfparam name=selState default= cfparam name=txtZip default= cfparam name=txtPhone default= cfparam name=txtFax default= cfparam name=txtEmail default= cfparam name=txtHours default= cfparam name=txtDescription default= cfparam name=txtKeywords default= cfparam name=chkActive default=off cfoutput cfquery name=address datasource=#dsn.listings_v2# INSERT INTO address (Listing_Id, area_Id, street1, street2, city, state, zipCode, phone, fax, email, hours, description, keywords, active) VALUES (#txtListing_Id#, '#selArea#', '#txtStreet1#', '#txtStreet2#', '#txtCity#', '#selState#', '#txtZip#', '#txtPhone#', '#txtFax#', '#txtEmail#', '#txtHours#', '#txtDescription#', '#txtKeywords#', '#chkActive#') /cfquery cfquery name=addressArray datasource=#dsn.listings_v2# dbtype=ODBC SELECT address_ID, street1 FROM address WHERE listing_id = #txtListing_id# /cfquery /cfoutput cfif addressArray.recordCount GT 0 cfset arrValue = ArrayNew(1) cfset arrLabel = ArrayNew(1) cfloop index=i from=1 to=#addressArray.recordcount# cfset arrValue = AddressArray.address_id cfset arrLabel = 'addressArra.street' /cfloop HTML HEAD META NAME=ROBOTS CONTENT=NONE SCRIPT LANGUAGE=JavaScript !-- function refreshProduct() { // Rebuilds the catalog list for the product page. // It is built here so that it can be returned to the product page and reloaded window.opener.modifyAddress(#arrLabel#, #arrValue#); window.close(); } //-- /SCRIPT /HEAD BODY onload=javascript: refreshProduct(); /body /HTML cfelse HTML HEAD META NAME=ROBOTS CONTENT=NONE SCRIPT LANGUAGE=JavaScript !-- function refreshProduct() { // Rebuilds the catalog list for the product page. // It is built here so that it can be returned to the product page and reloaded var arrValue; var arrLabel; window.opener.modifyaddress(arrLabel, 0); window.close(); } //-- /SCRIPT /HEAD BODY onload=javascript: refreshProduct(); /body /HTML /cfif - Metzy Matinez __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Slashes in the URL
We're doing this (Win2kServer/IIS5/CF5) and it works fine with Script engine checked. Check that file exists definitely has to be unchecked, though. Under IIS' Application Settings/Execute Permissions you only need Script only permission. Not sure about NTFS permissions on the directory. Jim - Original Message - From: Steve Oliver [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 10:25 AM Subject: RE: Slashes in the URL Look in your IIS manager, right click on Default Web Site, go into the Home directory tab, then click on the Configuration button. Next find .cfm and double click on it, you'll see the 2 checkboxes at the bottom of that form. Other then that, you need to set the folder that you want this enabled in to allow scripts executables to be run. I don't advise setting your entire folder this way, since it does allow executables to be run, (ie. If you have any .exe's for download, they won't download, they'll execute on the server) __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:22 PM To: CF-Talk Subject: Re: Slashes in the URL Say.. that sounds close to what I need. Where are those checkboxes? You have to uncheck Script Engine, and Ensure File Exists. I am using (abusing) IIS 5.0 TIA! I actually made a custom tag for this, do you already have IIS setup so you can use index.cfm/id/1 ? You have to uncheck Script Engine, and Ensure File Exists. Then you have to set your folder to allow executables, since it will handle them that way using slashes. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: well-baked cookies
indeed. i forgot to qualify my statements. i'm an intranet developer and we only use 100mbps Cameron Childress [EMAIL PROTECTED] on 01/22/2002 11:43:36 AM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: well-baked cookies You should check the spec for cookies. There are several limitations including: 4k per cookie 20 cookies per domain Even if you get beyond these limits and manage to somehow encrypt your large data, you do realize that your lots of user information is going to b e sent across the wire with every single page request right? Just 100K o f data? Might as well plop down 100 extra K on each page. Gonna slow you down me thinks... -Cameron Cameron Childress elliptIQ Inc. p.770.460.1035.232 f.770.460.0963 -- http://www.neighborware.com America's Leading Community Network Software -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:08 PM To: CF-Talk Subject: Re: well-baked cookies You should check the spec for cookies. There are several limitations including: 4k per cookie 20 cookies per domain Also, there are security risks involved with storing infomation on the client. I personally think that it's best to store tracking information in cookies and the actual client or session data on the server. Here's the original Netscape cookie spec: http://home.netscape.com/newsref/std/cookie_spec.html More stuff inline below... HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-46 68 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: Mike [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 11:56 AM Subject: well-baked cookies I'm trying to push cfcookie's usage to the limit, by storing and reading lots of user information on it. Can someone share some thoughts on the following? 1. is it possible to store complexed variables (i.e - arrays an d/or structure) into a cookie? Yes, as long as it's text. is that adviseable? I don't think so... 2. is it possible to store XML or WDDX packets into Cookie? Yes - xml is only text. However, you would need to URL encode the XML and you are limited to only 4k. 3. is it possible to store encrypted values in a cfcookie, i.e: cfcookie name=foo value=#Encrypt(foo,123)# and then re-use the ordinary within a cfquery Yes... SELECT from . WHERE userpassword='#Decrypt(Cookie. foo,123)#' does this takes noticable time and process usage? I mean - much more then NOT encrypting? I doubt that the process time is appreciable... -M. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript/coldfusion--- Can you do this?
Here is an example of what you can do with WDDX http://hotwired.lycos.com/webmonkey/99/15/demo/index.html The article for that is located here. http://hotwired.lycos.com/webmonkey/99/15/index3a.html __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:44 PM To: CF-Talk Subject: RE: javascript/coldfusion--- Can you do this? Steve- thank you for the direction, it looks i can make it work, i think. but how do a pass the variable through a cflocation. do i just append like any other variable or does it have to be in a form? -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 5:17 PM To: CF-Talk Subject: RE: javascript/coldfusion--- Can you do this? Look into WDDX, CFML2JS will create an array of all of your values for you. Something like script cfwddx action=cfml2js input=qryName toplevelvariable=variablename /script That will result in script variablename = new array stuff /script You'll need to include wddx.js which is in your cfide/scripts folder. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 4:55 PM To: CF-Talk Subject: javascript/coldfusion--- Can you do this? i have an application that saves a listing entry. this entry can have multiple number of addresses. so i have a child window that pops up. this window then calls addresspost.cfm, this is the code you will find below, and with this page i save the address and proceed to get all of the address that belong to the specific listing_id. once i get all of the addresses i place them into an array. but now i'm trying to pass that array into javascript and don't know how. Please help SomeOne Thank you Metzy cfparam name=txtListing_Id default= cfparam name=selArea default= cfparam name=txtStreet1 default= cfparam name=txtStreet2 default= cfparam name=txtCity default= cfparam name=selState default= cfparam name=txtZip default= cfparam name=txtPhone default= cfparam name=txtFax default= cfparam name=txtEmail default= cfparam name=txtHours default= cfparam name=txtDescription default= cfparam name=txtKeywords default= cfparam name=chkActive default=off cfoutput cfquery name=address datasource=#dsn.listings_v2# INSERT INTO address (Listing_Id, area_Id, street1, street2, city, state, zipCode, phone, fax, email, hours, description, keywords, active) VALUES (#txtListing_Id#, '#selArea#', '#txtStreet1#', '#txtStreet2#', '#txtCity#', '#selState#', '#txtZip#', '#txtPhone#', '#txtFax#', '#txtEmail#', '#txtHours#', '#txtDescription#', '#txtKeywords#', '#chkActive#') /cfquery cfquery name=addressArray datasource=#dsn.listings_v2# dbtype=ODBC SELECT address_ID, street1 FROM address WHERE listing_id = #txtListing_id# /cfquery /cfoutput cfif addressArray.recordCount GT 0 cfset arrValue = ArrayNew(1) cfset arrLabel = ArrayNew(1) cfloop index=i from=1 to=#addressArray.recordcount# cfset arrValue = AddressArray.address_id cfset arrLabel = 'addressArra.street' /cfloop HTML HEAD META NAME=ROBOTS CONTENT=NONE SCRIPT LANGUAGE=JavaScript !-- function refreshProduct() { // Rebuilds the catalog list for the product page. // It is built here so that it can be returned to the product page and reloaded window.opener.modifyAddress(#arrLabel#, #arrValue#); window.close(); } //-- /SCRIPT /HEAD BODY onload=javascript: refreshProduct(); /body /HTML cfelse HTML HEAD META NAME=ROBOTS CONTENT=NONE SCRIPT LANGUAGE=JavaScript !-- function refreshProduct() { // Rebuilds the catalog list for the product page. // It is built here so that it can be returned to the product page and reloaded var arrValue; var arrLabel; window.opener.modifyaddress(arrLabel, 0); window.close(); } //-- /SCRIPT /HEAD BODY onload=javascript: refreshProduct(); /body /HTML /cfif - Metzy Matinez __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Slashes in the URL
Hey, thanks a lot that works great! I actually re-checked the script engine and removed the execute as all I really needed was for IIS to not look for the file. I would never have figured that one out, thanks again! Look in your IIS manager, right click on Default Web Site, go into the Home directory tab, then click on the Configuration button. Next find .cfm and double click on it, you'll see the 2 checkboxes at the bottom of that form. Other then that, you need to set the folder that you want this enabled in to allow scripts executables to be run. I don't advise setting your entire folder this way, since it does allow executables to be run, (ie. If you have any .exe's for download, they won't download, they'll execute on the server) __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:22 PM To: CF-Talk Subject: Re: Slashes in the URL Say.. that sounds close to what I need. Where are those checkboxes? You have to uncheck Script Engine, and Ensure File Exists. I am using (abusing) IIS 5.0 TIA! I actually made a custom tag for this, do you already have IIS setup so you can use index.cfm/id/1 ? You have to uncheck Script Engine, and Ensure File Exists. Then you have to set your folder to allow executables, since it will handle them that way using slashes. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Advanced Coldfusion - Generating Preview Pages ???
Here's what I do: After the form is submitted, store all of the variables in a session scope. Then output the HTML page that displays those session variables. That page has a confirm and edit buttons. Press confirm and the session variables are written to the database. Press edit and you get the form page again with the variables written in the form values. Resubmit, the changed variables get updated in the session scope and you can confirm or edit again. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 -Original Message- From: Ian Vaughan [SMTP:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 5:48 AM To: CF-Talk Subject: Advanced Coldfusion - Generating Preview Pages ??? I am using standard html forms in a browser to allow admin users to add/modify entries to an oracle database via Coldfusion. When the form is submitted these changes are then sent to the relevant fields in the database table. And a seperate coldfusion template displays the output to end web users. At present this is all done automatically when the user submits the form. What I would like to do, is offer the administration user (who adds/modifies stories) a preview option of how the page would look in the web browser, before they actually submit their details to the database, so they have an idea of how the information they have just entered in the relevant form fields would look when generated from coldfusion and viewed by an end user in their browser. Is this process viable with Coldfusion , if so have any list members achieved anything like this? Ian __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript/coldfusion--- Can you do this?
thanks steve -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:57 PM To: CF-Talk Subject: RE: javascript/coldfusion--- Can you do this? Here is an example of what you can do with WDDX http://hotwired.lycos.com/webmonkey/99/15/demo/index.html The article for that is located here. http://hotwired.lycos.com/webmonkey/99/15/index3a.html __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:44 PM To: CF-Talk Subject: RE: javascript/coldfusion--- Can you do this? Steve- thank you for the direction, it looks i can make it work, i think. but how do a pass the variable through a cflocation. do i just append like any other variable or does it have to be in a form? -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 5:17 PM To: CF-Talk Subject: RE: javascript/coldfusion--- Can you do this? Look into WDDX, CFML2JS will create an array of all of your values for you. Something like script cfwddx action=cfml2js input=qryName toplevelvariable=variablename /script That will result in script variablename = new array stuff /script You'll need to include wddx.js which is in your cfide/scripts folder. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Metzy Martinez [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 4:55 PM To: CF-Talk Subject: javascript/coldfusion--- Can you do this? i have an application that saves a listing entry. this entry can have multiple number of addresses. so i have a child window that pops up. this window then calls addresspost.cfm, this is the code you will find below, and with this page i save the address and proceed to get all of the address that belong to the specific listing_id. once i get all of the addresses i place them into an array. but now i'm trying to pass that array into javascript and don't know how. Please help SomeOne Thank you Metzy cfparam name=txtListing_Id default= cfparam name=selArea default= cfparam name=txtStreet1 default= cfparam name=txtStreet2 default= cfparam name=txtCity default= cfparam name=selState default= cfparam name=txtZip default= cfparam name=txtPhone default= cfparam name=txtFax default= cfparam name=txtEmail default= cfparam name=txtHours default= cfparam name=txtDescription default= cfparam name=txtKeywords default= cfparam name=chkActive default=off cfoutput cfquery name=address datasource=#dsn.listings_v2# INSERT INTO address (Listing_Id, area_Id, street1, street2, city, state, zipCode, phone, fax, email, hours, description, keywords, active) VALUES (#txtListing_Id#, '#selArea#', '#txtStreet1#', '#txtStreet2#', '#txtCity#', '#selState#', '#txtZip#', '#txtPhone#', '#txtFax#', '#txtEmail#', '#txtHours#', '#txtDescription#', '#txtKeywords#', '#chkActive#') /cfquery cfquery name=addressArray datasource=#dsn.listings_v2# dbtype=ODBC SELECT address_ID, street1 FROM address WHERE listing_id = #txtListing_id# /cfquery /cfoutput cfif addressArray.recordCount GT 0 cfset arrValue = ArrayNew(1) cfset arrLabel = ArrayNew(1) cfloop index=i from=1 to=#addressArray.recordcount# cfset arrValue = AddressArray.address_id cfset arrLabel = 'addressArra.street' /cfloop HTML HEAD META NAME=ROBOTS CONTENT=NONE SCRIPT LANGUAGE=JavaScript !-- function refreshProduct() { // Rebuilds the catalog list for the product page. // It is built here so that it can be returned to the product page and reloaded window.opener.modifyAddress(#arrLabel#, #arrValue#); window.close(); } //-- /SCRIPT /HEAD BODY onload=javascript: refreshProduct(); /body /HTML cfelse HTML HEAD META NAME=ROBOTS CONTENT=NONE SCRIPT LANGUAGE=JavaScript !-- function refreshProduct() { // Rebuilds the catalog list for the product page. // It is built here so that it can be returned to the product page and reloaded var arrValue; var arrLabel; window.opener.modifyaddress(arrLabel, 0); window.close(); } //-- /SCRIPT /HEAD BODY onload=javascript: refreshProduct(); /body /HTML /cfif - Metzy Matinez __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slashes in the URL
Looks like I've been doing it the hard way :) __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:00 PM To: CF-Talk Subject: Re: Slashes in the URL Hey, thanks a lot that works great! I actually re-checked the script engine and removed the execute as all I really needed was for IIS to not look for the file. I would never have figured that one out, thanks again! Look in your IIS manager, right click on Default Web Site, go into the Home directory tab, then click on the Configuration button. Next find .cfm and double click on it, you'll see the 2 checkboxes at the bottom of that form. Other then that, you need to set the folder that you want this enabled in to allow scripts executables to be run. I don't advise setting your entire folder this way, since it does allow executables to be run, (ie. If you have any .exe's for download, they won't download, they'll execute on the server) __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:22 PM To: CF-Talk Subject: Re: Slashes in the URL Say.. that sounds close to what I need. Where are those checkboxes? You have to uncheck Script Engine, and Ensure File Exists. I am using (abusing) IIS 5.0 TIA! I actually made a custom tag for this, do you already have IIS setup so you can use index.cfm/id/1 ? You have to uncheck Script Engine, and Ensure File Exists. Then you have to set your folder to allow executables, since it will handle them that way using slashes. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slashes in the URL
I made a UDF for all you CF 5'ers called path2url() It works either way, with slashes in the URL, or with ?foo=1 Here's how to use it. Put this at the top of your page, or in application.cfm cfscriptpath2url();/cfscript Here's how to output all of your URL variables to make sure it worked ;) cfloop collection=#URL# item=i cfoutputURL.#i# = #Evaluate(URL. i)#/cfoutputbr /cfloop And here's the UDF cfscript function path2url(){ //first get everything after the script file qstring = replace(CGI.path_info,CGI.script_name,); //next loop through each variable and set them accordingly for(i=1; listlen(qstring,/) GTE i; i=i+1){ if(i MOD 2){ qstringvariable = listgetat(qstring,i,/); }else{ URL.#qstringvariable# = listgetat(qstring,i,/); } } } /cfscript __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:00 PM To: CF-Talk Subject: Re: Slashes in the URL Hey, thanks a lot that works great! I actually re-checked the script engine and removed the execute as all I really needed was for IIS to not look for the file. I would never have figured that one out, thanks again! Look in your IIS manager, right click on Default Web Site, go into the Home directory tab, then click on the Configuration button. Next find .cfm and double click on it, you'll see the 2 checkboxes at the bottom of that form. Other then that, you need to set the folder that you want this enabled in to allow scripts executables to be run. I don't advise setting your entire folder this way, since it does allow executables to be run, (ie. If you have any .exe's for download, they won't download, they'll execute on the server) __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:22 PM To: CF-Talk Subject: Re: Slashes in the URL Say.. that sounds close to what I need. Where are those checkboxes? You have to uncheck Script Engine, and Ensure File Exists. I am using (abusing) IIS 5.0 TIA! I actually made a custom tag for this, do you already have IIS setup so you can use index.cfm/id/1 ? You have to uncheck Script Engine, and Ensure File Exists. Then you have to set your folder to allow executables, since it will handle them that way using slashes. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Enterprise Strength Events Calendar
Any recommendations on a CF driven enterprise strength events calendar? Thanks, Dave === David R Hannum Ohio University Web Analyst/Programmer (740) 597-2524 [EMAIL PROTECTED] If your wife is having fun and you're not, you're still having a lot more fun than if you're having fun and she's not!' - Red Green __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Word Com Problems
Hi, I'm trying to generate an events calendar in Word via CF. I've tried two solutions, both of which have problems: 1. The first used CFTRY CFCATCH etc from cfcomet.com to test for a Word instance and then launch a new if necessary. The code works, but the problem with this one is that the winword.exes accumulate and can't be shut down except by rebooting(Debug is grayed out). It seems that every third or fourth call would start a new winword.exe. 2. Writing a Server variable. The code is from Ben Forta's Advanced CF Development. It successfully runs the first time and shuts down the process, but any subsequent attempts get this: Error building an argument list for: VISIBLE COM error 0x8001010E. The application called an interface that was marshalled for a different thread. I tried changing the scope to session variables with the same result: one success then failure. Any ideas? Code below Thanks, Doug Jordon Solution 1: !--- Try to connect to the Word application object --- CFTRY !--- If it exists, connect to it --- CFOBJECT ACTION=CONNECT CLASS=Word.Application NAME=objWord TYPE=COM CFCATCH !--- The object doesn't exist, so create it --- CFOBJECT ACTION=CREATE CLASS=Word.Application NAME=objWord TYPE=COM /CFCATCH /CFTRY Solution 2: !--- See if the Server object exists --- cfif not isdefined(Server.objWord) !--- Create the object --- CFOBJECT ACTION=CREATE CLASS=Word.Application NAME=objWord TYPE=COM !--- Exclusive lock in the Server scope --- cflock type=Exclusive scope=SERVER timeout=10 throwontimeout=Yes !--- Pass the COM reference to the Server scope --- cfset Server.objWord = objWord /cflock /cfif !--- Read-only lock in the Server scope --- cflock type=READONLY scope=SERVER timeout=10 throwontimeout=Yes !--- pointer to the original Server variable --- cfset objWord = Server.objWord /cflock __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javascript/coldfusion--- Can you do this?
i was able to pass the variable through cflocation. and once i got it to the proper page a desiarilezed the value but i'm still having the same problem. And that is that coldfusion wants to place the default html tags. Here is my code and my View Source. View Source* html head titleUntitled Document/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body bgcolor=#FF text=#00 /body /html = why does it do this. HTML HEAD META NAME=ROBOTS CONTENT=NONE SCRIPT LANGUAGE=JavaScript !-- function refreshProduct() { // Rebuilds the addess list for the listing page. // It is built here so that it can be returned to the listing page and reloaded var arrValue = new Array(5); var arrLabel = new Array(5); arrValue[1] = 2954; arrLabel[1] = '213'; arrValue[2] = 2955; arrLabel[2] = '213'; arrValue[3] = 2956; arrLabel[3] = '213'; arrValue[4] = 2957; arrLabel[4] = '213'; arrValue[5] = 2958; arrLabel[5] = '213'; window.opener.modifyCatalog(arrLabel, arrValue); var arrValue = new Array(5); var arrLabel = new Array(5); arrValue[1] = 2954; arrLabel[1] = '213'; arrValue[2] = 2955; arrLabel[2] = '213'; arrValue[3] = 2956; arrLabel[3] = '213'; arrValue[4] = 2957; arrLabel[4] = '213'; arrValue[5] = 2958; arrLabel[5] = '213'; window.opener.modifyCatalog(arrLabel, arrValue); var arrValue = new Array(5); var arrLabel = new Array(5); arrValue[1] = 2954; arrLabel[1] = '213'; arrValue[2] = 2955; arrLabel[2] = '213'; arrValue[3] = 2956; arrLabel[3] = '213'; arrValue[4] = 2957; arrLabel[4] = '213'; arrValue[5] = 2958; arrLabel[5] = '213'; window.opener.modifyCatalog(arrLabel, arrValue); var arrValue = new Array(5); var arrLabel = new Array(5); arrValue[1] = 2954; arrLabel[1] = '213'; arrValue[2] = 2955; arrLabel[2] = '213'; arrValue[3] = 2956; arrLabel[3] = '213'; arrValue[4] = 2957; arrLabel[4] = '213'; arrValue[5] = 2958; arrLabel[5] = '213'; window.opener.modifyCatalog(arrLabel, arrValue); var arrValue = new Array(5); var arrLabel = new Array(5); arrValue[1] = 2954; arrLabel[1] = '213'; arrValue[2] = 2955; arrLabel[2] = '213'; arrValue[3] = 2956; arrLabel[3] = '213'; arrValue[4] = 2957; arrLabel[4] = '213'; arrValue[5] = 2958; arrLabel[5] = '213'; window.opener.modifyCatalog(arrLabel, arrValue); window.close(); } //-- /SCRIPT /HEAD BODY onload=javascript: refreshProduct(); /body /HTML **Code** HTML HEAD META NAME=ROBOTS CONTENT=NONE SCRIPT LANGUAGE=JavaScript !-- function refreshProduct() { // Rebuilds the addess list for the listing page. // It is built here so that it can be returned to the listing page and
Re: Word Com Problems
Have you explored creating an RTF file in lieu of a Word document? It's much less resource intensive and won't crash the server like spawning winword.exe can. Just a thought. Dave - Original Message - From: Douglas Jordon [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 1:30 PM Subject: Word Com Problems Hi, I'm trying to generate an events calendar in Word via CF. I've tried two solutions, both of which have problems: 1. The first used CFTRY CFCATCH etc from cfcomet.com to test for a Word instance and then launch a new if necessary. The code works, but the problem with this one is that the winword.exes accumulate and can't be shut down except by rebooting(Debug is grayed out). It seems that every third or fourth call would start a new winword.exe. 2. Writing a Server variable. The code is from Ben Forta's Advanced CF Development. It successfully runs the first time and shuts down the process, but any subsequent attempts get this: Error building an argument list for: VISIBLE COM error 0x8001010E. The application called an interface that was marshalled for a different thread. I tried changing the scope to session variables with the same result: one success then failure. Any ideas? Code below Thanks, Doug Jordon Solution 1: !--- Try to connect to the Word application object --- CFTRY !--- If it exists, connect to it --- CFOBJECT ACTION=CONNECT CLASS=Word.Application NAME=objWord TYPE=COM CFCATCH !--- The object doesn't exist, so create it --- CFOBJECT ACTION=CREATE CLASS=Word.Application NAME=objWord TYPE=COM /CFCATCH /CFTRY Solution 2: !--- See if the Server object exists --- cfif not isdefined(Server.objWord) !--- Create the object --- CFOBJECT ACTION=CREATE CLASS=Word.Application NAME=objWord TYPE=COM !--- Exclusive lock in the Server scope --- cflock type=Exclusive scope=SERVER timeout=10 throwontimeout=Yes !--- Pass the COM reference to the Server scope --- cfset Server.objWord = objWord /cflock /cfif !--- Read-only lock in the Server scope --- cflock type=READONLY scope=SERVER timeout=10 throwontimeout=Yes !--- pointer to the original Server variable --- cfset objWord = Server.objWord /cflock __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Update Query not working
I've got an Access table where the unique ID is a UID and I'm trying to run an update query on it, for example: UPDATE #Request.userTbl# SET email = cfqueryparam value=#attributes.email# cfsqltype=CF_SQL_VARCHAR, first_name = cfqueryparam value=#attributes.first_name# cfsqltype=CF_SQL_VARCHAR, last_name = cfqueryparam value=#attributes.last_name# cfsqltype=CF_SQL_VARCHAR WHERE user_id = cfqueryparam value=#Request.user_id# cfsqltype=CF_SQL_LONGVARCHAR If I take the WHERE clause out, the update runs (of course, it runs on every row, but it does run). With the WHERE clause, the query doesn't update any rows (I'm not getting any errors). However, if I do a SELECT query on that table: SELECT * FROM #Request.userTbl# WHERE user_id = cfqueryparam value=#Request.user_id# cfsqltype=CF_SQL_LONGVARCHAR (I'm using SELECT * just for this test query), it runs and returns the proper record. I thought maybe it was the cfsqltype in the query param, but if that were the case, the SELECT query wouldn't run, right? Any ideas? Thanks! Scott -- Scott Brady http://www.scottbrady.net/ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL IN question
I am trying to determine if an integer passed to a stored procedure is in a comma-seperated list. The column is a varchar datatype to allow for the data to be entered in like this : 1,2,3,4,5. So if a Partner ID of 4 is passed into the stored procedure, rows with 4 or 1,4 or 1,4,5 etc. in the PartnerID column will be returned. The problem is that only rows that exactly match what has been passed into the stored procedure are being returned. So in the above example only the row with 4 in the PartnerID column will be returned. Any row with multiple comma-seperated values are being ignored. Am I doing this correctly Is there a better way to do this? STORED PROCEDURE CODE: CREATE PROCEDURE procedure_Name @PID int AS SELECT Title, DateStart, moreFields FROM Events WHERE CONVERT(varchar,@PID) IN (PartnerID) GO STORED PROCEDURE CALL: cfstoredproc procedure=procedure_Name datasource=#DSN# cfprocparam type=In dbvarname=@PID value=#PartnerID# cfsqltype=CF_SQL_INTEGER cfprocresult name=PartnerData /cfstoredproc BTW, I had to use the CONVERT function in the stored procedure because a datatype mismatch error was being returned without it. Thank you in advance for any help you can give. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql 7 MDAC
due to forces beyond my control, we are stuck with ODBC. I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC driver, but the same query still pegs the CF server to 100% CPU. I have pasted the query into it's own CF template, and I'm calling it directly - there is nothing in application.cfm. This is crazy, all this time I've heard people with this dreaded issue, never thinking it would happen to one of my boxes, and now it has. The weird thing is, I've got larger, much more complex queries that are running just fine. I've done a lot of snooping around the macromedia forums, and found a few tips regarding mail spool files, and other things - nothing has helped. I doubt anyone has the definitive answer, otherwise there wouldn't be so many posts in the forum about this and it would have been fixed a few releases back when it was first discovered. I am just at my last resorts here and was hoping that SOMEBODY can offer a fix. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:40 AM To: CF-Talk Subject: RE: sql 7 MDAC Have you tried using OLE DB or a Dynamic query with a connection string? __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:27 PM To: CF-Talk Subject: sql 7 MDAC Hi there, has anyone researched which ODBC driver is most stable with CF 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and this query will crash CF to 100% CPU every time I run it: CFQUERY datasource=#request.mainDSN# Name=ViewAssignment SELECT ASSIGNMENTS.num_contentid AS contentid, ASSIGNMENTS.dat_start AS dat_start, ASSIGNMENTS.dat_due AS dat_due, ASSIGNMENTS.bit_complete AS bit_complete, ASSIGNMENTS.txt_description AS txt_description, CONTENT.contenttitle AS title, CONTENT.editable AS editable FROM ASSIGNMENTS, CONTENT WHERE ASSIGNMENTS.num_contentid = CONTENT.contentid AND ASSIGNMENTS.num_contentid = #attributes.contentid# ORDER BY ASSIGNMENTS.dat_due /CFQUERY I'm not exactly sure which MDAC is installed. Is it advisable to update to the most recent MDAC even though we're not running SQL 2000 yet? I noticed on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/ Thanks for any of your help. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slashes in the URL
If your interested in a path2url custom tag. You can download it here: http://www.atnetsolutions.com/software/path2url.zip __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 1:00 PM To: CF-Talk Subject: Re: Slashes in the URL Hey, thanks a lot that works great! I actually re-checked the script engine and removed the execute as all I really needed was for IIS to not look for the file. I would never have figured that one out, thanks again! Look in your IIS manager, right click on Default Web Site, go into the Home directory tab, then click on the Configuration button. Next find .cfm and double click on it, you'll see the 2 checkboxes at the bottom of that form. Other then that, you need to set the folder that you want this enabled in to allow scripts executables to be run. I don't advise setting your entire folder this way, since it does allow executables to be run, (ie. If you have any .exe's for download, they won't download, they'll execute on the server) __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:22 PM To: CF-Talk Subject: Re: Slashes in the URL Say.. that sounds close to what I need. Where are those checkboxes? You have to uncheck Script Engine, and Ensure File Exists. I am using (abusing) IIS 5.0 TIA! I actually made a custom tag for this, do you already have IIS setup so you can use index.cfm/id/1 ? You have to uncheck Script Engine, and Ensure File Exists. Then you have to set your folder to allow executables, since it will handle them that way using slashes. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql 7 MDAC
For whatever its worth, try checking your indexes and their names. We had some weird behavior that was fixed by renaming some of the index files. At 01:03 PM 1/22/02 -0600, you wrote: due to forces beyond my control, we are stuck with ODBC. I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC driver, but the same query still pegs the CF server to 100% CPU. I have pasted the query into it's own CF template, and I'm calling it directly - there is nothing in application.cfm. This is crazy, all this time I've heard people with this dreaded issue, never thinking it would happen to one of my boxes, and now it has. The weird thing is, I've got larger, much more complex queries that are running just fine. I've done a lot of snooping around the macromedia forums, and found a few tips regarding mail spool files, and other things - nothing has helped. I doubt anyone has the definitive answer, otherwise there wouldn't be so many posts in the forum about this and it would have been fixed a few releases back when it was first discovered. I am just at my last resorts here and was hoping that SOMEBODY can offer a fix. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:40 AM To: CF-Talk Subject: RE: sql 7 MDAC Have you tried using OLE DB or a Dynamic query with a connection string? __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:27 PM To: CF-Talk Subject: sql 7 MDAC Hi there, has anyone researched which ODBC driver is most stable with CF 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and this query will crash CF to 100% CPU every time I run it: CFQUERY datasource=#request.mainDSN# Name=ViewAssignment SELECT ASSIGNMENTS.num_contentid AS contentid, ASSIGNMENTS.dat_start AS dat_start, ASSIGNMENTS.dat_due AS dat_due, ASSIGNMENTS.bit_complete AS bit_complete, ASSIGNMENTS.txt_description AS txt_description, CONTENT.contenttitle AS title, CONTENT.editable AS editable FROM ASSIGNMENTS, CONTENT WHERE ASSIGNMENTS.num_contentid = CONTENT.contentid AND ASSIGNMENTS.num_contentid = #attributes.contentid# ORDER BY ASSIGNMENTS.dat_due /CFQUERY I'm not exactly sure which MDAC is installed. Is it advisable to update to the most recent MDAC even though we're not running SQL 2000 yet? I noticed on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/ Thanks for any of your help. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql 7 MDAC
Adam, How big is the query. I noticed it's from a view - are other queries from views giving you any problems? mark -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:03 AM To: CF-Talk Subject: RE: sql 7 MDAC due to forces beyond my control, we are stuck with ODBC. I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC driver, but the same query still pegs the CF server to 100% CPU. I have pasted the query into it's own CF template, and I'm calling it directly - there is nothing in application.cfm. This is crazy, all this time I've heard people with this dreaded issue, never thinking it would happen to one of my boxes, and now it has. The weird thing is, I've got larger, much more complex queries that are running just fine. I've done a lot of snooping around the macromedia forums, and found a few tips regarding mail spool files, and other things - nothing has helped. I doubt anyone has the definitive answer, otherwise there wouldn't be so many posts in the forum about this and it would have been fixed a few releases back when it was first discovered. I am just at my last resorts here and was hoping that SOMEBODY can offer a fix. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:40 AM To: CF-Talk Subject: RE: sql 7 MDAC Have you tried using OLE DB or a Dynamic query with a connection string? __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:27 PM To: CF-Talk Subject: sql 7 MDAC Hi there, has anyone researched which ODBC driver is most stable with CF 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and this query will crash CF to 100% CPU every time I run it: CFQUERY datasource=#request.mainDSN# Name=ViewAssignment SELECT ASSIGNMENTS.num_contentid AS contentid, ASSIGNMENTS.dat_start AS dat_start, ASSIGNMENTS.dat_due AS dat_due, ASSIGNMENTS.bit_complete AS bit_complete, ASSIGNMENTS.txt_description AS txt_description, CONTENT.contenttitle AS title, CONTENT.editable AS editable FROM ASSIGNMENTS, CONTENT WHERE ASSIGNMENTS.num_contentid = CONTENT.contentid AND ASSIGNMENTS.num_contentid = #attributes.contentid# ORDER BY ASSIGNMENTS.dat_due /CFQUERY I'm not exactly sure which MDAC is installed. Is it advisable to update to the most recent MDAC even though we're not running SQL 2000 yet? I noticed on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/ Thanks for any of your help. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Sessions Character max
Is there a limit to how many characters a session variable can be. Or does it just depend on how much I want to put in it vs. traffic load, speed, and what not thanks __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Full-Text Search w/ Verity? (Not Working!)
Thanks for the suggestion, Chuck. Unfortunately, I need to accomplish this programmatically, from a web interface. Any other ideas? Thanks, Christian -Original Message- From: Chuck Rodgers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:23 PM To: CF-Talk Subject: Re: Full-Text Search w/ Verity? (Not Working!) If you have Cold Fusion Studio or HomeSite you can use the Search functions there to accomplish this. Chuck Rodgers At 12:22 PM 1/22/02 -0500, you wrote: Folks: I need to be able to search our entire web server and find specific strings in .cfm, .html and .cgi files. I have attempted to user Verity to accomplish this, but Verity doesn't appear to index ALL of the ASCII data in a .cfm file. (e.g. Doesn't appear to be a Full-Text search.) Can anyone suggest an efficient method to search the entire ASCII contents of a given list of .cfm, .html and .cgi files? In a nutshell, I need to find how many times cfset myVar = 123 appears in the .cfm files on our web server. Thanks! Christian N. Abad ColdFusion Web Developer __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: well-baked cookies
One not on the encrypted thing. Do the decrypt OUTSIDE of the query (ie, set a variable to the unecrypted string and use that in the query), otherwise evil things happen. cfcookie name=foo value=#Encrypt(foo,123)# and then re-use the ordinary within a cfquery SELECT from . WHERE userpassword='#Decrypt(Cookie.foo,123)#' does this takes noticable time and process usage? I mean - much more then NOT encrypting? -M. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql 7 MDAC
I wish I could offer more definitive. I'm just wondering how many records are being pulled out in this recordset. I've done a few joins the wrong way -- resulting in a ton of records pouring out into the recordset. That could be an answer. Probably isn't. Worth taking a look, though. EC -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 2:03 PM To: CF-Talk Subject: RE: sql 7 MDAC due to forces beyond my control, we are stuck with ODBC. I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC driver, but the same query still pegs the CF server to 100% CPU. I have pasted the query into it's own CF template, and I'm calling it directly - there is nothing in application.cfm. This is crazy, all this time I've heard people with this dreaded issue, never thinking it would happen to one of my boxes, and now it has. The weird thing is, I've got larger, much more complex queries that are running just fine. I've done a lot of snooping around the macromedia forums, and found a few tips regarding mail spool files, and other things - nothing has helped. I doubt anyone has the definitive answer, otherwise there wouldn't be so many posts in the forum about this and it would have been fixed a few releases back when it was first discovered. I am just at my last resorts here and was hoping that SOMEBODY can offer a fix. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:40 AM To: CF-Talk Subject: RE: sql 7 MDAC Have you tried using OLE DB or a Dynamic query with a connection string? __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:27 PM To: CF-Talk Subject: sql 7 MDAC Hi there, has anyone researched which ODBC driver is most stable with CF 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and this query will crash CF to 100% CPU every time I run it: CFQUERY datasource=#request.mainDSN# Name=ViewAssignment SELECT ASSIGNMENTS.num_contentid AS contentid, ASSIGNMENTS.dat_start AS dat_start, ASSIGNMENTS.dat_due AS dat_due, ASSIGNMENTS.bit_complete AS bit_complete, ASSIGNMENTS.txt_description AS txt_description, CONTENT.contenttitle AS title, CONTENT.editable AS editable FROM ASSIGNMENTS, CONTENT WHERE ASSIGNMENTS.num_contentid = CONTENT.contentid AND ASSIGNMENTS.num_contentid = #attributes.contentid# ORDER BY ASSIGNMENTS.dat_due /CFQUERY I'm not exactly sure which MDAC is installed. Is it advisable to update to the most recent MDAC even though we're not running SQL 2000 yet? I noticed on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/ Thanks for any of your help. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql 7 MDAC
In the last few minutes, I was able to actually narrow the issue down to the exact column, instead of the query. The exact query below works flawlessly when I omit the ASSIGNMENTS.txt_description field from the query. The data type in SQLserver is ntext. As soon as I add that field to the query though, the CPU goes to poop again and won't come down until I restart CF. Please don't tell me I'm going to have to store all of my text columns in individual files. Has anyone else had issues with text or ntext data types? The max size of any of the values is nowhere near 1k in that column, so it shouldn't be a bandwidth/memory issue. The server is pretty hefty on the resources too. Adam. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 3:13 PM To: CF-Talk Subject: RE: sql 7 MDAC Adam, How big is the query. I noticed it's from a view - are other queries from views giving you any problems? mark -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:03 AM To: CF-Talk Subject: RE: sql 7 MDAC due to forces beyond my control, we are stuck with ODBC. I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC driver, but the same query still pegs the CF server to 100% CPU. I have pasted the query into it's own CF template, and I'm calling it directly - there is nothing in application.cfm. This is crazy, all this time I've heard people with this dreaded issue, never thinking it would happen to one of my boxes, and now it has. The weird thing is, I've got larger, much more complex queries that are running just fine. I've done a lot of snooping around the macromedia forums, and found a few tips regarding mail spool files, and other things - nothing has helped. I doubt anyone has the definitive answer, otherwise there wouldn't be so many posts in the forum about this and it would have been fixed a few releases back when it was first discovered. I am just at my last resorts here and was hoping that SOMEBODY can offer a fix. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:40 AM To: CF-Talk Subject: RE: sql 7 MDAC Have you tried using OLE DB or a Dynamic query with a connection string? __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:27 PM To: CF-Talk Subject: sql 7 MDAC Hi there, has anyone researched which ODBC driver is most stable with CF 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and this query will crash CF to 100% CPU every time I run it: CFQUERY datasource=#request.mainDSN# Name=ViewAssignment SELECT ASSIGNMENTS.num_contentid AS contentid, ASSIGNMENTS.dat_start AS dat_start, ASSIGNMENTS.dat_due AS dat_due, ASSIGNMENTS.bit_complete AS bit_complete, ASSIGNMENTS.txt_description AS txt_description, CONTENT.contenttitle AS title, CONTENT.editable AS editable FROM ASSIGNMENTS, CONTENT WHERE ASSIGNMENTS.num_contentid = CONTENT.contentid AND ASSIGNMENTS.num_contentid = #attributes.contentid# ORDER BY ASSIGNMENTS.dat_due /CFQUERY I'm not exactly sure which MDAC is installed. Is it advisable to update to the most recent MDAC even though we're not running SQL 2000 yet? I noticed on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/ Thanks for any of your help. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: sql 7 MDAC
If it helps...the MDAC bug that would cause the 100% CPU spike didn't matter when it came to query size or complexity. It would just do it for some queries and not others (we're talkin SELECT * FROM TABLE when there's 10 records). I never found any kind of pattern to it. I don't remeber ever hearing of it happening with SQL Server, just Access. Bryan Stevenson VP Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Original Message - From: Cantrell, Adam [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, January 22, 2002 11:03 AM Subject: RE: sql 7 MDAC due to forces beyond my control, we are stuck with ODBC. I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC driver, but the same query still pegs the CF server to 100% CPU. I have pasted the query into it's own CF template, and I'm calling it directly - there is nothing in application.cfm. This is crazy, all this time I've heard people with this dreaded issue, never thinking it would happen to one of my boxes, and now it has. The weird thing is, I've got larger, much more complex queries that are running just fine. I've done a lot of snooping around the macromedia forums, and found a few tips regarding mail spool files, and other things - nothing has helped. I doubt anyone has the definitive answer, otherwise there wouldn't be so many posts in the forum about this and it would have been fixed a few releases back when it was first discovered. I am just at my last resorts here and was hoping that SOMEBODY can offer a fix. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:40 AM To: CF-Talk Subject: RE: sql 7 MDAC Have you tried using OLE DB or a Dynamic query with a connection string? __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:27 PM To: CF-Talk Subject: sql 7 MDAC Hi there, has anyone researched which ODBC driver is most stable with CF 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and this query will crash CF to 100% CPU every time I run it: CFQUERY datasource=#request.mainDSN# Name=ViewAssignment SELECT ASSIGNMENTS.num_contentid AS contentid, ASSIGNMENTS.dat_start AS dat_start, ASSIGNMENTS.dat_due AS dat_due, ASSIGNMENTS.bit_complete AS bit_complete, ASSIGNMENTS.txt_description AS txt_description, CONTENT.contenttitle AS title, CONTENT.editable AS editable FROM ASSIGNMENTS, CONTENT WHERE ASSIGNMENTS.num_contentid = CONTENT.contentid AND ASSIGNMENTS.num_contentid = #attributes.contentid# ORDER BY ASSIGNMENTS.dat_due /CFQUERY I'm not exactly sure which MDAC is installed. Is it advisable to update to the most recent MDAC even though we're not running SQL 2000 yet? I noticed on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/ Thanks for any of your help. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql 7 MDAC
You might try adjusting the long text buffers in CF Admin or blockfactors on that query to more closely control the flow of data. Just a guess... -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:37 AM To: CF-Talk Subject: RE: sql 7 MDAC In the last few minutes, I was able to actually narrow the issue down to the exact column, instead of the query. The exact query below works flawlessly when I omit the ASSIGNMENTS.txt_description field from the query. The data type in SQLserver is ntext. As soon as I add that field to the query though, the CPU goes to poop again and won't come down until I restart CF. Please don't tell me I'm going to have to store all of my text columns in individual files. Has anyone else had issues with text or ntext data types? The max size of any of the values is nowhere near 1k in that column, so it shouldn't be a bandwidth/memory issue. The server is pretty hefty on the resources too. Adam. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 3:13 PM To: CF-Talk Subject: RE: sql 7 MDAC Adam, How big is the query. I noticed it's from a view - are other queries from views giving you any problems? mark -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:03 AM To: CF-Talk Subject: RE: sql 7 MDAC due to forces beyond my control, we are stuck with ODBC. I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC driver, but the same query still pegs the CF server to 100% CPU. I have pasted the query into it's own CF template, and I'm calling it directly - there is nothing in application.cfm. This is crazy, all this time I've heard people with this dreaded issue, never thinking it would happen to one of my boxes, and now it has. The weird thing is, I've got larger, much more complex queries that are running just fine. I've done a lot of snooping around the macromedia forums, and found a few tips regarding mail spool files, and other things - nothing has helped. I doubt anyone has the definitive answer, otherwise there wouldn't be so many posts in the forum about this and it would have been fixed a few releases back when it was first discovered. I am just at my last resorts here and was hoping that SOMEBODY can offer a fix. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:40 AM To: CF-Talk Subject: RE: sql 7 MDAC Have you tried using OLE DB or a Dynamic query with a connection string? __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:27 PM To: CF-Talk Subject: sql 7 MDAC Hi there, has anyone researched which ODBC driver is most stable with CF 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and this query will crash CF to 100% CPU every time I run it: CFQUERY datasource=#request.mainDSN# Name=ViewAssignment SELECT ASSIGNMENTS.num_contentid AS contentid, ASSIGNMENTS.dat_start AS dat_start, ASSIGNMENTS.dat_due AS dat_due, ASSIGNMENTS.bit_complete AS bit_complete, ASSIGNMENTS.txt_description AS txt_description, CONTENT.contenttitle AS title, CONTENT.editable AS editable FROM ASSIGNMENTS, CONTENT WHERE ASSIGNMENTS.num_contentid = CONTENT.contentid AND ASSIGNMENTS.num_contentid = #attributes.contentid# ORDER BY ASSIGNMENTS.dat_due /CFQUERY I'm not exactly sure which MDAC is installed. Is it advisable to update to the most recent MDAC even though we're not running SQL 2000 yet? I noticed on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/ Thanks for any of your help. __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
accessibility - elegant solutions?
Hi folks, I'm working on a project where we have states with counties in them. I want to do an accessible version (ie - can't rely on javascript) of two related drop-down boxes - so that when someone selects a state, the county drop down is populated with counties in that state. I can do this easily enough by having the form submit back to itself, or breaking the form into two pages. I'm just wondering if anyone else that has to comply with section 508 has come up with a more elegant solution - something along the order of looking at the problem in a different way? Thoughts? -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf sites go poof
They all come up fine for me... -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 6:23 PM To: CF-Talk Subject: Re: cf sites go poof On Mon, 21 Jan 2002 17:24:51 -0500, Jon Hall [EMAIL PROTECTED] wrote: Well, obviously your ISP was having a major routing issue last night! ;-) That's a possibility. ;- Well... anyone know if any of these are really MIA? There were some more, but I don't have time to hunt them right now. http://www.coldfusionjournal.com/ http://www.cftutorials.com/ http://www.cfmentor.com http://www.cfextras.com http://www.trilemetry.com http://www.oacfug.org http://www.forumspot.org http://www.cffaq.org http://www.cflinux.org http://www.icesinc.com/ --min __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf sites go poof
If they do then you have a problem with something by you caching. CFLinux.org is down and dead. Icisinc.com has gone where too many have gone before. Forumspot is down and I'm talking to Ray about moving it over to HoF. A few of the others are also known to be down. At 02:48 PM 1/22/02, you wrote: They all come up fine for me... -Original Message- From: Lewis Sellers [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 6:23 PM To: CF-Talk Subject: Re: cf sites go poof On Mon, 21 Jan 2002 17:24:51 -0500, Jon Hall [EMAIL PROTECTED] wrote: Well, obviously your ISP was having a major routing issue last night! ;-) That's a possibility. ;- Well... anyone know if any of these are really MIA? There were some more, but I don't have time to hunt them right now. http://www.coldfusionjournal.com/ http://www.cftutorials.com/ http://www.cfmentor.com http://www.cfextras.com http://www.trilemetry.com http://www.oacfug.org http://www.forumspot.org http://www.cffaq.org http://www.cflinux.org http://www.icesinc.com/ --min __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL IN question
IN is just a shorthand for multiple OR clauses. try something like this: WHERE PartnerID LIKE '%@PID% of course, i don't know if you'll still need the convert. christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com -Original Message- From: Brian Ferrigno [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 2:05 PM To: CF-Talk Subject: SQL IN question I am trying to determine if an integer passed to a stored procedure is in a comma-seperated list. The column is a varchar datatype to allow for the data to be entered in like this : 1,2,3,4,5. So if a Partner ID of 4 is passed into the stored procedure, rows with 4 or 1,4 or 1,4,5 etc. in the PartnerID column will be returned. The problem is that only rows that exactly match what has been passed into the stored procedure are being returned. So in the above example only the row with 4 in the PartnerID column will be returned. Any row with multiple comma-seperated values are being ignored. Am I doing this correctly Is there a better way to do this? STORED PROCEDURE CODE: CREATE PROCEDURE procedure_Name @PID int AS SELECT Title, DateStart, moreFields FROM Events WHERE CONVERT(varchar,@PID) IN (PartnerID) GO STORED PROCEDURE CALL: cfstoredproc procedure=procedure_Name datasource=#DSN# cfprocparam type=In dbvarname=@PID value=#PartnerID# cfsqltype=CF_SQL_INTEGER cfprocresult name=PartnerData /cfstoredproc BTW, I had to use the CONVERT function in the stored procedure because a datatype mismatch error was being returned without it. Thank you in advance for any help you can give. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Word Com Problems
Sounds good. How do I do that? Dave Hannum wrote: Have you explored creating an RTF file in lieu of a Word document? It's much less resource intensive and won't crash the server like spawning winword.exe can. Just a thought. Dave __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: accessibility - elegant solutions?
One alternative would be to use an Iframe, but they only work with IE as far as I know. __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 3:01 PM To: CF-Talk Subject: accessibility - elegant solutions? Hi folks, I'm working on a project where we have states with counties in them. I want to do an accessible version (ie - can't rely on javascript) of two related drop-down boxes - so that when someone selects a state, the county drop down is populated with counties in that state. I can do this easily enough by having the form submit back to itself, or breaking the form into two pages. I'm just wondering if anyone else that has to comply with section 508 has come up with a more elegant solution - something along the order of looking at the problem in a different way? Thoughts? -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Anyone have CF Graphing examples?
Does anyone know of some place I can see what the graphs look like that are made with CF 5? I need to make some similar to what you can do in Excel but would like to see what is possible before I attempt to use ColdFusion for it. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql 7 MDAC
This is SOOO freakin weird. All of a sudden, it's working. No changes to anything. This is REAL comforting, I'm almost wishing it wouldn't have fixed itself because now I'm going to lose sleep at night wondering when the next time it magically decides to poop out on a random query. I hope you're all not rolling your eyes reading this, I'm dead serious about not changing anything. /me goes and talks to self in corner while cf-talk points and laughs. Thanks for all of your help, I'll keep you updated if I find anything else about this 'mystery'. Adam. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 3:47 PM To: CF-Talk Subject: RE: sql 7 MDAC You might try adjusting the long text buffers in CF Admin or blockfactors on that query to more closely control the flow of data. Just a guess... -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:37 AM To: CF-Talk Subject: RE: sql 7 MDAC In the last few minutes, I was able to actually narrow the issue down to the exact column, instead of the query. The exact query below works flawlessly when I omit the ASSIGNMENTS.txt_description field from the query. The data type in SQLserver is ntext. As soon as I add that field to the query though, the CPU goes to poop again and won't come down until I restart CF. Please don't tell me I'm going to have to store all of my text columns in individual files. Has anyone else had issues with text or ntext data types? The max size of any of the values is nowhere near 1k in that column, so it shouldn't be a bandwidth/memory issue. The server is pretty hefty on the resources too. Adam. -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 3:13 PM To: CF-Talk Subject: RE: sql 7 MDAC Adam, How big is the query. I noticed it's from a view - are other queries from views giving you any problems? mark -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:03 AM To: CF-Talk Subject: RE: sql 7 MDAC due to forces beyond my control, we are stuck with ODBC. I've updated the MDAC to 2.6 SP1 and it updated the SQLserver ODBC driver, but the same query still pegs the CF server to 100% CPU. I have pasted the query into it's own CF template, and I'm calling it directly - there is nothing in application.cfm. This is crazy, all this time I've heard people with this dreaded issue, never thinking it would happen to one of my boxes, and now it has. The weird thing is, I've got larger, much more complex queries that are running just fine. I've done a lot of snooping around the macromedia forums, and found a few tips regarding mail spool files, and other things - nothing has helped. I doubt anyone has the definitive answer, otherwise there wouldn't be so many posts in the forum about this and it would have been fixed a few releases back when it was first discovered. I am just at my last resorts here and was hoping that SOMEBODY can offer a fix. -Original Message- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 11:40 AM To: CF-Talk Subject: RE: sql 7 MDAC Have you tried using OLE DB or a Dynamic query with a connection string? __ steve oliver cresco technologies, inc. http://www.crescotech.com -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:27 PM To: CF-Talk Subject: sql 7 MDAC Hi there, has anyone researched which ODBC driver is most stable with CF 5 and MSSQL 7? We are currently running the 3.70.09.61 SQLserver driver and this query will crash CF to 100% CPU every time I run it: CFQUERY datasource=#request.mainDSN# Name=ViewAssignment SELECT ASSIGNMENTS.num_contentid AS contentid, ASSIGNMENTS.dat_start AS dat_start, ASSIGNMENTS.dat_due AS dat_due, ASSIGNMENTS.bit_complete AS bit_complete, ASSIGNMENTS.txt_description AS txt_description, CONTENT.contenttitle AS title, CONTENT.editable AS editable FROM ASSIGNMENTS, CONTENT WHERE ASSIGNMENTS.num_contentid = CONTENT.contentid AND ASSIGNMENTS.num_contentid = #attributes.contentid# ORDER BY ASSIGNMENTS.dat_due /CFQUERY I'm not exactly sure which MDAC is installed. Is it advisable to update to the most recent MDAC even though we're not running SQL 2000 yet? I noticed on this site, that the MDAC is up to 2.7 - http://microsoft.com/data/ Thanks for any of your help. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: