Search results for query: *

Hi I have the following stored procedure which runs overnight. runs ok................but for both lines that hardcodes a filename I'd like to be able to use a variable for the bak name - the backup runs every morning so this morning's was 200512190200, tomorrows will be 200512200200 etc etc...

Hi I have a website running through IIS, for which I've set it in its own application pool. The website is an asp front-end with a sql back-end - there will be a guaranteed 20 or so people on it all day (7/8 hours) and anything up to 30/40 people working on it sometime throughout the day. On 2...

i'd like to have a stored procedure which either performs a bulk insert, bulk update or does nothing from a table on one server (CTS_CUSTOMERS - ServerA) to another on a different server (CTS_CUSTOMERS - ServerB) firstly if the record does not exist on serverB then insert it from serverA...

Hi I have a combo box on an asp form, which reads values from a sql database using a sub and a function in an include file as below Sub getPestTypes(oRS) On Error Resume Next if Err.number=0 then set oRS = ExecQueryRS_X("CONN_Z","SELECT compTypeID, varIndicator,varCompType, varCost_Dom...

Hi We have an application on one server (server A), which in its global.asa file specifies a connection to another sql server using Application("Conn_Z") = "driver={SQL Server};server=Istanbul;database=Envsystem;uid=???;pwd=???" I use abit of custom code as follows ExecQuery_X...

Hi didn't know what forum to post in, but there is some kind of xml link !?! if you were applying for a job and you wanted the person to have .net knowledge (especially asp.net) and then knowledge of biztalk ,web services, biztalk alternatives etc - is there a generic term to give all those...

hi i have written an insert statement which then reults the id using Set MyRS = Server.CreateObject("ADODB.Recordset") MyRS.Open SQLstmt, dbconnSQL SQLstmt = "SELECT @@Identity FROM dbo.user_request" Set myRS = dbconnSQL.Execute(SQLstmt) varNewID = myRS(0) how can i put the value in an...

Hi I've installed aspemail onto server 'serverb' - looks ok - the email agent is working ok, so the install looks ok. i've got an asp file which part of the code is. <!-- #include file="CCCu_SENDASPEMAIL.asp" --> send_email_asp request("txtEmailAddress"),"Chester City Council Web...

Hi I have an asp form, with a select box (selService) and a text box (txtWebLink). the select box holds a series of values, that dependent on the value selected I want the text box to updated based on the select value. I have a look-up table (CCCu_ServiceWebLinks) with 2 columns...

Hi I have an asp with a drop-down box which onblur sets the values of other fields using a javascript function called selServiceChange. I have another lookup table called ServiceWebLinks which has 2 columns SERVICEID and WebLink. on my asp i have a text box called txtWebLink which the value of...

Hi is it possible to have an item from a combo box filter the values in a multiple select list box ? my form is a submission form, so the submit already validates the form using vbscript for errors and if successful completes a sql insert my form must be fully accessible to all users (those...

Hi I've got a online form with a select list as follows (there is also an option for some keywords entered as free text which i'll explain later) b = b & " <div>" b = b & "<label for=""cat"">Business Type<br />(Use Ctrl key for multiple selection(s))</label>" b = b & "<SELECT class=""a""...

Hi I'm trying to build up a select statement in asp using the IN operator. I've got SchText = request.form("cat") if len(SchText)=0 then SchText = "'" & SchText & "' " Flag = Flag + 1 end if and then the select statement (shown further below) which doesn't work because it may say Select *...

Hi I've been playing around with my online form using css. I found a site http://www.accessify.com/tools-and-wizards/accessible-form-builder.asp?type=css which gave me back this css (string because it is 3rd party cms) and below that the html. in their preview window it looks great, but if i...

one of my pages within my website is getting a poor rating for speed/response. The asp i have written uses arrays and GetRows() so i think that is pretty efficient. the stored procedure I use is shown below. Does it look ok ? or could i make it more efficent re. speed ? any ideas appreciated...

getting this error on my sitemap page (been working fine for 1½ years !) its a 3rd party software cms but the error point to line 77 of sitemap.asp which is shown further below (sorry for the length) but line 77 points to lp = smma(1,i) now the sp mnuTreeAll i have put into SQL QA and it runs...

Hi I've got my asp page setup, if the user clicks submits (or refreshes the page) then the input type="text" retains the value on screen as so for example <INPUT id="Postcode" name="Postcode" size="20" value=" & Postcode & " /> can't do the same for textareas and option groups though ? tried...

Hi I'm new to css and I'm trying to write a tabel-less form which has sort of worked but the layout isn't right. we have a seperate file for css files and for asp files. below is part of the asp file and further below some of the styles from the css file I have been using. Problem is the...

I've been trying to rewrite my code to validate within firefox. I've gone through loads of pages and done ok - replace @ with @amp; and close <BR> <HR> <input> as <input /> for example I'm still getting some errors but can't see what its getting at now...............any help appreciated thanks...

putting my web pages through firefox trying to improve accessibility it recommends where you have a href and a an & you replace the & with &amp; - great works a treat ! it also prompted me with the same resolution for POST= (like below) except that doesn't work ? any ideas ? thanks tony...