Recent content by Richey

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...

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...

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...

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...

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...

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

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...

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

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...

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...

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...

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...

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...

brilliant thanks !

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