Looking for advice on how to do this - remote printing
I am working on a project where I am going to have to print up a job ticket in a remote location. An event happens on the web site, and it causes this job ticket to print out in one of perhaps thousands of locations unattended.The people who are going to fill the job will have no interaction with teh system except to take the job ticket off the printer and do the task. We've specced out the whole application except for the part where we connect all these remote locations to the web site.What i want is to be able to push a xml packet to this remote location and get back an ack so i know its been received and executed. Since there will be minimal training of the staff at the remote locations and they wont necessarily have access to IT staff or other specialists, we were hoping to be able to keep it as simple as the EFTPOS terminals they have in retail stores. The main difference is that with a EFTPOS terminal the store clerk starts the transaction - we're going to start this transaction at the other end and push it down to the remote location. Daily running cost is a factor, so we dont want to have the remote devices making calls to our system by modem every few minutes - we want to have it all run from our web site. Any ideas on how this could be done? The environment as far as we have it: We have a CF8 Enterprise/Win2003/SQLServer web site, and think the remote sites will need a small low-cost self-contained Linux box with a little thermal printer or something but exactly how they're connected we havent worked out yet. Anyone have experience with this kind of scenario? Perhaps a factory job ticket or a retail point of sale system maybe? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323328 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server (RESOLVED)
Dude and double dude! Excellent work :OD To stop the errors we started looking in files for certain strings to indicate the image would crap out CF. Will let you know how we get on when we upgrade. Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 22:49 To: cf-talk Subject: RE: Image killing server (RESOLVED) Adrian, I have an explanation and a resolution for you. The problem is a buffer overrun in the ICC parser (a bit of color correction meta data that ships with the image). To resolve it I upgraded my JVM from 1.6.0_04 to 1.6.0_14 ... But _05 or above would do the trick I think. I'll write a blog on it and give a more thorough explanation - but meanwhile, I found my best clues by looking not for ColdFusion related image issues, but javax.imagaio related image issues. I found this post: http://www.securiteam.com/securitynews/5SP0E1PNQA.htm Which lead me more closely examine the update (build) number of my JVM install. I hope this helps you! -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 10:49 AM To: cf-talk Subject: RE: Image killing server Thanks Mark. You're right, I'm beginning to think I shouldn't have posted it on here now. I've submitted a bug report to Adobe. When I open it in GIMP I get told The image 'killer.jpg' has an embedded colour profile: eciRGB v2 ICCv4. cftry/cfcatch doesn't help so the only way I can think of to spot this prior to using ImageRead() etc. is to read the file in with cffile and look for eciRGB v2 ICCv4. But who's to say that will cover all the bases? Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 16:32 To: cf-talk Subject: RE: Image killing server Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Little help with IIS URL Rewrite..
It's failing because it's expecting http://mysite-test.myhost.net/net/wagon/red/small Start the expression with just ^/ instead of having net in there. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cf8 help with japanese characters
I've been struggling with a cf8 and database issue involving japanese characters for almost 2 weeks now. using cf8 and either mysql server or microsoft sql server 2008 express (both give me the same result), i am attempting to insert/update records containing japanese text. the japanese text doesn't insert into the database, only ?? (questions marks get inserted) I've checked the collation levels for microsoft sql server 2008 express. There's 2 ways to assign collation on a column; either SQL collation or Windows collation. The SQL collation option doesnt contain any Japanese collation options so I choose windows collation. In Windows collation, there's 4 different options to choose from. Unfortunately, I tried all of them with no success. I'm starting to think this is a driver related issue. The debug output displays the query with the japanese characters as I've typed them. I don't know what else to try. I don't know if this matters but my computer has an english version of Windows Vista . I've set my region to Japan. I've even set my IE browser language to Japanese. If I can't get the Japanese characters into the database, I am totally screwed. I hope somebody knows how to fix this problem. It is probably very simple but I am overlooking the obvious. Please help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cf8 help with japanese characters
mike pop wrote: using cf8 and either mysql server or microsoft sql server 2008 express (both give me the same result), i am attempting to insert/update records containing japanese text. and how are the columns holding the text defined? what db driver are you using? the japanese text doesn't insert into the database, only ?? (questions marks get inserted) question marks mean the data is garbaged by a fatal encoding flaw. boxes mean a less tragic encoding error where the whatever can't render that char using the current font. I've checked the collation levels for microsoft sql server 2008 express. There's 2 ways to assign collation on a column; either SQL collation or Windows collation. irrelevant for this issue. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cf8 help with japanese characters
Collation's not the problem, but the Data Type of your columns might be. Make sure you're using nvarchar ntext (not varchar and text) [SQL Server] and ensure that both page and form encoding allow Unicode, like using charset UTF-8. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:32 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cf8 help with japanese characters
On Wed, Jun 10, 2009 at 6:32 AM, mike pop mikepoplaw...@gmail.com wrote: I've been struggling with a cf8 and database issue involving japanese characters for almost 2 weeks now. using cf8 and either mysql server or microsoft sql server 2008 express (both give me the same result), i am attempting to insert/update records containing japanese text. the japanese text doesn't insert into the database, only ?? (questions marks get inserted) Here is the link to the Adobe knowledge base entry on encoding: http://kb2.adobe.com/cps/165/tn_16597.html Plus, this link on UNICODE from the European Commission Information Provider's Guide, which discusses Coldfusion and encoding: http://ec.europa.eu/ipg/standards/other/standard_unicode_en.htm My blog entries on handling characters with diacritics may, or may not, be of any help: http://speeves.erikin.com/2009/06/coldfusion-postgresql-prepare-norwegian.html http://speeves.erikin.com/2009/06/coldfusion-encodedecode-diacriticals.html http://speeves.erikin.com/2009/06/coldfusion-replace-html-ized-characters.html Take care, speeves ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323334 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for advice on how to do this - remote printing
I had a similar, yet much smaller project last summer... Our student center allows students to checkout laptops for a couple of hours. The staff wanted to be able to print receipts when checked-out/in. Also, the system was to be web-based. We purchased an Epson POS thermal printer with USB and attached it to a remote computer. (By remote, I mean across campus about 1000' away.) Once the USB POS printer was connected to the remote computer, I shared the printer. On the web server, I connected to the remote POS printer. Then, I was able to send text files to the POS printer and have it print correctly. Finally, I created my CF application that generates a string of text and command characters. This string is saved to a text file, on the web server. CFEXECUTE then runs a print command that passes the text file to the POS printer. The printer prints and everyone is happy. Thanks, Mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for advice on how to do this - remote printing
I did a similar thing by sending a fax to the remote locations. Worked nicely. The fax told them the job, and also told them to acknowledge receipt on the website.. so they would go to the website and a list of pending jobs was waiting for them, in case they missed a fax somehow.. Then they just check off the completed items. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for advice on how to do this - remote printing
How many daily tickets on average? -- Ryan LeTulle On Wed, Jun 10, 2009 at 2:28 AM, Mike Kear afpwebwo...@gmail.com wrote: I am working on a project where I am going to have to print up a job ticket in a remote location. An event happens on the web site, and it causes this job ticket to print out in one of perhaps thousands of locations unattended.The people who are going to fill the job will have no interaction with teh system except to take the job ticket off the printer and do the task. We've specced out the whole application except for the part where we connect all these remote locations to the web site.What i want is to be able to push a xml packet to this remote location and get back an ack so i know its been received and executed. Since there will be minimal training of the staff at the remote locations and they wont necessarily have access to IT staff or other specialists, we were hoping to be able to keep it as simple as the EFTPOS terminals they have in retail stores. The main difference is that with a EFTPOS terminal the store clerk starts the transaction - we're going to start this transaction at the other end and push it down to the remote location. Daily running cost is a factor, so we dont want to have the remote devices making calls to our system by modem every few minutes - we want to have it all run from our web site. Any ideas on how this could be done? The environment as far as we have it: We have a CF8 Enterprise/Win2003/SQLServer web site, and think the remote sites will need a small low-cost self-contained Linux box with a little thermal printer or something but exactly how they're connected we havent worked out yet. Anyone have experience with this kind of scenario? Perhaps a factory job ticket or a retail point of sale system maybe? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for advice on how to do this - remote printing
I am afraid i dont know we're only starting out on a new project but it could be dozens or even hundreds of remote points, scattered all over the place. So that represents lots of scalability issues in designing the application which i'm giving a lot of thought. But its the remote printing to a whole variety of locations, where there will be no interaction with the system apart from a non-IT trained person picking up the printed out put and executing the job.It's the connectivity to all those devices and how to trigger the printing that gives me cause to ponder. We can have intelligence on that device so it can format printing and all that if i sent it a XML packet or some such. It would be good to be able to require only a power point there if possible - so they plug it into the power, turn it on at the wall and its available to the system by itself. that way there's no need for us to provide keyboards, screens, training etc if that is at all possible. Certainly no specialised staff. I'm sorry if i have to be a bit vague about the actual specifics of the app - its still in progress and once launch i can say more. But since we're only now scoping out the job launch is a while away yet. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Jun 11, 2009 at 12:22 AM, Ryan Letullebayous...@gmail.com wrote: How many daily tickets on average? -- Ryan LeTulle On Wed, Jun 10, 2009 at 2:28 AM, Mike Kear afpwebwo...@gmail.com wrote: I am working on a project where I am going to have to print up a job ticket in a remote location. An event happens on the web site, and it causes this job ticket to print out in one of perhaps thousands of locations unattended. The people who are going to fill the job will have no interaction with teh system except to take the job ticket off the printer and do the task. We've specced out the whole application except for the part where we connect all these remote locations to the web site. What i want is to be able to push a xml packet to this remote location and get back an ack so i know its been received and executed. Since there will be minimal training of the staff at the remote locations and they wont necessarily have access to IT staff or other specialists, we were hoping to be able to keep it as simple as the EFTPOS terminals they have in retail stores. The main difference is that with a EFTPOS terminal the store clerk starts the transaction - we're going to start this transaction at the other end and push it down to the remote location. Daily running cost is a factor, so we dont want to have the remote devices making calls to our system by modem every few minutes - we want to have it all run from our web site. Any ideas on how this could be done? The environment as far as we have it: We have a CF8 Enterprise/Win2003/SQLServer web site, and think the remote sites will need a small low-cost self-contained Linux box with a little thermal printer or something but exactly how they're connected we havent worked out yet. Anyone have experience with this kind of scenario? Perhaps a factory job ticket or a retail point of sale system maybe? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for advice on how to do this - remote printing
In my earlier reply, I mentioned that we are using an Epson POS printer with USB. This same printer can be used with a built-in NIC. That means it would not need a host computer to which it is attached. Thanks, Mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Image killing server (RESOLVED)
Adria, I blogged this solution http://www.coldfusionmuse.com/index.cfm/2009/6/10/javax.imageio.jpg.crash.jv m -Mark -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Wednesday, June 10, 2009 3:21 AM To: cf-talk Subject: RE: Image killing server (RESOLVED) Dude and double dude! Excellent work :OD To stop the errors we started looking in files for certain strings to indicate the image would crap out CF. Will let you know how we get on when we upgrade. Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 22:49 To: cf-talk Subject: RE: Image killing server (RESOLVED) Adrian, I have an explanation and a resolution for you. The problem is a buffer overrun in the ICC parser (a bit of color correction meta data that ships with the image). To resolve it I upgraded my JVM from 1.6.0_04 to 1.6.0_14 ... But _05 or above would do the trick I think. I'll write a blog on it and give a more thorough explanation - but meanwhile, I found my best clues by looking not for ColdFusion related image issues, but javax.imagaio related image issues. I found this post: http://www.securiteam.com/securitynews/5SP0E1PNQA.htm Which lead me more closely examine the update (build) number of my JVM install. I hope this helps you! -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 10:49 AM To: cf-talk Subject: RE: Image killing server Thanks Mark. You're right, I'm beginning to think I shouldn't have posted it on here now. I've submitted a bug report to Adobe. When I open it in GIMP I get told The image 'killer.jpg' has an embedded colour profile: eciRGB v2 ICCv4. cftry/cfcatch doesn't help so the only way I can think of to spot this prior to using ImageRead() etc. is to read the file in with cffile and look for eciRGB v2 ICCv4. But who's to say that will cover all the bases? Adrian -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: 09 June 2009 16:32 To: cf-talk Subject: RE: Image killing server Follow up: I can verify the image is able to be previewed and edited using fireworks. I can't see anything unusual about it. I have to say if it's a something that is reproducible, it's going to be an attack vector. I can think of 3 or 4 servers I manage that need a fix for this pretty quickly if it becomes common knowledge. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mark Kruger [mailto:mkru...@cfwebtools.com] Sent: Tuesday, June 09, 2009 10:27 AM To: cf-talk Subject: RE: Image killing server Adrian, I verified your results on an 8.01 dev server running on my local XP box. Sure enough the service restarts. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Tuesday, June 09, 2009 9:43 AM To: cf-talk Subject: Image killing server Hey all, got a bit of a strange one here. A user is uploading an image which GIMP is reporting to have an embedded colour profile of . When I use any of the image functions on this image, CF dies. I posted a while ago but because it was only one user we converted it manually and re-uploaded, now we're getting more of them. Could I ask for a sanity check by someone confirming that this image is killing their server too? http://www.halestorm.co.uk/images/killer.jpg Download it, create a .cfm page and do ImageRead(ExpandPath(./killer.jpg)) I get a blank page back then on refresh a message saying CF is starting up. I'm on the bug report page at the moment but I thought I would get someone else to test this also. Thanks. Adrian Lynch | www.halestorm.co.uk ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cf8 help with japanese characters
Collation's not the problem, but the Data Type of your columns might be. Make sure you're using nvarchar ntext (not varchar and text) [SQL Server] and ensure that both page and form encoding allow Unicode, like using charset UTF-8. I'll +1 that, the data type is almost always the main culprit, most especially on data inserts or updates, to be 100% sure, set your data type on data insertion by preceding the letter N so e.g. cfquery datasource=#application.dsn# name=getthedata UPDATE tblName SET column = N 'the japanese chararcters' /cfquery cfquery datasource=#application.dsn# name=getthedata INSERT INTO (column) VALUES(N'the japanese chararcters') /cfquery cfqueryparam will do nicely actually...but I usually start with the above as a process of eliminination. The problem was a particular hassle on SQL Server 2K. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Simple regex question
I'm in need of some regex help. I am working with a cfinput and I need a pattern for regex validation that does the following: Field can be blank but if filled out has to be exactly 17 characters which are a combination of letters and numbers (VIN number) Know this is simple but Google seems to be failing me this morning. Thanks, Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple regex question
Try this: ^$|^[\w]{17}$ -Ben -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323343 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple regex question
[ ]|[a-z0-9]{17} Should do it... That basically allows for a space, or for 17 alphanumeric characters. -Original Message- From: Rick Mason [mailto:rhma...@gmail.com] Sent: Wednesday, June 10, 2009 9:50 AM To: cf-talk Subject: Simple regex question I'm in need of some regex help. I am working with a cfinput and I need a pattern for regex validation that does the following: Field can be blank but if filled out has to be exactly 17 characters which are a combination of letters and numbers (VIN number) Know this is simple but Google seems to be failing me this morning. Thanks, Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple regex question
Great minds Ben...great minds. -Original Message- From: Ben Nadel [mailto:b...@bennadel.com] Sent: Wednesday, June 10, 2009 9:51 AM To: cf-talk Subject: Re: Simple regex question Try this: ^$|^[\w]{17}$ -Ben -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323345 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple regex question
Ha ha, most agreed :) -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323346 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple regex question
Technically speaking, the regex that Ben or I posted isn't correct. You can't just have 17 alnum characters as each character (or character pairs) in a VIN has a specific slot. Plus, VINs don't have the letters I, O, or Q. Here's an excellent forum post about the subject. http://www.phpfreaks.com/forums/index.php?topic=217075.0 It all just depends on how accurate you need to be. andy -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Wednesday, June 10, 2009 9:52 AM To: cf-talk Subject: RE: Simple regex question [ ]|[a-z0-9]{17} Should do it... That basically allows for a space, or for 17 alphanumeric characters. -Original Message- From: Rick Mason [mailto:rhma...@gmail.com] Sent: Wednesday, June 10, 2009 9:50 AM To: cf-talk Subject: Simple regex question I'm in need of some regex help. I am working with a cfinput and I need a pattern for regex validation that does the following: Field can be blank but if filled out has to be exactly 17 characters which are a combination of letters and numbers (VIN number) Know this is simple but Google seems to be failing me this morning. Thanks, Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323347 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple regex question
I have to plead ignorance on this one - I don't know what a VIN number is. -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for advice on how to do this - remote printing
Something like Mike's printer solution sounds promising to me. You might need to look into some special formatting/pl for the output so the printer can understand it natively though. I did some work in labs with Zebra printers that required that to print out barcodes. -- Ryan LeTulle On Wed, Jun 10, 2009 at 9:44 AM, Dawson, Michael m...@evansville.eduwrote: In my earlier reply, I mentioned that we are using an Epson POS printer with USB. This same printer can be used with a built-in NIC. That means it would not need a host computer to which it is attached. Thanks, Mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for advice on how to do this - remote printing
What is the nature of the connection between the server and these printers? Will they be on the same LAN or WAN or are they only going to be accessible over the internet? If the former, many modern network printers have the capability to be sent print jobs to their IP address. Thus I would suggest digging up the specifications of these printers and see what options they may be exposing for you. HTH Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple regex question
Thanks you Andy and Ben for your quick response. A VIN number is a vehicle identification number which is on your car's registration as well as being on the driver side dash. Think of it as a unique serial number for your car with vehicle information baked into the number. Andy the only problem that I had with your regex is that it let me enter more than 17 characters. I quickly added a maxlength which corrected the problem. There's a ISVIN function on CFLib and I had originally proposed to my boss that I rewrite it in javascript but he didn't want that level of functionality. Rick On Wed, Jun 10, 2009 at 10:58 AM, Ben Nadel b...@bennadel.com wrote: I have to plead ignorance on this one - I don't know what a VIN number is. -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple regex question
Ben... VIN numbers are unique identifiers for cars. Generally there's a small metal plaque on the driver side part of the dashboard, tucked way back under the windshield. It's a fascinating number, as each set of digits have very specific meanings. You can almost everything about a vehicle from the VIN. andy -Original Message- From: Ben Nadel [mailto:b...@bennadel.com] Sent: Wednesday, June 10, 2009 9:59 AM To: cf-talk Subject: Re: Simple regex question I have to plead ignorance on this one - I don't know what a VIN number is. -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Simple regex question
Think of it as a unique serial number for your car with vehicle information baked into the number. Show me the CARFAX! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323353 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for advice on how to do this - remote printing
You guys are all being very helpful, as always. This is good stuff and it's helping me work out possibilities. @Mike Dawson: thanks Mike, directly accessing the NIC wont work in this case because we wont have all these devices on the same premises. They'll be too remote for a single network.Depending on how the project develops once it's launched, there could be devices all over the country. I dont think you can connect on a single network that far can you and therefore be able to access the NICs directly? I think it will require internet if we're to keep it low cost? @Ryan LeTulle: yes i think thats a certainty.That way we send the absolute minimum of data down the line and use the programmign inside the printer to format it and make it look pretty for the user. It's a fairly straightforward process to have templates stored in laser printer memory and overlaid with all kinds of fonts, graphics, logos, shading etc so a small amount of data prints up as quite a complex page. And you can manipulate those templates remotely too. I did that for several years before i started building web sites. @Ian Skinner: Thanks Ian, that's really the nub of the discussion at our end - how are we going to connect the print devices? I have a background in programming laser printers - that's what i did for a living before getting into web development. so i have no problem taking text and converting it using PCL or PostScript or other language formats so it produces pretty print from a tiny ASCII text file. But the issue for us is how to connect these devices? If we connect them to the internet, there's a modem and phone line and connection to pay for. If we use a wifi connection we can probably do a deal for many of the little dongles and get the cost of that down, but then cell phone coverage is great in the cities but pretty flaky in a lot of areas outside the cities. Most of these locations have a fax, so another option would be to connect our device to that somehow, rather in the way the answering machines pass faxes through and snag people talking I'm kind of hoping someone is going to say why dont you and suggest one of those 'slap the forehead'-'why the hell didn't *I* think of that! ideas. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Jun 11, 2009 at 12:59 AM, Ian Skinnerh...@ilsweb.com wrote: What is the nature of the connection between the server and these printers? Will they be on the same LAN or WAN or are they only going to be accessible over the internet? If the former, many modern network printers have the capability to be sent print jobs to their IP address. Thus I would suggest digging up the specifications of these printers and see what options they may be exposing for you. HTH Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple regex question
There's a ISVIN function on CFLib and I had originally proposed to my boss that I rewrite it in javascript but he didn't want that level of functionality. Just do it, don't ask the boss! :OD ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for advice on how to do this - remote printing
They'll be too remote for a single network.Depending on how the project develops once it's launched, there could be devices all over the country. I dont think you can connect on a single network that far can you and therefore be able to access the NICs directly? I think it will require internet if we're to keep it low cost? It is possible with a VPN through the internets. However, I'm no network guy, so I can't give you the details on what it would take. mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323356 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error register asp.net web service in CF 7 admin
Dave, We have successfully registered .net webservice by passing in username and password. However our project requires this webservice be configured as Integrated Windows Authentication. So, the question for us now becomes: How to invoke .net webservice requires Windows Authentication? We did some research and also tried different ways to make it work. But we still without passing in username and password we get the following error: Could not perform web service invocation UploadFileBasic. Here is the fault returned when invoking the web service operation: AxisFault faultCode: {http://xml.apache.org/axis/}HTTP faultSubcode: faultString: (401)Unauthorized faultActor: faultNode: faultDetail: {}:return code: 401 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01//EN http://www.w3.org/TR/html4/strict.dtd; HTMLHEADTITLEYou are not authorized to view this page/TITLE META HTTP-EQUIV=Content-Type Content=text/html; charset=Windows-1252 STYLE type=text/css BODY { font: 8pt/12pt verdana } H1 { font: 13pt/15pt verdana } H2 { font: 8pt/12pt verdana } A:link { color: red } A:visited { color: maroon } /STYLE /HEADBODYTABLE width=500 border=0 cellspacing=10TRTD h1You are not authorized to view this page/h1 You do not have permission to view this directory or page using the credentials that you supplied because your Web browser is sending a WWW-Authenticate header fi... Some people said: only Microsoft products can pass the required protocols for Windows Integrated Security. Is that true? Please share your thoughts. Thanks, Hong -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, June 03, 2009 5:10 PM To: cf-talk Subject: Re: Error register asp.net web service in CF 7 admin We found the problem. It was a user authentication issue. We were able to register the web service with a network username and password and which is also a valid username/password in HP Trim. Well, that explains why you had an HTML META tag in the response! 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323357 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple regex question
Andy, I jumped the gun a little too quickly. Neither yours nor Ben's works. Your code worked fine when I was just typing in numbers for a quick test. Once I started testing with actual VIN numbers it failed. It isn't counting the letters in the total count. So 12345678901234567 succeeds but 1M345678901234567 fails. Any suggestions? Rick On Wed, Jun 10, 2009 at 10:52 AM, Andy Matthews li...@commadelimited.comwrote: [ ]|[a-z0-9]{17} Should do it... That basically allows for a space, or for 17 alphanumeric characters. -Original Message- From: Rick Mason [mailto:rhma...@gmail.com] Sent: Wednesday, June 10, 2009 9:50 AM To: cf-talk Subject: Simple regex question I'm in need of some regex help. I am working with a cfinput and I need a pattern for regex validation that does the following: Field can be blank but if filled out has to be exactly 17 characters which are a combination of letters and numbers (VIN number) Know this is simple but Google seems to be failing me this morning. Thanks, Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFfunction within a query output
Are we able to run a cffunction within a cf query output? Please see below. Thanks. Don Chunshen Li cfoutput query=myQuery ... cfif conditionX eq 1 cffunction name=getProduct access=public output=no returnType=query cfargument name=id type=numeric required=yes cfset var data = cfquery name=data datasource=myDSN SELECT pname FROM product where id=#Arguments.id# /cfquery cfreturn data /cffunction #getProduct(3)# !-- it fails, why? fyi, the datatype of id is int. -- /cfif /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFfunction within a query output
you need to properly call the function, and since you are NOT in cfscript block, you need to use cfset: cfset somevar = getProduct(3) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 10/06/2009 23:12, Don L wrote: Are we able to run a cffunction within a cf query output? Please see below. Thanks. Don Chunshen Li cfoutput query=myQuery ... cfif conditionX eq 1 cffunction name=getProduct access=public output=no returnType=query cfargument name=id type=numeric required=yes cfset var data = cfquery name=data datasource=myDSN SELECT pname FROM product where id=#Arguments.id# /cfquery cfreturn data /cffunction #getProduct(3)# !-- it fails, why? fyi, the datatype of id is int. -- /cfif /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323360 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple regex question
change [a-z0-9] to [a-zA-Z0-9] it only fails because Andy's regexp does not allow uppercase letters. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 10/06/2009 23:15, Rick Mason wrote: Andy, I jumped the gun a little too quickly. Neither yours nor Ben's works. Your code worked fine when I was just typing in numbers for a quick test. Once I started testing with actual VIN numbers it failed. It isn't counting the letters in the total count. So 12345678901234567 succeeds but 1M345678901234567 fails. Any suggestions? Rick On Wed, Jun 10, 2009 at 10:52 AM, Andy Matthews li...@commadelimited.comwrote: [ ]|[a-z0-9]{17} Should do it... That basically allows for a space, or for 17 alphanumeric characters. -Original Message- From: Rick Mason [mailto:rhma...@gmail.com] Sent: Wednesday, June 10, 2009 9:50 AM To: cf-talk Subject: Simple regex question I'm in need of some regex help. I am working with a cfinput and I need a pattern for regex validation that does the following: Field can be blank but if filled out has to be exactly 17 characters which are a combination of letters and numbers (VIN number) Know this is simple but Google seems to be failing me this morning. Thanks, Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple regex question
PS: and Ben's needs to be adjusted to allow numbers: ^$|^[\w\d]{17}$ Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 10/06/2009 23:15, Rick Mason wrote: Andy, I jumped the gun a little too quickly. Neither yours nor Ben's works. Your code worked fine when I was just typing in numbers for a quick test. Once I started testing with actual VIN numbers it failed. It isn't counting the letters in the total count. So 12345678901234567 succeeds but 1M345678901234567 fails. Any suggestions? Rick On Wed, Jun 10, 2009 at 10:52 AM, Andy Matthews li...@commadelimited.comwrote: [ ]|[a-z0-9]{17} Should do it... That basically allows for a space, or for 17 alphanumeric characters. -Original Message- From: Rick Mason [mailto:rhma...@gmail.com] Sent: Wednesday, June 10, 2009 9:50 AM To: cf-talk Subject: Simple regex question I'm in need of some regex help. I am working with a cfinput and I need a pattern for regex validation that does the following: Field can be blank but if filled out has to be exactly 17 characters which are a combination of letters and numbers (VIN number) Know this is simple but Google seems to be failing me this morning. Thanks, Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323362 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error register asp.net web service in CF 7 admin
We have successfully registered .net webservice by passing in username and password. However our project requires this webservice be configured as Integrated Windows Authentication. So, the question for us now becomes: How to invoke .net webservice requires Windows Authentication? Well, you can't really, not directly from CF at any rate. Integrated Windows Authentication isn't supported by CF. Windows (or NTLM) Authentication sends a hash of the user's password to the server, instead of the actual password itself as Basic Authentication does. Some people said: only Microsoft products can pass the required protocols for Windows Integrated Security. Is that true? Please share your thoughts. No, there are other products that support NTLM Authentication. Firefox does, for example, although it may require configuration. I would look into using an NTLM proxy. When Googling ntlm proxy I found some possible candidates: http://sourceforge.net/projects/ntlmaps/ http://cntlm.sourceforge.net/ If the administrators of the web service can enable Basic Authentication, that would also solve the problem. If they're aiming for interoperability, they shouldn't require Windows Authentication. Of course, Basic Authentication does send credentials in base64-encoded plaintext, so it should be used in conjunction with SSL/TLS. 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple regex question
\w should handle both alpha and numeric data. I am not sure why mine was failing. -Ben -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323364 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple regex question
Azadi, Figured that out while awaiting for the answer. Reached John and Tim Farrar via IM who suggested testing with smaller case letters. Once we confirmed that worked they gave me the update. I will do further testing but that looks like it is a winner. Thanks all, Rick On Wed, Jun 10, 2009 at 12:31 PM, Azadi Saryev az...@sabai-dee.com wrote: PS: and Ben's needs to be adjusted to allow numbers: ^$|^[\w\d]{17}$ Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 10/06/2009 23:15, Rick Mason wrote: Andy, I jumped the gun a little too quickly. Neither yours nor Ben's works. Your code worked fine when I was just typing in numbers for a quick test. Once I started testing with actual VIN numbers it failed. It isn't counting the letters in the total count. So 12345678901234567 succeeds but 1M345678901234567 fails. Any suggestions? Rick On Wed, Jun 10, 2009 at 10:52 AM, Andy Matthews li...@commadelimited.comwrote: [ ]|[a-z0-9]{17} Should do it... That basically allows for a space, or for 17 alphanumeric characters. -Original Message- From: Rick Mason [mailto:rhma...@gmail.com] Sent: Wednesday, June 10, 2009 9:50 AM To: cf-talk Subject: Simple regex question I'm in need of some regex help. I am working with a cfinput and I need a pattern for regex validation that does the following: Field can be blank but if filled out has to be exactly 17 characters which are a combination of letters and numbers (VIN number) Know this is simple but Google seems to be failing me this morning. Thanks, Rick ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323365 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFfunction within a query output
The cfset to a var failed without error, Azadi. I suspect the cf fuction failed without an error, I don't know why the function fails. you need to properly call the function, and since you are NOT in cfscript block, you need to use cfset: cfset somevar = getProduct(3) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 10/06/2009 23:12, D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFfunction within a query output
This is incorrect: you need to properly call the function, and since you are NOT in cfscript block, you need to use cfset: cfset somevar = getProduct(3) You are NOT required to use cfset to call a function. Inside cfoutput, this is valid syntax and will call the function: #doSomething(Args)# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323367 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFfunction within a query output
Call it thusly. Cfset datatest = CreateObject(component,path.to.component.componentname) cfset getQuery = datatest.getQueryFunction(passed parameters if needed) cfoutput query=getQuery #outputFromQuery# /cfoutput -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: Wednesday, June 10, 2009 12:13 PM To: cf-talk Subject: CFfunction within a query output Are we able to run a cffunction within a cf query output? Please see below. Thanks. Don Chunshen Li cfoutput query=myQuery ... cfif conditionX eq 1 cffunction name=getProduct access=public output=no returnType=query cfargument name=id type=numeric required=yes cfset var data = cfquery name=data datasource=myDSN SELECT pname FROM product where id=#Arguments.id# /cfquery cfreturn data /cffunction #getProduct(3)# !-- it fails, why? fyi, the datatype of id is int. -- /cfif /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323368 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFfunction within a query output
Don, the problem is that you are trying to output a complex object as a string. You need to do one of: - use cfdump to have CF display your query as HTML; - manually convert your query to a string; - extract the appropriate fields and output those instead; - change the function to return a string instead; Also note that you do not need/want to put the function inside the loop. For example, I suspect this code is closer to what you want to do: (note how the function returntype and cfreturn have changed) cffunction name=getProduct access=public output=no returnType=string cfargument name=id type=numeric required=yes cfset var data = cfquery name=data datasource=myDSN SELECT pname FROM product where id= cfqueryparam value=#Arguments.id# cfsqltype=cf_sql_integer/ /cfquery cfreturn data.pname /cffunction cfoutput query=myQuery ... cfif conditionX eq 1 #getProduct(3)# /cfif /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple regex question
In CF regex, \w is same as [a-zA-Z0-9_] Most other regex flavours are the same as this. Some regex flavours also include accented characters (áéí...) in their \w matches. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFfunction within a query output
Peter, awesome, as you correctly pointed it out, the complex data type was the culprit, problem resolved. Also, good catch on the function inside the loop, I've set up a flag to ensure it runs only once, so, that's ok; also initially thought the cf8 engine would run it only once but that could be totally wrong for expecting too much from cf8... Many thanks. Don Don, the problem is that you are trying to output a complex object as a string. You need to do one of: - use cfdump to have CF display your query as HTML; - manually convert your query to a string; - extract the appropriate fields and output those instead; - change the function to return a string instead; Also note that you do not need/want to put the function inside the loop. For example, I suspect this code is closer to what you want to do: (note how the function returntype and cfreturn have changed) cffunction name=getProduct access=public output=no returnType=string cfargument name=id type=numeric required=yes cfset var data = cfquery name=data datasource=myDSN SELECT pname FROM product where id= cfqueryparam value=#Arguments.id# cfsqltype=cf_sql_integer/ /cfquery cfreturn data.pname /cffunction cfoutput query=myQuery ... cfif conditionX eq 1 #getProduct(3)# /cfif /cfoutput ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323371 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF's ImageWrite Function Question...
Does CF's imageWrite() function have a make unique naming capability when writing a file to a directory with a name that already exists? Or do I just need to use cffile? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFfunction within a query output
Better yet, just define the function outside the loop (top of the template?) and then just call it from inside your loop. From: Don L do...@yahoo.com Sent: Wednesday, June 10, 2009 2:39 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: CFfunction within a query output Peter, awesome, as you correctly pointed it out, the complex data type was the culprit, problem resolved. Also, good catch on the function inside the loop, I've set up a flag to ensure it runs only once, so, that's ok; also initially thought the cf8 engine would run it only once but that could be totally wrong for expecting too much from cf8... Many thanks. Don ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF's ImageWrite Function Question...
You'll need to take care of generating a unique name yourself. On Wed, Jun 10, 2009 at 11:58 AM, Che Vilnonisch...@asitv.com wrote: Does CF's imageWrite() function have a make unique naming capability when writing a file to a directory with a name that already exists? Or do I just need to use cffile? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323374 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
mysql and order by datetime
This is strange. I run this query and I get proper results (DateAdded is a DateTime data type): SELECT PP.ProfileID FROM profilepicts PP WHERE PP.Live = 1 ORDER BY PP.DateAdded DESC RESULTS: 3 2 2 2 1 5 3 6 I add a distinct and I get SELECT DISTINCT(PP.ProfileID) FROM profilepicts PP WHERE PP.Live = 1 ORDER BY PP.DateAdded DESC RESULTS: 5 3 6 1 2 Why did 5 come first after I added the DISTINCT? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: mysql and order by datetime
The only way I found to fix this is to return the first query via MySQL then use a Query of a Query in CF to do a group by on the data and ORDER it by the DateTime field. Strange. SELECT PP.ProfileID FROM profilepicts PP WHERE PP.Live = 1 ORDER BY PP.DateAdded DESC cfquery dbtype=query name=profiles SELECT ProfileID FROM profiles GROUP BY ProfileID ORDER BY DateAdded DESC /cfquery RESULT: 3 2 1 5 6 -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Wednesday, June 10, 2009 5:13 PM To: cf-talk Subject: mysql and order by datetime This is strange. I run this query and I get proper results (DateAdded is a DateTime data type): SELECT PP.ProfileID FROM profilepicts PP WHERE PP.Live = 1 ORDER BY PP.DateAdded DESC RESULTS: 3 2 2 2 1 5 3 6 I add a distinct and I get SELECT DISTINCT(PP.ProfileID) FROM profilepicts PP WHERE PP.Live = 1 ORDER BY PP.DateAdded DESC RESULTS: 5 3 6 1 2 Why did 5 come first after I added the DISTINCT? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323376 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Little help with IIS URL Rewrite..
Peter Boughton wrote: It's failing because it's expecting http://mysite-test.myhost.net/net/wagon/red/small Finally got it to work: ^([_0-9a-z-]+)(?:/([_0-9a-z-]+)(?:/([_0-9a-z-]+))?)?/?$ Now if I've got my head around this correctly, and the logic flow I've already charted out is correct - I can run the entire site from this one rule, which all gets processed through a sorta-fusebox index page. I've got the above mapped to var1, var2 and var3, all which can have different roles depending on the preceding variable. So, if var1 is Newsletters, then var2 would be a specific date and var3 would be the title My-Great-financial-news or whatever. If var1 is something else, the roles of 2 and 3 change accordlingly. Cool beans. Think I'll take a nap before I start on that task though... Thanks for the advice and replies! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323377 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: mysql and order by datetime
Hey Chad, Out of curiosity, can you share those date/time values with us for the first query? I'd be interested in playing with it to see why it's doing what it's doing. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323378 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Error register asp.net web service in CF 7 admin
Dave, As you said CF does not directly support windows authentication, we learned from our recent research that Apache Axis uses org.apache.axis.transport.http.HTTPSender by default. So we made a configuration change. We changed transport name=http pivot=java:org.apache.axis.transport.http.HTTPSender/transportTo:trans port name=http pivot=java:org.apache.axis.transport.http.CommonsHTTPSender/transport in client-config.wsdd file. We also enabled Integrated Windows authentication in iis. In addition we copied the wsdl file into iis root directory. After all of these changes, we assumed Apache Axis and iis should support windows authentication for our CF application. However we still need to provide username and password when consume the .net webservice. I used the following code and successfully consumed the webservice: cfscript ws = CreateObject(webservice, http:///fileservice.asmx?wsdl;); ws.setUsername(domain\username); ws.setPassword(password); recordNumber=ws.UploadFileBasic(#strTrimURL#,#objBinaryData#, #b64fileName#, #strDocument#); /cfscript But without passing in username and password the code returns an error. I have mentioned early that we have an asp.net client application which successfully consumes the .net webservice. It first gets the current user info: private void GetUserInfo() { System.Security.Principal.WindowsIdentity UserIdentityInfo; string strMsg; UserIdentityInfo = System.Security.Principal.WindowsIdentity.GetCurrent(); strMsg = (User Name: + (UserIdentityInfo.Name + \r\n)); strMsg = (strMsg + ( Token: + (UserIdentityInfo.Token.ToString() + \r\n))); strMsg = (strMsg + ( Authenticated: + (UserIdentityInfo.AuthenticationType + \r\n))); strMsg = (strMsg + ( System: + (UserIdentityInfo.IsSystem + \r\n))); strMsg = (strMsg + ( Guest: + (UserIdentityInfo.IsGuest + \r\n))); strMsg = (strMsg + ( Anonymous: + (UserIdentityInfo.IsAnonymous + \r\n))); //MessageBox.Show(strMsg); txtMultiLine.Text = strMsg.ToString(); } Then set the Credentials when it consumes the webservice: x.Credentials = System.Net.CredentialCache.DefaultCredentials; To narrow down my question, I'm thinking if there is any class in JRun security/or any other package I can setCredentials using current windows userinfo, instead of setUsername and setPassword in plain text? Do I have to set Www-Authenticate value in cfheader? It might be still an environmental issue, but I'm trying to find out as much as I can in CF coding. Thanks, Hong -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, June 10, 2009 12:29 PM To: cf-talk Subject: Re: Error register asp.net web service in CF 7 admin We have successfully registered .net webservice by passing in username and password. However our project requires this webservice be configured as Integrated Windows Authentication. So, the question for us now becomes: How to invoke .net webservice requires Windows Authentication? Well, you can't really, not directly from CF at any rate. Integrated Windows Authentication isn't supported by CF. Windows (or NTLM) Authentication sends a hash of the user's password to the server, instead of the actual password itself as Basic Authentication does. Some people said: only Microsoft products can pass the required protocols for Windows Integrated Security. Is that true? Please share your thoughts. No, there are other products that support NTLM Authentication. Firefox does, for example, although it may require configuration. I would look into using an NTLM proxy. When Googling ntlm proxy I found some possible candidates: http://sourceforge.net/projects/ntlmaps/ http://cntlm.sourceforge.net/ If the administrators of the web service can enable Basic Authentication, that would also solve the problem. If they're aiming for interoperability, they shouldn't require Windows Authentication. Of course, Basic Authentication does send credentials in base64-encoded plaintext, so it should be used in conjunction with SSL/TLS. 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323379 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Find the parent!
Hi, Top javascript gurus heavy with CF8, here's a challenge. In a nut shell, I'd like to be able to find (x,y) coordinates for each spot of 1, 2, 3, 4... (hierarchy level), draw a straight line from its child to it triggered by onMouseOver. Please see the following URL for detail, do you think doable with cf8 and fancy js? If possible, not use Flex etc. http://geocities.com/donli/ Thank you. Don Chunshen Li ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323380 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFfunction within a query output
Jason, Probably that's what Peter meant as well, on second thought, yes, why not? setting the flag is an extra/unnecessary. Thanks. Don Better yet, just define the function outside the loop (top of the template?) and then just call it from inside your loop. Peter, awesome, as you correctly pointed it out, the complex data type was the culprit, problem resolved. Also, good catch on the function inside the loop, I've set up a flag to ensure it runs only once, so, that's ok; also initially thought the cf8 engine would run it only once but that could be totally wrong for expecting too much from cf8... Many thanks. Don ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323381 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error register asp.net web service in CF 7 admin
As you said CF does not directly support windows authentication, we learned from our recent research that Apache Axis uses org.apache.axis.transport.http.HTTPSender by default. So we made a configuration change. We changed transport name=http pivot=java:org.apache.axis.transport.http.HTTPSender/transportTo:trans port name=http pivot=java:org.apache.axis.transport.http.CommonsHTTPSender/transport in client-config.wsdd file. We also enabled Integrated Windows authentication in iis. In addition we copied the wsdl file into iis root directory. After all of these changes, we assumed Apache Axis and iis should support windows authentication for our CF application. That's good to know; I didn't know you could do that. However we still need to provide username and password when consume the .net webservice. I used the following code and successfully consumed the webservice: cfscript ws = CreateObject(webservice, http:///fileservice.asmx?wsdl;); ws.setUsername(domain\username); ws.setPassword(password); ... But without passing in username and password the code returns an error. I have mentioned early that we have an asp.net client application which successfully consumes the .net webservice. It first gets the current user info... To narrow down my question, I'm thinking if there is any class in JRun security/or any other package I can setCredentials using current windows userinfo, instead of setUsername and setPassword in plain text? Do I have to set Www-Authenticate value in cfheader? Well, CF doesn't really know anything about the user other than what it receives from IIS. Unlike ASP.NET, which runs in-process with IIS, CF is a separate process which runs in a separate security context. That said, if the user has provided his or her credentials to IIS, the username at least will be available as a CGI variable. So you might just dump the CGI scope and see what you have, and insert those values in your setUsername and setPassword calls. 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 inf ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323382 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Full time Coldfusion developer needed (telecommute)
Sitezoogle creates website building tools for niche markets. Thousands of people around the world use our software every day. They are a diverse group, from artists to small businesses to nonprofits. The common thread is that they donât want the expense of hiring a designer and need higher quality results than what generic website builders provide. We Are Looking For: * A Coldfusion developer with 3+ years experience. * Strong Linux/Apache/MySQL skills (please do not apply unless you have these!) * Able to work and communicate effectively in a virtual office. * Bonus points for strong CSS and jQuery skills. Why Work With Us? * We decided to charge people money for an application they love to pieces. It worked! Weâve been profitable since 2004 and are growing fast, even in this economy. * We are a small team, so you will play a key role. * Youâll get to play with the latest web tech (Amazon S3/EC2, jQuery, Ruby) * We work in a virtual officeâyou can live where you love to be and set your own hours. * $60k-$80k salary, based on experience. To apply Send an email with the subject of Web Developer to j...@sitezoogle.com. Please include your resume, and let us know why your skills would fit well within Sitezoogle. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4245 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11