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: BradF
  • Order by date
  1. BradF

    C++ ISAPI Filter Code

    I know very little about C++ but I'm trying to tackle something for work and need some help... I'm using this C++ ISAPI filter code to add a message to the top of a page on a IIS web server running ASP and CFML. This is a web server that will be going away and need a way to notify the users...
  2. BradF

    Javascript Advanced Functionality...

    I'm looking at creating a site that allows you to drag/drop pictures, text-boxes, and certain stylized elements onto a template. It should contain the ability to edit the text in the boxes, as well as re-size the elements. There is a site that does basically the same thing using flash, but I'd...
  3. BradF

    Bulk Import w/Format File and Text Fields - Why is it not working?

    Here's what my data looks like: "12312331 ","DOE, JOHN","3423423",0,1900-01-01 00:00:00,"","@@ ","","JOHN DOE PROCESSING PLANT" Here's my format file: 7.0 10 1 SQLCHAR 0 0 "\"" 0 "" 2 SQLCHAR 0 250 "\",\"" 1...
  4. BradF

    Converting DATETIME to SMALLDATETIME...

    I'm needing help writing a query that will convert a DATETIME value into a SMALLDATETIME value and drop any DATETIME values that would cause a SMALLDATETIME overflow error (use NULL instead). Something like this maybe? UPDATE TABLE SET THISDATE = CASE WHEN THISDATE) >= 1/1/1900 OR...
  5. BradF

    TRAN issue...

    Nothing has helped so far. Everything seems to be okay with the defragmentation and statistics. This proc is very simple. It simply truncates two tables and reloads summary data into them. As I said, everything works fine and fast except when I surround the query inside the SPROC with a...
  6. BradF

    TRAN issue...

    Could it be related to the LOG files?
  7. BradF

    TRAN issue...

    Crowley, thanks for the helpful response. The SPROC had been running fine for the past year and just recently started having problems. I've looked over the indexes and they seem to be okay. It does appear to be a deadlock as you said. I had noticed some of the indexes on one of the tables...
  8. BradF

    TRAN issue...

    If I do the following, the SPROC runs fine: --BEGIN TRAN --commented out blah blah blah IF @@ERROR <> 0 BEGIN --ROLLBACK TRAIN --commented out RETURN 1 END --COMMIT TRAN --commented out
  9. BradF

    TRAN issue...

    Dennis -- I did not put in the full code because I assumed those responding would assume I knew what I was doing... IF @@error <> 0 BEGIN ROLLBACK TRAN RETURN 1 END Is the exact block of code for that section. Thanks for your concern over my methods however that's not my...
  10. BradF

    TRAN issue...

    I have a SP that will not work when I have the queries in it surrounded by... BEGIN TRAN blah - blah - blah IF @ERROR ROLLBACK TRAN COMMIT TRAN The proc seems to run indefinitely and there are tons of locks on the database it's using. If I remove all the TRAN lines (comment them out) the...
  11. BradF

    UPDATE OPENDATASOURCE Issue...

    George: Unfortunately, I'm unable to setup a true linked server and the databases aren't on the same server. I knew this was going to be a fiasco!
  12. BradF

    UPDATE OPENDATASOURCE Issue...

    I still can't get this to work. Is there another way to do it that may be easier?
  13. BradF

    UPDATE OPENDATASOURCE Issue...

    George, that gave me: Invalid object name 'b'. I don't think updating via aliases works on SQL Server 2000.
  14. BradF

    UPDATE OPENDATASOURCE Issue...

    Here's an example dataset returned from the select portion of the query after a run: 39 39 0 0 0 1 2007-12-12 14:40:17.910 2007-12-12 14:40:18.393 40 40 0 0 0 0 2007-12-12 14:40:17.910 2007-12-12 14:40:18.393 41 41 0 0 0 0 2007-12-12 14:40:17.910 2007-12-12 14:40:18.393 42 42 0 0 0 0 2007-12-12...
  15. BradF

    UPDATE OPENDATASOURCE Issue...

    Can someone please tell me why this doesn't work? *'s replace actual secured values. UPDATE OPENDATASOURCE('SQLOLEDB','Data Source=*.*.*.*;User ID=*;Password=*').*.dbo.* SET ExceptionRanked = a.XCP_RNK_IR, SelectionFlg = a.SLE_IR, EUDLoadDt = GETDATE() FROM TADMSMT a INNER JOIN...
  16. BradF

    ListFind &amp; Find Not Working

    Fixed by doing the following: ListFind(VARIABLES.lstTraining, RTRIM(qryTraining.TNG_SYS_NR)) Even though the output of qryTraining.TNG_SYS_NR didn't show it (because of the whitespace ignore of HTML) it was a CHAR(6) value.
  17. BradF

    ListFind &amp; Find Not Working

    Well, I thought that would work... Apparently not... Here's the code/output: Code:#VARIABLES.lstTraining# - #qryTraining.TNG_SYS_NR# - #ListFind(VARIABLES.lstTraining, qryTraining.TNG_SYS_NR)# - #Find(qryTraining.TNG_SYS_NR,VARIABLES.lstTraining)#<br/>...
  18. BradF

    ListFind &amp; Find Not Working

    Here's the cfoutput, notice how the last two are always 0 yet they should be returning non-0 values: #VARIABLES.lstTraining# - #qryTraining.TNG_SYS_NR# - #ListFind(VARIABLES.lstTraining, qryTraining.TNG_SYS_NR)# - #Find(qryTraining.TNG_SYS_NR,VARIABLES.lstTraining)#<br/> Here's the output...
    • BradF
    • Thread
    • Replies: 3
    • Forum: Adobe
  19. BradF

    SP accessing MS Access Database w/o DTS

    That's going to take a lot of red tape... It'd be nice if I could fine a stored procedure that could either pull the file in to a temporary directory on the server before running the openrowset or run the openrowset across the ftp connection.
  20. BradF

    SP accessing MS Access Database w/o DTS

    I'm familiar with OPENROWSET to access other database types. I use it frequently for Oracle pulls. However, this access database isn't on my SQL Server machine, it's going to be on an remote FTP server.

Part and Inventory Search

Back
Top