Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gasparrelli

    Scheduling an HTTPS page to automate mail with CF Admin tool

    I am trying to use the CF scheduler to send daily email based on a standard query, nothing special. This is something I have done many times before, even using the same mail server I am using now. The problem now however is that I only have access to https pathed pages, no plain http folders...
  2. gasparrelli

    Really dumb question!

    Thanks, that helps!
  3. gasparrelli

    Really dumb question!

    Let me preface this by saying I am a database developer and completely new to web development (I've got the hang of CF as a language now but not pinned down web concepts in general)... Having said that, I've noticed a number of sites with paths as url strings but no page names appearing at...
  4. gasparrelli

    Another strange session var problem

    I'm having a "new" problem with my application now that it's rolled into production, one we didn't (couldn't) catch in development and testing. Let me explain: The first time a user comes to our website we immediately convert an url string variable into a session variable, query...
  5. gasparrelli

    Oracle result sets from SP

    Iza, that's the first thing I was looking at too, but the part I can't figure out is that I think I need a cfprocparam OUT but can't figure out the datatype. Maybe I'm wrong on that though. Maybe it's just the strange nature of the de-encryption SP that's hanging me up. I did however find a...
  6. gasparrelli

    Oracle result sets from SP

    Thanks so much for helping - can I possibly get a little more detail from you? If I have a multi row recordset returned from Oracle what datatype do I give it as the out param? What type if object is returned for me to loop through? An array, or do I somehow reference the returned rows as a...
  7. gasparrelli

    Oracle result sets from SP

    I need to have CF display the results of an Oracle stored proc which selects multiple rows from an Oracle table. Right now I have an Oracle SP which returns results by using a ref cursor. I'm not sure however how to have CF loop through the result set. Do I use CFStoredProc and some other...
  8. gasparrelli

    Help With Date Trouble!!!

    Thanks all - but this was in fact verified as a bug by the folks at Allaire. 4.5.1 Enterprise has a date problem using CFstoredProc which is fixed by SP2 (we downloaded the beta) In our case it was specific to the Oracle native driver but it may be out there in other forms as well with 4.5.1...
  9. gasparrelli

    Session maintenance

    I understand that session variables cannot be passed from non-SSL to SSL pages, so you must pass all your variables from the "old" session into the "new" one. I haven't done this yet but am adding SSL to my site so have researched it, but can't advise beyond that... :)
  10. gasparrelli

    AOL/Browser help

    Thanks bankholdup. That's a terrific idea, I'm going to give that a try! I have also found a custom tag at Allaire's website called cf_browser which can return the browser type and version, but for some reason I don't think I've installed the tag in the right place or I'm calling it wrong...
  11. gasparrelli

    AOL/Browser help

    We are having some trouble with certain browsers not handling the CF-generated JavaScript (or any JS for that matter) How do we determine which browsers support this and keep users of those browsers from continuing? AOL seems particularly troublesome for us. I have seen that I can catch the...
  12. gasparrelli

    Session maintenance

    Use CF lock when you are creating the variables? I have never used it. There's nothing on the client side then?
  13. gasparrelli

    Session maintenance

    I am thoroughly confused on how CF maintains a session and could use a little insight... let me explain: I have an application which relies heacily on session variables. I create no cookies and do not programatically pass cfid or cftoken between pages (or any other session variables). Yet...
  14. gasparrelli

    Help With Date Trouble!!!

    Thanks for the suggestion - that's one of the things I looked into and that doesn't seem to have an effect. I have opened a trouble ticket with Allaire and they are telling me so far to rewrite all my sp's with to_date and change all my cfprocparams from cfsqltype DATE to cfsqltype VARCHAR...
  15. gasparrelli

    Help With Date Trouble!!!

    We are using cfstoredproc to insert and update records in our Oracle database. We accept dates through our user interface as mm/dd/yyyy and these are jscript validated. Trouble is that one of our CF servers using the oracle native 8.0 driver is having trouble sending "correct" dates...
  16. gasparrelli

    Oracle and CF debugging

    Thanks so much for your reply, that is a good idea. I am still a little concerned about how the datatypes and dbvarnames and such get passed, so it would still be nice to see truly what the whole statement is that gets created by cfstoredproc and cfprocparam. I am considering abandoning...
  17. gasparrelli

    Oracle and CF debugging

    I am having trouble debugging Stored Proc calls to Oracle from CF using CFStoredProc/ProcParam. Oracle traces will tell me which sp's get called and with which parameter names, but not the actual values being sent by CF. And CF will only give me query output, not SP output using its built in...
  18. gasparrelli

    Query problem

    MAatt, you could try creating a variable before your loop starts, changing that variable when the loop finds your matching record, and setting the loop to only run as long as the variable is the original value. In other words, have your loop look at the variable and exit the loop when the...
  19. gasparrelli

    New and Confused - CFID/CFTOKEN Visible

    Yes, I have been using cflocation after the logic in my action pages. I will try addtoken "NO". Thanks so much for replying to my post!
  20. gasparrelli

    New and Confused - CFID/CFTOKEN Visible

    I'm new to CF and finding myself confused - is there any way to use session variables without having the CFID and CFTOKEN show in the nav bar? I can count on the user having cookies enabled in this particular project by the way, but rely heavily on session variables to store user id's for table...

Part and Inventory Search

Back
Top