Two problems with that - #1, we use SQL 2000, not SQL 2005 or 2008 (doesn't seem like they offer a version of that library for SQL 2000, from what I can tell). Second, it still requires user interaction... It's basically a custom print-dialog box -- any print-dialog box is a bad thing for us. Zero user interaction is what we're going for here... Click the button in the Flex app, and it pops out on the correct printer automatically -- that's what we need.
But thanks for trying. :-) L. On Sat, Sep 4, 2010 at 6:08 PM, Eric DeCoff <ericdec...@gmail.com> wrote: > Laurence, > > Here a link to SQL server client side printing > > http://msdn.microsoft.com/en-us/library/ms155874(SQL.90).aspx > > sent via droid > > On Sep 4, 2010 6:00 PM, "Laurence MacNeill" <laurence5...@gmail.com> > wrote: > > You mean from the MSSQL database? I'm unfamiliar with the reporting > > features from there, but it would seem to me to be the same situation as > PHP > > and CF -- I need control of a client computer's printer(s). A server-side > > solution isn't going to work. And I seriously doubt that the MSSQL > > reporting features will help us with badge-printing. Reports, possibly, > but > > not badges. > > > > L. > > > > > > > > On Sat, Sep 4, 2010 at 5:53 PM, Eric DeCoff <ericdec...@gmail.com> > wrote: > > > >> Laurence, > >> > >> Have you concidered using Microsoft reporting features? > >> > >> sent via droid > >> > >> On Sep 4, 2010 5:10 PM, "Laurence MacNeill" <laurence5...@gmail.com> > >> wrote: > >> > Thanks for the info, Eric... > >> > > >> > Unfortunately that solution still appears to require user-interaction > of > >> > some sort... You can't just hit Print and have it go to the printer > that > >> > you want it to go to. Unless, of course, the printer is shared on the > >> > network and available to the server -- so it's the same situation I'm > in > >> > with PHP sharedPrinter or CF getPrinterInfo... Even if I create the > PDF > >> > file and save it to the user's computer (and that requires them > clicking > >> on > >> > a "save" button) it's still not going to automate the decision as to > >> which > >> > printer the file goes to... > >> > > >> > Having said that -- if it were possible to save the file without > >> > user-interaction, it might work for us to have a process running in > the > >> > background that looks for PDF files in a given directory, then > >> automatically > >> > prints them when they appear there. That'd work for all our company's > >> > computers, but not the client's computers unless they were willing to > >> > install and run such an applet... > >> > > >> > The more I look, the more it looks like AIR is the only option... :-( > >> > > >> > L. > >> > > >> > On Sat, Sep 4, 2010 at 8:25 AM, Eric DeCoff <ericdec...@gmail.com> > >> wrote: > >> > > >> >> Laurence, > >> >> > >> >> This is part three that lets you hide the header... > >> >> > >> >> > >> >> > >> > http://www.kalengibbons.com/blog/index.php/2009/04/custom-printing-with-flex-part-3-printing-data/ > >> >> > >> >> *source code* also available > >> >> > >> >> > >> >> > >> >> > >> >> On Sat, Sep 4, 2010 at 7:05 AM, Eric DeCoff <ericdec...@gmail.com> > >> wrote: > >> >> > >> >>> Laurence, > >> >>> > >> >>> Back Home.... > >> >>> > >> >>> Check out AlivePDF... > >> >>> > >> >>> > >> >>> > >> > http://www.kalengibbons.com/blog/index.php/2009/03/custom-printing-with-flex-part-2-generating-pdfs-with-alivepdf/ > >> >>> > >> >>> Give you an example to play with and *source code* > >> >>> ** > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> On Thu, Sep 2, 2010 at 4:18 PM, Laurence MacNeill < > >> laurence5...@gmail.com > >> >>> > wrote: > >> >>> > >> >>>> Yeah, looks like PHP and CF now offer pretty much the same setup, > it > >> >>>> seems. Looks like the printer(s) have to be shared on the network, > >> thus > >> >>>> allowing the server to know about them. Fine for the shows when > we're > >> using > >> >>>> a local server; not good when the server is our web-hosting server. > >> >>>> > >> >>>> I'm guessing it's just gonna have to be AIR for us... Nothing else > >> seems > >> >>>> to be panning out... > >> >>>> > >> >>>> L. > >> >>>> > >> >>>> > >> >>>> > >> >>>> On Thu, Sep 2, 2010 at 4:10 PM, Douglas Knudsen < > >> >>>> douglasknud...@gmail.com> wrote: > >> >>>> > >> >>>>> Air 2.0 has the whole native process thing, so guess this is > possible > >> if > >> >>>>> you have a shell script or something that can do this. I have not > >> looked at > >> >>>>> the PHP thing, but CF has access to printers via the server as of > >> CF8. See > >> >>>>> CFPRINT and getPrinterInfo() for example. I've never used this, > but > >> >>>>> personally I would look at this if in a corporate "behind the > >> firewall" > >> >>>>> setup. In these cases the printers are all networked and under AD > >> >>>>> permissions or some such, standardized basically. Just my $0.02. > If > >> you > >> >>>>> are thinking of printing from Flash, give up now, it sucks, as in > >> really > >> >>>>> really sucks :) > >> >>>>> > >> >>>>> Its easy-peasy to setup autoupdating AIR apps that present the > user > >> with > >> >>>>> a dialog if the application has a new version out. > >> >>>>> > >> >>>>> Douglas Knudsen > >> >>>>> http://www.cubicleman.com > >> >>>>> this is my signature, like it? > >> >>>>> > >> >>>>> > >> >>>>> > >> >>>>> On Thu, Sep 2, 2010 at 12:05 PM, Laurence MacNeill < > >> >>>>> laurence5...@gmail.com> wrote: > >> >>>>> > >> >>>>>> Yeah, I don't care for the version-control stuff, if we wind up > >> doing > >> >>>>>> this with AIR... But the people who are going to access this > program > >> are > >> >>>>>> pretty much in-house only, so hopefully it won't be too > terrible... > >> The > >> >>>>>> only people outside of our company who will access this app are > the > >> IT staff > >> >>>>>> from our client companies, so they should be smart enough to > realize > >> what's > >> >>>>>> going on, I would hope. > >> >>>>>> > >> >>>>>> I found an article that talks about integrating version-control > into > >> an > >> >>>>>> AIR app, and using our CF server to send the new app > automatically > >> when an > >> >>>>>> older app tries to log in. So hopefully we can do that, if we do > >> need to go > >> >>>>>> to AIR... It does seem like we can automate the entire process, > >> which is > >> >>>>>> what we'd need of course. > >> >>>>>> > >> >>>>>> > >> > http://www.adobe.com/devnet/coldfusion/articles/managing_air_updates_with_coldfusion.html > >> >>>>>> > >> >>>>>> The PHP sharedPrinter thing -- I'm not sure, yet, if that's going > to > >> be > >> >>>>>> an option or not... It would mean installing PHP on our servers, > and > >> I have > >> >>>>>> no clue about anything related to PHP... It *seems* like it might > be > >> an > >> >>>>>> option, but I don't really know enough about PHP to know for sure > >> yet... > >> >>>>>> (Can PHP determine what printer(s) is/are connected to the > client's > >> computer > >> >>>>>> -- it appears that it can? Can it send a print-job to a specific > >> printer on > >> >>>>>> that computer without popping up a dialogue box? If so, how do I > set > >> up and > >> >>>>>> control that print-job? How do I get my Flex app to send a print > job > >> >>>>>> *through* the PHP server to the client's printer? These are the > >> questions I > >> >>>>>> need to answer before I can know if it will work for us.) > >> >>>>>> > >> >>>>>> Frankly, I don't yet know enough about AIR to even be absolutely > >> >>>>>> certain that will work for us -- again, it *seems* like it could > >> work, but I > >> >>>>>> guess I'll just have to play with it to know for sure. I'm still > >> pretty > >> >>>>>> much open to any and all suggestions here, if anyone can think of > >> >>>>>> anything... > >> >>>>>> > >> >>>>>> L. > >> >>>>>> > >> >>>>>> > >> >>>>>> On Thu, Sep 2, 2010 at 4:58 AM, Eric DeCoff < > ericdec...@gmail.com > >> >wrote: > >> >>>>>> > >> >>>>>>> Air is definitely an option but version control becomes an issue > >> PHP > >> >>>>>>> has the same drawback.. is the sharedprinter option viable for > >> you... > >> >>>>>>> > >> >>>>>>> sent via droid > >> >>>>>>> > >> >>>>>>> On Sep 1, 2010 9:11 PM, "Laurence MacNeill" < > >> laurence5...@gmail.com> > >> >>>>>>> wrote: > >> >>>>>>> > AIR 2.0 is still so new that the info is still confusing... > I'm > >> not > >> >>>>>>> 100% > >> >>>>>>> > certain, myself, but it does look like a good possibility. > >> >>>>>>> > > >> >>>>>>> > On Sep 1, 2010 9:08 PM, "Cameron Childress" < > camer...@gmail.com> > >> >>>>>>> wrote: > >> >>>>>>> >> On Wed, Sep 1, 2010 at 9:04 PM, Laurence MacNeill > >> >>>>>>> >> <laurence5...@gmail.com> wrote: > >> >>>>>>> >>> From what I've read, it does appear that AIR 2.0 will do it. > >> There > >> >>>>>>> are > >> >>>>>>> >>> methods on PrintJob that will return a list of the client's > >> >>>>>>> printers, and > >> >>>>>>> >>> let you select one to send the job to, and skip all dialog > >> boxes. > >> >>>>>>> So AIR > >> >>>>>>> >>> might actually be an option. > >> >>>>>>> >> > >> >>>>>>> >> Guess I should pay better attention - Google tells me you > might > >> be > >> >>>>>>> >> right! Will have to check this out... > >> >>>>>>> >> > >> >>>>>>> >> -Cameron > >> >>>>>>> >> > >> >>>>>>> >> -- > >> >>>>>>> >> Cameron Childress > >> >>>>>>> >> Sumo Consulting Inc > >> >>>>>>> >> http://www.sumoc.com > >> >>>>>>> >> --- > >> >>>>>>> >> cell: 678.637.5072 > >> >>>>>>> >> aim: cameroncf > >> >>>>>>> >> email: camer...@gmail.com > >> >>>>>>> >> > >> >>>>>>> >> > >> >>>>>>> >> ------------------------------------------------------------- > >> >>>>>>> >> To unsubscribe from this list, simply email the list with > >> >>>>>>> unsubscribe in > >> >>>>>>> > the subject line > >> >>>>>>> >> > >> >>>>>>> >> For more info, see http://www.affug.com > >> >>>>>>> >> Archive @ > http://www.mail-archive.com/discussion%40affug.com/ > >> >>>>>>> >> List hosted by http://www.fusionlink.com > >> >>>>>>> >> ------------------------------------------------------------- > >> >>>>>>> >> > >> >>>>>>> >> > >> >>>>>>> > >> >>>>>> > >> >>>>>> > >> >>>>> > >> >>>> > >> >>> > >> >>> > >> >>> -- > >> >>> Eric R. DeCoff > >> >>> Changing the world, > >> >>> 1 line of code at a time > >> >>> > >> >> > >> >> > >> >> > >> >> -- > >> >> Eric R. DeCoff > >> >> Changing the world, > >> >> 1 line of code at a time > >> >> > >> >