RE: RegEx help
Try this
reReplaceNoCase( string, 'src=".*?/([a-z]+\.[a-z]{3,})"',
'src="#mypath#\1"', "all" )
Havent tried it, but give it a go, might get you going.
Taco Fleur - Chief Executive Officer
Pacific Fox http://www.pacificfox.com.au
an industry leader with commercial IT experience since 1994 .
** Web Design and Development
** SMS Solutions, including developer API
** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for
AUSD$50 two years!
** BlackBerryR Business Solutions www.OzBlackBerry.com
** We endorse PayPal, accept payments online now!
** Seamless Merchant integration
> -Original Message-
> From: r_pringle [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 9 November 2005 1:38 PM
> To: CF-Talk
> Subject: RegEx help
>
>
> I need some help with a regex problem.
>
>
>
> Paging Ben Doom, and other regex Gods.:)
>
>
>
>
>
> I need to change the src path in all img tags in a string.
>
>
>
> IE
>
>
>
> src="http://blahblah/blah/somefile.gif";
>
> or
>
> src="/blahblah/blah/somefile.gif"
>
> or
>
> src="file:/blahblah/blah/somefile.gif"
>
>
>
>
>
> to
>
>
>
> src="#mypath#somefile.gif"
>
>
>
> the image file can be a gif,jpg,png, or tif
>
>
>
> Any help would be greatly appreciated.
>
>
>
>
>
> Thanks
>
>
>
> Randy...
>
>
>
>
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223644
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
AD integration with CF
I can't recall whether it is possible to enable AD integration when the web server is not within the same office? Example; Web Server is hosted with an ISP on a dedicated server that we can control. Can we still authenticate domain users? I would think not, but am not sure of myself anymore, any confirmation would be much appreciated. Thanks, Taco Fleur - Chief Executive Officer Pacific Fox http://www.pacificfox.com.au <http://www.pacificfox.com.au/> an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** BlackBerryR Business Solutions www.OzBlackBerry.com <http://www.ozblackberry.com/> ** We endorse PayPal <https://www.paypal.com/au/mrb/pal=BYLS5532RWQWS> , accept payments online now! ** Seamless Merchant integration ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML Push
#cfhttp.fileContent# ??? Taco Fleur - Chief Executive Officer Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** BlackBerryR Business Solutions www.OzBlackBerry.com ** We endorse PayPal, accept payments online now! ** Seamless Merchant integration > -Original Message- > From: Rolf Kvamme [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 8 November 2005 7:11 AM > To: CF-Talk > Subject: XML Push > > > I am doing an application integration. I did it for the first > partner no problem with > > >value="#sourceID#"> >value="#securityID#"> > >value="#ssn#"> >value="#grossMonthlyIncome#"> > > Works like a charm. I get the ping back and send in the application. > > On the second client I do the same thing to their requested > URL and I get REJECTED!! I ask their intigration specialist > why and he says he needs exactly what xml the cfhttp is > creating. Any ideas on how I can tell what its producing? > > > Rolf > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML Is or NOT?
Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] > Sent: Saturday, 5 November 2005 12:40 AM > To: CF-Talk > Subject: Re: XML Is or NOT? > > > One of the nodes of the XML string is NOT there unless it is > an error .. > > XMLResponse.thisPacket.error > > If all is fine with the request the .error is not there ... > how do I check > to see if .error element is defined ... > > > Paul Giesenhagen > QuillDesign > 417-885-1375 > http://www.quilldesign.com > > > - Original Message - > From: "Adrocknaphobia" <[EMAIL PROTECTED]> > To: "CF-Talk" > Sent: Friday, November 04, 2005 8:26 AM > Subject: Re: XML Is or NOT? > > > > Check the HTTP headers. It's somewhat common to throw a 500 > response > > in the event of an error. > > > > -Adam > > > > On 11/4/05, Paul Giesenhagen <[EMAIL PROTECTED]> wrote: > >> This may be a basic question, but I am recieving some XML and it > >> could be > >> a valid response or it could be an error response... BOTH > are valid XML, > >> but they are formatted differently. > >> > >> I need to check to see if it is the error or not ... > >> > >> If I check for the error XML, and it is not, it errors out > saying it > >> isn't valid XML... how do you check to see if it is a > particular XML > >> document and not error if it is not? > >> > >> Make sense? > >> Paul Giesenhagen > >> QuillDesign > >> 417-885-1375 > >> http://www.quilldesign.com > >> > >> > >> > >> > >> > >> > > > > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SHOUTING
I would use the following regex \b[a-zA-Z][a-z]*\b Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 25 October 2005 4:20 AM > To: CF-Talk > Subject: Re: SHOUTING > > > a brute force method would be to check the ascii number of > each character > (caps have diff number than lower) ;-) > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222126 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Open Source Shopping Cart (was: Shopping Cart)
MM is no more ... Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] > Sent: Saturday, 22 October 2005 5:06 PM > To: CF-Talk > Subject: RE: Open Source Shopping Cart (was: Shopping Cart) > > > I was hoping those features would be released in the next > update for the current version. C'mon MM... what's the hold up? ;) > > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > -Original Message- > From: dave [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 22, 2005 2:41 AM > To: CF-Talk > Subject: Re: Open Source Shopping Cart (was: Shopping Cart) > > by the time its done even rick will be running cfmx 47.1 and > it will be an included feature of cfm along with image > manipulation and insta-site building with mind reading > graphic generations and the whole shabang. > > ~Dave the disruptor~ > "Some people just don't appreciate how difficult it is to > dispense wisdom and abuse at the same time." > > > From: Will Tomlinson <[EMAIL PROTECTED]> > Sent: Friday, October 21, 2005 9:53 PM > To: CF-Talk > Subject: Re: Open Source Shopping Cart (was: Shopping Cart) > > I've actually been workin' on one myself for this very > purpose, and for about 3 months it seems. lol! Kinda tough to > move fast with it though. > > Building productmanager.cfc and already have cart.cfc mostly > complete. > Like cw, the app allows unlimited product options, but mine > will allow images for any of those options. So you could have > an image for red, black, blue for instance. > > I also even have an affiliatetracker.cfc on a working site > that I'll add in. > > > Will > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221921 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT-Visual Web Server
I think they mean virtual hosts? One IP address many hosts, it's the webserver that decides to what website to route the traffic. Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Mickael Elmalem [mailto:[EMAIL PROTECTED] > Sent: Saturday, 22 October 2005 11:29 AM > To: CF-Talk > Subject: OT-Visual Web Server > > > Hello, > > Sorry for being OT but I am sure that someone on this list > can help me out here. I have an app that my customer wants > to host on their own webserver. I gave them the basic config > that I require. They came back to me and said that they have > decided to go with a Single IP, name based Visual Web Server. > > What is this thing? I could not find a straight answer? > > Thanks > > Mike > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221905 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Regex help.
Not only bytes, it's the fact you have to address an array index based upon how many results are matched and in what position the result that you want is. Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Munson, Jacob [mailto:[EMAIL PROTECTED] > Sent: Thursday, 20 October 2005 8:41 AM > To: CF-Talk > Subject: RE: Regex help. > > > Ah, we are discussing the difference between 5 bytes and 1 > byte in RAM? Well, to each his own, whatever works. ;) > Actually, to be honest I got the positions/subexpressions > idea from the MM docs, so I can't take credit for that. > > > -Original Message- > > From: Taco Fleur [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, October 19, 2005 4:30 PM > > To: CF-Talk > > Subject: RE: Regex help. > > > > It does the same, it returns the position, but in your case you are > > suggesting to return many positions and address the correct > position > > to get the result, with look ahead you just don't consume anything > > and only return > > the position of the string you are looking for. > > This transmission may contain information that is privileged, > confidential and/or exempt from disclosure under applicable > law. If you are not the intended recipient, you are hereby > notified that any disclosure, copying, distribution, or use > of the information contained herein (including any reliance > thereon) is STRICTLY PROHIBITED. If you received this > transmission in error, please immediately contact the sender > and destroy the material in its entirety, whether in > electronic or hard copy format. Thank you. A1. > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221575 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Regex help.
It does the same, it returns the position, but in your case you are suggesting to return many positions and address the correct position to get the result, with look ahead you just don't consume anything and only return the position of the string you are looking for. Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Munson, Jacob [mailto:[EMAIL PROTECTED] > Sent: Thursday, 20 October 2005 8:09 AM > To: CF-Talk > Subject: RE: Regex help. > > > Well, refind and friends all return a position in the string. > I don't know of a way to have the desired substring returned > instead of the position of the substring. Are you saying you > can use a look ahead to have a substring returned from refind? > > > -Original Message- > > From: Taco Fleur [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, October 19, 2005 3:59 PM > > To: CF-Talk > > Subject: RE: Regex help. > > > > You extract strings by using look aheads, they do not consume > > anything. > > This transmission may contain information that is privileged, > confidential and/or exempt from disclosure under applicable > law. If you are not the intended recipient, you are hereby > notified that any disclosure, copying, distribution, or use > of the information contained herein (including any reliance > thereon) is STRICTLY PROHIBITED. If you received this > transmission in error, please immediately contact the sender > and destroy the material in its entirety, whether in > electronic or hard copy format. Thank you. A1. > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221571 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Regex help.
You extract strings by using look aheads, they do not consume anything.
Taco Fleur - CEO
Pacific Fox http://www.pacificfox.com.au
an industry leader with commercial IT experience since 1994 .
** Web Design and Development
** SMS Solutions, including developer API
** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for
AUSD$50 two years!
** Seamless Merchant integration
** We endorse PayPal, accept payments online now!
> -Original Message-
> From: Munson, Jacob [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 20 October 2005 7:56 AM
> To: CF-Talk
> Subject: RE: Regex help.
>
>
> How about this:
>
>
>
>
> #Mid(myString1,foundit1.pos[4],foundit1.len[4])#
> #Mid(myString2,foundit2.pos[4],foundit2.len[4])#
>
>
> I don't know of a way to extract a substring from a regular
> expression, but if you use the return subexpressions = true
> option, you can use other functions like Mid to extract the
> desired string from the original.
>
> > -Original Message-
> > From: Emmet McGovern [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, October 19, 2005 3:06 PM
> > To: CF-Talk
> > Subject: RE: Regex help.
> >
> > That will just return the position of the start of name= not
> > the actual
> > formfield name. I need the formfield name.
> >
> > Thanks.
> >
> > -Original Message-
> > From: Munson, Jacob [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, October 19, 2005 4:42 PM
> > To: CF-Talk
> > Subject: RE: Regex help.
> >
> > This should work:
> > ReFind("(name)(=|"")(.*?)\b",myString,1,false)
> >
> > > -Original Message-
> > > From: Emmet McGovern [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, October 19, 2005 2:32 PM
> > > To: CF-Talk
> > > Subject: Regex help.
> > >
> > > I need to get formfield names from a plain html doc loaded as
> > > a string.
> > >
> > > Does anyone with a better grasp of regex know an efficient
> > > way to get the
> > > value of a name of a formfield. (ie name="firstname" returns
> > > firstname) also
> > > taking into consideration variances such as name=firstname.
> > >
> > > Thanks,
> > > Emmet
> >
> > This transmission may contain information that is privileged,
> > confidential
> > and/or exempt from disclosure under applicable law. If you
> are not the
> > intended recipient, you are hereby notified that any
> > disclosure, copying,
> > distribution, or use of the information contained herein
> > (including any
> > reliance thereon) is STRICTLY PROHIBITED. If you received
> > this transmission
> > in error, please immediately contact the sender and destroy
> > the material in
> > its entirety, whether in electronic or hard copy format.
> > Thank you. A1.
> >
> >
> >
> >
> >
> >
>
>
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221568
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RegEx to Empty HREFs
I think reReplace( "()", "\1\2", "all" ) Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Tim Raster [mailto:[EMAIL PROTECTED] > Sent: Thursday, 20 October 2005 7:41 AM > To: CF-Talk > Subject: RegEx to Empty HREFs > > > I tried to read up on the RegEx stuff, but my little brain > can't handle it. > > I have a big string of html text in a variable, and I want to > replace all the HREF parameters within the A tags with empty > strings. For example change all occurrences of: > > ..blah... > > Into this: > > ..blah... > > I basically just want to empty the HREFs. What RegEx > expression can I use in a REReplace? > > TIA! > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221565 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Regex help.
Just woke up, so not sure if this works, but give it a go (?=\w+="?)\w*\b Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Emmet McGovern [mailto:[EMAIL PROTECTED] > Sent: Thursday, 20 October 2005 6:32 AM > To: CF-Talk > Subject: Regex help. > > > I need to get formfield names from a plain html doc loaded as > a string. > > Does anyone with a better grasp of regex know an efficient > way to get the value of a name of a formfield. (ie > name="firstname" returns firstname) also taking into > consideration variances such as name=firstname. > > Thanks, > Emmet > > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [OT] SQL Express
Which part? I'm bad at diggin through the weed... ;-) Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 19 October 2005 9:42 PM > To: CF-Talk > Subject: RE: [OT] SQL Express > > > > From: Taco Fleur [mailto:[EMAIL PROTECTED] > > Does anyone know where I can get a management tool for SQL Express? > > On the MS website they keep talking about "MS SQL Express > > Management Studio" > > but haven't been able to find the download for it, I have > > found the "Express Manager" but it is giving me an error > > saying I need to have at least SP4 windows 2000, admin rights > > etc. and I meet all those criteria's. > > Check this link out... > http://blogs.msdn.com/sqlexpress/ > > HTH, > > Mike > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221460 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
[OT] SQL Express
Does anyone know where I can get a management tool for SQL Express? On the MS website they keep talking about "MS SQL Express Management Studio" but haven't been able to find the download for it, I have found the "Express Manager" but it is giving me an error saying I need to have at least SP4 windows 2000, admin rights etc. and I meet all those criteria's. All I really want is to restore a backup db from MS SQL on the SQL Express instance Thanks, Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au <http://www.pacificfox.com.au/> an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal <https://www.paypal.com/au/mrb/pal=BYLS5532RWQWS> , accept payments online now! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221458 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: PayPal Integration
Actually I think this one does not work with the seamless integration, from what I quickly read. So the question is question is still open, has anyone successfully implemented the seamless API with CF? Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Sean Corfield [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 18 October 2005 5:30 PM > To: CF-Talk > Subject: Re: PayPal Integration > > > On 10/17/05, Taco Fleur <[EMAIL PROTECTED]> wrote: > > Just wondering has anyone got the PayPal seamless API working with > > ColdFusion? > > > > I am getting a "500 null" error, which is not documented in the > > documentation anywhere. > > Have you considered using Continuum Media's PayPalMX wrapper? > http://web-relevant.com/web-relevant/index.cfm?fuseaction=main.paypalmx -- Sean A Corfield -- http://corfield.org/ Got frameworks? "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: PayPal Integration
Hi Sean, No I haven't, but I will now. I guess that means that people have been able to get it integrated with CF. Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal, accept payments online now! > -Original Message- > From: Sean Corfield [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 18 October 2005 5:30 PM > To: CF-Talk > Subject: Re: PayPal Integration > > > On 10/17/05, Taco Fleur <[EMAIL PROTECTED]> wrote: > > Just wondering has anyone got the PayPal seamless API working with > > ColdFusion? > > > > I am getting a "500 null" error, which is not documented in the > > documentation anywhere. > > Have you considered using Continuum Media's PayPalMX wrapper? > http://web-relevant.com/web-relevant/index.cfm?fuseaction=main.paypalmx -- Sean A Corfield -- http://corfield.org/ Got frameworks? "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
PayPal Integration
Just wondering has anyone got the PayPal seamless API working with ColdFusion? I am getting a "500 null" error, which is not documented in the documentation anywhere. Taco Fleur - CEO Pacific Fox http://www.pacificfox.com.au <http://www.pacificfox.com.au/> an industry leader with commercial IT experience since 1994 . ** Web Design and Development ** SMS Solutions, including developer API ** Domain Registration, .COM for as low as AUSD$15 a year, .COM.AU for AUSD$50 two years! ** Seamless Merchant integration ** We endorse PayPal <https://www.paypal.com/au/mrb/pal=BYLS5532RWQWS> , accept payments online now! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Client variables
Have a look at this, this will clear some of this up for you.
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17915
Basically you need to set per-session cookies.
Taco Fleur - CEO
Pacific Fox http://www.pacificfox.com.au
an industry leader with commercial IT experience since 1994 .
** Web Design and Development
** SMS Solutions, including developer API
** Domain Registration, .com for as low as AUSD$15 a year
** Seamless Merchant integration
** We endorse PayPal, accept payments online now!
> -Original Message-
> From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
> Sent: Saturday, 8 October 2005 6:36 PM
> To: CF-Talk
> Subject: Client variables
>
>
> Hi guys,
>
> I have a competition on my site. When a user enters the competition
> I set a client variable:
>
>
>
> I tested the competition a few days ago and now when i come to look
> at it I can see that the Client variable
> client.competitionEntry#url.ID# must still be equalling 1 as this
> line is in effect:
>
>
> ('client.competitionEntry#url.ID#')>
>
> Show competition form here.
>
>
>
>
> You have entered this competition.
>
> I automatically thought that client variables would end once the
> browser has been closed? I have had my Mac switched off overnight,
> how could this be?
>
> Anyone who can shed some light on this I'd be very grateful.
>
> Thanks,
>
> Saturday
>
>
>
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220478
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Make a loop repeat and control timing?
Correct. Not sure if it works with anything else. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Eddie Awad [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 5 October 2005 8:40 AM > To: CF-Talk > Subject: Re: Make a loop repeat and control timing? > > > On 10/4/05, Taco Fleur <[EMAIL PROTECTED]> wrote: > > Or if on a lower version of CF you could use the WAITFOR command in > > SQL within a cfquery tag.. > That would be in MS SQL Server, right? > -- > Eddie Awad. > http://awads.net/ > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220084 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Make a loop repeat and control timing?
You can create the pause with Or if on a lower version of CF you could use the WAITFOR command in SQL within a cfquery tag.. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Les Mizzell [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 5 October 2005 8:01 AM > To: CF-Talk > Subject: Make a loop repeat and control timing? > > > Is there any way to force CFLOOP into an endless loop, using > cfsleep to > control the timing of advancement? > > Something like: > > >1. Do something >2. wait 2 seconds then next step >3. if "i" = 20 start over > > > Yea, I know it's crazy. Javascript is a better way to go, but I > just wondered it this was possible... > > --- > Les Mizzell > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220081 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Server + internal/external IPs
Hi Kay, No, you can tell HyperTerminal (not terminal services, the two sound alike, I almost wrote terminal services) to listen on a port, in this case you should run it on the port your SQL server is running, then you make a request to it, and you should be able to see if it is able to reach the machine on the port. I guess we are just trying to see if the port is really open on the machine. And then debug from there. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Kay Smoljak [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 4 October 2005 6:35 PM > To: CF-Talk > Subject: Re: SQL Server + internal/external IPs > > > On 10/4/05, Taco Fleur <[EMAIL PROTECTED]> wrote: > > Check if the port is really accessible by running hyperterminal on > > that port and make a call to it from outside, see if it answers? > > Thanks Taco, > I can remote desktop into the machine using the external > address from outside our network, as well as access the site > running on it using both the external IP and the host header > assigned to it. I can remote desktop into the machine from > inside our network using the internal IP. Is that what you mean? > > K. > > > > > > > -Original Message- > > > From: Kay Smoljak [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, 4 October 2005 5:12 PM > > > To: CF-Talk > > > Subject: OT: SQL Server + internal/external IPs > > > > > > > > > Hey people, > > > > > > I have a problem with SQL Server on a new dev box we've > set up and I > > > don't know where else to ask... > > > > > > The machine has two network interfaces - an internal > 10.0.0.n IP and > > > an external 203.n.n.n IP. I can connect to the local 10.0.0.n IP > > > using Enterprise Manager no problems - but not using the > external IP > > > (it says it doesn't exist). This is Windows 2003 and SQL > Server 2000 > > > with SP3a. I've dropped the firewall completely to see if > that was > > > the problem but it makes no difference. > > > > > > Anyone know where I should look? > > > > > > Also, if anyone is in Perth (West Australia) and is looking for a > > > casual position with a view to full time work, please > check out this > > > ad: http://www.port80.asn.au/forums/viewtopic.php?t=2158 > > > (and no, we aren't considering telecommuters, sorry) > > > > > > -- > > > Kay Smoljak > > > http://kay.zombiecoder.com/ > > > > > > > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219991 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Server + internal/external IPs
Check if the port is really accessible by running hyperterminal on that port and make a call to it from outside, see if it answers? Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Kay Smoljak [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 4 October 2005 5:12 PM > To: CF-Talk > Subject: OT: SQL Server + internal/external IPs > > > Hey people, > > I have a problem with SQL Server on a new dev box we've set > up and I don't know where else to ask... > > The machine has two network interfaces - an internal 10.0.0.n > IP and an external 203.n.n.n IP. I can connect to the local > 10.0.0.n IP using Enterprise Manager no problems - but not > using the external IP (it says it doesn't exist). This is > Windows 2003 and SQL Server 2000 with SP3a. I've dropped the > firewall completely to see if that was the problem but it > makes no difference. > > Anyone know where I should look? > > Also, if anyone is in Perth (West Australia) and is looking > for a casual position with a view to full time work, please > check out this > ad: http://www.port80.asn.au/forums/viewtopic.php?t=2158 > (and no, we aren't considering telecommuters, sorry) > > -- > Kay Smoljak > http://kay.zombiecoder.com/ > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219989 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Invoking query and fails
Change the name and remove session. Then add a return statement SELECT blablabla FROM If you want to set the query in the session scope you should do that after the call to the function, i.e. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development We endorse PayPal, accept payments online now! > -Original Message- > From: Michel Deloux [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 4 October 2005 7:09 AM > To: CF-Talk > Subject: Invoking query and fails > > > Hi all > > we have a form with simple fields. If session.nameofquery is > not defined I invoke a cfc to get that data. Looks like: > > > > > #ID_name" > > > > > > > > > > This is my simple function: > > hint="Get all names" returntype="void"> > > > SELECT > blablabla > FROM > blablabla > > > OK, OK, the good CFC practices Manual don't uses session > inside components. Right. But using application scope don't > work... ;-( > > In the first call to CFC I invoke that cfc which output a > query. But after cfoutput CF throws an error: > > Complex object types cannot be converted to simple values. > > Why? That cfc returns a query right? Or I'me wrong? > > Cheers > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219982 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Server 2000 Full-text search issues
You need to rebuild the full-text catalog when you restore the db Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development We endorse PayPal, accept payments online now! > -Original Message- > From: George Abraham [mailto:[EMAIL PROTECTED] > Sent: Saturday, 1 October 2005 11:25 PM > To: CF-Talk > Subject: Re: SQL Server 2000 Full-text search issues > > > Hi, > Full-text search on SQL Server 2K gave me huge problems. Not > only was the code to conduct a full-text search cumbersome, > but the user had to learn how to define searches in ways that > were not really fair to the user. That is why I decided to > turn to another appliance for full-text search structured > databases. At first I tried using the Verity search already > packaged with CFMX. However I soon ran into scaling issues in > terms of the number of records that Verity will store. Since > one of my dbs stores more than 100K records, that alone would > take up the limits of Verity's licence. Buying an unlimited > (or whatever) licence for Verity was a bazillion dollars. > Similar problems with buying a Google search appliance. We > decided to go with Lucene from the Jakarta project which is a > simply beautiful product. And it is free. Of course you have > to learn Java, but the Lucene email lists are extremely > helpful. Besides Aaron Johnson has some code over at ( > http://cephas.net/blog/2003/12/06/indexing_database_content_wi > th_lucene_coldfusion.html) > that even talks about CF and Lucene. > > I know this doesn't solve your current problem, but I ran > into issues with SQL server like you did and some of them > were having our customers (and I, to some extent) tear their hair out. > > If you need some help with CF and Lucene, I can list some > resources or email me offlist. > > George > > > On 9/30/05, Martin Parry <[EMAIL PROTECTED]> wrote: > > > > I too get this on my 2003 cluster. I restored the database > as a backup > > from my dev box (which it works on) and do a full rebuild - > It takes > > but a second to say its complete and then gives me absolutely no > > results. > > > > If I find a solution I'll post it here. IF! > > > > Martin Parry > > http://www.beetrootstreet.com > > > > -Original Message- > > From: Burns, John D [mailto:[EMAIL PROTECTED] > > Sent: 30 September 2005 16:22 > > To: CF-Talk > > Subject: SOT: SQL Server 2000 Full-text search issues > > > > I have a development CF server (Windows 2003 Server, SQL > Server 2000 > > SP4, CFMX 6.1) on which I have a database that has > full-text enabled > > on a table. When I run a query against the full-text index, > it returns > > 31 rows. > > > > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219829 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Now more query problems... boo hoo
You can use it in the order by clause, he just needs to group all the columns in his query with GROUP BY. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 10:30 PM > To: CF-Talk > Subject: RE: Now more query problems... boo hoo > > > You can't use COUNT in the ORDER BY clause. (Please someone > back me up here else I'm off to spend some time with Book Online!). > > Ade > > -Original Message- > From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] > Sent: 29 September 2005 13:20 > To: CF-Talk > Subject: Now more query problems... boo hoo > > > Jumping from one query problem to another... just when it was > safe to to run a query another problem leapt out of the dungeons. > > I would like to only pull the top 8 authors who have the most > articles (articleID) > > I have specified only to get the 8 maxrows but the problem > i'm having is when i try to add to the ORDER BY COUNT(articleID) DESC > > My error is: > > [Macromedia][SQLServer JDBC Driver][SQLServer]Column > 'tbl_020authorDetails.authorID' is invalid in the select list > because it is not contained in an aggregate function and > there is no GROUP BY clause. > > It can be seen at: http://www.020.com/testsql.cfm > > > > SELECT > tbl_020authorDetails.authorID, > tbl_020authorDetails.authorFirstName, > tbl_020authorDetails.authorSurname, > tbl_020authorDetails.authorPhotograph, > tbl_020authorDetails.authorAboutMe, > tbl_020articleDetails.articleID, > tbl_020articleDetails.articleTitle > FROM tbl_020articleDetails > INNER JOIN tbl_020authorDetails ON > tbl_020articleDetails.authorID = tbl_020authorDetails.authorID > WHERE tbl_020authorDetails.authorPhotograph <> '' AND > tbl_020articleDetails.articleSubTypeID <> 55 > ORDER BY tbl_020authorDetails.authorID, COUNT(articleID) > DESC > > > #authorFirstName# > > my articles: > #articleTitle# > > > Any help would be great. > > Thanks, > > Stuart > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219588 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: clear session variables for testing
structClear() actually deletes other info that you might wish to keep, like cfid stuff. Your better of always setting your session variables in another structure, i.e. Session.user.username = "blah"; Session.user.firstname = "blah"; That way when you only want to expire the user details of the session you can just do structDelete( session, "user" ) It gives you more control. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 10:31 PM > To: CF-Talk > Subject: RE: clear session variables for testing > > > StructClear(SESSION) > > Ade > > -Original Message- > From: Mark Fuqua [mailto:[EMAIL PROTECTED] > Sent: 29 September 2005 13:23 > To: CF-Talk > Subject: clear session variables for testing > > > Good Morning, > > Is there an easy way to clear all session variables? It > would help me test for behaviors after session variables have > timed out. > > Thanks, > > Mark > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219586 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Every once in a while, I feel smart. A story of displaying a single random image.
I guess in the end it comes down to personal opinion and experience. In my opinion it is really not worth caching a query like this, lets say we are dealing with 10.000 records, and you want a random record, no way that it would be cost efficient to cache it, unless memory management is not a worry. Even when dealing with only a few records the hassle of 'caching and purging when needed' to me is not worth it, a trip to db and the query itself on MS SQL means nothing. But like I said, it's a matter of personal opinion ;-) Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 2:56 PM > To: CF-Talk > Subject: RE: Every once in a while, I feel smart. A story of > displaying a single random image. > > > > -----Original Message- > > From: Taco Fleur [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 11:47 PM > > To: CF-Talk > > Subject: RE: Every once in a while, I feel smart. A story of > > displaying a single random image. > > > > Hmm, sorry to break your bubbles but both solutions are very > > inefficient. > > > > The best thing to do is (in MS SQL) > > > > SELECT TOP 1 * > > FROM yourTable > > ORDER BY NEWID() > > > > That will give you a random record every time and you are not > > transferring a whole record set over the network. > > Well... it's not really a random value (but close enough for > practical purposes). ;^) > > But forgetting that I think we're both making assumptions > about the usage. I was under the impression from the original > poster that this random image would be displayed a lot - so > using a cached query and doing what I (or the original > poster) suggested would be faster by far than forcing the > database to generate and sort GUIDS for every image every > time you want an image. > > It's really the old argument of "where" - do you do this in > CF or in the database. All the solutions presented will work > - but some work better depending on how often you use them > and how much you can cache. > > I was under the assumption that the album application would > be making use of the query information quite a bit. It would > probably be on hand cached some place. If that's the case > it's silly to make a round trip to the database to fetch > random record when you have the data already. > > But if the data's not be used elsewhere on the page or is not > cached and you're really only doing the query for a single > random image then your solution makes more sense. > > Jim Davis > > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219564 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Every once in a while, I feel smart. A story of displaying a single random image.
NEWID() creates a unique ID for every record, since its unique everytime you call it and you are ordering by this field/function, the record returned is random. Make sense? Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 2:00 PM > To: CF-Talk > Subject: RE: Every once in a while, I feel smart. A story of > displaying a single random image. > > > Being lazy and not fishing out my sql ref's - how does the > newID() work? I think this could reduce some of my code dramatically!! > > mike > > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 3:47 p.m. > To: CF-Talk > Subject: RE: Every once in a while, I feel smart. A story of > displaying a single random image. > > > Hmm, sorry to break your bubbles but both solutions are very > inefficient. > > The best thing to do is (in MS SQL) > > SELECT TOP 1 * > FROM yourTable > ORDER BY NEWID() > > That will give you a random record every time and you are not > transferring a whole record set over the network. > > Have fun ;-) > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > > -Original Message- > > From: Jim Davis [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 29 September 2005 1:29 PM > > To: CF-Talk > > Subject: RE: Every once in a while, I feel smart. A story of > > displaying a single random image. > > > > > > > -Original Message- > > > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, September 28, 2005 11:11 PM > > > To: CF-Talk > > > Subject: Every once in a while, I feel smart. A story of > > displaying a > > > single random image. > > > > > > I thought I'd share this simple solution that I came up with. > > > > Great idea - nothing like some brain fuel. ;^) > > > > > I'm building a site that has a photo album as part of it. > > The image > > > data (caption, description, filename, etc.) is stored in a > > SQL Server > > > database and the image is on the server file system. > > > > > > > > > > > > Finally, and here's where the dead-simple beauty of all > > this comes in, > > > display the random image using cfloop's startrow and endrow > > using the > > > randImgRow value: > > > > > > > > endrow="#randImgRow#"> > > href="/album/default.cfm?albumid=#getrandimage.album_id#"> > > src="/images/album/#getRandImage.thumbnail#" > > > alt="#getRandImage.caption#" > > > class="thumbnail"> > > > > Just to be a jerk however... > > > > You don't actually need the loop at all. Remember that you > can access > > a query using indexed notation - so the above could be written as: > > > > > > > href="/album/default.cfm?albumid=#getrandimage.album_id[randIm > > gRow]#"> src="/images/album/#getRandImage.thumbnail[randImgRow]#" > > alt="#getRandImage.caption[randImgRow]#" > > class="thumbnail"> > > > > Of course both solutions do the exact same thing and both > access the > > query... I wouldn't be surprised to find them both about the same > > performance-wise as well. Mine is really just a little less code. > > > > I cover this in more details in my "Guide to CFML Variables" here: > > > http://www.depressedpress.com/Content/Development/ColdFusion/G uides/Vari able s/NotationIndexed.cfm Don't get me wrong tho' - I agree completely about "informational" posts like this. I wish more people would throw up snippets when they get something to work. ;^) Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Every once in a while, I feel smart. A story of displaying a single random image.
Hmm, sorry to break your bubbles but both solutions are very inefficient. The best thing to do is (in MS SQL) SELECT TOP 1 * FROM yourTable ORDER BY NEWID() That will give you a random record every time and you are not transferring a whole record set over the network. Have fun ;-) Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Jim Davis [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 1:29 PM > To: CF-Talk > Subject: RE: Every once in a while, I feel smart. A story of > displaying a single random image. > > > > -Original Message- > > From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 11:11 PM > > To: CF-Talk > > Subject: Every once in a while, I feel smart. A story of > displaying a > > single random image. > > > > I thought I'd share this simple solution that I came up with. > > Great idea - nothing like some brain fuel. ;^) > > > I'm building a site that has a photo album as part of it. > The image > > data (caption, description, filename, etc.) is stored in a > SQL Server > > database and the image is on the server file system. > > > > > > > > Finally, and here's where the dead-simple beauty of all > this comes in, > > display the random image using cfloop's startrow and endrow > using the > > randImgRow value: > > > > > endrow="#randImgRow#"> > href="/album/default.cfm?albumid=#getrandimage.album_id#"> > src="/images/album/#getRandImage.thumbnail#" > > alt="#getRandImage.caption#" > > class="thumbnail"> > > Just to be a jerk however... > > You don't actually need the loop at all. Remember that you > can access a query using indexed notation - so the above > could be written as: > > > href="/album/default.cfm?albumid=#getrandimage.album_id[randIm > gRow]#"> src="/images/album/#getRandImage.thumbnail[randImgRow]#" > alt="#getRandImage.caption[randImgRow]#" > class="thumbnail"> > > Of course both solutions do the exact same thing and both > access the query... I wouldn't be surprised to find them both > about the same performance-wise as well. Mine is really just > a little less code. > > I cover this in more details in my "Guide to CFML Variables" here: > http://www.depressedpress.com/Content/Development/ColdFusion/Guides/Variable s/NotationIndexed.cfm Don't get me wrong tho' - I agree completely about "informational" posts like this. I wish more people would throw up snippets when they get something to work. ;^) Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
> There were a couple typos, but it works rather nicely. Try > > SELECT * > FROM ( > SELECT TOP 20 * > FROM (SELECT TOP 220 * > FROM table C > ORDER BY C.column ASC) B > ORDER BY B.column DESC ) A > ORDER BY A.column ASC Ahh I see, I put the * infront of TOP Also, you probably want to put this as a stored procedure and pass in the parameters @curentPage INT, @rowPerPage INT SELECT * FROM ( SELECT TOP 20 * FROM (SELECT TOP ( ( @rowPerPage * @curentPage ) + @rowPerPage ) yourColumn1, yourColumn2 FROM yourTable C ORDER BY C.yourOrderColumn ASC) B ORDER BY B.yourOrderColumn DESC ) A ORDER BY A.yourOrderColumn ASC Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219537 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Idea for better hosting
Just curious, is this post in any way directed to us? Just asking because it seems you replied to a post I wrote. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: DRE [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 7:33 AM > To: CF-Talk > Subject: Idea for better hosting > > > Hey, I just had an idea for you guys working at hosting companies. > > Instead of just running each site on one server where its > depenedent on all the other sites workign well, why not load > balance between 2 or 3 servers. If you think about it, it > shouldnt cost more because you'd be able to put twice as many > sites on each machine because the load would be that > proportion smaller(other than the loadbalancer). If one goes > south, then the load balancing would work while you reboot > the machine. All you'd have to do is setup some sort of > directory watching so that the user would only have to > maintain files on one machine. Presto, no more stupid "the > jrun service is unavailable" messages. > > DRE > > On 9/28/05, Taco Fleur <[EMAIL PROTECTED]> wrote: > > > > The idea works, I have it implemented in several places. > > Any more details as why it didn't work for you? > > > > Taco Fleur - Pacific Fox > > an industry leader with commercial IT experience since 1994 . > > http://www.pacificfox.com - Web Design and Development > > > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219529 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML Signature and CF
Have you got a key that you need to sign with etc.? I should have a java class somewhere that allows you to create signatures. You can easily call it from CF or wrap it in a CFC. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Rolf Kvamme [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 7:18 AM > To: CF-Talk > Subject: XML Signature and CF > > > We have used xml for a few years now and suddenly have a > requirment for using a digital signature with a new partner. > > Are there any toolkits etc, that play well with CF that I can > use pretty readilly to sign our xml? > > Rolf Kvamme > Director of Development > ADTEL INTL > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219525 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: null value
Null does not exist in coldfusion, you can test for len() as you have, or Another thing you could do if you wanted to really know if a column is null instead of an empty string, you could use COALESCE in your select, i.e. SELECT COALESCE( yourColumn, 'null' ) AS myColumn In CF It's not pretty, but it depends on what you are looking for. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 6:29 AM > To: CF-Talk > Subject: null value > > > hi there, > > i have the following query ... > > password="#Request.app.DBpassword#" > username="#Request.app.DBusername#"> > SELECT orders.order_id, orders.dCreated, > orders.billing_fname, orders.billing_lname, > orders.billing_country, orders.currency, > orders.currency_value, orders.order_status, > payment_authority.success, payment_authority.responseText > FROM orders LEFT OUTER JOIN payment_authority > ON orders.order_id = payment_authority.order_id > WHERE order_receipt_sent = cfsqltype="cf_sql_bit" value="0"> ORDER BY orders.dCreated > DESC > > i am using an outer join as i wish to display all orders > whether they have an associated entry in the > payment_authority table or not. with each row of the query i > display the #payment_authority.responseText# value. the > payment_authority.responseText data is variable. > > now if the row does not have any associated entries in the > payment_authority table, how do i reference the > [empty-string] value returned? > > eg. does not > seem to recognise the null value. > > > Kind Regards > > Mike Little > [ Designer ] > > Graphic Impact Ltd > 40 College Hill, Ponsonby, Auckland > DDI +64 9 376 7622 > Fax +64 9 376 7360 > > _ > > CAUTION: This e-mail message and accompanying data may > contain information that is confidential. If you are not the > intended recipient you are notified that any use, > dissemination, distribution or copying of this message or > data is prohibited. All content is to be treated as > confidential unless otherwise specified, and is not to be > forwarded to third parties without the prior permission of > the author. To do so may breach the New Zealand Privacy Act > 1993. If you have received this > e-mail message in error please delete it and notify me. Thank you. > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL row select?
Yup, tested it, works like a charm here mate. So unless you provide any more input as to why you think it doesn't work I won't be able to help you out. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Matthew Small [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 6:58 AM > To: CF-Talk > Subject: RE: SQL row select? > > > Not only the IN method work, but yours did not, at least on > MSSQL. I tried it. > > Now that's not necessarily the most efficient solution > around, but if you have millions and millions of records to > parse through with CF, then you need a DBA to ensure proper > indexing and all that jazz, so you can let him write it. > > > Matthew Small > Web Developer > American City Business Journals > 704-973-1045 > [EMAIL PROTECTED] > > > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 4:24 PM > To: CF-Talk > Subject: RE: SQL row select? > > I would not expect an answer like that from a proper DBA. > > Not sure if we are talking about MS SQL or MySQL, but the > idea is to work with subqueries. > > SELECT * > FROM ( > SELECT * TOP 20 > FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 > FROM yourTable C > ORDER BY C.yourOrderColumn ASC) B > ORDER BY B.yourOrderColumn DESC ) A > ORDER BY A.yourOrderColumn ASC > > Where 200 is for example the current row you are on and 20 is > the number of records you want to retrieve. The idea is to > first get TOP currentRow + numberOfRowToRetrieve Then order > descending and get the top 20 Then order ascending and select all > > This way you only transfer from the DB over the network what > you need to, and the query is not inefficient, especially if > you got the right indexes. > > Now, its early here, so I might have made a mistake, but you > get the general idea. I think the previous sample with IN > does not work, especially not efficient. > > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > > -Original Message- > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 29 September 2005 2:25 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > Here's a post from a DBA I'm friends with: > > > > > > Just pull the entire query over to CF and use query of > > queries, to grab > > your "paged" row sets. I work with record sets of millions > > and it works > > very nicely. > > > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > From: Greg Morphis [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 10:59 AM > > To: CF-Talk > > Subject: Re: SQL row select? > > > > > > Select top 50 * from table > > Where id not in > > > > ( select top 199 id from table > >order by date, alpha) > > > > order by date, alpha > > > > that works but what if you are paging through a million > > records as suggested before? wouldnt the inner query select > > the top 999,999 rows? IE > > > > Select top 50 * from table > > Where id not in > > ( > >select top 99 id from table > >order by date, alpha > > ) > > order by date, alpha > > > > > > I think thats what Mike K was talking about. > > > > > > > > On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > > > Did no one see this post? After reading, and re-reading the > > original > > > post, it looks like this simple SQL statement is the answer > > (assuming > > > that MSSQL supports the LIMIT clause: > > > > > > SELECT * > > > FROM tablename > > > LIMIT #startrow#, #totalrecords# > > > > > > or > > > > > > SELECT * > > > FROM tablename > > > LIMIT 200, 50 > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.370.1530 x737 > > > --//-> > > > > > > -Original Message- > > > From: Andy Matthews [mailto:[
RE: SQL row select?
The idea works, I have it implemented in several places. Any more details as why it didn't work for you? Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Matthew Small [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 6:58 AM > To: CF-Talk > Subject: RE: SQL row select? > > > Not only the IN method work, but yours did not, at least on > MSSQL. I tried it. > > Now that's not necessarily the most efficient solution > around, but if you have millions and millions of records to > parse through with CF, then you need a DBA to ensure proper > indexing and all that jazz, so you can let him write it. > > > Matthew Small > Web Developer > American City Business Journals > 704-973-1045 > [EMAIL PROTECTED] > > > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 4:24 PM > To: CF-Talk > Subject: RE: SQL row select? > > I would not expect an answer like that from a proper DBA. > > Not sure if we are talking about MS SQL or MySQL, but the > idea is to work with subqueries. > > SELECT * > FROM ( > SELECT * TOP 20 > FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 > FROM yourTable C > ORDER BY C.yourOrderColumn ASC) B > ORDER BY B.yourOrderColumn DESC ) A > ORDER BY A.yourOrderColumn ASC > > Where 200 is for example the current row you are on and 20 is > the number of records you want to retrieve. The idea is to > first get TOP currentRow + numberOfRowToRetrieve Then order > descending and get the top 20 Then order ascending and select all > > This way you only transfer from the DB over the network what > you need to, and the query is not inefficient, especially if > you got the right indexes. > > Now, its early here, so I might have made a mistake, but you > get the general idea. I think the previous sample with IN > does not work, especially not efficient. > > > Taco Fleur - Pacific Fox > an industry leader with commercial IT experience since 1994 . > http://www.pacificfox.com - Web Design and Development > > > > > -Original Message- > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > Sent: Thursday, 29 September 2005 2:25 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > Here's a post from a DBA I'm friends with: > > > > > > Just pull the entire query over to CF and use query of > > queries, to grab > > your "paged" row sets. I work with record sets of millions > > and it works > > very nicely. > > > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > From: Greg Morphis [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 10:59 AM > > To: CF-Talk > > Subject: Re: SQL row select? > > > > > > Select top 50 * from table > > Where id not in > > > > ( select top 199 id from table > >order by date, alpha) > > > > order by date, alpha > > > > that works but what if you are paging through a million > > records as suggested before? wouldnt the inner query select > > the top 999,999 rows? IE > > > > Select top 50 * from table > > Where id not in > > ( > >select top 99 id from table > >order by date, alpha > > ) > > order by date, alpha > > > > > > I think thats what Mike K was talking about. > > > > > > > > On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > > > Did no one see this post? After reading, and re-reading the > > original > > > post, it looks like this simple SQL statement is the answer > > (assuming > > > that MSSQL supports the LIMIT clause: > > > > > > SELECT * > > > FROM tablename > > > LIMIT #startrow#, #totalrecords# > > > > > > or > > > > > > SELECT * > > > FROM tablename > > > LIMIT 200, 50 > > > > > > > > andy matthews > > > web developer > > > ICGLink, Inc. > > > [EMAIL PROTECTED] > > > 615.370.1530 x737 > > > --//-> > > > > > > -Original Message- > > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, Se
RE: SQL row select?
I would not expect an answer like that from a proper DBA. Not sure if we are talking about MS SQL or MySQL, but the idea is to work with subqueries. SELECT * FROM ( SELECT * TOP 20 FROM (SELECT TOP (200 + 20) yourColumn1, yourColumn2 FROM yourTable C ORDER BY C.yourOrderColumn ASC) B ORDER BY B.yourOrderColumn DESC ) A ORDER BY A.yourOrderColumn ASC Where 200 is for example the current row you are on and 20 is the number of records you want to retrieve. The idea is to first get TOP currentRow + numberOfRowToRetrieve Then order descending and get the top 20 Then order ascending and select all This way you only transfer from the DB over the network what you need to, and the query is not inefficient, especially if you got the right indexes. Now, its early here, so I might have made a mistake, but you get the general idea. I think the previous sample with IN does not work, especially not efficient. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: Thursday, 29 September 2005 2:25 AM > To: CF-Talk > Subject: RE: SQL row select? > > > Here's a post from a DBA I'm friends with: > > > Just pull the entire query over to CF and use query of > queries, to grab > your "paged" row sets. I work with record sets of millions > and it works > very nicely. > > > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 10:59 AM > To: CF-Talk > Subject: Re: SQL row select? > > > Select top 50 * from table > Where id not in > > ( select top 199 id from table >order by date, alpha) > > order by date, alpha > > that works but what if you are paging through a million > records as suggested before? wouldnt the inner query select > the top 999,999 rows? IE > > Select top 50 * from table > Where id not in > ( >select top 99 id from table >order by date, alpha > ) > order by date, alpha > > > I think thats what Mike K was talking about. > > > > On 9/28/05, Andy Matthews <[EMAIL PROTECTED]> wrote: > > Did no one see this post? After reading, and re-reading the > original > > post, it looks like this simple SQL statement is the answer > (assuming > > that MSSQL supports the LIMIT clause: > > > > SELECT * > > FROM tablename > > LIMIT #startrow#, #totalrecords# > > > > or > > > > SELECT * > > FROM tablename > > LIMIT 200, 50 > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, September 28, 2005 8:57 AM > > To: CF-Talk > > Subject: RE: SQL row select? > > > > > > I don't use MS SQL but doesn't it support the LIMIT keyword in the > > SELECT statement? > > > > SELECT * > > FROM tablename > > LIMIT #startrow#, #totalrecords# > > > > or > > > > SELECT * > > FROM tablename > > LIMIT 200, 50 > > > > > andy matthews > > web developer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --//-> > > > > -Original Message- > > > > >Ok, I feel like this should be something simple but my brain just > > >isn't working this morning. Besides using CFOUTPUT with > the startrow > > >and maxrows attributes, is there a way in my SQL itself to specify > > >that I want it to grab 50 rows starting at the 200th row. > I'm trying > > >to make a paged approach to a query that could potentially > have about > > >20,000 records returned. I'd much rather just have MS SQL > return 50 > > >rows at a time by telling it which row to start at rather > than having > > >it return a 20,000 recordset to CF and then only output 50. I'm > > >hoping this is something easy and my brain just hasn't > woken up yet. > > >Any thoughts would be appreciated. > > > > > >John Burns > > >Certified Advanced ColdFusion MX Developer > > >Wyle Laboratories, Inc. | Web Developer > > > > > > > > > > ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219512 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Suggestions wanted
Throw a regex over it, maybe something like
{?=<)[\^](?=>)
It's early, no time to test, but give it a go.
I hope I haven't contributed to a spamming scheme ;-)
Taco Fleur - Pacific Fox
an industry leader with commercial IT experience since 1994 .
http://www.pacificfox.com - Web Design and Development
> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Thursday, 29 September 2005 5:26 AM
> To: CF-Talk
> Subject: Suggestions wanted
>
>
> I'm looking for some suggestions on the best way to get email
> addresses
> from a string that looks like this:
>
> "Rick Root" <[EMAIL PROTECTED]>
>
> or
>
> "Rick Root" <[EMAIL PROTECTED]>,"Root, Rick"
> <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
>
> Ultimately, the latter should return an array or email addresses.
>
> To the best of my knowledge, all email addresses will be
> contained in <>'s.
>
> Rick
>
>
>
>
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219509
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: comparing dates
In SQL it would be SELECT * FROM yourTable WHERE yourDate BETWEEN startDateColumn AND endDateColumn In CF it would be date 1 is greater thandate 2 Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: DIEDLER Alexander [mailto:[EMAIL PROTECTED] > Sent: Monday, 26 September 2005 4:59 PM > To: CF-Talk > Subject: comparing dates > > > Hello, > I have to create a appliaction with time based visibility. So > I have a start date and end date for the period in which the > article should be visible. How can I check, if the actual > sysdate is between the start and end date or out of this range? > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219223 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: regex help
Something like reReplaceNoCase( "\b(and)\b", string, "\1<\\strong>", "all" ) Not sure if its in the right order though, don't have time to check. Taco Fleur - Pacific Fox an industry leader with commercial IT experience since 1994 . http://www.pacificfox.com - Web Design and Development > -Original Message- > From: Ryan Guill [mailto:[EMAIL PROTECTED] > Sent: Friday, 23 September 2005 6:54 AM > To: CF-Talk > Subject: regex help > > > hey guys, need some more regex help > > I am wanting to match the word and, for instance in the > following query: > > SELECT > brbrch, > brname, > brst||char(brbrch) > FROM tn9997/sybr > where brregn=5 > and bract='Y' > > with regex. How could I make it where it will match any > whitespace (linefeed, carrage return or a space) right before > the word and and then surround just the word and with > tags ? or even better yet, also, if the word and is > lowercase, I would like it capitolized as well, but thats not > as importaint yet. > > Any takers? > -- > Ryan Guill > BlueEyesDevelopment > [EMAIL PROTECTED] > www.ryanguill.com > (270) 217.2399 > got google talk? Chat me at [EMAIL PROTECTED] > > The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219046 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last_Inster_Id()
Why not put both statements in one cfquery tag? INSERT INTO SELECT LAST_INSERT_ID() AS `id` Taco Fleur - E-commerce Development Manager Shelco Searches & Services An Authorised ASIC Information Broker www.shelco.com.au Ph: + 61 7 3236 2605 -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, 2 August 2005 10:25 AM To: CF-Talk Subject: Re: Last_Inster_Id() INSERT INTO SELECT LAST_INSERT_ID() AS `id` inserted id: #get.id# Note that MySQL tracks the last insert id on a per-connection basis, hence the need for CFTRANSACTION. cheers, barneyb On 8/1/05, Les Mizzell <[EMAIL PROTECTED]> wrote: > What is the correct syntax with Coldfusion/mySQL to use: > > LAST_INSERT_ID() > > > to grab the id of the last inserted record? > > Can't seem to get it quite right... > > Thanks, > > -- > --- > Les Mizzell > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213433 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Where's my singleton??
I was wondering if someone can see why I can't seem to get my singleton
from the following function?
var mySingletonPath = "";
// Check if this object is a singleton
if ( isSingleton() )
{
mySingletonPath =
getSingletonScope() & ".hash" & getClassPathAsHash() & ".hash" & hash(
getMetaData( this ).name );
// Check if the singleton is
instantiated
if ( NOT isDefined( mySingletonPath
) )
{
setInstanceVariable(
variableName = "initialized", value = true );
setClassVariable(
variableName = "hash" & hash( getMetaData( this ).name ), value = this,
scope = getSingletonScope() );
}
// Return the Singleton
//getClassVariable( variableName =
"hash" & hash( getMetaData( this ).name ), scope = getSingletonScope()
).dumpInstance();abort();
return getClassVariable(
variableName = "hash" & hash( getMetaData( this ).name ), scope =
getSingletonScope() );
}
setInstanceVariable( variableName =
"initialized", value = true );
// Return a new instance of this object
return this;
Let's say if I set a variable in the object with a value of "1",
instantiate the object, change the value to "2" save the object and
instantiate it again, and then call dumpInstance() I expect the value to
be "1" not "2".
When I uncomment the following line it outputs the expected result, i.e.
an instance variable with the value "1"
//getClassVariable( variableName = "hash" & hash( getMetaData( this
).name ), scope = getSingletonScope() ).dumpInstance();abort();
But when I later dump it from the file that instantiates the object it
outputs "2"
FormProcess = new ( "com.pacificMomentum.data.FormProcess" ).init();
FormProcess.dumpInstance();abort();
PS.
dumpInstance() is one of my own methods which dumps instance variables
BTW.
The init() method in the object returns getInstance() BTW i.e.
return getInstance();
Taco Fleur - E-commerce Development Manager
Shelco Searches & Services
An Authorised ASIC Information Broker
www.shelco.com.au
Ph: + 61 7 3236 2605
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212918
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SSL Debugging
Actually I am after > This will show in what CACERTS file Coldfusion is looking for the certificate. -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Tuesday, 26 July 2005 6:11 AM To: CF-Talk Subject: Re: SSL Debugging For all troubles like this, I use Ethereal. Its a open source network sniffer that lets you see what transactions are happening over the wire. I've used it to find out many times where connections were failing. http://www.ethereal.com/ Of course, you won't be able to see the actual SSL packets body, but you can see the request headers... Cheers, Kevin - Original Message - From: "Taco Fleur" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Sunday, July 24, 2005 6:01 PM Subject: SSL Debugging >I received some feedback from MM in regards to an issue I have been > trying to tackle for a while now: > > > > Enable SSL debugging by adding in the following JVM argument for more > info. -Dssl.debug=true This should write out to the standard out log. > This will show in what CACERTS file Coldfusion is looking for the > certificate. > > > > I did exactly as requested above, also restarted the CF server, made > another call to the class, then had a look at > C:\CFusionMX\runtime\logs\default-out.log > > But no reference to what certs CF is looking for. > > Anyone any ideas? > > > > Thanks, > > > > Taco Fleur - E-commerce Development Manager > > Shelco Searches & Services > > An Authorised ASIC Information Broker > > www.shelco.com.au > > Ph: + 61 7 3236 2605 > > > > > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212797 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
SSL Debugging
I received some feedback from MM in regards to an issue I have been trying to tackle for a while now: Enable SSL debugging by adding in the following JVM argument for more info. -Dssl.debug=true This should write out to the standard out log. This will show in what CACERTS file Coldfusion is looking for the certificate. I did exactly as requested above, also restarted the CF server, made another call to the class, then had a look at C:\CFusionMX\runtime\logs\default-out.log But no reference to what certs CF is looking for. Anyone any ideas? Thanks, Taco Fleur - E-commerce Development Manager Shelco Searches & Services An Authorised ASIC Information Broker www.shelco.com.au Ph: + 61 7 3236 2605 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212698 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
getBytes() on a session structure
Is there any way to call java's getBytes() on a CF Session structure? Yeah yeah it's the same old story again, trying to get a slight idea of how much memory a certain structure will take up in memory so we know how it will scale... Been fooling around, does anyone see anything really wrong with this estimate? Besides from the fact CF might not support toString() on the structure in the future blah blah... ____ Taco Fleur - E-commerce Development Manager Shelco Searches & Services An Authorised ASIC Information Broker www.shelco.com.au Ph: + 61 7 3236 2605 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CodFusion keystore
I am trying to import a certificate into another store (CF), but I can't get the fingerprints to match on the two, while I am sure the certificate is the same. In my C:\Documents and Settings\Administrator\ directory when I run "keytool -list -keystore .keystore" I get Your keystore contains 2 entries asiccert, 6/07/2005, trustedCertEntry, Certificate fingerprint (MD5): AE:A9:A6:61:D4:EE:D5:4A:B6:14:56:AC:6A:46:CB:2C shelco, 6/07/2005, keyEntry, Certificate fingerprint (MD5): E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2 And the above works, but when I do the same on C:\CFusionMX\runtime\jre\lib\security\cacerts I get asiccert, 13/07/2005, trustedCertEntry, Certificate fingerprint (MD5): E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2 This is how I added the later: C:\Temp\signature>keytool -import -keystore C:\CFusionMX\runtime\jre\lib\securit y\cacerts -file C:\Temp\signature\Shelco.cert.der -alias asiccert Enter keystore password: changeit Owner: CN=Graham Chapman test 200 serial, OU=eBusiness Development CA, O=ASIC, L =Sydney, ST=NSW, C=AU Issuer: OU=eBusiness Development CA, O=ASIC, L=SYDNEY, ST=NSW, C=AU Serial number: ed128008ec110fd416d961bd42ea0cabbd42ff0caced128008ec110fd416d961b d42ea0cabbd42ff0caced128008ec110fd416d961bd42ea0cabbd42ff0caced128008ec1 10fd416d 961bd42ea0cabbd42ff0caced128008ec110fd416d961bd42ea0cab Valid from: Thu Aug 19 09:29:11 EST 2004 until: Fri Aug 19 09:29:11 EST 2005 Certificate fingerprints: MD5: E0:05:34:7C:9C:A2:E9:9E:E6:0E:A8:66:4D:60:3A:F2 SHA1: 70:ED:59:6E:02:B8:9B:C3:0D:9B:3D:0E:92:0C:7B:DB:73:BE:26:0E Trust this certificate? [no]: y Certificate was added to keystore Anyone able to help out? ____ Taco Fleur - E-commerce Development Manager Shelco Searches & Services An Authorised ASIC Information Broker www.shelco.com.au Ph: + 61 7 3236 2605 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211708 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Java class called from CF errors
I have a Java class that runs fine as an application with main(), but
when I call it form CF it errors, I made sure the right constructor is
called - I just cannot figure out what the difference is and why it
errors.
The error is:
There was an error reading the Input Stream. The error is Connection has
been shutdown: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: No trusted certificate found
Any help is greatly appreciated.
/* Author: Taco Fleur ([EMAIL PROTECTED]) */
package edge;
import java.io.*;
import java.net.UnknownHostException;
import java.security.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import javax.net.ssl.*;
public class CFSSLTransportLayer
{
final String host = "edge.asic.gov.au";
final int port = 5608;
private static SSLSocket sslServerSocket;
static boolean debug = true;
final String keyStoreLocation ="C:\\Documents and
Settings\\Administrator\\.keystore";
final String password = "x";
final int socketTimeout = 6; // Set timeout to one
minute as per specs.
SSLSocketFactory factory;
PrintWriter pw;
BufferedReader in = null;
String error = "";
public CFSSLTransportLayer()
{
try
{
KeyStore myKeyStore =
KeyStore.getInstance( "JKS" );
myKeyStore.load( new
FileInputStream( keyStoreLocation ), password.toCharArray() );
TrustManagerFactory myTrustFactory =
TrustManagerFactory.getInstance( "SunX509", "SunJSSE" );
myTrustFactory.init( myKeyStore );
TrustManager[] myTrustManager =
myTrustFactory.getTrustManagers();
SSLContext ctx =
SSLContext.getInstance( "SSL" );
ctx.init( null, myTrustManager, null
);
factory = ctx.getSocketFactory();
}
catch ( Exception e )
{
String myError = "Error creating SSL
objects.";
System.err.println( myError );
setError( myError );
e.printStackTrace( System.out );
}
try
{
sslServerSocket = ( SSLSocket )
factory.createSocket( host, port );
// Set the timeout
sslServerSocket.setSoTimeout(
socketTimeout );
if ( debug )
{
System.out.println(
"*" );
System.out.println(
"***Secure socket made" );
System.out.println(
"*" );
System.out.println();
}
pw = new PrintWriter(
sslServerSocket.getOutputStream() );
}
catch ( UnknownHostException e )
{
String myError = "Unknown host.";
System.err.println( myError );
setError( myError );
}
catch ( java.net.SocketTimeoutException e )
{
String myError = "The Socket waited
" + socketTimeout / 1000 + " seconds for a response.";
System.err.println( myError );
setError( myError );
}
catch ( IOException e )
{
String myError = "I/O Exception.";
System.err.println( myError );
setError( myError );
}
catch ( Exception e )
{
String myError = "An exception has occurred, error message:
" + e.getMessage();
System.err.println( myError );
setError( myError );
}
}
private void setError( String error )
{
RE: pausing a script
Thread = createObject( "java", "java.lang.Thread" ); Thread.sleep( javaCast( "long", 1000*60 )); -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 13 April 2005 1:04 PM To: CF-Talk Subject: pausing a script Is there a way of pausing a script in CF MX 6? I want to send out 200 emails, wait 60 seconds before executing another cfmail batch of 200. I have got the following code after the cfmail tag both of which are nested in an index loop which has a value from 1 to 12. But the server hangs and has crashed once. Is there an elegant and efficient way to do this? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202519 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Regex help
This one is probably better
http://www.mydomain.com/missingdirectory/dfgfdgf/index.cfm";
/>
--
Taco Fleur
Senior Web Systems Engineer
http://www.webassociates.com
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 April 2005 11:01 AM
To: CF-Talk
Subject: Regex help
(CF5 on IIS, Win2k Server)
I have a CF template set up as the IIS 404 error handler on a web site.
When IIS detects a 404 error it calls the CF page and passes the original
request within the CGI variable cgi.query_string in the following form:
404;http://www.mydomain.com/missingpage.htm
or if the request was for a directory it might look like:
404;http://www.mydomain.com/missingdirectory/
In my template I need to extract what would have been the original
cgi.path_info:
/missingpage.htm
or
/missingdirectory/
What might a CF function look like using regexes to extract the trailing
part of the URL? There will be many different host (domain) names pointed
at the site, so I can't match the domain name. The function would be called
by passing cgi.query_string:
The function below is start, but it matches the entire string rather than
"extracting" just the end part.
function getPathInfo(qs) {
var re = '404;http://[^/]+/*';
var stuff = REFindNoCase(re, qs, 1, 'yes');
if (stuff.pos[1]) {
return Mid(qs, stuff.pos[1], stuff.len[1]);
} else {
return '';
}
}
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202516
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Regex help
Definitely not perfect, but it does the trick
http://www.mydomain.com/missingdirectory/dfgfdgf/index.cfm";
/>
--
Taco Fleur
Senior Web Systems Engineer
http://www.webassociates.com
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 13 April 2005 11:01 AM
To: CF-Talk
Subject: Regex help
(CF5 on IIS, Win2k Server)
I have a CF template set up as the IIS 404 error handler on a web site.
When IIS detects a 404 error it calls the CF page and passes the original
request within the CGI variable cgi.query_string in the following form:
404;http://www.mydomain.com/missingpage.htm
or if the request was for a directory it might look like:
404;http://www.mydomain.com/missingdirectory/
In my template I need to extract what would have been the original
cgi.path_info:
/missingpage.htm
or
/missingdirectory/
What might a CF function look like using regexes to extract the trailing
part of the URL? There will be many different host (domain) names pointed
at the site, so I can't match the domain name. The function would be called
by passing cgi.query_string:
The function below is start, but it matches the entire string rather than
"extracting" just the end part.
function getPathInfo(qs) {
var re = '404;http://[^/]+/*';
var stuff = REFindNoCase(re, qs, 1, 'yes');
if (stuff.pos[1]) {
return Mid(qs, stuff.pos[1], stuff.len[1]);
} else {
return '';
}
}
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202515
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: You have to laugh - the world is full of half-wits
Look, I like a laugh, and a bit of off-topic, but this is ridiculous.. Has absolutely nothing to do with nothing.. Sorry ... ;-) -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, 7 April 2005 9:54 AM To: CF-Talk Subject: RE: You have to laugh - the world is full of half-wits Thanks for sharing the story, Mike...I enjoyed it. Taco...go back to sleep. :o) Rick PS - You have to admit...this group will tear apart anything trying to analyze it! -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 06, 2005 7:31 PM To: CF-Talk Subject: Re: You have to laugh - the world is full of half-wits I'm sorry everyone. I just thought it was amusing. I laughed at the concept of sending an email to adivse us that email was working, and at his o-so-serious reaction to my flippant remark about the Telstra person. "no, i dont have any relatives at Telstra" - my joke was totally lost on him and that made it all the more funny for me. I certainly dont think it merited a debate about who was at fault or who should have done what. It was a mildly amusing incident in what would rank for me as one of the worst days I've had in several years. Dont worry I wont be sharing any other stories I think might amuse you. Apparently there are only a few who have the permission of the list to do so. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Apr 7, 2005 8:55 AM, Taco Fleur <[EMAIL PROTECTED]> wrote: > Hey lets have a nasty debate over this really cool and informational topic.. > > -- > Taco Fleur > Senior Web Systems Engineer > http://www.webassociates.com > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201801 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: You have to laugh - the world is full of half-wits
Hey lets have a nasty debate over this really cool and informational topic.. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Thursday, 7 April 2005 11:46 AM To: CF-Talk Subject: RE: You have to laugh - the world is full of half-wits > But who's dumber, the person who supplies an email address that will > only be working after the connection is setup, or the tech who assumes > the email address supplied is a working one? Maybe moving this to > cf-community is probably best, since then we can throw out the > "personal responsibility" > part of the equation. Again... my interpretation of it was that he was talking to a tech about service he had ordered personally, wherein he had not supplied the provider with an email address, either a working email address or an email address to be in operation in the future (which is generally supplied by the provider anyway) and that the tech simply offered "email" as a generic answer to the question of how the customer would be informed because email is the medium through which they generally communicate with customers. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201797 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfc error
   SELECT * FROM patterns ORDER BY parentID DESC   -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 April 2005 2:47 PM To: CF-Talk Subject: Re: cfc error here it is    SELECT * FROM patterns ORDER BY parentID DESC   From: Jon Austin <[EMAIL PROTECTED]> Sent: Tuesday, April 05, 2005 12:43 AM To: CF-Talk Subject: Re: cfc error Are all of your statements grouped under your ? //got nuthin On Apr 5, 2005 2:40 PM, dave wrote: > anyone know what this error means? > > Local variable qLF on line 18 must be grouped at the top of the function body. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201469 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfc error
If you use var in front of any of your variables then they need to be right after your arguments, i.e. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Tuesday, 5 April 2005 2:40 PM To: CF-Talk Subject: cfc error anyone know what this error means? Local variable qLF on line 18 must be grouped at the top of the function body. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201468 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Table name - Singular or plural?
It's not stupid at all and probably one of the most important things to get right, but like most of us you will only figure this out after several years of programming. Funny enough, it seems even big companies seem to have trouble with consistency, which is why it is so important to get a naming convention and methodology done before anything else. And yes, "variables" scope being plural always bothered me, that's why I decided to write my own scopes with CFCs, which doesn't include the name Variables, but only Local, Form, URL, Client, Application, Session, Server etc. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Mark Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, 31 March 2005 4:58 AM To: CF-Talk Subject: RE: Table name - Singular or plural? This has to be the stupidest and most wasteful thread I have ever seen. STFU! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200874 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Table name - Singular or plural?
> Why would you name tables singular? Because you do not want to guess "What did I name that table, person or personS?" If you use singular you always know what the name is, and your fellow programmers will appreciate it too.. Now let us hear your arguments as to why you would want to use plural? -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Wednesday, 30 March 2005 10:42 AM To: CF-Talk Subject: Table name - Singular or plural? Why would you name tables singular? I can give many reasons why they should be plural, but that aside, are the existing SQL Server System tables singular or plural? Plural. http://www.cit.cornell.edu/atc/materials/old/dbdesign/erd.pdf Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Transparent authentication aginst IIS
Is the domain in your trusted site list in IE? IE automatically thinks the site is not an intranet if there is a dot in the domain name Also, are you on the same domain when you try to access the site? -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: jamie wedow [mailto:[EMAIL PROTECTED] Sent: Tuesday, 29 March 2005 9:32 AM To: CF-Talk Subject: Re: Transparent authentication aginst IIS I have windows authentication currently enabled but the dialog box still comes up. I can get it to go away by enabling anonymous access, but then the time-tracking app breaks. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Transparent authentication aginst IIS
Yes, you need to enable "windows integrated authentication" under the website in IIS. This will enable authentication in the background, i.e. via the web browser and IIS, the web browser passes the login details from the logged in user to the web server which authenticates the details. No need to pass any of these details anywhere, the username however is available for you to use under the cgi variable cgi.auth_user -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: jamie wedow [mailto:[EMAIL PROTECTED] Sent: Tuesday, 29 March 2005 9:02 AM To: CF-Talk Subject: Transparent authentication aginst IIS I am currently in the process of integrating a new time-tracking application into out company intranet. The application authenticates users through IIS as shown http://myportal2.fclaw.com/authenticate.jpg";>here. Is there a way I can mask this authentication? I have the username and password available as session variables, but I'm not sure how to pass that data on to the IIS server itself. Thanks, Jamie ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200317 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Get Disk Space from CF?
You can use the Scripting.FileSystemObject to get this information. FSO = createObject( "COM", "Scripting.FileSystemObject" ); Drive = FSO.getDrive( FSO.getDriveName( "D" ) ); diskSpaceLeft = Drive.freeSpace() / 1024; There might be some errors there as I typed it in this email, but it will get you going ;-) -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, 18 March 2005 11:05 AM To: CF-Talk Subject: Get Disk Space from CF? Does anyone know how I can retrieve the amount of disk space remaining in a disk volume on the server on which CF is running? CF5, IIS5, Windows 2000 Server Standard. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfqueryparam breaking query
PS: Use char when the data values in a column are expected to be consistently close to the same size -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 March 2005 3:39 PM To: CF-Talk Subject: RE: cfqueryparam breaking query CHAR is a fixed width datatype If you have a field with CHAR( 34 ) and you only insert 4 characters than the other 30 characters are padded with a space. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Tyler Fitch [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 March 2005 11:11 AM To: CF-Talk Subject: Re: cfqueryparam breaking query I don't know what Ron's problem is, but cf_sql_char isn't limited to a single char. Sean, you thought wrong ;). It's the same thing as a CHAR datatype in a RDBMS. I use cf_sql_char with a size="35" for my UUID cfqueryparams w/o issue. t On Tue, 15 Mar 2005 16:46:02 -0800, Sean Corfield <[EMAIL PROTECTED]> wrote: > On Tue, 15 Mar 2005 19:19:49 -0400, Ron G <[EMAIL PROTECTED]> wrote: > > I have an Access 97 database(Yes I Know) that has a linked Oracle table\view in it. I can query the linked table without cfqueryparam. > > >LAWSON_SHC_EMPLOYEE_V.LAST_NAME= > value="#ucase(form.Lname)#" cfsqltype="cf_sql_char"> > > > > I can do a similar query against an integer datatype with queryparam and it will work. > > cf_sql_char is a single character I thought. Try cf_sql_varchar. > > See also the documents linked from my blog entry on this subject: > > http://www.corfield.org/blog/index.cfm?do=blog.entry&entry=E33E072C-F6 > 7D-BA7C-310D63974FA85A92 > -- > Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- > http://www.fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to > give away! > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwood > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198919 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfqueryparam breaking query
CHAR is a fixed width datatype If you have a field with CHAR( 34 ) and you only insert 4 characters than the other 30 characters are padded with a space. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Tyler Fitch [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 March 2005 11:11 AM To: CF-Talk Subject: Re: cfqueryparam breaking query I don't know what Ron's problem is, but cf_sql_char isn't limited to a single char. Sean, you thought wrong ;). It's the same thing as a CHAR datatype in a RDBMS. I use cf_sql_char with a size="35" for my UUID cfqueryparams w/o issue. t On Tue, 15 Mar 2005 16:46:02 -0800, Sean Corfield <[EMAIL PROTECTED]> wrote: > On Tue, 15 Mar 2005 19:19:49 -0400, Ron G <[EMAIL PROTECTED]> wrote: > > I have an Access 97 database(Yes I Know) that has a linked Oracle table\view in it. I can query the linked table without cfqueryparam. > > >LAWSON_SHC_EMPLOYEE_V.LAST_NAME= > value="#ucase(form.Lname)#" cfsqltype="cf_sql_char"> > > > > I can do a similar query against an integer datatype with queryparam and it will work. > > cf_sql_char is a single character I thought. Try cf_sql_varchar. > > See also the documents linked from my blog entry on this subject: > > http://www.corfield.org/blog/index.cfm?do=blog.entry&entry=E33E072C-F6 > 7D-BA7C-310D63974FA85A92 > -- > Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- > http://www.fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to > give away! > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwood > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198918 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: URL masking and application.cfc
I done it ages ago, and I found it is not how the web is supposed to work, a 404 error means page not found (as we all know) and that's what it should be used for, there are all kinds of ramifications when you use it for something else, for example; search engines will not pick your page up, fine if you don't want them listed in the first place. I think you are also opening yourself up for a security attack (not sure about the specifics anymore). Just my dos pesetas -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, 15 March 2005 3:17 AM To: CF-Talk Subject: URL masking and application.cfc I've been thinking of a new method of presenting dynamic content, specifically the list archives. At the moment you get to a single post by passing an ID on the url. Even if this is 'hidden' using SES Urls or the like, your still passing something. My idea is to use the application.cfc to 'catch' a specific type of 404 error and in place of an error, run a page. Take for example this url: http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:38946 In its place I want to use this url: http://www.houseoffusion.com/cf_lists/messages_4_38946.cfm When the onRequestStart or onRequest action is run, I'd like to change the page requested from messages_4_38946.cfm to messages.cfm and turn the rest of the url into the proper variables. Looks totally do-able and I'll be playing with it tonight. The reason I'm mentioning it is to see if anyone else has done this already, anyone finds this interesting and wants to try it and anyone wants to comment on it. I think it's a nice usage of application.cfc, but if others find it to be flawed, I'd like to hear it early on. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198735 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Form Security - was RE: Run CFC method on form submit
Yup, but if that's what he wants to do, this might be what he is looking for. If he wants to make it secure he might want to adopt a different file structure, as I do in this case, and let the method be determined by the current folder. I actually let every aspect of the directory rule what is called, i.e. system/package/Object/method *While* we are on the topic of security, always describe your properties with attributes like regular expressions, required, format etc. and then do data checking and filtering before accepting the data. I myself do this with XML or cfproperty and use this to do the validation. Regards, Taco Fleur > -Original Message- > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 2 March 2005 12:08 AM > To: CF-Talk > Subject: Form Security - was RE: Run CFC method on form submit > > > > I think the following would work in your CFM page > > > > "YourObject" ) /> > > > > > > > form.method is ofcourse a hidden field in the form > > > > I don't know if I'd recommend this for the same reason I > wouldn't recommend even CF7's server-side validation. Because > it relies on a hidden form field, anyone with cfhttp (or any > readily available > equivalent) can alter the behavior of your form on the server > -- so this becomes a potential vulnerability in your > application security. > > The articles written about the new cfform features in MX7 do > mention improved validation features, and I remember one > making the intimation that CF7 forms were more secure -- but > the honest truth is that if you rely solely on the server > side (and/or javascript) form validation they become > completely insecure. The only way you can secure CF7 forms is > by writing your own server-side validation for them -- the > good news is that the new isValid() and cfparam features make > this a lot easier, but don't be lulled into a false sense of > security by the new feautres, isValid() (or similar) is an > absolute must. > > s. isaac dealey 954.927.5117 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196997 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Run CFC method on form submit
I think the following would work in your CFM page form.method is ofcourse a hidden field in the form -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Yexley Robert D Contr AFRL/PROE [mailto:[EMAIL PROTECTED] Sent: Tuesday, 1 March 2005 7:33 AM To: CF-Talk Subject: Run CFC method on form submit I'm looking for some good documentation or a code sample for how I would execute a method in a CFC on form submit. So far I haven't been able to find what I'm looking for. What I'm trying to do seems like it ought to be fairly straight forward. I've got a method in a CFC that inserts a record into a database, it has 11 parameters. I've got an HTML form (not a ) in a ColdFusion template, and I'd like to set the method of this CFC to be the "method" for the form. When the form is submitted, I want the values of the fields on the form (there are 11 of them, corresponding to each of the parameters of the CFC method) to get passed into the CFC method as parameters, and then run the method. Can somebody point me to some documentation, or give me a good code sample? I've looked in the CFML Reference, and also "Developing ColdFusion MX Application with CFML" as well, and haven't been able to find anything that covers this sort of scenario. // YEX // /* || Robert D. Yexley || Oracle Programmer/Analyst || Northrop Grumman IT || Contractor - Wright Research Site MIS || Det-1 AFRL/PROE Bldg. 18 Rm. 034A || Commercial: 937.255.1984 || DSN: 785.1984 || [EMAIL PROTECTED] || <)))>< */ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196906 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfset ?
Creating code that is able to create code! And also validate it up to a certain point.. I see a big value there. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 11:44 PM To: CF-Talk Subject: RE: cfset ? Well, if it was valid XML then you could, in theory, actually parse a cf document as an xml document Not sure what value that would have though. - Calvin -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 6:38 PM To: CF-Talk Subject: Re: cfset ? if its parsed on the server, and it doesnt make it to the browser, anyway, why or how does xhtml compliance matter? -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfset ?
I guess its all just one step towards being compliant with xml, all you would have to do to make it really compliant is something like the following to get around the issue with cfelse. test -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 9:25 AM To: CF-Talk Subject: Re: cfset ? Except that CFML isn't XML compliant. CFELSEIF and CFELSE, in particular, are an issue. If you use CFSWITCH for all conditionals with more than one block, then it'd work (you can still use CFIF without a CFELSE). cheers, barneyb On Fri, 4 Feb 2005 09:20:43 +1000, Taco Fleur <[EMAIL PROTECTED]> wrote: > Its just to make the code xml compliant, basically you could > eventually parse a cfm page and work with it as XML.. > > -- > Taco Fleur > Senior Web Systems Engineer > http://www.webassociates.com > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193014 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfset ?
Its just to make the code xml compliant, basically you could eventually parse a cfm page and work with it as XML.. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, 4 February 2005 9:14 AM To: CF-Talk Subject: cfset ? ok this is dumb but was just curious about something i have always done cfsets like suck but i was just browsing through one of charlie griefers articles and i see he closes the tag, like suck the docs dont mention using a closing tag and i have never seen it before so just curious :) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193003 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Random row from SQL table
SELECT TOP 1 * FROM Quotes ORDER BY NEWID() -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Duncan I Loxton [mailto:[EMAIL PROTECTED] Sent: Thursday, 3 February 2005 2:13 PM To: CF-Talk Subject: Random row from SQL table Hi, I need to get one row and one row only from a sql table - cheesy quotes for our corporate intranet. The table is like this: CREATE TABLE dbo.Quotes ( quo_id int NOT NULL IDENTITY (1, 1), quo_text text, quo_author varchar(100), quo_wwwSite int ) Now wwwSite is the id of the website we are currently on, as this table is shared between sites and quotes are different depending on where you are. I need to get one random(ish) row from the quotes table from the subset of wwwSite = 3. Is it possible to do in one query? or will I have to run 2? I am using CF4.5 Thanks! -- Duncan I Loxton ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192849 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: better way to code?
First one, second one should throw an error. And I would make it But then again its pretty dangerous allowing the path to come from the url if this website has public access. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Friday, 28 January 2005 1:43 PM To: CF-Talk Subject: better way to code? Which method of programming do you consider is better? This one: or this one: I know that the first one is most people use, but the second one is more interesting. It seems to use the power of CF more. So let me know what you think. Johnny ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192055 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [object name].scope
that was *really* stupid of me actually.. Taco Fleur Thought of the day: coding and beer don't mix... ;-) > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Thursday, 6 January 2005 3:16 PM > To: CF-Talk > Subject: Re: [object name].scope > > > What's the actual output versus the expected output? I'd say > expected would be this: > > scopetest scope > unknown scope > parent scope > unknown scope > this scope > > unscoped (your unknown scope) is shorthand for the variables scope. > the 'this' scope is actually a subscope of 'variables', so > #this.test# is equivalent to #variables.this.test# from > within the CFC. The 'variables' scope (including the 'this' > scope) is inherited by subclasses. Your "special" > object-name scope, is nothing more than a struct inside the > 'variables' scope, exactly as you'd expect to have happen in > "normal" CFML code. Since the 'variables' scope is private, > your new struct is also private. > > cheers, > barneyb > > On Thu, 6 Jan 2005 14:37:18 +1000, Taco Fleur > <[EMAIL PROTECTED]> wrote: > > Following is just interesting, when I read about CFC scopes > I always > > hear about the private and public scope, i.e. > > > > this.test = public > > variables.test = private > > test = private > > > > But it appears that the name of the object is also a (seperate) > > private scope, see following: > > > > ** Save as ScopeTest.cfc > > > > > > > > ScopeTest.test = "Hello there! I'm in the ScopeTest Scope"; > > variables.test = "Hello there! I'm in the ScopeTest Variables"; > > //Parent.test = "Hello there! I'm in the Parent Scope"; > > test = "Hello there! I'm in the unknown Scope"; > > this.test = "Hello there! I'm in the this Scope"; > > > > > > > name="test1" > > access="public" > > returntype="string"> > > > > > > > > > > > name="test2" > > access="public" > > returntype="string"> > > > > > > > > > > > name="test3" > > access="public" > > returntype="string"> > > > > > > > > > > > name="test4" > > access="public" > > returntype="string"> > > > > > > > > > > > name="test5" > > access="public" > > returntype="string"> > > > > > > > > > > > > > > * Save as Parent.cfc > > > > > > > > > > Parent.test = "Hello there! I'm in the Parent Scope1"; > > > > > > > > > > ** Code to test > > > > > > Object = createObject( "component", "ScopeTest" ); > > > > #Object.test1()# > > #Object.test2()# > > #Object.test3()# > > #Object.test4()# > > #Object.test5()# > > > > > > Is this already documented and known, or am I off with the fairies > > again?? You would think that [object name] would be the same as > > [this], not? > > > > Taco Fleur > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 9 invites. > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [object name].scope
Yeah makes sense, cheers. Taco Fleur > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Thursday, 6 January 2005 3:16 PM > To: CF-Talk > Subject: Re: [object name].scope > > > What's the actual output versus the expected output? I'd say > expected would be this: > > scopetest scope > unknown scope > parent scope > unknown scope > this scope > > unscoped (your unknown scope) is shorthand for the variables scope. > the 'this' scope is actually a subscope of 'variables', so > #this.test# is equivalent to #variables.this.test# from > within the CFC. The 'variables' scope (including the 'this' > scope) is inherited by subclasses. Your "special" > object-name scope, is nothing more than a struct inside the > 'variables' scope, exactly as you'd expect to have happen in > "normal" CFML code. Since the 'variables' scope is private, > your new struct is also private. > > cheers, > barneyb > > On Thu, 6 Jan 2005 14:37:18 +1000, Taco Fleur > <[EMAIL PROTECTED]> wrote: > > Following is just interesting, when I read about CFC scopes > I always > > hear about the private and public scope, i.e. > > > > this.test = public > > variables.test = private > > test = private > > > > But it appears that the name of the object is also a (seperate) > > private scope, see following: > > > > ** Save as ScopeTest.cfc > > > > > > > > ScopeTest.test = "Hello there! I'm in the ScopeTest Scope"; > > variables.test = "Hello there! I'm in the ScopeTest Variables"; > > //Parent.test = "Hello there! I'm in the Parent Scope"; > > test = "Hello there! I'm in the unknown Scope"; > > this.test = "Hello there! I'm in the this Scope"; > > > > > > > name="test1" > > access="public" > > returntype="string"> > > > > > > > > > > > name="test2" > > access="public" > > returntype="string"> > > > > > > > > > > > name="test3" > > access="public" > > returntype="string"> > > > > > > > > > > > name="test4" > > access="public" > > returntype="string"> > > > > > > > > > > > name="test5" > > access="public" > > returntype="string"> > > > > > > > > > > > > > > * Save as Parent.cfc > > > > > > > > > > Parent.test = "Hello there! I'm in the Parent Scope1"; > > > > > > > > > > ** Code to test > > > > > > Object = createObject( "component", "ScopeTest" ); > > > > #Object.test1()# > > #Object.test2()# > > #Object.test3()# > > #Object.test4()# > > #Object.test5()# > > > > > > Is this already documented and known, or am I off with the fairies > > again?? You would think that [object name] would be the same as > > [this], not? > > > > Taco Fleur > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 9 invites. > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189478 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
[object name].scope
Following is just interesting, when I read about CFC scopes I always hear about the private and public scope, i.e. this.test = public variables.test = private test = private But it appears that the name of the object is also a (seperate) private scope, see following: ** Save as ScopeTest.cfc ScopeTest.test = "Hello there! I'm in the ScopeTest Scope"; variables.test = "Hello there! I'm in the ScopeTest Variables"; //Parent.test = "Hello there! I'm in the Parent Scope"; test = "Hello there! I'm in the unknown Scope"; this.test = "Hello there! I'm in the this Scope"; * Save as Parent.cfc Parent.test = "Hello there! I'm in the Parent Scope1"; ** Code to test Object = createObject( "component", "ScopeTest" ); #Object.test1()# #Object.test2()# #Object.test3()# #Object.test4()# #Object.test5()# Is this already documented and known, or am I off with the fairies again?? You would think that [object name] would be the same as [this], not? Taco Fleur ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189474 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Typesafe enum design pattern (another go)
> The first problem is that in the Java world the constructor is declared as
private so you can't create an instance of the class. You can't do that in
CF.
Exactly, I have been thinking about that, how about the following?
--
Taco Fleur
Senior Web Systems Engineer
http://www.webassociates.com
Second problem is that the variables are declared as static final, so you
can't change them except in the constructor of the class that declares them.
Again, you can't really do that in CF.
Also, in the Java world, a common use of the pattern is to ensure that the
value passed as a parameter can contain only one of a set of pre-defined
values. The common example given is a class called Suit that has 4 fields.
One for each suit in a pack of cards. You can then know that when you
declare the argument to a function as being of type Suit that it must be one
of the 4 permitted suits and anything else will fail *at compile time* not
at runtime.
That may or may not be a requirement for what Taco is doing, but if it was,
it would affect the implementation in CF.
The other thing about enums is that there are so many ways you could
possibly use them that it's very difficult to say whether an implementation
is a good one without knowing more about the specific scenario.
Spike
Aaron DC wrote:
> Sounds like Taco is reading and learning about patterns and trying to
> implement / translate them into CF purely for the exercise or sake of
> doing so. Hence he would like to discuss the implementation / code at
> a purely theoretical point of view, rather than a specific
> implementation point of view. Respondents to date seem to indicate
> that a pattern is basically useless without the associated problem it
> was intended to solve being present.
>
> In a brain-storm session, Stage 1 is "every idea is good" - I think
> this is the space Taco is occupying. Once all the ideas are written
> down, Stage 2 involves "picking the best / most doable" ideas - looks
> to me like this is the space occupied by his respondents.
>
> I think the pattern porting exercise would be interesting and
> potentially valuable. This value could be greatly enhanced if a common
> CF or web-based programming scenario was also invented, for which the
> pattern provides a solution. Without this scenario, it would be like
> Mach-II or FB3/4 having base code and documentation, but no example apps.
>
> My gut feeling is that there are only a handful of other developers
> here who would be able to discuss pattern templates or
> implementations. It may be that another list is better suited, or a new
"CF-patterns" / "CF-hardcore"
> list would at least show you through its subscription how many others
> are interested.
>
> Good luck, Taco, I hope you find others that share your passion.
>
> Aaron
>
> - Original Message -
> From: "Spike" <[EMAIL PROTECTED]>
> To: "CF-Talk"
> Sent: Tuesday, January 04, 2005 12:59 PM
> Subject: Re: Typesafe enum design pattern (another go)
>
>
>
>>That's pretty much all we can discuss unless you lay out the problem
>>that you're trying to solve.
>
>
>
>
>
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189207
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Typesafe enum design pattern (another go)
I know what most of you are trying to get at (I read the book too) "Don't use design patterns just for the sake of it". I'm not interested in discussing that, a pattern solves certain problems, lets just say I have all those problems that this particular pattern solves! Aaron you are spot on. But as Sean already pointed out, this is not the list to discuss it. And yes a site dedicated to design patterns for CF would be nice (any volunteers to help ? ;-)... -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Spike [mailto:[EMAIL PROTECTED] Sent: Tuesday, 4 January 2005 12:21 PM To: CF-Talk Subject: Re: Typesafe enum design pattern (another go) That's not describing the problem. It's describing a solution. Why do you need constants? Why do you need them to be in a class/cfc? Why do you not want the public to be able to modify any data and who do you define as the public? Why do you need to be able to loop over the constants? Spike Taco Fleur wrote: > The problem: > > I need a class that represents constants I don't want the public to be > able to modify any data I need to be able to loop over the constants > easily > > Basically quoting what problems the pattern solves.. > > -- Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189203 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Typesafe enum design pattern (another go)
The problem: I need a class that represents constants I don't want the public to be able to modify any data I need to be able to loop over the constants easily Basically quoting what problems the pattern solves.. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, 4 January 2005 11:57 AM To: CF-Talk Subject: RE: Typesafe enum design pattern (another go) > Ok, so are we discussing how to implement the design pattern specific > for ColdFusion or will we just keep discussing the discussion itself? What problem is your code specifically trying to solve? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189199 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Typesafe enum design pattern (another go)
Ok, so are we discussing how to implement the design pattern specific for ColdFusion or will we just keep discussing the discussion itself? -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, 4 January 2005 9:27 AM To: CF-Talk Subject: Re: Typesafe enum design pattern (another go) I think what Sean was trying to get at was that an implementation of a design pattern in isolation of a problem it can solve is nothing more than a bunch of arbitrary code. If you have two problems that can both be solved with the same pattern, and you use the same langauge to implement each solution, the implementations will very likely be different. The design pattern itself is merely a guide as to how to best approach implementing a solution. If you go get a book on patterns, you'll always find a problem description preceeding the sample implementation, because without that context (the problem) the implementation is meaningless. cheers, barneyb On Tue, 4 Jan 2005 09:14:36 +1000, Taco Fleur <[EMAIL PROTECTED]> wrote: > > Example code alone does not teach a pattern! > > Completely agree, which is why I did not provide an explanation, and > was hoping to get feedback from people familiar with the pattern. > The link was just to give an idea of what its all about, I actually > read about the pattern in another book. > > Anyway, I'll go and hide in my corner again and discover the world of > design patterns on my own again, I lost all hope to discuss some of > this wonderful stuff on the cf list and port the patterns to cf for > all to enjoy ;-)) > > -- > Taco Fleur > Senior Web Systems Engineer > http://www.webassociates.com -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 9 invites. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189194 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Typesafe enum design pattern (another go)
> Example code alone does not teach a pattern! Completely agree, which is why I did not provide an explanation, and was hoping to get feedback from people familiar with the pattern. The link was just to give an idea of what its all about, I actually read about the pattern in another book. Anyway, I'll go and hide in my corner again and discover the world of design patterns on my own again, I lost all hope to discuss some of this wonderful stuff on the cf list and port the patterns to cf for all to enjoy ;-)) -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, 4 January 2005 8:57 AM To: CF-Talk Subject: Re: Typesafe enum design pattern (another go) On Tue, 4 Jan 2005 08:32:06 +1000, Taco Fleur <[EMAIL PROTECTED]> wrote: [singleton] > OK, any ideas on how to make it less complex? > Which part of it did you consider to be complex and why? Umm, I don't remember now... beyond just thinking "Wow, that's a really complex solution to what ought to be a simple problem". > When I read up about the design pattern in Java this was the closest I > could get it to the real thing. > (link: http://www.javacamp.org/designPattern/enum.html ) Right, but that doesn't mean that the same implementation makes sense in CF. > > You also aren't explaining what problem you're trying to solve with this. > I was hoping to get some feedback from people that are familiar with > the design pattern, Well, some design patterns are language specific and the problems they solve don't always translate to other languages. I think it's a mistake to focus on a design pattern in isolation of how it should be used or, rather, what set of problems it is trying to solve. I just posted this in my Breeze room as an example of why code != pattern: Examine the relative importance of sections in a pattern description (from the GoF book): FACTORY METHOD Intent... (a paragraph) Also Known As... (one name) Motivation... (a full page!) Applicability... (when to use it) Structure... (one small diagram) Participants... (a few bullets describing each class) Collaborations... (one sentence) Consequences... (almost TWO PAGES!) Implementation... (describes several implementation options with a few code fragments - three and a half pages - note that this is a set of guidelines for implementation, not a *specific* implementation) Sample Code... (just under two pages of simple code with commentary) Known Uses... (half a page) Related Patterns... (a few paragraphs) The Motivation, Applicability and Consequences sections are the most important. The (long) implementation section contains a lot of theory and suggestions. Patterns are generally light on code and heavy on the whys and wherefores. -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 6 invites to give away! "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189191 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Typesafe enum design pattern (another go)
Hey feedback! > 3. Possibly... I seem to recall your solution was overly complex OK, any ideas on how to make it less complex? Which part of it did you consider to be complex and why? Some things that I did notice I could improve in the code is to use the actual variable scope instead of evaluating a string in the "getSingletonScope" method, and use some locking. > You're using DataType as both a container and the elements it contains which seems wrong. When I read up about the design pattern in Java this was the closest I could get it to the real thing. (link: http://www.javacamp.org/designPattern/enum.html ) > You also aren't explaining what problem you're trying to solve with this. I was hoping to get some feedback from people that are familiar with the design pattern, since I want to stick with the design pattern it would not be relevant to explain what it should do, as that way I might receive feedback on how to implement it some other way, but that is not what I am after. I want to stick to the pattern, thus someone who is familiar with the pattern could comment and provide feedback better than someone who does not (also, I did specify that I could provide more details if required). > Again, as with your singleton implementation, it seems unnecessarily complex. You must have had a close look at the code to make this assumption, please provide details. But as you said, maybe this is not the list to discuss this.. Thanks ;-) -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189188 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Typesafe enum design pattern (another go)
Just trying to implement the Typesafe Enum Design Pattern in ColdFusion,
and am looking for some feedback/input on the following code.
I have tried to get some feedback before on the Singleton design pattern,
but got not one response, so I am thinking;
1. This is not the list to post to for feedback, only problems.
2. There is no interest in these type of posts.
3. I was so way off that it wasn't even worth replying.
4. Fill in..
So here is another go at another design pattern..
Following is the code to call the CFC
**
DataType = createObject( "component",
"_resource.class.database.microsoftSQLServer.DataType" ).init();
for ( Constant in DataType.instance )
{
writeOutput( DataType.instance[ Constant ].getLower() & "" );
}
**
Following is the CFC itself
**
this.instance = structNew();
// Public static
newConstant( name = "BIGINT", lower = -9223372036854775808, upper
= 9223372036854775807, type = "numeric" );
newConstant( name = "INTEGER", lower = -2147483648, upper =
2147483647, type = "numeric" );
newConstant( name = "SMALLINT", lower = -32768, upper = 32767,
type = "numeric" );
newConstant( name = "TINYINT", lower = 0, upper = 255, type =
"numeric" );
newConstant( name = "BIT", lower = 0, upper = 1, type = "numeric"
);
newConstant( name = "DECIMAL", lower = "-10^38+1", upper =
"10^38-1", type = "numeric" );
// Same as Decimal constant
structInsert( this, "NUMERIC", this.DECIMAL, false );
newConstant( name = "MONEY", lower = -922337203685477.5808, upper
= 922337203685477.5807, type = "numeric" );
newConstant( name = "SMALLMONEY", lower = -214748.3648, upper =
214748.3647, type = "numeric" );
newConstant( name = "FLOAT", lower = -1.79E+308, upper =
1.79E+308, type = "numeric" );
newConstant( name = "REAL", lower = -3.40E+38, upper = 3.40E+38,
type = "numeric" );
newConstant( name = "DATETIME", lower = createDate( 1753, 1, 1 ),
upper = createDate( , 12, 31 ), type = "date" );
newConstant( name = "SMALLDATETIME", lower = createDate( 1900, 1,
1 ), upper = createDate( 2079, 6, 6 ), type = "date" );
newConstant( name = "CHAR", lower = 0, upper = 8000, type =
"string" );
newConstant( name = "TEXT", lower = 0, upper = 8000, type =
"string" );
newConstant( name = "VARCHAR", lower = 0, upper = 2147483647, type
= "string" );
newConstant( name = "NCHAR", lower = 0, upper = 4000, type =
"string" );
newConstant( name = "NVARCHAR", lower = 0, upper = 4000, type =
"string" );
newConstant( name = "BINARY", lower = 0, upper = 8000, type =
"string" );
newConstant( name = "VARBINARY", lower = 0, upper = 8000, type =
"string" );
newConstant( name = "IMAGE", lower = 0, upper = 2147483647, type =
"string" );
// Return the instance of the Object
return this;
structInsert( this, arguments.name, createObject( "component",
"DataType" ).setConstant( lower = arguments.lower, upper = arguments.upper,
type = arguments.type ), false );
// Create a reference in the this.instance structure
structInsert( this.instance, arguments.name, this[ arguments.name
], false );
return this;
setUpper( upper = arguments.upper );
setLower( lower = arguments.lower );
setType( type = arguments.type );
return this;
variables.upper = arguments.upper;
return variables.upper;
variables.lower = arguments.lower;
return variables.lower;
variables.type = arguments.type;
return variables.type;
Taco Fleur
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189130
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Singleton Design Pattern
I am just playing with the singleton design pattern, and this is how I
imagine it implemented in ColdFusion, I am just looking after some feedback
on this, and most likely improvements. And maybe I am just way off!!?
If needed I can provide some more info on what's going on.
* Object.cfc
//
// Return the instance of the Object
return getInstance();
evaluate( getSingletonScope() & "[ getMetaData( this
).name ] = this" );
return evaluate( getSingletonScope() & "[
getMetaData( this ).name ]" );
// Check if this object is a singleton
if ( isSingleton() )
{
// Check if the singleton is
instantiated
if ( isInstantiatedSingleton() )
{
// Get the singleton
this = getSingleton();
}
// Otherwise instantiate the singleton
else
{
setSingleton();
}
}
return this;
return structKeyExists( evaluate(
getSingletonScope() ), getMetaData( this ).name );
* Child.cfc
//
this.instance.test = "";
super.init();
// Return the instance of the Object
return getInstance();
this.instance.test = arguments.test;
* test.cfm
//structDelete( server, "Child" );
obj = createObject( "component", "child" ).init();
// Uncomment the following line the first time this object is instantiated
//obj.test( "testing" );
--
Taco Fleur
Senior Web Systems Engineer
http://www.webassociates.com <http://www.webassociates.com/>
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188596
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: toString() generates invalid xml [solution]
Here is another way to solve the problem.. var Stream = createObject( "java", "java.io.ByteArrayOutputStream" ); var Transformer = createObject( "java", "javax.xml.transform.TransformerFactory").newInstance().newTransformer(); var DOMSource = createObject( "java", "javax.xml.transform.dom.DOMSource" ); var StreamResult = createObject( "java", "javax.xml.transform.stream.StreamResult" ); var OutputKeys = createObject( "java", "javax.xml.transform.OutputKeys" ); // Initialize class instances Stream.init(); DOMSource.init( arguments.xmlObject.getDocumentElement() ); StreamResult.init( stream ); // *** this is the part the CF toString() method is missing! Transformer.setOutputProperty( OutputKeys.METHOD, "xml"); // Perform the actual serialization Transformer.transform( DOMSource, StreamResult ); return Stream.toString(); Taco Fleur > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Saturday, 18 December 2004 12:07 PM > To: CF-Talk > Subject: RE: toString() generates invalid xml [solution] > > > Thanks for all the help! > > problem solved!! > > A new day, did some tests to verify my suspicions! > > > > > > This is the body > > > > > > > > xmlns="http://www.w3.org/1999/xhtml";> > > > > This is the body > > > > > > > > > > > > This is the body > > > > > > > > > > So I have my html document as XML which I will transform to > HTML at a later stage, but want to execute some > transformations on it first! To do this I need to call > toString() on the DOM which generated a real html document, > not an xml presentation of my HTML file, so I guess I need to > put the xhtml namespace on the file treath it as xhtml and > then when done convert it to html > > > Taco Fleur > > > ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188187 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: toString() generates invalid xml [solution]
Thanks for all the help! problem solved!! A new day, did some tests to verify my suspicions! This is the body http://www.w3.org/1999/xhtml";> This is the body This is the body So I have my html document as XML which I will transform to HTML at a later stage, but want to execute some transformations on it first! To do this I need to call toString() on the DOM which generated a real html document, not an xml presentation of my HTML file, so I guess I need to put the xhtml namespace on the file treath it as xhtml and then when done convert it to html.... Taco Fleur ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188113 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: toString() generates invalid xml
Hi, It returns the same string as toString(), see following result my title http://development.internet/framework/_resource/style/form.css"; type="text/css">Fusion MXSystem Notice the link element.. Once again - the document is valid before calling xmlToString() Its driving me nuts.. Its like it knows it needs to convert to html (while that's not what I want) Taco Fleur > -Original Message- > From: Jamie Price [mailto:[EMAIL PROTECTED] > Sent: Friday, 17 December 2004 8:08 AM > To: CF-Talk > Subject: Re: toString() generates invalid xml > > > I don't know if this helps or not, but here's an interal KB > we have on a ToString/XML bug: > > CFMX function toString() outputs null when attempting to > output a XML document created with the tag. > > Example: > > #XMLFormat(Trim(tempText))# > #XMLFormat(Trim(tempLink))# > > ToString Result: #ToString(ticker)# > The preceding toString() function outputs null or an empty string. > > Answer/Solution: > The following solution was found on Macromedia's forums. (see > reference below) > > 1. Copy and paste this CF code into the template where the > toString function is being used. > > > > > > > >"java.io.ByteArrayOutputStream")> >"javax.xml.transform.TransformerFactory").newInstance().newTra > nsformer()> >"javax.xml.transform.dom.DOMSource")> >"javax.xml.transform.stream.StreamResult")> > > > > > > > > > > > > > > 2. replace the toString() function with XmlToString() in the CF Code. > > Reference: > http://webforums.macromedia.com/coldfusion/messageview.cfm?cat id=143&threadid=461867 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187964 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: toString() generates invalid xml
Nobody ever had this problem then, or nobody knows about the internals of toString() - or is it not clear what my problem is? > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Thursday, 16 December 2004 6:16 PM > To: CF-Talk > Subject: toString() generates invalid xml > > > I have a valid (its valid, it parses!) XML object (basically a > representation of a HTML page), when I call toString() it > creates invalid > XML, i.e. > > becomes > > now correct me if I am wrong, toString() does not perform a xsl > transformation and thinks its smart enough to create HTML out > of my XML? > > > Taco Fleur > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187954 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: toString() generates invalid xml
Nothing but ColdFusion... Taco Fleur > -Original Message- > From: Keith Gaughan [mailto:[EMAIL PROTECTED] > Sent: Friday, 17 December 2004 12:21 AM > To: CF-Talk > Subject: Re: toString() generates invalid xml > > > Taco Fleur wrote: > > > I have a valid (its valid, it parses!) XML object (basically a > > representation of a HTML page), when I call toString() it creates > > invalid XML, i.e. > > > > becomes > > > > now correct me if I am wrong, toString() does not perform a xsl > > transformation and thinks its smart enough to create HTML out of my > > XML? > > 'Twould be good to know what parser libraries you're using. > > K. > > -- > Keith Gaughan, Developer > Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, > Ireland http://digital-crew.com/ > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 15/12/2004 > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187940 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
toString() generates invalid xml
I have a valid (its valid, it parses!) XML object (basically a representation of a HTML page), when I call toString() it creates invalid XML, i.e. becomes now correct me if I am wrong, toString() does not perform a xsl transformation and thinks its smart enough to create HTML out of my XML? Taco Fleur ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187860 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: xmlNSUri
Got it objXML.xmlRoot.xmlns (duh) Taco Fleur > -Original Message- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 15 December 2004 7:12 PM > To: CF-Talk > Subject: xmlNSUri > > > How do I set the xmlNSUri in ColdFusion? > > I tried > > objXML.xmlRoot.xmlNSUri = "whatever"; > > objXML.xmlRoot.xmlAttributes.xmlNSUri = "whatever"; > > none seem to set the namespace. > Anyone any ideas? > > Taco Fleur > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187704 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
xmlNSUri
How do I set the xmlNSUri in ColdFusion? I tried objXML.xmlRoot.xmlNSUri = "whatever"; objXML.xmlRoot.xmlAttributes.xmlNSUri = "whatever"; none seem to set the namespace. Anyone any ideas? Taco Fleur ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187703 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Range regex
I want to use regular expressions to check numeric ranges, I have come up with the following, and it works, but I was wondering whether there is an easier regex that can be constructed, one you look at and go "yes, I see that you want to check for a range"... Between 25 and 75 #i# is #yesnoformat( refindnocase( "\b[3-7][0-5]|[3-6][0-9]|2[5-9]\b", i ) )# Also, to construct this regex took me a while, the logic I used to construct it was - first allow 3 to 7 in the ten range and 0 to 5 in the one range, allowing 30,31,32,33,34,35,40,41,42,43,44,45 . 75 - then allow 3-6 in the ten range and 0 to 9 in the one range, allowing 30,31,32,33,34,35,36,36,37,38,39,40,41 69 - then allow the litteral 2 and 5-9 in the one range, allowing 25,26,27,28,29 Which covers the whole range I want to check for. Anyone? -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com <http://www.webassociates.com/> ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186046 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFC required arguments
Another option is to use the argumentCollection, i.e. obj.method( argumentCollection = structureContainingAllRequiredArguments ) Example: variables.argumentCollection = structNew(); variables.argumentCollection.argument1 = form.argument1; variables.argumentCollection.argument2 = url.argument2; variables.argumentCollection.argument3 = variables.argument3; obj.method( argumentCollection = variables.argumentCollection ) Off course if all arguments were in the form scope you could do obj.method( argumentCollection = form ) -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Paul Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, 1 December 2004 9:20 AM To: CF-Talk Subject: CFC required arguments I'm using createObject to invoke a CFC and one of the methods in the CFC takes a number of arguments, all numeric but not all required. In the CFC I have some conditional statements that do various things based on the arguments passed in. do this Firstly is it a good idea to do this in a CFC? And secondly, how can I pass is the only the arguments required .e.g. http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185761 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFC required arguments
By named parameters. Offcourse the argument name has to match the name in the method. > do this > Firstly is it a good idea to do this in a CFC? Not sure what to answer here, I know in OOP it's a bad thing to have switches and if's in a method. Maybe your better off creating another method? It's a shame we can't overload methods like in Java :-( -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Paul Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, 1 December 2004 9:20 AM To: CF-Talk Subject: CFC required arguments I'm using createObject to invoke a CFC and one of the methods in the CFC takes a number of arguments, all numeric but not all required. In the CFC I have some conditional statements that do various things based on the arguments passed in. do this Firstly is it a good idea to do this in a CFC? And secondly, how can I pass is the only the arguments required .e.g. http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185757 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: inserting empty dates into MSSQL
You need to set the null attribute to yes, if the value is null Or INSERT INTO tblFeed( PMEDICDATE ) VALUES ( NULL ) PS. Use DTS to import files! -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: Tuesday, 23 November 2004 9:57 AM To: CF-Talk Subject: inserting empty dates into MSSQL hi - I have now spent 1 whole day trying to import a whole stack of CSV data into a MSSQL table. My insert query keeps falling over when it hits an empty date field. The MSDE table has a datetime field to enter this particular date into, but some of my CSV fields have empty dates, and will continue to have empty dates from time to time. I have tried: INSERT INTO tblFeed( PMEDICDATE ) VALUES ( #CreateODBCDateTime(qGetData.PMEDICDATE)# ) and: INSERT INTO tblFeed( PMEDICDATE ) VALUES ( ) I just cant get anything to work, I can import data until it hits a row with an empty date field. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185099 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML via OLEDB
Your best bet would be to use CF, since you are familiar with it.. There is a whole lot of info on xmlSearch in the CFDOCS, if you have them installed.. Basically it works like this: Now you have an XML object you can query with xmlSearch or access like a structure and arrays depending on how you created your XML file... -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 9:56 AM To: CF-Talk Subject: RE: XML via OLEDB Thank you for your reply. Where can I get more information on: xmlSearch, and OPENXML? What is the simplest way to read and modify values in XML files? Do I have to do the parsing in Cold Fusion all myself or is there a way I can access each item as a "property" somehow where I can just change a value? Sorry if my questions are lame... I am new to working with XML files in CF. -Dustin CF MX 6.1 -Original Message----- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 3:04 PM To: CF-Talk Subject: RE: XML via OLEDB Not sure what your reason are for specifically wanting an OLEDB Driver (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/ht m/xmloledbprovider_1ar6.asp), but there are many ways (easier) to query an XML file: 1. read it with cffile, parse it and search it with xmlSearch 2. read it with cffile, pass it to an SP and use OPENXML to search it 3. you can store the files in a XML database http://exist.sourceforge.net/ 4. plus many more ways -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:31 AM To: CF-Talk Subject: OT: XML via OLEDB Sorry for the OT post. Does anyone know if it there is an OLEDB driver that allows you to access an XML file as a database and query it? -Dustin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184836 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML via OLEDB
Not sure what your reason are for specifically wanting an OLEDB Driver (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/ht m/xmloledbprovider_1ar6.asp), but there are many ways (easier) to query an XML file: 1. read it with cffile, parse it and search it with xmlSearch 2. read it with cffile, pass it to an SP and use OPENXML to search it 3. you can store the files in a XML database http://exist.sourceforge.net/ 4. plus many more ways -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:31 AM To: CF-Talk Subject: OT: XML via OLEDB Sorry for the OT post. Does anyone know if it there is an OLEDB driver that allows you to access an XML file as a database and query it? -Dustin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184831 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML via OLEDB
Sorry, I didn't read your post properly. SQL XML support does not apply here. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Taco Fleur [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:37 AM To: CF-Talk Subject: RE: XML via OLEDB On MS SQL you could install "SQL XML Support in IIS" and then you can query it with Xpath (xmlSearch in CF).. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:31 AM To: CF-Talk Subject: OT: XML via OLEDB Sorry for the OT post. Does anyone know if it there is an OLEDB driver that allows you to access an XML file as a database and query it? -Dustin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184827 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: XML via OLEDB
On MS SQL you could install "SQL XML Support in IIS" and then you can query it with Xpath (xmlSearch in CF).. -- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -Original Message- From: Dustin Snell [mailto:[EMAIL PROTECTED] Sent: Friday, 19 November 2004 8:31 AM To: CF-Talk Subject: OT: XML via OLEDB Sorry for the OT post. Does anyone know if it there is an OLEDB driver that allows you to access an XML file as a database and query it? -Dustin ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184826 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Reference to complex var not destroyed
Yes ok I get it now, *ignore* my last email... There is still a reference, i.e. the one in the server scope itself.. OK, I understand it now. So, references change, but do not get deleted when one of the references get deleted. Ok all clear, thanks. Taco Fleur > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Friday, 19 November 2004 12:55 AM > To: CF-Talk > Subject: RE: Reference to complex var not destroyed > > > > I don't think you understand me correctly, I understand that > > a REFERENCE is created and not a copy of the structure > > itself, if you read my message again you might see this. > > > > My question is: why is the reference not destroyed when the > > original structure is? When I update the original structure > > with another value the reference is updated, but why not > > destroyed? > > No, I understood you correctly. When you create a structure > using, say, StructNew, you're actually creating two things - > the structure itself, and a reference to the structure. The > structure itself can have as many references as you like, and > they all point you back to the actual structure. > > bar = foo> > > The structure itself will stick around as long as there's at > least one reference still around. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184809 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Reference to complex var not destroyed
Hi Dave, > The structure itself will stick around as long as there's at > least one reference still around. If you look at one of my emails where I says I set it in the server scope, you will see that the above statement is not true, which is *the only thing this email is about*. > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184808 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query using 'FOR XML' & Coldfusion
Here it is, -- Author: Taco Fleur ([EMAIL PROTECTED]) -- Function: Returns an XML string from a FOR XML clause -- Credit: I could not have come this far without the help of Hillaire from Experts-Exchange. -- Copyright: This code can be used freely as long as this header remains intact. -- Requirements: MS SQL 2000 (SP3) -- Known issues: The current limit of the returned XML document is 4000 CREATE PROCEDURE [dbo].[sp_forXML] ( @serverName VARCHAR(40), @databaseName VARCHAR(40), @selectStatement TEXT, @xml NVARCHAR(4000) OUTPUT ) AS DECLARE @returnCode INT, -- the status code returned from calls to sp_OA @objStream INT, -- the ADO stream object @objCommand INT, -- the ADO command object @errorSource VARCHAR(2550), @errorDescription VARCHAR(2550), @connectionString VARCHAR(1000), @filesize INT, @objProperty INT, @objOutputStream INT SET @connectionString = 'Data Source=' + @serverName + '; Provider=SQLOLEDB; Initial Catalog=' + @databaseName + '; Integrated Security=SSPI' EXEC @returnCode = sp_OACreate 'ADODB.Stream', @objStream OUTPUT IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error ADODB.Stream: ', @errorSource, @errorDescription END EXEC @returnCode = sp_OACreate 'ADODB.Command', @objCommand OUTPUT IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error ADODB.Command: ', @errorSource, @errorDescription END EXEC @returnCode = sp_OASetProperty @objCommand, 'ActiveConnection', @connectionString IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error ActiveConnection: ', @errorSource, @errorDescription END EXEC @returnCode = sp_OASetProperty @objCommand, 'CommandText', @selectStatement IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error CommandText: ', @errorSource, @errorDescription END EXEC @returnCode = sp_OAMethod @objStream,'Open' IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error Open: ', @errorSource, @errorDescription END --Get a pointer to the properties collection EXEC @returnCode = sp_OAGetProperty @objCommand, 'Properties', @objProperty OUTPUT IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error Properties: ', @errorSource, @errorDescription END -- Get a pointer to the "Output Stream" property EXEC @returnCode = sp_OAMethod @objProperty, 'Item', @objOutputStream OUT, 'Output Stream' IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error Item: ', @errorSource, @errorDescription END -- Set Property value EXEC @returnCode = sp_OASetProperty @objOutputStream, 'Value', @objStream IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error Value: ', @errorSource, @errorDescription END -- Invoke execute method EXEC sp_OAMethod @objCommand, 'Execute', null, null, null, 1024 IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error Execute: ', @errorSource, @errorDescription END -- Check output stream size EXEC @returnCode = sp_OAGetProperty @objStream, 'Size', @fileSize OUT IF @filesize < 4000 BEGIN -- ReadText EXEC @returnCode = sp_OAMethod @objStream,'ReadText', @xml OUT IF @returnCode <> 0 BEGIN EXEC sp_OAGetErrorInfo @objStream, @errorSource OUTPUT, @errorDescription OUTPUT SELECT 'Error ReadText: ', @errorSource, @errorDescription END END ELSE BEGIN SET @xml = 'Output is too large to fit nvarchar(4000) variable' END SELECT @xml AS 'Result' -- Clean up. E
RE: Reference to complex var not destroyed
Ok, To make a long story short, you guys are saying a reference does not get deleted when the reference to the object (or the object) gets deleted, and this is normal behavior. It's the following comments though that are still vague, "it could be" and "maybe". I'm just trying to fully understand what is *really* going on ;-) > It could be that, when you delete the last reference > to the object, CF deletes the object itself. Or maybe CF > doesn't and the garbage collector does it later. In the end what I was hoping for was that when I set a complex structure in the application scope and then create a reference to it in the server scope, the one in the server scope get deleted when the application scope times out.. Taco Fleur ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184721 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query using 'FOR XML' & Coldfusion
The only way I found to do this is actually get an ADO stream, I wrote an SP that gets the result and stores it into a T-SQL variable. If you are interested I can post it when I find it..? Taco Fleur > -Original Message- > From: Andy McShane [mailto:[EMAIL PROTECTED] > Sent: Thursday, 18 November 2004 8:27 PM > To: CF-Talk > Subject: RE: SQL Query using 'FOR XML' & Coldfusion > > > Can you remember at all how you handled the column names? > i.e. 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > > -Original Message- > From: Rob [mailto:[EMAIL PROTECTED] > Sent: 17 November 2004 17:42 > To: CF-Talk > Subject: Re: SQL Query using 'FOR XML' & Coldfusion > > Yes, you have to loop over the query columns and build a new > string with the columns data. > > The way you go about it is pretty wacky and I forget the > syntax, but I (and others) have posted how to do it to the > list at one point so it should be in the archive (it was like > a year ago though) > > On Wed, 17 Nov 2004 07:58:42 -0400, Andy Mcshane > <[EMAIL PROTECTED]> wrote: > > Hi all. I am trying to utilise the SQL2000 'FOR XML' > functionality to > return the results of a stored procedure, called from > Coldfusion using 'CFStoredProc', as an XML string to my > Coldfusion app. I am having a few problems; > > > > When I run the query in the SQL query window the results > are exactly > > as I > want, when I then call the stored procedure from Coldfusion > app I get a recordset with multiple rows instead of one > record containing a string and when I look at the > 'ColumnList' property of the query I have mulitple columns > with a naming convention as > 'XML_F52E2B61-18A1-11D1-B105-00805F49916B'. > > > > Has anybody managed to use this SQL 'FOR XML' functionality in a > Coldfusion app before? > > > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184720 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
