RE: ot: time changing on servers mysteriously?
Do you happen to use getTickCount() in your code? :P Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Is this possible in SQL
Cheers Matt, Worked a charm I have two tables which I want to query at the same time. I'm thinking something along the lines of SELECT c.categoryid, sc.sub_CategoryId FROM categories c, sub_category sc WHERE c.category = '#form.searchVal#' OR sc.sub_Category = '#form.searchVal#' LIMIT 1 But where this is a left join it will always return a result for either column whether it makes a match or not. I could do something like the code below, but it seems to cumbersum for the job. cfquery name=qryName SELECT c.categoryid AS catId FROM categories c WHERE c.category = '#form.searchVal#' /cfquery cif NOT qry.recordCount cfquery name=qryName SELECT sc.sub_CategoryId AS catId FROM sub_category sc WHERE sc.sub_Category = '#form.searchVal#' /cfquery /cfif cfset variables.catId =qryName.catId Cheers Andy --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.735 / Virus Database: 489 - Release Date: 06/08/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: advice on structure and cfcs (petmarket related)
My CFC knowledge is limited at the moment, but if you want some good starting points to building an app with CFC's then downloand and check out Ray Camdens BlogCFC (http://www.camdenfamily.com/morpheus/blog/). If you're looking for a good way to structure your code then have you looked at frameworks like Mach-ii (www.mach-ii.com) or Fusebox 4 (www.fusebox.org) Hope this helps Andy I'm looking how to best structure an application and build it with cfcs. I'm looking at the petmarket example right now (cfml only, not the flash front end version). What do people feel in general about the way that application is structured? In particular, I'm wondering about the detailview.cfm which is called by the product.cfc detailview function and used to output the page. Isn't that a bad thing? I would have thought you would call from a page template a cfc to return query info on a product and output that. Anything else about this application in particular I should be aware of or wary of duplicating, as maybe there is a better method or better performance to be had another way? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Downloading image
I like to use two separate tags though because you can validate that the cfhttp.FileContent variable actually contains the image and not a connection timeout message or something similar before you actually commit it to disk. What do other people think here, am I better of just writing the file and handling possible errors afterwards? -- Jay -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 09 August 2004 15:16 To: CF-Talk Subject: RE: Downloading image cfhttp url=""> method=GET getasbinary=yes cffile action="" ... It's worth pointing out that you can just use the FILE attribute of CFHTTP, rather than having a separate CFFILE tag. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: MySQL 4.1 reliability?
I am running it fine on our intranet, no problems so far. -- Jay -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: 09 August 2004 18:47 To: CF-Talk Subject: OT: MySQL 4.1 reliability? How reliable is MySQL 4.1?I know its flagged as beta but would it be safe to use for a small task, e.g. a bug tracker? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Javascript window.opener error
I am trying to populate a select box in FORM1 from a window which is originally opened by this form (FORM1). My browser is throwing error for some reason. I wonder if someone can tell me whats wrong with the following code? function PopulateLocality() { with (window.opener.document.forms[0]) { locality.options.length=0; for (var i = 0; i Locality.getRowCount(); i++) { locality.options[i]= new Option(Locality.alias_name[i],Locality.id[i]); } } } When I try to populate the select box in the same window not the parent then it works fine but that's not what I want Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: MySQL 4.1 reliability?
I've been playing around with it on my home machine and word Dev machine with no problems so far. Andy J I am running it fine on our intranet, no problems so far. -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Javascript window.opener error
You can only do new Option() from within the window that has the select. Write a function to add the option in the opener and call it from the popup. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 12:23 To: CF-Talk Subject: _javascript_ window.opener error I am trying to populate a select box in FORM1 from a window which is originally opened by this form (FORM1). My browser is throwing error for some reason. I wonder if someone can tell me whats wrong with the following code? function PopulateLocality() { with (window.opener.document.forms[0]) { locality.options.length=0; for (var i = 0; i Locality.getRowCount(); i++) { locality.options[i]= new Option(Locality.alias_name[i],Locality.id[i]); } } } When I try to populate the select box in the same window not the parent then it works fine but that's not what I want Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFX Tag help
Send it to me off list and I'll have a look Kola -Original Message- From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: 09 August 2004 18:18 To: CF-Talk Subject: CFX Tag help Hi All, I am using CFX_google on one of the application I am working on. I have downloaded the tag from CFDEV website http://www.cfdev.com/xml/soap/google/ It comes in open source so you can pretty much change it. I want to know if any body can help me to change the max results in the class file and the generate the JAR file for me. I have no knowledge at all of JAVA so any help is appreciated. I want to retrieve up to 1000 results instead of 10 which come standard with the downloaded version. Thanks in advance. Ketan Patel _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Range in SQL
On Monday 09 Aug 2004 16:49 pm, Mickael wrote: Ok but how do I use that number?Is there a way to set a variable in SQL? I'm lost now :-) Run one (select) query, see what the PK of the cut off point is. In your 2nd (update) query, use the PK in the where clause to only update records less (or more) than it. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX = .Net Web Service
Hi, i have a problem where i need to create an Array of Structs and pass it from CFMX to .Net Web Service. firstly can CF pass complex datatypes to non-CFMX web services ?? if it can then.. i have created a Array of Structs.. .eg cfset stForm.rtReqArray = ArrayNew(1) cfset stForm.rtReqStruct = StructNew() cfset stForm.rtReqStruct[rtCode] = JavaCast(string, 1S)!--- room type code --- cfset stForm.rtReqStruct[rtReq] = JavaCast(int, 1) !--- no of beds or room required --- cfset stForm.rtReqStruct[rtAdultCount] = JavaCast(int, 1) !--- no of Adults --- cfset stForm.rtReqStruct[rtChildCount] = JavaCast(int, 0) !--- no of Youths --- cfset stForm.rtReqStruct[rtRoomCost] = JavaCast(double, 20.00) !--- Total Cost per Room Type --- cfset stForm.rtReqArray[1] = stForm.rtReqStruct etc but i seem to be getting an error as shown below .. (Book is the function i call on the Web Service) you do not get to see the Array of Structs in the error mesg since it gets truncated. cfset stSendBooking.rtReqArray = stForm.rtReqArray cfset stSendBooking.email = stForm.email etc. cfset stLocal.returnBookStatus = stLocal.ws.Book(Application.chartWebServiceRevisionNo, stLocal.Code, Application.CallerID, stSendBooking, stLocal.returnBookingChartsBRN, stLocal.returnBookingTotalCost, stLocal.returnErrorMessage) Web service operation Bookwith parameters {1,BLUEMTNS,SCOTTY,[EMAIL PROTECTED],CARDAUTH={123},USERATETABLE={Y},ORIGBKGNO={e4b1c0e5},RTREQARRAY={[Ljava.lang.Objec t;@1d143d1},COMM={},PMCODE={XVCD},ARRDATE={06 Aug 04},RTMAX={1},FIRSTNAME={Joel},DEPTIME={},CARDNO={5123456789012346},LASTNAME={Nath},TOTALCOST={70.0},COUNTRY={Australia},ARRTIME={}, ADDRESS={302/182-190 hampden Road},STATE={NSW},PGCODE={},AGNCOD={},POSC={2064},DEPDATE={10 Aug 04},FAX={},PHONE={61 02 94112746},CARDEXP={0405},},stLocal.returnBookingChartsBRN,stLocal.returnBookingTotalCost,stLocal.returnErrorMessage} could not be found. i have checked the array name and struct keys etc... to be correct.. i have also used the toArray() function to convert the CF Array to Java Array.. but i have a feeling that the struct is having problems... if i take the Array of Structs out of the call then it seems fine.. any suggestion would be most helpful Cheers Joel .ps the args for the function call.. ' [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: advice on structure and cfcs (petmarket related)
I haven't seen the petmarket example, so I can't comment on that particular case, but I can say that - Yes, in general, that's a very bad thing. I'm not going to go into detail about WHY it's a bad thing, because I'll be rabbiting on for hours, but in practical it harms the flexibility, re-usability and maintainability of your code. The idea is to separate your backend from your frontend - or your Model from your Views, in MVC speak. This is achieved by an intermediary layer called the Controller. So your back-end CFCs are all self-contained - they don't know ANYTHING about the front-end display templates that actually define the interface. Fusebox ( www.fusebox.org http://www.fusebox.org/) was an attempt to achieve this degree of separation long before the advent of CFCs, Mach-II ( www.mach-ii.com http://www.mach-ii.com/) is probably the way to go if you want a standard way of doing it that harnesses the power of the CFC model. Hope that helps Al _ From: stylo stylo [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 06:37 To: CF-Talk Subject: advice on structure and cfcs (petmarket related) I'm looking how to best structure an application and build it with cfcs. I'm looking at the petmarket example right now (cfml only, not the flash front end version). What do people feel in general about the way that application is structured? In particular, I'm wondering about the detailview.cfm which is called by the product.cfc detailview function and used to output the page. Isn't that a bad thing? I would have thought you would call from a page template a cfc to return query info on a product and output that. Anything else about this application in particular I should be aware of or wary of duplicating, as maybe there is a better method or better performance to be had another way? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Accented characters
Perfect, exactly what I was looking for and having added charset=iso-8859-1 to a couple of cfhttp's I was doing it all now works. Thanks. -- Jay -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 05 August 2004 18:06 To: CF-Talk Subject: Re: Accented characters I am using MySQL as a datasource and whenever an accented character arises ( for example) it ends up being stored in the database as ' ' instead. for mx: in your application.cfm add: cfset setEncoding(url,ISO-8859-1) cfset setEncoding(form,ISO-8859-1) cfcontent type=text/html; charset=ISO-8859-1 at the top of your cf pages add: cfprocessingdirective pageEncoding=ISO-8859-1 in the advanced option, connection string, for that DSN add: useUnicode=truecharacterEncoding=ISO-8859-1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: WOT: City Portal Software
Donna, You might try FarCry CMS: http://farcry.daemon.com.au/ - Original Message - From: Donna French [EMAIL PROTECTED] Sorry for the WOT post but I'm hoping someone out there knows of a ready-made solution to get a city web portal off the ground quickly. Would like something with classifieds, news, etc...any suggestions more than welcome. FarCry has most of these options out of the box, and is particularly easy to extend and customise.You can't beat the price; opensource! Try the farcry-dev mailing list for some candid opinions on whether FarCry is the right choice for your project: http://farcry.daemon.com.au/go/support/mailing-lists -- geoff On the road via GMail. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blogging APIs
You need Roger Benningfield's CFC: http://support.journurl.com/users/admin/index.cfm?mode=article http://support.journurl.com/users/admin/index.cfm?mode=articleentry=362 entry=362 Roger's weblog is a goldmine of info for this topic. Yes, Roger's site has some great stuff, but I'm new enough at this particular piece that I'm need some ground zero help. Roger's stuff skips over some of ground level stuff and jumps right into the thick of things. For instance, Roger you mention abovei using GetHttpRequestData()... but how? With the CFC, how do you actually put it to use? Is there documentation for this CFC? I've not done much with this stuff, so I need some pretty ground level help! :) Thanks! Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Transaction Log Size
Thank you all for your help. Dave Not sure about problems, but seems like a long way around and depending on the size of the database, might take a little time to execute. Not to mention if this is a production database, it will not be an option to deattach it. You can extend the scheduled template I spoke of before that checks the size of the log file and if it is over XMB, execute the following query: use [pubs] DBCC SHRINKFILE (N'pubs_log', 1) where 1 is the size you want the log to be. I should also point out that you should determine a reasonable daily log file size and set it at that size. Shrinking all of the way down will just cause it to expand when it needs to, and I am sure there is a little overhead with that process. Dan - Original Message - From: David Koehler [EMAIL PROTECTED] Date: Mon, 09 Aug 2004 13:45:37 -0400 Subject: Re: Transaction Log Size To: CF-Talk [EMAIL PROTECTED] Thanks Dan. I read that as long as I have a good backup I can detach the database and then delete the transaction log and then reattach the database. The new transaction log then begins at a small size. I tried this on a dummy database and all seems ok. Any inherent problems with doing this? Dave In my experience, here is what happens. start: log is 2 MB daily activity increase it to 3MB backup, log remains at 3MB but is empty daily activity increase it to 45MB* backup, log remains at 45MB but is empty daily activity = 3MB* backup, log remains at 45MB but is empty * typically a lrage update or insert of data causes this So the log size is 45 MB, and it will always use that space for the fist 45 MB of logged transactions, and increase if it has to, but nothing ever shrinks it. There may be a better way, but a qucick scheduled template to check the size after the backup and alert you via email when it is larger than XMB, can be an alert for you to shrink it. Dan - Original Message - From: David Koehler [EMAIL PROTECTED] Date: Mon, 09 Aug 2004 11:49:32 -0400 Subject: Re: Transaction Log Size To: CF-Talk [EMAIL PROTECTED] So, they should be shrunked? Dave They get cleared, not removed, but the problem is they are not shrunk, which is why they tend to get blown out of size. Dan - Original Message - From: Samuel R. Neff [EMAIL PROTECTED] Date: Fri, 6 Aug 2004 16:36:38 -0400 Subject: RE: Transaction Log Size To: CF-Talk [EMAIL PROTECTED] The transaction logs get removed when you do a backup ('cause they're no longer needed). Sam -Original Message- From: David Koehler [mailto:[EMAIL PROTECTED] Sent: Friday, August 06, 2004 4:33 PM To: CF-Talk Subject: Transaction Log Size Some of our transaction logs are getting very large. I know I can set the database recovery model to simple and not have any logging, but is there a way to actually reduce the already massive log file size? Thanks in advance, dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blogging APIs
i've been playing with this all morning since this thread appeared. Using the CFC i''ve now got Newzcrawler to be able to add posts to my blogsit's pretty cool once you get going. You need to construct the array to pass into the xmlrpc CFC. Use the debugger to test the results, jb. On Tue, 10 Aug 2004 08:18:31 -0400, Jake . [EMAIL PROTECTED] wrote: You need Roger Benningfield's CFC: http://support.journurl.com/users/admin/index.cfm?mode=article http://support.journurl.com/users/admin/index.cfm?mode=articleentry=362 entry=362 Roger's weblog is a goldmine of info for this topic. Yes, Roger's site has some great stuff, but I'm new enough at this particular piece that I'm need some ground zero help. Roger's stuff skips over some of ground level stuff and jumps right into the thick of things. For instance, Roger you mention abovei using GetHttpRequestData()... but how? With the CFC, how do you actually put it to use? Is there documentation for this CFC? I've not done much with this stuff, so I need some pretty ground level help! :) Thanks! Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
metaWeblog.getCategories xmlrpc result anyone?
can anyone post the a demo resultant XML of the metaweblog.getcategories method call, thanks, jb. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: UNIX linefeeds... why?
On Tue, 10 Aug 2004 01:16:10 -0400, Claude Schneegans [EMAIL PROTECTED] wrote: Using Unix line feeds works with most tools on most platforms. Well... except under Windows ;-) Dreamweaver can easily be configured to use Unix line feeds - you all use Dreamweaver, right? :) By the way, the _expression_ Windows line feed is not quite appropriate: One should rather say ASCII line feed. It has always been that in ASCII, there is one character to get the cursor (actually the cariage from the time of good old TTYs) at the begining of the line, and another one to move the paper one line up. Actually that's not strictly true. ASCII line feed is control J which moves the paper one line up but does NOT move the cursor to the beginning of the line. That requires an ASCII carriage return - control M. Windows line feeds are control J control M - which is why when you edit a Windows file on Unix you see a control M at the end of every line or you see double-spaced lines. Unix files use just the ASCII line feed characters and the convention is that it represents a newline (hence the \n escape character in C-based languages - carriage return is \r). Mac native line endings are just control M (carriage return) but Mac editing tools are all happy with control J instead. CP/M and Windows, which were supporting 8 bits, then 16 bits machines, were ASCII based system at the begining. Both \n (control J) and \r (control M) are ASCII characters and even on multibyte systems the lower character values are still technically ASCII. -- Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Is Morgan Ross on this list?
If so.. please reply :) Looking for old coleagues! -- Mark Drew mailto:[EMAIL PROTECTED] blog:http://cybersonic.blogspot.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Export to Excel ok, PDF not ok
Sorry, the msg were not clear enough, following is my editing. It seems strange, the following code would work to export current page to Excel format but not PDF format (though a pdf doc is generated, its format seems incorrect for PDF reader failed to open it). Code for exporting to Excel: cfheader name=Content-Disposition value=attachment;filename=file123.xls cfcontent type=application/msexcel Code for exporting to PDF: cfheader name=Content-Disposition value=attachment;filename=file123.pdf cfcontent type=application/pdf (content to be exported or included in the desired format) dynamic page data in HTML table format. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blogging APIs
oh and i started out by cfdumping the rpcCall into an email to see what methods the blogging client was attempting to call then i created a big cfswitch on rpccall.method to deal with each method, jb. On Tue, 10 Aug 2004 14:23:03 +0100, John Beynon [EMAIL PROTECTED] wrote: i've been playing with this all morning since this thread appeared. Using the CFC i''ve now got Newzcrawler to be able to add posts to my blogsit's pretty cool once you get going. You need to construct the array to pass into the xmlrpc CFC. Use the debugger to test the results, jb. On Tue, 10 Aug 2004 08:18:31 -0400, Jake . [EMAIL PROTECTED] wrote: You need Roger Benningfield's CFC: http://support.journurl.com/users/admin/index.cfm?mode=article http://support.journurl.com/users/admin/index.cfm?mode=articleentry=362 entry=362 Roger's weblog is a goldmine of info for this topic. Yes, Roger's site has some great stuff, but I'm new enough at this particular piece that I'm need some ground zero help. Roger's stuff skips over some of ground level stuff and jumps right into the thick of things. For instance, Roger you mention abovei using GetHttpRequestData()... but how? With the CFC, how do you actually put it to use? Is there documentation for this CFC? I've not done much with this stuff, so I need some pretty ground level help! :) Thanks! Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLACKSTONE Sneak Preview Posted
As Damon has said (twice :) - installation support is free and it's fairly easy to find the installation support form on the web site but here's the URL to save you searching: http://www.macromedia.com/support/email/isupport/main.cgi -- Sean A Corfield -- http://www.corfield.org/blog/ Thanks for the follow-up, problem resolved before even I posted the msg, the intention of mentioning it is for the benefit of others. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
mapping cfmx to parse .htm templates in virtual sites in apache?
Hi, I've added the servlet-mapping section to web.xml in my cfmxroot/wwwroot/WEB-INF folder as described on livedocs and restarted CFMX but it hasn't picked up the mapping for my apache virtual sites. Can anybody point me in the right direction here please? do I need to re-configure the apache-connector and re-run it to apply the mapping? Cheers, Dave CFMX 6.1, Apache 2.0.49 on Debian Woody. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
looking for a regex
Hello I'm looking for a regex that will identify items in a template file along the lines of {item} {item.subitem} {item.subitem1.subitem2} etc... But that will not pull up _javascript_ functions!! Any guru's out there who can help? Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Export to Excel ok, PDF not ok
This isn't going to work... You code for exporting to excel only works because Excel knows how to deal with HTML data; the PDF viewer does not know how to deal with HTML and it fails.To the best of my knowledge, changing headers, etc won't make a difference. -Original Message- From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 10:35 AM To: CF-Talk Subject: Re: Export to Excel ok, PDF not ok Sorry, the msg were not clear enough, following is my editing. It seems strange, the following code would work to export current page to Excel format but not PDF format (though a pdf doc is generated, its format seems incorrect for PDF reader failed to open it). Code for exporting to Excel: cfheader name=Content-Disposition value=attachment;filename=file123.xls cfcontent type=application/msexcel Code for exporting to PDF: cfheader name=Content-Disposition value=attachment;filename=file123.pdf cfcontent type=application/pdf (content to be exported or included in the desired format) dynamic page data in HTML table format. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: looking for a regex
\{\w+(\.\w+)*\} What do you mean by js functions? Pascal -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 16:44 To: CF-Talk Subject: looking for a regex Hello I'm looking for a regex that will identify items in a template file along the lines of {item} {item.subitem} {item.subitem1.subitem2} etc... But that will not pull up _javascript_ functions!! Any guru's out there who can help? Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX Oracle and SQL Server Fun
CFers, Im need some advice. I have a few tables in Oracle 9i that I need to get into SQL Server 7 daily and when needed, the basic function of the process is get the data from Oracle then perform some joins followed by creating a new table in SQL Server with the results each time this job is run. Whats the best way to do this? Right now I have a CFMX server with a JDBC connection to Oracle then I CFQUERY my way through this task using a CFM template. I was thinking if I could use a SQL Server SPROC this might be a better method. Does anyone out here do anything like this? By what Ive been researching using a SQL Server Linked Server may be the option Im looking for. Regards, -JB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: looking for a regex
he means this regex will return things like window.location.replace() or document.write() -- he wants to exclude those. \{\w+(\.\w+)*\} What do you mean by js functions? Pascal -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 16:44 To: CF-Talk Subject: looking for a regex Hello I'm looking for a regex that will identify items in a template file along the lines of {item} {item.subitem} {item.subitem1.subitem2} etc... But that will not pull up _javascript_ functions!! Any guru's out there who can help? Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Export to Excel ok, PDF not ok
Try this site http://www.school-for-champions.com/coldfusion/cftopdf.htm Or use a program like CFXPDF by http://www.easel2.com, DynamicPDF byhttp://gilgamesh-solutions.com/products.cfm#p1 (Must have cfExecute turned on to use this product.) or ActivePDF http://www.activepdf.com/Pricy This isn't going to work... You code for exporting to excel only works because Excel knows how to deal with HTML data; the PDF viewer does not know how to deal with HTML and it fails.To the best of my knowledge, changing headers, etc won't make a difference. -Original Message- From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 10:35 AM To: CF-Talk Subject: Re: Export to Excel ok, PDF not ok Sorry, the msg were not clear enough, following is my editing. It seems strange, the following code would work to export current page to Excel format but not PDF format (though a pdf doc is generated, its format seems incorrect for PDF reader failed to open it). Code for exporting to Excel: cfheader name=Content-Disposition value=attachment;filename=file123.xls cfcontent type=application/msexcel Code for exporting to PDF: cfheader name=Content-Disposition value=attachment;filename=file123.pdf cfcontent type=application/pdf (content to be exported or included in the desired format) dynamic page data in HTML table format. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX Oracle and SQL Server Fun
I would use a DTS package.I have a process here that runs nightly and it is a DTS package that connects to the Oracle 9i server and pulls data out of views and places that data into tables on the SQL Server then manipulates that data into the final tables that their application accesses. On Tue, 10 Aug 2004 10:51:50 -0400, James Blaha [EMAIL PROTECTED] wrote: CFers, I'm need some advice. I have a few tables in Oracle 9i that I need to get into SQL Server 7 daily and when needed, the basic function of the process is get the data from Oracle then perform some joins followed by creating a new table in SQL Server with the results each time this job is run. What's the best way to do this? Right now I have a CFMX server with a JDBC connection to Oracle then I CFQUERY my way through this task using a CFM template. I was thinking if I could use a SQL Server SPROC this might be a better method. Does anyone out here do anything like this? By what I've been researching using a SQL Server Linked Server may be the option I'm looking for. Regards, -JB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looking for a regex
he wants to exclude those. Then he should use CF_REExtract (see address below) to detect SCRIPT. /SCRIP areas and neutrilized them before the scan. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: looking for a regex
No it won't, there can't be a ( after the last word, it has to be a } Pascal -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 16:53 To: CF-Talk Subject: RE: looking for a regex he means this regex will return things like window.location.replace() or document.write() -- he wants to exclude those. \{\w+(\.\w+)*\} What do you mean by js functions? Pascal -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 16:44 To: CF-Talk Subject: looking for a regex Hello I'm looking for a regex that will identify items in a template file along the lines of {item} {item.subitem} {item.subitem1.subitem2} etc... But that will not pull up _javascript_ functions!! Any guru's out there who can help? Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX Oracle and SQL Server Fun
I'm need some advice. I have a few tables in Oracle 9i that I need to get into SQL Server 7 daily and when needed, the basic function of the process is get the data from Oracle then perform some joins followed by creating a new table in SQL Server with the results each time this job is run. What's the best way to do this? Right now I have a CFMX server with a JDBC connection to Oracle then I CFQUERY my way through this task using a CFM template. I was thinking if I could use a SQL Server SPROC this might be a better method. Does anyone out here do anything like this? By what I've been researching using a SQL Server Linked Server may be the option I'm looking for. I'd second Aaron Rouse's suggestion to use DTS. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: looking for a regex
Well the regexes he was using were -- I don't know why but for some reason I didn't interpet the {} as part of what he was looking for in the string, and then I glossed over it in your regex... No it won't, there can't be a ( after the last word, it has to be a } Pascal -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 16:53 To: CF-Talk Subject: RE: looking for a regex he means this regex will return things like window.location.replace() or document.write() -- he wants to exclude those. \{\w+(\.\w+)*\} What do you mean by js functions? Pascal -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 16:44 To: CF-Talk Subject: looking for a regex Hello I'm looking for a regex that will identify items in a template file along the lines of {item} {item.subitem} {item.subitem1.subitem2} etc... But that will not pull up _javascript_ functions!! Any guru's out there who can help? Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looking for a regex
I think he doesn't want to find {document.forms[0].bob.value=dom1.dom2.function()} I'd remove everything contained in script tags first.There are several threads about that in the articles.If you have onclicks or _javascript_ calls in anchor tags, it can get more complicated, but I don't want to think really hard about problems that haven't arisen yet. :-) Depending on what your items look like, you might use [^. ] instead of \w, but Pascal (as usual) seems to have the right of it. --Ben Pascal Peters wrote: \{\w+(\.\w+)*\} What do you mean by js functions? Pascal -Original Message- From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 16:44 To: CF-Talk Subject: looking for a regex Hello I'm looking for a regex that will identify items in a template file along the lines of {item} {item.subitem} {item.subitem1.subitem2} etc... But that will not pull up _javascript_ functions!! Any guru's out there who can help? Thanks, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT:Client/Server Gateway JSAPI
Anyone using this from Pengoworks.com? Contact me off list or via AIM: mtangorre Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFForm CFGrid - Submit button not appearing
Has anyone else had a problem with CFFORM not showing the submit button for the form when using CFGRID? I've never seen that problem. When you use CFFORM, it just builds HTML form tags for you. You still need to include a submit button yourself. When you view HTML source, do you see the submit button code? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looking for a regex
he wants to exclude those. Then he should use CF_REExtract (see address below) to detect SCRIPT. /SCRIP areas and neutrilized them before the scan. Which might still leave the question of a href=""> s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX Oracle and SQL Server Fun
My first thought was DTS but arent SPROCs much faster to execute? Plus I need to execute the DTS via a Cold Fusion template I know how to due this but I always run through loops with my DBA about the setup with all the permissions I need to have setup. Regards, -JB Dave Watts wrote: I'm need some advice. I have a few tables in Oracle 9i that I need to get into SQL Server 7 daily and when needed, the basic function of the process is get the data from Oracle then perform some joins followed by creating a new table in SQL Server with the results each time this job is run. What's the best way to do this? Right now I have a CFMX server with a JDBC connection to Oracle then I CFQUERY my way through this task using a CFM template. I was thinking if I could use a SQL Server SPROC this might be a better method. Does anyone out here do anything like this? By what I've been researching using a SQL Server Linked Server may be the option I'm looking for. I'd second Aaron Rouse's suggestion to use DTS. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Shared Server / 500 Error
I am doing some development on a shared server for a customer and am getting an Internal 500 Server error ... is there ANY way around this error?We don't have access to the CF Admin so I can't view the error logs ... anything you can suggest? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
dynamic time picker
hi all! i need to make a select option value=00:00:0012:00 am option value=00:15:0012:15 am /select that has all the times from midnight to 11:45 pm and not have to hand type them all...how would you do it? is this already done, and i can dl it? if not, ill hand type them all and then have that for future use, but im SURE someone has done this? thanks -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Shared Server / 500 Error
What are you trying to do?Some kind of code or explanation of what the page is doing would help.Any CFHTTP tags being used? Ray At 11:26 AM 8/10/2004, you wrote: I am doing some development on a shared server for a customer and am getting an Internal 500 Server error ... is there ANY way around this error?We don't have access to the CF Admin so I can't view the error logs ... anything you can suggest? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Shared Server / 500 Error
Yes, we are creating an XML String wit hCFSCRIPT, then sending that script with CFHTTP and waiting for a response. I am getting nothing .. just the 500 error (script is from the company providing the services). Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Ray Champagne To: CF-Talk Sent: Tuesday, August 10, 2004 10:31 AM Subject: Re: Shared Server / 500 Error What are you trying to do?Some kind of code or explanation of what the page is doing would help.Any CFHTTP tags being used? Ray At 11:26 AM 8/10/2004, you wrote: I am doing some development on a shared server for a customer and am getting an Internal 500 Server error ... is there ANY way around this error?We don't have access to the CF Admin so I can't view the error logs ... anything you can suggest? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX Oracle and SQL Server Fun
Why do you need to execute the DTS from CFMX?I suppose you could do a combination of DTS and stored procedures.I personally have never used an SP to connect to another flavor database and pull out date, honestly not even sure how that would be done, so could not say if it is faster or not to do it solely through an SP. On Tue, 10 Aug 2004 11:25:13 -0400, James Blaha [EMAIL PROTECTED] wrote: My first thought was DTS but aren't SPROCs much faster to execute? Plus I need to execute the DTS via a Cold Fusion template I know how to due this but I always run through loops with my DBA about the setup with all the permissions I need to have setup. Regards, -JB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX Oracle and SQL Server Fun
Aaron, Check this out: http://www.winnetmag.com/SQLServer/Article/ArticleID/22264/SQLServer_22264.html Regards, -JB Aaron Rouse wrote: Why do you need to execute the DTS from CFMX?I suppose you could do a combination of DTS and stored procedures.I personally have never used an SP to connect to another flavor database and pull out date, honestly not even sure how that would be done, so could not say if it is faster or not to do it solely through an SP. On Tue, 10 Aug 2004 11:25:13 -0400, James Blaha [EMAIL PROTECTED] wrote: My first thought was DTS but aren't SPROCs much faster to execute? Plus I need to execute the DTS via a Cold Fusion template I know how to due this but I always run through loops with my DBA about the setup with all the permissions I need to have setup. Regards, -JB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looking for a regex
Which might still leave the question of a href=""> No {}.:-) --Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: dynamic time picker
dont know if there's a more efficient way to do this but 2 loops format it to your desire. select name=time > cfloop index=i from=0 to=23 step=1 cfloop index=j from=0 to=45 step=15 cfset ltime=#numberformat(i,'00')#:#numberformat(j,'00')# option value=cfoutput#ltime#/cfoutputcfoutput#timeformat(ltime, short)#/cfoutput/option /cfloop /cfloop /select On Tue, 10 Aug 2004 11:30:01 -0400, Tony Weeg [EMAIL PROTECTED] wrote: hi all! i need to make a select option value=00:00:0012:00 am option value=00:15:0012:15 am /select that has all the times from midnight to 11:45 pm and not have to hand type them all...how would you do it? is this already done, and i can dl it? if not, ill hand type them all and then have that for future use, but im SURE someone has done this? thanks -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dynamic time picker
cfset t = CreateTime(0,0,0) cfset end = DateAdd(d,1,t) cfset step = 15 select cfloop condition=DateCompare(t,end) LT 0 option value=#TimeFormat(t,'HH:mm:ss')##TimeFormat(t,'hh:mm tt')#/option cfset t = DateAdd(n,step,t) /cfloop /select /cfoutput Pascal -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 17:30 To: CF-Talk Subject: dynamic time picker hi all! i need to make a select option value=00:00:0012:00 am option value=00:15:0012:15 am /select that has all the times from midnight to 11:45 pm and not have to hand type them all...how would you do it? is this already done, and i can dl it? if not, ill hand type them all and then have that for future use, but im SURE someone has done this? thanks -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Shared Server / 500 Error
Not sure I am going to be able to help that much with the XML deal.I don't deal with it that much, but I bet if you post your code, someone here (maybe me) could help out.The problem definitely lies in CFHTTP, but I guess we'd need to see why... Ray At 11:34 AM 8/10/2004, you wrote: Yes, we are creating an XML String wit hCFSCRIPT, then sending that script with CFHTTP and waiting for a response. I am getting nothing .. just the 500 error (script is from the company providing the services). Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com - Original Message - From: Ray Champagne To: CF-Talk Sent: Tuesday, August 10, 2004 10:31 AM Subject: Re: Shared Server / 500 Error What are you trying to do?Some kind of code or explanation of what the page is doing would help.Any CFHTTP tags being used? Ray At 11:26 AM 8/10/2004, you wrote: I am doing some development on a shared server for a customer and am getting an Internal 500 Server error ... is there ANY way around this error?We don't have access to the CF Admin so I can't view the error logs ... anything you can suggest? Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dynamic time picker
This works for me! cfset x=00:00:00 select name=time cfloop from=1 to=96 index=i cfoutput option value=#timeformat(x,'HH:mm:ss')##timeformat(x,'h:mm: tt')# /cfoutput cfset x = dateadd(n,15,timeformat(x)) /cfloop /select Ferg _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 10:30 AM To: CF-Talk Subject: dynamic time picker hi all! i need to make a select option value=00:00:0012:00 am option value=00:15:0012:15 am /select that has all the times from midnight to 11:45 pm and not have to hand type them all...how would you do it? is this already done, and i can dl it? if not, ill hand type them all and then have that for future use, but im SURE someone has done this? thanks -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Crytal Enterprise
Does anyone have a good resource for Crystal Enterprise 10 info? We just got it, and while I can make a report and publish it to Enterprise, I can't get enterprise to talk to Oracle. (The odbc connection exists on the enterprise server in the same config as on my desktop, and I've verified that the Oracle client software is working, too.) I know some people on the list use Crystal Does anyone have a good mailing list/forum for questions about it? -- Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blogging APIs
For instance, Roger you mention abovei using GetHttpRequestData()... but how? Jake: Today is my birthday, so I'm not going to be able to go into anything extensive here. And there's only so in-depth I can be anyway, since blogging is my business and there's a fine line between being helpful and commercially suicidal. :D That aside... the idea is that you have a page like xmlrpc.cfm, and you point your client app at it. The client is going to POST an XML-RPC packet to that page. To make use of that packet, you need to retrieve it and feed it to xmlrpc.cfc to have it converted into a CFML struct. That's where GetHttpRequestData() comes in. cfset myxmlrpc = GetHttpRequestData().content Feed the results into the CFC and you're on your way. With the CFC, how do you actually put it to use? Is there documentation for this CFC? Yup, but Macromedia owns it. Check out DRK5 for a tutorial. I've not done much with this stuff, so I need some pretty ground level help! :) I feel your pain. When I was alpha-testing the current version of JournURL in late 2002, there was zero userful XML-RPC and RSS info available in the CF world. That's why I went ahead and released the CFC... it's one thing for folks to pull themselves up by their bootstraps, but quite another to expect them to make their own boots first. -- Roger Benningfield work: http://journurl.com/ blog: http://admin.support.journurl.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: dynamic time picker
thank you, perfect! brain fart this morning prevented my brain going past the first loop :( anyway, good day! cheers tw On Tue, 10 Aug 2004 17:47:19 +0200, Pascal Peters [EMAIL PROTECTED] wrote: cfset t = CreateTime(0,0,0) cfset end = DateAdd(d,1,t) cfset step = 15 select cfloop condition=DateCompare(t,end) LT 0 option value=#TimeFormat(t,'HH:mm:ss')##TimeFormat(t,'hh:mm tt')#/option cfset t = DateAdd(n,step,t) /cfloop /select /cfoutput Pascal -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 17:30 To: CF-Talk Subject: dynamic time picker hi all! i need to make a select option value=00:00:0012:00 am option value=00:15:0012:15 am /select that has all the times from midnight to 11:45 pm and not have to hand type them all...how would you do it? is this already done, and i can dl it? if not, ill hand type them all and then have that for future use, but im SURE someone has done this? thanks -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF LOGINUSER not logging in users :)
Hey, Does anyone have any other ideas? I still haven't solved this issue yet. And I still can't figure out what's the problem with my code. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Export to Excel ok, PDF not ok
This isn't going to work... You code for exporting to excel only works because Excel knows how to deal with HTML data; the PDF viewer does not know how to deal with HTML and it fails.To the best of my knowledge, changing headers, etc won't make a difference. Thanks, good to know. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Search Engine Optimization
I know this is a little off topic, but does anyone have any specific techniques they use to get the most out of thier listing in Search engines? Other than, the title tag, the amount of times the words are listed in the page etc, submitting to search engines directly, as well as having many links to your site as possible from other sites. Any help would be appreciated . Thanks Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Export to Excel ok, PDF not ok
Try this site http://www.school-for-champions.com/coldfusion/cftopdf.htm Thanks, will revisit it when I got time to work on the conversion. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
chinese translations anyone?
I need a quick translation into Chinese (simplified encoding) for the following statement: Thank you for your interest. A representative will get back to you as soon as possible. Anyone here able to do this for me?Our contract translator is out of the country at the moment, and I really need this to get done today. My email address is [EMAIL PROTECTED], if anyone could send me a word doc, I would be eternally grateful! Thanks, Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Search Engine Optimization
Ryan...search the archives over the past few weeks...asked and answered ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
joining two queries
hello again i have two queries, with the same column list in each.. and i want to append one query to the end of the other... i know i can do it in sql, but i want to do it in coldfusion preferably in cfscript... how!? Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Timed out trying to establish connection
Just switched form CF Server 5 to MX 6.1 and now getting this error all the time. Error Executing Database Query. Timed out trying to establish connection Any help to correct this would be appreciated. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX Oracle and SQL Server Fun
DTS can run stored procedures as well. The two options aren't exclusive. If you're really worried about speed, then you should definitely cut CF out of the loop and have SQL Server pull the data directly from Oracle. If you have SQL Server talk to Oracle directly, then you will probably need to set up an Oracle connection for your SQL Server database, as your article says. See http://www.orafaq.com/faqodbc.htm for more details. Unless you need real-time data, for performance issues, it's better to make a local copy of the Oracle table(s) that you need rather than having to fetch the table across the network all the time. Again, this scheduled import is best done with DTS. --- James Blaha [EMAIL PROTECTED] wrote: Aaron, Check this out: http://www.winnetmag.com/SQLServer/Article/ArticleID/22264/SQLServer_22264.html Regards, -JB Aaron Rouse wrote: Why do you need to execute the DTS from CFMX?I suppose you could do a combination of DTS and stored procedures.I personally have never used an SP to connect to another flavor database and pull out date, honestly not even sure how that would be done, so could not say if it is faster or not to do it solely through an SP. On Tue, 10 Aug 2004 11:25:13 -0400, James Blaha [EMAIL PROTECTED] wrote: My first thought was DTS but aren't SPROCs much faster to execute? Plus I need to execute the DTS via a Cold Fusion template I know how to due this but I always run through loops with my DBA about the setup with all the permissions I need to have setup. Regards, -JB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: joining two queries
http://www.cflib.org/udf.cfm?ID=1021 _ From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: 10 August 2004 17:14 To: CF-Talk Subject: joining two queries hello again i have two queries, with the same column list in each.. and i want to append one query to the end of the other... i know i can do it in sql, but i want to do it in coldfusion preferably in cfscript... how!? Ryan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: joining two queries
i have two queries, with the same column list in each.. and i want to append one query to the end of the other... i know i can do it in sql, but i want to do it in coldfusion preferably in cfscript... http://www.cflib.org/udf.cfm?ID=1021 Massimo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: joining two queries
My question would be Why do it in CF if you can do it in SQL? IMHO it's always best to make the DB do the work it's meant for...it does it best So I'd suggest using a UNION clasue to join the 2 queries.As you stated, there are 2 select lists with the same columnsso you should be good to go if your DB can handle UNIONs But hey...perhaps I'm not gettin what you're after Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Ryan Mitchell To: CF-Talk Sent: Tuesday, August 10, 2004 9:13 AM Subject: joining two queries hello again i have two queries, with the same column list in each.. and i want to append one query to the end of the other... i know i can do it in sql, but i want to do it in coldfusion preferably in cfscript... how!? Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Search Engine Optimization
SES Urls (article in FA), CSS for tighter code (Sandy speaking on it tonight or take her course), clean url spaces, good content on a regular rotation, lots o' links I know this is a little off topic, but does anyone have any specific techniques they use to get the most out of thier listing in Search engines? Other than, the title tag, the amount of times the words are listed in the page etc, submitting to search engines directly, as well as having many links to your site as possible from other sites. Any help would be appreciated . Thanks Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: advice on structure and cfcs (petmarket related)
I'm not interested in Fusebox, and MachII is a bit much to begin with, maybe later. I am worried, however, about the speed of MachII. I thought FB3 apps ran slowly, and MachII is apparently slower, no? I do have Ray's BlogCFC and need to look at it more, but, to be honest, at first glance I find the structure of it a bit confusing, what with all the folders and ini file, though I will certainly study it, especially the cfcs and flow of it. Thanks, Ray! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: chinese translations anyone?
I really need this to get done today. Chinatown for lunch? ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: chinese translations anyone?
Hi, I can do it, but just cannot make the Word to write out the Chinese Characters here at work.I have added the Language Chinese (PRC) to the Language bar, but it still not working. If nobody does that for you please let me know. I will try again. Sima -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 12:06 PM To: CF-Talk Subject: chinese translations anyone? I need a quick translation into Chinese (simplified encoding) for the following statement: Thank you for your interest. A representative will get back to you as soon as possible. Anyone here able to do this for me?Our contract translator is out of the country at the moment, and I really need this to get done today. My email address is [EMAIL PROTECTED], if anyone could send me a word doc, I would be eternally grateful! Thanks, Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looking for a regex
Which might still leave the question of a href=""> This can also be found easily with CF_REExtract Actually, CF_REextract could be used first to extract the area where the content to analyse is to be found, then applied a seconf time on this content (or a standard RegEx) to extract whats wanted [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: chinese translations anyone?
Actually, someone already helped me out. Thanks everyone for the options and offers.This WOT request is a tribute to how diverse and helpful this list is!You guys rock! Thanks, Ray At 12:40 PM 8/10/2004, you wrote: Hi, I can do it, but just cannot make the Word to write out the Chinese Characters here at work.I have added the Language Chinese (PRC) to the Language bar, but it still not working. If nobody does that for you please let me know. I will try again. Sima -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 12:06 PM To: CF-Talk Subject: chinese translations anyone? I need a quick translation into Chinese (simplified encoding) for the following statement: Thank you for your interest. A representative will get back to you as soon as possible. Anyone here able to do this for me?Our contract translator is out of the country at the moment, and I really need this to get done today. My email address is [EMAIL PROTECTED], if anyone could send me a word doc, I would be eternally grateful! Thanks, Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[ HTML-Kit ] Users, new CFMX plugin
Just wanted to share this with the cf community. I've created a plugin for HTML kit that includes all the common CFMX6.1 tags and functions...it's basically a new version of the current plugin mgColdfusion, but updated for CFMX 6.1. Enjoy! http://www.chami.com/html%2Dkit/plugins/info/dfcfmx/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: chinese translations anyone?
http://www.hegelsoftware.com/demo/response_in_chinese.bmp Note, I saved it as an image, so, it does not care about encoding. I need a quick translation into Chinese (simplified encoding) for the following statement: Thank you for your interest. A representative will get back to you as soon as possible. Anyone here able to do this for me?Our contract translator is out of the country at the moment, and I really need this to get done today. My email address is [EMAIL PROTECTED], if anyone could send me a word doc, I would be eternally grateful! Thanks, Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX Oracle and SQL Server Fun
Interesting, though I can not think of any data center I have worked with that would be happy with a request to do such a link.Then again the guys around here in the data centers are set in their ways and never like change.I'd have to wonder if after linking databases if it is faster than just copying the data over with a DTS package then manipulating it however you need to. On Tue, 10 Aug 2004 11:41:10 -0400, James Blaha [EMAIL PROTECTED] wrote: Aaron, Check this out: http://www.winnetmag.com/SQLServer/Article/ArticleID/22264/SQLServer_22264.html Regards, -JB [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Search Engine Optimization
Ryan, I can highly recommend a site called webmasterworld.com.Searching their forums will teach you anything you need to know about search engine optimization. There is also Brett Tabke's famous 26 steps for 15K a day.It's a bit dated but a good starting point. http://www.searchengineworld.com/misc/guide.htm Rick Mason - Original Message - From: Ryan Mannion [EMAIL PROTECTED] Date: Tue, 10 Aug 2004 12:08:20 -0400 Subject: Search Engine Optimization To: CF-Talk [EMAIL PROTECTED] I know this is a little off topic, but does anyone have any specific techniques they use to get the most out of thier listing in Search engines? Other than, the title tag, the amount of times the words are listed in the page etc, submitting to search engines directly, as well as having many links to your site as possible from other sites. Any help would be appreciated . Thanks Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Flash lists
Hey all, Does anyone know of a Flash list like CF-Talk? We are getting into using flash more and more and have some questions that we need answered and I don't want to keep bothering you guys with OT stuff. Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Flash lists
http://chattyfig.figleaf.com/ Hey all, Does anyone know of a Flash list like CF-Talk? We are getting into using flash more and more and have some questions that we need answered and I don't want to keep bothering you guys with OT stuff. Thanks, Steve _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Flash lists
IMHO Flashcoders is a good list: http://chattyfig.figleaf.com (Tip- avoid FlashLounge unless you're *really* into OT posts.Actual Flash postings on that list are rare...) HTH! - Scott scott fegette macromedia, inc. http://www.macromedia.com/go/blog_sfegette From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 10, 2004 11:40 AM To: CF-Talk Subject: OT: Flash lists Hey all, Does anyone know of a Flash list like CF-Talk? We are getting into using flash more and more and have some questions that we need answered and I don't want to keep bothering you guys with OT stuff. Thanks, Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Is this too much?
I have a function called eccnLookUp() that accepts one argument named PartNumber. In another cfc I need to do 5 calls to this function and pass in 5 different part numbers. Would this be a huge hit on the server to do it like: cfset variables.partNum1 = variables.sampleDAO.eccnLookUp(#sampleInfo.getSample().getPartNum1()#) / cfset partNumList = listAppend(partNumList,variables.partNum1.ECCN,,)/ cfset variables.partNum2 = variables.sampleDAO.eccnLookUp(#sampleInfo.getSample().getPartNum2()#) / cfset partNumList = listAppend(partNumList,variables.partNum2.ECCN,,)/ cfset variables.partNum3 = variables.sampleDAO.eccnLookUp(#sampleInfo.getSample().getPartNum3()#) / cfset partNumList = listAppend(partNumList,variables.partNum3.ECCN,,)/ cfset variables.partNum4 = variables.sampleDAO.eccnLookUp(#sampleInfo.getSample().getPartNum4()#) / cfset partNumList = listAppend(partNumList,variables.partNum4.ECCN,,)/ cfset variables.partNum5 = variables.sampleDAO.eccnLookUp(#sampleInfo.getSample().getPartNum5()#) / cfset partNumList = listAppend(partNumList,variables.partNum5.ECCN,,)/ Thanks, Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SQL help!
This is probably basic, but my brain is not functioning at this point today... I need to compare two tables. They both contain customer numbers. One table mimics the other so the same data *should* be in each. It has come to my attention that there are orphans in one of the tables. What I'd like to do is compare one table against the other, find the orphans in that table and list them out. Then vice versa with the other table. I was attempting to do a Inner join but it didn't seem to work. Anyone with ideas? Thanks. Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL help!
At 03:18 PM 8/10/2004, you wrote: This is probably basic, but my brain is not functioning at this point today... I need to compare two tables. They both contain customer numbers. One table mimics the other so the same data *should* be in each. It has come to my attention that there are orphans in one of the tables. What I'd like to do is compare one table against the other, find the orphans in that table and list them out. Then vice versa with the other table. I was attempting to do a Inner join but it didn't seem to work. Anyone with ideas? You could do something like... SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM table2) SELECT * FROM table2 WHERE id NOT IN (SELECT id FROM table1) Not super-fab, but it'll show you what's in one that isn't in the other... -- Phillip Beazley Onvix -- Website Hosting, Development E-commerce Visit http://www.onvix.com/ or call 727-578-9600. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Search Engine Optimization
Ryan, I've had tons of success with coding my applications so that I can go into the admin and write out the site in static HTML. Most of the big search engines are getting better at being able to crawl dynamic sites, but they crawl like mad when it's good ole static HTML text.Also, make sure you don't have any broken links... If you can offer any affiliate-type marketing partnerships, you will be able to easily boost your page rank and link popularity because of how many people will highlight your site in an effort to earn commissions. What I do with my affiliate programs is that I pay very good commissions, but I only offer the program to sites with very high page ranking and newsletters with good reach. If you do this, make sure you lay down the law about how your partners are NOT allowed to promote your products or services. You certainly don't want an affiliate bringing DOWN your reputation. One of the other things that you can do to help yourself out is to dedicate significant sections of your site to useful content. If your site is concerned with selling aftermarket Harley Davidson parts, provide as much useful information on HD motorcycles, customizing and riding culture... writing your own articles and syndicating as much content as you can from elsewhere. We all know there are plenty of sources on the internet without even having to plagiarize. The more real, informative content you have on your site, the better you will rank naturally (just be sure to keep it all neatly organized). --Ferg _ I know this is a little off topic, but does anyone have any specific techniques they use to get the most out of thier listing in Search engines? Other than, the title tag, the amount of times the words are listed in the page etc, submitting to search engines directly, as well as having many links to your site as possible from other sites. Any help would be appreciated . Thanks Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFHTTP odd error
I guess I am stressing CFHTTP to much, but maybe someone knows a workaround for my problem. This is actually a follow up on my issue yesterday. I am building a link checker, and these links get validated with cfhttp. When I do about 10 links no errors are returned, all links are checked. However, when I execute more, for ex. 20 or the entire list, CFHTTP bugs. This is the executed template: http://mschopman.demon.nl/bug.cfm (takes a while, is running cfhttp requests) This is the source of the template (use it if you want in your own apps, I don't mind sharing) http://mschopman.demon.nl/bug.txt I thought maybe about using locks, I don't know if race conditions are responsible for this behaviour of CFHTTP. What I have left is calling a sleep between iterations, using a queue, with 10 links each time etc. But maybe there is a simple solution. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL help!
Quick and dirty .and it worked like a charm.. Thanks IN was where I shoulda been looking... Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL help!
SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM table2) SELECT * FROM table2 WHERE id NOT IN (SELECT id FROM table1) Yes, and may be UNION the two in one: SELECT id FROM table1 WHERE id NOT IN (SELECT id FROM table2) UNION SELECT id FROM table2 WHERE id NOT IN (SELECT id FROM table1) However, if the tables are big tables, this might kill the server, so may be using LEFT JOINs could be more efficient in this case: SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id = table2.id WHERE table2.id IS NULL I didn't test it, but this should select records in table1 that have no match in table2 Then invert the quey for the othe table. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [ HTML-Kit ] Users, new CFMX plugin
is this an editor? Dan - Original Message - From: Daniel Farmer [EMAIL PROTECTED] Date: Tue, 10 Aug 2004 13:41:36 -0400 Subject: [ HTML-Kit ] Users, new CFMX plugin To: CF-Talk [EMAIL PROTECTED] Just wanted to share this with the cf community. I've created a plugin for HTML kit that includes all the common CFMX6.1 tags and functions...it's basically a new version of the current plugin mgColdfusion, but updated for CFMX 6.1. Enjoy! http://www.chami.com/html%2Dkit/plugins/info/dfcfmx/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP odd error
CFHTTP bugs. Could it be a time limit? Especially if one of the url is down. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP odd error
Then CFHTTP would return a non CF error, with a statuscode telling me the url failed to load. That is why I use retry possibilites in the code. Sometimes an url fails to load, then it is retried according to the settings, until it reaches a maximum retry amount. Then the url is noted as failed. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFHTTP odd error
Then CFHTTP would return a non CF error, with a statuscode telling me the url failed to load. That is why I use retry possibilites in the code. Sometimes an url fails to load, then it is retried according to the settings, until it reaches a maximum retry amount. Then the url is noted as failed. I don't think the CFHTTP.StatusCode variable contains a useful message in the event of a timeout. If I recall correctly, it only contains the HTTP status code returned by the remote server. If the request times out, you haven't gotten any response from the remote server. I could be wrong about this, since I don't use CFHTTP much. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [ HTML-Kit ] Users, new CFMX plugin
On Aug 10, 2004, at 3:34 PM, Dan O'Keefe wrote: is this an editor? HTML Kit is an editor for Windows.It supports a wide variety of file formats (for syntax highlighting, etc) and has a plugin interface which has allowed others to write a wide array of, well, plugins. I tried it a few years ago but the whole thing felt very clunky to me, and slow.Better than notepad, but I was faster in EditPlus or Dreamweaver. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 Nothing endures but change. - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ColdFusion default Client Variable Storage, how robust?
Does anyone know how robust/scalable is those FoxPro/DBase IV/DBase V driver for Client Variable database?We got about 12,000+ unique session created in a day and the database size has grown close to 500MB.We also experienced sporadic missing client variables. Does external native ODBC DB like MySql work better than those?BTW, we are an UNIX shop. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL help!
That union worked well too... thanks! Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ColdFusion default Client Variable Storage, how robust?
I think that MySQL would be a much more robust option than FoxPro. You could also consider PostgreSQL, or if possible, Oracle. - Original Message - From: Sumito Hamdyl [EMAIL PROTECTED] Date: Tue, 10 Aug 2004 15:45:17 -0400 Subject: ColdFusion default Client Variable Storage, how robust? To: CF-Talk [EMAIL PROTECTED] Does anyone know how robust/scalable is those FoxPro/DBase IV/DBase V driver for Client Variable database?We got about 12,000+ unique session created in a day and the database size has grown close to 500MB.We also experienced sporadic missing client variables. Does external native ODBC DB like MySql work better than those?BTW, we are an UNIX shop. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: advice on structure and cfcs (petmarket related)
On Tue, 10 Aug 2004 12:37:04 -0400, stylo stylo [EMAIL PROTECTED] wrote: I'm not interested in Fusebox, and MachII is a bit much to begin with, maybe later. I am worried, however, about the speed of MachII. I thought FB3 apps ran slowly, and MachII is apparently slower, no? Macromedia has about a dozen Mach II applications on macromedia.com handling thousands of concurrent users with no problem so I wouldn't get too hung up on 'performance'... -- Sean A Corfield -- http://www.corfield.org/blog/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP odd error
This is returned with: A invalid url (for ex: _javascript_: links): Connection Failure. Status code unavailable. A bogus url (for ex: www.mschopman.nl): 408 Request Time-out With settings on aggresive I see it made 1 attempt to check the url. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: Help with textarea
Hi all. Is there a way to dynamically resize a textarea element (ie. add rows as the number of lines in the textarea increases)? My users only want one line in the form but as people type they what the textarea to expand automatically. I can do it to a text field but not the textarea. Thanks, Mario http://www.houseoffusion.com/banners/view.cfm?bannerid=35 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP odd error
When I call a non existing url I get: 408 Request Time-out When I call an invalid formed url: Connection Failure. Status code unavailable. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP odd error
When I call a non existing url I get: 408 Request Time-out When I call an invalid formed url: Connection Failure. Status code unavailable. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: many IPS or one?
I have a sort of off-topic question for you guys concerning hosting set-ups.We have about 89 domains that we are currently hosting at XO communications for cheap cheap money.All of them are static sites - html only - we do our CF hosting elsewhere (I'll leave 'who' up to your imaginations to avoid 'my host is better than yours' conversations).Recently, XO decided that they are going to start charging us an arm and a leg for our hosting, yet still keep the same crappy customer service and questionable uptime.So, we have started to look elsewhere for hosting options.The cheapest option given to us from most hosting companies is using one IP address and having all sites reside under the one IP using IIS redirects (I guess, I'm not an IIS guy).We are used to having one IP per domain at XO... My boss is totally against going this route, but has no reason to do so.What I want to know is why would this matter?Search Engines, etc don't care what our IP address is, right?Are there any real reasons that we should have a separate IP for every account, even if we were to bundle all of our CF accounts into one host?The hosting companies are reputable large (not cheap or crappy service) companies, so those things are not an issue, we have already weeded out the dregs... Thanks for the insights! Ray = Ray Champagne - Senior Application Developer CrystalVision Web Site Design and Internet Services 603.433.9559 www.crystalvision.org = The information contained in this transmission (including any attached files) is CONFIDENTIAL and is intended only for the person(s) named above. If you received this transmission in error, please delete it from your system and notify us immediately. If you are not an intended recipient, please note that any use or dissemination of the information contained in this transmission (including any attached files) and the copying, printing, or retransmission of that information is strictly prohibited. You can notify us by return email or by phone at 603.433.9559. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]