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!

Register Log in
  • Congratulations Chriss Miller 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: Neilf
  • Order by date
  1. Neilf

    EXEC and return values

    I've a large dynamic sql statement built in asp. I need to return an error (or anything) from within the exec sql statement. I've tried as shown below but return does not work within the string, and @@ERROR outside the exec statement reports no errors. I've been looking at the forum and the...
  2. Neilf

    return from sql without sp

    Thanks i'll check it out!
  3. Neilf

    Mailto - length restrictions?

    Ok Thanks - I normally do use cdonts but the user wants to use Outlook. They're happy to paste the addresses from a textfield so all is fine, if a bit messy.
  4. Neilf

    Mailto - length restrictions?

    I think the restriction is the string length - i guess the same restrictions that apply to using 'get' to processing a form.
  5. Neilf

    return from sql without sp

    Thanks for that - i was thinking along those lines - its going to be messy though as my sql string can be of infinite length (well i guess i can put some restriction on it - its for a dynamic survey result insert, the surveys can be a bit lengthy - the string i just tested was almost 22000...
  6. Neilf

    return from sql without sp

    What can be returned from a sql execute command without a sp? I want to report an error if it occurs - ie if the transaction is rolled back. I've only had any success with the RecordsAffected property on the Execute method. My sql statement consists of multiple inserts, this only seems to...
  7. Neilf

    Acess Import Specification to SQL Server DTS

    Thanks for the advice - i've just found the dts tables in sql and i think you're right i can't see anything which looks the same as the access spec data but i'll keep trying. The reason i want to copy the specs is that they are for many undelimited text files with about 100 columns in each, so...
  8. Neilf

    Acess Import Specification to SQL Server DTS

    I need to copy a large access db to SQL Server 2000 & want to copy the access import specs to SQL DTS packages. The spec data in access is held in the hidden system tables MSysIMEXColumns and MSysIMEXSpecs - is this data held in a similar manor in SQL Server? I'm guessing it must be somewhere...
  9. Neilf

    Mailto - length restrictions?

    I need to mail up to 700 email addresses (using a dynamic string from a recordset to get the addresses). If I use the mailto command nothing happens, as if the hyperlink goes nowhere. If I paste the string created into outlook it works fine & if i cut the string down to only contain a few...
  10. Neilf

    Integrated Security

    MS article Q176377 suggests that integrated security can be used with SQL server 2000 if using kerberos security on 2000 server and that the workarounds described in that article & Q247931 do not apply. Should need to follow steps in this doc to get it to work...
  11. Neilf

    trap page cannot be displayed?

    Sorted this out using javascript to open another page on the server in a new hidden window and then checking something in it (e.g title) to make sure it has loaded OK (use setInterval or setTimeout to give it time to load). If OK then submit the form. :-)
  12. Neilf

    trap page cannot be displayed?

    I'm fairly sure this isn't possible but pls. let me know if i'm wrong! I need to trap the 'page cannot be displayed' error when a user submits a form (the users are working offline - when they submit it should reconnect and reload the same page - it doesn't if there's a problem with the line)...
  13. Neilf

    position / center object on screen

    Anyone know if there is any way of centering a form object on the screen when it gets focus? Some of our intranet users are new to windows and aren't too hot with scrollbars - i have a huge form for them to complete and anticipate problems! Thanks in advance.
  14. Neilf

    Access 97 Connection error

    I have now - still no difference, i'm going to have a play around moving everything to my local machine to try & eliminate any security issues. Failing that, the only reason its in Access is because it was originally a stand alone app., I'd like to migrate the whole backend to SQLServer!
  15. Neilf

    Access 97 Connection error

    Thanks G & Paul, unfortunately I don't think its that simple. All recordsets are closed at the end of each page (well 1 wasn't but I've changed that now & the error still occurs). I've checked and can't see the .ldb remaining. I've been looking on Microsoft's support pages & I think the...
  16. Neilf

    Access 97 Connection error

    Can anybody help with this error which is occurring intermitently when I connect to an Access97 db. Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xa70 Thread...
  17. Neilf

    Posting asp form

    This problem affects 1 of 3 iis servers i've tested, I don't know much about iis, can anyone help: If I set integrated auth (iis5) for an asp page and then try to use the 'post' method to send data from it (and from any subsequent anonymous pages), the data is not passed. I have no problem if...
  18. Neilf

    NT Authentication & post form method

    Tried this on another iis server and don't have any problem so this is in the wrong forum! If anyone does know why this is happening please let me know though.
  19. Neilf

    NT Authentication & post form method

    If i set the security of an asp page to nt challenge/response (IIS5), I cannot send info from a form on that page (& subsequent pages) using the 'post' method. It works fine with 'get' but thats no good to me in this instance. If i set the security back to anonymous i have no problem. Hope...
  20. Neilf

    SQL Statements - Replace function

    Just wondered if anybody knew why Ultradev changes your SQL statement by generating a replace function for a variable when creating a recordset, e.g: WHERE (tblLkpAreaManager.RegionID LIKE '" + Replace(rsList__varRegion, "'", "''") + "') It doesn't cause any...
    • Neilf
    • Thread
    • Replies: 1
    • Forum: Adobe

Part and Inventory Search

Back
Top