Search results for query: *

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

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

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

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

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

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

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

Hi I've got 2 tables Categories and tblID Categories contains 4 columns (ID, BroadItem, Item, RelatedItem) Sample Data ----------- 142, Forestry, tree maintenance, N/A 143, Forestry, logging, N/A 144, Forestry, consulting, N/A 145, Forestry, Timber Mgt, N/A the user can select one or more of...

hi i'm using optgroup in my asp page like below. objRS2 is taken from a table called BusinessCategories with 4 columns ID, BroadItem, Item, RelatedItem. The values in the list should be drawn from column Item. Each item will have a broaditem associated so the table may look like this 1...

hi i want my users to enter a web address as www.bbc.co.uk for example not http://www.bbc.co.uk if they do enter http:// at the start how can i best remove it before sending the result to the database ? thanks I thought of doing something like left(str, 7) if str = "http://" then a =...

Hi once my users have submitted an online form i let them edit their own details by logging in with a username/password. the details are read from a recordset, the user can change any details and click update form, which checks the validation, if successful updates the record else highlights to...

Hi I've got this bit of code which basically checks that the username a customer has chosen hasn't been already used. If it has then it says either try again or it sugessts one by concatenating their effort with the @@identity. I'm missing a loop or something though because when it gets to the...

Hi I setup a Maintenance Plan 6 months ago for optimization, data integrity and complete backup - it has worked fine until this morning ? the optimzation is failing on two database called cccinternet and training48.............this is the error message - error number 1934 for cccinternet...

Hi I have the code below, which launches a Word document. There are bookmarks set-up in this Word document, that I'd like to link to ,somehow, within the code below any ideas much appreciated Thanks Richey If IsNull(Me.List84) Then Msgbox "Please select a Section&quot...

I have 5 tick-boxes on a form, 2002/03, 2003/04, 2004/05, 2005/06 and 2006/07. The user can select one or more of these tick-boxes - they then click 'generate funding matrix' there is a table called tblSECT_funding If the user, for example, selects 2002/03 and 2005/06 I'd like the table to be...

I have a form which is based on a table, where the data types are text - in most cases the entries in the text fields will be numbers. I want the continious form to do a sum, in the form footer, on the text boxes. Obviously with them being data type text, it won't work. Is there a way round...

Hi I have a form, frmreports, with an unbound combo box, cmb_sort, containing total_score and category. If the user chooses total_score and clicks open report it launches a report, rptstrats, with a sub-report called tblstratssubreport. I want to apply sorting within the sub-report...

Hi I have a form whereby the user choose either Percent, Yes/No or Currency. They then open a pop-up form which has text-boxes bound to another table. I'd like to be able to say, dependent on what the user has chosen on the other form, affect ALL text-boxes to Percent, Yes/No or Currency for...

Hi I need to execute a delete statement, using multiple criteria i.e. str1 = "delete * from tblinteractions where [ID] =" & Me!ID db.execute(str) this works fine but I now need to say str1_new = "delete * from tblinteractions where [ID] =" & Me!ID And " [atoz] =...