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

    begin/rollback transaction help

    ok...............I was using the code below, would that do the trick now then as i am checking for an error after each statement (bar the use crmwht statements but I'm not bothered about those really)? so any error with any of the bulk inserts or truncate/indexes will neither insert take place...
  2. Richey

    some advice re. configuration for new website

    Hi I'm new to IIS - we have version 6.0 a new 3rd party software package has been loaded on - a new website created under web sites, called customertest. today the application seemed to hang, and i did a iisreset /restart and it worked ok then ! it seemed to be talking about lack of memory - I...
  3. Richey

    begin/rollback transaction help

    thanks i get an error now - I know there is an error within the 2nd bulk insert, but using query analyser i get The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. Server: Msg 50000, Level 16, State 1, Line 6 Error in inserting llpg data................. The ROLLBACK...
  4. Richey

    begin/rollback transaction help

    hi i've got a piece of code below which works fine, i've since added in lines to try and catch any errors, using begin transaction, rollback etc. There are 2 bulk inserts which take place, if either one fails I want to rollback completely, i.e. don't truncate the table, don't drop/re-create...
  5. Richey

    multiple inner joins

    i have the following sql statement which I'd like to add another inner join to. I have a table called cts_enquiry_services which has two columns I'm interested in, EnquiryTypeID and ServiceID. ServiceID links back to the ServiceID in cts_services, so i want to add an inner join for...
  6. Richey

    IDENTITY_INSERT is set to OFF

    that is exactly what i am thinking......... let me guess, they can do it for us at a cost !!
  7. Richey

    IDENTITY_INSERT is set to OFF

    Hi I'm using a 3rd party software package and doing an insert with 2 columns (neither are identity columns but just numeric) the identity column is columnID (primary key int(4)) the insert statement is ExecQuery_X "CONN_Z","00010::insert into tblComplaint_ISB (crmCallID,CustomerID) Values...
  8. Richey

    add in further checkbox check in javascript

    thank you everyone - works a treat Rekcor - I have given your earlier post a star also because once i rewrite them completely i will take that into account thanks again
  9. Richey

    add in further checkbox check in javascript

    thanks rekcor I'll take note of that for the future, problem is I've inherited this 3rd party software product and I don't want to (and haven't the time) at this early stage to re-write the whole thing, so that code is their's - I just can't seem to add validation for my custom fields...
  10. Richey

    add in further checkbox check in javascript

    sorry ! <script language=JavaScript> function validateEnquiry() { if (document.frmEnquiry.selService.value == '-1') { alert('Please select a Service'); document.frmEnquiry.selService.focus(); return false; } if (document.frmEnquiry.selRFC.value == '-1') { alert('Please...
  11. Richey

    add in further checkbox check in javascript

    Hi I have an existing form which I need to mofidy - I have 2 new checkboxes which i want to validate for if they are both checked = false I have tried fitting in this check within the existing validation below but it doesn't call it ? the html for the checkboxes is further below also any...
  12. Richey

    update using for each next statement maybe ?

    thanks everyone I eventually have got it working using my code below Dim dbs As DAO.Database Set dbs = CurrentDb Dim stra, strupdatea As String Dim rst As DAO.Recordset stra = "SELECT intStratID, Min(ReviewDate) AS NextDate FROM dbo_tblStratReviews where ReviewDate >= date() GROUP BY...
  13. Richey

    update using for each next statement maybe ?

    Hi I've got a main table called tblRiskMain with an identity column called intRiskIDcalled and a column called NextReview (type smalldatetime) sample data ----------- 10, 01/01/2004 11, 01/01/2000 i have another table called tblStratReviews with columns intStratID, intRiskID, ReviewDate...
  14. Richey

    Select case using loop

    brilliant thanks !
  15. Richey

    Select case using loop

    ok thanks so lets assume it returns 10, then how do i add 10 case statements programatically ? thanks
  16. Richey

    Select case using loop

    Hi i've got the following code. I won't know how mnay items will be in List0, because it gets added to frequently. therefore i can never say how many cases I require (in the example below i have used 5) but it might be 12, it might be 14 etc. How can i match the number of case statements to the...
  17. Richey

    apply conditional formatting between 2 subreports

    yeah I've given up with conditional formatting....is there any way you can say to move next on the OnFormat detail event procedure, as in move to the next record ? thanks
  18. Richey

    apply conditional formatting between 2 subreports

    Hi I have a report rptFormA containing 2 subreports [dbo_tblStratRecords subreport] which has a field intNewID (primary key) and [dbo_tblKeyComponents subreport] which also has a field intNewID the [dbo_tblStratRecords subreport] may have 2 records with the intNewID's being 1 and 10 for...
  19. Richey

    use of NOT IN in select statement

    thanks aa it was the join - I simply removed it ! thanks again
  20. Richey

    use of NOT IN in select statement

    has anybody got any ideas about this ? I'm wondering if its a union that is needed in there somewhere ? thanks

Part and Inventory Search

Back
Top