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 strongm 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: *

  • Users: PaulHInstincticve
  • Order by date
  1. PaulHInstincticve

    Parameterised Update Problem

    No not at all. I think I must have misinterpretted what you were saying earlier. I think this is the way to go here if empty paramters cannot be handled by the system. Its not as elegant as it might be otherwise but I have come to understand about ASP that it is the simplest of things that take...
  2. PaulHInstincticve

    Parameterised Update Problem

    Thanks for that. Yes it did occur to me. Unfortunately, however, although at this point there are only 3 large variable length fields that could go over 255 characters each being written to the database, 1 of those fields contains the concatenated values from 2 other large fields and I have...
  3. PaulHInstincticve

    Parameterised Update Problem

    I am using a parameterised update command instead of an SQL command because I have long character fields captured in a form that I need to store to Visual FoxPro variable length memo fields that can exceed 255 characters which in turn will break the SQL command. This has been working fine if I...
  4. PaulHInstincticve

    CDOSYS Emails Working To All Domains Except My Own

    Thanks for that Paul, I have passed this on to the web designer in charge of the hosting. Hopefully he can have a look at this and perhaps post a reply in here detailing what has and has not been done at that end to help narrow things down. Paul
  5. PaulHInstincticve

    Adding a Vcalendar Link For Outlook Appointments To A Web Page

    I want to add a button to my web page so that when a visitor clicks it it will automatically add an appointment in Microsoft Outlook. I see that I can do this by creating a vcalendar text file similar to the one below and simply hyperlinking it so that when the visit clicks and chooses 'Open' to...
  6. PaulHInstincticve

    CDOSYS Emails Working To All Domains Except My Own

    Hi, we have been running a Windows server for some time and sending email via CDOSYS quite happily from our ASP application with copies going to customers and copies coming to ourselves. This used to work fine but for some reason recently the copies to ourselves, ie to mailboxes at the same...
  7. PaulHInstincticve

    Intermittent Error The connection cannot be used to perform this opera

    Yes knew what you meant first time and agree entirely! Exactly how I work on the desktop app! Paul
  8. PaulHInstincticve

    Intermittent Error The connection cannot be used to perform this opera

    Sheco, Thanks that's good advice. I do similar loops and dumps of databases, variables, objects etc in my desktop app. Something similar needs to be done with the on-line app if only it weren't so much more complicated! Will implement those ideas. Thanks Paul
  9. PaulHInstincticve

    Intermittent Error The connection cannot be used to perform this opera

    Talk about using a sledghammer to crack a nut!. How can a company like Microsoft produce such good software and then design something as complicated as messy to use as IIS and ASP - oh, I remember, they buy up the companies that produce the easy to use stuff then brand it as their own! Might see...
  10. PaulHInstincticve

    Intermittent Error The connection cannot be used to perform this opera

    Don't suppose there is a chance of some sample code that access the objects that can get me started. It was really frustrating last time I looked into this that noone could supply sample code referencing a line number, only a script, I was told it was a limitation of ASP which having had such...
  11. PaulHInstincticve

    Intermittent Error The connection cannot be used to perform this opera

    Thanks Sheco. I was, however, directed to using on error resume next for my error handler and then to check the error number at key points and activate my error page followed by a response.end when a find a value other than 0. That is all very well in ASP because it stops the system crashing...
  12. PaulHInstincticve

    Intermittent Error The connection cannot be used to perform this opera

    I am receiving the following error intermittently from my application The connection cannot be used to perform this operation. It is either closed or invalid in this context I cannot replicate this. I have an error handler running (to email me details of any errors that occur in a user...
  13. PaulHInstincticve

    Occasional Missing CDONTS Emails

    Sheco, Thanks for that. Will look into CDO (I assume there is a line for line simple replacement for the above CDONTS code?). Regarding \mailroot\badmail etc, is that something we would have access to on a shared server with someone like Fasthosts or would we need to contact the ISP to look at...
  14. PaulHInstincticve

    Occasional Missing CDONTS Emails

    Nick, Thanks for that, what an obvious idea! Had not realised the basic CDONTS email system was quite so advanced ;-) Shame the ISP could not be as helpful! Will make the change immediately and hopefully this should do the trick. Still baffled why its just this one account though and its only...
  15. PaulHInstincticve

    Occasional Missing CDONTS Emails

    I have a script which generates emails from a web page during an ordering process. The script is part of a function where parameters such as the from address, to address, subject and message body are passed to the function to generate the CDONTS email. I have about 12 customers using this...
  16. PaulHInstincticve

    WhatsThis CHM File Problem

    Mike, Yes, 4 miles overland to the start of the Pennine Way (about 11 miles by road!). Did the walk in reverse a year this March having done it the other way about 20 years back, remember the really cold spell for about 3 weeks? We spent 13 days in sub zero temperatures backpacking the 260 or...
  17. PaulHInstincticve

    WhatsThis CHM File Problem

    Olaf, Yes the network issue was some time back. At the start of my app now I always check sys(5) to see if its running on C:. If it is then I just open my help file in the current directory. If its not I look for a directory on the c: drive called c:\myapp. If its there I look for the presence...
  18. PaulHInstincticve

    WhatsThis CHM File Problem

    Mike, At last - a time for me to help you rather than you help me!!! Yes I am using Help and Manual 4.2. I remember struggling with this at first and contacted the people who write it and they could not really help me suggesting that this was really something specific to VFP rather than Help...
  19. PaulHInstincticve

    WhatsThis CHM File Problem

    Mike, Thanks for coming back. Sorry that I must have solved this whilst you were still responding, a flash of inspiration must have come over me. Regarding Whatsthis and CHM files not working well, not really sure why you say that. I am using Help and Manual to compile my help files following...
  20. PaulHInstincticve

    WhatsThis CHM File Problem

    Don't worry, I think I have sorted the problem myself. It appears that I need to ask Installshield Express to install the VFP Help Runtime files for me. Even though I have never installed these before, there must have been sufficient runtimes already installed in the operating systems for the...

Part and Inventory Search

Back
Top