RE: CFMX Taking all CPU Resources? (CODE)
On another machine we tried the same tests and found the code took 1680ms to run 1000 iterations. Interestingly enough we rewrote Sean's code in Java and retried the tests. From Java we could do 1000 iterations in 1265ms. The Java code is below. import java.util.*; import java.io.*; import org.xml.sax.*; import com.allaire.wddx.*; public class STest { String xmlContent = null; WddxDeserializer deserializer = null; public STest(String filePath) throws Exception { deserializer = new WddxDeserializer("org.apache.xerces.parsers.SAXParser"); readInXML(filePath); } public static void main(String args[]) { try { if (args.length < 2) { System.out.println("Usage: alchemy.STest filepath deserializations [iterations]"); return; } int iterations = 1; if (args.length == 3) iterations = Integer.parseInt(args[2]); STest test = new STest(args[0]); for (int i=0; ihttp://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] > -Original Message- > From: Matt Liotta [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 10:22 AM > To: CF-Talk > Subject: RE: CFMX Taking all CPU Resources? (CODE) > > P3 866 384 RAM CFMX (2543ms) > > Using the below code on the same machine (5908ms) > > > > > > > > tempDoc = XmlParse(temp); > ctemp = StructNew(); > > for(itr = 1; itr lte > ArrayLen(tempDoc.wddxpacket.data.struct.XmlChildren); itr = itr + 1) > StructInsert(ctemp, > tempDoc.wddxpacket.data.struct.var[itr].XmlAttributes.name, > tempDoc.wddxpacket.data.struct.var[itr].XmlChildren[1].XmlText); > > > > #GetTickCount() - request.StartTime# ms > > > > Matt Liotta > President & CEO > Montara Software, Inc. > http://www.montarasoftware.com/ > V: 415-577-8070 > F: 415-341-8906 > P: [EMAIL PROTECTED] > > > -Original Message- > > From: Sean A Corfield [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 31, 2002 9:11 AM > > To: CF-Talk > > Subject: Re: CFMX Taking all CPU Resources? (CODE) > > > > On Tuesday, July 30, 2002, at 10:27 , Joe Eugene wrote: > > > Below are the details of the code that is running slow on CFMX. > > > > I've put together a very simple test to time wddx2cfml on various > systems. > > I don't have CF5 to run it on but hopefully some folks here will be > able > > to confirm / deny the speed differences. > > > > Two files: > > - xfile.cfm reads the WDDX packet and then times cfwddx repeatedly > > deserializing it > > - joe.wddx is Joe's WDDX (with a correction: there's a missing > > > on line 34!) > > > > I tested this on a PowerMac G4 800MHz with > > http://127.0.0.1/xfile.cfm?loop= > > 1000 and it consistently executed in 4000ms. > > > > xfile.cfm: > > > > > > > > > > > > > > > > > > > > > > #GetTickCount() - request.StartTime# ms > > > > > > > > > > joe.wddx: > > > name='ALTTAG'>MS Commercial > name='BODY'>All MS® models are made in the > USA to > > the highest quality standards.
The > > MS® Series grew out of our decades of experience with > > HighlineTM, Trimline, and units combined with > the > > time-proven technologies of The Asian® series. All MS® > > models are made in the USA to the highest quality standards. > >
> code='0A'/>Key Distinguishing Feature
> code='0A'/>North America
> cellSpacing=0 cellPadding=3 width="100%" border=0> > code='0A'/>
> code='0A'/>code='0A'/> > class=headerWhite bgColor=#ff6633>Related Links and > > Brochures: > href="http://@url@/pdfs/P1903.pdf">The MS Series - Commercial > > (PDF)
> name='CONTENTITEMID'>11 > name='CONTENTTYPEID'>PMP > name='DESCRIPTION'>MS Commercial have mechanical non-computing > > specifically designed for industrial, and fleet > > applications. name='ERRORS'> > name='FILES'>com.jpg,P103.pdf > name='KEYWORDS'>, industrial, fleet, north > > america > name='NAVTEXT'>MS-Commercial > name='PUBLISHDATE'>2002-3-7T0:0:0-5:0 > name='PUBLISHDAY'>07 > name='PUBLISHMONTH'>3 > name='PUBLISHYEAR'>2002 > name='TITLE'>The > > MS Series - Commercial > name='UPLOADIMAGE'>2A2.8_MS_com.jpg > name='UPLOADPDF'>P1903.pdf > name='USERNAME'>abc > name='VERSIONNUMBER'>42 > name='VERSIONSTATUSID'>PUB > > > > > > Sean A Corfield -- http://www.corfield.org/blog/ > > > > "If you're not annoying somebody, you're not really alive." > > -- Margaret Atwood > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: X-server?
Dick Applebaum wrote: > You can get most of the function of Verity with a open source package > called Glimpse -- I think the latest version is available at: > > http://webglimpse.org/ > > It is Perl-based only (AFAIK), but that's no problem as Mac OS X > includes Perl with every installation > > I used glimpse quite a bit in the 1997 time frame, when I was > programming Perl sites > > Pretty good package, fast, complete - no stemming, though > > Anyway, there are other excellent packages such as imageMagik, that > probably could be interfaced through Perl. There is even a Coldfusion custom tag set that works with imagemagick Jesse __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: OS X Web Services Running! was Re: X-server?
On Wednesday, July 31, 2002, at 10:06 , Sean A Corfield wrote: > Access a web service (e.g., the Amazon one) and lo and behold!! Here's a simple example (you'll need to sign up for the Amazon developer program and get your own developer tag to go in this code!): Amazon Keyword Search http://soap.amazon.com/schemas/AmazonWebServices.wsdl"; method= "KeywordSearchRequest" KeywordSearchRequest="#kwReq#" returnvariable="amazon"/> Books matching #kwReq.keyword#: #details[i].getProductName()# by #authors# #details[i].getListPrice()# #details[i].getOurPrice()# __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
Statistics for dynamic data websites
Hi All, I *know* this has been said before, but can't find it anywhere (& yes, I have searched the archives, and used google). Can anyone give me a good statistics package for use with a dynamic website. Something that can handle query strings indicating what the content is. I've looked at Urchin, WebTrends (any ideas on the price? can't find it on the website), LiveStats (can it handle dynamic data?), NetTracker Enterprise, and Summary. Any other ideas? Any recomendations? Please reply directly as well as to the list as I am on digest. Thanks, Cameron 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: reg ex again
On Wednesday, July 31, 2002, at 07:45 , S. Isaac Dealey wrote: > You lucky bastard. :) It's actually a real advantage (or it will be if it' > s > not already) that most of your experience is after the migration to J2EE, > since that means your head hasn't been pre-filled with issues which only > existed in older versions of the server. This is true of any newer > version, > but much more so with MX because of the move from C++ to Java -- > full-scale > core-system changes carry so many more differences than new versions on > the > same basic platform. I guess so. But my background is compiler theory and language design with eight years of C++ development and five years of Java so I would probably be approaching even CF5 with a very different viewpoint to most CFers. I actually feel a bit embarrassed that I don't know more about CF5 and can only really talk knowledgeably about CFMX... I think CF rocks tho'! Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: OS X Web Services Running! was Re: X-server?
On Wednesday, July 31, 2002, at 04:23 , Dick Applebaum wrote: > I also put a copy of java2wsdl.jar and wsdl2java.jar in the same folder. Don't need 'em. You need tt-bytecode.jar which is part of the axis-1_0 distribution. Download the "Beta 3" .tar.gz from http://xml.apache.org/axis/index.html - inside axis-1_0/lib you'll find tt-bytecode.jar - cp it to /Library/Java/Extensions/ You also need xmlParserAPIs.jar which is part of the Xerces Java 2 distribution which you can download from http://gump.covalent.net/jars/latest/xml-xerces2/ - cp that to /Library/Java/Extensions/ I also cp webservices.jar from the CF runtime/lib to there but I haven't verified whether it's actually necessary. Access a web service (e.g., the Amazon one) and lo and behold!! "If you're not annoying somebody, you're not really alive." -- Margaret Atwood __ Get the mailserver that powers this list at http://www.coolfusion.com 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
ColdFusion Scheduler creates hung process
I saw a post on this forum regarding a problem where if you: (1) Don't specify an output file (2) Get a long output from your executable then you get a hung process on your server. Has anybody experienced a similar problem with the ColdFusion Scheduler ? I am not using , just have created the schedule to run daily in ColdFusion Administrator. It's a highly database-intensive process, which dynamically generates and sends out emails. 9 times out of 10, it runs fine, requiring anything from 12-20 minutes for execution. However, in about 1 of 10 cases, the schedule executes completely but doesn't exit. It continues to run and eventually times out, at the RequestTimeout interval specified in CF Administrator. It also pushes up CPU utilisation to 99%, and virtually hangs the machine, requiring a restart of the CF Application Server service. Has anyone experienced a similar problem or have any suggestions on troubleshooting it ? My scheduler refresh interval is 15 minutes, lower than the usual time of execution of this schedule. The requesttimeout period is set to a very high value, nearly 80 minutes. The template executed in the schedule contains some cfoutput tags, used for debugging purposes. However, the output from this template is not being logged. Could any of these be causing this hung process ? I am running CF 4.5 on Win 2K, IIS5, and SQL 2000 DB. Vishal. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
ColdFusion Scheduler creates hung process
I saw a post on this forum regarding a problem where if you: (1) Don't specify an output file (2) Get a long output from your executable then you get a hung process on your server. Has anybody experienced a similar problem with the ColdFusion Scheduler ? I am not using , just have created the schedule to run daily in ColdFusion Administrator. It's a highly database-intensive process, which dynamically generates and sends out emails. 9 times out of 10, it runs fine, requiring anything from 12-20 minutes for execution. However, in about 1 of 10 cases, the schedule executes completely but doesn't exit. It continues to run and eventually times out, at the RequestTimeout interval specified in CF Administrator. It also pushes up CPU utilisation to 99%, and virtually hangs the machine, requiring a restart of the CF Application Server service. Has anyone experienced a similar problem or have any suggestions on troubleshooting it ? My scheduler refresh interval is 15 minutes, lower than the usual time of execution of this schedule. The requesttimeout period is set to a very high value, nearly 80 minutes. The template executed in the schedule contains some cfoutput tags, used for debugging purposes. However, the output from this template is not being logged. Could any of these be causing this hung process ? I am running CF 4.5 on Win 2K, IIS5, and SQL 2000 DB. Vishal. __ Get the mailserver that powers this list at http://www.coolfusion.com 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: creating tables on the fly? Should I or Shouldn't I?
Personally... I would create a good relational tables structure without any data replication... this should be fairly sufficient. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:21 PM To: CF-Talk Subject: creating tables on the fly? Should I or Shouldn't I? I posted this before, but got no response. Does any one know if this is sound/standard practice and if it makes any sense in this context? Just a nudge in the right direction in all I need. Thanks! - I am designing an email application that will be used by multiple (100's - 1000's) of users. Each user will have their own account. When they send mail, the recipients are recorded to a table. this table is basically just a reference to the full recipient record and the email campaign id. If each user is sending email campaigns of 25,000 recipients + what is the best way to record and later generate reports on this data. Would it make sense to generate a campaign recipient table on the fly for each user of the system upon registration or first use? This way the total records per table would be a bit more manageable for report generation later. Is this sound practice? Or should I just have one huge table shared by all the systems users. I could see this table growing to 20,000,000 records within time. Would select statements and report generation on subsets of data from this monster table be slow? (SQL7) Are there benefits to leaving all of the data in one big table as opposed to generating this table on the fly for each user, therefor keeping the total size down? The table which holds the email campaigns recipients will need to be used in a number of joins to include additional email delivery stats. What do you think? Brook Davies maracasmedia inc. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: cfsavecontent
> so, do you think this should work? > > > > > > > > > > > > btw, the value of final chop, is about 1900 characters of > xml code, a response from an asp web service, that has > been len()'d then lefted and righted to get a middle > section, the only section i need, then parse in this new > variable called "tony" > > to then write to a cffile xml file. Yep, that should work... The problem you're having really isn't with the tho, it's with the xml parsing ... which is probably significantly more complex than the savecontent tag... I'd need ( or anyone on the list would need ) a lot more information about where this xml packet is coming from and where it's going and what its format is in order to provide any really helpful advice... Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
CFSERVLET "Could not connect to JRun Connector Proxy" error
Can't connect to a servlet using cfservlet tag in CF 4.5 sp2 JRun default server is definitely running as well as the external connector. The local.properties file reveals its using port 51000 ,which is the default port. Since everything else seems to be working like it should with jrun, i don't see this being a jrun issue. Anybody had this before ? -- Visit "The Most Powerful Tool on the Farm" at http://www.ifarm.com Get the latest on Ag News, Market Reports, FREE email, and much more. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: cfsavecontent
so, do you think this should work? btw, the value of final chop, is about 1900 characters of xml code, a response from an asp web service, that has been len()'d then lefted and righted to get a middle section, the only section i need, then parse in this new variable called "tony" to then write to a cffile xml file. tony -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 11:00 PM To: CF-Talk Subject: RE: cfsavecontent > heres whats not parsing > > > > > its returning this: > > and thats not correct. That's a problem with the xmlFormat() function -- or the way it's being used -- I'm not familiar with the function, so I don't know what it's supposed to do, although my _guess_ ( if I had to guess ) would be that it's intended to make a string "xml-safe" like jsstringformat() does for javascript or the way that htmleditformat() makes a string "html-safe" ... What is the value of FinalChop prior to using the xmlFormat() function on it? And what is the expected output? Incidentally, you don't need the single-quotes or the pound-symbols surrounding FinalChop ... #xmlFormat(finalChop)# should do the same thing, and with less typing, is easier to read and slightly more efficient for the parser. Final thing -- I would still recommend putting the tags outside the tags if for no other reason than legibility ... that way, they're not muddling up the xml packet in your code, and the xml packet should be easier to read. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: cfsavecontent
> heres whats not parsing > > > > > its returning this: > > and thats not correct. That's a problem with the xmlFormat() function -- or the way it's being used -- I'm not familiar with the function, so I don't know what it's supposed to do, although my _guess_ ( if I had to guess ) would be that it's intended to make a string "xml-safe" like jsstringformat() does for javascript or the way that htmleditformat() makes a string "html-safe" ... What is the value of FinalChop prior to using the xmlFormat() function on it? And what is the expected output? Incidentally, you don't need the single-quotes or the pound-symbols surrounding FinalChop ... #xmlFormat(finalChop)# should do the same thing, and with less typing, is easier to read and slightly more efficient for the parser. Final thing -- I would still recommend putting the tags outside the tags if for no other reason than legibility ... that way, they're not muddling up the xml packet in your code, and the xml packet should be easier to read. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: cfsavecontent
and even putting the cfoutput tags around that, cfsavecontent tag, it still doesnt work? tw -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:57 PM To: CF-Talk Subject: RE: cfsavecontent heres whats not parsing its returning this: and thats not correct. tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:44 PM To: CF-Talk Subject: RE: cfsavecontent ok, well, for some reason, it doesnt seem to be working? let me try again tw -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:57 PM To: CF-Talk Subject: Re: cfsavecontent What do you mean? This is exactly what does. The outputted variable WILL contain the code executed between the start and end tag. #mtVar# #str# At 10:31 PM 31/07/02 -0400, you wrote: >hi. > >is there a way to parse #mtVar# >inside the tag? > >like this > > > > > #mtVar# > > > > >if so, how? HELP :) > > >...tony > >tony weeg >[EMAIL PROTECTED] >www.revolutionwebdesign.com >rEvOlUtIoN wEb DeSiGn >410.334.6331 > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: cfsavecontent
heres whats not parsing its returning this: and thats not correct. tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:44 PM To: CF-Talk Subject: RE: cfsavecontent ok, well, for some reason, it doesnt seem to be working? let me try again tw -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:57 PM To: CF-Talk Subject: Re: cfsavecontent What do you mean? This is exactly what does. The outputted variable WILL contain the code executed between the start and end tag. #mtVar# #str# At 10:31 PM 31/07/02 -0400, you wrote: >hi. > >is there a way to parse #mtVar# >inside the tag? > >like this > > > > > #mtVar# > > > > >if so, how? HELP :) > > >...tony > >tony weeg >[EMAIL PROTECTED] >www.revolutionwebdesign.com >rEvOlUtIoN wEb DeSiGn >410.334.6331 > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: cfsavecontent
> hi. > > is there a way to parse #mtVar# > inside the tag? > > like this > > > > > #mtVar# > > > > > if so, how? HELP :) Yep, that's the purpose of ... I would put the tags outside the tag ... This then is a very fast and easy way to generate xml packets for whatever your purposes happen to be... As a matter of fact, if it weren't for the fact that there's already a native parser to create WDDX packets, I'd probably be creating them this way. :) Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: reg ex again
>> but ... why assuming CFMX? This works beautifully on >> CF 5 -- minus the trailing / since CF 5 and before >> weren't technically xml languages. > > I don't have CF5 here to check whether cfdump was > available - I knew it wasn't in some earlier release but > wasn't sure when it actually appeared > > (I used CF5 for only about a month before I changed to > CFMX, back in September/October last year!). You lucky bastard. :) It's actually a real advantage (or it will be if it's not already) that most of your experience is after the migration to J2EE, since that means your head hasn't been pre-filled with issues which only existed in older versions of the server. This is true of any newer version, but much more so with MX because of the move from C++ to Java -- full-scale core-system changes carry so many more differences than new versions on the same basic platform. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com 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: cfsavecontent
ok, well, for some reason, it doesnt seem to be working? let me try again tw -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:57 PM To: CF-Talk Subject: Re: cfsavecontent What do you mean? This is exactly what does. The outputted variable WILL contain the code executed between the start and end tag. #mtVar# #str# At 10:31 PM 31/07/02 -0400, you wrote: >hi. > >is there a way to parse #mtVar# >inside the tag? > >like this > > > > > #mtVar# > > > > >if so, how? HELP :) > > >...tony > >tony weeg >[EMAIL PROTECTED] >www.revolutionwebdesign.com >rEvOlUtIoN wEb DeSiGn >410.334.6331 > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: cfsavecontent
What do you mean? This is exactly what does. The outputted variable WILL contain the code executed between the start and end tag. #mtVar# #str# At 10:31 PM 31/07/02 -0400, you wrote: >hi. > >is there a way to parse #mtVar# >inside the tag? > >like this > > > > > #mtVar# > > > > >if so, how? HELP :) > > >...tony > >tony weeg >[EMAIL PROTECTED] >www.revolutionwebdesign.com >rEvOlUtIoN wEb DeSiGn >410.334.6331 > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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 GetDate()
Have you tried this in Query Analyser? SQL 7? like insert into table values(field1,.,GetDate()) Check to see whether your Field of "DateTime" Type? Joe -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 7:56 PM To: CF-Talk Subject: RE: SQL GetDate() > I did exactly that...defined in Ent Man as GetDate(), left > it blank in the insert statement, but get this error: > DIAGNOSTIC: > ODBC Error Code = 22008 (Datetime field overflow) > [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax > error converting > datetime from character string. My first guess would be that there is a space-character at the beginning of your default definition, i.e. " GETDATE()" ... Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
cfsavecontent
hi. is there a way to parse #mtVar# inside the tag? like this #mtVar# if so, how? HELP :) ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: One Last Duh: CFSET getting variable value (cancel)
DUH. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Eric Hoffman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:58 PM To: CF-Talk Subject: One Last Duh: CFSET getting variable value Been awhile since the brain has not overloaded. What have I missed here to get the value, I don't have sites that cfloop like this often...what I need to do in each of these is somehow plop the value of the form variable...in this instance, product1 in the first loop, product2 in the second loop...what have I missed making this fly besides forgetting how to set dynamic column names??? Insert into customer_orders_prod (order_id, product_id, qty) VALUES (#getnewordernum.newestid#, #productnew#, #qtynew#) Quick refresher much appreciated. Thanks to all for the help I've needed on this "meltdown" week. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions __ Get the mailserver that powers this list at http://www.coolfusion.com 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
One Last Duh: CFSET getting variable value
Been awhile since the brain has not overloaded. What have I missed here to get the value, I don't have sites that cfloop like this often...what I need to do in each of these is somehow plop the value of the form variable...in this instance, product1 in the first loop, product2 in the second loop...what have I missed making this fly besides forgetting how to set dynamic column names??? Insert into customer_orders_prod (order_id, product_id, qty) VALUES (#getnewordernum.newestid#, #productnew#, #qtynew#) Quick refresher much appreciated. Thanks to all for the help I've needed on this "meltdown" week. Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions __ Get the mailserver that powers this list at http://www.coolfusion.com 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: OS X Web Services was Re: X-server?
I have had no luck getting CFMX to recognize the class path for org/w3c/dom/Node either in the startup shell script or the CFMX administrator JVM settings. No doubt, my lack of Java expertise ... I'll do some reading and see if I can make it worh I think that it is close, thanks to Matt Liotta Dick current error Error Occurred While Processing Request org/w3c/dom/Node The Error Occurred in /opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: line 10 8 : 10 : 11 : #varName# 12 : Please Try The Following: * Check the CFML Reference Manual to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 5.14; Mac_PowerPC) Remote Address 127.0.0.1 Referer http://127.0.0.1:8500/mycfmxapps/ Date/Time 31-Jul-02 06:29 PM Stack Trace (click to expand) at cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: 10) at cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: 10) java.lang.NoClassDefFoundError: org/w3c/dom/Node at coldfusion.xml.rpc.XmlRpcServiceImpl$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(Unknown Source) at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(Unknown Source) at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebService(Unknown Source) at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebServiceProxy(Unknown Source) at coldfusion.tagext.lang.InvokeTag.doEndTag(Unknown Source) at cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: 10) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java: 294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) On Wednesday, July 31, 2002, at 05:45 PM, Dick Applebaum wrote: > I found it in DWMX, not in CFMX > > That changed the error > > now it can't find: > > java.lang.NoClassDefFoundError: org/w3c/dom/Node > > > But, I do have that in several places WebObjects and several others. > > The most promising looks to be > > /System/Library/Frameworks/JavaXML.framework/WebServerResources/Java/orgw3c/ > dom/Node.class > > I'll put that in my classpath and see what happens > > Thanks > > Dick > On Wednesday, July 31, 2002, at 05:19 PM, Matt Liotta wrote: > >> I found the class in tt-bytecode.jar, which was part of the Axis >> distribution. Not sure where the class is supposed to be. >> >> Matt Liotta >> President & CEO >> Montara Software, Inc. >> http://www.montarasoftware.com/ >> V: 415-577-8070 >> F: 415-341-8906 >> P: [EMAIL PROTECTED] >> > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: reg ex again
HI, My name is now "mr. hits send to early" again, thanks anyway, but i just figgered it out :) trust thyself, and thee shall succeed young gwasshoppa. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 9:07 PM To: CF-Talk Subject: reg ex again hi there ','#Chop1#')#> do i need to do something special to the characters that might be special character, (i suck at RegExp's) thanks. tony -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 9:04 PM To: CF-Talk Subject: Re: Good CFCatch code On Wednesday, July 31, 2002, at 02:39 , S. Isaac Dealey wrote: >> but ... why assuming CFMX? > This works beautifully on CF 5 -- minus the trailing / since CF 5 and > before > weren't technically xml languages. I don't have CF5 here to check whether cfdump was available - I knew it wasn't in some earlier release but wasn't sure when it actually appeared (I used CF5 for only about a month before I changed to CFMX, back in September/October last year!). Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
reg ex again
hi there ','#Chop1#')#> do i need to do something special to the characters that might be special character, (i suck at RegExp's) thanks. tony -Original Message- From: Sean A Corfield [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 9:04 PM To: CF-Talk Subject: Re: Good CFCatch code On Wednesday, July 31, 2002, at 02:39 , S. Isaac Dealey wrote: >> but ... why assuming CFMX? > This works beautifully on CF 5 -- minus the trailing / since CF 5 and > before > weren't technically xml languages. I don't have CF5 here to check whether cfdump was available - I knew it wasn't in some earlier release but wasn't sure when it actually appeared (I used CF5 for only about a month before I changed to CFMX, back in September/October last year!). Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Good CFCatch code
On Wednesday, July 31, 2002, at 02:39 , S. Isaac Dealey wrote: >> but ... why assuming CFMX? > This works beautifully on CF 5 -- minus the trailing / since CF 5 and > before > weren't technically xml languages. I don't have CF5 here to check whether cfdump was available - I knew it wasn't in some earlier release but wasn't sure when it actually appeared (I used CF5 for only about a month before I changed to CFMX, back in September/October last year!). Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: creating tables on the fly? Should I or Shouldn't I?
I would say providing such granularity gets expensive... Not that should or shouldn't do it... from my take you have a database that looks like: ID (autonumber) email_address (text) email_campaign (numerical) subscriber_identifier (numerical) - relates to the particular user generating the email If you have 25,000 as a hard max on per mail mailings, then worst case is 25,000 x users x duration of logging... Every 40 power users per day adds a million rows of data... 400 power users equals 10 million rows Growth is exponential. Manageability of the data is paramount to making the system work in my opinion So historical data should be 'warehoused' after so many days and made available in less than live time web response atmosphere... Multiple tables won't work in this scenario... due to volume and limits on indexes, overhead, etc I am sure someone will say otherwise... it's just an expensive road to travel... The one table approach is wonderful, because you can bulk remove old data from it in one big query... the other route would mean multiple efforts to trim each set of data... more operations, more likelihood for error... I run queries against a several million column access database with success... SQL varieties (MSSQL and MySQL) should fair well for multiple user environments. You should attempt to precompile things on schedule to another table with stats, long and large term stuff... The only thing people should live time be requesting is active campaign data... Noted, that this is a logging application... This is the type of stuff that normally breaks things... -paris Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com (p) 1-212-655-4477 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:21 PM To: CF-Talk Subject: creating tables on the fly? Should I or Shouldn't I? I posted this before, but got no response. Does any one know if this is sound/standard practice and if it makes any sense in this context? Just a nudge in the right direction in all I need. Thanks! - I am designing an email application that will be used by multiple (100's - 1000's) of users. Each user will have their own account. When they send mail, the recipients are recorded to a table. this table is basically just a reference to the full recipient record and the email campaign id. If each user is sending email campaigns of 25,000 recipients + what is the best way to record and later generate reports on this data. Would it make sense to generate a campaign recipient table on the fly for each user of the system upon registration or first use? This way the total records per table would be a bit more manageable for report generation later. Is this sound practice? Or should I just have one huge table shared by all the systems users. I could see this table growing to 20,000,000 records within time. Would select statements and report generation on subsets of data from this monster table be slow? (SQL7) Are there benefits to leaving all of the data in one big table as opposed to generating this table on the fly for each user, therefor keeping the total size down? The table which holds the email campaigns recipients will need to be used in a number of joins to include additional email delivery stats. What do you think? Brook Davies maracasmedia inc. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: OS X Web Services was Re: X-server?
I found it in DWMX, not in CFMX That changed the error now it can't find: java.lang.NoClassDefFoundError: org/w3c/dom/Node But, I do have that in several places WebObjects and several others. The most promising looks to be /System/Library/Frameworks/JavaXML.framework/WebServerResources/Java/orgw3c/ dom/Node.class I'll put that in my classpath and see what happens Thanks Dick On Wednesday, July 31, 2002, at 05:19 PM, Matt Liotta wrote: > I found the class in tt-bytecode.jar, which was part of the Axis > distribution. Not sure where the class is supposed to be. > > Matt Liotta > President & CEO > Montara Software, Inc. > http://www.montarasoftware.com/ > V: 415-577-8070 > F: 415-341-8906 > P: [EMAIL PROTECTED] > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: creating tables on the fly? Should I or Shouldn't I?
I think the question that needs to be answered is do the account holders really want to know exactly when a particular email address was mailed, and what they were mailed, and if so do they really need to do the queries on the fly? Those are the only benfits I can see of keeping track of exactly which emailing a particular email address received. I do see how valuable that kind of info could be in trying to track response though. Maybe if you only stored the complete record of who got emailed what for a certain amount of time? That might make the hardware requirements managable. How about logging the mailing info to a log file, and developing a process to parse the files and generate fancy reports? They couldn't be done on the fly, but there might be an oppurtunity to charge for the reports that way :) As to the question of creating tables on the fly, I don't think it's a good idea...data must be normalized, resistance is futile :) That's my opinion anyway. -- Jon mailto:[EMAIL PROTECTED] Wednesday, July 31, 2002, 8:20:48 PM, you wrote: BD> I posted this before, but got no response. Does any one know if this is BD> sound/standard practice and if it makes any sense in this context? Just a BD> nudge in the right direction in all I need. Thanks! BD> - BD> I am designing an email application that will be used by multiple (100's - BD> 1000's) of users. Each user will have their own account. When they send BD> mail, the recipients are recorded to a table. this table is basically just BD> a reference to the full recipient record and the email campaign id. If each BD> user is sending email campaigns of 25,000 recipients + what is the best way BD> to record and later generate reports on this data. BD> Would it make sense to generate a campaign recipient table on the fly for BD> each user of the system upon registration or first use? This way the total BD> records per table would be a bit more manageable for report generation BD> later. Is this sound practice? Or should I just have one huge table shared BD> by all the systems users. I could see this table growing to 20,000,000 BD> records within time. Would select statements and report generation on BD> subsets of data from this monster table be slow? (SQL7) Are there benefits BD> to leaving all of the data in one big table as opposed to generating this BD> table on the fly for each user, therefor keeping the total size down? The BD> table which holds the email campaigns recipients will need to be used in a BD> number of joins to include additional email delivery stats. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: creating tables on the fly? Should I or Shouldn't I?
Generating tables for users on the fly is liable to be a lot more work both in the short term and especially in the long run. My general feeling is that if you think having separate tables to limit the number of records per would be a significant advantage ( if not necessary for performance purposes, after having exhausted the use of indexes and locking hints ) that you should probably be replicating and load-balancing your database accross multiple servers. I don't have any personal experience with systems which create tables on the fly, however, so I can't say from experience that "it was a disaster" ... it is a semi-unknown -- I know how it can be accomplished with SQL Server using the sp_execsql stored procedure primarily ( that is internally, as opposed to using ColdFusion dynamic queries ) but I haven't actually done it. The fact that there are very few people who have worked with similar systems is another reason for hesitation, since it limits your ability to get help if something goes wrong. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 > I posted this before, but got no response. Does any one > know if this is > sound/standard practice and if it makes any sense in this > context? Just a > nudge in the right direction in all I need. Thanks! > -- > --- > I am designing an email application that will be used by > multiple (100's - > 1000's) of users. Each user will have their own account. > When they send > mail, the recipients are recorded to a table. this table > is basically just > a reference to the full recipient record and the email > campaign id. If each > user is sending email campaigns of 25,000 recipients + > what is the best way > to record and later generate reports on this data. > Would it make sense to generate a campaign recipient table > on the fly for > each user of the system upon registration or first use? > This way the total > records per table would be a bit more manageable for > report generation > later. Is this sound practice? Or should I just have one > huge table shared > by all the systems users. I could see this table growing > to 20,000,000 > records within time. Would select statements and report > generation on > subsets of data from this monster table be slow? (SQL7) > Are there benefits > to leaving all of the data in one big table as opposed to > generating this > table on the fly for each user, therefor keeping the total > size down? The > table which holds the email campaigns recipients will need > to be used in a > number of joins to include additional email delivery > stats. > What do you think? > Brook Davies > maracasmedia inc. > __ > > Signup for the Fusion Authority news alert and keep up > with the latest news in ColdFusion and related topics. > http://www.fusionauthority.com/signup.cfm > 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: OS X Web Services was Re: X-server?
I found the class in tt-bytecode.jar, which was part of the Axis distribution. Not sure where the class is supposed to be. Matt Liotta President & CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] > -Original Message- > From: Dick Applebaum [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 5:04 PM > To: CF-Talk > Subject: Re: OS X Web Services was Re: X-server? > > Thanks Matt > > There is no com nor techtrader nor BCEntity > > anywhere within the Linux install (either as a filename or in the > content of any file) -- I ported everything across as installed. > > Is the above part of the CFMX Linux install? > > If not where do I get it? > > TIA > > Dick > > On Wednesday, July 31, 2002, at 04:37 PM, Matt Liotta wrote: > > >> java.lang.NoClassDefFoundError: > >> com/techtrader/modules/tools/bytecode/BCEntity > > > > Looks like your classpath is still wrong as the above error means that > > the JVM can't find the class > > com.techtrader.modules.tools.bytecode.BCEntity. You should verify that > > that class is in the classpath and/or even exists. > > > > -Matt > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
creating tables on the fly? Should I or Shouldn't I?
I posted this before, but got no response. Does any one know if this is sound/standard practice and if it makes any sense in this context? Just a nudge in the right direction in all I need. Thanks! - I am designing an email application that will be used by multiple (100's - 1000's) of users. Each user will have their own account. When they send mail, the recipients are recorded to a table. this table is basically just a reference to the full recipient record and the email campaign id. If each user is sending email campaigns of 25,000 recipients + what is the best way to record and later generate reports on this data. Would it make sense to generate a campaign recipient table on the fly for each user of the system upon registration or first use? This way the total records per table would be a bit more manageable for report generation later. Is this sound practice? Or should I just have one huge table shared by all the systems users. I could see this table growing to 20,000,000 records within time. Would select statements and report generation on subsets of data from this monster table be slow? (SQL7) Are there benefits to leaving all of the data in one big table as opposed to generating this table on the fly for each user, therefor keeping the total size down? The table which holds the email campaigns recipients will need to be used in a number of joins to include additional email delivery stats. What do you think? Brook Davies maracasmedia inc. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: OS X Web Services was Re: X-server?
Thanks Matt There is no com nor techtrader nor BCEntity anywhere within the Linux install (either as a filename or in the content of any file) -- I ported everything across as installed. Is the above part of the CFMX Linux install? If not where do I get it? TIA Dick On Wednesday, July 31, 2002, at 04:37 PM, Matt Liotta wrote: >> java.lang.NoClassDefFoundError: >> com/techtrader/modules/tools/bytecode/BCEntity > > Looks like your classpath is still wrong as the above error means that > the JVM can't find the class > com.techtrader.modules.tools.bytecode.BCEntity. You should verify that > that class is in the classpath and/or even exists. > > -Matt __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: what scope are the variables in when a template is called via cfh ttp?
Thanks, Shawn. Been working this all day, and my brain is starting to get a bit foggy. Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] >>-Original Message- >>From: Shawn Grover [mailto:[EMAIL PROTECTED]] >>Sent: Wednesday, July 31, 2002 6:46 PM >>To: CF-Talk >>Subject: RE: what scope are the variables in when a template is called via >>cfh ttp? >> >>Local - to within the page request. The requested page is then returned >>via >>the CFHTTP.FileContent (hope I got that right) variable. This variable is >>then local to your calling page. The Called page, is fully rendered at >>this >>time, and you are dealing with the resulting HTML. >> >>Shawn Grover >> >>-Original Message- >>From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] >>Sent: Wednesday, July 31, 2002 5:38 PM >>To: CF-Talk >>Subject: what scope are the variables in when a template is called via >>cfh ttp? >> >> >>I have a template that I am calling via cfhttp. How do I access the >>variables being passed to it? I am passing them via >type="URL" >>name="foo" valuefoo">. In the called template, though, referencing >>"url.foo" throws an error. >> >> __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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 MX performance issue
> CF 5MX JRE 1.3MX JRE 1.4 > 9 KB405060 > 24 KB 240 3300 7000 > 84 KB 670013174000 ah that would explain my "sucky" numbers for cfmx. ah, let them eat i18n cake ;-) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.380 / Virus Database: 213 - Release Date: 24/7/2545 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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 GetDate()
> I did exactly that...defined in Ent Man as GetDate(), left > it blank in the insert statement, but get this error: > DIAGNOSTIC: > ODBC Error Code = 22008 (Datetime field overflow) > [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax > error converting > datetime from character string. My first guess would be that there is a space-character at the beginning of your default definition, i.e. " GETDATE()" ... Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: what scope are the variables in when a template is called via cfh ttp?
Local - to within the page request. The requested page is then returned via the CFHTTP.FileContent (hope I got that right) variable. This variable is then local to your calling page. The Called page, is fully rendered at this time, and you are dealing with the resulting HTML. Shawn Grover -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 5:38 PM To: CF-Talk Subject: what scope are the variables in when a template is called via cfh ttp? I have a template that I am calling via cfhttp. How do I access the variables being passed to it? I am passing them via . In the called template, though, referencing "url.foo" throws an error. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: OS X Web Services was Re: X-server?
> java.lang.NoClassDefFoundError: > com/techtrader/modules/tools/bytecode/BCEntity Looks like your classpath is still wrong as the above error means that the JVM can't find the class com.techtrader.modules.tools.bytecode.BCEntity. You should verify that that class is in the classpath and/or even exists. -Matt __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
what scope are the variables in when a template is called via cfh ttp?
I have a template that I am calling via cfhttp. How do I access the variables being passed to it? I am passing them via . In the called template, though, referencing "url.foo" throws an error. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: OS X Web Services was Re: X-server?
On Wednesday, July 31, 2002, at 02:20 PM, Matt Liotta wrote:
> All of the Web services stuff is in webservices.jar.
>
>
OK, I made webservices.jar accessable to Mac OS X JVM with a quick fix
that works for the jdbc drivers-- putting a copy in
/Library/Java/Extensions *
I also put a copy of java2wsdl.jar and wsdl2java.jar in the same folder.
This still fails, but the nature of the error has changed (below)
* when I first started porting CFMX to OS X, Jesse Noller said I should
look in /runtime/bin/jvm.config
for clue to how the java classpath & parameters should be changed to
reflect that we were using the Mac OSX JVM not the one installed by
CFMX. This was pretty hard from my perspective -- I didn't have the
java source, so I was reverse engineering (in a foreign language). I
changed the parameters as best I could determine (not being a Java
person) to no avail -- these didn't solve the problem I was having at
the tine (not finding the pointbase jdbc driver)
By accident, I stumbled on another driver (not CFMX) in the
/Library/Java/Extensions folder -- I copied the pointbase driver there,
and Voila!, it worked (CFMX forund it).
One thing always bothered me about the jvm.config file -- the
# JVM classpath
java.class.path={application.home}/runtime/../../src,{application.home}/lib/
cfusion.jar,{application.home}/runtime/pointbase/lib/pbclient42RE.jar,
{application.home}/runtime/pointbase/lib/pbembedded42RE.jar,{application.home}
/runtime/pointbase/lib/pbserver42RE.jar,{application.home}/runtime/pointbase/
lib/pbtools42RE.jar,{application.home}/runtime/lib/webservices.jar
As near as I could figure {application.home} should be /opt/coldfusionmx
But, the first path didn't make any sense
{application.home}/runtime/../../src as there was no src folder 2
levels above /runtime/ in the Linux install
When I started having problems with WS compilation, I remembered this --
don't know if it is related or not!
Sure is tedious doing this with a blindfold -- seems as though the right
person, with knowledge of what is supposed to happen and how all the
pieces fit together, would have the necessary info at his fingertips.
As-Is, I've been fiddling with this for about a week.
Anyway here is the failure with the repositioned jar files:
Dick
P.S. I also found some Axis docs among the CFMX docs & am reviewing them
now!
Error Occurred While Processing Request
com/techtrader/modules/tools/bytecode/BCEntity
The Error Occurred in /opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: line
10
8 :
10 :
11 : #varName#
12 :
Please Try The Following:
* Check the CFML Reference Manual to verify that you are using the
correct syntax.
* Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 5.14; Mac_PowerPC)
Remote Address 127.0.0.1
Referer http://127.0.0.1:8500/mycfmxapps/
Date/Time 31-Jul-02 02:59 PM
Stack Trace (click to expand)
at
cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm:
10) at
cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm:
10)
java.lang.NoClassDefFoundError:
com/techtrader/modules/tools/bytecode/BCEntity
at org.apache.axis.wsdl.toJava.Emitter.(Emitter.java:533)
at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(Unknown
Source)
at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(Unknown
Source)
at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebService(Unknown Source)
at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebServiceProxy(Unknown
Source)
at coldfusion.tagext.lang.InvokeTag.doEndTag(Unknown Source)
at
cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm:
10)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown
Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.CfmServlet.service(Unknown Source)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.j
Re: SQL GetDate()
If the field is a datetime field, then either the data is out of
range, or it is invalid. The clock on the server isn't off is it? :)
Try doing the query in query analyzer and see what happens.
--
Jon
mailto:[EMAIL PROTECTED]
Wednesday, July 31, 2002, 6:58:38 PM, you wrote:
EH> I did exactly that...defined in Ent Man as GetDate(), left it blank in
EH> the insert statement, but get this error:
EH> DIAGNOSTIC:
EH> ODBC Error Code = 22008 (Datetime field overflow)
EH> [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting
EH> datetime from character string.
EH> Regards,
EH> Eric J Hoffman
EH> DataStream Connexion
EH> www.datastreamconnexion.com
EH> Delivering Creative Data Solutions
EH> -Original Message-
EH> From: Jon Hall [mailto:[EMAIL PROTECTED]]
EH> Sent: Wednesday, July 31, 2002 5:53 PM
EH> To: CF-Talk
EH> Subject: Re: SQL GetDate()
EH> Either define the default value for the field as getDate(), or use
EH> getDate() in your insert query.
EH> ex:
EH>
EH> INSERT INTO Table (Foo, Bar, DateField)
EH> VALUES ('somedata', 42, getDate())
EH>
EH> If you defined getDate() as the field default in ent manager, then just
EH> leave the datefield stuff out of the query. SQL will fill in the field
EH> with it's default value.
EH> ex:
EH>
EH> INSERT INTO Table (Foo, Bar)
EH> VALUES ('somedata', 42)
EH>
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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 GetDate()
I did exactly that...defined in Ent Man as GetDate(), left it blank in
the insert statement, but get this error:
DIAGNOSTIC:
ODBC Error Code = 22008 (Datetime field overflow)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting
datetime from character string.
Regards,
Eric J Hoffman
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 5:53 PM
To: CF-Talk
Subject: Re: SQL GetDate()
Either define the default value for the field as getDate(), or use
getDate() in your insert query.
ex:
INSERT INTO Table (Foo, Bar, DateField)
VALUES ('somedata', 42, getDate())
If you defined getDate() as the field default in ent manager, then just
leave the datefield stuff out of the query. SQL will fill in the field
with it's default value.
ex:
INSERT INTO Table (Foo, Bar)
VALUES ('somedata', 42)
--
Jon
mailto:[EMAIL PROTECTED]
Wednesday, July 31, 2002, 6:35:31 PM, you wrote:
EH> Okay, the default value field in SQL 7 for date/time is what? I put
EH> GetDate() in there to save CF processing and query time...so when I
EH> submit a form the data gets inserted, I just want SQL to put in the
EH> current date by default. I get an error using GetDate() though.
EH> Any quick "duh" help?
EH> Regards,
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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 GetDate()
Either define the default value for the field as getDate(), or use
getDate() in your insert query.
ex:
INSERT INTO Table (Foo, Bar, DateField)
VALUES ('somedata', 42, getDate())
If you defined getDate() as the field default in ent manager, then
just leave the datefield stuff out of the query. SQL will fill in the
field with it's default value.
ex:
INSERT INTO Table (Foo, Bar)
VALUES ('somedata', 42)
--
Jon
mailto:[EMAIL PROTECTED]
Wednesday, July 31, 2002, 6:35:31 PM, you wrote:
EH> Okay, the default value field in SQL 7 for date/time is what? I put
EH> GetDate() in there to save CF processing and query time...so when I
EH> submit a form the data gets inserted, I just want SQL to put in the
EH> current date by default. I get an error using GetDate() though.
EH> Any quick "duh" help?
EH> Regards,
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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: Good CFCatch code
block's looks a lot like xslt...I imagine it wouldn't be hard to rewrite quite a bit of the CF engine on top of an xml/xslt parser. duh! :) Sorry for the blank message...damn buttons. -- Jon mailto:[EMAIL PROTECTED] Wednesday, July 31, 2002, 6:24:24 PM, you wrote: MW> Aside from the more obscure aspects of XML, it would be difficult to MW> write and make it look like XML I should MW> think >> -Original Message- >> From: Dave Watts [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, 1 August 2002 10:03 a.m. >> To: CF-Talk >> Subject: RE: Good CFCatch code >> >> >> > This works beautifully on CF 5 -- minus the trailing / since >> > CF 5 and before weren't technically xml languages. >> >> Actually, though, you can still use the trailing slash with many tags >> (perhaps all, for all I know) in CF 4.x and higher. This is >> actually done >> quite a bit, when calling nested custom tag sets using >> CFMODULE, and with >> nested CFTRANSACTION tags for partial commits and rollbacks. >> Also, I don't >> think that CFML is an XML language even in CF MX in any >> meaningful sense, >> although I guess you can generally follow XML syntactical >> rules when writing >> tags. >> >> Dave Watts, CTO, Fig Leaf Software >> http://www.figleaf.com/ >> voice: (202) 797-5496 >> fax: (202) 797-5444 >> MW> __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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 GetDate()
Okay, the default value field in SQL 7 for date/time is what? I put GetDate() in there to save CF processing and query time...so when I submit a form the data gets inserted, I just want SQL to put in the current date by default. I get an error using GetDate() though. Any quick "duh" help? Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Good CFCatch code
-- Jon mailto:[EMAIL PROTECTED] Wednesday, July 31, 2002, 6:24:24 PM, you wrote: MW> Aside from the more obscure aspects of XML, it would be difficult to MW> write and make it look like XML I should MW> think >> -Original Message- >> From: Dave Watts [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, 1 August 2002 10:03 a.m. >> To: CF-Talk >> Subject: RE: Good CFCatch code >> >> >> > This works beautifully on CF 5 -- minus the trailing / since >> > CF 5 and before weren't technically xml languages. >> >> Actually, though, you can still use the trailing slash with many tags >> (perhaps all, for all I know) in CF 4.x and higher. This is >> actually done >> quite a bit, when calling nested custom tag sets using >> CFMODULE, and with >> nested CFTRANSACTION tags for partial commits and rollbacks. >> Also, I don't >> think that CFML is an XML language even in CF MX in any >> meaningful sense, >> although I guess you can generally follow XML syntactical >> rules when writing >> tags. >> >> Dave Watts, CTO, Fig Leaf Software >> http://www.figleaf.com/ >> voice: (202) 797-5496 >> fax: (202) 797-5444 >> MW> __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: Good CFCatch code
Aside from the more obscure aspects of XML, it would be difficult to write and make it look like XML I should think > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 1 August 2002 10:03 a.m. > To: CF-Talk > Subject: RE: Good CFCatch code > > > > This works beautifully on CF 5 -- minus the trailing / since > > CF 5 and before weren't technically xml languages. > > Actually, though, you can still use the trailing slash with many tags > (perhaps all, for all I know) in CF 4.x and higher. This is > actually done > quite a bit, when calling nested custom tag sets using > CFMODULE, and with > nested CFTRANSACTION tags for partial commits and rollbacks. > Also, I don't > think that CFML is an XML language even in CF MX in any > meaningful sense, > although I guess you can generally follow XML syntactical > rules when writing > tags. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: treating query/form as a structure/array
> Seems like everytime I try to do this, I muck the syntax or can't quite > find the exact documentation. How do you treat a query as a structure: > > SELECT field1, field2 FROM myTable WHERE 0 = 0 > > > > #isStruct(test)# > #isArray(test)# > > #isStruct(test['field1'])# > #isArray(test['field1'])# > Hmm... Well... The array functions can be used on query columns, although I don't think IsArray() would work, or for that matter isStruct()... If you declare isStruct(queryname) or isArray(queryname) they're going to be false because you're passing them a query. If you delcare isArray(queryname['columnname']) it's going to return false because it's going to evaluate the _value_ contained in the first row of that column of that query, which is going to be a string rather than an array... Is there a particular reason you need to get the "isarray" information from a query column? or can you just use the other array functions to get what you need? The easiest way to actually create an array is to use ListToArray(ValueList(myquery.mycolumn)) if necessary... I wouldn't expect there to be much in the way of documentation on this issue specifically ... There's documentation on each of the functions and on queries of course, but I wouldn't expect any of that documentation to cover this explicitely... Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: cfmx client vars as cookies do not persist.
And it appears they aren't persisting even when set to store in the db. This totally sucks. I'm really really really really really disappointed with mm. > -Original Message- > From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 2:39 PM > To: CF-Talk > Subject: cfmx client vars as cookies do not persist. > > > We're not happy about this one. heres a thread as a heads up to anyone > thinking about migrating. > > http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7 > &threadid= > 384991&highlight_key=y&keyword1=cfmx&keyword2=client%20variables > > Any ideas to circumvent this? Move to db storage of client vars I guess.. > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: CFMX, Access DSN and JDBCPool errors! Help!
>>I did What does the error message /log file say? -Craig __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: Good CFCatch code
> This works beautifully on CF 5 -- minus the trailing / since > CF 5 and before weren't technically xml languages. Actually, though, you can still use the trailing slash with many tags (perhaps all, for all I know) in CF 4.x and higher. This is actually done quite a bit, when calling nested custom tag sets using CFMODULE, and with nested CFTRANSACTION tags for partial commits and rollbacks. Also, I don't think that CFML is an XML language even in CF MX in any meaningful sense, although I guess you can generally follow XML syntactical rules when writing tags. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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 and SQL
> I am interested in peoples opinions on the following: > > Is it best practice to check for a records existence > before attempting to update it? And what would the > best way to go about that be? Depends heavily on the application ... The database as a general rule doesn't care if a given record doesn't exist when you execute an update statement, so if the record doesn't exist, the worst that will happen is nothing -- which may be worse than an error. :) Though I can't think of a single occasion on which I actually manually verified that the row existed prior to updating it... though if you use a stored procedure, you could simply use a select statement following the update statement which would retrieve all the data from the updated row using the same identifying input variable, that way if the result set returned to CF has a recordcount of 0 you know that nothing was updated and maybe you've got a problem. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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!!
> If this is in an onChange you use this.options[this.selectedIndex].text > otherwise document.forms["yourformname"].yourselectbox.options[document.fo > rms["yourformname"].yourselectbox.selectedIndex].text Yea, that's always seemed like a lot of typing to me... which was why I tended to do something like this: var s = document.myform.myselectbox; s.options[s.selectedIndex].text; Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: Good CFCatch code
> On Wednesday, July 31, 2002, at 11:03 , Neil H. wrote: >> Anyone have a snippet of code that would show all the information >> available >> when an error occurs? I am looking for something like what CF displays >> if I >> wasn't using the catch but I will email it to me when it does :) > Assuming you're on CFMX? > http://www.fusionauthority.com/ads.cfm 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
Proper way to catch a connection failure for cfhttp
A couple of questions... There is a url I am calling, which allows us to validate a user against the DEERS db(military thing). I am sending it a few url params through cfhttp. Does this classify it as a web service? It returns a string, not an XML document, does that matter? Also, what is the proper way to trap (ie cftry/cfcatch style) a failed cfhttp call? The service tends to be iffy, so: If the user is verified, I return a "1" If the user verification fails, I return "0" If the cfhttp call fails, I want to return "-1" Currently, I am doing this: https://foo.com";> -1 Is this the correct way to trap it? Or is there a that would be better? Thanks for the help. Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
cfmx client vars as cookies do not persist.
We're not happy about this one. heres a thread as a heads up to anyone thinking about migrating. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7&threadid= 384991&highlight_key=y&keyword1=cfmx&keyword2=client%20variables Any ideas to circumvent this? Move to db storage of client vars I guess.. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: CFMX, Access DSN and JDBCPool errors! Help!
Did you try this, from the release notes: (Windows only) You must provide a username for Microsoft Access and ODBC Socket Data Source Names (DSNs), even if the data sources do not require any user authentication. Provide a username as follows: Access DSN-Select the Use Default Username option; OR show the Advanced Settings section and enter a username in the ColdFusion Username field. ODBC Socket DSN-Select the Use Trusted Connection option; OR show the Advanced Settings section and, in the Username field, accept the default username (system) or enter a username. Deb -Original Message- From: Dimo Michailov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 3:33 PM To: CF-Talk Subject: CFMX, Access DSN and JDBCPool errors! Help! Hello all! Here's the problem. Installed CFMX on a dev machine that runs CF5. All datasources were preserved but only the DSNs that point to our SQL Server verify correctly. All Access DSNs throw an error: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Has anyone had a similar problem? Any help will be appreciated! Thanks- Dimo __ Get the mailserver that powers this list at http://www.coolfusion.com 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
CFMX - Linux - DB2 AS/400
Has anyone had any luck connecting MX/Linux to a AS/400 running DB2 without DB2Connect? If so, please elighten :) Thanks Paul Giesenhagen QuillDesign __ Get the mailserver that powers this list at http://www.coolfusion.com 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: CFMX, Access DSN and JDBCPool errors! Help!
I did -Original Message- From: Craig Thomas <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wednesday, July 31, 2002 5:32 PM Subject: RE: CFMX, Access DSN and JDBCPool errors! Help! >>>I have had the same problem but the other way around. All of the SQL dsn's >>>failed. Still have yet to find out why. > >If you have access to the sql server admin features, I'd your using to >connect to sql server. I'm wondering too if you used the cf migration wizard >after "co-exist" install? > >-Craig > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: OS X Web Services was Re: X-server?
All of the Web services stuff is in webservices.jar. Matt Liotta President & CEO Montara Software, Inc. http://www.montarasoftware.com/ V: 415-577-8070 F: 415-341-8906 P: [EMAIL PROTECTED] > -Original Message- > From: Dick Applebaum [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 2:14 PM > To: CF-Talk > Subject: Re: OS X Web Services was Re: X-server? > > On Wednesday, July 31, 2002, at 01:38 PM, Sean A Corfield wrote: > > > CFMX tries to compile these files but they don't compile. My sense is > > that > > the environment that CFMX uses to compile the stubs doesn't have the > > org.apache.* classes in it (I tried to javac the files by hand and it > > couldn't resolve those items). > > I searched the Linux install for org.apache and found nothing. > > Could it be that CFMX assumes that Apache, and the required classes, are > pre-installed (not part of the CFMX install)? > > Would that also mean that consuming web services is *Not* supported with > the CFMX Default web server? > > Do you know what ckasses are required and where I can get them? > > Aren't I persistent? > > TIA > > Dick > > > It *may* be as simple as changing some > > configuration file somewhere or it may require adding the appropriate > > .jar > > file to the classpath or something else. It's on my list of things to > > figure out... but it's down the list a page or two! > > > > Sean A Corfield -- http://www.corfield.org/blog/ > > > > "If you're not annoying somebody, you're not really alive." > > -- Margaret Atwood > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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: CFMX, Access DSN and JDBCPool errors! Help!
>>I have had the same problem but the other way around. All of the SQL dsn's >>failed. Still have yet to find out why. If you have access to the sql server admin features, I'd your using to connect to sql server. I'm wondering too if you used the cf migration wizard after "co-exist" install? -Craig __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: OS X Web Services was Re: X-server?
On Wednesday, July 31, 2002, at 02:14 , Dick Applebaum wrote: > Could it be that CFMX assumes that Apache, and the required classes, are > pre-installed (not part of the CFMX install)? No, it's the Axis code and it's buried somewhere in one of the .jar files installed with CFMX. > Would that also mean that consuming web services is *Not* supported with > the CFMX Default web server? Huh? The web server has nothing to do with consuming web services. > Do you know what ckasses are required and where I can get them? See above. I'm off to the doctor but I'll make a concerted effort to figure this out when I get back OK? > Aren't I persistent? It's part of your charm... Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood __ Get the mailserver that powers this list at http://www.coolfusion.com 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 and SQL
If you DB supports it, use if exists [query] the presence of the exists directive will cause the query to stop processing as soon as it has a match. This can save time if you are querying an unindexed table or there are multiple results. Justin > -Original Message- > From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 2:23 PM > To: CF-Talk > Subject: CF and SQL > > Ok, > > I am interested in peoples opinions on the following: > > Is it best practice to check for a records existence before > attempting to update it? > And what would the best way to go about that be? > > Michael Tangorre > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: OS X Web Services was Re: X-server?
On Wednesday, July 31, 2002, at 01:38 PM, Sean A Corfield wrote: > CFMX tries to compile these files but they don't compile. My sense is > that > the environment that CFMX uses to compile the stubs doesn't have the > org.apache.* classes in it (I tried to javac the files by hand and it > couldn't resolve those items). I searched the Linux install for org.apache and found nothing. Could it be that CFMX assumes that Apache, and the required classes, are pre-installed (not part of the CFMX install)? Would that also mean that consuming web services is *Not* supported with the CFMX Default web server? Do you know what ckasses are required and where I can get them? Aren't I persistent? TIA Dick > It *may* be as simple as changing some > configuration file somewhere or it may require adding the appropriate > .jar > file to the classpath or something else. It's on my list of things to > figure out... but it's down the list a page or two! > > Sean A Corfield -- http://www.corfield.org/blog/ > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwood > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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: cfargument and dot notaion
Yes, the order of args must match the order of cfarg tags. Unless... You use the new name/value pair notation, which works w/ UDFs as well: === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 5:07 PM > To: CF-Talk > Subject: cfargument and dot notaion > > > When calling a cfc method using the dot notation, the order of the > arguments given to the method must match the order of the cfargument > tags in the body of the method, unlike cfinvoke, where you have name > value pairs. > > Example: > >objEmailMan.isDupe(trim(singleAddress),emailCategoryID)> > > -- emailman.cfc -- > > >type="numeric"> > > > Is this correct? It seems to be so, but I can't find anything > anywhere that comes out and says it is the order that matters. > > -- > Jon > mailto:[EMAIL PROTECTED] > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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: SSL on form submission
Chad, In a previous thread in a different mailing list Lynn Taylor concisely described the SLL process as it relates to IP and IP-less domains. It so accurately described the process I saved it for posterity. [From a discussion with "Lynn W. Taylor" <[EMAIL PROTECTED]>]= Certificates are bound to domain names, no question. SSL connections are negotiated by IP address, before the domain name is passed. So, the TCP SYN packet comes in, the SYN+ACK goes back, the ACK comes in, and then SSL encryption starts. After the encryption is started, it checks the domain name on the certificate. So it stands to reason that you can put a certificate on any IP, and you can change the IP -- you just can't have more than one certificate on a single IP address+Port number. Note that this is true on any OS and any web server. ==[ end discussion ]== So in your example (http://www/form.cfm) the data passed from the server to the browser is NOT encrypted since you did not negotiate for a secure connection and the browser will not indicate that it is secure. If there is nothing in the data used to display the form that needs to be secure then it is technically OK, however, the user cannot tell if the data he is entering will be sent back via a secure connection unless he looks at the form code. Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/ http://dennis.uxb.net/ -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 10:56 AM To: CF-Talk Subject: SSL on form submission Im wondering if when a form is submitted at what point do you request SSL? Do you want the form to be covered under SSL as the user is filling it out? https://www/form.cfm Or do you leave the form http://www/form.cfm and use https://www/action.cfm"; method="POST"> enough to encrypt the data being passed to the action page? Just curious __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
CFMX distributed mode and local Jrun conflict?
I've been developing on CFMX in distributed mode for a few weeks now, and haven't had any problems at all. I had CFMX on a development app server, with the built-in web server turned off, and was using a development IIS server as the web server, configured with the CFMX connector. Everything was working great. The problem is that the web server that I was using is the development web server for our entire organization. Our admins had a need to install some other software for another team. They installed Brio on this web server, which actually has an embedded version of JRun (version 2.2.3) that installs with it. Well, as you might imagine, when they got that software installed, my CFMX app stopped working. I'm now getting a 404 error - "The page cannot be found". For some reason or other, I have no idea why, the connector doesn't seem to be working at all now. I'm fairly certain it has something to do with the fact that there is now a conflicting version of JRun on the web that is causing the problems that we're having with the connector, but I have absolutely no idea how to fix it. What we've done so far was to completely shut down the new JRun service that's running. We re-ran the connector script (executed the wsconfig.jar file) and it told us that the server was already configured. So, we uninstalled it successfully, and then ran it again, to get a fresh installation of it. That ran successfully. Still no go. We checked the settings in the wsconfig.properties file, and those all seemed to be correct. Still nothing. I'm kind of stuck. I really don't feel like an uninstall and reinstall of CFMX would do any good, since it's running on a totally different server and everything. It would appear that it's simply a problem with the connector, or some sort of conflict with this new (old version) JRun server that's on this web server.! Has anyone else run into this yet? Does anyone have any ideas of how we could get this fixed and up and running again? Thanks in advance. ::YEX:: /* || Robert D. Yexley || Oracle Programmer/Analyst || Easylink Services Corporation || Professional Services || Contractor - Wright Research Site MIS || Det-1 AFRL/WSI Bldg. 45 Rm. 062 || (937) 255-1984 || [EMAIL PROTECTED] || <)))>< */ <> __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Can you use with an insert?
Thanks, worked like a charm.
Been using nothing but stored procs for awhile; forgot about that gotcha.
Matthew P. Smith
Web Developer, Object Oriented
Naval Education & Training Professional
Development & Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
>>-Original Message-
>>From: Kelly Tetterton [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, July 31, 2002 4:05 PM
>>To: [EMAIL PROTECTED]
>>Subject: RE: Can you use with an insert?
>>
>>Don't quote the cfqueryparam; ie do
>>
>>Values(>cfsqltype="CF_SQL_VARCHAR" maxlength="50">,
>>
>>rather than
>>
>>Values('>cfsqltype="CF_SQL_VARCHAR" maxlength="50">',
>>
>>-Original Message-
>>From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
>>Sent: Wednesday, July 31, 2002 4:03 PM
>>To: CF-Talk
>>Subject: Can you use with an insert?
>>
>>
>>I try to use cfqueryparam for a little better performance(I'll be
>>converting
>>to a stored proc in a bit).
>>
>>I've used it with no prob for selects, but can you use it for an INSERT or
>>UPDATE statement?
>>
>>After running the query below, the DB is storing an actual "?" for the
>>values, rather than the actual values sent. The debug info shows the
>>correct values being sent.
>>
>>
>>
>> INSERT INTO loginInfo (ssn, lastName, birthDate,
>>lastVerified)
>> Values ('>cfsqltype="CF_SQL_VARCHAR" maxlength="50">', '>value="#attributes.lastName#" cfsqltype="CF_SQL_VARCHAR" maxlength="50">',
>>'>maxlength="50">', #CreateODBCDateTime(now())#)
>>
>>
>>
>>DEBUG INFO:
>>
>>qry_insertNew (Records=0, Time=16ms)
>>SQL =
>>INSERT INTO loginInfo (ssn, lastName, birthDate, lastVerified, hits)
>> Values ('?', '?', '?', {ts '2002-07-31 16:00:41'},
>>?)
>>
>>Query Parameter Value(s) -
>>Parameter #1 = 123456789
>>Parameter #2 = Davis
>>Parameter #3 = 19430214
>>Parameter #4 = 1
>>
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
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
cfargument and dot notaion
When calling a cfc method using the dot notation, the order of the arguments given to the method must match the order of the cfargument tags in the body of the method, unlike cfinvoke, where you have name value pairs. Example: -- emailman.cfc -- Is this correct? It seems to be so, but I can't find anything anywhere that comes out and says it is the order that matters. -- Jon mailto:[EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Can you use with an insert?
Remove the quotes
- Original Message -
From: "Smith, Matthew P -CONT(DYN)" <[EMAIL PROTECTED]>
Date: Wednesday, July 31, 2002 3:03 pm
Subject: Can you use with an insert?
> I try to use cfqueryparam for a little better performance(I'll be
> convertingto a stored proc in a bit).
>
> I've used it with no prob for selects, but can you use it for an
> INSERT or
> UPDATE statement?
>
> After running the query below, the DB is storing an actual "?" for the
> values, rather than the actual values sent. The debug info shows the
> correct values being sent.
>
>
>
> INSERT INTO loginInfo (ssn, lastName, birthDate,
> lastVerified)
> Values (' cfsqltype="CF_SQL_VARCHAR" maxlength="50">', ' value="#attributes.lastName#" cfsqltype="CF_SQL_VARCHAR"
> maxlength="50">',' cfsqltype="CF_SQL_VARCHAR"maxlength="50">',
> #CreateODBCDateTime(now())#)
>
>
> DEBUG INFO:
>
> qry_insertNew (Records=0, Time=16ms)
> SQL =
> INSERT INTO loginInfo (ssn, lastName, birthDate, lastVerified, hits)
> Values ('?', '?', '?', {ts '2002-07-31
16:00:41'},
> ?)
>
> Query Parameter Value(s) -
> Parameter #1 = 123456789
> Parameter #2 = Davis
> Parameter #3 = 19430214
> Parameter #4 = 1
>
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
Can you use with an insert?
I try to use cfqueryparam for a little better performance(I'll be converting
to a stored proc in a bit).
I've used it with no prob for selects, but can you use it for an INSERT or
UPDATE statement?
After running the query below, the DB is storing an actual "?" for the
values, rather than the actual values sent. The debug info shows the
correct values being sent.
INSERT INTO loginInfo (ssn, lastName, birthDate,
lastVerified)
Values ('', '',
'', #CreateODBCDateTime(now())#)
DEBUG INFO:
qry_insertNew (Records=0, Time=16ms)
SQL =
INSERT INTO loginInfo (ssn, lastName, birthDate, lastVerified, hits)
Values ('?', '?', '?', {ts '2002-07-31 16:00:41'},
?)
Query Parameter Value(s) -
Parameter #1 = 123456789
Parameter #2 = Davis
Parameter #3 = 19430214
Parameter #4 = 1
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
Structure OR Array?
I have a large ugly query listing the threads in a message board. (each thread can have multiple articles) I have a separate function that stores a user profile for a member based on their username. In each article (post) the username defaults to their real username, but they can edit it and perhaps put someone else's username. I have the queries to find out the poster's real username, and then I can compare it to the main query's username to see if it's a "fake". Of course these quries right now are in the output loop of the big ugly query. I'd like to loop over them and create a structure, or array to store the threadid and the REAL username of the poster BEFORE the main output. This way I could test for the real username of the poster while in the output loop without hitting the db. I'm using CF4.5 so I can't query a query. :-( And I think building a list would be rather crude. Could someone help get me started? Which is proper to use for this an array or structure? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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 5 App crashing every 5 minutes...
Glad to be of service!! Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: "Joel Blanchette" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 1:32 PM Subject: RE: CF 5 App crashing every 5 minutes... > Thanks all...It seems to work perfectly nowI will keep an eye out on > it for a few hours. > > Again thanks for all the help. I love this list! > > > > == > Joel Blanchette > IT and System Specialist > Point of Impact Technologies Inc. > Tel: (204) 989-0013 > Email: [EMAIL PROTECTED] > == > > > -Original Message- > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 2:13 PM > To: CF-Talk > Subject: Re: CF 5 App crashing every 5 minutes... > > > What version of CF are you using? If you are using 5 then it will be > under settings. As far as the time-out is concerned, I would set it to > 30 and then in the templates that you are talking about, you can use > requesttimeout= in your url variable. > > IE: > > http://www.yourserver.com?requesttimeout= > > > > > Douglas Brown > Email: [EMAIL PROTECTED] > - Original Message - > From: "Joel Blanchette" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 31, 2002 11:40 AM > Subject: RE: CF 5 App crashing every 5 minutes... > > > > I have 1 cpu intel 850mhz > > > > I need the timeout high before some of our stats that go off at the > > middle of the night takes a while to finish. We are re-vamping the > > stats system right now. Hopefully this will be better in a couple of > > weeks. > > > > I will change it to 5... > > > > How to I enable strict attribute validation? > > > > > > > > == > > Joel Blanchette > > IT and System Specialist > > Point of Impact Technologies Inc. > > Tel: (204) 989-0013 > > Email: [EMAIL PROTECTED] == > > > > > > -Original Message- > > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 31, 2002 1:20 PM > > To: CF-Talk > > Subject: Re: CF 5 App crashing every 5 minutes... > > > > > > Limit simultaneous requests to : 10 how many cpu's? > > Timeout requests after : 900 s Kinda high dont ya think? 30 - > 60 > > maybe > > Restart at 10 unresponsive requests - I would make this like 5 > > Restart when requests terminate abnormally : on > > Suppress whitespace by default: on > > > > > > I would also enforce strict attribute validation. > > > > > > > > > > Douglas Brown > > Email: [EMAIL PROTECTED] > > - Original Message - > > From: "Joel Blanchette" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, July 31, 2002 11:07 AM > > Subject: RE: CF 5 App crashing every 5 minutes... > > > > > > > Limit simultaneous requests to : 10 > > > Timeout requests after : 900 s > > > Restart at 10 unresponsive requests > > > Restart when requests terminate abnormally : on > > > Suppress whitespace by default: on > > > > > > Template cache size: 1024 kilobytes > > > > > > > > > Anything else? Let me know where it would be in the menu and I will > > > get it.. > > > > > > Thanks for the help > > > > > > > > > > > > == > > > Joel Blanchette > > > IT and System Specialist > > > Point of Impact Technologies Inc. > > > Tel: (204) 989-0013 > > > Email: [EMAIL PROTECTED] == > > > > > > > > > -Original Message- > > > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, July 31, 2002 12:17 PM > > > To: CF-Talk > > > Subject: Re: CF 5 App crashing every 5 minutes... > > > > > > > > > What settings do you have in Admin? Max number of threads > > etc...Template > > > caching? > > > > > > > > > > > > > > > Douglas Brown > > > Email: [EMAIL PROTECTED] > > > - Original Message - > > > From: "Joel Blanchette" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Wednesday, July 31, 2002 10:07 AM > > > Subject: CF 5 App crashing every 5 minutes... > > > > > > > > > > Hello All, > > > > I need big help.Last night, I saw that our server was going > > down, > > > > then I noticed that it was not the server but more that the > > > > cfserver.exe in the task manager was just stopping. If I restart > > the > > > > serveice it is all good. But I need to do this every 5 > > > > minutes...Which is not good...So I wrote a batch file that does it > > for > > > > > > > me. > > > > > > > > I need to know why this error is happening. It seems like when > the > > > > cfserver.exe gets around 25 megs or memory use it just stops > > > > responding. The task is still there but it will not respond. I'm > > > > using CF Server 5 on a Windows server 2000 SP2. Is there > something > > in > > > > > > > the threads that I should change? > > > > > > > > I can post the lines of the error logs of CF here but I nee
RE: Good CFCatch code
> isn't available on CF 4.5.x. D'oh! But of course. I'd forgotten about using the cf_dump custom tag back then. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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: OS X Web Services was Re: X-server?
On Wednesday, July 31, 2002, at 12:16 , Dick Applebaum wrote: > Can anyone tell me/ point me to what is supposed to happen when you > invove a web service. CFMX parses the WSDL and generates Java stub files. These are then compiled. The result allows CFMX to execute the Web Service (subsequent calls use the precompiled stubs). > the Java files generated are in > /opt/coldfusionmx/stubs/WS330149168/Net/xmethods/www are: > > BabelFishBindingStub.java > BabelFishPortType.java > BabelFishService.java > BabelFishServiceLocator.java > > AFAIK, the only file missing is: > > BabelFishService.class > > However, I can't figure out who is responsible for generating the > missing file -- or where to start looking. CFMX tries to compile these files but they don't compile. My sense is that the environment that CFMX uses to compile the stubs doesn't have the org.apache.* classes in it (I tried to javac the files by hand and it couldn't resolve those items). It *may* be as simple as changing some configuration file somewhere or it may require adding the appropriate .jar file to the classpath or something else. It's on my list of things to figure out... but it's down the list a page or two! Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Good CFCatch code
isn't available on CF 4.5.x. -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel > 213.244.5205 Email > [EMAIL PROTECTED] "Hello Stupid, and welcome to your crappy computer." - Strong Bad, HomestarRunner.com > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 1:40 PM > To: CF-Talk > Subject: RE: Good CFCatch code > > > > Assuming you're on CFMX? > > > > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Good CFCatch code
> Assuming you're on CFMX? > > http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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 5 App crashing every 5 minutes...
Thanks all...It seems to work perfectly nowI will keep an eye out on it for a few hours. Again thanks for all the help. I love this list! == Joel Blanchette IT and System Specialist Point of Impact Technologies Inc. Tel: (204) 989-0013 Email: [EMAIL PROTECTED] == -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:13 PM To: CF-Talk Subject: Re: CF 5 App crashing every 5 minutes... What version of CF are you using? If you are using 5 then it will be under settings. As far as the time-out is concerned, I would set it to 30 and then in the templates that you are talking about, you can use requesttimeout= in your url variable. IE: http://www.yourserver.com?requesttimeout= Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: "Joel Blanchette" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 11:40 AM Subject: RE: CF 5 App crashing every 5 minutes... > I have 1 cpu intel 850mhz > > I need the timeout high before some of our stats that go off at the > middle of the night takes a while to finish. We are re-vamping the > stats system right now. Hopefully this will be better in a couple of > weeks. > > I will change it to 5... > > How to I enable strict attribute validation? > > > > == > Joel Blanchette > IT and System Specialist > Point of Impact Technologies Inc. > Tel: (204) 989-0013 > Email: [EMAIL PROTECTED] == > > > -Original Message- > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 1:20 PM > To: CF-Talk > Subject: Re: CF 5 App crashing every 5 minutes... > > > Limit simultaneous requests to : 10 how many cpu's? > Timeout requests after : 900 s Kinda high dont ya think? 30 - 60 > maybe > Restart at 10 unresponsive requests - I would make this like 5 > Restart when requests terminate abnormally : on > Suppress whitespace by default: on > > > I would also enforce strict attribute validation. > > > > > Douglas Brown > Email: [EMAIL PROTECTED] > - Original Message - > From: "Joel Blanchette" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 31, 2002 11:07 AM > Subject: RE: CF 5 App crashing every 5 minutes... > > > > Limit simultaneous requests to : 10 > > Timeout requests after : 900 s > > Restart at 10 unresponsive requests > > Restart when requests terminate abnormally : on > > Suppress whitespace by default: on > > > > Template cache size: 1024 kilobytes > > > > > > Anything else? Let me know where it would be in the menu and I will > > get it.. > > > > Thanks for the help > > > > > > > > == > > Joel Blanchette > > IT and System Specialist > > Point of Impact Technologies Inc. > > Tel: (204) 989-0013 > > Email: [EMAIL PROTECTED] == > > > > > > -Original Message- > > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 31, 2002 12:17 PM > > To: CF-Talk > > Subject: Re: CF 5 App crashing every 5 minutes... > > > > > > What settings do you have in Admin? Max number of threads > etc...Template > > caching? > > > > > > > > > > Douglas Brown > > Email: [EMAIL PROTECTED] > > - Original Message - > > From: "Joel Blanchette" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, July 31, 2002 10:07 AM > > Subject: CF 5 App crashing every 5 minutes... > > > > > > > Hello All, > > > I need big help.Last night, I saw that our server was going > down, > > > then I noticed that it was not the server but more that the > > > cfserver.exe in the task manager was just stopping. If I restart > the > > > serveice it is all good. But I need to do this every 5 > > > minutes...Which is not good...So I wrote a batch file that does it > for > > > > > me. > > > > > > I need to know why this error is happening. It seems like when the > > > cfserver.exe gets around 25 megs or memory use it just stops > > > responding. The task is still there but it will not respond. I'm > > > using CF Server 5 on a Windows server 2000 SP2. Is there something > in > > > > > the threads that I should change? > > > > > > I can post the lines of the error logs of CF here but I need to know > > > which ones u would need. I will need help. I did nothing to the > > > server that would just start doing this. We are getting more > traffic > > > then before. Would that be the cause? If yes, there must be a way > to > > > > > fix this. > > > > > > > > > > > > == > > > Joel Blanchette > > > IT and System Specialist > > > Point of Impact Technologies Inc. > > > Tel: (204) 989-0013 > > > Email: [EMAIL PROTECTED] == > > > > > > > > > > > > __ Get
Re: CFMX, Access DSN and JDBCPool errors! Help!
It's funny that you ask that now, I just got off of the phone with a client asking her to verify that she got a test email that I sent her through a form on her dev site. And she did not get it, I checked the logs and the undeliverables and it was not in there also. I was wondering if this could be something like the problem Dimo is happening and if a product like cfdev.com's ActivMail could be an answer to Dimo and my problems. -Original Message- From: Dimo Michailov <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wednesday, July 31, 2002 3:42 PM Subject: CFMX, Access DSN and JDBCPool errors! Help! >Hello all! > >Here's the problem. Installed CFMX on a dev machine that runs CF5. All >datasources were preserved but only the DSNs that point to our SQL >Server verify correctly. All Access DSNs throw an error: > >[]java.sql.SQLException: SQLException occurred in JDBCPool while >attempting to connect, please check your username, password, URL, and >other connectivity info. > > >Has anyone had a similar problem? Any help will be appreciated! > >Thanks- > >Dimo > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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: CfMail occasionally dropping emails - alternative
You might want to take a look at our CFMAIL replacement product, iMS-SE. You can install iMS-SE on the server for 60 days prior to purchase by installing with a serial number of DEMO. You can get additional information here: http://www.coolfusion.com/WhyiMS.cfm http://www.coolfusion.com/imssecomparison.cfm Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: "Jason Miller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 6:37 PM Subject: CfMail occasionally dropping emails - alternative > Hello all, CFMAIL after 3 years has finally showed that it occasionally > drops emails. On an ordering system - even 1 email is not acceptable. > > What is the absolute simplest and fastest way to address this with an > alternative? I am pretty busy and have no real time to invest in it at > the moment and have to update a dozen or so sites. > > I appreciate any thoughts. > Thanks, > Jason > __ Get the mailserver that powers this list at http://www.coolfusion.com 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
CfMail occasionally dropping emails - alternative
Hello all, CFMAIL after 3 years has finally showed that it occasionally drops emails. On an ordering system - even 1 email is not acceptable. What is the absolute simplest and fastest way to address this with an alternative? I am pretty busy and have no real time to invest in it at the moment and have to update a dozen or so sites. I appreciate any thoughts. Thanks, Jason __ Get the mailserver that powers this list at http://www.coolfusion.com 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: CFMX, Access DSN and JDBCPool errors! Help!
I have had the same problem but the other way around. All of the SQL dsn's failed. Still have yet to find out why. -Original Message- From: Dimo Michailov <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wednesday, July 31, 2002 3:42 PM Subject: CFMX, Access DSN and JDBCPool errors! Help! >Hello all! > >Here's the problem. Installed CFMX on a dev machine that runs CF5. All >datasources were preserved but only the DSNs that point to our SQL >Server verify correctly. All Access DSNs throw an error: > >[]java.sql.SQLException: SQLException occurred in JDBCPool while >attempting to connect, please check your username, password, URL, and >other connectivity info. > > >Has anyone had a similar problem? Any help will be appreciated! > >Thanks- > >Dimo > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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 Studio autocomplete
Doh, nevermind. What I was looking for was the tag completion and tag insight panels under settings. I never really looked at them :) Thanks though. -- Jon mailto:[EMAIL PROTECTED] Wednesday, July 31, 2002, 3:22:33 PM, you wrote: CT> just curious, have you used the tag updater for CFMX yet? >>>-Original Message- >>>From: Jon Hall [mailto:[EMAIL PROTECTED]] >>>Sent: Wednesday, July 31, 2002 2:47 PM >>>To: CF-Talk >>>Subject: CF Studio autocomplete >>> >>> >>> Does anyone know which file dictates which tags have closing tags, >>> and which tags display in the autocomplete dropdown as you are >>> typing in Studio 5? I want the MX tags to autocomplete as well... >>> >>>-- >>> Jon >>> mailto:[EMAIL PROTECTED] >>> >>> CT> __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
CFMX, Access DSN and JDBCPool errors! Help!
Hello all! Here's the problem. Installed CFMX on a dev machine that runs CF5. All datasources were preserved but only the DSNs that point to our SQL Server verify correctly. All Access DSNs throw an error: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Has anyone had a similar problem? Any help will be appreciated! Thanks- Dimo __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
treating query/form as a structure/array
Seems like everytime I try to do this, I muck the syntax or can't quite find the exact documentation. How do you treat a query as a structure: SELECT field1, field2 FROM myTable WHERE 0 = 0 #isStruct(test)# #isArray(test)# #isStruct(test['field1'])# #isArray(test['field1'])# Help much appreciated. Adam. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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 and passing SQL commands through a form
Your welcome -Original Message- From: Ryan Kime <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wednesday, July 31, 2002 3:35 PM Subject: RE: CF and passing SQL commands through a form >That's it, thanks Bryan. > >-Original Message- >From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, July 31, 2002 2:16 PM >To: CF-Talk >Subject: Re: CF and passing SQL commands through a form > > >In my oppinion this is the way to go: >http://www.sys-con.com/coldfusion/article.cfm?id=398 > >-Original Message- >From: Ryan Kime <[EMAIL PROTECTED]> >To: CF-Talk <[EMAIL PROTECTED]> >Date: Wednesday, July 31, 2002 3:22 PM >Subject: RE: CF and passing SQL commands through a form > > >>Use for validation purposes. I've seen docs on this, but >>can't remember where off the top of my head. >> >> >>-Original Message- >>From: Chad Gray [mailto:[EMAIL PROTECTED]] >>Sent: Wednesday, July 31, 2002 2:07 PM >>To: CF-Talk >>Subject: CF and passing SQL commands through a form >> >> >>Do we have anything to worry about if someone enters a SQL command into >>a form field or URL? >> >>Like the form is collecting a users ID and passing the users ID to this >>action page: >> >>SELECT * >>FROM users >>WHERE user = #FORM.user# >> >>Can someone enter into the form field: >> >>9; DROP TABLE users; >> >>Thus creating on the action side: >> >>SELECT * >>FROM users >>WHERE user = 9; DROP TABLE users; >> >>Has MM protected us from this kind of attack or do we have to protect >>ourselves with val().. etc...? >> >> >> >> > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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 and passing SQL commands through a form
That's it, thanks Bryan. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:16 PM To: CF-Talk Subject: Re: CF and passing SQL commands through a form In my oppinion this is the way to go: http://www.sys-con.com/coldfusion/article.cfm?id=398 -Original Message- From: Ryan Kime <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wednesday, July 31, 2002 3:22 PM Subject: RE: CF and passing SQL commands through a form >Use for validation purposes. I've seen docs on this, but >can't remember where off the top of my head. > > >-Original Message- >From: Chad Gray [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, July 31, 2002 2:07 PM >To: CF-Talk >Subject: CF and passing SQL commands through a form > > >Do we have anything to worry about if someone enters a SQL command into >a form field or URL? > >Like the form is collecting a users ID and passing the users ID to this >action page: > >SELECT * >FROM users >WHERE user = #FORM.user# > >Can someone enter into the form field: > >9; DROP TABLE users; > >Thus creating on the action side: > >SELECT * >FROM users >WHERE user = 9; DROP TABLE users; > >Has MM protected us from this kind of attack or do we have to protect >ourselves with val().. etc...? > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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 and passing SQL commands through a form
At 02:11 PM 7/31/02 -0500, Ryan Kime wrote: >Use for validation purposes. I've seen docs on this, but >can't remember where off the top of my head. Here's some: http://www.macromedia.com/desdev/articles/ben_forta_faster.htmlhttp://www.macromedia.com/desdev/articles/ben_forta_faster.html T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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 and passing SQL commands through a form
Protect yourself. Depending on someone else will get you in trouble. On Wed, 31 Jul 2002, Chad Gray wrote: > Do we have anything to worry about if someone enters a SQL command into > a form field or URL? > > Like the form is collecting a users ID and passing the users ID to this > action page: > > SELECT * > FROM users > WHERE user = #FORM.user# > > Can someone enter into the form field: > > 9; DROP TABLE users; > > Thus creating on the action side: > > SELECT * > FROM users > WHERE user = 9; DROP TABLE users; > > Has MM protected us from this kind of attack or do we have to protect > ourselves with val().. etc...? > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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 Studio autocomplete
Took the words right out of my mouth! In case you haven't found it yet... http://www.macromedia.com/software/coldfusionstudio/productinfo/resources/ta g_updaters/ -Cameron - Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] > -Original Message- > From: Craig Thomas [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 3:23 PM > To: CF-Talk > Subject: RE: CF Studio autocomplete > > > just curious, have you used the tag updater for CFMX yet? > > >>-Original Message- > >>From: Jon Hall [mailto:[EMAIL PROTECTED]] > >>Sent: Wednesday, July 31, 2002 2:47 PM > >>To: CF-Talk > >>Subject: CF Studio autocomplete > >> > >> > >> Does anyone know which file dictates which tags have closing tags, > >> and which tags display in the autocomplete dropdown as you are > >> typing in Studio 5? I want the MX tags to autocomplete as well... > >> > >>-- > >> Jon > >> mailto:[EMAIL PROTECTED] > >> > >> > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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 and passing SQL commands through a form
In my oppinion this is the way to go: http://www.sys-con.com/coldfusion/article.cfm?id=398 -Original Message- From: Ryan Kime <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wednesday, July 31, 2002 3:22 PM Subject: RE: CF and passing SQL commands through a form >Use for validation purposes. I've seen docs on this, but >can't remember where off the top of my head. > > >-Original Message- >From: Chad Gray [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, July 31, 2002 2:07 PM >To: CF-Talk >Subject: CF and passing SQL commands through a form > > >Do we have anything to worry about if someone enters a SQL command into a >form field or URL? > >Like the form is collecting a users ID and passing the users ID to this >action page: > >SELECT * >FROM users >WHERE user = #FORM.user# > >Can someone enter into the form field: > >9; DROP TABLE users; > >Thus creating on the action side: > >SELECT * >FROM users >WHERE user = 9; DROP TABLE users; > >Has MM protected us from this kind of attack or do we have to protect >ourselves with val().. etc...? > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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: pass a variable to a perl script using CF?
Use CFexecute and call... perl script.pl #username# On Wed, 31 Jul 2002, FlashGuy wrote: > Hello, > > Is there a way to pass a variable to a perl script using CF? > > I need to pass the username which I dump into a variable when the user logs in via >NT authentication to my perl script. This script is being run via a web interface >which executes a > bat file on the server. I the batch file I change directories and execute my perl >script. > > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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 Studio autocomplete
just curious, have you used the tag updater for CFMX yet? >>-Original Message- >>From: Jon Hall [mailto:[EMAIL PROTECTED]] >>Sent: Wednesday, July 31, 2002 2:47 PM >>To: CF-Talk >>Subject: CF Studio autocomplete >> >> >> Does anyone know which file dictates which tags have closing tags, >> and which tags display in the autocomplete dropdown as you are >> typing in Studio 5? I want the MX tags to autocomplete as well... >> >>-- >> Jon >> mailto:[EMAIL PROTECTED] >> >> __ Get the mailserver that powers this list at http://www.coolfusion.com 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
OS X Web Services was Re: X-server?
On Wednesday, July 31, 2002, at 11:20 AM, Dave Watts wrote: > > In fact, I think getting web services working might be a bigger deal, > in the > long run. > > I would like to try to get consuming web services working, but I don't know where to start. Can anyone tell me/ point me to what is supposed to happen when you invove a web service. For instance, the code: http://www.xmethods.net/sd/2001/BabelFishService.wsdl"; method ="BabelFish" returnVariable = "varName" > #varName# Gives the error (below). the Java files generated are in /opt/coldfusionmx/stubs/WS330149168/Net/xmethods/www are: BabelFishBindingStub.java BabelFishPortType.java BabelFishService.java BabelFishServiceLocator.java AFAIK, the only file missing is: BabelFishService.class However, I can't figure out who is responsible for generating the missing file -- or where to start looking. Any help will be greatly apprecioated TIA Dick Error Occurred While Processing Request []java.security.PrivilegedActionException: null The Error Occurred in /opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: line 10 8 : 10 : 11 : #varName# 12 : Please Try The Following: * Check the CFML Reference Manual to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/4.0 (compatible; MSIE 5.14; Mac_PowerPC) Remote Address 127.0.0.1 Referer http://127.0.0.1:8500/mycfmxapps/ Date/Time 31-Jul-02 12:03 PM Stack Trace (click to expand) at cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: 10) at cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: 10) java.security.PrivilegedActionException: java.io.FileNotFoundException: /opt/coldfusionmx/stubs/WS330149168/net/xmethods/www/BabelFishService.class (No such file or directory) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.(FileInputStream.java:64) at coldfusion.jsp.JavaCompiler.load(Unknown Source) at coldfusion.jsp.JavaCompiler.compileClass(Unknown Source) at coldfusion.xml.rpc.XmlRpcServiceImpl$2.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(Unknown Source) at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(Unknown Source) at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebService(Unknown Source) at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebServiceProxy(Unknown Source) at coldfusion.tagext.lang.InvokeTag.doEndTag(Unknown Source) at cfWS12ecfm1726113412.runPage(/opt/coldfusionmx/wwwroot/mycfmxapps/WS1.cfm: 10) at coldfusion.runtime.CfJspPage.invoke(Unknown Source) at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source) at coldfusion.filter.CfincludeFilter.invoke(Unknown Source) at coldfusion.filter.ApplicationFilter.invoke(Unknown Source) at coldfusion.filter.PathFilter.invoke(Unknown Source) at coldfusion.filter.ExceptionFilter.invoke(Unknown Source) at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source) at coldfusion.filter.BrowserFilter.invoke(Unknown Source) at coldfusion.filter.GlobalsFilter.invoke(Unknown Source) at coldfusion.filter.DatasourceFilter.invoke(Unknown Source) at coldfusion.CfmServlet.service(Unknown Source) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 348) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java: 294) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) __ Get the mailserver that powers this list at http://www.coolfusion.com 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!!
for (i=0; i < document.form.field.length; i++) {
if (document.form.field[i].checked) {
var selectedItem = document.form.field[i].value;
}
}
On Wed, 31 Jul 2002, Kris Pilles wrote:
> Last part of my appp... Need a quick answer
>
> I need to know how to reference the name of a select box
> (javascript) I can grab the ID and do everything I want to do But I
> need the displayed name of the selected index also...
>
> Please help
>
> -Original Message-
> From: Michael Wilson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 10:37 AM
> To: CF-Talk
> Subject: RE: Totally OT JavaScript Q
>
>
> "I don't believe this can be done. Are you just seeking to hide the
> field Contents when focused?"
>
> Hi,
>
> Exactly. The design of the site I am working on calls for a couple of
> form fields with initial values of UserName and PassWord. As you no
> doubt are aware, setting the initial value is normally no problem,
> however we need to mask the user's input to the password field; i.e.
> *. Obviously if the form element is of type password, the initial
> value is masked when the form loads.
>
> It's not a big deal really; I was just curious to see if a way existed
> to alter the "type" of the field, onClick or onFocus, so that I could
> meet both requirements.
>
> Thanks allot!
>
> Mike
>
>
>
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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 and passing SQL commands through a form
Use for validation purposes. I've seen docs on this, but can't remember where off the top of my head. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:07 PM To: CF-Talk Subject: CF and passing SQL commands through a form Do we have anything to worry about if someone enters a SQL command into a form field or URL? Like the form is collecting a users ID and passing the users ID to this action page: SELECT * FROM users WHERE user = #FORM.user# Can someone enter into the form field: 9; DROP TABLE users; Thus creating on the action side: SELECT * FROM users WHERE user = 9; DROP TABLE users; Has MM protected us from this kind of attack or do we have to protect ourselves with val().. etc...? __ Get the mailserver that powers this list at http://www.coolfusion.com 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: Importing tables - Access to SQLServer
It's the upsizing wizard. Works well for basic info but in the past I've seen problems when people have yes/no fields in access. (ie: it used to turn yes/no into a bit then the bit couldn't be null. But that was SQL6.5...) And you may want to go in and change the field types as it often will make everything a nvarchar vs varchar With this tool make sure that import/keep or however it's worded indexes checkbox is marked. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 3:03 PM To: CF-Talk Subject: RE: Importing tables - Access to SQLServer Dave, Access has a migration wizard (I forget the name) built-in that will keep all keys and more. --- Ben -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 3:02 PM To: CF-Talk Subject: Importing tables - Access to SQLServer Whenever I import a table into SQL-Server from MS Access I always loose my primary keys. Is there a particular option in Enterprise Manager that I'm overlooking that preserves primary key fields? Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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 Studio autocomplete
Does anyone know which file dictates which tags have closing tags, and which tags display in the autocomplete dropdown as you are typing in Studio 5? I want the MX tags to autocomplete as well... -- Jon mailto:[EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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 5 App crashing every 5 minutes...
What version of CF are you using? If you are using 5 then it will be under settings. As far as the time-out is concerned, I would set it to 30 and then in the templates that you are talking about, you can use requesttimeout= in your url variable. IE: http://www.yourserver.com?requesttimeout= Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: "Joel Blanchette" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 11:40 AM Subject: RE: CF 5 App crashing every 5 minutes... > I have 1 cpu intel 850mhz > > I need the timeout high before some of our stats that go off at the > middle of the night takes a while to finish. We are re-vamping the > stats system right now. Hopefully this will be better in a couple of > weeks. > > I will change it to 5... > > How to I enable strict attribute validation? > > > > == > Joel Blanchette > IT and System Specialist > Point of Impact Technologies Inc. > Tel: (204) 989-0013 > Email: [EMAIL PROTECTED] > == > > > -Original Message- > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 31, 2002 1:20 PM > To: CF-Talk > Subject: Re: CF 5 App crashing every 5 minutes... > > > Limit simultaneous requests to : 10 how many cpu's? > Timeout requests after : 900 s Kinda high dont ya think? 30 - 60 > maybe > Restart at 10 unresponsive requests - I would make this like 5 > Restart when requests terminate abnormally : on > Suppress whitespace by default: on > > > I would also enforce strict attribute validation. > > > > > Douglas Brown > Email: [EMAIL PROTECTED] > - Original Message - > From: "Joel Blanchette" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, July 31, 2002 11:07 AM > Subject: RE: CF 5 App crashing every 5 minutes... > > > > Limit simultaneous requests to : 10 > > Timeout requests after : 900 s > > Restart at 10 unresponsive requests > > Restart when requests terminate abnormally : on > > Suppress whitespace by default: on > > > > Template cache size: 1024 kilobytes > > > > > > Anything else? Let me know where it would be in the menu and I will > > get it.. > > > > Thanks for the help > > > > > > > > == > > Joel Blanchette > > IT and System Specialist > > Point of Impact Technologies Inc. > > Tel: (204) 989-0013 > > Email: [EMAIL PROTECTED] == > > > > > > -Original Message- > > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 31, 2002 12:17 PM > > To: CF-Talk > > Subject: Re: CF 5 App crashing every 5 minutes... > > > > > > What settings do you have in Admin? Max number of threads > etc...Template > > caching? > > > > > > > > > > Douglas Brown > > Email: [EMAIL PROTECTED] > > - Original Message - > > From: "Joel Blanchette" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, July 31, 2002 10:07 AM > > Subject: CF 5 App crashing every 5 minutes... > > > > > > > Hello All, > > > I need big help.Last night, I saw that our server was going > down, > > > then I noticed that it was not the server but more that the > > > cfserver.exe in the task manager was just stopping. If I restart > the > > > serveice it is all good. But I need to do this every 5 > > > minutes...Which is not good...So I wrote a batch file that does it > for > > > > > me. > > > > > > I need to know why this error is happening. It seems like when the > > > cfserver.exe gets around 25 megs or memory use it just stops > > > responding. The task is still there but it will not respond. I'm > > > using CF Server 5 on a Windows server 2000 SP2. Is there something > in > > > > > the threads that I should change? > > > > > > I can post the lines of the error logs of CF here but I need to know > > > which ones u would need. I will need help. I did nothing to the > > > server that would just start doing this. We are getting more > traffic > > > then before. Would that be the cause? If yes, there must be a way > to > > > > > fix this. > > > > > > > > > > > > == > > > Joel Blanchette > > > IT and System Specialist > > > Point of Impact Technologies Inc. > > > Tel: (204) 989-0013 > > > Email: [EMAIL PROTECTED] == > > > > > > > > > > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
